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

Line 224: -- cst_conferral_dt, IGS_GE_DATE.igscharDT(grh.conferral_dt),

220: cst_award_course_cd, grh.award_course_cd,
221: cst_award_crs_version_number, TO_CHAR(grh.award_crs_version_number),
222: cst_award_cd, grh.award_cd,
223: -- cst_honours_level, grh.HONOURS_LEVEL,
224: -- cst_conferral_dt, IGS_GE_DATE.igscharDT(grh.conferral_dt),
225: cst_graduand_status, grh.GRADUAND_STATUS,
226: cst_graduand_appr_status, grh.GRADUAND_APPR_STATUS,
227: cst_s_graduand_type, grh.s_graduand_type,
228: cst_proxy_award_ind, grh.proxy_award_ind,

Line 246: -- cst_conferral_dt, IGS_GE_DATE.igscharDT(grh.conferral_dt),

242: cst_award_course_cd, grh.award_course_cd,
243: cst_award_crs_version_number, TO_CHAR(grh.award_crs_version_number),
244: cst_award_cd, grh.award_cd,
245: -- cst_honours_level, grh.HONOURS_LEVEL,
246: -- cst_conferral_dt, IGS_GE_DATE.igscharDT(grh.conferral_dt),
247: cst_graduand_status, grh.GRADUAND_STATUS,
248: cst_graduand_appr_status, grh.GRADUAND_APPR_STATUS,
249: cst_s_graduand_type, grh.s_graduand_type,
250: cst_proxy_award_ind, grh.proxy_award_ind,

Line 395: cst_ou_end_dt, IGS_GE_DATE.igscharDT(ouh.ou_end_dt),

391: CURSOR c_ouh IS
392: SELECT
393: DECODE (
394: p_column_name,
395: cst_ou_end_dt, IGS_GE_DATE.igscharDT(ouh.ou_end_dt),
396: cst_description, ouh.description,
397: cst_org_status, ouh.ORG_STATUS,
398: cst_org_type, ouh.ORG_TYPE,
399: cst_member_type, ouh.MEMBER_TYPE,

Line 408: cst_ou_end_dt, IGS_GE_DATE.igscharDT(ouh.ou_end_dt),

404: ouh.ou_start_dt = p_ou_start_dt AND
405: ouh.hist_start_dt >= p_hist_end_dt AND
406: DECODE (
407: p_column_name,
408: cst_ou_end_dt, IGS_GE_DATE.igscharDT(ouh.ou_end_dt),
409: cst_description, ouh.description,
410: cst_org_status, ouh.ORG_STATUS,
411: cst_org_type, ouh.ORG_TYPE,
412: cst_member_type, ouh.MEMBER_TYPE,

Line 502: cst_commencement_dt, IGS_GE_DATE.igscharDT(scah.commencement_dt),

498: cst_location_cd, scah.location_cd,
499: cst_attendance_mode, scah.ATTENDANCE_MODE,
500: cst_attendance_type, scah.ATTENDANCE_TYPE,
501: cst_student_confirmed_ind, scah.student_confirmed_ind,
502: cst_commencement_dt, IGS_GE_DATE.igscharDT(scah.commencement_dt),
503: cst_course_attempt_status, scah.course_attempt_status,
504: cst_progression_status, scah.progression_status,
505: cst_derived_att_type, scah.derived_att_type,
506: cst_derived_att_mode, scah.derived_att_mode,

Line 508: cst_discontinued_dt, IGS_GE_DATE.igscharDT(scah.discontinued_dt),

504: cst_progression_status, scah.progression_status,
505: cst_derived_att_type, scah.derived_att_type,
506: cst_derived_att_mode, scah.derived_att_mode,
507: cst_provisional_ind, scah.provisional_ind,
508: cst_discontinued_dt, IGS_GE_DATE.igscharDT(scah.discontinued_dt),
509: cst_discontinuation_reason_cd, scah.DISCONTINUATION_REASON_CD,
510: cst_funding_source, scah.FUNDING_SOURCE,
511: cst_fs_description, scah.fs_description,
512: cst_exam_location_cd, scah.exam_location_cd,

Line 520: cst_last_rule_check_dt, IGS_GE_DATE.igscharDT(scah.last_rule_check_dt),

516: cst_nominated_completion_yr, TO_CHAR(scah.nominated_completion_yr),
517: cst_nominated_completion_perd, scah.nominated_completion_perd,
518: cst_rule_check_ind, scah.rule_check_ind,
519: cst_waive_option_check_ind, scah.waive_option_check_ind,
520: cst_last_rule_check_dt, IGS_GE_DATE.igscharDT(scah.last_rule_check_dt),
521: cst_publish_outcomes_ind, scah.publish_outcomes_ind,
522: cst_course_rqrmnt_complete_ind, scah.course_rqrmnt_complete_ind,
523: cst_course_rqrmnts_complete_dt, IGS_GE_DATE.igscharDT(scah.course_rqrmnts_complete_dt),
524: cst_s_completed_source_type, scah.s_completed_source_type,

Line 523: cst_course_rqrmnts_complete_dt, IGS_GE_DATE.igscharDT(scah.course_rqrmnts_complete_dt),

519: cst_waive_option_check_ind, scah.waive_option_check_ind,
520: cst_last_rule_check_dt, IGS_GE_DATE.igscharDT(scah.last_rule_check_dt),
521: cst_publish_outcomes_ind, scah.publish_outcomes_ind,
522: cst_course_rqrmnt_complete_ind, scah.course_rqrmnt_complete_ind,
523: cst_course_rqrmnts_complete_dt, IGS_GE_DATE.igscharDT(scah.course_rqrmnts_complete_dt),
524: cst_s_completed_source_type, scah.s_completed_source_type,
525: cst_override_time_limitation, TO_CHAR(scah.override_time_limitation),
526: cst_advanced_standing_ind, scah.advanced_standing_ind,
527: cst_fee_cat, scah.FEE_CAT,

Line 532: cst_lapsed_dt, IGS_GE_DATE.igscharDT(scah.lapsed_dt),

528: cst_fc_description, scah.fc_description,
529: cst_correspondence_cat, scah.CORRESPONDENCE_CAT,
530: cst_cc_description, scah.cc_description,
531: cst_self_help_group_ind, scah.self_help_group_ind,
532: cst_lapsed_dt, IGS_GE_DATE.igscharDT(scah.lapsed_dt),
533: cst_adm_admission_appl_number, TO_CHAR(scah.adm_admission_appl_number),
534: cst_adm_nominated_course_cd, scah.adm_nominated_course_cd,
535: cst_adm_sequence_number, TO_CHAR(scah.adm_sequence_number),
536: cst_last_date_of_attendance, IGS_GE_DATE.igscharDT(scah.last_date_of_attendance),

Line 536: cst_last_date_of_attendance, IGS_GE_DATE.igscharDT(scah.last_date_of_attendance),

532: cst_lapsed_dt, IGS_GE_DATE.igscharDT(scah.lapsed_dt),
533: cst_adm_admission_appl_number, TO_CHAR(scah.adm_admission_appl_number),
534: cst_adm_nominated_course_cd, scah.adm_nominated_course_cd,
535: cst_adm_sequence_number, TO_CHAR(scah.adm_sequence_number),
536: cst_last_date_of_attendance, IGS_GE_DATE.igscharDT(scah.last_date_of_attendance),
537: cst_dropped_by, scah.dropped_by,
538: cst_key_program, scah.key_program,
539: cst_primary_program_type, scah.primary_program_type,
540: cst_primary_prog_type_source, scah.primary_prog_type_source,

Line 544: cst_override_cmpl_dt, IGS_GE_DATE.igscharDT(scah.override_cmpl_dt),

540: cst_primary_prog_type_source, scah.primary_prog_type_source,
541: cst_catalog_cal_type, scah.catalog_cal_type,
542: cst_catalog_seq_num, TO_CHAR(scah.catalog_seq_num),
543: cst_manual_ovr_cmpl_dt_ind, scah.manual_ovr_cmpl_dt_ind ,
544: cst_override_cmpl_dt, IGS_GE_DATE.igscharDT(scah.override_cmpl_dt),
545: cst_coo_id, TO_CHAR(scah.coo_id),
546: cst_IGS_PR_CLASS_STD_ID, TO_CHAR(scah.IGS_PR_CLASS_STD_ID)
547: )
548: FROM IGS_AS_SC_ATTEMPT_H scah

Line 559: cst_commencement_dt, IGS_GE_DATE.igscharDT(scah.commencement_dt),

555: cst_location_cd, scah.location_cd,
556: cst_attendance_mode, scah.ATTENDANCE_MODE,
557: cst_attendance_type, scah.ATTENDANCE_TYPE,
558: cst_student_confirmed_ind, scah.student_confirmed_ind,
559: cst_commencement_dt, IGS_GE_DATE.igscharDT(scah.commencement_dt),
560: cst_course_attempt_status, scah.course_attempt_status,
561: cst_progression_status, scah.progression_status,
562: cst_derived_att_type, scah.derived_att_type,
563: cst_derived_att_mode, scah.derived_att_mode,

Line 565: cst_discontinued_dt, IGS_GE_DATE.igscharDT(scah.discontinued_dt),

561: cst_progression_status, scah.progression_status,
562: cst_derived_att_type, scah.derived_att_type,
563: cst_derived_att_mode, scah.derived_att_mode,
564: cst_provisional_ind, scah.provisional_ind,
565: cst_discontinued_dt, IGS_GE_DATE.igscharDT(scah.discontinued_dt),
566: cst_discontinuation_reason_cd, scah.DISCONTINUATION_REASON_CD,
567: cst_funding_source, scah.FUNDING_SOURCE,
568: cst_fs_description, scah.fs_description,
569: cst_exam_location_cd, scah.exam_location_cd,

Line 577: cst_last_rule_check_dt, IGS_GE_DATE.igscharDT(scah.last_rule_check_dt),

573: cst_nominated_completion_yr, TO_CHAR(scah.nominated_completion_yr),
574: cst_nominated_completion_perd, scah.nominated_completion_perd,
575: cst_rule_check_ind, scah.rule_check_ind,
576: cst_waive_option_check_ind, scah.waive_option_check_ind,
577: cst_last_rule_check_dt, IGS_GE_DATE.igscharDT(scah.last_rule_check_dt),
578: cst_publish_outcomes_ind, scah.publish_outcomes_ind,
579: cst_course_rqrmnt_complete_ind, scah.course_rqrmnt_complete_ind,
580: cst_course_rqrmnts_complete_dt, IGS_GE_DATE.igscharDT(scah.course_rqrmnts_complete_dt),
581: cst_s_completed_source_type, scah.s_completed_source_type,

Line 580: cst_course_rqrmnts_complete_dt, IGS_GE_DATE.igscharDT(scah.course_rqrmnts_complete_dt),

576: cst_waive_option_check_ind, scah.waive_option_check_ind,
577: cst_last_rule_check_dt, IGS_GE_DATE.igscharDT(scah.last_rule_check_dt),
578: cst_publish_outcomes_ind, scah.publish_outcomes_ind,
579: cst_course_rqrmnt_complete_ind, scah.course_rqrmnt_complete_ind,
580: cst_course_rqrmnts_complete_dt, IGS_GE_DATE.igscharDT(scah.course_rqrmnts_complete_dt),
581: cst_s_completed_source_type, scah.s_completed_source_type,
582: cst_override_time_limitation, TO_CHAR(scah.override_time_limitation),
583: cst_advanced_standing_ind, scah.advanced_standing_ind,
584: cst_fee_cat, scah.FEE_CAT,

Line 589: cst_lapsed_dt, IGS_GE_DATE.igscharDT(scah.lapsed_dt),

585: cst_fc_description, scah.fc_description,
586: cst_correspondence_cat, scah.CORRESPONDENCE_CAT,
587: cst_cc_description, scah.cc_description,
588: cst_self_help_group_ind, scah.self_help_group_ind,
589: cst_lapsed_dt, IGS_GE_DATE.igscharDT(scah.lapsed_dt),
590: cst_adm_admission_appl_number, TO_CHAR(scah.adm_admission_appl_number),
591: cst_adm_nominated_course_cd, scah.adm_nominated_course_cd,
592: cst_adm_sequence_number, TO_CHAR(scah.adm_sequence_number),
593: cst_last_date_of_attendance, IGS_GE_DATE.igscharDT(scah.last_date_of_attendance),

Line 593: cst_last_date_of_attendance, IGS_GE_DATE.igscharDT(scah.last_date_of_attendance),

589: cst_lapsed_dt, IGS_GE_DATE.igscharDT(scah.lapsed_dt),
590: cst_adm_admission_appl_number, TO_CHAR(scah.adm_admission_appl_number),
591: cst_adm_nominated_course_cd, scah.adm_nominated_course_cd,
592: cst_adm_sequence_number, TO_CHAR(scah.adm_sequence_number),
593: cst_last_date_of_attendance, IGS_GE_DATE.igscharDT(scah.last_date_of_attendance),
594: cst_dropped_by, scah.dropped_by ,
595: cst_key_program , scah.key_program,
596: cst_primary_program_type, scah.primary_program_type,
597: cst_primary_prog_type_source, scah.primary_prog_type_source,

Line 601: cst_override_cmpl_dt, IGS_GE_DATE.igscharDT(scah.override_cmpl_dt),

597: cst_primary_prog_type_source, scah.primary_prog_type_source,
598: cst_catalog_cal_type, scah.catalog_cal_type,
599: cst_catalog_seq_num, TO_CHAR(scah.catalog_seq_num),
600: cst_manual_ovr_cmpl_dt_ind, scah.manual_ovr_cmpl_dt_ind,
601: cst_override_cmpl_dt, IGS_GE_DATE.igscharDT(scah.override_cmpl_dt),
602: cst_coo_id, TO_CHAR(scah.coo_id),
603: cst_IGS_PR_CLASS_STD_ID, TO_CHAR(scah.IGS_PR_CLASS_STD_ID)
604: ) IS NOT NULL
605: ORDER BY scah.hist_start_dt;

Line 645: cst_date_submission, IGS_GE_DATE.igscharDT(sph.date_submission),

641: CURSOR c_sph IS
642: SELECT
643: DECODE (
644: p_column_name,
645: cst_date_submission, IGS_GE_DATE.igscharDT(sph.date_submission),
646: cst_reason_for_request, sph.reason_for_request,
647: cst_instructor_more_info, sph.instructor_more_info,
648: cst_instructor_deny_info, sph.instructor_deny_info,
649: cst_student_more_info, sph.student_more_info,

Line 659: cst_date_submission, IGS_GE_DATE.igscharDT(sph.date_submission),

655: WHERE sph.spl_perm_request_h_id = p_spl_perm_request_h_id AND
656: sph.hist_start_dt >= p_hist_end_dt AND
657: DECODE (
658: p_column_name,
659: cst_date_submission, IGS_GE_DATE.igscharDT(sph.date_submission),
660: cst_reason_for_request, sph.reason_for_request,
661: cst_instructor_more_info, sph.instructor_more_info,
662: cst_instructor_deny_info, sph.instructor_deny_info,
663: cst_student_more_info, sph.student_more_info,

Line 734: cst_enrolled_dt, IGS_GE_DATE.igscharDT(suah.enrolled_dt),

730: SELECT DECODE (p_column_name,
731: cst_version_number, TO_CHAR(suah.version_number),
732: cst_location_cd, suah.location_cd,
733: cst_unit_class, suah.UNIT_CLASS,
734: cst_enrolled_dt, IGS_GE_DATE.igscharDT(suah.enrolled_dt),
735: cst_unit_attempt_status, suah.unit_attempt_status,
736: cst_administrative_unit_status, suah.ADMINISTRATIVE_UNIT_STATUS,
737: cst_aus_description, suah.aus_description,
738: cst_discontinued_dt, IGS_GE_DATE.igscharDT(suah.discontinued_dt),

Line 738: cst_discontinued_dt, IGS_GE_DATE.igscharDT(suah.discontinued_dt),

734: cst_enrolled_dt, IGS_GE_DATE.igscharDT(suah.enrolled_dt),
735: cst_unit_attempt_status, suah.unit_attempt_status,
736: cst_administrative_unit_status, suah.ADMINISTRATIVE_UNIT_STATUS,
737: cst_aus_description, suah.aus_description,
738: cst_discontinued_dt, IGS_GE_DATE.igscharDT(suah.discontinued_dt),
739: cst_rule_waived_dt, IGS_GE_DATE.igscharDT(suah.rule_waived_dt),
740: cst_rule_waived_person_id, TO_CHAR(suah.rule_waived_person_id),
741: cst_no_assessment_ind, suah.no_assessment_ind,
742: cst_exam_location_cd, suah.exam_location_cd,

Line 739: cst_rule_waived_dt, IGS_GE_DATE.igscharDT(suah.rule_waived_dt),

735: cst_unit_attempt_status, suah.unit_attempt_status,
736: cst_administrative_unit_status, suah.ADMINISTRATIVE_UNIT_STATUS,
737: cst_aus_description, suah.aus_description,
738: cst_discontinued_dt, IGS_GE_DATE.igscharDT(suah.discontinued_dt),
739: cst_rule_waived_dt, IGS_GE_DATE.igscharDT(suah.rule_waived_dt),
740: cst_rule_waived_person_id, TO_CHAR(suah.rule_waived_person_id),
741: cst_no_assessment_ind, suah.no_assessment_ind,
742: cst_exam_location_cd, suah.exam_location_cd,
743: cst_elo_description, suah.elo_description,

Line 750: cst_override_outcome_due_dt, IGS_GE_DATE.igscharDT(suah.override_outcome_due_dt),

746: cst_alternative_title, suah.alternative_title,
747: cst_override_enrolled_cp, TO_CHAR(suah.override_enrolled_cp),
748: cst_override_eftsu, TO_CHAR(suah.override_eftsu),
749: cst_override_achievable_cp, TO_CHAR(suah.override_achievable_cp),
750: cst_override_outcome_due_dt, IGS_GE_DATE.igscharDT(suah.override_outcome_due_dt),
751: cst_override_credit_reason, suah.override_credit_reason,
752: cst_grading_schema_code, suah.grading_schema_code,
753: cst_enr_method_type, suah.enr_method_type,
754: --added by rvangala 01-OCT-2003. Enh Bug# 3052432

Line 917: cst_selection_dt, IGS_GE_DATE.igscharDT(susah.selection_dt),

913: SELECT
914: DECODE (
915: p_column_name,
916: cst_us_version_number, TO_CHAR(susah.us_version_number),
917: cst_selection_dt, IGS_GE_DATE.igscharDT(susah.selection_dt),
918: cst_student_confirmed_ind, susah.student_confirmed_ind,
919: cst_end_dt, IGS_GE_DATE.igscharDT(susah.end_dt),
920: cst_parent_unit_set_cd, susah.parent_unit_set_cd,
921: cst_parent_sequence_number, TO_CHAR(susah.parent_sequence_number),

Line 919: cst_end_dt, IGS_GE_DATE.igscharDT(susah.end_dt),

915: p_column_name,
916: cst_us_version_number, TO_CHAR(susah.us_version_number),
917: cst_selection_dt, IGS_GE_DATE.igscharDT(susah.selection_dt),
918: cst_student_confirmed_ind, susah.student_confirmed_ind,
919: cst_end_dt, IGS_GE_DATE.igscharDT(susah.end_dt),
920: cst_parent_unit_set_cd, susah.parent_unit_set_cd,
921: cst_parent_sequence_number, TO_CHAR(susah.parent_sequence_number),
922: cst_primary_set_ind, susah.primary_set_ind,
923: cst_voluntary_end_ind, susah.voluntary_end_ind,

Line 928: cst_rqrmnts_complete_dt, IGS_GE_DATE.igscharDT(susah.rqrmnts_complete_dt),

924: cst_authorised_person_id, TO_CHAR(susah.authorised_person_id),
925: cst_authorised_on, TO_CHAR(susah.authorised_on),
926: cst_override_title, susah.override_title,
927: cst_rqrmnts_complete_ind, susah.rqrmnts_complete_ind,
928: cst_rqrmnts_complete_dt, IGS_GE_DATE.igscharDT(susah.rqrmnts_complete_dt),
929: cst_s_completed_source_type, susah.s_completed_source_type,
930: cst_catalog_cal_type, susah.catalog_cal_type ,
931: cst_catalog_seq_num, TO_CHAR(susah.catalog_seq_num) )
932: FROM IGS_AS_SU_SETATMPT_H susah

Line 941: cst_selection_dt, IGS_GE_DATE.igscharDT(susah.selection_dt),

937: susah.hist_start_dt >= p_hist_end_dt AND
938: DECODE (
939: p_column_name,
940: cst_us_version_number, TO_CHAR(susah.us_version_number),
941: cst_selection_dt, IGS_GE_DATE.igscharDT(susah.selection_dt),
942: cst_student_confirmed_ind, susah.student_confirmed_ind,
943: cst_end_dt, IGS_GE_DATE.igscharDT(susah.end_dt),
944: cst_parent_unit_set_cd, susah.parent_unit_set_cd,
945: cst_parent_sequence_number, TO_CHAR(susah.parent_sequence_number),

Line 943: cst_end_dt, IGS_GE_DATE.igscharDT(susah.end_dt),

939: p_column_name,
940: cst_us_version_number, TO_CHAR(susah.us_version_number),
941: cst_selection_dt, IGS_GE_DATE.igscharDT(susah.selection_dt),
942: cst_student_confirmed_ind, susah.student_confirmed_ind,
943: cst_end_dt, IGS_GE_DATE.igscharDT(susah.end_dt),
944: cst_parent_unit_set_cd, susah.parent_unit_set_cd,
945: cst_parent_sequence_number, TO_CHAR(susah.parent_sequence_number),
946: cst_primary_set_ind, susah.primary_set_ind,
947: cst_voluntary_end_ind, susah.voluntary_end_ind,

Line 949: cst_authorised_on, IGS_GE_DATE.igscharDT(susah.authorised_on),

945: cst_parent_sequence_number, TO_CHAR(susah.parent_sequence_number),
946: cst_primary_set_ind, susah.primary_set_ind,
947: cst_voluntary_end_ind, susah.voluntary_end_ind,
948: cst_authorised_person_id, TO_CHAR(susah.authorised_person_id),
949: cst_authorised_on, IGS_GE_DATE.igscharDT(susah.authorised_on),
950: cst_override_title, susah.override_title,
951: cst_rqrmnts_complete_ind, susah.rqrmnts_complete_ind,
952: cst_rqrmnts_complete_dt, IGS_GE_DATE.igscharDT(susah.rqrmnts_complete_dt),
953: cst_s_completed_source_type, susah.s_completed_source_type,

Line 952: cst_rqrmnts_complete_dt, IGS_GE_DATE.igscharDT(susah.rqrmnts_complete_dt),

948: cst_authorised_person_id, TO_CHAR(susah.authorised_person_id),
949: cst_authorised_on, IGS_GE_DATE.igscharDT(susah.authorised_on),
950: cst_override_title, susah.override_title,
951: cst_rqrmnts_complete_ind, susah.rqrmnts_complete_ind,
952: cst_rqrmnts_complete_dt, IGS_GE_DATE.igscharDT(susah.rqrmnts_complete_dt),
953: cst_s_completed_source_type, susah.s_completed_source_type,
954: cst_catalog_cal_type, susah.catalog_cal_type ,
955: cst_catalog_seq_num, TO_CHAR(susah.catalog_seq_num) ) IS NOT NULL
956: ORDER BY susah.hist_start_dt;