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

Line 654: FROM IGS_CA_INST aci

650: SELECT aci.cal_type,
651: aci.sequence_number,
652: aci.start_dt,
653: aci.end_dt
654: FROM IGS_CA_INST aci
655: WHERE aci.cal_type = p_acad_cal_type AND
656: aci.sequence_number = p_acad_sequence_number;
657: v_aci_rec c_aci%ROWTYPE;
658: CURSOR c_pos ( cp_unit_set_cd IGS_AS_SU_SETATMPT.UNIT_SET_CD%TYPE ) IS

Line 755: cp_start_dt IGS_CA_INST.start_dt%TYPE) IS

751: WHERE posp.sequence_number = posu.posp_sequence_number AND
752: posu.unit_cd IS NOT NULL)
753: ORDER BY posp.acad_period_num;
754: CURSOR c_ci (
755: cp_start_dt IGS_CA_INST.start_dt%TYPE) IS
756: SELECT aci.cal_type,
757: aci.sequence_number,
758: aci.start_dt,
759: aci.end_dt

Line 760: FROM IGS_CA_INST aci,

756: SELECT aci.cal_type,
757: aci.sequence_number,
758: aci.start_dt,
759: aci.end_dt
760: FROM IGS_CA_INST aci,
761: IGS_CA_STAT cs
762: WHERE aci.cal_type = p_acad_cal_type AND
763: aci.start_dt > cp_start_dt AND
764: cs.cal_status = aci.cal_status AND

Line 769: cp_cal_type IGS_CA_INST.cal_type%TYPE,

765: cs.s_cal_status = cst_active
766: ORDER BY aci.start_dt;
767: v_ci_rec c_ci%ROWTYPE;
768: CURSOR c_ci2 (
769: cp_cal_type IGS_CA_INST.cal_type%TYPE,
770: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
771: SELECT ci.start_dt
772: FROM IGS_CA_INST ci
773: WHERE ci.cal_type = cp_cal_type AND

Line 770: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS

766: ORDER BY aci.start_dt;
767: v_ci_rec c_ci%ROWTYPE;
768: CURSOR c_ci2 (
769: cp_cal_type IGS_CA_INST.cal_type%TYPE,
770: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
771: SELECT ci.start_dt
772: FROM IGS_CA_INST ci
773: WHERE ci.cal_type = cp_cal_type AND
774: ci.sequence_number = cp_sequence_number;

Line 772: FROM IGS_CA_INST ci

768: CURSOR c_ci2 (
769: cp_cal_type IGS_CA_INST.cal_type%TYPE,
770: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
771: SELECT ci.start_dt
772: FROM IGS_CA_INST ci
773: WHERE ci.cal_type = cp_cal_type AND
774: ci.sequence_number = cp_sequence_number;
775: v_ci2_rec c_ci2%ROWTYPE;
776: CURSOR c_cir (

Line 777: cp_acad_cal_type IGS_CA_INST.cal_type%TYPE,

773: WHERE ci.cal_type = cp_cal_type AND
774: ci.sequence_number = cp_sequence_number;
775: v_ci2_rec c_ci2%ROWTYPE;
776: CURSOR c_cir (
777: cp_acad_cal_type IGS_CA_INST.cal_type%TYPE,
778: cp_acad_sequence_number IGS_CA_INST.sequence_number%TYPE,
779: cp_teach_cal_type IGS_CA_INST.cal_type%TYPE) IS
780: SELECT tci.cal_type,
781: tci.sequence_number

Line 778: cp_acad_sequence_number IGS_CA_INST.sequence_number%TYPE,

774: ci.sequence_number = cp_sequence_number;
775: v_ci2_rec c_ci2%ROWTYPE;
776: CURSOR c_cir (
777: cp_acad_cal_type IGS_CA_INST.cal_type%TYPE,
778: cp_acad_sequence_number IGS_CA_INST.sequence_number%TYPE,
779: cp_teach_cal_type IGS_CA_INST.cal_type%TYPE) IS
780: SELECT tci.cal_type,
781: tci.sequence_number
782: FROM IGS_CA_INST_REL cir,

Line 779: cp_teach_cal_type IGS_CA_INST.cal_type%TYPE) IS

775: v_ci2_rec c_ci2%ROWTYPE;
776: CURSOR c_cir (
777: cp_acad_cal_type IGS_CA_INST.cal_type%TYPE,
778: cp_acad_sequence_number IGS_CA_INST.sequence_number%TYPE,
779: cp_teach_cal_type IGS_CA_INST.cal_type%TYPE) IS
780: SELECT tci.cal_type,
781: tci.sequence_number
782: FROM IGS_CA_INST_REL cir,
783: IGS_CA_INST tci,

Line 782: FROM IGS_CA_INST_REL cir,

778: cp_acad_sequence_number IGS_CA_INST.sequence_number%TYPE,
779: cp_teach_cal_type IGS_CA_INST.cal_type%TYPE) IS
780: SELECT tci.cal_type,
781: tci.sequence_number
782: FROM IGS_CA_INST_REL cir,
783: IGS_CA_INST tci,
784: IGS_CA_TYPE cat,
785: IGS_CA_STAT cs
786: WHERE cir.sup_cal_type = cp_acad_cal_type AND

Line 783: IGS_CA_INST tci,

779: cp_teach_cal_type IGS_CA_INST.cal_type%TYPE) IS
780: SELECT tci.cal_type,
781: tci.sequence_number
782: FROM IGS_CA_INST_REL cir,
783: IGS_CA_INST tci,
784: IGS_CA_TYPE cat,
785: IGS_CA_STAT cs
786: WHERE cir.sup_cal_type = cp_acad_cal_type AND
787: sup_ci_sequence_number = cp_acad_sequence_number AND

Line 849: v_last_acad_start_dt IGS_CA_INST.start_dt%TYPE;

845: v_warn_level VARCHAR2(5) ;
846: vp_warn_level VARCHAR2(5) ;
847: v_message_name VARCHAR2(2000) ;
848: v_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE;
849: v_last_acad_start_dt IGS_CA_INST.start_dt%TYPE;
850: v_last_acad_period_num NUMBER(2) := 0;
851: v_ci_start_dt DATE;
852: v_ci_end_dt DATE;
853: v_core_only VARCHAR2(1);

Line 2194: FROM IGS_CA_INST ci

2190:
2191:
2192: CURSOR c_ci IS
2193: SELECT ci.end_dt
2194: FROM IGS_CA_INST ci
2195: WHERE ci.cal_type = p_acad_cal_type AND
2196: ci.sequence_number = p_acad_sequence_number;
2197: v_ci_end_dt IGS_CA_INST.end_dt%TYPE;
2198: BEGIN

Line 2197: v_ci_end_dt IGS_CA_INST.end_dt%TYPE;

2193: SELECT ci.end_dt
2194: FROM IGS_CA_INST ci
2195: WHERE ci.cal_type = p_acad_cal_type AND
2196: ci.sequence_number = p_acad_sequence_number;
2197: v_ci_end_dt IGS_CA_INST.end_dt%TYPE;
2198: BEGIN
2199: -- Set the default message number
2200: p_message_name := NULL;
2201: -- Select the type of HECS option from the hecs_payment_option table

Line 2561: l_acad_cal_type igs_ca_inst.cal_type%TYPE;

2557: WHERE person_id = p_person_id
2558: AND course_cd = p_program_cd;
2559:
2560: l_ps_att_dtls_rec c_ps_att_dtls%ROWTYPE;
2561: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
2562: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
2563:
2564: CURSOR c_pos ( cp_unit_set_cd IGS_AS_SU_SETATMPT.UNIT_SET_CD%TYPE ) IS
2565: SELECT pos.cal_type,

Line 2562: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;

2558: AND course_cd = p_program_cd;
2559:
2560: l_ps_att_dtls_rec c_ps_att_dtls%ROWTYPE;
2561: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
2562: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
2563:
2564: CURSOR c_pos ( cp_unit_set_cd IGS_AS_SU_SETATMPT.UNIT_SET_CD%TYPE ) IS
2565: SELECT pos.cal_type,
2566: pos.sequence_number,

Line 2688: FROM igs_ca_inst aci

2684: SELECT aci.cal_type,
2685: aci.sequence_number,
2686: aci.start_dt,
2687: aci.end_dt
2688: FROM igs_ca_inst aci
2689: WHERE aci.cal_type = l_acad_cal_type AND
2690: aci.sequence_number = l_acad_ci_sequence_number;
2691: l_aci_rec c_aci%ROWTYPE;
2692:

Line 2995: l_acad_cal_type igs_ca_inst.cal_type%TYPE;

2991: WHERE coo_id = p_coo_id;
2992:
2993:
2994: l_ps_att_dtls_rec c_ps_att_dtls%ROWTYPE;
2995: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
2996: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
2997:
2998: CURSOR c_pos ( cp_unit_set_cd IGS_AS_SU_SETATMPT.UNIT_SET_CD%TYPE ) IS
2999: SELECT pos.cal_type,

Line 2996: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;

2992:
2993:
2994: l_ps_att_dtls_rec c_ps_att_dtls%ROWTYPE;
2995: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
2996: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
2997:
2998: CURSOR c_pos ( cp_unit_set_cd IGS_AS_SU_SETATMPT.UNIT_SET_CD%TYPE ) IS
2999: SELECT pos.cal_type,
3000: pos.sequence_number,

Line 3123: FROM igs_ca_inst aci

3119: SELECT aci.cal_type,
3120: aci.sequence_number,
3121: aci.start_dt,
3122: aci.end_dt
3123: FROM igs_ca_inst aci
3124: WHERE aci.cal_type = l_acad_cal_type AND
3125: aci.sequence_number = l_acad_ci_sequence_number;
3126: l_aci_rec c_aci%ROWTYPE;
3127: