[Home] [Help]
41: --------------------------------------------------------------------------------+
42:
43: procedure archive_item
44: ( p_item in ff_user_entities.user_entity_name%type,
45: p_context1 in pay_assignment_actions.assignment_action_id%type,
46: p_context2 in pay_element_entries_f.element_entry_id%type,
47: p_value in out NOCOPY ff_archive_items.value%type) is
48: cursor get_user_entity_id(c_user_entity_name in varchar2)
49: is
124:
125: ------------------------------------------------------------------------------+
126: Procedure archive_corp_details
127: (p_business_group_id in hr_organization_units.business_group_id%type,
128: p_tax_unit_id in pay_assignment_Actions.tax_unit_id%type,
129: p_assignment_id in pay_assignment_actions.assignment_id%type,
130: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
131: p_assignment_Action_id in pay_assignment_actions.assignment_action_id%type,
132: p_date_earned in date ) is
125: ------------------------------------------------------------------------------+
126: Procedure archive_corp_details
127: (p_business_group_id in hr_organization_units.business_group_id%type,
128: p_tax_unit_id in pay_assignment_Actions.tax_unit_id%type,
129: p_assignment_id in pay_assignment_actions.assignment_id%type,
130: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
131: p_assignment_Action_id in pay_assignment_actions.assignment_action_id%type,
132: p_date_earned in date ) is
133:
127: (p_business_group_id in hr_organization_units.business_group_id%type,
128: p_tax_unit_id in pay_assignment_Actions.tax_unit_id%type,
129: p_assignment_id in pay_assignment_actions.assignment_id%type,
130: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
131: p_assignment_Action_id in pay_assignment_actions.assignment_action_id%type,
132: p_date_earned in date ) is
133:
134:
135: ------------------------------------------------------------------------------+
229:
230: -------------------------------------------------------------------------------+
231: Function archive_emp_details
232: (p_business_group_id in hr_organization_units.business_group_id%type,
233: p_tax_unit_id in pay_assignment_Actions.tax_unit_id%type,
234: p_assignment_id in pay_assignment_actions.assignment_id%type,
235: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
236: p_assignment_Action_id in pay_assignment_actions.assignment_action_id%type,
237: p_date_earned in date )
230: -------------------------------------------------------------------------------+
231: Function archive_emp_details
232: (p_business_group_id in hr_organization_units.business_group_id%type,
233: p_tax_unit_id in pay_assignment_Actions.tax_unit_id%type,
234: p_assignment_id in pay_assignment_actions.assignment_id%type,
235: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
236: p_assignment_Action_id in pay_assignment_actions.assignment_action_id%type,
237: p_date_earned in date )
238: return boolean
232: (p_business_group_id in hr_organization_units.business_group_id%type,
233: p_tax_unit_id in pay_assignment_Actions.tax_unit_id%type,
234: p_assignment_id in pay_assignment_actions.assignment_id%type,
235: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
236: p_assignment_Action_id in pay_assignment_actions.assignment_action_id%type,
237: p_date_earned in date )
238: return boolean
239: is
240:
258: ,ft.territory_code country_code
259: from pay_run_results prr1,
260: pay_run_results prr2,
261: pay_payroll_actions ppa,
262: pay_assignment_actions paa,
263: pay_element_types_f pet1,
264: pay_element_types_f pet2,
265: pay_input_values_f piv1,
266: pay_input_values_f piv2,
329: ,pay_kr_report_pkg.get_result_value(prr1.run_result_id, piv3.input_value_id) ns_prev_hire_date
330: ,pay_kr_report_pkg.get_result_value(prr1.run_result_id, piv4.input_value_id) ns_prev_leaving_date
331: from pay_run_results prr1,
332: pay_payroll_actions ppa,
333: pay_assignment_actions paa,
334: pay_element_types_f pet1,
335: pay_input_values_f piv1,
336: pay_input_values_f piv2,
337: pay_input_values_f piv3,
465: -------------------------------------------------------------------------------+
466:
467: Procedure archive_prev_emp_details
468: (p_business_group_id in hr_organization_units.business_group_id%type,
469: p_tax_unit_id in pay_assignment_Actions.tax_unit_id%type,
470: p_assignment_id in pay_assignment_actions.assignment_id%type,
471: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
472: p_assignment_Action_id in pay_assignment_actions.assignment_action_id%type,
473: p_date_earned in date ) is
466:
467: Procedure archive_prev_emp_details
468: (p_business_group_id in hr_organization_units.business_group_id%type,
469: p_tax_unit_id in pay_assignment_Actions.tax_unit_id%type,
470: p_assignment_id in pay_assignment_actions.assignment_id%type,
471: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
472: p_assignment_Action_id in pay_assignment_actions.assignment_action_id%type,
473: p_date_earned in date ) is
474:
468: (p_business_group_id in hr_organization_units.business_group_id%type,
469: p_tax_unit_id in pay_assignment_Actions.tax_unit_id%type,
470: p_assignment_id in pay_assignment_actions.assignment_id%type,
471: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
472: p_assignment_Action_id in pay_assignment_actions.assignment_action_id%type,
473: p_date_earned in date ) is
474:
475: cursor c_prev_emp_details(v_element_name varchar2,v_piv_name varchar2)
476: is
479: from pay_element_entries_f pee,
480: pay_element_links_f pel,
481: pay_element_types_f pet,
482: pay_payroll_actions ppa,
483: pay_assignment_actions paa,
484: pay_run_types_f prt,
485: pay_input_values_f piv1,
486: pay_element_entry_values_f peev1
487: where pet.element_name = v_element_name
732: -------------------------------------------------------------------------------+
733:
734: Procedure archive_xdbi
735: (p_business_group_id in hr_organization_units.business_group_id%type,
736: p_tax_unit_id in pay_assignment_Actions.tax_unit_id%type,
737: p_assignment_id in pay_assignment_actions.assignment_id%type,
738: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
739: p_assignment_Action_id in pay_assignment_actions.assignment_action_id%type,
740: p_date_earned in date ) is
733:
734: Procedure archive_xdbi
735: (p_business_group_id in hr_organization_units.business_group_id%type,
736: p_tax_unit_id in pay_assignment_Actions.tax_unit_id%type,
737: p_assignment_id in pay_assignment_actions.assignment_id%type,
738: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
739: p_assignment_Action_id in pay_assignment_actions.assignment_action_id%type,
740: p_date_earned in date ) is
741: begin
735: (p_business_group_id in hr_organization_units.business_group_id%type,
736: p_tax_unit_id in pay_assignment_Actions.tax_unit_id%type,
737: p_assignment_id in pay_assignment_actions.assignment_id%type,
738: p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
739: p_assignment_Action_id in pay_assignment_actions.assignment_action_id%type,
740: p_date_earned in date ) is
741: begin
742:
743: /* Corporate Dtails and Prev emp details are archived only if
797: paa.source_action_id,
798: paa.tax_unit_id
799: from pay_run_types_f prt,
800: pay_payroll_actions ppa,
801: pay_assignment_actions paa,
802: per_assignments_f pa,
803: pay_payroll_actions bppa
804: where bppa.payroll_action_id = p_payroll_action_id
805: and pa.business_group_id = bppa.business_group_id
821: and prt.run_type_name <> 'SEP_L'
822: and not exists(
823: select 'x'
824: from pay_payroll_actions appa,
825: pay_assignment_actions apaa,
826: pay_action_interlocks pai
827: where pai.locked_action_id = paa.assignment_action_id
828: and apaa.assignment_action_id = pai.locking_action_id
829: and appa.payroll_action_id = apaa.payroll_action_id
833: union all -- 4660184
834: select 'x'
835: from pay_payroll_actions ppa2,
836: pay_run_types_f prt2,
837: pay_assignment_actions paa2
838: where paa2.assignment_id = paa.assignment_id
839: and prt2.run_type_id = paa2.run_type_id
840: and prt2.run_type_id = ppa2.run_type_id
841: and prt2.run_type_name like 'SEP%'
863: exit when csr_process_assignment%notfound;
864: --
865: -- Insert new Assignment Action for Archive Process
866: --
867: select pay_assignment_actions_s.nextval
868: into l_locking_action_id
869: from dual;
870: --
871: if g_debug then
942: paa.assignment_action_id,
943: ppa.date_earned,
944: paa.tax_unit_id
945: from pay_payroll_actions ppa,
946: pay_assignment_actions paa,
947: pay_action_interlocks pai,
948: pay_assignment_actions xpaa
949: where xpaa.assignment_action_id = p_assignment_action_id
950: and pai.locking_action_id = xpaa.assignment_action_id
944: paa.tax_unit_id
945: from pay_payroll_actions ppa,
946: pay_assignment_actions paa,
947: pay_action_interlocks pai,
948: pay_assignment_actions xpaa
949: where xpaa.assignment_action_id = p_assignment_action_id
950: and pai.locking_action_id = xpaa.assignment_action_id
951: and paa.assignment_action_id = pai.locked_action_id
952: and paa.source_action_id is not null