APPS.PER_GB_TERMINATION dependencies on PER_PERIODS_OF_SERVICE

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

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

Line 26: from per_periods_of_service ppos

22: -- Gets Person_id for given period_of_service_id
23:
24: CURSOR c_get_person_id (c_period_of_service_id per_periods_of_service.period_of_service_id%Type) is
25: select ppos.person_id
26: from per_periods_of_service ppos
27: where period_of_service_id = c_period_of_service_id;
28:
29: PROCEDURE actual_termination(
30: p_period_of_service_id per_periods_of_service.period_of_service_id%TYPE,

Line 30: p_period_of_service_id per_periods_of_service.period_of_service_id%TYPE,

26: from per_periods_of_service ppos
27: where period_of_service_id = c_period_of_service_id;
28:
29: PROCEDURE actual_termination(
30: p_period_of_service_id per_periods_of_service.period_of_service_id%TYPE,
31: p_actual_termination_date per_periods_of_service.actual_termination_date%TYPE)
32: IS
33: BEGIN
34: -- doing no processing here

Line 31: p_actual_termination_date per_periods_of_service.actual_termination_date%TYPE)

27: where period_of_service_id = c_period_of_service_id;
28:
29: PROCEDURE actual_termination(
30: p_period_of_service_id per_periods_of_service.period_of_service_id%TYPE,
31: p_actual_termination_date per_periods_of_service.actual_termination_date%TYPE)
32: IS
33: BEGIN
34: -- doing no processing here
35: hr_utility.set_location('Entering per_gb_termination.actual_termination',10);

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

39: THEN
40: raise_application_error(-20001, SQLERRM(SQLCODE) );
41: END actual_termination;
42:
43: PROCEDURE Final_termination( p_period_of_service_id per_periods_of_service.period_of_service_id%TYPE
44: ,p_final_process_date Date)
45: IS
46: BEGIN
47: -- doing no processing here

Line 57: p_period_of_service_id per_periods_of_service.period_of_service_id%TYPE,

53: raise_application_error(-20001, SQLERRM(SQLCODE) );
54: END Final_termination;
55:
56: PROCEDURE REVERSE(
57: p_period_of_service_id per_periods_of_service.period_of_service_id%TYPE,
58: p_actual_termination_date per_periods_of_service.actual_termination_date%TYPE,
59: p_leaving_reason per_periods_of_service.leaving_reason%TYPE)
60: IS
61: l_person_id per_periods_of_service.person_id%TYPE;

Line 58: p_actual_termination_date per_periods_of_service.actual_termination_date%TYPE,

54: END Final_termination;
55:
56: PROCEDURE REVERSE(
57: p_period_of_service_id per_periods_of_service.period_of_service_id%TYPE,
58: p_actual_termination_date per_periods_of_service.actual_termination_date%TYPE,
59: p_leaving_reason per_periods_of_service.leaving_reason%TYPE)
60: IS
61: l_person_id per_periods_of_service.person_id%TYPE;
62: l_date_of_birth DATE;

Line 59: p_leaving_reason per_periods_of_service.leaving_reason%TYPE)

55:
56: PROCEDURE REVERSE(
57: p_period_of_service_id per_periods_of_service.period_of_service_id%TYPE,
58: p_actual_termination_date per_periods_of_service.actual_termination_date%TYPE,
59: p_leaving_reason per_periods_of_service.leaving_reason%TYPE)
60: IS
61: l_person_id per_periods_of_service.person_id%TYPE;
62: l_date_of_birth DATE;
63: l_token varchar2(255);

Line 61: l_person_id per_periods_of_service.person_id%TYPE;

57: p_period_of_service_id per_periods_of_service.period_of_service_id%TYPE,
58: p_actual_termination_date per_periods_of_service.actual_termination_date%TYPE,
59: p_leaving_reason per_periods_of_service.leaving_reason%TYPE)
60: IS
61: l_person_id per_periods_of_service.person_id%TYPE;
62: l_date_of_birth DATE;
63: l_token varchar2(255);
64: l_count number;
65: