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_TYPE

Line 57: v_s_cal_cat IGS_CA_TYPE.s_cal_cat%TYPE;

53: cst_admission CONSTANT VARCHAR2(10) := 'ADMISSION';
54: cst_progress CONSTANT VARCHAR2(10) := 'PROGRESS';
55: cst_award CONSTANT VARCHAR2(10) := 'AWARD';
56: cst_load CONSTANT VARCHAR2(10) := 'LOAD';
57: v_s_cal_cat IGS_CA_TYPE.s_cal_cat%TYPE;
58: CURSOR c_cal_type (
59: cp_cal_type IGS_CA_TYPE.cal_type%TYPE) IS
60: SELECT CAT.s_cal_cat
61: FROM IGS_CA_TYPE CAT

Line 59: cp_cal_type IGS_CA_TYPE.cal_type%TYPE) IS

55: cst_award CONSTANT VARCHAR2(10) := 'AWARD';
56: cst_load CONSTANT VARCHAR2(10) := 'LOAD';
57: v_s_cal_cat IGS_CA_TYPE.s_cal_cat%TYPE;
58: CURSOR c_cal_type (
59: cp_cal_type IGS_CA_TYPE.cal_type%TYPE) IS
60: SELECT CAT.s_cal_cat
61: FROM IGS_CA_TYPE CAT
62: WHERE CAT.cal_type = cp_cal_type;
63: BEGIN

Line 61: FROM IGS_CA_TYPE CAT

57: v_s_cal_cat IGS_CA_TYPE.s_cal_cat%TYPE;
58: CURSOR c_cal_type (
59: cp_cal_type IGS_CA_TYPE.cal_type%TYPE) IS
60: SELECT CAT.s_cal_cat
61: FROM IGS_CA_TYPE CAT
62: WHERE CAT.cal_type = cp_cal_type;
63: BEGIN
64: -- Module to validate that alternate code is given for calendar instances whose
65: -- calendar type has system calendar categories 'ACADEMIC', 'TEACHING',

Line 367: cp_cal_type IGS_CA_TYPE.cal_type%TYPE)

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)
368: IS
369: SELECT *
370: FROM IGS_CA_TYPE
371: WHERE cal_type = cp_cal_type

Line 370: FROM IGS_CA_TYPE

366: CURSOR c_cal_type(
367: cp_cal_type IGS_CA_TYPE.cal_type%TYPE)
368: IS
369: SELECT *
370: FROM IGS_CA_TYPE
371: WHERE cal_type = cp_cal_type
372: AND s_cal_cat = cst_academic_period;
373: CURSOR c_cal_typ(
374: cp_cal_type IGS_CA_TYPE.cal_type%TYPE)

Line 374: cp_cal_type IGS_CA_TYPE.cal_type%TYPE)

370: FROM IGS_CA_TYPE
371: WHERE cal_type = cp_cal_type
372: AND s_cal_cat = cst_academic_period;
373: CURSOR c_cal_typ(
374: cp_cal_type IGS_CA_TYPE.cal_type%TYPE)
375: IS
376: SELECT *
377: FROM IGS_CA_TYPE
378: WHERE cal_type = cp_cal_type

Line 377: FROM IGS_CA_TYPE

373: CURSOR c_cal_typ(
374: cp_cal_type IGS_CA_TYPE.cal_type%TYPE)
375: IS
376: SELECT *
377: FROM IGS_CA_TYPE
378: WHERE cal_type = cp_cal_type
379: AND s_cal_cat = cst_teaching_period;
380: v_other_detail VARCHAR2(255);
381: BEGIN