DBA Data[Home] [Help]

APPS.IGF_SP_CREATE_BASE_REC dependencies on IGF_AP_SS_PKG

Line 95: -- to igf_ap_ss_pkg.get_pid

91: --
92: --Change History:
93: --Who When What
94: --ridas 08-Feb-2006 Bug #5021084. Added new parameter 'lv_group_type' in call
95: -- to igf_ap_ss_pkg.get_pid
96: --bvisvana 31-Aug-2005 FA 157 - Bug # 4382371 - Dynamic person Id Inclusion.
97: -- Removed the normal cursor c_person_id and made it as REF CURSOR
98: --rasahoo 17-NOV-2003 FA 128 - ISIR update 2004-05
99: -- added new parameter award_fmly_contribution_type to

Line 306: l_list := igf_ap_ss_pkg.get_pid(p_person_group_id,lv_status,lv_group_type);

302: */
303: -- FOR rec_person_id IN c_person_id (p_person_group_id)
304: --FA 157 - Bug # 4382371 - Dynamic person Id Inclusion
305: --Bug #5021084
306: l_list := igf_ap_ss_pkg.get_pid(p_person_group_id,lv_status,lv_group_type);
307:
308: --Bug #5021084. Passing Group ID if the group type is STATIC.
309: IF lv_group_type = 'STATIC' THEN
310: OPEN c_person_id FOR 'SELECT party_id person_id FROM hz_parties WHERE party_id IN (' || l_list || ') ' USING p_person_group_id;