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_CA_INST

Line 209: igs_ca_inst_rel r

205: r.sup_ci_sequence_number,
206: r.sub_cal_type,
207: r.sub_ci_sequence_number
208: from
209: igs_ca_inst_rel r
210: , igs_ca_type t1
211: , igs_ca_type t2
212: , igs_ca_inst acad
213: , igs_ca_inst adm

Line 212: , igs_ca_inst acad

208: from
209: igs_ca_inst_rel r
210: , igs_ca_type t1
211: , igs_ca_type t2
212: , igs_ca_inst acad
213: , igs_ca_inst adm
214: where
215: sup_cal_type = t1.cal_type
216: and t1.s_cal_cat = 'ACADEMIC'

Line 213: , igs_ca_inst adm

209: igs_ca_inst_rel r
210: , igs_ca_type t1
211: , igs_ca_type t2
212: , igs_ca_inst acad
213: , igs_ca_inst adm
214: where
215: sup_cal_type = t1.cal_type
216: and t1.s_cal_cat = 'ACADEMIC'
217: and sub_cal_type = t2.cal_type

Line 224: from igs_ca_inst ci

220: and sup_ci_sequence_number = acad.sequence_number
221: and sub_cal_type = adm.cal_type
222: and sub_ci_sequence_number = adm.sequence_number
223: and acad.start_dt > ( select ci.start_dt
224: from igs_ca_inst ci
225: where ci.cal_type = l_acad_cal
226: and ci.sequence_number = l_acad_cal_seq_num)
227: and adm.start_dt > ( select ci.start_dt
228: from igs_ca_inst ci

Line 228: from igs_ca_inst ci

224: from igs_ca_inst ci
225: where ci.cal_type = l_acad_cal
226: and ci.sequence_number = l_acad_cal_seq_num)
227: and adm.start_dt > ( select ci.start_dt
228: from igs_ca_inst ci
229: where ci.cal_type = l_adm_cal
230: and ci.sequence_number = l_adm_cal_seq_num)
231: )
232: )

Line 297: igs_ca_inst_rel r

293: r.sup_ci_sequence_number,
294: r.sub_cal_type,
295: r.sub_ci_sequence_number
296: from
297: igs_ca_inst_rel r
298: , igs_ca_type t1
299: , igs_ca_type t2
300: , igs_ca_inst acad
301: , igs_ca_inst adm

Line 300: , igs_ca_inst acad

296: from
297: igs_ca_inst_rel r
298: , igs_ca_type t1
299: , igs_ca_type t2
300: , igs_ca_inst acad
301: , igs_ca_inst adm
302: where
303: sup_cal_type = t1.cal_type
304: and t1.s_cal_cat = 'ACADEMIC'

Line 301: , igs_ca_inst adm

297: igs_ca_inst_rel r
298: , igs_ca_type t1
299: , igs_ca_type t2
300: , igs_ca_inst acad
301: , igs_ca_inst adm
302: where
303: sup_cal_type = t1.cal_type
304: and t1.s_cal_cat = 'ACADEMIC'
305: and sub_cal_type = t2.cal_type

Line 312: from igs_ca_inst ci

308: and sup_ci_sequence_number = acad.sequence_number
309: and sub_cal_type = adm.cal_type
310: and sub_ci_sequence_number = adm.sequence_number
311: and acad.start_dt > ( select ci.start_dt
312: from igs_ca_inst ci
313: where ci.cal_type = l_acad_cal
314: and ci.sequence_number = l_acad_cal_seq_num)
315: and adm.start_dt > ( select ci.start_dt
316: from igs_ca_inst ci

Line 316: from igs_ca_inst ci

312: from igs_ca_inst ci
313: where ci.cal_type = l_acad_cal
314: and ci.sequence_number = l_acad_cal_seq_num)
315: and adm.start_dt > ( select ci.start_dt
316: from igs_ca_inst ci
317: where ci.cal_type = l_adm_cal
318: and ci.sequence_number = l_adm_cal_seq_num)
319: )
320: )

Line 373: igs_ca_inst_rel r

369: r.sup_ci_sequence_number,
370: r.sub_cal_type,
371: r.sub_ci_sequence_number
372: from
373: igs_ca_inst_rel r
374: , igs_ca_type t1
375: , igs_ca_type t2
376: , igs_ca_inst acad
377: , igs_ca_inst adm

Line 376: , igs_ca_inst acad

372: from
373: igs_ca_inst_rel r
374: , igs_ca_type t1
375: , igs_ca_type t2
376: , igs_ca_inst acad
377: , igs_ca_inst adm
378: where
379: sup_cal_type = t1.cal_type
380: and t1.s_cal_cat = 'ACADEMIC'

Line 377: , igs_ca_inst adm

373: igs_ca_inst_rel r
374: , igs_ca_type t1
375: , igs_ca_type t2
376: , igs_ca_inst acad
377: , igs_ca_inst adm
378: where
379: sup_cal_type = t1.cal_type
380: and t1.s_cal_cat = 'ACADEMIC'
381: and sub_cal_type = t2.cal_type

Line 388: from igs_ca_inst ci

384: and sup_ci_sequence_number = acad.sequence_number
385: and sub_cal_type = adm.cal_type
386: and sub_ci_sequence_number = adm.sequence_number
387: and acad.start_dt > ( select ci.start_dt
388: from igs_ca_inst ci
389: where ci.cal_type = l_acad_cal
390: and ci.sequence_number = l_acad_cal_seq_num)
391: and adm.start_dt > ( select ci.start_dt
392: from igs_ca_inst ci

Line 392: from igs_ca_inst ci

388: from igs_ca_inst ci
389: where ci.cal_type = l_acad_cal
390: and ci.sequence_number = l_acad_cal_seq_num)
391: and adm.start_dt > ( select ci.start_dt
392: from igs_ca_inst ci
393: where ci.cal_type = l_adm_cal
394: and ci.sequence_number = l_adm_cal_seq_num)
395: )
396: )

Line 465: igs_ca_inst_rel r

461: r.sup_ci_sequence_number,
462: r.sub_cal_type,
463: r.sub_ci_sequence_number
464: from
465: igs_ca_inst_rel r
466: , igs_ca_type t1
467: , igs_ca_type t2
468: , igs_ca_inst acad
469: , igs_ca_inst adm

Line 468: , igs_ca_inst acad

464: from
465: igs_ca_inst_rel r
466: , igs_ca_type t1
467: , igs_ca_type t2
468: , igs_ca_inst acad
469: , igs_ca_inst adm
470: where
471: sup_cal_type = t1.cal_type
472: and t1.s_cal_cat = 'ACADEMIC'

Line 469: , igs_ca_inst adm

465: igs_ca_inst_rel r
466: , igs_ca_type t1
467: , igs_ca_type t2
468: , igs_ca_inst acad
469: , igs_ca_inst adm
470: where
471: sup_cal_type = t1.cal_type
472: and t1.s_cal_cat = 'ACADEMIC'
473: and sub_cal_type = t2.cal_type

Line 480: from igs_ca_inst ci

476: and sup_ci_sequence_number = acad.sequence_number
477: and sub_cal_type = adm.cal_type
478: and sub_ci_sequence_number = adm.sequence_number
479: and acad.start_dt > ( select ci.start_dt
480: from igs_ca_inst ci
481: where ci.cal_type = l_acad_cal
482: and ci.sequence_number = l_acad_cal_seq_num)
483: and adm.start_dt > ( select ci.start_dt
484: from igs_ca_inst ci

Line 484: from igs_ca_inst ci

480: from igs_ca_inst ci
481: where ci.cal_type = l_acad_cal
482: and ci.sequence_number = l_acad_cal_seq_num)
483: and adm.start_dt > ( select ci.start_dt
484: from igs_ca_inst ci
485: where ci.cal_type = l_adm_cal
486: and ci.sequence_number = l_adm_cal_seq_num)
487: )
488: )

Line 1130: l_adm_cal igs_ca_inst_all.cal_type%TYPE := RTRIM(SUBSTR(p_calendar_details, 23, 10));

1126: l_user_name VARCHAR2(100);
1127: l_full_name VARCHAR2(1000);
1128: l_count number := 0;
1129:
1130: l_adm_cal igs_ca_inst_all.cal_type%TYPE := RTRIM(SUBSTR(p_calendar_details, 23, 10));
1131: l_acad_cal igs_ca_inst_all.cal_type%TYPE := RTRIM(SUBSTR(p_calendar_details,1,10));
1132: l_acad_cal_seq_num igs_ca_inst_all.sequence_number%TYPE := IGS_GE_NUMBER.TO_NUM(SUBSTR(p_calendar_details,14,6));
1133: l_adm_cal_seq_num igs_ca_inst_all.sequence_number%TYPE :=IGS_GE_NUMBER.TO_NUM(SUBSTR(p_calendar_details,37,6));
1134: l_adm_cat VARCHAR2(10) := RTRIM(SUBSTR(p_apc,1, 10));

Line 1131: l_acad_cal igs_ca_inst_all.cal_type%TYPE := RTRIM(SUBSTR(p_calendar_details,1,10));

1127: l_full_name VARCHAR2(1000);
1128: l_count number := 0;
1129:
1130: l_adm_cal igs_ca_inst_all.cal_type%TYPE := RTRIM(SUBSTR(p_calendar_details, 23, 10));
1131: l_acad_cal igs_ca_inst_all.cal_type%TYPE := RTRIM(SUBSTR(p_calendar_details,1,10));
1132: l_acad_cal_seq_num igs_ca_inst_all.sequence_number%TYPE := IGS_GE_NUMBER.TO_NUM(SUBSTR(p_calendar_details,14,6));
1133: l_adm_cal_seq_num igs_ca_inst_all.sequence_number%TYPE :=IGS_GE_NUMBER.TO_NUM(SUBSTR(p_calendar_details,37,6));
1134: l_adm_cat VARCHAR2(10) := RTRIM(SUBSTR(p_apc,1, 10));
1135: l_adm_proc_type varchar2(15) := RTRIM(SUBSTR(p_apc, 11, 30));

Line 1132: l_acad_cal_seq_num igs_ca_inst_all.sequence_number%TYPE := IGS_GE_NUMBER.TO_NUM(SUBSTR(p_calendar_details,14,6));

1128: l_count number := 0;
1129:
1130: l_adm_cal igs_ca_inst_all.cal_type%TYPE := RTRIM(SUBSTR(p_calendar_details, 23, 10));
1131: l_acad_cal igs_ca_inst_all.cal_type%TYPE := RTRIM(SUBSTR(p_calendar_details,1,10));
1132: l_acad_cal_seq_num igs_ca_inst_all.sequence_number%TYPE := IGS_GE_NUMBER.TO_NUM(SUBSTR(p_calendar_details,14,6));
1133: l_adm_cal_seq_num igs_ca_inst_all.sequence_number%TYPE :=IGS_GE_NUMBER.TO_NUM(SUBSTR(p_calendar_details,37,6));
1134: l_adm_cat VARCHAR2(10) := RTRIM(SUBSTR(p_apc,1, 10));
1135: l_adm_proc_type varchar2(15) := RTRIM(SUBSTR(p_apc, 11, 30));
1136:

Line 1133: l_adm_cal_seq_num igs_ca_inst_all.sequence_number%TYPE :=IGS_GE_NUMBER.TO_NUM(SUBSTR(p_calendar_details,37,6));

1129:
1130: l_adm_cal igs_ca_inst_all.cal_type%TYPE := RTRIM(SUBSTR(p_calendar_details, 23, 10));
1131: l_acad_cal igs_ca_inst_all.cal_type%TYPE := RTRIM(SUBSTR(p_calendar_details,1,10));
1132: l_acad_cal_seq_num igs_ca_inst_all.sequence_number%TYPE := IGS_GE_NUMBER.TO_NUM(SUBSTR(p_calendar_details,14,6));
1133: l_adm_cal_seq_num igs_ca_inst_all.sequence_number%TYPE :=IGS_GE_NUMBER.TO_NUM(SUBSTR(p_calendar_details,37,6));
1134: l_adm_cat VARCHAR2(10) := RTRIM(SUBSTR(p_apc,1, 10));
1135: l_adm_proc_type varchar2(15) := RTRIM(SUBSTR(p_apc, 11, 30));
1136:
1137: l_alt_code_acad igs_ca_inst.alternate_code%TYPE;

Line 1137: l_alt_code_acad igs_ca_inst.alternate_code%TYPE;

1133: l_adm_cal_seq_num igs_ca_inst_all.sequence_number%TYPE :=IGS_GE_NUMBER.TO_NUM(SUBSTR(p_calendar_details,37,6));
1134: l_adm_cat VARCHAR2(10) := RTRIM(SUBSTR(p_apc,1, 10));
1135: l_adm_proc_type varchar2(15) := RTRIM(SUBSTR(p_apc, 11, 30));
1136:
1137: l_alt_code_acad igs_ca_inst.alternate_code%TYPE;
1138: l_alt_code_adm igs_ca_inst.alternate_code%TYPE;
1139:
1140: Cursor c_per_adm_req IS
1141: select a.person_id

Line 1138: l_alt_code_adm igs_ca_inst.alternate_code%TYPE;

1134: l_adm_cat VARCHAR2(10) := RTRIM(SUBSTR(p_apc,1, 10));
1135: l_adm_proc_type varchar2(15) := RTRIM(SUBSTR(p_apc, 11, 30));
1136:
1137: l_alt_code_acad igs_ca_inst.alternate_code%TYPE;
1138: l_alt_code_adm igs_ca_inst.alternate_code%TYPE;
1139:
1140: Cursor c_per_adm_req IS
1141: select a.person_id
1142: from igs_ad_appl_all a,

Line 1214: CURSOR c_get_alt_code(cp_cal_type igs_ca_inst.cal_type%TYPE,cp_seq_no igs_ca_inst.sequence_number%TYPE) IS

1210: and t.tracking_type = ty.tracking_type
1211: and ty.s_tracking_type = 'POST_ADMISSION'
1212: group by a.person_id;
1213:
1214: CURSOR c_get_alt_code(cp_cal_type igs_ca_inst.cal_type%TYPE,cp_seq_no igs_ca_inst.sequence_number%TYPE) IS
1215: SELECT alternate_code
1216: FROM IGS_CA_INST
1217: WHERE cal_type = cp_cal_type AND
1218: sequence_number = cp_seq_no;

Line 1216: FROM IGS_CA_INST

1212: group by a.person_id;
1213:
1214: CURSOR c_get_alt_code(cp_cal_type igs_ca_inst.cal_type%TYPE,cp_seq_no igs_ca_inst.sequence_number%TYPE) IS
1215: SELECT alternate_code
1216: FROM IGS_CA_INST
1217: WHERE cal_type = cp_cal_type AND
1218: sequence_number = cp_seq_no;
1219:
1220: CURSOR cur_user(cp_person_id igs_ad_appl_all.person_id%TYPE) IS