DBA Data[Home] [Help]

APPS.HR_EMPLOYEE_APPLICANT_API dependencies on HR_MAINTAIN_PROPOSAL_API

Line 951: hr_maintain_proposal_api.cre_or_upd_salary_proposal

947: end if;
948:
949: ---- Fix For ER: 6136609 Ends ----
950:
951: hr_maintain_proposal_api.cre_or_upd_salary_proposal
952: (p_pay_proposal_id => l_pay_proposal_id
953: ,p_object_version_number => l_pyp_object_version_number
954: ,p_change_date => p_effective_date
955: ,p_approved => l_approved_flag

Line 2529: hr_maintain_proposal_api.cre_or_upd_salary_proposal(

2525: OPEN get_pay_proposal(asg_rec.assignment_id);
2526: FETCH get_pay_proposal INTO l_pay_pspl_id,l_pay_obj_number,l_proposed_sal_n, l_dummy_change_date,l_proposal_reason; --Added Proposal_Reason for Bug # 5987409 --
2527: if get_pay_proposal%found then
2528: close get_pay_proposal;
2529: hr_maintain_proposal_api.cre_or_upd_salary_proposal(
2530: p_validate => false,
2531: p_pay_proposal_id => l_pay_pspl_id ,
2532: p_object_version_number => l_pay_obj_number,
2533: p_change_date => p_hire_date,

Line 2591: hr_maintain_proposal_api.cre_or_upd_salary_proposal(

2587: OPEN get_pay_proposal(asg_rec.assignment_id);
2588: FETCH get_pay_proposal INTO l_pay_pspl_id,l_pay_obj_number,l_proposed_sal_n, l_dummy_change_date,l_proposal_reason; --Added Proposal_Reason for Bug # 5987409 --
2589: if get_pay_proposal%found then
2590: close get_pay_proposal;
2591: hr_maintain_proposal_api.cre_or_upd_salary_proposal(
2592: p_validate => false,
2593: p_pay_proposal_id => l_pay_pspl_id ,
2594: p_object_version_number => l_pay_obj_number,
2595: p_change_date => p_hire_date,

Line 2975: hr_maintain_proposal_api.cre_or_upd_salary_proposal(

2971: open get_primary_proposal(l_primary_asg_id);
2972: fetch get_primary_proposal into l_pay_pspl_id,l_pay_obj_number;
2973: if get_primary_proposal%found then
2974: close get_primary_proposal;
2975: hr_maintain_proposal_api.cre_or_upd_salary_proposal(
2976: p_validate => false,
2977: p_pay_proposal_id => l_pay_pspl_id ,
2978: p_object_version_number => l_pay_obj_number,
2979: p_change_date => p_hire_date,

Line 2992: hr_maintain_proposal_api.cre_or_upd_salary_proposal(

2988: else
2989: close get_primary_proposal;
2990: l_pay_pspl_id:=null;
2991: l_pay_obj_number:=null;
2992: hr_maintain_proposal_api.cre_or_upd_salary_proposal(
2993: p_validate => false,
2994: p_pay_proposal_id => l_pay_pspl_id,
2995: p_assignment_id => l_primary_asg_id,
2996: p_object_version_number => l_pay_obj_number,

Line 3624: hr_maintain_proposal_api.cre_or_upd_salary_proposal(

3620: open get_primary_proposal (l_primary_asg_id);
3621: fetch get_primary_proposal into l_pay_pspl_id,l_pay_obj_number;
3622: if get_primary_proposal%found then
3623: close get_primary_proposal;
3624: hr_maintain_proposal_api.cre_or_upd_salary_proposal(
3625: p_validate => false,
3626: p_pay_proposal_id => l_pay_pspl_id ,
3627: p_object_version_number => l_pay_obj_number,
3628: p_change_date => p_hire_date,

Line 3641: hr_maintain_proposal_api.cre_or_upd_salary_proposal(

3637: else
3638: close get_primary_proposal;
3639: l_pay_pspl_id:=null;
3640: l_pay_obj_number:=null;
3641: hr_maintain_proposal_api.cre_or_upd_salary_proposal(
3642: p_validate => false,
3643: p_pay_proposal_id => l_pay_pspl_id,
3644: p_assignment_id => l_primary_asg_id,
3645: p_object_version_number => l_pay_obj_number,

Line 5155: hr_maintain_proposal_api.cre_or_upd_salary_proposal(

5151: OPEN get_pay_proposal(asg_rec.assignment_id);
5152: FETCH get_pay_proposal INTO l_pay_pspl_id,l_pay_obj_number,l_proposed_sal_n, l_dummy_change_date,l_proposal_reason; --Added Proposal_Reason for Bug # 5987409 --
5153: if get_pay_proposal%found then
5154: close get_pay_proposal;
5155: hr_maintain_proposal_api.cre_or_upd_salary_proposal(
5156: p_validate => false,
5157: p_pay_proposal_id => l_pay_pspl_id ,
5158: p_object_version_number => l_pay_obj_number,
5159: p_change_date => p_hire_date,

Line 5242: hr_maintain_proposal_api.cre_or_upd_salary_proposal(

5238: OPEN get_pay_proposal(asg_rec.assignment_id);
5239: FETCH get_pay_proposal INTO l_pay_pspl_id,l_pay_obj_number,l_proposed_sal_n, l_dummy_change_date,l_proposal_reason; --Added Proposal_Reason for Bug # 5987409 --
5240: if get_pay_proposal%found then
5241: close get_pay_proposal;
5242: hr_maintain_proposal_api.cre_or_upd_salary_proposal(
5243: p_validate => false,
5244: p_pay_proposal_id => l_pay_pspl_id ,
5245: p_object_version_number => l_pay_obj_number,
5246: p_change_date => p_hire_date,

Line 5725: hr_maintain_proposal_api.cre_or_upd_salary_proposal(

5721: close get_primary_proposal; */
5722: update per_pay_proposals set assignment_id = l_primary_asg_id
5723: where pay_proposal_id = l_pay_pspl_id;
5724: l_pay_obj_number := l_pay_obj_number +1;
5725: hr_maintain_proposal_api.cre_or_upd_salary_proposal(
5726: p_validate => false,
5727: p_pay_proposal_id => l_pay_pspl_id ,
5728: p_object_version_number => l_pay_obj_number,
5729: p_change_date => p_hire_date,

Line 5742: hr_maintain_proposal_api.cre_or_upd_salary_proposal(

5738: /* else
5739: close get_primary_proposal;
5740: l_pay_pspl_id:=null;
5741: l_pay_obj_number:=null;
5742: hr_maintain_proposal_api.cre_or_upd_salary_proposal(
5743: p_validate => false,
5744: p_pay_proposal_id => l_pay_pspl_id,
5745: p_assignment_id => l_primary_asg_id,
5746: p_object_version_number => l_pay_obj_number,

Line 6467: hr_maintain_proposal_api.cre_or_upd_salary_proposal(

6463: close get_primary_proposal; */
6464: update per_pay_proposals set assignment_id = l_primary_asg_id
6465: where pay_proposal_id = l_pay_pspl_id;
6466: l_pay_obj_number := l_pay_obj_number + 1;
6467: hr_maintain_proposal_api.cre_or_upd_salary_proposal(
6468: p_validate => false,
6469: p_pay_proposal_id => l_pay_pspl_id ,
6470: p_object_version_number => l_pay_obj_number,
6471: p_change_date => p_hire_date,

Line 6484: hr_maintain_proposal_api.cre_or_upd_salary_proposal(

6480: /* else
6481: close get_primary_proposal;
6482: l_pay_pspl_id:=null;
6483: l_pay_obj_number:=null;
6484: hr_maintain_proposal_api.cre_or_upd_salary_proposal(
6485: p_validate => false,
6486: p_pay_proposal_id => l_pay_pspl_id,
6487: p_assignment_id => l_primary_asg_id,
6488: p_object_version_number => l_pay_obj_number,