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

Line 1598: PROCEDURE get_acad_cal(p_adm_cal_type IN igs_ca_type.cal_type%TYPE,

1594: END transfer_attachment;
1595:
1596: --Procedure sent from HQ to be added
1597: -----------------------------------
1598: PROCEDURE get_acad_cal(p_adm_cal_type IN igs_ca_type.cal_type%TYPE,
1599: p_adm_seq IN OUT NOCOPY igs_ca_inst.sequence_number%TYPE,
1600: p_acad_cal_type OUT NOCOPY igs_ca_type.cal_type%TYPE,
1601: p_acad_seq OUT NOCOPY igs_ca_inst.sequence_number%TYPE) AS
1602: l_message fnd_new_messages.message_name%TYPE;

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

1596: --Procedure sent from HQ to be added
1597: -----------------------------------
1598: PROCEDURE get_acad_cal(p_adm_cal_type IN igs_ca_type.cal_type%TYPE,
1599: p_adm_seq IN OUT NOCOPY igs_ca_inst.sequence_number%TYPE,
1600: p_acad_cal_type OUT NOCOPY igs_ca_type.cal_type%TYPE,
1601: p_acad_seq OUT NOCOPY igs_ca_inst.sequence_number%TYPE) AS
1602: l_message fnd_new_messages.message_name%TYPE;
1603: l_start_dt DATE;
1604: l_end_dt DATE;

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

1606:
1607: -- Cursor for getting the Calendar Sequence for the
1608: -- Calendar Type. The Calendar Instance Selected for this calendar
1609: -- should be the nearest one to the System Date
1610: CURSOR cur_sequence(cp_cal_type igs_ca_type.cal_type%TYPE) IS
1611: SELECT ci_adm.sequence_number adm_sequence_number,
1612: ci_acad.cal_type acad_cal_type,
1613: ci_acad.sequence_number acad_sequence_number
1614: FROM igs_ca_type ct_adm,

Line 1614: FROM igs_ca_type ct_adm,

1610: CURSOR cur_sequence(cp_cal_type igs_ca_type.cal_type%TYPE) IS
1611: SELECT ci_adm.sequence_number adm_sequence_number,
1612: ci_acad.cal_type acad_cal_type,
1613: ci_acad.sequence_number acad_sequence_number
1614: FROM igs_ca_type ct_adm,
1615: igs_ca_inst ci_adm,
1616: igs_ca_stat cs,
1617: igs_ca_inst_rel cir,
1618: igs_ca_inst ci_acad,

Line 1619: igs_ca_type ct_acad

1615: igs_ca_inst ci_adm,
1616: igs_ca_stat cs,
1617: igs_ca_inst_rel cir,
1618: igs_ca_inst ci_acad,
1619: igs_ca_type ct_acad
1620: WHERE ct_adm.cal_type = cp_cal_type
1621: AND ct_adm.cal_type = ci_adm.cal_type
1622: AND SYSDATE <= ci_adm.end_dt
1623: AND ct_adm.s_cal_cat = 'ADMISSION'