eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.HR_EMPLOYEE_APPLICANT_API dependencies on PER_PAY_PROPOSALS

Line 913: l_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE;

909: ---- Fix For Bug: 12612530 Starts ----
910: PROCEDURE update_salary_proposal(p_assignment_id number
911: , p_effective_date date) IS
912:
913: l_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE;
914: l_pyp_object_version_number per_pay_proposals.object_version_number%TYPE;
915: l_change_date per_pay_proposals.change_date%TYPE;
916: l_proposed_salary per_pay_proposals.PROPOSED_SALARY_N%TYPE;
917: l_approved_flag varchar2(1) := 'N'; ---- Changed from Y to N for ER: 6136609

Line 914: l_pyp_object_version_number per_pay_proposals.object_version_number%TYPE;

910: PROCEDURE update_salary_proposal(p_assignment_id number
911: , p_effective_date date) IS
912:
913: l_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE;
914: l_pyp_object_version_number per_pay_proposals.object_version_number%TYPE;
915: l_change_date per_pay_proposals.change_date%TYPE;
916: l_proposed_salary per_pay_proposals.PROPOSED_SALARY_N%TYPE;
917: l_approved_flag varchar2(1) := 'N'; ---- Changed from Y to N for ER: 6136609
918: l_inv_next_sal_date_warning boolean;

Line 915: l_change_date per_pay_proposals.change_date%TYPE;

911: , p_effective_date date) IS
912:
913: l_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE;
914: l_pyp_object_version_number per_pay_proposals.object_version_number%TYPE;
915: l_change_date per_pay_proposals.change_date%TYPE;
916: l_proposed_salary per_pay_proposals.PROPOSED_SALARY_N%TYPE;
917: l_approved_flag varchar2(1) := 'N'; ---- Changed from Y to N for ER: 6136609
918: l_inv_next_sal_date_warning boolean;
919: l_proposed_salary_warning boolean;

Line 916: l_proposed_salary per_pay_proposals.PROPOSED_SALARY_N%TYPE;

912:
913: l_pay_proposal_id per_pay_proposals.pay_proposal_id%TYPE;
914: l_pyp_object_version_number per_pay_proposals.object_version_number%TYPE;
915: l_change_date per_pay_proposals.change_date%TYPE;
916: l_proposed_salary per_pay_proposals.PROPOSED_SALARY_N%TYPE;
917: l_approved_flag varchar2(1) := 'N'; ---- Changed from Y to N for ER: 6136609
918: l_inv_next_sal_date_warning boolean;
919: l_proposed_salary_warning boolean;
920: l_approved_warning boolean;

Line 932: from per_pay_proposals

928:
929: cursor csr_payproposal is
930: select pay_proposal_id, object_version_number, change_date
931: ,PROPOSED_SALARY_N
932: from per_pay_proposals
933: where assignment_id = p_assignment_id
934: order by change_date DESC;
935: BEGIN
936: open csr_payproposal;

Line 1943: from per_pay_proposals

1939: --
1940: -- Bug 4644830 Start
1941: cursor get_pay_proposal(ass_id per_all_assignments_f.assignment_id%type) is
1942: select pay_proposal_id,object_version_number,proposed_salary_n, change_date, proposal_reason -- Added For Bug 5987409 --
1943: from per_pay_proposals
1944: where assignment_id=ass_id
1945: and approved = 'N'
1946: order by change_date desc;
1947: l_pay_pspl_id per_pay_proposals.pay_proposal_id%TYPE;

Line 1947: l_pay_pspl_id per_pay_proposals.pay_proposal_id%TYPE;

1943: from per_pay_proposals
1944: where assignment_id=ass_id
1945: and approved = 'N'
1946: order by change_date desc;
1947: l_pay_pspl_id per_pay_proposals.pay_proposal_id%TYPE;
1948: l_pay_obj_number per_pay_proposals.object_version_number%TYPE;
1949: l_proposed_sal_n per_pay_proposals.proposed_salary_n%TYPE;
1950: l_dummy_change_date per_pay_proposals.change_date%TYPE;
1951: l_inv_next_sal_date_warning boolean := false;

Line 1948: l_pay_obj_number per_pay_proposals.object_version_number%TYPE;

1944: where assignment_id=ass_id
1945: and approved = 'N'
1946: order by change_date desc;
1947: l_pay_pspl_id per_pay_proposals.pay_proposal_id%TYPE;
1948: l_pay_obj_number per_pay_proposals.object_version_number%TYPE;
1949: l_proposed_sal_n per_pay_proposals.proposed_salary_n%TYPE;
1950: l_dummy_change_date per_pay_proposals.change_date%TYPE;
1951: l_inv_next_sal_date_warning boolean := false;
1952: l_proposed_salary_warning boolean := false;

Line 1949: l_proposed_sal_n per_pay_proposals.proposed_salary_n%TYPE;

1945: and approved = 'N'
1946: order by change_date desc;
1947: l_pay_pspl_id per_pay_proposals.pay_proposal_id%TYPE;
1948: l_pay_obj_number per_pay_proposals.object_version_number%TYPE;
1949: l_proposed_sal_n per_pay_proposals.proposed_salary_n%TYPE;
1950: l_dummy_change_date per_pay_proposals.change_date%TYPE;
1951: l_inv_next_sal_date_warning boolean := false;
1952: l_proposed_salary_warning boolean := false;
1953: l_approved_warning boolean := false;

Line 1950: l_dummy_change_date per_pay_proposals.change_date%TYPE;

1946: order by change_date desc;
1947: l_pay_pspl_id per_pay_proposals.pay_proposal_id%TYPE;
1948: l_pay_obj_number per_pay_proposals.object_version_number%TYPE;
1949: l_proposed_sal_n per_pay_proposals.proposed_salary_n%TYPE;
1950: l_dummy_change_date per_pay_proposals.change_date%TYPE;
1951: l_inv_next_sal_date_warning boolean := false;
1952: l_proposed_salary_warning boolean := false;
1953: l_approved_warning boolean := false;
1954: l_payroll_warning boolean := false;

Line 1955: l_proposal_reason per_pay_proposals.proposal_reason%TYPE; -- Added For Bug 5987409 --

1951: l_inv_next_sal_date_warning boolean := false;
1952: l_proposed_salary_warning boolean := false;
1953: l_approved_warning boolean := false;
1954: l_payroll_warning boolean := false;
1955: l_proposal_reason per_pay_proposals.proposal_reason%TYPE; -- Added For Bug 5987409 --
1956: -- Bug 4644830 End
1957: --
1958: -- start of bug 4641965
1959: l_pspl_asg_id per_all_assignments_f.assignment_id%type;

Line 1962: from per_pay_proposals

1958: -- start of bug 4641965
1959: l_pspl_asg_id per_all_assignments_f.assignment_id%type;
1960: cursor get_primary_proposal(ass_id per_all_assignments_f.assignment_id%type) is
1961: select pay_proposal_id,object_version_number
1962: from per_pay_proposals
1963: where assignment_id=ass_id
1964: and APPROVED='N';
1965: -- end 4641965
1966:

Line 1977: from per_pay_proposals

1973: l_bg_id number;
1974:
1975: cursor get_primary_approved_proposal(ass_id per_all_assignments_f.assignment_id%type) is
1976: select pay_proposal_id
1977: from per_pay_proposals
1978: where assignment_id=ass_id
1979: and APPROVED='Y';
1980:
1981: --Bug 4959033 ends here

Line 4424: from per_pay_proposals

4420: --
4421: -- Bug 4644830 Start
4422: cursor get_pay_proposal(ass_id per_all_assignments_f.assignment_id%type) is
4423: select pay_proposal_id,object_version_number,proposed_salary_n, change_date, proposal_reason -- Added For Bug 5987409 --
4424: from per_pay_proposals
4425: where assignment_id=ass_id
4426: and approved = 'N'
4427: order by change_date desc;
4428: l_pay_pspl_id per_pay_proposals.pay_proposal_id%TYPE;

Line 4428: l_pay_pspl_id per_pay_proposals.pay_proposal_id%TYPE;

4424: from per_pay_proposals
4425: where assignment_id=ass_id
4426: and approved = 'N'
4427: order by change_date desc;
4428: l_pay_pspl_id per_pay_proposals.pay_proposal_id%TYPE;
4429: l_pay_obj_number per_pay_proposals.object_version_number%TYPE;
4430: l_proposed_sal_n per_pay_proposals.proposed_salary_n%TYPE;
4431: l_dummy_change_date per_pay_proposals.change_date%TYPE;
4432: l_inv_next_sal_date_warning boolean := false;

Line 4429: l_pay_obj_number per_pay_proposals.object_version_number%TYPE;

4425: where assignment_id=ass_id
4426: and approved = 'N'
4427: order by change_date desc;
4428: l_pay_pspl_id per_pay_proposals.pay_proposal_id%TYPE;
4429: l_pay_obj_number per_pay_proposals.object_version_number%TYPE;
4430: l_proposed_sal_n per_pay_proposals.proposed_salary_n%TYPE;
4431: l_dummy_change_date per_pay_proposals.change_date%TYPE;
4432: l_inv_next_sal_date_warning boolean := false;
4433: l_proposed_salary_warning boolean := false;

Line 4430: l_proposed_sal_n per_pay_proposals.proposed_salary_n%TYPE;

4426: and approved = 'N'
4427: order by change_date desc;
4428: l_pay_pspl_id per_pay_proposals.pay_proposal_id%TYPE;
4429: l_pay_obj_number per_pay_proposals.object_version_number%TYPE;
4430: l_proposed_sal_n per_pay_proposals.proposed_salary_n%TYPE;
4431: l_dummy_change_date per_pay_proposals.change_date%TYPE;
4432: l_inv_next_sal_date_warning boolean := false;
4433: l_proposed_salary_warning boolean := false;
4434: l_approved_warning boolean := false;

Line 4431: l_dummy_change_date per_pay_proposals.change_date%TYPE;

4427: order by change_date desc;
4428: l_pay_pspl_id per_pay_proposals.pay_proposal_id%TYPE;
4429: l_pay_obj_number per_pay_proposals.object_version_number%TYPE;
4430: l_proposed_sal_n per_pay_proposals.proposed_salary_n%TYPE;
4431: l_dummy_change_date per_pay_proposals.change_date%TYPE;
4432: l_inv_next_sal_date_warning boolean := false;
4433: l_proposed_salary_warning boolean := false;
4434: l_approved_warning boolean := false;
4435: l_payroll_warning boolean := false;

Line 4436: l_proposal_reason per_pay_proposals.proposal_reason%TYPE; -- Added For Bug 5987409 --

4432: l_inv_next_sal_date_warning boolean := false;
4433: l_proposed_salary_warning boolean := false;
4434: l_approved_warning boolean := false;
4435: l_payroll_warning boolean := false;
4436: l_proposal_reason per_pay_proposals.proposal_reason%TYPE; -- Added For Bug 5987409 --
4437: -- Bug 4644830 End
4438: --
4439: -- start of bug 4641965
4440: l_pspl_asg_id per_all_assignments_f.assignment_id%type;

Line 4443: from per_pay_proposals

4439: -- start of bug 4641965
4440: l_pspl_asg_id per_all_assignments_f.assignment_id%type;
4441: cursor get_primary_proposal(ass_id per_all_assignments_f.assignment_id%type) is
4442: select pay_proposal_id,object_version_number
4443: from per_pay_proposals
4444: where assignment_id=ass_id
4445: and APPROVED='N';
4446: -- end 4641965
4447:

Line 4458: from per_pay_proposals

4454: l_bg_id number;
4455:
4456: cursor get_primary_approved_proposal(ass_id per_all_assignments_f.assignment_id%type) is
4457: select pay_proposal_id
4458: from per_pay_proposals
4459: where assignment_id=ass_id
4460: and APPROVED='Y';
4461:
4462: --Bug 4959033 ends here

Line 5722: update per_pay_proposals set assignment_id = l_primary_asg_id

5718: open get_primary_proposal(l_primary_asg_id);
5719: fetch get_primary_proposal into l_pay_pspl_id,l_pay_obj_number;
5720: if get_primary_proposal%found then
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,

Line 6464: update per_pay_proposals set assignment_id = l_primary_asg_id

6460: open get_primary_proposal (l_primary_asg_id);
6461: fetch get_primary_proposal into l_pay_pspl_id,l_pay_obj_number;
6462: if get_primary_proposal%found then
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,