eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGF_SL_LAR_CREATION dependencies on HZ_PARTIES

Line 3261: l_person_id hz_parties.party_id%TYPE;

3257: TYPE cur_person_id_type IS REF CURSOR;
3258: cur_per_grp cur_person_id_type;
3259:
3260: lv_status VARCHAR2(1);
3261: l_person_id hz_parties.party_id%TYPE;
3262: lb_record_exist BOOLEAN;
3263:
3264: ln_base_id NUMBER;
3265: lv_person_number hz_parties.party_number%TYPE;

Line 3265: lv_person_number hz_parties.party_number%TYPE;

3261: l_person_id hz_parties.party_id%TYPE;
3262: lb_record_exist BOOLEAN;
3263:
3264: ln_base_id NUMBER;
3265: lv_person_number hz_parties.party_number%TYPE;
3266: lv_group_type igs_pe_persid_group_v.group_type%TYPE;
3267:
3268: BEGIN
3269:

Line 3455: OPEN cur_per_grp FOR ' SELECT PARTY_ID FROM HZ_PARTIES WHERE PARTY_ID IN (' || l_list || ') ' USING p_dyn_pid_grp;

3451: l_list := igf_ap_ss_pkg.get_pid( p_dyn_pid_grp,lv_status,lv_group_type);
3452:
3453: --Bug #5021084. Passing Group ID if the group type is STATIC.
3454: IF lv_group_type = 'STATIC' THEN
3455: OPEN cur_per_grp FOR ' SELECT PARTY_ID FROM HZ_PARTIES WHERE PARTY_ID IN (' || l_list || ') ' USING p_dyn_pid_grp;
3456: ELSIF lv_group_type = 'DYNAMIC' THEN
3457: OPEN cur_per_grp FOR ' SELECT PARTY_ID FROM HZ_PARTIES WHERE PARTY_ID IN (' || l_list || ') ';
3458: END IF;
3459:

Line 3457: OPEN cur_per_grp FOR ' SELECT PARTY_ID FROM HZ_PARTIES WHERE PARTY_ID IN (' || l_list || ') ';

3453: --Bug #5021084. Passing Group ID if the group type is STATIC.
3454: IF lv_group_type = 'STATIC' THEN
3455: OPEN cur_per_grp FOR ' SELECT PARTY_ID FROM HZ_PARTIES WHERE PARTY_ID IN (' || l_list || ') ' USING p_dyn_pid_grp;
3456: ELSIF lv_group_type = 'DYNAMIC' THEN
3457: OPEN cur_per_grp FOR ' SELECT PARTY_ID FROM HZ_PARTIES WHERE PARTY_ID IN (' || l_list || ') ';
3458: END IF;
3459:
3460: FETCH cur_per_grp INTO l_person_id;
3461:

Line 3553: OPEN cur_per_grp FOR ' SELECT PARTY_ID FROM HZ_PARTIES WHERE PARTY_ID IN (' || l_list || ') ' USING p_dyn_pid_grp;

3549: l_list := igf_ap_ss_pkg.get_pid( p_dyn_pid_grp,lv_status,lv_group_type);
3550:
3551: --Bug #5021084. Passing Group ID if the group type is STATIC.
3552: IF lv_group_type = 'STATIC' THEN
3553: OPEN cur_per_grp FOR ' SELECT PARTY_ID FROM HZ_PARTIES WHERE PARTY_ID IN (' || l_list || ') ' USING p_dyn_pid_grp;
3554: ELSIF lv_group_type = 'DYNAMIC' THEN
3555: OPEN cur_per_grp FOR ' SELECT PARTY_ID FROM HZ_PARTIES WHERE PARTY_ID IN (' || l_list || ') ';
3556: END IF;
3557:

Line 3555: OPEN cur_per_grp FOR ' SELECT PARTY_ID FROM HZ_PARTIES WHERE PARTY_ID IN (' || l_list || ') ';

3551: --Bug #5021084. Passing Group ID if the group type is STATIC.
3552: IF lv_group_type = 'STATIC' THEN
3553: OPEN cur_per_grp FOR ' SELECT PARTY_ID FROM HZ_PARTIES WHERE PARTY_ID IN (' || l_list || ') ' USING p_dyn_pid_grp;
3554: ELSIF lv_group_type = 'DYNAMIC' THEN
3555: OPEN cur_per_grp FOR ' SELECT PARTY_ID FROM HZ_PARTIES WHERE PARTY_ID IN (' || l_list || ') ';
3556: END IF;
3557:
3558: FETCH cur_per_grp INTO l_person_id;
3559: