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.

[Home] [Help]

APPS.IGS_AD_GEN_004 dependencies on IGS_PS_OFR

Line 635: v_cal_type IGS_PS_OFR.cal_type%TYPE;

631: BEGIN --admp_get_crv_comp_dt
632: --Routine to return the course version expected completion date.
633: --This can be determined from a start date or expected completeion details
634: DECLARE
635: v_cal_type IGS_PS_OFR.cal_type%TYPE;
636: v_att_gat IGS_EN_ATD_TYPE.govt_attendance_type%TYPE;
637: v_comp_perd_dt_alias IGS_AD_CAL_CONF.adm_appl_e_comp_perd_dt_alias%TYPE;
638: v_completion_time IGS_PS_VER.std_ft_completion_time%TYPE;
639: v_completion_months IGS_PS_VER.std_ft_completion_time%TYPE;

Line 656: FROM IGS_PS_OFR co

652: v_rec_cnt NUMBER;
653: v_completion_days NUMBER;
654: CURSOR c_co IS
655: SELECT co.cal_type
656: FROM IGS_PS_OFR co
657: WHERE co.course_cd = p_course_cd AND
658: co.version_number = p_crv_version_number;
659: CURSOR c_sacco IS
660: SELECT adm_appl_e_comp_perd_dt_alias,

Line 695: cp_course_cd igs_ps_ofr_opt_all.course_cd%TYPE,

691: ORDER BY alias_val; -- Order is changed to Ascending. Bug :2647482
692:
693: --Cursor to get the Program Length and Program Length Measurement for the Program Offering Option record. Bug:2647482
694: CURSOR c_get_prg_mesr_dtls(
695: cp_course_cd igs_ps_ofr_opt_all.course_cd%TYPE,
696: cp_version_number igs_ps_ofr_opt_all.version_number%TYPE,
697: cp_cal_type igs_ps_ofr_opt_all.cal_type%TYPE,
698: cp_attendance_type igs_ps_ofr_opt_all.attendance_type%TYPE,
699: cp_attendance_mode igs_ps_ofr_opt_all.attendance_mode%TYPE,

Line 696: cp_version_number igs_ps_ofr_opt_all.version_number%TYPE,

692:
693: --Cursor to get the Program Length and Program Length Measurement for the Program Offering Option record. Bug:2647482
694: CURSOR c_get_prg_mesr_dtls(
695: cp_course_cd igs_ps_ofr_opt_all.course_cd%TYPE,
696: cp_version_number igs_ps_ofr_opt_all.version_number%TYPE,
697: cp_cal_type igs_ps_ofr_opt_all.cal_type%TYPE,
698: cp_attendance_type igs_ps_ofr_opt_all.attendance_type%TYPE,
699: cp_attendance_mode igs_ps_ofr_opt_all.attendance_mode%TYPE,
700: cp_location_cd igs_ps_ofr_opt_all.location_cd%TYPE

Line 697: cp_cal_type igs_ps_ofr_opt_all.cal_type%TYPE,

693: --Cursor to get the Program Length and Program Length Measurement for the Program Offering Option record. Bug:2647482
694: CURSOR c_get_prg_mesr_dtls(
695: cp_course_cd igs_ps_ofr_opt_all.course_cd%TYPE,
696: cp_version_number igs_ps_ofr_opt_all.version_number%TYPE,
697: cp_cal_type igs_ps_ofr_opt_all.cal_type%TYPE,
698: cp_attendance_type igs_ps_ofr_opt_all.attendance_type%TYPE,
699: cp_attendance_mode igs_ps_ofr_opt_all.attendance_mode%TYPE,
700: cp_location_cd igs_ps_ofr_opt_all.location_cd%TYPE
701: ) IS

Line 698: cp_attendance_type igs_ps_ofr_opt_all.attendance_type%TYPE,

694: CURSOR c_get_prg_mesr_dtls(
695: cp_course_cd igs_ps_ofr_opt_all.course_cd%TYPE,
696: cp_version_number igs_ps_ofr_opt_all.version_number%TYPE,
697: cp_cal_type igs_ps_ofr_opt_all.cal_type%TYPE,
698: cp_attendance_type igs_ps_ofr_opt_all.attendance_type%TYPE,
699: cp_attendance_mode igs_ps_ofr_opt_all.attendance_mode%TYPE,
700: cp_location_cd igs_ps_ofr_opt_all.location_cd%TYPE
701: ) IS
702: SELECT program_length,

Line 699: cp_attendance_mode igs_ps_ofr_opt_all.attendance_mode%TYPE,

695: cp_course_cd igs_ps_ofr_opt_all.course_cd%TYPE,
696: cp_version_number igs_ps_ofr_opt_all.version_number%TYPE,
697: cp_cal_type igs_ps_ofr_opt_all.cal_type%TYPE,
698: cp_attendance_type igs_ps_ofr_opt_all.attendance_type%TYPE,
699: cp_attendance_mode igs_ps_ofr_opt_all.attendance_mode%TYPE,
700: cp_location_cd igs_ps_ofr_opt_all.location_cd%TYPE
701: ) IS
702: SELECT program_length,
703: program_length_measurement

Line 700: cp_location_cd igs_ps_ofr_opt_all.location_cd%TYPE

696: cp_version_number igs_ps_ofr_opt_all.version_number%TYPE,
697: cp_cal_type igs_ps_ofr_opt_all.cal_type%TYPE,
698: cp_attendance_type igs_ps_ofr_opt_all.attendance_type%TYPE,
699: cp_attendance_mode igs_ps_ofr_opt_all.attendance_mode%TYPE,
700: cp_location_cd igs_ps_ofr_opt_all.location_cd%TYPE
701: ) IS
702: SELECT program_length,
703: program_length_measurement
704: FROM igs_ps_ofr_opt_all

Line 704: FROM igs_ps_ofr_opt_all

700: cp_location_cd igs_ps_ofr_opt_all.location_cd%TYPE
701: ) IS
702: SELECT program_length,
703: program_length_measurement
704: FROM igs_ps_ofr_opt_all
705: WHERE course_cd = p_course_cd AND
706: version_number = p_crv_version_number AND
707: cal_type = p_cal_type AND
708: location_cd = p_location_cd AND