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_GE_VAL_PARAM dependencies on IGS_GE_DATE

Line 802: IGS_GE_DATE.igschar(ci.start_dt) || ' - ' ||

798: -- Local Cursors
799: CURSOR c_cal(cp_s_cal_cat IN IGS_CA_TYPE.s_cal_cat%TYPE)
800: IS
801: SELECT RPAD(RPAD(NVL(ci.alternate_code, ci.cal_type), 10) || ' ' ||
802: IGS_GE_DATE.igschar(ci.start_dt) || ' - ' ||
803: IGS_GE_DATE.igschar(ci.end_dt) || ' ' || ct.abbreviation, 100) ||
804: RPAD(ci.cal_type, 10) ||
805: TO_CHAR(ci.sequence_number, '999990') cal_desc
806: FROM IGS_CA_TYPE ct,

Line 803: IGS_GE_DATE.igschar(ci.end_dt) || ' ' || ct.abbreviation, 100) ||

799: CURSOR c_cal(cp_s_cal_cat IN IGS_CA_TYPE.s_cal_cat%TYPE)
800: IS
801: SELECT RPAD(RPAD(NVL(ci.alternate_code, ci.cal_type), 10) || ' ' ||
802: IGS_GE_DATE.igschar(ci.start_dt) || ' - ' ||
803: IGS_GE_DATE.igschar(ci.end_dt) || ' ' || ct.abbreviation, 100) ||
804: RPAD(ci.cal_type, 10) ||
805: TO_CHAR(ci.sequence_number, '999990') cal_desc
806: FROM IGS_CA_TYPE ct,
807: IGS_CA_INST ci,

Line 861: IGS_GE_DATE.igschar(ci.start_dt) || ' - ' ||

857: CURSOR c_cal(cp_cal_type IN IGS_CA_TYPE.cal_type%TYPE,
858: cp_seq_num IN IGS_CA_INST.sequence_number%TYPE)
859: IS
860: SELECT RPAD(RPAD(NVL(ci.alternate_code, ci.cal_type), 10) || ' ' ||
861: IGS_GE_DATE.igschar(ci.start_dt) || ' - ' ||
862: IGS_GE_DATE.igschar(ci.end_dt) || ' ' || ct.abbreviation, 100) ||
863: RPAD(ci.cal_type, 10) ||
864: TO_CHAR(ci.sequence_number, '999990') cal_desc
865: FROM IGS_CA_TYPE ct,

Line 862: IGS_GE_DATE.igschar(ci.end_dt) || ' ' || ct.abbreviation, 100) ||

858: cp_seq_num IN IGS_CA_INST.sequence_number%TYPE)
859: IS
860: SELECT RPAD(RPAD(NVL(ci.alternate_code, ci.cal_type), 10) || ' ' ||
861: IGS_GE_DATE.igschar(ci.start_dt) || ' - ' ||
862: IGS_GE_DATE.igschar(ci.end_dt) || ' ' || ct.abbreviation, 100) ||
863: RPAD(ci.cal_type, 10) ||
864: TO_CHAR(ci.sequence_number, '999990') cal_desc
865: FROM IGS_CA_TYPE ct,
866: IGS_CA_INST ci

Line 903: IGS_GE_DATE.igschar(ci.start_dt) || ' - ' ||

899: CURSOR c_cal(cp_cal_type IN IGS_CA_TYPE.cal_type%TYPE,
900: cp_seq_num IN IGS_CA_INST.sequence_number%TYPE)
901: IS
902: SELECT RPAD(RPAD(NVL(ci.alternate_code, ci.cal_type), 10) || ' ' ||
903: IGS_GE_DATE.igschar(ci.start_dt) || ' - ' ||
904: IGS_GE_DATE.igschar(ci.end_dt) || ' ' || ct.abbreviation, 100) ||
905: RPAD(ci.cal_type, 10) ||
906: TO_CHAR(ci.sequence_number, '999990') cal_desc
907: FROM IGS_CA_TYPE ct,

Line 904: IGS_GE_DATE.igschar(ci.end_dt) || ' ' || ct.abbreviation, 100) ||

900: cp_seq_num IN IGS_CA_INST.sequence_number%TYPE)
901: IS
902: SELECT RPAD(RPAD(NVL(ci.alternate_code, ci.cal_type), 10) || ' ' ||
903: IGS_GE_DATE.igschar(ci.start_dt) || ' - ' ||
904: IGS_GE_DATE.igschar(ci.end_dt) || ' ' || ct.abbreviation, 100) ||
905: RPAD(ci.cal_type, 10) ||
906: TO_CHAR(ci.sequence_number, '999990') cal_desc
907: FROM IGS_CA_TYPE ct,
908: IGS_CA_INST ci