Sunday, October 5, 2008

R12 HRMS: Single record insertion for salary

DECLARE
l_element_entry_id NUMBER := NULL;
l_inv_next_sal_date_warning BOOLEAN;
l_proposed_salary_warning BOOLEAN;
l_approved_warning BOOLEAN;
l_payroll_warning BOOLEAN;
l_perf_object_version_number NUMBER;
l_pay_proposal_id NUMBER (15);
l_assignment_id NUMBER;
l_performance_review_id NUMBER := NULL;
BEGIN
hr_maintain_proposal_api.insert_salary_proposal
(p_pay_proposal_id => l_pay_proposal_id,
p_assignment_id => 27920,
p_business_group_id => 202,
p_change_date => TRUNC (SYSDATE),
p_comments => NULL,
p_next_sal_review_date => TRUNC (SYSDATE + 30),
p_proposal_reason => 'NEWH',
p_proposed_salary_n => 10000,
p_forced_ranking => NULL,
p_performance_review_id => l_performance_review_id,
p_attribute_category => NULL,
p_attribute1 => NULL,
p_attribute2 => NULL,
p_attribute3 => NULL,
p_attribute4 => NULL,
p_attribute5 => NULL,
p_attribute6 => NULL,
p_attribute7 => NULL,
p_attribute8 => NULL,
p_attribute9 => NULL,
p_attribute10 => NULL,
p_attribute11 => NULL,
p_attribute12 => NULL,
p_attribute13 => NULL,
p_attribute14 => NULL,
p_attribute15 => NULL,
p_attribute16 => NULL,
p_attribute17 => NULL,
p_attribute18 => NULL,
p_attribute19 => NULL,
p_attribute20 => NULL,
p_object_version_number => l_perf_object_version_number,
p_multiple_components => 'N',
p_approved => 'Y',
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
);
DBMS_OUTPUT.put_line (SQLERRM);
COMMIT;
END;

No comments: