[Home] [Help]
83: p_chunk in number )
84: is
85: v_next_action_id pay_assignment_actions.assignment_action_id%type;
86: v_setup_action_id pay_payroll_actions.payroll_action_id%type;
87: v_assignment_id per_all_assignments_f.assignment_id%type;
88: --
89: cursor get_params(c_payroll_action_id in pay_payroll_actions.payroll_action_id%type) is
90: select pay_core_utils.get_parameter('SETUP_ACTION_ID',legislative_parameters)
91: from pay_payroll_actions
216: v_basis_start date;
217: v_basis_end date;
218: v_legal_entity_id number;
219: v_basis_year number;
220: v_asg_id per_all_assignments_f.assignment_id%type;
221: ----------------------------------------------------------------------------
222: -- Cursor to get the values of archive parameters
223: ----------------------------------------------------------------------------
224: cursor get_params(c_payroll_action_id in pay_payroll_actions.payroll_action_id%type) is
423: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
424: p_effective_date in date )
425: is
426: v_person_id per_all_people_f.person_id%type;
427: v_assignment_id per_all_assignments_f.assignment_id%type;
428: v_national_identifier varchar2(50);
429: v_archive_date pay_payroll_actions.effective_date%type;
430: l_person_id per_all_people_f.person_id%type;
431: l_archived_person_id binary_integer;
1771: v_moa_410_date ff_archive_items.value%type;
1772: v_moa_411_date ff_archive_items.value%type;
1773: v_moa_413_date ff_archive_items.value%type;
1774: l_terminated varchar2(1);
1775: l_prev_ass_id per_all_assignments_f.assignment_id%TYPE;
1776: l_new_ass_id per_all_assignments_f.assignment_id%TYPE;
1777: l_run_ass_action_id pay_assignment_actions.assignment_action_id%TYPE;
1778: l_term_max_assact_id pay_assignment_actions.assignment_action_id%TYPE;
1779: l_person_id per_all_people_f.person_id%type;
1772: v_moa_411_date ff_archive_items.value%type;
1773: v_moa_413_date ff_archive_items.value%type;
1774: l_terminated varchar2(1);
1775: l_prev_ass_id per_all_assignments_f.assignment_id%TYPE;
1776: l_new_ass_id per_all_assignments_f.assignment_id%TYPE;
1777: l_run_ass_action_id pay_assignment_actions.assignment_action_id%TYPE;
1778: l_term_max_assact_id pay_assignment_actions.assignment_action_id%TYPE;
1779: l_person_id per_all_people_f.person_id%type;
1780: v_person_id per_all_people_f.person_id%type;
1805: and to_date('31-12-'||c_basis_year,'DD-MM-YYYY');
1806: ---------------------------------------------------------------------------
1807: -- Bug# 2920732 - Modified the cursor to use secured view per_assignments_f
1808: ---------------------------------------------------------------------------
1809: cursor get_max_assactid( c_prev_ass_id per_all_assignments_f.assignment_id%TYPE ,
1810: c_basis_year varchar2,
1811: c_tax_unit_id pay_assignment_actions.tax_unit_id%type,
1812: c_business_group_id hr_organization_units.business_group_id%type )
1813: is
2506: v_er_bonus_date hr_organization_information.org_information8%type;
2507: -- Added for bug 5435088
2508: v_er_auth_person_email hr_organization_information.org_information5%type;
2509: v_er_division hr_organization_information.org_information8%type;
2510: l_pri_assignment_id per_all_assignments_f.assignment_id%type;
2511: l_id_assignment_id per_all_assignments_f.assignment_id%type;
2512:
2513:
2514: --
2507: -- Added for bug 5435088
2508: v_er_auth_person_email hr_organization_information.org_information5%type;
2509: v_er_division hr_organization_information.org_information8%type;
2510: l_pri_assignment_id per_all_assignments_f.assignment_id%type;
2511: l_id_assignment_id per_all_assignments_f.assignment_id%type;
2512:
2513:
2514: --
2515: cursor org_info
3167: -- _shares, remarks
3168: -- Bug 6349937, removed hr_lookups which is not being used
3169: ---------------------------------------------------------------------------
3170: cursor person_eits
3171: ( c_person_id per_all_assignments_f.assignment_id%type,
3172: c_basis_start date,
3173: c_basis_end date )
3174: is
3175: select indicators.pei_information1,
3254: ---------------------------------------------------------------------------
3255: procedure archive_assignment_eits
3256: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
3257: p_person_id in per_all_people_f.person_id%type,
3258: p_assignment_id in per_all_assignments_f.assignment_id%type,
3259: p_legal_entity_id in hr_organization_units.organization_id%type,
3260: p_basis_start in date,
3261: p_basis_end in date )
3262: is
3322: ---------------------------------------------------------------------------
3323: procedure archive_ass_bonus_date_eits
3324: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
3325: p_person_id in per_all_people_f.person_id%type,
3326: p_assignment_id in per_all_assignments_f.assignment_id%type,
3327: p_legal_entity_id in hr_organization_units.organization_id%type,
3328: p_basis_start in date,
3329: p_basis_end in date )
3330: is
3387: ---------------------------------------------------------------------------
3388: procedure archive_ass_payment_method
3389: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
3390: p_person_id in per_all_people_f.person_id%type,
3391: p_assignment_id in per_all_assignments_f.assignment_id%type,
3392: p_legal_entity_id in hr_organization_units.organization_id%type,
3393: p_basis_start in date,
3394: p_basis_end in date)
3395: is
3464: ---------------------------------------------------------------------------
3465: procedure archive_job_designation
3466: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
3467: p_person_id in per_all_people_f.person_id%type,
3468: p_assignment_id in per_all_assignments_f.assignment_id%type,
3469: p_legal_entity_id in hr_organization_units.organization_id%type,
3470: p_basis_start in date,
3471: p_basis_end in date,
3472: p_er_designation_type in hr_organization_information.org_information17%type,
3518: -- assignment
3519: ---------------------------------------------------------------------------
3520: cursor job
3521: ( c_person_id per_all_people_f.person_id%type,
3522: c_assignment_id per_all_assignments_f.assignment_id%type,
3523: c_legal_entity_id hr_organization_units.organization_id%type,
3524: c_basis_start date,
3525: c_basis_end date) is
3526:
3553: -- assignment
3554: ---------------------------------------------------------------------------
3555: cursor position
3556: ( c_person_id per_all_people_f.person_id%type,
3557: c_assignment_id per_all_assignments_f.assignment_id%type,
3558: c_legal_entity_id hr_organization_units.organization_id%type,
3559: c_basis_start date,
3560: c_basis_end date) is
3561:
3591: ---------------------------------------------------------------------------
3592:
3593: cursor position_seg
3594: ( c_person_id per_all_people_f.person_id%type,
3595: c_assignment_id per_all_assignments_f.assignment_id%type,
3596: c_basis_start date,
3597: c_basis_end date,
3598: c_legal_entity_id hr_organization_units.organization_id%type,
3599: c_er_position_seg_type hr_organization_information.org_information18
3680: ---------------------------------------------------------------------------
3681:
3682: cursor other
3683: ( c_person_id per_all_people_f.person_id%type,
3684: c_assignment_id per_all_assignments_f.assignment_id%type,
3685: c_legal_entity_id hr_organization_units.organization_id%type,
3686: c_basis_start date,
3687: c_basis_end date) is
3688: