113: TYPE g_element_entry_rec_type
114: IS RECORD (
115: business_group_id PER_BUSINESS_GROUPS.business_group_id%TYPE
116: ,payroll_id PER_ALL_ASSIGNMENTS_F.payroll_id%TYPE
117: ,element_entry_id PAY_ELEMENT_ENTRIES_F.element_entry_id%TYPE
118: ,creator_type PAY_ELEMENT_ENTRIES_F.creator_type%TYPE
119: );
120:
121: -- Global variable to set Generic extract date. It is used to allow the extract
114: IS RECORD (
115: business_group_id PER_BUSINESS_GROUPS.business_group_id%TYPE
116: ,payroll_id PER_ALL_ASSIGNMENTS_F.payroll_id%TYPE
117: ,element_entry_id PAY_ELEMENT_ENTRIES_F.element_entry_id%TYPE
118: ,creator_type PAY_ELEMENT_ENTRIES_F.creator_type%TYPE
119: );
120:
121: -- Global variable to set Generic extract date. It is used to allow the extract
122: -- on any given date instead of the sysdate.
127: g_element_entry_rec_var g_element_entry_rec_type;
128:
129: -- Global variables to indicate whether attribute1 has been set in the date
130: -- tracked table pay_element_types
131: g_ele_link_id pay_element_entries_f.element_link_id%TYPE;
132: g_ele_entry_id pay_element_entries_f.element_entry_id%TYPE;
133: g_ele_start_date pay_element_entries_f.effective_start_date%TYPE;
134: g_ele_person_id per_all_people_f.person_id%TYPE;
135:
128:
129: -- Global variables to indicate whether attribute1 has been set in the date
130: -- tracked table pay_element_types
131: g_ele_link_id pay_element_entries_f.element_link_id%TYPE;
132: g_ele_entry_id pay_element_entries_f.element_entry_id%TYPE;
133: g_ele_start_date pay_element_entries_f.effective_start_date%TYPE;
134: g_ele_person_id per_all_people_f.person_id%TYPE;
135:
136: -- Global variable g_personal_payment_method_id used to store the payment
129: -- Global variables to indicate whether attribute1 has been set in the date
130: -- tracked table pay_element_types
131: g_ele_link_id pay_element_entries_f.element_link_id%TYPE;
132: g_ele_entry_id pay_element_entries_f.element_entry_id%TYPE;
133: g_ele_start_date pay_element_entries_f.effective_start_date%TYPE;
134: g_ele_person_id per_all_people_f.person_id%TYPE;
135:
136: -- Global variable g_personal_payment_method_id used to store the payment
137: -- method of the personal_payment_method to be deleted.
153:
154: --Procedure set_ele_var_ids is used to set the globals g_elem_link_id, and
155: --g_ele_entry_id which are used by the trigger hr_adp_ele_entry_value_brd
156: PROCEDURE set_ele_var_ids(p_ele_link_id
157: pay_element_entries_f.element_link_id%TYPE,
158: p_ele_entry_id
159: pay_element_entries_f.element_entry_id%TYPE,
160: p_ele_start_date
161: pay_element_entries_f.effective_start_date%TYPE,
155: --g_ele_entry_id which are used by the trigger hr_adp_ele_entry_value_brd
156: PROCEDURE set_ele_var_ids(p_ele_link_id
157: pay_element_entries_f.element_link_id%TYPE,
158: p_ele_entry_id
159: pay_element_entries_f.element_entry_id%TYPE,
160: p_ele_start_date
161: pay_element_entries_f.effective_start_date%TYPE,
162: p_ele_person_id
163: per_all_people_f.person_id%TYPE);
157: pay_element_entries_f.element_link_id%TYPE,
158: p_ele_entry_id
159: pay_element_entries_f.element_entry_id%TYPE,
160: p_ele_start_date
161: pay_element_entries_f.effective_start_date%TYPE,
162: p_ele_person_id
163: per_all_people_f.person_id%TYPE);
164:
165: --