[Home] [Help]
11: (element_link_id number
12: ,element_type_id number
13: ,effective_start_date date
14: ,effective_end_date date
15: ,link_to_all_payrolls_flag pay_element_links_f.link_to_all_payrolls_flag%type
16: ,payroll_id number
17: ,job_id number
18: ,grade_id number
19: ,position_id number
19: ,position_id number
20: ,organization_id number
21: ,location_id number
22: ,pay_basis_id number
23: ,employment_category pay_element_links_f.employment_category%type
24: ,people_group_id number
25: );
26: --
27: type t_element_link_tab is table of t_element_link_rec
238: -- Update the values that were bypassed in creating the link.
239: --
240: if (l_bat_rec.comment_id is not null) then
241: --
242: update pay_element_links_f
243: set comment_id = l_bat_rec.comment_id
244: where
245: element_link_id = l_link_rec.element_link_id
246: and effective_start_date = l_link_rec.effective_start_date
536: --
537: ,bos.payroll_action_id
538: ,bos.object_status
539: from
540: pay_element_links_f pel
541: ,pay_batch_object_status bos
542: where
543: p_phase = 1
544: and ( pel.element_link_id = p_elelink_id
597: ,bos.payroll_action_id
598: ,bos.object_status
599: from
600: pay_batch_object_status bos
601: ,pay_element_links_f pel
602: where
603: bos.payroll_action_id = p_pact_id
604: and bos.object_type = 'EL'
605: and pel.element_link_id = bos.object_id
754: --
755: -- Failed to lock element link.
756: --
757: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
758: hr_utility.set_message_token('TABLE_NAME', 'pay_element_links_f');
759: hr_utility.raise_error;
760: end init_links;
761: --
762: -- ---------------------------------------------------------------------------