[Home] [Help]
86: p_chunk in number )
87: is
88: v_next_action_id pay_assignment_actions.assignment_action_id%type;
89: v_setup_action_id pay_payroll_actions.payroll_action_id%type;
90: v_assignment_id per_all_assignments_f.assignment_id%type;
91: --
92: cursor get_params(c_payroll_action_id in pay_payroll_actions.payroll_action_id%type) is
93: select pay_core_utils.get_parameter('SETUP_ACTION_ID',legislative_parameters)
94: from pay_payroll_actions
219: v_basis_start date;
220: v_basis_end date;
221: v_legal_entity_id number;
222: v_basis_year number;
223: v_asg_id per_all_assignments_f.assignment_id%type;
224: ----------------------------------------------------------------------------
225: -- Cursor to get the values of archive parameters
226: ----------------------------------------------------------------------------
227: cursor get_params(c_payroll_action_id in pay_payroll_actions.payroll_action_id%type) is
426: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
427: p_effective_date in date )
428: is
429: v_person_id per_all_people_f.person_id%type;
430: v_assignment_id per_all_assignments_f.assignment_id%type;
431: v_national_identifier varchar2(50);
432: v_archive_date pay_payroll_actions.effective_date%type;
433: l_person_id per_all_people_f.person_id%type;
434: l_archived_person_id binary_integer;
1782: v_moa_410_date ff_archive_items.value%type;
1783: v_moa_411_date ff_archive_items.value%type;
1784: v_moa_413_date ff_archive_items.value%type;
1785: l_terminated varchar2(1);
1786: l_prev_ass_id per_all_assignments_f.assignment_id%TYPE;
1787: l_new_ass_id per_all_assignments_f.assignment_id%TYPE;
1788: l_run_ass_action_id pay_assignment_actions.assignment_action_id%TYPE;
1789: l_term_max_assact_id pay_assignment_actions.assignment_action_id%TYPE;
1790: l_person_id per_all_people_f.person_id%type;
1783: v_moa_411_date ff_archive_items.value%type;
1784: v_moa_413_date ff_archive_items.value%type;
1785: l_terminated varchar2(1);
1786: l_prev_ass_id per_all_assignments_f.assignment_id%TYPE;
1787: l_new_ass_id per_all_assignments_f.assignment_id%TYPE;
1788: l_run_ass_action_id pay_assignment_actions.assignment_action_id%TYPE;
1789: l_term_max_assact_id pay_assignment_actions.assignment_action_id%TYPE;
1790: l_person_id per_all_people_f.person_id%type;
1791: v_person_id per_all_people_f.person_id%type;
1816: and to_date('31-12-'||c_basis_year,'DD-MM-YYYY');
1817: ---------------------------------------------------------------------------
1818: -- Bug# 2920732 - Modified the cursor to use secured view per_assignments_f
1819: ---------------------------------------------------------------------------
1820: cursor get_max_assactid( c_prev_ass_id per_all_assignments_f.assignment_id%TYPE ,
1821: c_basis_year varchar2,
1822: c_tax_unit_id pay_assignment_actions.tax_unit_id%type,
1823: c_business_group_id hr_organization_units.business_group_id%type )
1824: is
2518: v_er_division hr_organization_information.org_information8%type;
2519: -- Added for bug 7415444
2520: v_er_a8b_incorp_date hr_organization_information.org_information9%type;
2521: v_shares_nsop_count number;
2522: l_pri_assignment_id per_all_assignments_f.assignment_id%type;
2523: l_id_assignment_id per_all_assignments_f.assignment_id%type;
2524:
2525:
2526: --
2519: -- Added for bug 7415444
2520: v_er_a8b_incorp_date hr_organization_information.org_information9%type;
2521: v_shares_nsop_count number;
2522: l_pri_assignment_id per_all_assignments_f.assignment_id%type;
2523: l_id_assignment_id per_all_assignments_f.assignment_id%type;
2524:
2525:
2526: --
2527: cursor org_info
3299: -- _shares, remarks
3300: -- Bug 6349937, removed hr_lookups which is not being used
3301: ---------------------------------------------------------------------------
3302: cursor person_eits
3303: ( c_person_id per_all_assignments_f.assignment_id%type,
3304: c_basis_start date,
3305: c_basis_end date )
3306: is
3307: select indicators.pei_information1,
3383: ---------------------------------------------------------------------------
3384: procedure archive_assignment_eits
3385: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
3386: p_person_id in per_all_people_f.person_id%type,
3387: p_assignment_id in per_all_assignments_f.assignment_id%type,
3388: p_legal_entity_id in hr_organization_units.organization_id%type,
3389: p_basis_start in date,
3390: p_basis_end in date )
3391: is
3451: ---------------------------------------------------------------------------
3452: procedure archive_ass_bonus_date_eits
3453: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
3454: p_person_id in per_all_people_f.person_id%type,
3455: p_assignment_id in per_all_assignments_f.assignment_id%type,
3456: p_legal_entity_id in hr_organization_units.organization_id%type,
3457: p_basis_start in date,
3458: p_basis_end in date )
3459: is
3516: ---------------------------------------------------------------------------
3517: procedure archive_ass_payment_method
3518: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
3519: p_person_id in per_all_people_f.person_id%type,
3520: p_assignment_id in per_all_assignments_f.assignment_id%type,
3521: p_legal_entity_id in hr_organization_units.organization_id%type,
3522: p_basis_start in date,
3523: p_basis_end in date)
3524: is
3594: ---------------------------------------------------------------------------
3595: procedure archive_job_designation
3596: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
3597: p_person_id in per_all_people_f.person_id%type,
3598: p_assignment_id in per_all_assignments_f.assignment_id%type,
3599: p_legal_entity_id in hr_organization_units.organization_id%type,
3600: p_basis_start in date,
3601: p_basis_end in date,
3602: p_er_designation_type in hr_organization_information.org_information17%type,
3648: -- assignment
3649: ---------------------------------------------------------------------------
3650: cursor job
3651: ( c_person_id per_all_people_f.person_id%type,
3652: c_assignment_id per_all_assignments_f.assignment_id%type,
3653: c_legal_entity_id hr_organization_units.organization_id%type,
3654: c_basis_start date,
3655: c_basis_end date) is
3656:
3683: -- assignment
3684: ---------------------------------------------------------------------------
3685: cursor position
3686: ( c_person_id per_all_people_f.person_id%type,
3687: c_assignment_id per_all_assignments_f.assignment_id%type,
3688: c_legal_entity_id hr_organization_units.organization_id%type,
3689: c_basis_start date,
3690: c_basis_end date) is
3691:
3721: ---------------------------------------------------------------------------
3722:
3723: cursor position_seg
3724: ( c_person_id per_all_people_f.person_id%type,
3725: c_assignment_id per_all_assignments_f.assignment_id%type,
3726: c_basis_start date,
3727: c_basis_end date,
3728: c_legal_entity_id hr_organization_units.organization_id%type,
3729: c_er_position_seg_type hr_organization_information.org_information18
3810: ---------------------------------------------------------------------------
3811:
3812: cursor other
3813: ( c_person_id per_all_people_f.person_id%type,
3814: c_assignment_id per_all_assignments_f.assignment_id%type,
3815: c_legal_entity_id hr_organization_units.organization_id%type,
3816: c_basis_start date,
3817: c_basis_end date) is
3818: