Have any question?
+2 0100 62 62 837
[email protected]
Register Login

Login with your site account

Lost your password?

Not a member yet? Register now

AppsLead | Learn Oracle From The LeadersAppsLead | Learn Oracle From The Leaders
  • Home
  • Courses
    • About Courses

      • Free Training
        • Oracle ebusiness suite Free
        • Oracle Fusion Free
      • Online Live Training
        • Oracle ebusiness suite
        • Oracle Fusion
        • Oracle Database
        • Java & Middleware
      • All Training Courses
      • Training Schedule
      • Register For Live Course
      • Join Our Team
      • Exam Request
  • Blog
    • Oracle ebusiness Suite
      • Oracle Financial
      • Oracle HCM
      • Oracle SCM
    • Oracle Fusion
      • Fusion Financial
      • Fusion HCM
    • Our Authors
    • Be an Author
  • Schedule
  • FAQs
  • About Us
    • About Us
    • Our Services
    • Our Authors
  • Contact Us
  • Home
  • Courses
    • About Courses

      • Free Training
        • Oracle ebusiness suite Free
        • Oracle Fusion Free
      • Online Live Training
        • Oracle ebusiness suite
        • Oracle Fusion
        • Oracle Database
        • Java & Middleware
      • All Training Courses
      • Training Schedule
      • Register For Live Course
      • Join Our Team
      • Exam Request
  • Blog
    • Oracle ebusiness Suite
      • Oracle Financial
      • Oracle HCM
      • Oracle SCM
    • Oracle Fusion
      • Fusion Financial
      • Fusion HCM
    • Our Authors
    • Be an Author
  • Schedule
  • FAQs
  • About Us
    • About Us
    • Our Services
    • Our Authors
  • Contact Us

Blog

  • Home
  • Blog
  • HRMS Delete Salary Proposal API

HRMS Delete Salary Proposal API

  • Posted by Sameh Bakkar
  • Categories Blog
  • Date March 20, 2011
  • Comments 0 comment
Hi guys today we will explain HRMS Delete Salary Proposal API
Declare
Error_msg   varchar2(4000);

l_business_group_id number := 81;
l_proposal_salry number;
l_approved char(1);
l_rowid varchar2(30);
--------------------
-- Out Parameters --
--------------------
l_p_salary_warning boolean;
--
cursor crs_batch_run_number is

select nvl(max(abm.batch_run_number),0) +1
from hr_api_batch_message_lines abm;

cursor crs_dc_proposal is
select
pay_proposal_id,
business_group_id,
object_version_number,
assignment_id
from hr.per_pay_proposals t
where t.assignment_id not in ( 3342 , 624);

begin

for pro_rcrd in crs_dc_proposal loop

begin

hr_maintain_proposal_api.delete_salary_proposal
(p_pay_proposal_id       => pro_rcrd.pay_proposal_id
,p_business_group_id     => pro_rcrd.business_group_id
,p_object_version_number => pro_rcrd.object_version_number
,p_salary_warning        => l_p_salary_warning);

Commit;
dbms_output.PUT_LINE ('Done');

exception when others then
Error_msg := SQLERRM;
dbms_output.PUT_LINE (Error_msg);
end;
end loop;
commit;
end Delete_Proposal;
/

Tag:API, Delete Salary Proposal API, HRMS

  • Share:
Admin bar avatar
Sameh Bakkar
Sameh Bakkar has over 15 years Oracle Applications implementation experience (EBS/Fusion) and he is an Oracle authorized trainer. He has in-depth technical and Functional knowledge of Oracle Applications and Oracle HCM Cloud. Sameh has excellent experience in Team management, Man Power and resource planning, and Pre-Sales management Process. Additionally he has also given Best Practices seminars on Oracle e-business suite and Oracle Fusion.

Previous post

HRMS Salary Proposal API
March 20, 2011

Next post

HRMS Previous Employer and Jobs API
20 March, 2011

You may also like

  • Entering Request for Quotations (RFQ)
    19 June, 2012
  • HRMS Assignment Migration – API
    9 March, 2011

Leave A Reply Cancel reply

Your email address will not be published. Required fields are marked *

Search

Categories

  • Blog
  • Oracle ebusiness Suite
  • Oracle Financial
  • Oracle HCM
  • Oracle SCM

Latest Courses

R12.x Oracle E-Business Suite Essentials for Implementers

R12.x Oracle E-Business Suite Essentials for Implementers

Free
R12.x Oracle HRMS Work Structures Fundamentals

R12.x Oracle HRMS Work Structures Fundamentals

Free
R12.x Oracle Payroll Fundamentals

R12.x Oracle Payroll Fundamentals

Free
AppsLead | Learn Oracle From The Leaders

+2 0100 62 62 837

[email protected]

Company

  • About Us
  • Blog
  • Contact Us

Links

  • Events

Copyright © 2017 AppsLead, All rights reserved. Developed by ECDSCS Co.

  • Privacy
  • Terms
  • Sitemap