APPS.GHR_MTO_PKG dependencies on PER_PEOPLE_EXTRA_INFO

Line 2751: l_per_ei_data per_people_extra_info%rowtype;

2747: PROCEDURE get_to_agency (p_person_id in number,
2748: p_effective_date in date,
2749: p_agency_code out NOCOPY varchar2) is
2750:
2751: l_per_ei_data per_people_extra_info%rowtype;
2752: l_proc varchar2(72) := g_package || '.upd_ext_info_api';
2753: l_eff_date date;
2754: l_agency_code varchar2(5);
2755: begin

Line 2793: from per_people_extra_info

2789: -- VSM - Changes Bug # 752015 changed p_information type from
2790: -- GHR_US_PER_SEPARATE_RETIRE to GHR_US_PER_MASS_ACTIONS
2791: CURSOR PERSON_EXT_CUR (p_person number) IS
2792: select person_extra_info_id, object_version_number
2793: from per_people_extra_info
2794: where person_id = (p_person)
2795: and INFORMATION_TYPE = 'GHR_US_PER_MASS_ACTIONS';
2796:
2797: l_cnt number;

Line 2803: l_per_ei_data per_people_extra_info%rowtype;

2799: l_person_EXTRA_INFO_ID NUMBER;
2800: l_OBJECT_VERSION_NUMBER NUMBER;
2801: l_object_version_no number;
2802:
2803: l_per_ei_data per_people_extra_info%rowtype;
2804: l_proc varchar2(72) := g_package || '.upd_ext_info_api';
2805: l_eff_date date;
2806:
2807: BEGIN

Line 2909: from per_people_extra_info

2905: Procedure upd_per_extra_info_to_null(p_person_id in number) is
2906:
2907: CURSOR PER_EXT_CUR (p_person number) IS
2908: select person_extra_info_id, object_version_number
2909: from per_people_extra_info
2910: where person_id = (p_person)
2911: and INFORMATION_TYPE = 'GHR_US_PER_MASS_ACTIONS';
2912:
2913: l_Person_EXTRA_INFO_ID NUMBER;

Line 2915: l_per_ei_data per_people_extra_info%rowtype;

2911: and INFORMATION_TYPE = 'GHR_US_PER_MASS_ACTIONS';
2912:
2913: l_Person_EXTRA_INFO_ID NUMBER;
2914: l_OBJECT_VERSION_NUMBER NUMBER;
2915: l_per_ei_data per_people_extra_info%rowtype;
2916: l_proc varchar2(72) := g_package || '.upd_per_extra_info_to_null';
2917: begin
2918:
2919: g_proc := 'upd_per_extra_info_to_null';