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_GEN_008 dependencies on IGS_CA_TYPE

Line 758: p_adm_cal_type IN OUT NOCOPY igs_ca_type.cal_type%TYPE,

754: App_Exception.Raise_Exception;
755: END admp_get_sys_aas;
756:
757: PROCEDURE get_acad_cal (
758: p_adm_cal_type IN OUT NOCOPY igs_ca_type.cal_type%TYPE,
759: p_adm_seq IN OUT NOCOPY igs_ca_inst.sequence_number%TYPE,
760: p_acad_cal_type OUT NOCOPY igs_ca_type.cal_type%TYPE,
761: p_acad_seq OUT NOCOPY igs_ca_inst.sequence_number%TYPE,
762: p_adm_alternate_code OUT NOCOPY igs_ca_inst.alternate_code%TYPE,

Line 760: p_acad_cal_type OUT NOCOPY igs_ca_type.cal_type%TYPE,

756:
757: PROCEDURE get_acad_cal (
758: p_adm_cal_type IN OUT NOCOPY igs_ca_type.cal_type%TYPE,
759: p_adm_seq IN OUT NOCOPY igs_ca_inst.sequence_number%TYPE,
760: p_acad_cal_type OUT NOCOPY igs_ca_type.cal_type%TYPE,
761: p_acad_seq OUT NOCOPY igs_ca_inst.sequence_number%TYPE,
762: p_adm_alternate_code OUT NOCOPY igs_ca_inst.alternate_code%TYPE,
763: p_message OUT NOCOPY VARCHAR2
764: )

Line 791: CURSOR cur_sequence (cp_cal_type igs_ca_type.cal_type%TYPE)

787:
788: -- Cursor for getting the Calendar Sequence for the
789: -- Calendar Type. The Calendar Instance Selected for this calendar
790: -- should be the nearest one to the System Date
791: CURSOR cur_sequence (cp_cal_type igs_ca_type.cal_type%TYPE)
792: IS
793: SELECT ci_adm.sequence_number adm_sequence_number,
794: ci_acad.cal_type acad_cal_type,
795: ci_acad.sequence_number acad_sequence_number,

Line 797: FROM igs_ca_type ct_adm,

793: SELECT ci_adm.sequence_number adm_sequence_number,
794: ci_acad.cal_type acad_cal_type,
795: ci_acad.sequence_number acad_sequence_number,
796: ci_adm.alternate_code adm_alternate_code
797: FROM igs_ca_type ct_adm,
798: igs_ca_inst ci_adm,
799: igs_ca_stat cs,
800: igs_ca_inst_rel cir,
801: igs_ca_inst ci_acad,

Line 802: igs_ca_type ct_acad

798: igs_ca_inst ci_adm,
799: igs_ca_stat cs,
800: igs_ca_inst_rel cir,
801: igs_ca_inst ci_acad,
802: igs_ca_type ct_acad
803: WHERE ct_adm.cal_type = cp_cal_type
804: AND ct_adm.cal_type = ci_adm.cal_type
805: AND SYSDATE <= ci_adm.end_dt
806: AND ct_adm.s_cal_cat = 'ADMISSION'