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_ACAIU dependencies on IGS_AD_APPL

Line 18: v_s_adm_appl_status IGS_AD_APPL_STAT.s_adm_appl_status%TYPE;

14: BEGIN -- admp_val_acaiu_iud
15: -- This modules validates the insert/update/delete of
16: -- IGS_AD_PS_APLINSTUNT.
17: DECLARE
18: v_s_adm_appl_status IGS_AD_APPL_STAT.s_adm_appl_status%TYPE;
19: v_s_adm_outcome_status IGS_AD_OU_STAT.s_adm_outcome_status%TYPE;
20: CURSOR c_aa_aas IS
21: SELECT aas.s_adm_appl_status
22: FROM IGS_AD_APPL aa,

Line 22: FROM IGS_AD_APPL aa,

18: v_s_adm_appl_status IGS_AD_APPL_STAT.s_adm_appl_status%TYPE;
19: v_s_adm_outcome_status IGS_AD_OU_STAT.s_adm_outcome_status%TYPE;
20: CURSOR c_aa_aas IS
21: SELECT aas.s_adm_appl_status
22: FROM IGS_AD_APPL aa,
23: IGS_AD_APPL_STAT aas
24: WHERE
25: aa.person_id = p_person_id AND
26: aa.admission_appl_number= p_admission_appl_number AND

Line 23: IGS_AD_APPL_STAT aas

19: v_s_adm_outcome_status IGS_AD_OU_STAT.s_adm_outcome_status%TYPE;
20: CURSOR c_aa_aas IS
21: SELECT aas.s_adm_appl_status
22: FROM IGS_AD_APPL aa,
23: IGS_AD_APPL_STAT aas
24: WHERE
25: aa.person_id = p_person_id AND
26: aa.admission_appl_number= p_admission_appl_number AND
27: aa.adm_appl_status = aas.adm_appl_status;

Line 104: cp_acad_cal_type IGS_AD_APPL.acad_cal_type%TYPE,

100: v_message_name VARCHAR2(30);
101: CURSOR c_cir_1 (
102: cp_unit_cd IGS_AD_PS_APLINSTUNT.unit_cd%TYPE,
103: cp_uv_version_number IGS_AD_PS_APLINSTUNT.uv_version_number%TYPE,
104: cp_acad_cal_type IGS_AD_APPL.acad_cal_type%TYPE,
105: cp_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE) IS
106: SELECT DISTINCT uoo.cal_type,
107: uoo.ci_sequence_number
108: FROM IGS_PS_UNIT_OFR_OPT uoo,

Line 105: cp_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE) IS

101: CURSOR c_cir_1 (
102: cp_unit_cd IGS_AD_PS_APLINSTUNT.unit_cd%TYPE,
103: cp_uv_version_number IGS_AD_PS_APLINSTUNT.uv_version_number%TYPE,
104: cp_acad_cal_type IGS_AD_APPL.acad_cal_type%TYPE,
105: cp_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE) IS
106: SELECT DISTINCT uoo.cal_type,
107: uoo.ci_sequence_number
108: FROM IGS_PS_UNIT_OFR_OPT uoo,
109: IGS_CA_INST_REL cir

Line 118: cp_adm_cal_type IGS_AD_APPL.acad_cal_type%TYPE,

114: cir.sub_ci_sequence_number = uoo.ci_sequence_number AND
115: cir.sup_cal_type = cp_acad_cal_type AND
116: cir.sup_ci_sequence_number = cp_acad_ci_sequence_number;
117: CURSOR c_cir_2 (
118: cp_adm_cal_type IGS_AD_APPL.acad_cal_type%TYPE,
119: cp_adm_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE,
120: cp_sup_cal_type IGS_AD_APPL.acad_cal_type%TYPE,
121: cp_sup_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE) IS
122: SELECT 'x'

Line 119: cp_adm_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE,

115: cir.sup_cal_type = cp_acad_cal_type AND
116: cir.sup_ci_sequence_number = cp_acad_ci_sequence_number;
117: CURSOR c_cir_2 (
118: cp_adm_cal_type IGS_AD_APPL.acad_cal_type%TYPE,
119: cp_adm_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE,
120: cp_sup_cal_type IGS_AD_APPL.acad_cal_type%TYPE,
121: cp_sup_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE) IS
122: SELECT 'x'
123: FROM IGS_CA_INST_REL cir

Line 120: cp_sup_cal_type IGS_AD_APPL.acad_cal_type%TYPE,

116: cir.sup_ci_sequence_number = cp_acad_ci_sequence_number;
117: CURSOR c_cir_2 (
118: cp_adm_cal_type IGS_AD_APPL.acad_cal_type%TYPE,
119: cp_adm_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE,
120: cp_sup_cal_type IGS_AD_APPL.acad_cal_type%TYPE,
121: cp_sup_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE) IS
122: SELECT 'x'
123: FROM IGS_CA_INST_REL cir
124: WHERE cir.sub_cal_type = cp_adm_cal_type AND

Line 121: cp_sup_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE) IS

117: CURSOR c_cir_2 (
118: cp_adm_cal_type IGS_AD_APPL.acad_cal_type%TYPE,
119: cp_adm_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE,
120: cp_sup_cal_type IGS_AD_APPL.acad_cal_type%TYPE,
121: cp_sup_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE) IS
122: SELECT 'x'
123: FROM IGS_CA_INST_REL cir
124: WHERE cir.sub_cal_type = cp_adm_cal_type AND
125: cir.sub_ci_sequence_number = cp_adm_ci_sequence_number AND

Line 226: v_cal_type IGS_AD_APPL.adm_cal_type%TYPE,

222: v_val_ind_type_offer NUMBER;
223: ------------------------------SUB-FUNCTION-------------------------------------
224: ----------
225: FUNCTION admpl_val_offer_optn(
226: v_cal_type IGS_AD_APPL.adm_cal_type%TYPE,
227: v_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE,
228: v_val_ind_type_offer OUT NOCOPY NUMBER)
229: RETURN BOOLEAN
230: AS

Line 227: v_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE,

223: ------------------------------SUB-FUNCTION-------------------------------------
224: ----------
225: FUNCTION admpl_val_offer_optn(
226: v_cal_type IGS_AD_APPL.adm_cal_type%TYPE,
227: v_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE,
228: v_val_ind_type_offer OUT NOCOPY NUMBER)
229: RETURN BOOLEAN
230: AS
231: BEGIN -- admpl_val_off_optn

Line 235: cp_cal_type IGS_AD_APPL.adm_cal_type%TYPE,

231: BEGIN -- admpl_val_off_optn
232: -- Validate unit offering option (if uoo.offered_ind = 'Y')
233: DECLARE
234: CURSOR c_uoo(
235: cp_cal_type IGS_AD_APPL.adm_cal_type%TYPE,
236: cp_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE) IS
237: SELECT uoo.offered_ind,
238: uoo.unit_class
239: FROM IGS_PS_UNIT_OFR_OPT uoo

Line 236: cp_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE) IS

232: -- Validate unit offering option (if uoo.offered_ind = 'Y')
233: DECLARE
234: CURSOR c_uoo(
235: cp_cal_type IGS_AD_APPL.adm_cal_type%TYPE,
236: cp_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE) IS
237: SELECT uoo.offered_ind,
238: uoo.unit_class
239: FROM IGS_PS_UNIT_OFR_OPT uoo
240: WHERE uoo.unit_cd = p_unit_cd AND

Line 800: cp_cal_type IGS_AD_APPL.adm_cal_type%TYPE,

796: cs.cal_status = ci.cal_status AND
797: cat.s_cal_cat = cst_teaching AND
798: ci.cal_status = cs.cal_status;
799: CURSOR c_cir_cat(
800: cp_cal_type IGS_AD_APPL.adm_cal_type%TYPE,
801: cp_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE) IS
802: SELECT 'x'
803: FROM IGS_CA_INST_REL cir,
804: IGS_CA_TYPE cat

Line 801: cp_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE) IS

797: cat.s_cal_cat = cst_teaching AND
798: ci.cal_status = cs.cal_status;
799: CURSOR c_cir_cat(
800: cp_cal_type IGS_AD_APPL.adm_cal_type%TYPE,
801: cp_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE) IS
802: SELECT 'x'
803: FROM IGS_CA_INST_REL cir,
804: IGS_CA_TYPE cat
805: WHERE cir.sub_cal_type = p_adm_cal_type AND

Line 810: cp_cal_type IGS_AD_APPL.adm_cal_type%TYPE,

806: cir.sub_ci_sequence_number = p_adm_ci_sequence_number AND
807: cir.sup_cal_type = cp_cal_type AND
808: cir.sup_ci_sequence_number = cp_sequence_number;
809: CURSOR c_uoo (
810: cp_cal_type IGS_AD_APPL.adm_cal_type%TYPE,
811: cp_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE) IS
812: SELECT 'x'
813: FROM IGS_PS_UNIT_OFR_OPT uoo
814: WHERE uoo.unit_cd = p_unit_cd AND

Line 811: cp_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE) IS

807: cir.sup_cal_type = cp_cal_type AND
808: cir.sup_ci_sequence_number = cp_sequence_number;
809: CURSOR c_uoo (
810: cp_cal_type IGS_AD_APPL.adm_cal_type%TYPE,
811: cp_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE) IS
812: SELECT 'x'
813: FROM IGS_PS_UNIT_OFR_OPT uoo
814: WHERE uoo.unit_cd = p_unit_cd AND
815: uoo.version_number = p_uv_version_number AND