DBA Data[Home] [Help]

APPS.IGS_PS_CAL_RSR_VAL dependencies on IGS_PS_UNIT_OFR_OPT_PKG

Line 23: -- Added auditable_ind, audit_permission_ind to update_row call of igs_ps_unit_ofr_opt_pkg.

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
26: -- Removed the following 4 columns
27: -- BILLING_CREDIT_POINTS,BILLING_HRS,FIN_AID_CP,FIN_AID_HRS

Line 30: -- pkg IGS_PS_UNIT_OFR_OPT_PKG (Bug# 2224366)

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
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

Line 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: -------------------------------------------------------------------

Line 34: -- msrinivi 16 Aug,2001 Added new col rev_account_cd to igs_ps_unit_ver_pkg,igs_ps_unit_ofr_opt_pkg

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 ,

Line 84: --sommukhe 27-JUL-2005 Bug#4344483,Modified the call to igs_ps_unit_ofr_opt_pkg.update_row to include new parameter abort_flag.

80: --
81: --Change History:
82: --Who When What
83: --sarakshi 12-Jan-2006 Bug#4926548, modified cursor cur_uoo1 from performance perspective.
84: --sommukhe 27-JUL-2005 Bug#4344483,Modified the call to igs_ps_unit_ofr_opt_pkg.update_row to include new parameter abort_flag.
85: --sarakshi 10-Sep-2004 Enh#3882537, modifed cursor cur_uoo1 to exclude INACTIVE units and rearranged the cursor.
86: --sarakshi 22-sep-2003 Enh#3052452,added column relation-type,sup_uoo_id,default_enroll_flag in the call of to igs_ps_unit_ofr_opt_pkg.update_row
87: --vvutukur 05-Aug-2003 Enh#3045069.PSP Enh Build. Modified the call to igs_ps_unit_ofr_opt_pkg.update_row to include
88: -- new parameter not_multiple_section_flag.

Line 86: --sarakshi 22-sep-2003 Enh#3052452,added column relation-type,sup_uoo_id,default_enroll_flag in the call of to igs_ps_unit_ofr_opt_pkg.update_row

82: --Who When What
83: --sarakshi 12-Jan-2006 Bug#4926548, modified cursor cur_uoo1 from performance perspective.
84: --sommukhe 27-JUL-2005 Bug#4344483,Modified the call to igs_ps_unit_ofr_opt_pkg.update_row to include new parameter abort_flag.
85: --sarakshi 10-Sep-2004 Enh#3882537, modifed cursor cur_uoo1 to exclude INACTIVE units and rearranged the cursor.
86: --sarakshi 22-sep-2003 Enh#3052452,added column relation-type,sup_uoo_id,default_enroll_flag in the call of to igs_ps_unit_ofr_opt_pkg.update_row
87: --vvutukur 05-Aug-2003 Enh#3045069.PSP Enh Build. Modified the call to igs_ps_unit_ofr_opt_pkg.update_row to include
88: -- new parameter not_multiple_section_flag.
89: --sarakshi 10_apr-2003 Bug#2550388, modified procedure to replace hard coded log message with
90: -- lookups values

Line 87: --vvutukur 05-Aug-2003 Enh#3045069.PSP Enh Build. Modified the call to igs_ps_unit_ofr_opt_pkg.update_row to include

83: --sarakshi 12-Jan-2006 Bug#4926548, modified cursor cur_uoo1 from performance perspective.
84: --sommukhe 27-JUL-2005 Bug#4344483,Modified the call to igs_ps_unit_ofr_opt_pkg.update_row to include new parameter abort_flag.
85: --sarakshi 10-Sep-2004 Enh#3882537, modifed cursor cur_uoo1 to exclude INACTIVE units and rearranged the cursor.
86: --sarakshi 22-sep-2003 Enh#3052452,added column relation-type,sup_uoo_id,default_enroll_flag in the call of to igs_ps_unit_ofr_opt_pkg.update_row
87: --vvutukur 05-Aug-2003 Enh#3045069.PSP Enh Build. Modified the call to igs_ps_unit_ofr_opt_pkg.update_row to include
88: -- new parameter not_multiple_section_flag.
89: --sarakshi 10_apr-2003 Bug#2550388, modified procedure to replace hard coded log message with
90: -- lookups values
91: --Pradhakr 23-Jul-2001 Added three new columns in he TBH call

Line 194: igs_ps_unit_ofr_opt_pkg.update_row(x_rowid => r_cur_uoo.row_id,

190:
191:
192: -- Updating Reserved Seating Allowed value to 'N'
193: -- Added auditable_ind and audit_permission_ind to the following call as part of Bug# 2636716 by shtatiko
194: igs_ps_unit_ofr_opt_pkg.update_row(x_rowid => r_cur_uoo.row_id,
195: x_unit_cd => r_cur_uoo.unit_cd,
196: x_version_number => r_cur_uoo.version_number,
197: x_cal_type => r_cur_uoo.cal_type,
198: x_ci_sequence_number => r_cur_uoo.ci_sequence_number,