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 Salary Proposal API

HRMS Salary Proposal API

  • Posted by Sameh Bakkar
  • Categories Blog
  • Date March 20, 2011
  • Comments 0 comment
Hi guys today we will explain HRMS Salary Proposal API
declare

l_element_entry_id            NUMBER;
l_inv_next_sal_date_warning   BOOLEAN;
l_proposed_salary_warning     BOOLEAN;
l_approved_warning            BOOLEAN;
l_payroll_warning             BOOLEAN;
l_pay_proposal_id             NUMBER;
v_batch_run_number            NUMBER;
l_object_version_number       NUMBER;
v_err_msg                     VARCHAR2 (400);
l_approved                    VARCHAR2 (100);
v_dummy_line_id               NUMBER;
v_asg_id                      NUMBER;
l_business_group_id           NUMBER :=81;
v_emp_eff_start_date date ;
cursor c1 is
select * from  XX_PAYROLL
where person_id = 16438 ;
BEGIN

for i in c1 loop
BEGIN

l_pay_proposal_id := NULL;
l_element_entry_id := NULL;

--v_emp_eff_start_date := to_date('20-01-2010','DD-MM-RRRR');

hr_maintain_proposal_api.insert_salary_proposal
(p_pay_proposal_id                => l_pay_proposal_id,
p_assignment_id                  => i.ass_id,
p_business_group_id              => l_business_group_id,
p_change_date                    => i.eff_date,
p_proposed_salary_n              => i.salary,
p_performance_review_id          => NULL,
p_attribute_category             => NULL,
p_object_version_number          => l_object_version_number,
p_multiple_components            => 'N',          -- 918219
p_approved                       => 'Y',          -- 918219
p_validate                       => FALSE,
p_element_entry_id               => l_element_entry_id,
p_inv_next_sal_date_warning      => l_inv_next_sal_date_warning,
p_proposed_salary_warning        => l_proposed_salary_warning,
p_approved_warning               => l_approved_warning,
p_payroll_warning                => l_payroll_warning
);
COMMIT;

UPDATE xx_payroll
SET valid_flag = 'Done',
error_msg = NULL,
element_entry_id = l_element_entry_id
WHERE person_id  = i.person_id;

Commit;

EXCEPTION
WHEN OTHERS
THEN
v_err_msg := SQLERRM;

UPDATE xx_payroll
SET valid_flag = 'Error',
error_msg = v_err_msg
WHERE person_id  = i.person_id;

Commit;

END;

COMMIT;

end loop;

END;
/

Tag:API, HRMS, Salary Proposal API

  • 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 Previous Employer and Jobs API
March 20, 2011

Next post

HRMS Delete Salary Proposal 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