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

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 66: p_unit_cd IN igs_ps_unit_ofr_opt.unit_cd%TYPE,

62: PROCEDURE del_reserved_seating ( errbuf OUT NOCOPY VARCHAR2,
63: retcode OUT NOCOPY NUMBER,
64: p_teach_prd IN VARCHAR2,
65: p_org_unit_cd IN VARCHAR2,
66: p_unit_cd IN igs_ps_unit_ofr_opt.unit_cd%TYPE,
67: p_version_number IN igs_ps_unit_ofr_opt.version_number%TYPE,
68: p_location_cd IN igs_ps_unit_ofr_opt.location_cd%TYPE,
69: p_unit_class IN igs_ps_unit_ofr_opt.unit_class%TYPE,
70: p_unit_mode IN igs_ps_unit_ofr_opt_v.unit_mode%TYPE,

Line 67: p_version_number IN igs_ps_unit_ofr_opt.version_number%TYPE,

63: retcode OUT NOCOPY NUMBER,
64: p_teach_prd IN VARCHAR2,
65: p_org_unit_cd IN VARCHAR2,
66: p_unit_cd IN igs_ps_unit_ofr_opt.unit_cd%TYPE,
67: p_version_number IN igs_ps_unit_ofr_opt.version_number%TYPE,
68: p_location_cd IN igs_ps_unit_ofr_opt.location_cd%TYPE,
69: p_unit_class IN igs_ps_unit_ofr_opt.unit_class%TYPE,
70: p_unit_mode IN igs_ps_unit_ofr_opt_v.unit_mode%TYPE,
71: p_org_id IN NUMBER

Line 68: p_location_cd IN igs_ps_unit_ofr_opt.location_cd%TYPE,

64: p_teach_prd IN VARCHAR2,
65: p_org_unit_cd IN VARCHAR2,
66: p_unit_cd IN igs_ps_unit_ofr_opt.unit_cd%TYPE,
67: p_version_number IN igs_ps_unit_ofr_opt.version_number%TYPE,
68: p_location_cd IN igs_ps_unit_ofr_opt.location_cd%TYPE,
69: p_unit_class IN igs_ps_unit_ofr_opt.unit_class%TYPE,
70: p_unit_mode IN igs_ps_unit_ofr_opt_v.unit_mode%TYPE,
71: p_org_id IN NUMBER
72: ) IS

Line 69: p_unit_class IN igs_ps_unit_ofr_opt.unit_class%TYPE,

65: p_org_unit_cd IN VARCHAR2,
66: p_unit_cd IN igs_ps_unit_ofr_opt.unit_cd%TYPE,
67: p_version_number IN igs_ps_unit_ofr_opt.version_number%TYPE,
68: p_location_cd IN igs_ps_unit_ofr_opt.location_cd%TYPE,
69: p_unit_class IN igs_ps_unit_ofr_opt.unit_class%TYPE,
70: p_unit_mode IN igs_ps_unit_ofr_opt_v.unit_mode%TYPE,
71: p_org_id IN NUMBER
72: ) IS
73: ------------------------------------------------------------------

Line 70: p_unit_mode IN igs_ps_unit_ofr_opt_v.unit_mode%TYPE,

66: p_unit_cd IN igs_ps_unit_ofr_opt.unit_cd%TYPE,
67: p_version_number IN igs_ps_unit_ofr_opt.version_number%TYPE,
68: p_location_cd IN igs_ps_unit_ofr_opt.location_cd%TYPE,
69: p_unit_class IN igs_ps_unit_ofr_opt.unit_class%TYPE,
70: p_unit_mode IN igs_ps_unit_ofr_opt_v.unit_mode%TYPE,
71: p_org_id IN NUMBER
72: ) IS
73: ------------------------------------------------------------------
74: --Created by : pradhakr, Oracle IDC

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 96: l_calendar_type igs_ps_unit_ofr_opt.cal_type%TYPE;

92: -- as part of Enrollment Build process.
93: -- (Enh Bug# 1832130)
94: -------------------------------------------------------------------
95:
96: l_calendar_type igs_ps_unit_ofr_opt.cal_type%TYPE;
97: l_sequence_number igs_ps_unit_ofr_opt.ci_sequence_number%TYPE;
98:
99: CURSOR cur_uoo1( p_cal_type VARCHAR2,
100: p_ci_sequence_number NUMBER) IS

Line 97: l_sequence_number igs_ps_unit_ofr_opt.ci_sequence_number%TYPE;

93: -- (Enh Bug# 1832130)
94: -------------------------------------------------------------------
95:
96: l_calendar_type igs_ps_unit_ofr_opt.cal_type%TYPE;
97: l_sequence_number igs_ps_unit_ofr_opt.ci_sequence_number%TYPE;
98:
99: CURSOR cur_uoo1( p_cal_type VARCHAR2,
100: p_ci_sequence_number NUMBER) IS
101: SELECT uoov.*,uoov.rowid row_id,uc.unit_mode,loc.description location_description

Line 102: FROM igs_ps_unit_ofr_opt_all uoov,igs_as_unit_class_all uc, igs_ad_location_all loc,

98:
99: CURSOR cur_uoo1( p_cal_type VARCHAR2,
100: p_ci_sequence_number NUMBER) IS
101: SELECT uoov.*,uoov.rowid row_id,uc.unit_mode,loc.description location_description
102: FROM igs_ps_unit_ofr_opt_all uoov,igs_as_unit_class_all uc, igs_ad_location_all loc,
103: igs_ps_unit_ver_all uv,
104: igs_ps_unit_stat st
105: WHERE uoov.cal_type = p_cal_type AND
106: uoov.ci_sequence_number = p_ci_sequence_number AND

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,

Line 471: CURSOR cur_ps_unit_ofr_opt_enroll( p_unit_cd IGS_PS_UNIT_OFR_OPT_ALL.unit_cd%TYPE,

467: uv.unit_status = us.unit_status AND
468: us.s_unit_status <> 'INACTIVE' AND
469: uop.delete_flag='N';
470:
471: CURSOR cur_ps_unit_ofr_opt_enroll( p_unit_cd IGS_PS_UNIT_OFR_OPT_ALL.unit_cd%TYPE,
472: p_version_number IGS_PS_UNIT_OFR_OPT_ALL.version_number%TYPE,
473: p_start_date IGS_CA_INST_ALL.start_dt%TYPE ) IS
474: SELECT uoov.cal_type,
475: uoov.ci_sequence_number,

Line 472: p_version_number IGS_PS_UNIT_OFR_OPT_ALL.version_number%TYPE,

468: us.s_unit_status <> 'INACTIVE' AND
469: uop.delete_flag='N';
470:
471: CURSOR cur_ps_unit_ofr_opt_enroll( p_unit_cd IGS_PS_UNIT_OFR_OPT_ALL.unit_cd%TYPE,
472: p_version_number IGS_PS_UNIT_OFR_OPT_ALL.version_number%TYPE,
473: p_start_date IGS_CA_INST_ALL.start_dt%TYPE ) IS
474: SELECT uoov.cal_type,
475: uoov.ci_sequence_number,
476: ci.start_dt

Line 477: FROM igs_ps_unit_ofr_opt uoov, igs_ca_inst ci

473: p_start_date IGS_CA_INST_ALL.start_dt%TYPE ) IS
474: SELECT uoov.cal_type,
475: uoov.ci_sequence_number,
476: ci.start_dt
477: FROM igs_ps_unit_ofr_opt uoov, igs_ca_inst ci
478: WHERE uoov.cal_type = ci.cal_type AND
479: uoov.ci_sequence_number = ci.sequence_number AND
480: uoov.enrollment_actual > 0 AND
481: ci.start_dt <= p_start_date AND

Line 487: CURSOR cur_ps_unit_ofr_opt_offer( p_unit_cd IGS_PS_UNIT_OFR_OPT_ALL.unit_cd%TYPE,

483: uoov.version_number = p_version_number
484: ORDER BY ci.start_dt DESC;
485: cur_ps_unit_ofr_opt_enroll_rec cur_ps_unit_ofr_opt_enroll%ROWTYPE;
486:
487: CURSOR cur_ps_unit_ofr_opt_offer( p_unit_cd IGS_PS_UNIT_OFR_OPT_ALL.unit_cd%TYPE,
488: p_version_number IGS_PS_UNIT_OFR_OPT_ALL.version_number%TYPE,
489: p_start_date IGS_CA_INST_ALL.start_dt%TYPE ) IS
490: SELECT uoov.cal_type,
491: uoov.ci_sequence_number,

Line 488: p_version_number IGS_PS_UNIT_OFR_OPT_ALL.version_number%TYPE,

484: ORDER BY ci.start_dt DESC;
485: cur_ps_unit_ofr_opt_enroll_rec cur_ps_unit_ofr_opt_enroll%ROWTYPE;
486:
487: CURSOR cur_ps_unit_ofr_opt_offer( p_unit_cd IGS_PS_UNIT_OFR_OPT_ALL.unit_cd%TYPE,
488: p_version_number IGS_PS_UNIT_OFR_OPT_ALL.version_number%TYPE,
489: p_start_date IGS_CA_INST_ALL.start_dt%TYPE ) IS
490: SELECT uoov.cal_type,
491: uoov.ci_sequence_number,
492: ci.start_dt

Line 493: FROM igs_ps_unit_ofr_opt uoov, igs_ca_inst ci

489: p_start_date IGS_CA_INST_ALL.start_dt%TYPE ) IS
490: SELECT uoov.cal_type,
491: uoov.ci_sequence_number,
492: ci.start_dt
493: FROM igs_ps_unit_ofr_opt uoov, igs_ca_inst ci
494: WHERE uoov.cal_type = ci.cal_type AND
495: uoov.ci_sequence_number = ci.sequence_number AND
496: uoov.unit_section_status NOT IN ('PLANNED') AND
497: uoov.offered_ind = 'Y' AND

Line 515: CURSOR cur_unit_ver_enroll(p_unit_cd IGS_PS_UNIT_OFR_OPT_ALL.unit_cd%TYPE,

511: teach_ci_sequence_number = p_teach_sequence_number
512: ORDER BY load_start_dt DESC;
513: cur_teach_to_load_rec cur_teach_to_load%ROWTYPE;
514:
515: CURSOR cur_unit_ver_enroll(p_unit_cd IGS_PS_UNIT_OFR_OPT_ALL.unit_cd%TYPE,
516: p_version_number IGS_PS_UNIT_OFR_OPT_ALL.version_number%TYPE) IS
517: SELECT ci.start_dt start_date
518: FROM igs_ps_unit_ver uv,igs_ca_inst ci
519: WHERE uv.unit_cd = p_unit_cd AND

Line 516: p_version_number IGS_PS_UNIT_OFR_OPT_ALL.version_number%TYPE) IS

512: ORDER BY load_start_dt DESC;
513: cur_teach_to_load_rec cur_teach_to_load%ROWTYPE;
514:
515: CURSOR cur_unit_ver_enroll(p_unit_cd IGS_PS_UNIT_OFR_OPT_ALL.unit_cd%TYPE,
516: p_version_number IGS_PS_UNIT_OFR_OPT_ALL.version_number%TYPE) IS
517: SELECT ci.start_dt start_date
518: FROM igs_ps_unit_ver uv,igs_ca_inst ci
519: WHERE uv.unit_cd = p_unit_cd AND
520: uv.version_number = p_version_number AND

Line 525: CURSOR cur_unit_ver_offer(p_unit_cd IGS_PS_UNIT_OFR_OPT_ALL.unit_cd%TYPE,

521: uv.cal_type_enrol_load_cal = ci.cal_type AND
522: uv.sequence_num_enrol_load_cal = ci.sequence_number;
523: cur_unit_ver_enroll_rec cur_unit_ver_enroll%ROWTYPE;
524:
525: CURSOR cur_unit_ver_offer(p_unit_cd IGS_PS_UNIT_OFR_OPT_ALL.unit_cd%TYPE,
526: p_version_number IGS_PS_UNIT_OFR_OPT_ALL.version_number%TYPE) IS
527: SELECT ci.start_dt start_date
528: FROM igs_ps_unit_ver uv,igs_ca_inst ci
529: WHERE uv.unit_cd = p_unit_cd AND

Line 526: p_version_number IGS_PS_UNIT_OFR_OPT_ALL.version_number%TYPE) IS

522: uv.sequence_num_enrol_load_cal = ci.sequence_number;
523: cur_unit_ver_enroll_rec cur_unit_ver_enroll%ROWTYPE;
524:
525: CURSOR cur_unit_ver_offer(p_unit_cd IGS_PS_UNIT_OFR_OPT_ALL.unit_cd%TYPE,
526: p_version_number IGS_PS_UNIT_OFR_OPT_ALL.version_number%TYPE) IS
527: SELECT ci.start_dt start_date
528: FROM igs_ps_unit_ver uv,igs_ca_inst ci
529: WHERE uv.unit_cd = p_unit_cd AND
530: uv.version_number = p_version_number AND