[Home] [Help]
15: -- sarakshi 18-Apr-2003 Bug#2910695,modified procedure crspl_ins_unit_off_opt and CRSP_INS_UOP_UOO
16: -- sarakshi 05-Mar-2003 Bug#2768783, modified procedure crsp_ins_uop_uoo and crspl_ins_unit_off_opt,
17: -- removed local function check_call_number
18: -- shtatiko 06-NOV-2002 Added auditable_ind and audit_permission_ind parameters to
19: -- insert_row calls of igs_ps_unit_ofr_opt_pkg as part of
20: -- bug# 2636716, EN Integration.
21: -- jbegum 11-Sep-2002 As part of bug#2563596
22: -- 1) The logic of FUNCTION CRSP_INS_UOP_UOO has been modified.
23: -- 2) The PROCEDURE handle_excp has been modified.
23: -- 2) The PROCEDURE handle_excp has been modified.
24: -- 3) The exception handling of FUNCTION CRSP_INS_UOP_UOO has been modified
25: -- sarakshi 5-Jun-2002 bug#2332807, changes are mentioned in detail in the code, procedure crsp_ins_uop_uoo.
26: -- prraj 14-Feb-2002 Added column NON_STD_USEC_IND to tbh calls for
27: -- pkg IGS_PS_UNIT_OFR_OPT_PKG (Bug# 2224366)
28: -- ayedubat 30-JAN-2002 Changed the crsp_ins_unit_ver procedure to add the HESA functionality
29: -- as per the HESA Integration DLD ( Bug # 2201753)
30: -- ddey 01-FEB-2002 Added columns anon_unit_grading_ind and anon_assess_grading_ind in the calls
31: -- for the package IGS_PS_UNIT_OFR_OPT_PKG
27: -- pkg IGS_PS_UNIT_OFR_OPT_PKG (Bug# 2224366)
28: -- ayedubat 30-JAN-2002 Changed the crsp_ins_unit_ver procedure to add the HESA functionality
29: -- as per the HESA Integration DLD ( Bug # 2201753)
30: -- ddey 01-FEB-2002 Added columns anon_unit_grading_ind and anon_assess_grading_ind in the calls
31: -- for the package IGS_PS_UNIT_OFR_OPT_PKG
32: -- smadathi 28-AUG-2001 Bug No. 1956374 .The call to igs_ps_val_uoo.genp_val_staff_prsn
33: -- is changed to igs_ad_val_acai.genp_val_staff_prsn
34: -- nalkumar 02-Jan-2002 Modified the crspl_ins_unit_assmnt_item procedure as per the
35: -- Calculation of Results Part-1 DLD. Bug# 2162831
661: OPEN cur_usec(p_uoo_id);
662: FETCH cur_usec INTO l_cur_usec;
663: CLOSE cur_usec;
664:
665: igs_ps_unit_ofr_opt_pkg.update_row( x_rowid =>l_cur_usec.row_id,
666: x_unit_cd =>l_cur_usec.unit_cd,
667: x_version_number =>l_cur_usec.version_number,
668: x_cal_type =>l_cur_usec.cal_type,
669: x_ci_sequence_number =>l_cur_usec.ci_sequence_number,
1393: sarakshi 14-oct-2004 Bug#3945817, passsing unit section status as mentioned in the bug.
1394: sarakshi 31-AUG-2004 Bug#3864738,passed unit_section_status as OPEN in the insert row call of IGS_PS_UNIT_OFR_OPT
1395: sarakshi 13-Apr-2004 Bug#3555871, removed the logic of getting the call number for AUTO profile option.
1396: sarakshi 17-oct-2003 Enh#3168650,Added call to the procedure crspl_upd_usec_relation
1397: sarakshi 23-sep-2003 Enh#3052452,Added column sup_uoo_id,relation_type,default_enroll_flag to the call of igs_ps_unit_ofr_opt_pkg.insert_row
1398: vvutukur 05-aug-2003 Enh#3045069.PSP Enh Build. Modified the call to igs_ps_unit_ofr_opt_pkg.insert_row to added new column not_multiple_section_flag.
1399: sarakshi 18-Apr-2003 Bug#2910695,passed actual_enrollment and actual_waitlist null in the table IGS_PS_OFR_OPT_ALL
1400: sarakshi 05-Mar-2003 bug#2768783,added logic for checking/generating the call number
1401: */
1394: sarakshi 31-AUG-2004 Bug#3864738,passed unit_section_status as OPEN in the insert row call of IGS_PS_UNIT_OFR_OPT
1395: sarakshi 13-Apr-2004 Bug#3555871, removed the logic of getting the call number for AUTO profile option.
1396: sarakshi 17-oct-2003 Enh#3168650,Added call to the procedure crspl_upd_usec_relation
1397: sarakshi 23-sep-2003 Enh#3052452,Added column sup_uoo_id,relation_type,default_enroll_flag to the call of igs_ps_unit_ofr_opt_pkg.insert_row
1398: vvutukur 05-aug-2003 Enh#3045069.PSP Enh Build. Modified the call to igs_ps_unit_ofr_opt_pkg.insert_row to added new column not_multiple_section_flag.
1399: sarakshi 18-Apr-2003 Bug#2910695,passed actual_enrollment and actual_waitlist null in the table IGS_PS_OFR_OPT_ALL
1400: sarakshi 05-Mar-2003 bug#2768783,added logic for checking/generating the call number
1401: */
1402: v_unit_offer_opt_rec IGS_PS_UNIT_OFR_OPT%ROWTYPE;
1441: v_unit_offer_opt_rec.call_number:=NULL;
1442: ELSIF ( fnd_profile.value('IGS_PS_CALL_NUMBER') = 'USER_DEFINED' ) THEN
1443:
1444: IF v_unit_offer_opt_rec.call_number IS NOT NULL THEN
1445: IF NOT igs_ps_unit_ofr_opt_pkg.check_call_number ( p_teach_cal_type => v_unit_offer_opt_rec.cal_type,
1446: p_teach_sequence_num => v_unit_offer_opt_rec.ci_sequence_number,
1447: p_call_number => v_unit_offer_opt_rec.call_number,
1448: p_rowid => x_rowid ) THEN
1449: v_unit_offer_opt_rec.call_number:=NULL;
1453: END IF;
1454:
1455: l_c_usec_status := get_section_status(v_unit_offer_opt_rec.unit_section_status);
1456:
1457: IGS_PS_UNIT_OFR_OPT_PKG.INSERT_ROW(
1458: X_ROWID => x_rowid,
1459: X_UNIT_CD => p_new_unit_cd,
1460: X_VERSION_NUMBER => P_new_version_number,
1461: X_CAL_TYPE => v_unit_offer_opt_rec.cal_type,
2455: --sarakshi 31-AUG-2004 Bug#3864738,passed unit_section_status as OPEN in the insert row call of IGS_PS_UNIT_OFR_OPT
2456: --sarakshi 12-Jul-2004 Bug#3729462, Added the predicate DELETE_FLAG='N' to the cursor c_uop_dest_rec
2457: --sarakshi 02-Jun-2004 Bug#3655650,modified cursor c_uai_source_rec and its usage, also added logic to rollover the unit assessment items groups
2458: --sarakshi 13-Apr-2004 Bug#3555871, removed the logic of getting the call number for AUTO profile option.
2459: --sarakshi 23-sep-2003 ENh#3052452,created local procedure crspl_upd_usec_relation and the call of the same .Also added column sup_uoo_id,relation_type,default_enroll_flag to the call of igs_ps_unit_ofr_opt_pkg.insert_row
2460: --sarakhsi 29-Aug-2003 Bug#3076021,shifted teh local function crspl_ins_teach_resp_ovrd to IGSPS01B.pls(only logic),also set the value of unit_section_status,unit section start_dt and unit_section_end_dt appropriately
2461: --vvutukur 05-Aug-2003 Enh#3045069.PSP Enh Build. Modified call to igs_ps_unit_ofr_opt_pkg.insert_row to include new parameter not_multiple_section_flag.
2462: --sarakshi 18-Apr-2003 Bug#2910695,passed null to actual_enrollment,actual_waitlist to IGS_PS_UNIT_OFR_OPT_ALL
2463: --sarakshi 05-Mar-2003 Bug#2768783,replaced the local function call check_call_number with
2457: --sarakshi 02-Jun-2004 Bug#3655650,modified cursor c_uai_source_rec and its usage, also added logic to rollover the unit assessment items groups
2458: --sarakshi 13-Apr-2004 Bug#3555871, removed the logic of getting the call number for AUTO profile option.
2459: --sarakshi 23-sep-2003 ENh#3052452,created local procedure crspl_upd_usec_relation and the call of the same .Also added column sup_uoo_id,relation_type,default_enroll_flag to the call of igs_ps_unit_ofr_opt_pkg.insert_row
2460: --sarakhsi 29-Aug-2003 Bug#3076021,shifted teh local function crspl_ins_teach_resp_ovrd to IGSPS01B.pls(only logic),also set the value of unit_section_status,unit section start_dt and unit_section_end_dt appropriately
2461: --vvutukur 05-Aug-2003 Enh#3045069.PSP Enh Build. Modified call to igs_ps_unit_ofr_opt_pkg.insert_row to include new parameter not_multiple_section_flag.
2462: --sarakshi 18-Apr-2003 Bug#2910695,passed null to actual_enrollment,actual_waitlist to IGS_PS_UNIT_OFR_OPT_ALL
2463: --sarakshi 05-Mar-2003 Bug#2768783,replaced the local function call check_call_number with
2464: -- igs_ps_unit_ofr_opt_pkg.check_call_number.Also coded logic for validating/generating call_number
2465: --sarakshi 18-sep-2002 changed the variable name p_message_name to l_message_name,bug#2563596
2460: --sarakhsi 29-Aug-2003 Bug#3076021,shifted teh local function crspl_ins_teach_resp_ovrd to IGSPS01B.pls(only logic),also set the value of unit_section_status,unit section start_dt and unit_section_end_dt appropriately
2461: --vvutukur 05-Aug-2003 Enh#3045069.PSP Enh Build. Modified call to igs_ps_unit_ofr_opt_pkg.insert_row to include new parameter not_multiple_section_flag.
2462: --sarakshi 18-Apr-2003 Bug#2910695,passed null to actual_enrollment,actual_waitlist to IGS_PS_UNIT_OFR_OPT_ALL
2463: --sarakshi 05-Mar-2003 Bug#2768783,replaced the local function call check_call_number with
2464: -- igs_ps_unit_ofr_opt_pkg.check_call_number.Also coded logic for validating/generating call_number
2465: --sarakshi 18-sep-2002 changed the variable name p_message_name to l_message_name,bug#2563596
2466: --sarakshi 06-Jun-2002 Local procedure to handle the exception condition ,bug#2332807
2467: -------------------------------------------------------------------------------------------------------------------------------------
2468:
3208: v_uoo_rec.call_number:=NULL;
3209: ELSIF ( fnd_profile.value('IGS_PS_CALL_NUMBER') = 'USER_DEFINED' ) THEN
3210:
3211: IF v_uoo_rec.call_number IS NOT NULL THEN
3212: IF NOT igs_ps_unit_ofr_opt_pkg.check_call_number ( p_teach_cal_type => p_cal_type,
3213: p_teach_sequence_num => p_dest_ci_sequence_number,
3214: p_call_number => v_uoo_rec.call_number,
3215: p_rowid => x_rowid ) THEN
3216: v_uoo_rec.call_number:=NULL;
3258: l_c_usec_status := get_section_status(v_uoo_rec.unit_section_status);
3259:
3260: -- Added auditable_ind and audit_permission_ind parameters to the following insert_row call
3261: -- as part of Bug# 2636716, EN Integration by shtatiko
3262: igs_ps_unit_ofr_opt_pkg.insert_row(
3263: x_rowid => x_rowid,
3264: x_unit_cd => v_uoo_rec.unit_cd,
3265: x_version_number => v_uoo_rec.version_number,
3266: x_cal_type => p_cal_type,