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_PS_APLINSTUNT_PKG dependencies on IGS_AD_PRCS_CAT_STEP

Line 122: cp_admission_cat IGS_AD_PRCS_CAT_STEP.admission_cat%TYPE,

118: v_unit_encmb_chk_ind VARCHAR2(1);
119: v_unit_restr_ind VARCHAR2(1);
120: cst_error CONSTANT VARCHAR2(1):= 'E';
121: CURSOR c_apcs (
122: cp_admission_cat IGS_AD_PRCS_CAT_STEP.admission_cat%TYPE,
123: cp_s_admission_process_type IGS_AD_PRCS_CAT_STEP.s_admission_process_type%TYPE) IS
124: SELECT s_admission_step_type
125: FROM IGS_AD_PRCS_CAT_STEP
126: WHERE admission_cat = cp_admission_cat AND

Line 123: cp_s_admission_process_type IGS_AD_PRCS_CAT_STEP.s_admission_process_type%TYPE) IS

119: v_unit_restr_ind VARCHAR2(1);
120: cst_error CONSTANT VARCHAR2(1):= 'E';
121: CURSOR c_apcs (
122: cp_admission_cat IGS_AD_PRCS_CAT_STEP.admission_cat%TYPE,
123: cp_s_admission_process_type IGS_AD_PRCS_CAT_STEP.s_admission_process_type%TYPE) IS
124: SELECT s_admission_step_type
125: FROM IGS_AD_PRCS_CAT_STEP
126: WHERE admission_cat = cp_admission_cat AND
127: s_admission_process_type = cp_s_admission_process_type AND

Line 125: FROM IGS_AD_PRCS_CAT_STEP

121: CURSOR c_apcs (
122: cp_admission_cat IGS_AD_PRCS_CAT_STEP.admission_cat%TYPE,
123: cp_s_admission_process_type IGS_AD_PRCS_CAT_STEP.s_admission_process_type%TYPE) IS
124: SELECT s_admission_step_type
125: FROM IGS_AD_PRCS_CAT_STEP
126: WHERE admission_cat = cp_admission_cat AND
127: s_admission_process_type = cp_s_admission_process_type AND
128: step_group_type <> 'TRACK'; --2402377
129: CURSOR c_acai (

Line 417: cp_admission_cat IGS_AD_PRCS_CAT_STEP.admission_cat%TYPE,

413: v_unit_restriction_ind VARCHAR2(1);
414: v_unit_restriction_num NUMBER;
415: v_message_name varchar2(30);
416: CURSOR c_apcs (
417: cp_admission_cat IGS_AD_PRCS_CAT_STEP.admission_cat%TYPE,
418: cp_s_admission_process_type
419: IGS_AD_PRCS_CAT_STEP.s_admission_process_type%TYPE) IS
420: SELECT s_admission_step_type,
421: step_type_restriction_num

Line 419: IGS_AD_PRCS_CAT_STEP.s_admission_process_type%TYPE) IS

415: v_message_name varchar2(30);
416: CURSOR c_apcs (
417: cp_admission_cat IGS_AD_PRCS_CAT_STEP.admission_cat%TYPE,
418: cp_s_admission_process_type
419: IGS_AD_PRCS_CAT_STEP.s_admission_process_type%TYPE) IS
420: SELECT s_admission_step_type,
421: step_type_restriction_num
422: FROM IGS_AD_PRCS_CAT_STEP
423: WHERE admission_cat = cp_admission_cat AND

Line 422: FROM IGS_AD_PRCS_CAT_STEP

418: cp_s_admission_process_type
419: IGS_AD_PRCS_CAT_STEP.s_admission_process_type%TYPE) IS
420: SELECT s_admission_step_type,
421: step_type_restriction_num
422: FROM IGS_AD_PRCS_CAT_STEP
423: WHERE admission_cat = cp_admission_cat AND
424: s_admission_process_type = cp_s_admission_process_type AND
425: step_group_type <> 'TRACK'; --2402377
426: BEGIN