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_EN_GEN_017 dependencies on IGS_PS_UNIT_OFR_OPT

Line 42: || sommukhe 27-JUL-2005 Bug#4344483,Modified the call to igs_ps_unit_ofr_opt_pkg.update_row

38: || Change History :
39: || Who When What
40: || sgurusam 05-Jul-2005 Pass the new parameter p_calling_obj='JOB' in the calls to igs_ss_en_wrappers.insert_into_enr_worksheet
41: || Pass the new parameter p_calling_obj= 'JOB' in the calls to igs_ss_en_wrappers.drop_selected_units
42: || sommukhe 27-JUL-2005 Bug#4344483,Modified the call to igs_ps_unit_ofr_opt_pkg.update_row
43: || to include new parameter abort_flag.
44: || sarakshi 18-Sep-2003 Enh#3052452.Modified the call to igs_ps_unit_ofr_opt_pkg.update_row
45: || to include new parameter sup_uoo_id,relation_type,default_enroll_flag
46: || rvivekan 3-Aug-2003 Added new parameters to ofr_enrollment_or_waitlist |

Line 44: || sarakshi 18-Sep-2003 Enh#3052452.Modified the call to igs_ps_unit_ofr_opt_pkg.update_row

40: || sgurusam 05-Jul-2005 Pass the new parameter p_calling_obj='JOB' in the calls to igs_ss_en_wrappers.insert_into_enr_worksheet
41: || Pass the new parameter p_calling_obj= 'JOB' in the calls to igs_ss_en_wrappers.drop_selected_units
42: || sommukhe 27-JUL-2005 Bug#4344483,Modified the call to igs_ps_unit_ofr_opt_pkg.update_row
43: || to include new parameter abort_flag.
44: || sarakshi 18-Sep-2003 Enh#3052452.Modified the call to igs_ps_unit_ofr_opt_pkg.update_row
45: || to include new parameter sup_uoo_id,relation_type,default_enroll_flag
46: || rvivekan 3-Aug-2003 Added new parameters to ofr_enrollment_or_waitlist |
47: as a part of Bulk Unit Upload Bug#3049009
48: || vvutukur 05-aug-2003 Enh#3045069.PSP Enh Build. Modified the call to igs_ps_unit_ofr_opt_pkg.update_row to

Line 48: || vvutukur 05-aug-2003 Enh#3045069.PSP Enh Build. Modified the call to igs_ps_unit_ofr_opt_pkg.update_row to

44: || sarakshi 18-Sep-2003 Enh#3052452.Modified the call to igs_ps_unit_ofr_opt_pkg.update_row
45: || to include new parameter sup_uoo_id,relation_type,default_enroll_flag
46: || rvivekan 3-Aug-2003 Added new parameters to ofr_enrollment_or_waitlist |
47: as a part of Bulk Unit Upload Bug#3049009
48: || vvutukur 05-aug-2003 Enh#3045069.PSP Enh Build. Modified the call to igs_ps_unit_ofr_opt_pkg.update_row to
49: || include new parameter not_multiple_section_flag.
50: || svanukur 16-jun-2003 implemented the check for unit section status of 'NOT_OFFERED'
51: || as part of validation impact CR ENCR034.
52: || (reverse chronological order - newest change first)

Line 60: l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;

56: l_cal_type igs_ca_inst.cal_type%TYPE;
57: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
58: l_primary_code igs_ps_ver.course_cd%TYPE;
59: l_primary_version igs_ps_ver.version_number%TYPE;
60: l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;
61: l_us_status igs_en_su_attempt.unit_attempt_status%TYPE;
62: l_ret_status VARCHAR2(6):='TRUE';
63: l_waitlist_ind VARCHAR2(1);
64: l_message_count NUMBER;

Line 71: FROM igs_ps_unit_ofr_opt

67: l_next_step VARCHAR2(1);
68:
69: CURSOR c_chk_us_ivr IS
70: SELECT ivrs_available_ind, unit_section_status, auditable_ind
71: FROM igs_ps_unit_ofr_opt
72: WHERE uoo_id = l_uoo_id;
73:
74: l_ivrs_available_ind igs_ps_unit_ofr_opt.ivrs_available_ind%TYPE;
75: l_unit_section_status igs_ps_unit_ofr_opt.unit_section_status%TYPE;

Line 74: l_ivrs_available_ind igs_ps_unit_ofr_opt.ivrs_available_ind%TYPE;

70: SELECT ivrs_available_ind, unit_section_status, auditable_ind
71: FROM igs_ps_unit_ofr_opt
72: WHERE uoo_id = l_uoo_id;
73:
74: l_ivrs_available_ind igs_ps_unit_ofr_opt.ivrs_available_ind%TYPE;
75: l_unit_section_status igs_ps_unit_ofr_opt.unit_section_status%TYPE;
76: l_auditable_ind igs_ps_unit_ofr_opt.auditable_ind%TYPE;
77:
78: CURSOR c_unit_ofr_opt IS

Line 75: l_unit_section_status igs_ps_unit_ofr_opt.unit_section_status%TYPE;

71: FROM igs_ps_unit_ofr_opt
72: WHERE uoo_id = l_uoo_id;
73:
74: l_ivrs_available_ind igs_ps_unit_ofr_opt.ivrs_available_ind%TYPE;
75: l_unit_section_status igs_ps_unit_ofr_opt.unit_section_status%TYPE;
76: l_auditable_ind igs_ps_unit_ofr_opt.auditable_ind%TYPE;
77:
78: CURSOR c_unit_ofr_opt IS
79: SELECT uoo.*

Line 76: l_auditable_ind igs_ps_unit_ofr_opt.auditable_ind%TYPE;

72: WHERE uoo_id = l_uoo_id;
73:
74: l_ivrs_available_ind igs_ps_unit_ofr_opt.ivrs_available_ind%TYPE;
75: l_unit_section_status igs_ps_unit_ofr_opt.unit_section_status%TYPE;
76: l_auditable_ind igs_ps_unit_ofr_opt.auditable_ind%TYPE;
77:
78: CURSOR c_unit_ofr_opt IS
79: SELECT uoo.*
80: FROM igs_ps_unit_ofr_opt uoo

Line 80: FROM igs_ps_unit_ofr_opt uoo

76: l_auditable_ind igs_ps_unit_ofr_opt.auditable_ind%TYPE;
77:
78: CURSOR c_unit_ofr_opt IS
79: SELECT uoo.*
80: FROM igs_ps_unit_ofr_opt uoo
81: WHERE uoo_id = l_uoo_id;
82:
83: l_unit_ofr_opt c_unit_ofr_opt%ROWTYPE;
84:

Line 129: igs_ps_unit_ofr_opt_pkg.update_row (

125: OPEN c_unit_ofr_opt;
126: FETCH c_unit_ofr_opt INTO l_unit_ofr_opt;
127: CLOSE c_unit_ofr_opt;
128:
129: igs_ps_unit_ofr_opt_pkg.update_row (
130: x_rowid => l_unit_ofr_opt.row_id,
131: x_unit_cd => l_unit_ofr_opt.unit_cd,
132: x_version_number => l_unit_ofr_opt.version_number,
133: x_cal_type => l_unit_ofr_opt.cal_type,

Line 359: l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;

355: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
356: l_program_cd igs_en_su_attempt_all.course_cd%TYPE;
357: l_primary_code igs_en_su_attempt_all.course_cd%TYPE;
358: l_primary_version igs_en_su_attempt_all.version_number%TYPE;
359: l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;
360: l_messaage_count NUMBER(15);
361: l_error_message VARCHAR2(1000);
362: l_return_stat VARCHAR2(10);
363: l_api_name CONSTANT VARCHAR2(30) := 'drop_section';

Line 862: FROM igs_ps_unit_ofr_opt

858: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
859:
860: CURSOR c_uoo_id IS
861: SELECT 'X'
862: FROM igs_ps_unit_ofr_opt
863: WHERE call_number = p_call_number;
864: l_dummy VARCHAR2(1);
865:
866: CURSOR c_chk_call_num_term (cp_cal_type igs_ca_inst.cal_type%TYPE,

Line 869: FROM igs_ps_unit_ofr_opt

865:
866: CURSOR c_chk_call_num_term (cp_cal_type igs_ca_inst.cal_type%TYPE,
867: cp_ci_seq_num igs_ca_inst.sequence_number%TYPE) IS
868: SELECT uoo_id
869: FROM igs_ps_unit_ofr_opt
870: WHERE call_number = p_call_number
871: AND ( cal_type, ci_sequence_number ) IN
872: ( SELECT teach_cal_type, teach_ci_sequence_number
873: FROM igs_ca_load_to_teach_v

Line 966: l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;

962: l_primary_program_code igs_ps_ver.course_cd%TYPE;
963: l_primary_program_version igs_ps_ver.version_number%TYPE;
964: l_cal_type igs_ca_inst.cal_type%TYPE;
965: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
966: l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;
967: l_return_status VARCHAR2(10);
968: l_message_count NUMBER;
969: l_message_data VARCHAR2(2000);
970: