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

Line 126: v_cal_instance_rec IGS_CA_INST%ROWTYPE;

122: cst_planned CONSTANT VARCHAR2(8) := 'PLANNED';
123: cst_active CONSTANT VARCHAR2(8) := 'ACTIVE';
124: cst_inactive CONSTANT VARCHAR2(8) := 'INACTIVE';
125: v_other_detail VARCHAR2(255);
126: v_cal_instance_rec IGS_CA_INST%ROWTYPE;
127: v_cal_instance_rltshp_rec IGS_CA_INST_REL%ROWTYPE;
128: v_dt_alias_instance_rec IGS_CA_DA_INST_V%ROWTYPE;
129: v_new_s_cal_status IGS_CA_STAT.s_cal_status%TYPE;
130: v_old_s_cal_status IGS_CA_STAT.s_cal_status%TYPE;

Line 127: v_cal_instance_rltshp_rec IGS_CA_INST_REL%ROWTYPE;

123: cst_active CONSTANT VARCHAR2(8) := 'ACTIVE';
124: cst_inactive CONSTANT VARCHAR2(8) := 'INACTIVE';
125: v_other_detail VARCHAR2(255);
126: v_cal_instance_rec IGS_CA_INST%ROWTYPE;
127: v_cal_instance_rltshp_rec IGS_CA_INST_REL%ROWTYPE;
128: v_dt_alias_instance_rec IGS_CA_DA_INST_V%ROWTYPE;
129: v_new_s_cal_status IGS_CA_STAT.s_cal_status%TYPE;
130: v_old_s_cal_status IGS_CA_STAT.s_cal_status%TYPE;
131: v_s_cal_status IGS_CA_STAT.s_cal_status%TYPE;

Line 141: FROM IGS_CA_INST_REL

137: WHERE cal_status = cp_cal_status;
138: CURSOR c_cir_subord_calendars
139: IS
140: SELECT *
141: FROM IGS_CA_INST_REL
142: WHERE sup_cal_type = p_cal_type AND
143: sup_ci_sequence_number = p_sequence_number;
144: CURSOR c_cir_superior_calendars
145: IS

Line 147: FROM IGS_CA_INST_REL

143: sup_ci_sequence_number = p_sequence_number;
144: CURSOR c_cir_superior_calendars
145: IS
146: SELECT *
147: FROM IGS_CA_INST_REL
148: WHERE sub_cal_type = p_cal_type AND
149: sub_ci_sequence_number = p_sequence_number;
150: CURSOR c_dt_alias_instance
151: IS

Line 156: CURSOR c_cal_instance(cp_cal_type IGS_CA_INST.cal_type%TYPE,

152: SELECT *
153: FROM IGS_CA_DA_INST_V
154: WHERE cal_type = p_cal_type AND
155: ci_sequence_number = p_sequence_number;
156: CURSOR c_cal_instance(cp_cal_type IGS_CA_INST.cal_type%TYPE,
157: cp_sequence_number IGS_CA_INST.sequence_number%TYPE)
158: IS
159: SELECT *
160: FROM IGS_CA_INST

Line 157: cp_sequence_number IGS_CA_INST.sequence_number%TYPE)

153: FROM IGS_CA_DA_INST_V
154: WHERE cal_type = p_cal_type AND
155: ci_sequence_number = p_sequence_number;
156: CURSOR c_cal_instance(cp_cal_type IGS_CA_INST.cal_type%TYPE,
157: cp_sequence_number IGS_CA_INST.sequence_number%TYPE)
158: IS
159: SELECT *
160: FROM IGS_CA_INST
161: WHERE cal_type = cp_cal_type AND

Line 160: FROM IGS_CA_INST

156: CURSOR c_cal_instance(cp_cal_type IGS_CA_INST.cal_type%TYPE,
157: cp_sequence_number IGS_CA_INST.sequence_number%TYPE)
158: IS
159: SELECT *
160: FROM IGS_CA_INST
161: WHERE cal_type = cp_cal_type AND
162: sequence_number = cp_sequence_number;
163: -- define sub-routines
164: FUNCTION check_status_change

Line 344: cp_cal_type IGS_CA_INST.cal_type%TYPE,

340: RETURN boolean AS
341: cst_teaching_period CONSTANT VARCHAR2(15) := 'TEACHING';
342: cst_academic_period CONSTANT VARCHAR2(15) := 'ACADEMIC';
343: CURSOR c_cal_instance (
344: cp_cal_type IGS_CA_INST.cal_type%TYPE,
345: cp_cal_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
346: SELECT *
347: FROM IGS_CA_INST
348: WHERE cal_type = cp_cal_type

Line 345: cp_cal_sequence_number IGS_CA_INST.sequence_number%TYPE) IS

341: cst_teaching_period CONSTANT VARCHAR2(15) := 'TEACHING';
342: cst_academic_period CONSTANT VARCHAR2(15) := 'ACADEMIC';
343: CURSOR c_cal_instance (
344: cp_cal_type IGS_CA_INST.cal_type%TYPE,
345: cp_cal_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
346: SELECT *
347: FROM IGS_CA_INST
348: WHERE cal_type = cp_cal_type
349: AND sequence_number = cp_cal_sequence_number ;

Line 347: FROM IGS_CA_INST

343: CURSOR c_cal_instance (
344: cp_cal_type IGS_CA_INST.cal_type%TYPE,
345: cp_cal_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
346: SELECT *
347: FROM IGS_CA_INST
348: WHERE cal_type = cp_cal_type
349: AND sequence_number = cp_cal_sequence_number ;
350: CURSOR c_cal_inst_rltshp_sup(
351: cp_sub_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE,

Line 351: cp_sub_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE,

347: FROM IGS_CA_INST
348: WHERE cal_type = cp_cal_type
349: AND sequence_number = cp_cal_sequence_number ;
350: CURSOR c_cal_inst_rltshp_sup(
351: cp_sub_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE,
352: cp_sub_ci_sequence_number
353: IGS_CA_INST_REL.sup_ci_sequence_number%TYPE) IS
354: SELECT *
355: FROM IGS_CA_INST_REL

Line 353: IGS_CA_INST_REL.sup_ci_sequence_number%TYPE) IS

349: AND sequence_number = cp_cal_sequence_number ;
350: CURSOR c_cal_inst_rltshp_sup(
351: cp_sub_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE,
352: cp_sub_ci_sequence_number
353: IGS_CA_INST_REL.sup_ci_sequence_number%TYPE) IS
354: SELECT *
355: FROM IGS_CA_INST_REL
356: WHERE sub_cal_type = cp_sub_cal_type
357: AND sub_ci_sequence_number = cp_sub_ci_sequence_number;

Line 355: FROM IGS_CA_INST_REL

351: cp_sub_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE,
352: cp_sub_ci_sequence_number
353: IGS_CA_INST_REL.sup_ci_sequence_number%TYPE) IS
354: SELECT *
355: FROM IGS_CA_INST_REL
356: WHERE sub_cal_type = cp_sub_cal_type
357: AND sub_ci_sequence_number = cp_sub_ci_sequence_number;
358: CURSOR c_cal_inst_rltshp_sub(
359: cp_sup_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE,

Line 359: cp_sup_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE,

355: FROM IGS_CA_INST_REL
356: WHERE sub_cal_type = cp_sub_cal_type
357: AND sub_ci_sequence_number = cp_sub_ci_sequence_number;
358: CURSOR c_cal_inst_rltshp_sub(
359: cp_sup_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE,
360: cp_sup_ci_sequence_number
361: IGS_CA_INST_REL.sup_ci_sequence_number%TYPE) IS
362: SELECT *
363: FROM IGS_CA_INST_REL

Line 361: IGS_CA_INST_REL.sup_ci_sequence_number%TYPE) IS

357: AND sub_ci_sequence_number = cp_sub_ci_sequence_number;
358: CURSOR c_cal_inst_rltshp_sub(
359: cp_sup_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE,
360: cp_sup_ci_sequence_number
361: IGS_CA_INST_REL.sup_ci_sequence_number%TYPE) IS
362: SELECT *
363: FROM IGS_CA_INST_REL
364: WHERE sup_cal_type = cp_sup_cal_type
365: AND sup_ci_sequence_number = cp_sup_ci_sequence_number;

Line 363: FROM IGS_CA_INST_REL

359: cp_sup_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE,
360: cp_sup_ci_sequence_number
361: IGS_CA_INST_REL.sup_ci_sequence_number%TYPE) IS
362: SELECT *
363: FROM IGS_CA_INST_REL
364: WHERE sup_cal_type = cp_sup_cal_type
365: AND sup_ci_sequence_number = cp_sup_ci_sequence_number;
366: CURSOR c_cal_type(
367: cp_cal_type IGS_CA_TYPE.cal_type%TYPE)