[Home] [Help]
17: --sarakshi 25-Nov-2003 Bug#3191862, created local procedure update_unit_version and modified procedure update_enroll_offer_unit
18: --sarakshi 02-sep-2003 Enh#3052452,removed the reference of the columnsup_unit_allowed_ind and sub_unit_allowed_ind
19: --vvutukur 05-Aug-2003 Enh#3045069.PSP Enh Build. Modified del_reserved_seating.
20: -- sarakshi 10-Apr-2003 Bug#2550388, modified procedure del_reserved_seating to replace hard coded log messages with lookup values
21: -- shtatiko 30-OCT-2002 Modified calles to igs_ps_unit_ver_pkg.update_row to incorporate addition of
22: -- auditable_ind, audit_permission_ind, max_auditors_allowed columns.
23: -- Added auditable_ind, audit_permission_ind to update_row call of igs_ps_unit_ofr_opt_pkg.
24: -- This has been done as part of Bug# 2636716.
25: -- jbegum 17 April 02 As part of bug fix of bug #2322290 and bug#2250784
24: -- This has been done as part of Bug# 2636716.
25: -- jbegum 17 April 02 As part of bug fix of bug #2322290 and bug#2250784
26: -- Removed the following 4 columns
27: -- BILLING_CREDIT_POINTS,BILLING_HRS,FIN_AID_CP,FIN_AID_HRS
28: -- from calls to IGS_PS_UNIT_VER_PKG.
29: -- prraj 14-Feb-2002 Added column NON_STD_USEC_IND to the tbh calls for
30: -- pkg IGS_PS_UNIT_OFR_OPT_PKG (Bug# 2224366)
31: -- ddey 01-FEB-2002 Added columns anon_unit_grading_ind and anon_assess_grading_ind in the calls
32: -- for the package IGS_PS_UNIT_OFR_OPT_PKG and IGS_PS_UNIT_VER_PKG
28: -- from calls to IGS_PS_UNIT_VER_PKG.
29: -- prraj 14-Feb-2002 Added column NON_STD_USEC_IND to the tbh calls for
30: -- pkg IGS_PS_UNIT_OFR_OPT_PKG (Bug# 2224366)
31: -- ddey 01-FEB-2002 Added columns anon_unit_grading_ind and anon_assess_grading_ind in the calls
32: -- for the package IGS_PS_UNIT_OFR_OPT_PKG and IGS_PS_UNIT_VER_PKG
33: -- ayedubat 20/6/2001 Added one new procedure ,update_enroll_offer_unit
34: -- msrinivi 16 Aug,2001 Added new col rev_account_cd to igs_ps_unit_ver_pkg,igs_ps_unit_ofr_opt_pkg
35: -- TBH calls
36: -------------------------------------------------------------------
30: -- pkg IGS_PS_UNIT_OFR_OPT_PKG (Bug# 2224366)
31: -- ddey 01-FEB-2002 Added columns anon_unit_grading_ind and anon_assess_grading_ind in the calls
32: -- for the package IGS_PS_UNIT_OFR_OPT_PKG and IGS_PS_UNIT_VER_PKG
33: -- ayedubat 20/6/2001 Added one new procedure ,update_enroll_offer_unit
34: -- msrinivi 16 Aug,2001 Added new col rev_account_cd to igs_ps_unit_ver_pkg,igs_ps_unit_ofr_opt_pkg
35: -- TBH calls
36: -------------------------------------------------------------------
37:
38: PROCEDURE log_messages ( p_msg_name VARCHAR2 ,
285: --Known limitations/enhancements and/or remarks:
286: --
287: --Change History:
288: --Who When What
289: --sarakshi 30-Apr-2004 Bug#3568858, Added columns ovrd_wkld_val_flag, workload_val_code in the TBH call igs_ps_unit_ver_pkg.update_row
290: -------------------------------------------------------------------
291: CURSOR cur_unit_ver IS
292: SELECT *
293: FROM igs_ps_unit_ver
300: --Update the unit version record
301: OPEN cur_unit_ver;
302: FETCH cur_unit_ver INTO cur_unit_ver_rec;
303:
304: igs_ps_unit_ver_pkg.update_row (
305: X_Mode => 'R' ,
306: X_RowId => cur_unit_ver_rec.Row_Id ,
307: X_Unit_Cd => cur_unit_ver_rec.Unit_Cd ,
308: X_Version_Number => cur_unit_ver_rec.Version_Number ,
433: --Who When What
434: --sarakshi 12-Jul-2004 Bug#3729462, Added the predicate DELETE_FLAG to cursor cur_units
435: --sarakshi 25-Nov-2003 Bug#3191862, Modified the cursors cur_units,cur_teach_to_load also moved the
436: -- updation in a local procedure and calling only once for a unit using local variable.
437: --sarakshi 06-Nov-2003 Enh#3116171, Added billing_credit_points for igs_ps_unit_ver_pkg.update_row
438: -------------------------------------------------------------------
439: l_input_load_cal_type IGS_CA_INST_ALL.CAL_TYPE%TYPE;
440: l_input_load_sequence_number IGS_CA_INST_ALL.SEQUENCE_NUMBER%TYPE;
441: