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

Line 227: 'START_DT', IGS_GE_DATE.igscharDT(ush.start_dt),

223: CURSOR c_ush IS
224: SELECT DECODE (p_column_name,
225: 'UNIT_SET_STATUS', ush.UNIT_SET_STATUS,
226: 'UNIT_SET_CAT', ush.UNIT_SET_CAT,
227: 'START_DT', IGS_GE_DATE.igscharDT(ush.start_dt),
228: 'REVIEW_DT', IGS_GE_DATE.igscharDT(ush.review_dt),
229: 'EXPIRY_DT', IGS_GE_DATE.igscharDT(ush.expiry_dt),
230: 'END_DT', IGS_GE_DATE.igscharDT(ush.end_dt),
231: 'TITLE', ush.TITLE,

Line 228: 'REVIEW_DT', IGS_GE_DATE.igscharDT(ush.review_dt),

224: SELECT DECODE (p_column_name,
225: 'UNIT_SET_STATUS', ush.UNIT_SET_STATUS,
226: 'UNIT_SET_CAT', ush.UNIT_SET_CAT,
227: 'START_DT', IGS_GE_DATE.igscharDT(ush.start_dt),
228: 'REVIEW_DT', IGS_GE_DATE.igscharDT(ush.review_dt),
229: 'EXPIRY_DT', IGS_GE_DATE.igscharDT(ush.expiry_dt),
230: 'END_DT', IGS_GE_DATE.igscharDT(ush.end_dt),
231: 'TITLE', ush.TITLE,
232: 'SHORT_TITLE', ush.short_title,

Line 229: 'EXPIRY_DT', IGS_GE_DATE.igscharDT(ush.expiry_dt),

225: 'UNIT_SET_STATUS', ush.UNIT_SET_STATUS,
226: 'UNIT_SET_CAT', ush.UNIT_SET_CAT,
227: 'START_DT', IGS_GE_DATE.igscharDT(ush.start_dt),
228: 'REVIEW_DT', IGS_GE_DATE.igscharDT(ush.review_dt),
229: 'EXPIRY_DT', IGS_GE_DATE.igscharDT(ush.expiry_dt),
230: 'END_DT', IGS_GE_DATE.igscharDT(ush.end_dt),
231: 'TITLE', ush.TITLE,
232: 'SHORT_TITLE', ush.short_title,
233: 'ABBREVIATION', ush.abbreviation,

Line 230: 'END_DT', IGS_GE_DATE.igscharDT(ush.end_dt),

226: 'UNIT_SET_CAT', ush.UNIT_SET_CAT,
227: 'START_DT', IGS_GE_DATE.igscharDT(ush.start_dt),
228: 'REVIEW_DT', IGS_GE_DATE.igscharDT(ush.review_dt),
229: 'EXPIRY_DT', IGS_GE_DATE.igscharDT(ush.expiry_dt),
230: 'END_DT', IGS_GE_DATE.igscharDT(ush.end_dt),
231: 'TITLE', ush.TITLE,
232: 'SHORT_TITLE', ush.short_title,
233: 'ABBREVIATION', ush.abbreviation,
234: 'RESPONSIBLE_ORG_UNIT_CD', ush.responsible_org_unit_cd,

Line 235: 'RESPONSIBLE_OU_START_DT', IGS_GE_DATE.igscharDT(ush.responsible_ou_start_dt),

231: 'TITLE', ush.TITLE,
232: 'SHORT_TITLE', ush.short_title,
233: 'ABBREVIATION', ush.abbreviation,
234: 'RESPONSIBLE_ORG_UNIT_CD', ush.responsible_org_unit_cd,
235: 'RESPONSIBLE_OU_START_DT', IGS_GE_DATE.igscharDT(ush.responsible_ou_start_dt),
236: 'OU_DESCRIPTION', ush.ou_description,
237: 'ADMINISTRATIVE_IND', ush.administrative_ind,
238: 'AUTHORISATION_RQRD_IND', ush.authorisation_rqrd_ind)
239: FROM IGS_EN_UNIT_SET_HIST ush

Line 246: 'START_DT', IGS_GE_DATE.igscharDT(ush.start_dt),

242: ush.hist_start_dt >= p_hist_end_dt AND
243: DECODE (p_column_name,
244: 'UNIT_SET_STATUS', ush.UNIT_SET_STATUS,
245: 'UNIT_SET_CAT', ush.UNIT_SET_CAT,
246: 'START_DT', IGS_GE_DATE.igscharDT(ush.start_dt),
247: 'REVIEW_DT', IGS_GE_DATE.igscharDT(ush.review_dt),
248: 'EXPIRY_DT', IGS_GE_DATE.igscharDT(ush.expiry_dt),
249: 'END_DT', IGS_GE_DATE.igscharDT(ush.end_dt),
250: 'TITLE', ush.TITLE,

Line 247: 'REVIEW_DT', IGS_GE_DATE.igscharDT(ush.review_dt),

243: DECODE (p_column_name,
244: 'UNIT_SET_STATUS', ush.UNIT_SET_STATUS,
245: 'UNIT_SET_CAT', ush.UNIT_SET_CAT,
246: 'START_DT', IGS_GE_DATE.igscharDT(ush.start_dt),
247: 'REVIEW_DT', IGS_GE_DATE.igscharDT(ush.review_dt),
248: 'EXPIRY_DT', IGS_GE_DATE.igscharDT(ush.expiry_dt),
249: 'END_DT', IGS_GE_DATE.igscharDT(ush.end_dt),
250: 'TITLE', ush.TITLE,
251: 'SHORT_TITLE', ush.short_title,

Line 248: 'EXPIRY_DT', IGS_GE_DATE.igscharDT(ush.expiry_dt),

244: 'UNIT_SET_STATUS', ush.UNIT_SET_STATUS,
245: 'UNIT_SET_CAT', ush.UNIT_SET_CAT,
246: 'START_DT', IGS_GE_DATE.igscharDT(ush.start_dt),
247: 'REVIEW_DT', IGS_GE_DATE.igscharDT(ush.review_dt),
248: 'EXPIRY_DT', IGS_GE_DATE.igscharDT(ush.expiry_dt),
249: 'END_DT', IGS_GE_DATE.igscharDT(ush.end_dt),
250: 'TITLE', ush.TITLE,
251: 'SHORT_TITLE', ush.short_title,
252: 'ABBREVIATION', ush.abbreviation,

Line 249: 'END_DT', IGS_GE_DATE.igscharDT(ush.end_dt),

245: 'UNIT_SET_CAT', ush.UNIT_SET_CAT,
246: 'START_DT', IGS_GE_DATE.igscharDT(ush.start_dt),
247: 'REVIEW_DT', IGS_GE_DATE.igscharDT(ush.review_dt),
248: 'EXPIRY_DT', IGS_GE_DATE.igscharDT(ush.expiry_dt),
249: 'END_DT', IGS_GE_DATE.igscharDT(ush.end_dt),
250: 'TITLE', ush.TITLE,
251: 'SHORT_TITLE', ush.short_title,
252: 'ABBREVIATION', ush.abbreviation,
253: 'RESPONSIBLE_ORG_UNIT_CD', ush.responsible_org_unit_cd,

Line 254: 'RESPONSIBLE_OU_START_DT', IGS_GE_DATE.igscharDT(ush.responsible_ou_start_dt),

250: 'TITLE', ush.TITLE,
251: 'SHORT_TITLE', ush.short_title,
252: 'ABBREVIATION', ush.abbreviation,
253: 'RESPONSIBLE_ORG_UNIT_CD', ush.responsible_org_unit_cd,
254: 'RESPONSIBLE_OU_START_DT', IGS_GE_DATE.igscharDT(ush.responsible_ou_start_dt),
255: 'OU_DESCRIPTION', ush.ou_description,
256: 'ADMINISTRATIVE_IND', ush.administrative_ind,
257: 'AUTHORISATION_RQRD_IND', ush.authorisation_rqrd_ind) IS NOT NULL
258: ORDER BY ush.hist_start_dt;

Line 374: cst_start_dt, IGS_GE_DATE.igscharDT(uvh.start_dt),

370: l_c_billing_hrs VARCHAR2(30) := 'BILLING_HRS';
371:
372: CURSOR c_uvh IS
373: SELECT DECODE (p_column_name,
374: cst_start_dt, IGS_GE_DATE.igscharDT(uvh.start_dt),
375: cst_review_dt, IGS_GE_DATE.igscharDT(uvh.review_dt),
376: cst_expiry_dt, IGS_GE_DATE.igscharDT(uvh.expiry_dt),
377: cst_end_dt, IGS_GE_DATE.igscharDT(uvh.end_dt),
378: cst_unit_status, uvh.UNIT_STATUS,

Line 375: cst_review_dt, IGS_GE_DATE.igscharDT(uvh.review_dt),

371:
372: CURSOR c_uvh IS
373: SELECT DECODE (p_column_name,
374: cst_start_dt, IGS_GE_DATE.igscharDT(uvh.start_dt),
375: cst_review_dt, IGS_GE_DATE.igscharDT(uvh.review_dt),
376: cst_expiry_dt, IGS_GE_DATE.igscharDT(uvh.expiry_dt),
377: cst_end_dt, IGS_GE_DATE.igscharDT(uvh.end_dt),
378: cst_unit_status, uvh.UNIT_STATUS,
379: cst_title, uvh.TITLE,

Line 376: cst_expiry_dt, IGS_GE_DATE.igscharDT(uvh.expiry_dt),

372: CURSOR c_uvh IS
373: SELECT DECODE (p_column_name,
374: cst_start_dt, IGS_GE_DATE.igscharDT(uvh.start_dt),
375: cst_review_dt, IGS_GE_DATE.igscharDT(uvh.review_dt),
376: cst_expiry_dt, IGS_GE_DATE.igscharDT(uvh.expiry_dt),
377: cst_end_dt, IGS_GE_DATE.igscharDT(uvh.end_dt),
378: cst_unit_status, uvh.UNIT_STATUS,
379: cst_title, uvh.TITLE,
380: cst_short_title, uvh.short_title,

Line 377: cst_end_dt, IGS_GE_DATE.igscharDT(uvh.end_dt),

373: SELECT DECODE (p_column_name,
374: cst_start_dt, IGS_GE_DATE.igscharDT(uvh.start_dt),
375: cst_review_dt, IGS_GE_DATE.igscharDT(uvh.review_dt),
376: cst_expiry_dt, IGS_GE_DATE.igscharDT(uvh.expiry_dt),
377: cst_end_dt, IGS_GE_DATE.igscharDT(uvh.end_dt),
378: cst_unit_status, uvh.UNIT_STATUS,
379: cst_title, uvh.TITLE,
380: cst_short_title, uvh.short_title,
381: cst_title_override_ind, uvh.title_override_ind,

Line 391: cst_owner_ou_start_dt, IGS_GE_DATE.igscharDT(uvh.owner_ou_start_dt),

387: cst_points_override_ind, uvh.points_override_ind,
388: cst_supp_exam_permitted_ind, uvh.supp_exam_permitted_ind,
389: cst_coord_person_id, TO_CHAR(uvh.coord_person_id),
390: cst_owner_org_unit_cd, uvh.owner_org_unit_cd,
391: cst_owner_ou_start_dt, IGS_GE_DATE.igscharDT(uvh.owner_ou_start_dt),
392: cst_ou_description, uvh.ou_description,
393: cst_award_course_only_ind, uvh.award_course_only_ind,
394: cst_research_unit_ind, uvh.research_unit_ind,
395: cst_industrial_ind, uvh.industrial_ind,

Line 406: cst_approval_date, IGS_GE_DATE.igscharDT( uvh.approval_date ),

402: cst_points_max, TO_CHAR(uvh.points_max),
403: cst_unit_int_course_level_cd, uvh.unit_int_course_level_cd,
404: cst_uicl_description, uvh.uicl_description,
405: cst_advance_maximum, TO_CHAR(uvh.advance_maximum),
406: cst_approval_date, IGS_GE_DATE.igscharDT( uvh.approval_date ),
407: cst_cal_type_enrol_load_cal, uvh.cal_type_enrol_load_cal,
408: cst_cal_type_offer_load_cal, uvh.cal_type_offer_load_cal,
409: cst_clock_hours, TO_CHAR(uvh.clock_hours),
410: cst_contact_hrs_lab, TO_CHAR(uvh.contact_hrs_lab),

Line 462: cst_start_dt, IGS_GE_DATE.igscharDT(uvh.start_dt),

458: WHERE uvh.unit_cd = p_unit_cd AND
459: uvh.version_number = p_version_number AND
460: uvh.hist_start_dt >= p_hist_date AND
461: DECODE (p_column_name,
462: cst_start_dt, IGS_GE_DATE.igscharDT(uvh.start_dt),
463: cst_review_dt, IGS_GE_DATE.igscharDT(uvh.review_dt),
464: cst_expiry_dt, IGS_GE_DATE.igscharDT(uvh.expiry_dt),
465: cst_end_dt, IGS_GE_DATE.igscharDT(uvh.end_dt),
466: cst_unit_status, uvh.UNIT_STATUS,

Line 463: cst_review_dt, IGS_GE_DATE.igscharDT(uvh.review_dt),

459: uvh.version_number = p_version_number AND
460: uvh.hist_start_dt >= p_hist_date AND
461: DECODE (p_column_name,
462: cst_start_dt, IGS_GE_DATE.igscharDT(uvh.start_dt),
463: cst_review_dt, IGS_GE_DATE.igscharDT(uvh.review_dt),
464: cst_expiry_dt, IGS_GE_DATE.igscharDT(uvh.expiry_dt),
465: cst_end_dt, IGS_GE_DATE.igscharDT(uvh.end_dt),
466: cst_unit_status, uvh.UNIT_STATUS,
467: cst_title, uvh.TITLE,

Line 464: cst_expiry_dt, IGS_GE_DATE.igscharDT(uvh.expiry_dt),

460: uvh.hist_start_dt >= p_hist_date AND
461: DECODE (p_column_name,
462: cst_start_dt, IGS_GE_DATE.igscharDT(uvh.start_dt),
463: cst_review_dt, IGS_GE_DATE.igscharDT(uvh.review_dt),
464: cst_expiry_dt, IGS_GE_DATE.igscharDT(uvh.expiry_dt),
465: cst_end_dt, IGS_GE_DATE.igscharDT(uvh.end_dt),
466: cst_unit_status, uvh.UNIT_STATUS,
467: cst_title, uvh.TITLE,
468: cst_short_title, uvh.short_title,

Line 465: cst_end_dt, IGS_GE_DATE.igscharDT(uvh.end_dt),

461: DECODE (p_column_name,
462: cst_start_dt, IGS_GE_DATE.igscharDT(uvh.start_dt),
463: cst_review_dt, IGS_GE_DATE.igscharDT(uvh.review_dt),
464: cst_expiry_dt, IGS_GE_DATE.igscharDT(uvh.expiry_dt),
465: cst_end_dt, IGS_GE_DATE.igscharDT(uvh.end_dt),
466: cst_unit_status, uvh.UNIT_STATUS,
467: cst_title, uvh.TITLE,
468: cst_short_title, uvh.short_title,
469: cst_title_override_ind, uvh.title_override_ind,

Line 479: cst_owner_ou_start_dt, IGS_GE_DATE.igscharDT(uvh.owner_ou_start_dt),

475: cst_points_override_ind, uvh.points_override_ind,
476: cst_supp_exam_permitted_ind, uvh.supp_exam_permitted_ind,
477: cst_coord_person_id, TO_CHAR(uvh.coord_person_id),
478: cst_owner_org_unit_cd, uvh.owner_org_unit_cd,
479: cst_owner_ou_start_dt, IGS_GE_DATE.igscharDT(uvh.owner_ou_start_dt),
480: cst_ou_description, uvh.ou_description,
481: cst_award_course_only_ind, uvh.award_course_only_ind,
482: cst_research_unit_ind, uvh.research_unit_ind,
483: cst_industrial_ind, uvh.industrial_ind,

Line 494: cst_approval_date, IGS_GE_DATE.igscharDT( uvh.approval_date ),

490: cst_points_max, TO_CHAR(uvh.points_max),
491: cst_unit_int_course_level_cd, uvh.unit_int_course_level_cd,
492: cst_uicl_description, uvh.uicl_description,
493: cst_advance_maximum, TO_CHAR(uvh.advance_maximum),
494: cst_approval_date, IGS_GE_DATE.igscharDT( uvh.approval_date ),
495: cst_cal_type_enrol_load_cal, uvh.cal_type_enrol_load_cal,
496: cst_cal_type_offer_load_cal, uvh.cal_type_offer_load_cal,
497: cst_clock_hours, TO_CHAR(uvh.clock_hours),
498: cst_contact_hrs_lab, TO_CHAR(uvh.contact_hrs_lab),