APPS.HR_PAY_IF_ELE_ENT_ASD dependencies on HR_PAY_INTERFACE_PKG

Line 15: pps.person_id = hr_pay_interface_pkg.g_ele_person_id;

11: SELECT pps.final_process_date fpd
12: FROM
13: per_periods_of_service pps
14: WHERE
15: pps.person_id = hr_pay_interface_pkg.g_ele_person_id;
16: --
17: l_event_id NUMBER;
18: l_business_group_id NUMBER;
19: l_legislation_code VARCHAR2(10);

Line 30: IF hr_pay_interface_pkg.g_element_entry_rec_var.business_group_id IS NULL

26: -- If the business group id is null, the Before Row trigger didn't fire
27: -- which means that no rows have been deleted in the database.
28: -- Hence the trigger doesn't need to fire.
29: --
30: IF hr_pay_interface_pkg.g_element_entry_rec_var.business_group_id IS NULL
31: THEN
32: return;
33: END IF;
34: --

Line 48: (l_fpd < hr_pay_interface_pkg.g_ele_start_date)) OR

44: --process date of the employee (if terminated). If it is, then the
45: --element should be deleted, therefore the trigger shouldn't fire,
46: --and should exit at this point.
47: IF ((l_fpd IS NOT NULL) AND
48: (l_fpd < hr_pay_interface_pkg.g_ele_start_date)) OR
49: (hr_pay_interface_pkg.g_ele_start_date IS NULL) THEN
50: hr_pay_interface_pkg.g_ele_start_date := NULL;
51: hr_pay_interface_pkg.g_ele_person_id := NULL;
52: return;

Line 49: (hr_pay_interface_pkg.g_ele_start_date IS NULL) THEN

45: --element should be deleted, therefore the trigger shouldn't fire,
46: --and should exit at this point.
47: IF ((l_fpd IS NOT NULL) AND
48: (l_fpd < hr_pay_interface_pkg.g_ele_start_date)) OR
49: (hr_pay_interface_pkg.g_ele_start_date IS NULL) THEN
50: hr_pay_interface_pkg.g_ele_start_date := NULL;
51: hr_pay_interface_pkg.g_ele_person_id := NULL;
52: return;
53: END IF;

Line 50: hr_pay_interface_pkg.g_ele_start_date := NULL;

46: --and should exit at this point.
47: IF ((l_fpd IS NOT NULL) AND
48: (l_fpd < hr_pay_interface_pkg.g_ele_start_date)) OR
49: (hr_pay_interface_pkg.g_ele_start_date IS NULL) THEN
50: hr_pay_interface_pkg.g_ele_start_date := NULL;
51: hr_pay_interface_pkg.g_ele_person_id := NULL;
52: return;
53: END IF;
54:

Line 51: hr_pay_interface_pkg.g_ele_person_id := NULL;

47: IF ((l_fpd IS NOT NULL) AND
48: (l_fpd < hr_pay_interface_pkg.g_ele_start_date)) OR
49: (hr_pay_interface_pkg.g_ele_start_date IS NULL) THEN
50: hr_pay_interface_pkg.g_ele_start_date := NULL;
51: hr_pay_interface_pkg.g_ele_person_id := NULL;
52: return;
53: END IF;
54:
55: /* Initialise the variables to ensure the triggers work */

Line 58: hr_pay_interface_pkg.g_element_entry_rec_var.business_group_id;

54:
55: /* Initialise the variables to ensure the triggers work */
56: --
57: l_business_group_id :=
58: hr_pay_interface_pkg.g_element_entry_rec_var.business_group_id;
59: l_payroll_id := hr_pay_interface_pkg.g_element_entry_rec_var.payroll_id;
60: l_legislation_code := pay_core_utils.get_legislation_code(
61: p_bg_id => l_business_group_id);
62: --

Line 59: l_payroll_id := hr_pay_interface_pkg.g_element_entry_rec_var.payroll_id;

55: /* Initialise the variables to ensure the triggers work */
56: --
57: l_business_group_id :=
58: hr_pay_interface_pkg.g_element_entry_rec_var.business_group_id;
59: l_payroll_id := hr_pay_interface_pkg.g_element_entry_rec_var.payroll_id;
60: l_legislation_code := pay_core_utils.get_legislation_code(
61: p_bg_id => l_business_group_id);
62: --
63: -- Check if the cursor is enabled

Line 78: hr_pay_interface_pkg.disable_ele_entry_delete;

74: RETURN;
75: END IF;
76: /* If the procedure hasn't exited at this point, run the trigger code*/
77: --
78: hr_pay_interface_pkg.disable_ele_entry_delete;
79: --
80: END IF;
81: END hr_pay_if_ele_ent_asd;