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_AD_WRKFLOW_PKG dependencies on IGS_SS_ADM_APPL_STG

Line 41: From IGS_SS_ADM_APPL_STG aa

37:
38: /* No program parameter has been provided,include application without calendar is YES and calendar range is CURRENT */
39: Cursor c_incom_appl_nopgm_curr_anc IS
40: Select aa.person_id
41: From IGS_SS_ADM_APPL_STG aa
42: Where
43: ((aa.person_id = p_person_id AND p_person_id IS NOT NULL) OR (p_person_id is NULL))
44: AND (p_person_id_group IS NOT NULL AND
45: aa.person_id IN (SELECT person_id

Line 60: From IGS_SS_ADM_APPL_STG aa

56: AND aa.APP_SOURCE_ID IN ( select code_id from igs_ad_code_classes where CLASS = 'SYS_APPL_SOURCE' and system_status = 'WEB_APPL' AND CLASS_TYPE_CODE='ADM_CODE_CLASSES')
57: Group BY aa.person_id
58: UNION
59: Select aa.person_id
60: From IGS_SS_ADM_APPL_STG aa
61: Where
62: ((aa.person_id = p_person_id AND p_person_id IS NOT NULL) OR (p_person_id is NULL)) AND
63: (p_person_id_group IS NOT NULL AND
64: aa.person_id IN (SELECT person_id

Line 80: From IGS_SS_ADM_APPL_STG aa

76:
77: /* No program parameter has been provided,include application without calendar is NO and calendar range is CURRENT */
78: Cursor c_incom_appl_nopgm_curr IS
79: Select aa.person_id
80: From IGS_SS_ADM_APPL_STG aa
81: Where ((aa.person_id = p_person_id AND p_person_id IS NOT NULL) OR (p_person_id is NULL))
82: AND (p_person_id_group IS NOT NULL AND
83: aa.person_id IN (SELECT person_id
84: FROM igs_pe_prsid_grp_mem pgm

Line 100: From IGS_SS_ADM_APPL_STG aa, IGS_SS_APP_PGM_STG aap

96:
97: /* Program parameter has been provided,include application without calendar is YES and calendar range is CURRENT */
98: Cursor c_incom_appl_pgm_curr_anc IS
99: Select aa.person_id
100: From IGS_SS_ADM_APPL_STG aa, IGS_SS_APP_PGM_STG aap
101: Where
102: aap.SS_ADM_APPL_ID = aa.SS_ADM_APPL_ID(+)
103: And ((aa.person_id = p_person_id AND p_person_id IS NOT NULL) OR (p_person_id is NULL))
104: AND (p_person_id_group IS NOT NULL AND

Line 124: From IGS_SS_ADM_APPL_STG aa

120: AND aa.APP_SOURCE_ID IN (select code_id from igs_ad_code_classes where CLASS = 'SYS_APPL_SOURCE' and system_status = 'WEB_APPL' AND CLASS_TYPE_CODE='ADM_CODE_CLASSES')
121: Group BY aa.person_id
122: UNION
123: Select aa.person_id
124: From IGS_SS_ADM_APPL_STG aa
125: Where
126: ((aa.person_id = p_person_id AND p_person_id IS NOT NULL) OR (p_person_id is NULL))
127: AND (p_person_id_group IS NOT NULL AND
128: aa.person_id IN (SELECT person_id

Line 144: From IGS_SS_ADM_APPL_STG aa, IGS_SS_APP_PGM_STG aap

140:
141: /* Program parameter has been provided,include application without calendar is NO and calendar range is CURRENT */
142: Cursor c_incom_appl_pgm_curr IS
143: Select aa.person_id
144: From IGS_SS_ADM_APPL_STG aa, IGS_SS_APP_PGM_STG aap
145: Where aap.SS_ADM_APPL_ID = aa.SS_ADM_APPL_ID(+)
146: And ((aa.person_id = p_person_id AND p_person_id IS NOT NULL) OR (p_person_id is NULL))
147: AND (p_person_id_group IS NOT NULL AND
148: aa.person_id IN (SELECT person_id

Line 169: From IGS_SS_ADM_APPL_STG aa

165:
166: /* No program parameter has been provided,include application without calendar is YES and calendar range is CURRFUTURE */
167: Cursor c_incom_appl_nopgm_cnf_anc IS
168: Select aa.person_id
169: From IGS_SS_ADM_APPL_STG aa
170: Where
171: ((aa.person_id = p_person_id AND p_person_id IS NOT NULL) OR (p_person_id is NULL))
172: AND (p_person_id_group IS NOT NULL
173: AND aa.person_id IN (SELECT person_id

Line 187: From IGS_SS_ADM_APPL_STG aa

183: AND ((aa.ADMISSION_APPLICATION_TYPE = p_appl_type AND p_appl_type IS NOT NULL ) OR (p_appl_type IS NULL))
184: AND aa.APP_SOURCE_ID IN ( select code_id from igs_ad_code_classes where CLASS = 'SYS_APPL_SOURCE' and system_status = 'WEB_APPL' AND CLASS_TYPE_CODE='ADM_CODE_CLASSES')
185: UNION
186: Select aa.person_id
187: From IGS_SS_ADM_APPL_STG aa
188: Where
189: ((aa.person_id = p_person_id AND p_person_id IS NOT NULL) OR (p_person_id is NULL))
190: AND (p_person_id_group IS NOT NULL
191: AND aa.person_id IN (SELECT person_id

Line 237: From IGS_SS_ADM_APPL_STG aa

233: AND aa.APP_SOURCE_ID IN ( select code_id from igs_ad_code_classes where CLASS = 'SYS_APPL_SOURCE' and system_status = 'WEB_APPL' AND CLASS_TYPE_CODE='ADM_CODE_CLASSES')
234: Group BY aa.person_id
235: UNION
236: Select aa.person_id
237: From IGS_SS_ADM_APPL_STG aa
238: Where
239: ((aa.person_id = p_person_id AND p_person_id IS NOT NULL) OR (p_person_id is NULL))
240: AND (p_person_id_group IS NOT NULL
241: AND aa.person_id IN (SELECT person_id

Line 257: From IGS_SS_ADM_APPL_STG aa

253:
254: /* No program parameter has been provided,include application without calendar is NO and calendar range is CURRFUTURE */
255: Cursor c_incom_appl_nopgm_cnf IS
256: Select aa.person_id
257: From IGS_SS_ADM_APPL_STG aa
258: Where ((aa.person_id = p_person_id AND p_person_id IS NOT NULL) OR (p_person_id is NULL))
259: AND (p_person_id_group IS NOT NULL AND
260: aa.person_id IN (SELECT person_id
261: FROM igs_pe_prsid_grp_mem pgm

Line 275: From IGS_SS_ADM_APPL_STG aa

271: AND aa.APP_SOURCE_ID IN ( select code_id from igs_ad_code_classes where CLASS = 'SYS_APPL_SOURCE' and system_status = 'WEB_APPL' AND CLASS_TYPE_CODE='ADM_CODE_CLASSES')
272: Group BY aa.person_id
273: UNION
274: Select aa.person_id
275: From IGS_SS_ADM_APPL_STG aa
276: Where
277: ((aa.person_id = p_person_id AND p_person_id IS NOT NULL) OR (p_person_id is NULL))
278: AND (p_person_id_group IS NOT NULL AND
279: aa.person_id IN (SELECT person_id

Line 327: From IGS_SS_ADM_APPL_STG aa, IGS_SS_APP_PGM_STG aap

323:
324: /* Program parameter has been provided,include application without calendar is YES and calendar range is CURRFUTURE */
325: Cursor c_incom_appl_pgm_cnf_anc IS
326: Select aa.person_id
327: From IGS_SS_ADM_APPL_STG aa, IGS_SS_APP_PGM_STG aap
328: Where
329: aap.SS_ADM_APPL_ID = aa.SS_ADM_APPL_ID(+)
330: And ((aa.person_id = p_person_id AND p_person_id IS NOT NULL) OR (p_person_id is NULL))
331: AND (p_person_id_group IS NOT NULL AND

Line 351: From IGS_SS_ADM_APPL_STG aa

347: AND aa.APP_SOURCE_ID IN (select code_id from igs_ad_code_classes where CLASS = 'SYS_APPL_SOURCE' and system_status = 'WEB_APPL' AND CLASS_TYPE_CODE='ADM_CODE_CLASSES')
348: Group BY aa.person_id
349: UNION
350: Select aa.person_id
351: From IGS_SS_ADM_APPL_STG aa
352: Where
353: ((aa.person_id = p_person_id AND p_person_id IS NOT NULL) OR (p_person_id is NULL))
354: AND (p_person_id_group IS NOT NULL AND
355: aa.person_id IN (SELECT person_id

Line 401: From IGS_SS_ADM_APPL_STG aa

397: AND aa.APP_SOURCE_ID IN ( select code_id from igs_ad_code_classes where CLASS = 'SYS_APPL_SOURCE' and system_status = 'WEB_APPL' AND CLASS_TYPE_CODE='ADM_CODE_CLASSES')
398: Group BY aa.person_id
399: UNION
400: Select aa.person_id
401: From IGS_SS_ADM_APPL_STG aa
402: Where
403: ((aa.person_id = p_person_id AND p_person_id IS NOT NULL) OR (p_person_id is NULL))
404: AND (p_person_id_group IS NOT NULL AND
405: aa.person_id IN (SELECT person_id

Line 421: From IGS_SS_ADM_APPL_STG aa, IGS_SS_APP_PGM_STG aap

417:
418: /* Program parameter has been provided,include application without calendar is YES and calendar range is CURRFUTURE */
419: Cursor c_incom_appl_pgm_cnf IS
420: Select aa.person_id
421: From IGS_SS_ADM_APPL_STG aa, IGS_SS_APP_PGM_STG aap
422: Where aap.SS_ADM_APPL_ID = aa.SS_ADM_APPL_ID(+)
423: And ((aa.person_id = p_person_id AND p_person_id IS NOT NULL) OR (p_person_id is NULL))
424: AND (p_person_id_group IS NOT NULL AND
425: aa.person_id IN (SELECT person_id

Line 443: From IGS_SS_ADM_APPL_STG aa

439: AND ((aap.ATTENDANCE_MODE = p_att_mode AND p_att_mode IS NOT NULL ) OR (p_att_mode IS NULL))
440: AND aa.APP_SOURCE_ID IN (select code_id from igs_ad_code_classes where CLASS = 'SYS_APPL_SOURCE' and system_status = 'WEB_APPL' AND CLASS_TYPE_CODE='ADM_CODE_CLASSES')
441: UNION
442: Select aa.person_id
443: From IGS_SS_ADM_APPL_STG aa
444: Where
445: ((aa.person_id = p_person_id AND p_person_id IS NOT NULL) OR (p_person_id is NULL))
446: AND (p_person_id_group IS NOT NULL AND
447: aa.person_id IN (SELECT person_id

Line 493: CURSOR cur_user(cp_person_id igs_ss_adm_appl_stg.person_id%TYPE) IS

489: AND aa.APP_SOURCE_ID IN ( select code_id from igs_ad_code_classes where CLASS = 'SYS_APPL_SOURCE' and system_status = 'WEB_APPL' AND CLASS_TYPE_CODE='ADM_CODE_CLASSES')
490: Group BY aa.person_id;
491:
492:
493: CURSOR cur_user(cp_person_id igs_ss_adm_appl_stg.person_id%TYPE) IS
494: SELECT user_id, user_name, description
495: FROM FND_USER
496: WHERE person_party_id = cp_person_id ;
497:

Line 503: CURSOR c_per_num1(cp_person_id igs_ss_adm_appl_stg.person_id%TYPE) IS

499: SELECT party_number
500: FROM HZ_PARTIES
501: WHERE party_id = p_person_id ;
502:
503: CURSOR c_per_num1(cp_person_id igs_ss_adm_appl_stg.person_id%TYPE) IS
504: SELECT party_number
505: FROM HZ_PARTIES
506: WHERE party_id = cp_person_id ;
507: