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.IGS_DA_UTILS_PKG dependencies on IGS_PE_PERSID_GROUP_ALL

Line 20: smanglm 05-Aug-2003 Bug 3084766: Make use of Dynamic Person ID Group if the igs_pe_persid_group_all.FILE_NAME

16: Change History
17:
18: Who When What
19: ---------------------------------------------------------------
20: smanglm 05-Aug-2003 Bug 3084766: Make use of Dynamic Person ID Group if the igs_pe_persid_group_all.FILE_NAME
21: is not null else make use of static query. Changes made in the CURSOR c_stud_grp_mem of
22: create_req_stdnts_rec procedure
23: Jitendra Handa 27-Mar-2003 New Package Created.
24:

Line 137: -- of igs_pe_persid_group_all.file_name for the given group_id

133: --
134: l_person_id igs_pe_person.person_id%TYPE;
135: --
136: -- cursor to check whether dynamic person_id_group has to be used or not based on the value
137: -- of igs_pe_persid_group_all.file_name for the given group_id
138: --
139: CURSOR c_is_filename_null (cp_group_id igs_pe_persid_group_all.group_id%TYPE) IS
140: SELECT 'Y' FROM igs_pe_persid_group_all WHERE group_id = cp_group_id AND file_name IS NULL;
141: l_is_filename_null varchar2(1) := 'N';

Line 139: CURSOR c_is_filename_null (cp_group_id igs_pe_persid_group_all.group_id%TYPE) IS

135: --
136: -- cursor to check whether dynamic person_id_group has to be used or not based on the value
137: -- of igs_pe_persid_group_all.file_name for the given group_id
138: --
139: CURSOR c_is_filename_null (cp_group_id igs_pe_persid_group_all.group_id%TYPE) IS
140: SELECT 'Y' FROM igs_pe_persid_group_all WHERE group_id = cp_group_id AND file_name IS NULL;
141: l_is_filename_null varchar2(1) := 'N';
142:
143: CURSOR c_igs_da_rqst (cp_batch_id igs_da_rqst.batch_id%TYPE) IS

Line 140: SELECT 'Y' FROM igs_pe_persid_group_all WHERE group_id = cp_group_id AND file_name IS NULL;

136: -- cursor to check whether dynamic person_id_group has to be used or not based on the value
137: -- of igs_pe_persid_group_all.file_name for the given group_id
138: --
139: CURSOR c_is_filename_null (cp_group_id igs_pe_persid_group_all.group_id%TYPE) IS
140: SELECT 'Y' FROM igs_pe_persid_group_all WHERE group_id = cp_group_id AND file_name IS NULL;
141: l_is_filename_null varchar2(1) := 'N';
142:
143: CURSOR c_igs_da_rqst (cp_batch_id igs_da_rqst.batch_id%TYPE) IS
144: SELECT dr.rowid, dr.*