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.

APPS.PER_IE_TERMINATION dependencies on PER_PERIODS_OF_SERVICE

Line 23: CURSOR c_get_person_id (c_period_of_service_id per_periods_of_service.period_of_service_id%Type) is

19: -------------------------------------------------------------------------------
20: */
21: -- Gets Person_id for given period_of_service_id
22:
23: CURSOR c_get_person_id (c_period_of_service_id per_periods_of_service.period_of_service_id%Type) is
24: select ppos.person_id
25: from per_periods_of_service ppos
26: where period_of_service_id = c_period_of_service_id;
27:

Line 25: from per_periods_of_service ppos

21: -- Gets Person_id for given period_of_service_id
22:
23: CURSOR c_get_person_id (c_period_of_service_id per_periods_of_service.period_of_service_id%Type) is
24: select ppos.person_id
25: from per_periods_of_service ppos
26: where period_of_service_id = c_period_of_service_id;
27:
28: -- Gets assignment_id from per_all_assignments_f for above generated person_id
29: CURSOR c_get_asg_id (c_person_id per_periods_of_service.person_id%type,

Line 29: CURSOR c_get_asg_id (c_person_id per_periods_of_service.person_id%type,

25: from per_periods_of_service ppos
26: where period_of_service_id = c_period_of_service_id;
27:
28: -- Gets assignment_id from per_all_assignments_f for above generated person_id
29: CURSOR c_get_asg_id (c_person_id per_periods_of_service.person_id%type,
30: c_effective_date DATE ) is
31: select paaf.assignment_id
32: from per_all_assignments_f paaf
33: where paaf.person_id = c_person_id and

Line 38: p_period_of_service_id per_periods_of_service.period_of_service_id%TYPE,

34: c_effective_date between effective_start_date
35: and effective_end_date;
36:
37: PROCEDURE actual_termination(
38: p_period_of_service_id per_periods_of_service.period_of_service_id%TYPE,
39: p_actual_termination_date per_periods_of_service.actual_termination_date%TYPE)
40: IS
41: --end Local vriables---------
42: BEGIN

Line 39: p_actual_termination_date per_periods_of_service.actual_termination_date%TYPE)

35: and effective_end_date;
36:
37: PROCEDURE actual_termination(
38: p_period_of_service_id per_periods_of_service.period_of_service_id%TYPE,
39: p_actual_termination_date per_periods_of_service.actual_termination_date%TYPE)
40: IS
41: --end Local vriables---------
42: BEGIN
43: /*

Line 61: PROCEDURE Final_termination( p_period_of_service_id per_periods_of_service.period_of_service_id%TYPE

57: THEN
58: raise_application_error(-20001, SQLERRM(SQLCODE) );
59: END actual_termination;
60:
61: PROCEDURE Final_termination( p_period_of_service_id per_periods_of_service.period_of_service_id%TYPE
62: ,p_final_process_date Date)
63: IS
64: /*
65: cursor csr_asg_id is

Line 95: l_person_id per_periods_of_service.person_id%TYPE;

91: p_final_process_date BETWEEN effective_start_date
92: AND effective_end_date
93: ORDER BY effective_start_date;
94: --Local vriables-----
95: l_person_id per_periods_of_service.person_id%TYPE;
96: -- l_assignment_id per_all_assignments_f.assignment_id%TYPE;
97: l_paye_detail_id pay_ie_paye_details_f.paye_details_id%TYPE;
98: l_paye_start_date pay_ie_paye_details_f.effective_start_date%TYPE;
99: l_paye_end_date pay_ie_paye_details_f.effective_end_date%TYPE;

Line 175: p_period_of_service_id per_periods_of_service.period_of_service_id%TYPE,

171: raise_application_error(-20001, SQLERRM(SQLCODE) );
172: END Final_termination;
173:
174: PROCEDURE REVERSE(
175: p_period_of_service_id per_periods_of_service.period_of_service_id%TYPE,
176: p_actual_termination_date per_periods_of_service.actual_termination_date%TYPE,
177: p_leaving_reason per_periods_of_service.leaving_reason%TYPE)
178: IS
179: l_person_id per_periods_of_service.person_id%TYPE;

Line 176: p_actual_termination_date per_periods_of_service.actual_termination_date%TYPE,

172: END Final_termination;
173:
174: PROCEDURE REVERSE(
175: p_period_of_service_id per_periods_of_service.period_of_service_id%TYPE,
176: p_actual_termination_date per_periods_of_service.actual_termination_date%TYPE,
177: p_leaving_reason per_periods_of_service.leaving_reason%TYPE)
178: IS
179: l_person_id per_periods_of_service.person_id%TYPE;
180: -- l_assignment_id per_all_assignments_f.assignment_id%TYPE;

Line 177: p_leaving_reason per_periods_of_service.leaving_reason%TYPE)

173:
174: PROCEDURE REVERSE(
175: p_period_of_service_id per_periods_of_service.period_of_service_id%TYPE,
176: p_actual_termination_date per_periods_of_service.actual_termination_date%TYPE,
177: p_leaving_reason per_periods_of_service.leaving_reason%TYPE)
178: IS
179: l_person_id per_periods_of_service.person_id%TYPE;
180: -- l_assignment_id per_all_assignments_f.assignment_id%TYPE;
181: l_final_process_date DATE;

Line 179: l_person_id per_periods_of_service.person_id%TYPE;

175: p_period_of_service_id per_periods_of_service.period_of_service_id%TYPE,
176: p_actual_termination_date per_periods_of_service.actual_termination_date%TYPE,
177: p_leaving_reason per_periods_of_service.leaving_reason%TYPE)
178: IS
179: l_person_id per_periods_of_service.person_id%TYPE;
180: -- l_assignment_id per_all_assignments_f.assignment_id%TYPE;
181: l_final_process_date DATE;
182:
183: CURSOR csr_final_process_date(p_assignment_id Number)