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_INS_ROLL_CI dependencies on IGS_CA_INST_SEQ_NUM_S1

Line 22: (igs_ca_inst_seq_num_s1) to make it unique

18: For calendars load , teaching and academic the alternate
19: code is made unique . In rollover the alternate code of the
20: previous calendar and the rolled over calendar was retained same
21: now the alternate code is appended with sequence number
22: (igs_ca_inst_seq_num_s1) to make it unique
23: asbala 9-Feb-2004 ENCR039: New column TERM_INSTRUCTION_TIME of table IGS_CA_INST will also be rolled
24: over when the calendar is rolled over.
25: nsidnaa 9/21/2004 New function added to rollover retention schedules for a teaching calendar.
26: skpandey 4-AUG-2005 BUG : 4356272

Line 2184: SELECT igs_ca_inst_seq_num_s1.nextval from DUAL;

2180: FROM DUAL;
2181:
2182: -- Sequence to get unique value for alternate codes bug - 2563531
2183: CURSOR alt_uniq_seq IS
2184: SELECT igs_ca_inst_seq_num_s1.nextval from DUAL;
2185: -- cursor to check whether the alternate code for academic calendar instance is already present.
2186: CURSOR alt_code_unique(p_alternate_code IGS_CA_INST.ALTERNATE_CODE%TYPE) IS
2187: SELECT count(*)
2188: FROM IGS_CA_INST CI , IGS_CA_TYPE CAT