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

Line 21: -- shtatiko 30-OCT-2002 Modified calles to igs_ps_unit_ver_pkg.update_row to incorporate addition of

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

Line 28: -- from calls to IGS_PS_UNIT_VER_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
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

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 103: igs_ps_unit_ver_all uv,

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
107: (uoov.owner_org_unit_cd = p_org_unit_cd OR p_org_unit_cd IS NULL) AND

Line 270: PROCEDURE update_unit_version ( p_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE ,

266: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
267:
268: END del_reserved_seating;
269:
270: PROCEDURE update_unit_version ( p_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE ,
271: p_version_number igs_ps_unit_ver_all.version_number%TYPE ,
272: p_cal_type_enrol_load_cal igs_ps_unit_ver_all.cal_type_enrol_load_cal%TYPE ,
273: p_sequence_num_enrol_load_cal igs_ps_unit_ver_all.sequence_num_enrol_load_cal%TYPE,
274: p_cal_type_offer_load_cal igs_ps_unit_ver_all.cal_type_offer_load_cal%TYPE,

Line 271: p_version_number igs_ps_unit_ver_all.version_number%TYPE ,

267:
268: END del_reserved_seating;
269:
270: PROCEDURE update_unit_version ( p_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE ,
271: p_version_number igs_ps_unit_ver_all.version_number%TYPE ,
272: p_cal_type_enrol_load_cal igs_ps_unit_ver_all.cal_type_enrol_load_cal%TYPE ,
273: p_sequence_num_enrol_load_cal igs_ps_unit_ver_all.sequence_num_enrol_load_cal%TYPE,
274: p_cal_type_offer_load_cal igs_ps_unit_ver_all.cal_type_offer_load_cal%TYPE,
275: p_sequence_num_offer_load_cal igs_ps_unit_ver_all.sequence_num_offer_load_cal%TYPE

Line 272: p_cal_type_enrol_load_cal igs_ps_unit_ver_all.cal_type_enrol_load_cal%TYPE ,

268: END del_reserved_seating;
269:
270: PROCEDURE update_unit_version ( p_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE ,
271: p_version_number igs_ps_unit_ver_all.version_number%TYPE ,
272: p_cal_type_enrol_load_cal igs_ps_unit_ver_all.cal_type_enrol_load_cal%TYPE ,
273: p_sequence_num_enrol_load_cal igs_ps_unit_ver_all.sequence_num_enrol_load_cal%TYPE,
274: p_cal_type_offer_load_cal igs_ps_unit_ver_all.cal_type_offer_load_cal%TYPE,
275: p_sequence_num_offer_load_cal igs_ps_unit_ver_all.sequence_num_offer_load_cal%TYPE
276: ) IS

Line 273: p_sequence_num_enrol_load_cal igs_ps_unit_ver_all.sequence_num_enrol_load_cal%TYPE,

269:
270: PROCEDURE update_unit_version ( p_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE ,
271: p_version_number igs_ps_unit_ver_all.version_number%TYPE ,
272: p_cal_type_enrol_load_cal igs_ps_unit_ver_all.cal_type_enrol_load_cal%TYPE ,
273: p_sequence_num_enrol_load_cal igs_ps_unit_ver_all.sequence_num_enrol_load_cal%TYPE,
274: p_cal_type_offer_load_cal igs_ps_unit_ver_all.cal_type_offer_load_cal%TYPE,
275: p_sequence_num_offer_load_cal igs_ps_unit_ver_all.sequence_num_offer_load_cal%TYPE
276: ) IS
277: ------------------------------------------------------------------

Line 274: p_cal_type_offer_load_cal igs_ps_unit_ver_all.cal_type_offer_load_cal%TYPE,

270: PROCEDURE update_unit_version ( p_unit_cd igs_ps_unit_ver_all.unit_cd%TYPE ,
271: p_version_number igs_ps_unit_ver_all.version_number%TYPE ,
272: p_cal_type_enrol_load_cal igs_ps_unit_ver_all.cal_type_enrol_load_cal%TYPE ,
273: p_sequence_num_enrol_load_cal igs_ps_unit_ver_all.sequence_num_enrol_load_cal%TYPE,
274: p_cal_type_offer_load_cal igs_ps_unit_ver_all.cal_type_offer_load_cal%TYPE,
275: p_sequence_num_offer_load_cal igs_ps_unit_ver_all.sequence_num_offer_load_cal%TYPE
276: ) IS
277: ------------------------------------------------------------------
278: --Created by : sarakshi, Oracle IDC

Line 275: p_sequence_num_offer_load_cal igs_ps_unit_ver_all.sequence_num_offer_load_cal%TYPE

271: p_version_number igs_ps_unit_ver_all.version_number%TYPE ,
272: p_cal_type_enrol_load_cal igs_ps_unit_ver_all.cal_type_enrol_load_cal%TYPE ,
273: p_sequence_num_enrol_load_cal igs_ps_unit_ver_all.sequence_num_enrol_load_cal%TYPE,
274: p_cal_type_offer_load_cal igs_ps_unit_ver_all.cal_type_offer_load_cal%TYPE,
275: p_sequence_num_offer_load_cal igs_ps_unit_ver_all.sequence_num_offer_load_cal%TYPE
276: ) IS
277: ------------------------------------------------------------------
278: --Created by : sarakshi, Oracle IDC
279: --Date created: 25-Nov-2003

Line 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

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

Line 293: FROM igs_ps_unit_ver

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
294: WHERE unit_cd = p_unit_cd
295: AND version_number = p_version_number;
296: cur_unit_ver_rec cur_unit_ver%ROWTYPE;
297:

Line 304: igs_ps_unit_ver_pkg.update_row (

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 ,

Line 420: p_org_id IN IGS_PS_UNIT_VER.ORG_ID%TYPE,

416: END update_unit_version;
417:
418: PROCEDURE update_enroll_offer_unit(errbuf OUT NOCOPY VARCHAR2,
419: retcode OUT NOCOPY NUMBER,
420: p_org_id IN IGS_PS_UNIT_VER.ORG_ID%TYPE,
421: p_load_calendar IN VARCHAR2) IS
422: ------------------------------------------------------------------
423: --Created by : ayedubat, Oracle IDC
424: --Date created: 12/6/2001

Line 437: --sarakshi 06-Nov-2003 Enh#3116171, Added billing_credit_points for igs_ps_unit_ver_pkg.update_row

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:

Line 460: FROM igs_ps_unit_ofr_pat uop , igs_ca_load_to_teach_v lteach ,igs_ps_unit_ver_all uv, igs_ps_unit_stat us

456: CURSOR cur_units( p_input_load_cal_type IGS_CA_INST_ALL.CAL_TYPE%TYPE,
457: p_input_load_sequence_number IGS_CA_INST_ALL.SEQUENCE_NUMBER%TYPE ) IS
458: SELECT DISTINCT uop.unit_cd,
459: uop.version_number
460: FROM igs_ps_unit_ofr_pat uop , igs_ca_load_to_teach_v lteach ,igs_ps_unit_ver_all uv, igs_ps_unit_stat us
461: WHERE lteach.load_cal_type = p_input_load_cal_type AND
462: lteach.load_ci_sequence_number = p_input_load_sequence_number AND
463: uop.cal_type = lteach.teach_cal_type AND
464: uop.ci_sequence_number = lteach.teach_ci_sequence_number AND

Line 518: FROM igs_ps_unit_ver uv,igs_ca_inst ci

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
521: uv.cal_type_enrol_load_cal = ci.cal_type AND
522: uv.sequence_num_enrol_load_cal = ci.sequence_number;

Line 528: FROM igs_ps_unit_ver uv,igs_ca_inst ci

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
531: uv.cal_type_offer_load_cal = ci.cal_type AND
532: uv.sequence_num_offer_load_cal = ci.sequence_number;

Line 536: l_cal_type_enrol_load_cal igs_ps_unit_ver_all.cal_type_enrol_load_cal%TYPE ;

532: uv.sequence_num_offer_load_cal = ci.sequence_number;
533: cur_unit_ver_offer_rec cur_unit_ver_offer%ROWTYPE;
534:
535:
536: l_cal_type_enrol_load_cal igs_ps_unit_ver_all.cal_type_enrol_load_cal%TYPE ;
537: l_sequence_num_enrol_load_cal igs_ps_unit_ver_all.sequence_num_enrol_load_cal%TYPE;
538: l_cal_type_offer_load_cal igs_ps_unit_ver_all.cal_type_offer_load_cal%TYPE;
539: l_sequence_num_offer_load_cal igs_ps_unit_ver_all.sequence_num_offer_load_cal%TYPE;
540:

Line 537: l_sequence_num_enrol_load_cal igs_ps_unit_ver_all.sequence_num_enrol_load_cal%TYPE;

533: cur_unit_ver_offer_rec cur_unit_ver_offer%ROWTYPE;
534:
535:
536: l_cal_type_enrol_load_cal igs_ps_unit_ver_all.cal_type_enrol_load_cal%TYPE ;
537: l_sequence_num_enrol_load_cal igs_ps_unit_ver_all.sequence_num_enrol_load_cal%TYPE;
538: l_cal_type_offer_load_cal igs_ps_unit_ver_all.cal_type_offer_load_cal%TYPE;
539: l_sequence_num_offer_load_cal igs_ps_unit_ver_all.sequence_num_offer_load_cal%TYPE;
540:
541:

Line 538: l_cal_type_offer_load_cal igs_ps_unit_ver_all.cal_type_offer_load_cal%TYPE;

534:
535:
536: l_cal_type_enrol_load_cal igs_ps_unit_ver_all.cal_type_enrol_load_cal%TYPE ;
537: l_sequence_num_enrol_load_cal igs_ps_unit_ver_all.sequence_num_enrol_load_cal%TYPE;
538: l_cal_type_offer_load_cal igs_ps_unit_ver_all.cal_type_offer_load_cal%TYPE;
539: l_sequence_num_offer_load_cal igs_ps_unit_ver_all.sequence_num_offer_load_cal%TYPE;
540:
541:
542: BEGIN

Line 539: l_sequence_num_offer_load_cal igs_ps_unit_ver_all.sequence_num_offer_load_cal%TYPE;

535:
536: l_cal_type_enrol_load_cal igs_ps_unit_ver_all.cal_type_enrol_load_cal%TYPE ;
537: l_sequence_num_enrol_load_cal igs_ps_unit_ver_all.sequence_num_enrol_load_cal%TYPE;
538: l_cal_type_offer_load_cal igs_ps_unit_ver_all.cal_type_offer_load_cal%TYPE;
539: l_sequence_num_offer_load_cal igs_ps_unit_ver_all.sequence_num_offer_load_cal%TYPE;
540:
541:
542: BEGIN
543:

Line 586: --Fetch the Enrolled Calendar Instance for the unit from IGS_PS_UNIT_VER.

582: -- Fectch the Load Calendar Instance for the teaching calendar instance of a unit.
583: OPEN cur_teach_to_load(cur_ps_unit_ofr_opt_enroll_rec.cal_type,cur_ps_unit_ofr_opt_enroll_rec.ci_sequence_number);
584: FETCH cur_teach_to_load INTO cur_teach_to_load_rec;
585:
586: --Fetch the Enrolled Calendar Instance for the unit from IGS_PS_UNIT_VER.
587: OPEN cur_unit_ver_enroll(cur_units_rec.unit_cd,cur_units_rec.version_number);
588: FETCH cur_unit_ver_enroll INTO cur_unit_ver_enroll_rec;
589:
590: -- If Load Calendar Instance is greater than the Enrolled Calendar Instance or there is no calendar instance defined for the unit

Line 591: -- then Update the table,IGS_PS_UNIT_VER

587: OPEN cur_unit_ver_enroll(cur_units_rec.unit_cd,cur_units_rec.version_number);
588: FETCH cur_unit_ver_enroll INTO cur_unit_ver_enroll_rec;
589:
590: -- If Load Calendar Instance is greater than the Enrolled Calendar Instance or there is no calendar instance defined for the unit
591: -- then Update the table,IGS_PS_UNIT_VER
592:
593: IF ( cur_unit_ver_enroll%NOTFOUND OR
594: TRUNC(cur_unit_ver_enroll_rec.start_date) < TRUNC(cur_teach_to_load_rec.load_start_dt) ) THEN
595:

Line 596: -- Set the value of cal_type_enrol_load_cal and sequence_num_enrol_load_cal of IGS_PS_UNIT_VER table.

592:
593: IF ( cur_unit_ver_enroll%NOTFOUND OR
594: TRUNC(cur_unit_ver_enroll_rec.start_date) < TRUNC(cur_teach_to_load_rec.load_start_dt) ) THEN
595:
596: -- Set the value of cal_type_enrol_load_cal and sequence_num_enrol_load_cal of IGS_PS_UNIT_VER table.
597: l_cal_type_enrol_load_cal := cur_teach_to_load_rec.load_cal_type;
598: l_sequence_num_enrol_load_cal := cur_teach_to_load_rec.load_ci_sequence_number;
599:
600: END IF;

Line 618: --Fetch the Offered Calendar Instance for the unit from IGS_PS_UNIT_VER.

614: -- Fectch the Load Calendar Instance for the teaching calendar instance of a unit.
615: OPEN cur_teach_to_load(cur_ps_unit_ofr_opt_offer_rec.cal_type,cur_ps_unit_ofr_opt_offer_rec.ci_sequence_number);
616: FETCH cur_teach_to_load INTO cur_teach_to_load_rec;
617:
618: --Fetch the Offered Calendar Instance for the unit from IGS_PS_UNIT_VER.
619: OPEN cur_unit_ver_offer(cur_units_rec.unit_cd,cur_units_rec.version_number);
620: FETCH cur_unit_ver_offer INTO cur_unit_ver_offer_rec;
621:
622: -- If Load Calendar Instance is greater than the Enrolled Calendar Instance then Update the table,IGS_PS_UNIT_VER.

Line 622: -- If Load Calendar Instance is greater than the Enrolled Calendar Instance then Update the table,IGS_PS_UNIT_VER.

618: --Fetch the Offered Calendar Instance for the unit from IGS_PS_UNIT_VER.
619: OPEN cur_unit_ver_offer(cur_units_rec.unit_cd,cur_units_rec.version_number);
620: FETCH cur_unit_ver_offer INTO cur_unit_ver_offer_rec;
621:
622: -- If Load Calendar Instance is greater than the Enrolled Calendar Instance then Update the table,IGS_PS_UNIT_VER.
623: IF ( cur_unit_ver_offer%NOTFOUND OR
624: TRUNC(cur_unit_ver_offer_rec.start_date) < TRUNC(cur_teach_to_load_rec.load_start_dt) ) THEN
625:
626: -- Set the value of cal_type_offer_load_cal and sequence_num_offer_load_cal of IGS_PS_UNIT_VER table.

Line 626: -- Set the value of cal_type_offer_load_cal and sequence_num_offer_load_cal of IGS_PS_UNIT_VER table.

622: -- If Load Calendar Instance is greater than the Enrolled Calendar Instance then Update the table,IGS_PS_UNIT_VER.
623: IF ( cur_unit_ver_offer%NOTFOUND OR
624: TRUNC(cur_unit_ver_offer_rec.start_date) < TRUNC(cur_teach_to_load_rec.load_start_dt) ) THEN
625:
626: -- Set the value of cal_type_offer_load_cal and sequence_num_offer_load_cal of IGS_PS_UNIT_VER table.
627: l_cal_type_offer_load_cal := cur_teach_to_load_rec.load_cal_type ;
628: l_sequence_num_offer_load_cal := cur_teach_to_load_rec.load_ci_sequence_number;
629:
630: END IF; -- End of Updation