[Home] [Help]
5: --cursor to fetch the subcategory for the pension type
6: CURSOR c_get_subcat(c_pt IN varchar2) IS
7: SELECT distinct(pension_sub_category)
8: FROM pqp_pension_types_f
9: WHERE pension_type_id = fnd_number.canonical_to_number(c_pt);
10:
11: --cursor to check the enabled flag for the lookup code before logging changes
12: CURSOR chk_if_enabled(c_code IN VARCHAR2) IS
13: SELECT enabled_flag
356: ,p_chg_evt_cd => 'COAPP'
357: ,p_chg_eff_dt => p_effective_date
358: ,p_prmtr_01 => l_sub_cat -- Sub cat
359: ,p_prmtr_02 => p_aei_information3 --PT id
360: ,p_prmtr_03 => fnd_number.number_to_canonical(p_assignment_extra_info_id)
361: ,p_prmtr_04 => p_aei_information4 -- End Reason
362: ,p_prmtr_05 => NULL
363: ,p_prmtr_06 => NULL
364: ,p_prmtr_07 => NULL
363: ,p_prmtr_06 => NULL
364: ,p_prmtr_07 => NULL
365: ,p_prmtr_08 => NULL
366: ,p_prmtr_09 => fnd_date.date_to_canonical(p_abp_reporting_date)
367: ,p_prmtr_10 => fnd_number.number_to_canonical(p_assignment_id)
368: ,p_person_id => l_person_id
369: ,p_business_group_id => l_business_group_id
370: ,p_object_version_number => l_ovn
371: ,p_effective_date => p_effective_date
408: ,chg_eff_dt
409: FROM ben_ext_chg_evt_log
410: WHERE person_id = c_person_id
411: AND chg_evt_cd = 'COAPP'
412: AND prmtr_03 = fnd_number.number_to_canonical(p_assignment_extra_info_id);
413:
414: l_person_id per_all_assignments_f.person_id%TYPE;
415: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
416: l_ovn ben_ext_chg_evt_log.object_version_number%TYPE;
644: (p_validate => true
645: ,p_ext_chg_evt_log_id => l_log_id
646: ,p_chg_evt_cd => 'COSIPD'
647: ,p_chg_eff_dt => p_effective_date
648: ,p_prmtr_01 => fnd_number.number_to_canonical(p_assignment_id)
649: ,p_person_id => l_person_id
650: ,p_business_group_id => l_business_group_id
651: ,p_object_version_number => l_ovn
652: ,p_effective_date => p_effective_date
719: ben_EXT_CHG_EVT_api.create_EXT_CHG_EVT
720: (p_ext_chg_evt_log_id => l_log_id
721: ,p_chg_evt_cd => 'COSIPD'
722: ,p_chg_eff_dt => fnd_date.canonical_to_date(p_aei_information1)
723: ,p_prmtr_01 => fnd_number.number_to_canonical(p_assignment_id)
724: ,p_person_id => l_person_id
725: ,p_business_group_id => l_business_group_id
726: ,p_object_version_number => l_ovn
727: ,p_effective_date => fnd_date.canonical_to_date(p_aei_information1)
737: ben_EXT_CHG_EVT_api.create_EXT_CHG_EVT
738: (p_ext_chg_evt_log_id => l_log_id
739: ,p_chg_evt_cd => 'COSIPD'
740: ,p_chg_eff_dt => p_effective_date
741: ,p_prmtr_01 => fnd_number.number_to_canonical(p_assignment_id)
742: ,p_person_id => l_person_id
743: ,p_business_group_id => l_business_group_id
744: ,p_object_version_number => l_ovn
745: ,p_effective_date => p_effective_date
895: ,p_chg_eff_dt => nvl(l_eff_date,
896: fnd_date.canonical_to_date(p_aei_information1))
897: ,p_prmtr_01 => p_aei_information1
898: ,p_prmtr_02 => p_aei_information2
899: ,p_prmtr_03 => fnd_number.number_to_canonical(p_assignment_extra_info_id)
900: ,p_prmtr_09 => fnd_date.date_to_canonical(p_abp_reporting_date)
901: ,p_prmtr_10 => p_assignment_id
902: ,p_person_id => l_person_id
903: ,p_business_group_id => l_business_group_id
983: ,chg_eff_dt
984: FROM ben_ext_chg_evt_log
985: WHERE person_id = c_person_id
986: AND chg_evt_cd = 'COAPKOP'
987: AND prmtr_03 = fnd_number.number_to_canonical(p_assignment_extra_info_id);
988:
989: l_person_id per_all_assignments_f.person_id%TYPE;
990: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
991: l_log_id ben_ext_chg_evt_log.ext_chg_evt_log_id%TYPE;