DBA Data[Home] [Help]

APPS.PQP_NL_ABP_FUNCTIONS dependencies on PQP_NL_EXT_FUNCTIONS

Line 768: pqp_nl_ext_functions.create_org_pt_ins_chg_evt

764: END IF; */
765: --hr_utility.trace_off;
766: --call the procedure to fire insert of the change events in the
767: --ben_ext_chg_evt_log table
768: pqp_nl_ext_functions.create_org_pt_ins_chg_evt
769: (p_organization_id => p_organization_id
770: ,p_org_information1 => p_org_information1
771: ,p_org_information2 => p_org_information2
772: ,p_org_information3 => p_org_information3

Line 1474: pqp_nl_ext_functions.create_org_pt_upd_chg_evt

1470: END IF; */
1471: hr_utility.set_location('calling insert process',20);
1472: --call the procedure to fire insert of the change events in the
1473: --ben_ext_chg_evt_log table
1474: pqp_nl_ext_functions.create_org_pt_upd_chg_evt
1475: (p_organization_id => p_organization_id
1476: ,p_org_information1 => p_org_information1
1477: ,p_org_information2 => p_org_information2
1478: ,p_org_information3 => p_org_information3

Line 2316: pqp_nl_ext_functions.create_asg_info_ins_chg_evt

2312: l_abp_rep_date := greatest(l_abp_rep_date,fnd_date.canonical_to_date(p_aei_information1));
2313: END IF;
2314:
2315: --call the procedure to insert rows into the ben_ext_chg_evt_log table
2316: pqp_nl_ext_functions.create_asg_info_ins_chg_evt
2317: (p_assignment_id => p_assignment_id
2318: ,p_assignment_extra_info_id => p_assignment_extra_info_id
2319: ,p_aei_information1 => p_aei_information1
2320: ,p_aei_information2 => p_aei_information2

Line 2546: pqp_nl_ext_functions.create_sal_info_ins_chg_evt

2542: ,p_person_id => l_person_id
2543: ,p_reporting_date => l_abp_rep_date );
2544:
2545: --call the procedure to insert rows into the ben_ext_chg_evt_log table
2546: pqp_nl_ext_functions.create_sal_info_ins_chg_evt
2547: (p_assignment_id => p_assignment_id
2548: ,p_assignment_extra_info_id => p_assignment_extra_info_id
2549: ,p_aei_information1 => p_aei_information1
2550: ,p_aei_information2 => p_aei_information2

Line 2568: pqp_nl_ext_functions.create_si_info_ins_chg_evt

2564:
2565: --if the information context is Social Insurance Information, then call the
2566: --procedure to insert information into the ben log tables
2567: ELSIF p_information_type = 'NL_SII' THEN
2568: pqp_nl_ext_functions.create_si_info_ins_chg_evt
2569: (p_assignment_id => p_assignment_id
2570: ,p_aei_information1 => p_aei_information1
2571: ,p_aei_information2 => p_aei_information2
2572: ,p_aei_information3 => p_aei_information3

Line 3381: pqp_nl_ext_functions.create_asg_info_upd_chg_evt

3377: l_abp_rep_date := greatest(l_abp_rep_date,fnd_date.canonical_to_date(p_aei_information1));
3378: END IF;
3379:
3380: --Call the procedure to insert the rows in the ben_ext_chg_evt_log table
3381: pqp_nl_ext_functions.create_asg_info_upd_chg_evt
3382: (p_assignment_id => p_assignment_id
3383: ,p_assignment_extra_info_id => p_assignment_extra_info_id
3384: ,p_aei_information1 => p_aei_information1
3385: ,p_aei_information2 => p_aei_information2

Line 3646: pqp_nl_ext_functions.create_sal_info_upd_chg_evt

3642: ,p_person_id => l_person_id
3643: ,p_reporting_date => l_abp_rep_date );
3644:
3645: --Call the procedure to insert the rows in the ben_ext_chg_evt_log table
3646: pqp_nl_ext_functions.create_sal_info_upd_chg_evt
3647: (p_assignment_id => p_assignment_id
3648: ,p_assignment_extra_info_id => p_assignment_extra_info_id
3649: ,p_aei_information1 => p_aei_information1
3650: ,p_aei_information2 => p_aei_information2

Line 3674: pqp_nl_ext_functions.create_si_info_upd_chg_evt

3670:
3671: --if the information type is Social Insurance Information , then call the extract function
3672: --to insert rows as required into the ben log tables for logging the changes
3673: ELSIF p_information_type = 'NL_SII' THEN
3674: pqp_nl_ext_functions.create_si_info_upd_chg_evt
3675: (p_assignment_id => p_assignment_id
3676: ,p_aei_information1 => p_aei_information1
3677: ,p_aei_information2 => p_aei_information2
3678: ,p_aei_information3 => p_aei_information3

Line 5947: pqp_nl_ext_functions.create_org_pp_ins_chg_evt

5943: END IF;
5944:
5945: --call the procedure to fire insert of the change events in the
5946: --ben_ext_chg_evt_log table
5947: pqp_nl_ext_functions.create_org_pp_ins_chg_evt
5948: (p_organization_id => p_organization_id
5949: ,p_org_information1 => p_org_information1
5950: ,p_org_information2 => p_org_information2
5951: ,p_org_information3 => p_org_information3

Line 5989: pqp_nl_ext_functions.create_org_pp_upd_chg_evt

5985: FETCH c_get_eff_date INTO l_eff_date;
5986: CLOSE c_get_eff_date;
5987:
5988: --call the procedure to insert the change in the row into the ben_ext_chg_evt_log table
5989: pqp_nl_ext_functions.create_org_pp_upd_chg_evt
5990: (p_organization_id => p_organization_id
5991: ,p_org_information1 => p_org_information1
5992: ,p_org_information2 => p_org_information2
5993: ,p_org_information3 => p_org_information3