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_VAL_APAC dependencies on IGS_CA_INST

Line 101: v_sup_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE;

97: -- academic calendar instance.
98: DECLARE
99: v_alter_found CHAR DEFAULT 'N';
100: v_alter_exist CHAR DEFAULT 'N';
101: v_sup_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE;
102: v_sup_ci_seq_no IGS_CA_INST_REL.sup_ci_sequence_number%TYPE;
103: v_message_name varchar2(30);
104: v_alternate_code IGS_CA_INST.alternate_code%TYPE;
105: v_start_dt IGS_CA_INST.start_dt%TYPE;

Line 102: v_sup_ci_seq_no IGS_CA_INST_REL.sup_ci_sequence_number%TYPE;

98: DECLARE
99: v_alter_found CHAR DEFAULT 'N';
100: v_alter_exist CHAR DEFAULT 'N';
101: v_sup_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE;
102: v_sup_ci_seq_no IGS_CA_INST_REL.sup_ci_sequence_number%TYPE;
103: v_message_name varchar2(30);
104: v_alternate_code IGS_CA_INST.alternate_code%TYPE;
105: v_start_dt IGS_CA_INST.start_dt%TYPE;
106: v_end_dt IGS_CA_INST.end_dt%TYPE;

Line 104: v_alternate_code IGS_CA_INST.alternate_code%TYPE;

100: v_alter_exist CHAR DEFAULT 'N';
101: v_sup_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE;
102: v_sup_ci_seq_no IGS_CA_INST_REL.sup_ci_sequence_number%TYPE;
103: v_message_name varchar2(30);
104: v_alternate_code IGS_CA_INST.alternate_code%TYPE;
105: v_start_dt IGS_CA_INST.start_dt%TYPE;
106: v_end_dt IGS_CA_INST.end_dt%TYPE;
107: CURSOR c_sup (
108: p_adm_cal_type IGS_AD_PERD_AD_CAT.adm_cal_type%TYPE,

Line 105: v_start_dt IGS_CA_INST.start_dt%TYPE;

101: v_sup_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE;
102: v_sup_ci_seq_no IGS_CA_INST_REL.sup_ci_sequence_number%TYPE;
103: v_message_name varchar2(30);
104: v_alternate_code IGS_CA_INST.alternate_code%TYPE;
105: v_start_dt IGS_CA_INST.start_dt%TYPE;
106: v_end_dt IGS_CA_INST.end_dt%TYPE;
107: CURSOR c_sup (
108: p_adm_cal_type IGS_AD_PERD_AD_CAT.adm_cal_type%TYPE,
109: p_adm_ci_sequence_number

Line 106: v_end_dt IGS_CA_INST.end_dt%TYPE;

102: v_sup_ci_seq_no IGS_CA_INST_REL.sup_ci_sequence_number%TYPE;
103: v_message_name varchar2(30);
104: v_alternate_code IGS_CA_INST.alternate_code%TYPE;
105: v_start_dt IGS_CA_INST.start_dt%TYPE;
106: v_end_dt IGS_CA_INST.end_dt%TYPE;
107: CURSOR c_sup (
108: p_adm_cal_type IGS_AD_PERD_AD_CAT.adm_cal_type%TYPE,
109: p_adm_ci_sequence_number
110: IGS_AD_PERD_AD_CAT.adm_ci_sequence_number%TYPE) IS

Line 113: FROM IGS_CA_INST_REL cir1,

109: p_adm_ci_sequence_number
110: IGS_AD_PERD_AD_CAT.adm_ci_sequence_number%TYPE) IS
111: Select cir1.sup_cal_type,
112: cir1.sup_ci_sequence_number
113: FROM IGS_CA_INST_REL cir1,
114: IGS_CA_TYPE cat
115: WHERE cir1.sub_cal_type = p_adm_cal_type AND
116: cir1.sub_ci_sequence_number = p_adm_ci_sequence_number AND
117: cir1.sup_cal_type = cat.cal_type AND

Line 120: cp_sup_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE,

116: cir1.sub_ci_sequence_number = p_adm_ci_sequence_number AND
117: cir1.sup_cal_type = cat.cal_type AND
118: cat.s_cal_cat = 'ACADEMIC';
119: CURSOR c_alter_code (
120: cp_sup_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE,
121: cp_sup_ci_sequence_number
122: IGS_CA_INST_REL.sup_ci_sequence_number%TYPE) IS
123: SELECT DISTINCT ci.alternate_code,
124: cir2.sub_cal_type,

Line 122: IGS_CA_INST_REL.sup_ci_sequence_number%TYPE) IS

118: cat.s_cal_cat = 'ACADEMIC';
119: CURSOR c_alter_code (
120: cp_sup_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE,
121: cp_sup_ci_sequence_number
122: IGS_CA_INST_REL.sup_ci_sequence_number%TYPE) IS
123: SELECT DISTINCT ci.alternate_code,
124: cir2.sub_cal_type,
125: cir2.sub_ci_sequence_number
126: FROM IGS_CA_INST_REL cir2,

Line 126: FROM IGS_CA_INST_REL cir2,

122: IGS_CA_INST_REL.sup_ci_sequence_number%TYPE) IS
123: SELECT DISTINCT ci.alternate_code,
124: cir2.sub_cal_type,
125: cir2.sub_ci_sequence_number
126: FROM IGS_CA_INST_REL cir2,
127: IGS_CA_INST ci,
128: IGS_CA_TYPE cat
129: WHERE cir2.sup_cal_type = cp_sup_cal_type AND
130: cir2.sup_ci_sequence_number = cp_sup_ci_sequence_number AND

Line 127: IGS_CA_INST ci,

123: SELECT DISTINCT ci.alternate_code,
124: cir2.sub_cal_type,
125: cir2.sub_ci_sequence_number
126: FROM IGS_CA_INST_REL cir2,
127: IGS_CA_INST ci,
128: IGS_CA_TYPE cat
129: WHERE cir2.sup_cal_type = cp_sup_cal_type AND
130: cir2.sup_ci_sequence_number = cp_sup_ci_sequence_number AND
131: (cir2.sub_cal_type <> p_adm_cal_type OR

Line 138: cp_sub_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE,

134: cat.cal_type = ci.cal_type AND
135: ci.cal_type = cir2.sub_cal_type AND
136: ci.sequence_number = cir2.sub_ci_sequence_number;
137: CURSOR c_apac (
138: cp_sub_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE,
139: cp_sub_ci_sequence_number
140: IGS_CA_INST_REL.sub_ci_sequence_number%TYPE) IS
141: SELECT admission_cat
142: FROM IGS_AD_PERD_AD_CAT

Line 140: IGS_CA_INST_REL.sub_ci_sequence_number%TYPE) IS

136: ci.sequence_number = cir2.sub_ci_sequence_number;
137: CURSOR c_apac (
138: cp_sub_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE,
139: cp_sub_ci_sequence_number
140: IGS_CA_INST_REL.sub_ci_sequence_number%TYPE) IS
141: SELECT admission_cat
142: FROM IGS_AD_PERD_AD_CAT
143: WHERE adm_cal_type = cp_sub_cal_type AND
144: adm_ci_sequence_number = cp_sub_ci_sequence_number;

Line 351: v_alternate_code IGS_CA_INST.alternate_code%TYPE;

347: cst_admission CONSTANT VARCHAR2(9) := 'ADMISSION';
348: cst_active CONSTANT VARCHAR2(9) := 'ACTIVE'; --removed the planned variable (cst_planned) as per bug#2722785 --rghosh
349: v_s_cal_cat IGS_CA_TYPE.s_cal_cat%TYPE;
350: v_s_cal_status IGS_CA_STAT.s_cal_status%TYPE;
351: v_alternate_code IGS_CA_INST.alternate_code%TYPE;
352: v_start_dt IGS_CA_INST.start_dt%TYPE;
353: v_end_dt IGS_CA_INST.end_dt%TYPE;
354: CURSOR c_s_cal_cat (
355: cp_adm_cal_type IGS_AD_PERD_AD_CAT.adm_cal_type%TYPE) IS

Line 352: v_start_dt IGS_CA_INST.start_dt%TYPE;

348: cst_active CONSTANT VARCHAR2(9) := 'ACTIVE'; --removed the planned variable (cst_planned) as per bug#2722785 --rghosh
349: v_s_cal_cat IGS_CA_TYPE.s_cal_cat%TYPE;
350: v_s_cal_status IGS_CA_STAT.s_cal_status%TYPE;
351: v_alternate_code IGS_CA_INST.alternate_code%TYPE;
352: v_start_dt IGS_CA_INST.start_dt%TYPE;
353: v_end_dt IGS_CA_INST.end_dt%TYPE;
354: CURSOR c_s_cal_cat (
355: cp_adm_cal_type IGS_AD_PERD_AD_CAT.adm_cal_type%TYPE) IS
356: SELECT cat.s_cal_cat

Line 353: v_end_dt IGS_CA_INST.end_dt%TYPE;

349: v_s_cal_cat IGS_CA_TYPE.s_cal_cat%TYPE;
350: v_s_cal_status IGS_CA_STAT.s_cal_status%TYPE;
351: v_alternate_code IGS_CA_INST.alternate_code%TYPE;
352: v_start_dt IGS_CA_INST.start_dt%TYPE;
353: v_end_dt IGS_CA_INST.end_dt%TYPE;
354: CURSOR c_s_cal_cat (
355: cp_adm_cal_type IGS_AD_PERD_AD_CAT.adm_cal_type%TYPE) IS
356: SELECT cat.s_cal_cat
357: FROM IGS_CA_TYPE cat

Line 367: FROM IGS_CA_INST ci,

363: SELECT cs.s_cal_status,
364: ci.alternate_code,
365: ci.start_dt,
366: ci.end_dt
367: FROM IGS_CA_INST ci,
368: IGS_CA_STAT cs
369: WHERE ci.cal_type = cp_adm_cal_type AND
370: ci.sequence_number = cp_adm_ci_sequence_number AND
371: ci.cal_status = cs.cal_status;