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

Line 19: -- insert_row calls of igs_ps_unit_ofr_opt_pkg as part of

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.

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

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

Line 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

Line 603: FUNCTION get_section_status (p_c_src_usec_status igs_ps_unit_ofr_opt_all.unit_section_status%TYPE

599: IGS_GE_MSG_STACK.ADD;
600: App_Exception.Raise_Exception;
601: END crsp_ins_unit_set;
602:
603: FUNCTION get_section_status (p_c_src_usec_status igs_ps_unit_ofr_opt_all.unit_section_status%TYPE
604: ) RETURN VARCHAR2 AS
605: /*************************************************************
606: Created By : sarakshi
607: Date Created By :14-Oct-2004

Line 615: l_c_usec_status igs_ps_unit_ofr_opt_all.unit_section_status%TYPE;

611: Who When What
612:
613: (reverse chronological order - newest change first)
614: ***************************************************************/
615: l_c_usec_status igs_ps_unit_ofr_opt_all.unit_section_status%TYPE;
616: BEGIN
617: IF p_c_src_usec_status = 'OPEN' THEN
618: l_c_usec_status := 'OPEN';
619: ELSIF p_c_src_usec_status = 'PLANNED' THEN

Line 638: --Private procedure for updating the sup_uo_id and relation_type value of IGS_PS_UNIT_OFR_OPT_ALL

634:
635: END get_section_status;
636:
637:
638: --Private procedure for updating the sup_uo_id and relation_type value of IGS_PS_UNIT_OFR_OPT_ALL
639: PROCEDURE update_usec_record (p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
640: p_relation_type igs_ps_unit_ofr_opt.relation_type%TYPE,
641: p_sup_uoo_id igs_ps_unit_ofr_opt.sup_uoo_id%TYPE,
642: p_default_enroll_flag igs_ps_unit_ofr_opt.default_enroll_flag%TYPE) IS

Line 639: PROCEDURE update_usec_record (p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,

635: END get_section_status;
636:
637:
638: --Private procedure for updating the sup_uo_id and relation_type value of IGS_PS_UNIT_OFR_OPT_ALL
639: PROCEDURE update_usec_record (p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
640: p_relation_type igs_ps_unit_ofr_opt.relation_type%TYPE,
641: p_sup_uoo_id igs_ps_unit_ofr_opt.sup_uoo_id%TYPE,
642: p_default_enroll_flag igs_ps_unit_ofr_opt.default_enroll_flag%TYPE) IS
643: /*----------------------------------------------------------------------------

Line 640: p_relation_type igs_ps_unit_ofr_opt.relation_type%TYPE,

636:
637:
638: --Private procedure for updating the sup_uo_id and relation_type value of IGS_PS_UNIT_OFR_OPT_ALL
639: PROCEDURE update_usec_record (p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
640: p_relation_type igs_ps_unit_ofr_opt.relation_type%TYPE,
641: p_sup_uoo_id igs_ps_unit_ofr_opt.sup_uoo_id%TYPE,
642: p_default_enroll_flag igs_ps_unit_ofr_opt.default_enroll_flag%TYPE) IS
643: /*----------------------------------------------------------------------------
644: || Created By :sarakshi

Line 641: p_sup_uoo_id igs_ps_unit_ofr_opt.sup_uoo_id%TYPE,

637:
638: --Private procedure for updating the sup_uo_id and relation_type value of IGS_PS_UNIT_OFR_OPT_ALL
639: PROCEDURE update_usec_record (p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
640: p_relation_type igs_ps_unit_ofr_opt.relation_type%TYPE,
641: p_sup_uoo_id igs_ps_unit_ofr_opt.sup_uoo_id%TYPE,
642: p_default_enroll_flag igs_ps_unit_ofr_opt.default_enroll_flag%TYPE) IS
643: /*----------------------------------------------------------------------------
644: || Created By :sarakshi
645: || Created On :17-oct-2003

Line 642: p_default_enroll_flag igs_ps_unit_ofr_opt.default_enroll_flag%TYPE) IS

638: --Private procedure for updating the sup_uo_id and relation_type value of IGS_PS_UNIT_OFR_OPT_ALL
639: PROCEDURE update_usec_record (p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
640: p_relation_type igs_ps_unit_ofr_opt.relation_type%TYPE,
641: p_sup_uoo_id igs_ps_unit_ofr_opt.sup_uoo_id%TYPE,
642: p_default_enroll_flag igs_ps_unit_ofr_opt.default_enroll_flag%TYPE) IS
643: /*----------------------------------------------------------------------------
644: || Created By :sarakshi
645: || Created On :17-oct-2003
646: || Purpose :For updating the sup_uo_id and relation_type value of IGS_PS_UNIT_OFR_OPT_ALL from multiple places in this package

Line 646: || Purpose :For updating the sup_uo_id and relation_type value of IGS_PS_UNIT_OFR_OPT_ALL from multiple places in this package

642: p_default_enroll_flag igs_ps_unit_ofr_opt.default_enroll_flag%TYPE) IS
643: /*----------------------------------------------------------------------------
644: || Created By :sarakshi
645: || Created On :17-oct-2003
646: || Purpose :For updating the sup_uo_id and relation_type value of IGS_PS_UNIT_OFR_OPT_ALL from multiple places in this package
647: || Known limitations, enhancements or remarks :
648: || Change History :
649: || Who When What
650: || (reverse chronological order - newest change first)

Line 654: CURSOR cur_usec(cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS

650: || (reverse chronological order - newest change first)
651: || sarakshi 17-Nov-2005 Bug#4726940,changed the signature by adding p_default_enroll_flag
652: ----------------------------------------------------------------------------*/
653:
654: CURSOR cur_usec(cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
655: SELECT *
656: FROM igs_ps_unit_ofr_opt
657: WHERE uoo_id=cp_uoo_id;
658: l_cur_usec cur_usec%ROWTYPE;

Line 656: FROM igs_ps_unit_ofr_opt

652: ----------------------------------------------------------------------------*/
653:
654: CURSOR cur_usec(cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
655: SELECT *
656: FROM igs_ps_unit_ofr_opt
657: WHERE uoo_id=cp_uoo_id;
658: l_cur_usec cur_usec%ROWTYPE;
659:
660: BEGIN

Line 665: igs_ps_unit_ofr_opt_pkg.update_row( x_rowid =>l_cur_usec.row_id,

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,

Line 1162: p_cal_type IN IGS_PS_UNIT_OFR_OPT.cal_type%TYPE,

1158: END crspl_ins_unit_off_opt_note;
1159: PROCEDURE crspl_ins_teach_resp_ovrd(
1160: p_unit_cd IN IGS_PS_UNIT_VER.unit_cd%TYPE,
1161: p_version_number IN IGS_PS_UNIT_VER.version_number%TYPE,
1162: p_cal_type IN IGS_PS_UNIT_OFR_OPT.cal_type%TYPE,
1163: p_ci_sequence_number IN IGS_PS_UNIT_OFR_OPT.ci_sequence_number%TYPE,
1164: p_location_cd IN IGS_PS_UNIT_OFR_OPT.location_cd%TYPE,
1165: p_unit_class IN IGS_PS_UNIT_OFR_OPT.unit_class%TYPE,
1166: p_new_uoo_id IN IGS_PS_UNT_OFR_OPT_N.uoo_id%TYPE)

Line 1163: p_ci_sequence_number IN IGS_PS_UNIT_OFR_OPT.ci_sequence_number%TYPE,

1159: PROCEDURE crspl_ins_teach_resp_ovrd(
1160: p_unit_cd IN IGS_PS_UNIT_VER.unit_cd%TYPE,
1161: p_version_number IN IGS_PS_UNIT_VER.version_number%TYPE,
1162: p_cal_type IN IGS_PS_UNIT_OFR_OPT.cal_type%TYPE,
1163: p_ci_sequence_number IN IGS_PS_UNIT_OFR_OPT.ci_sequence_number%TYPE,
1164: p_location_cd IN IGS_PS_UNIT_OFR_OPT.location_cd%TYPE,
1165: p_unit_class IN IGS_PS_UNIT_OFR_OPT.unit_class%TYPE,
1166: p_new_uoo_id IN IGS_PS_UNT_OFR_OPT_N.uoo_id%TYPE)
1167: AS

Line 1164: p_location_cd IN IGS_PS_UNIT_OFR_OPT.location_cd%TYPE,

1160: p_unit_cd IN IGS_PS_UNIT_VER.unit_cd%TYPE,
1161: p_version_number IN IGS_PS_UNIT_VER.version_number%TYPE,
1162: p_cal_type IN IGS_PS_UNIT_OFR_OPT.cal_type%TYPE,
1163: p_ci_sequence_number IN IGS_PS_UNIT_OFR_OPT.ci_sequence_number%TYPE,
1164: p_location_cd IN IGS_PS_UNIT_OFR_OPT.location_cd%TYPE,
1165: p_unit_class IN IGS_PS_UNIT_OFR_OPT.unit_class%TYPE,
1166: p_new_uoo_id IN IGS_PS_UNT_OFR_OPT_N.uoo_id%TYPE)
1167: AS
1168: CURSOR c_tro IS

Line 1165: p_unit_class IN IGS_PS_UNIT_OFR_OPT.unit_class%TYPE,

1161: p_version_number IN IGS_PS_UNIT_VER.version_number%TYPE,
1162: p_cal_type IN IGS_PS_UNIT_OFR_OPT.cal_type%TYPE,
1163: p_ci_sequence_number IN IGS_PS_UNIT_OFR_OPT.ci_sequence_number%TYPE,
1164: p_location_cd IN IGS_PS_UNIT_OFR_OPT.location_cd%TYPE,
1165: p_unit_class IN IGS_PS_UNIT_OFR_OPT.unit_class%TYPE,
1166: p_new_uoo_id IN IGS_PS_UNT_OFR_OPT_N.uoo_id%TYPE)
1167: AS
1168: CURSOR c_tro IS
1169: SELECT tro.location_cd,

Line 1227: PROCEDURE crspl_upd_usec_relation( p_old_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE,

1223: END IF;
1224: END crspl_ins_teach_resp_ovrd;
1225:
1226:
1227: PROCEDURE crspl_upd_usec_relation( p_old_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
1228: p_new_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) AS
1229: /*----------------------------------------------------------------------------
1230: || Created By :sarakshi
1231: || Created On :17-oct-2003

Line 1228: p_new_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) AS

1224: END crspl_ins_teach_resp_ovrd;
1225:
1226:
1227: PROCEDURE crspl_upd_usec_relation( p_old_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
1228: p_new_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) AS
1229: /*----------------------------------------------------------------------------
1230: || Created By :sarakshi
1231: || Created On :17-oct-2003
1232: || Purpose :For Rolling over the unit section relationship

Line 1248: FROM igs_ps_unit_ofr_opt

1244: l_c_planned VARCHAR2(10);
1245:
1246: CURSOR c_old_sub IS
1247: SELECT *
1248: FROM igs_ps_unit_ofr_opt
1249: WHERE relation_type = l_c_subordinate
1250: AND sup_uoo_id = p_old_uoo_id;
1251:
1252: CURSOR c_old_sup IS

Line 1254: FROM igs_ps_unit_ofr_opt

1250: AND sup_uoo_id = p_old_uoo_id;
1251:
1252: CURSOR c_old_sup IS
1253: SELECT *
1254: FROM igs_ps_unit_ofr_opt
1255: WHERE relation_type = l_c_superior
1256: AND uoo_id = (SELECT sup_uoo_id
1257: FROM igs_ps_unit_ofr_opt
1258: WHERE uoo_id = p_old_uoo_id

Line 1257: FROM igs_ps_unit_ofr_opt

1253: SELECT *
1254: FROM igs_ps_unit_ofr_opt
1255: WHERE relation_type = l_c_superior
1256: AND uoo_id = (SELECT sup_uoo_id
1257: FROM igs_ps_unit_ofr_opt
1258: WHERE uoo_id = p_old_uoo_id
1259: );
1260:
1261: CURSOR c_new_sub(cp_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE,

Line 1261: CURSOR c_new_sub(cp_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE,

1257: FROM igs_ps_unit_ofr_opt
1258: WHERE uoo_id = p_old_uoo_id
1259: );
1260:
1261: CURSOR c_new_sub(cp_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE,
1262: cp_ci_sequence_number igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE,
1263: cp_location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
1264: cp_unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
1265: cp_unit_cd igs_ps_unit_ofr_opt_all.unit_cd%TYPE,

Line 1262: cp_ci_sequence_number igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE,

1258: WHERE uoo_id = p_old_uoo_id
1259: );
1260:
1261: CURSOR c_new_sub(cp_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE,
1262: cp_ci_sequence_number igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE,
1263: cp_location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
1264: cp_unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
1265: cp_unit_cd igs_ps_unit_ofr_opt_all.unit_cd%TYPE,
1266: cp_version_number igs_ps_unit_ofr_opt_all.version_number%TYPE

Line 1263: cp_location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,

1259: );
1260:
1261: CURSOR c_new_sub(cp_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE,
1262: cp_ci_sequence_number igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE,
1263: cp_location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
1264: cp_unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
1265: cp_unit_cd igs_ps_unit_ofr_opt_all.unit_cd%TYPE,
1266: cp_version_number igs_ps_unit_ofr_opt_all.version_number%TYPE
1267: )IS

Line 1264: cp_unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,

1260:
1261: CURSOR c_new_sub(cp_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE,
1262: cp_ci_sequence_number igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE,
1263: cp_location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
1264: cp_unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
1265: cp_unit_cd igs_ps_unit_ofr_opt_all.unit_cd%TYPE,
1266: cp_version_number igs_ps_unit_ofr_opt_all.version_number%TYPE
1267: )IS
1268: SELECT uoo.*

Line 1265: cp_unit_cd igs_ps_unit_ofr_opt_all.unit_cd%TYPE,

1261: CURSOR c_new_sub(cp_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE,
1262: cp_ci_sequence_number igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE,
1263: cp_location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
1264: cp_unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
1265: cp_unit_cd igs_ps_unit_ofr_opt_all.unit_cd%TYPE,
1266: cp_version_number igs_ps_unit_ofr_opt_all.version_number%TYPE
1267: )IS
1268: SELECT uoo.*
1269: FROM igs_ps_unit_ofr_opt_all uoo,igs_ps_unit_ver_all uv, igs_ps_unit_stat us

Line 1266: cp_version_number igs_ps_unit_ofr_opt_all.version_number%TYPE

1262: cp_ci_sequence_number igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE,
1263: cp_location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
1264: cp_unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
1265: cp_unit_cd igs_ps_unit_ofr_opt_all.unit_cd%TYPE,
1266: cp_version_number igs_ps_unit_ofr_opt_all.version_number%TYPE
1267: )IS
1268: SELECT uoo.*
1269: FROM igs_ps_unit_ofr_opt_all uoo,igs_ps_unit_ver_all uv, igs_ps_unit_stat us
1270: WHERE uoo.cal_type = cp_cal_type

Line 1269: FROM igs_ps_unit_ofr_opt_all uoo,igs_ps_unit_ver_all uv, igs_ps_unit_stat us

1265: cp_unit_cd igs_ps_unit_ofr_opt_all.unit_cd%TYPE,
1266: cp_version_number igs_ps_unit_ofr_opt_all.version_number%TYPE
1267: )IS
1268: SELECT uoo.*
1269: FROM igs_ps_unit_ofr_opt_all uoo,igs_ps_unit_ver_all uv, igs_ps_unit_stat us
1270: WHERE uoo.cal_type = cp_cal_type
1271: AND uoo.ci_sequence_number = cp_ci_sequence_number
1272: AND uoo.location_cd = cp_location_cd
1273: AND uoo.unit_class = cp_unit_class

Line 1284: CURSOR c_new_sup(cp_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE,

1280: AND uoo.relation_type = l_c_none
1281: AND uoo_id NOT IN (SELECT uoo_id FROM igs_en_su_attempt)
1282: ORDER BY uoo.unit_cd,uoo.version_number ASC;
1283:
1284: CURSOR c_new_sup(cp_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE,
1285: cp_ci_sequence_number igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE,
1286: cp_location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
1287: cp_unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
1288: cp_unit_cd igs_ps_unit_ofr_opt_all.unit_cd%TYPE,

Line 1285: cp_ci_sequence_number igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE,

1281: AND uoo_id NOT IN (SELECT uoo_id FROM igs_en_su_attempt)
1282: ORDER BY uoo.unit_cd,uoo.version_number ASC;
1283:
1284: CURSOR c_new_sup(cp_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE,
1285: cp_ci_sequence_number igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE,
1286: cp_location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
1287: cp_unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
1288: cp_unit_cd igs_ps_unit_ofr_opt_all.unit_cd%TYPE,
1289: cp_version_number igs_ps_unit_ofr_opt_all.version_number%TYPE

Line 1286: cp_location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,

1282: ORDER BY uoo.unit_cd,uoo.version_number ASC;
1283:
1284: CURSOR c_new_sup(cp_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE,
1285: cp_ci_sequence_number igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE,
1286: cp_location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
1287: cp_unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
1288: cp_unit_cd igs_ps_unit_ofr_opt_all.unit_cd%TYPE,
1289: cp_version_number igs_ps_unit_ofr_opt_all.version_number%TYPE
1290: )IS

Line 1287: cp_unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,

1283:
1284: CURSOR c_new_sup(cp_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE,
1285: cp_ci_sequence_number igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE,
1286: cp_location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
1287: cp_unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
1288: cp_unit_cd igs_ps_unit_ofr_opt_all.unit_cd%TYPE,
1289: cp_version_number igs_ps_unit_ofr_opt_all.version_number%TYPE
1290: )IS
1291: SELECT uoo.*

Line 1288: cp_unit_cd igs_ps_unit_ofr_opt_all.unit_cd%TYPE,

1284: CURSOR c_new_sup(cp_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE,
1285: cp_ci_sequence_number igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE,
1286: cp_location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
1287: cp_unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
1288: cp_unit_cd igs_ps_unit_ofr_opt_all.unit_cd%TYPE,
1289: cp_version_number igs_ps_unit_ofr_opt_all.version_number%TYPE
1290: )IS
1291: SELECT uoo.*
1292: FROM igs_ps_unit_ofr_opt_all uoo,igs_ps_unit_ver_all uv, igs_ps_unit_stat us

Line 1289: cp_version_number igs_ps_unit_ofr_opt_all.version_number%TYPE

1285: cp_ci_sequence_number igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE,
1286: cp_location_cd igs_ps_unit_ofr_opt_all.location_cd%TYPE,
1287: cp_unit_class igs_ps_unit_ofr_opt_all.unit_class%TYPE,
1288: cp_unit_cd igs_ps_unit_ofr_opt_all.unit_cd%TYPE,
1289: cp_version_number igs_ps_unit_ofr_opt_all.version_number%TYPE
1290: )IS
1291: SELECT uoo.*
1292: FROM igs_ps_unit_ofr_opt_all uoo,igs_ps_unit_ver_all uv, igs_ps_unit_stat us
1293: WHERE uoo.cal_type = cp_cal_type

Line 1292: FROM igs_ps_unit_ofr_opt_all uoo,igs_ps_unit_ver_all uv, igs_ps_unit_stat us

1288: cp_unit_cd igs_ps_unit_ofr_opt_all.unit_cd%TYPE,
1289: cp_version_number igs_ps_unit_ofr_opt_all.version_number%TYPE
1290: )IS
1291: SELECT uoo.*
1292: FROM igs_ps_unit_ofr_opt_all uoo,igs_ps_unit_ver_all uv, igs_ps_unit_stat us
1293: WHERE uoo.cal_type = cp_cal_type
1294: AND uoo.ci_sequence_number = cp_ci_sequence_number
1295: AND uoo.location_cd = cp_location_cd
1296: AND uoo.unit_class = cp_unit_class

Line 1388: p_cal_type IN IGS_PS_UNIT_OFR_OPT.cal_type%TYPE,

1384:
1385: PROCEDURE crspl_ins_unit_off_opt (
1386: p_unit_cd IN IGS_PS_UNIT_VER.unit_cd%TYPE,
1387: p_version_number IN IGS_PS_UNIT_VER.version_number%TYPE,
1388: p_cal_type IN IGS_PS_UNIT_OFR_OPT.cal_type%TYPE,
1389: p_ci_sequence_number IN IGS_PS_UNIT_OFR_OPT.ci_sequence_number%TYPE )
1390: AS
1391: /*
1392: WHO WHEN WHAT

Line 1389: p_ci_sequence_number IN IGS_PS_UNIT_OFR_OPT.ci_sequence_number%TYPE )

1385: PROCEDURE crspl_ins_unit_off_opt (
1386: p_unit_cd IN IGS_PS_UNIT_VER.unit_cd%TYPE,
1387: p_version_number IN IGS_PS_UNIT_VER.version_number%TYPE,
1388: p_cal_type IN IGS_PS_UNIT_OFR_OPT.cal_type%TYPE,
1389: p_ci_sequence_number IN IGS_PS_UNIT_OFR_OPT.ci_sequence_number%TYPE )
1390: AS
1391: /*
1392: WHO WHEN WHAT
1393: sarakshi 14-oct-2004 Bug#3945817, passsing unit section status as mentioned in the bug.

Line 1394: sarakshi 31-AUG-2004 Bug#3864738,passed unit_section_status as OPEN in the insert row call of IGS_PS_UNIT_OFR_OPT

1390: AS
1391: /*
1392: WHO WHEN WHAT
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.

Line 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

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: */

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

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;

Line 1402: v_unit_offer_opt_rec IGS_PS_UNIT_OFR_OPT%ROWTYPE;

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;
1403: v_new_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE;
1404: v_latest_gs_version IGS_PS_UNIT_OFR_OPT.gs_version_number%TYPE;
1405: CURSOR c_unit_offer_opt_rec IS
1406: SELECT *

Line 1403: v_new_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE;

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;
1403: v_new_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE;
1404: v_latest_gs_version IGS_PS_UNIT_OFR_OPT.gs_version_number%TYPE;
1405: CURSOR c_unit_offer_opt_rec IS
1406: SELECT *
1407: FROM IGS_PS_UNIT_OFR_OPT

Line 1404: v_latest_gs_version IGS_PS_UNIT_OFR_OPT.gs_version_number%TYPE;

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;
1403: v_new_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE;
1404: v_latest_gs_version IGS_PS_UNIT_OFR_OPT.gs_version_number%TYPE;
1405: CURSOR c_unit_offer_opt_rec IS
1406: SELECT *
1407: FROM IGS_PS_UNIT_OFR_OPT
1408: WHERE unit_cd = p_unit_cd AND

Line 1407: FROM IGS_PS_UNIT_OFR_OPT

1403: v_new_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE;
1404: v_latest_gs_version IGS_PS_UNIT_OFR_OPT.gs_version_number%TYPE;
1405: CURSOR c_unit_offer_opt_rec IS
1406: SELECT *
1407: FROM IGS_PS_UNIT_OFR_OPT
1408: WHERE unit_cd = p_unit_cd AND
1409: version_number = p_version_number AND
1410: cal_type = p_cal_type AND
1411: ci_sequence_number = p_ci_sequence_number;

Line 1419: l_c_usec_status igs_ps_unit_ofr_opt_all.unit_section_status%TYPE;

1415: FROM IGS_AS_GRD_SCHEMA gs
1416: WHERE gs.grading_schema_cd = cp_gs_cd;
1417:
1418: l_org_id NUMBER(15);
1419: l_c_usec_status igs_ps_unit_ofr_opt_all.unit_section_status%TYPE;
1420: BEGIN
1421: FOR v_unit_offer_opt_rec IN c_unit_offer_opt_rec LOOP
1422: -- get the last version number for grading schema cd
1423: OPEN c_latest_gs_version (

Line 1428: SELECT IGS_PS_UNIT_OFR_OPT_UOO_ID_S.nextval

1424: v_unit_offer_opt_rec.grading_schema_cd);
1425: FETCH c_latest_gs_version INTO v_latest_gs_version;
1426: CLOSE c_latest_gs_version;
1427: BEGIN
1428: SELECT IGS_PS_UNIT_OFR_OPT_UOO_ID_S.nextval
1429: INTO v_new_uoo_id
1430: FROM dual;
1431: x_rowid := NULL;
1432:

Line 1445: IF NOT igs_ps_unit_ofr_opt_pkg.check_call_number ( p_teach_cal_type => v_unit_offer_opt_rec.cal_type,

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;

Line 1457: IGS_PS_UNIT_OFR_OPT_PKG.INSERT_ROW(

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,

Line 1898: --- Check if the IGS_PS_UNIT_OFR_OPT exists for the old IGS_PS_UNIT code and

1894: p_unit_cd,
1895: p_version_number,
1896: v_unit_offer_pat_rec.cal_type,
1897: v_unit_offer_pat_rec.ci_sequence_number );
1898: --- Check if the IGS_PS_UNIT_OFR_OPT exists for the old IGS_PS_UNIT code and
1899: --- version number. If it does exist, create the new record with the
1900: --- substituted values.
1901: crspl_ins_unit_off_opt(
1902: p_unit_cd,

Line 2455: --sarakshi 31-AUG-2004 Bug#3864738,passed unit_section_status as OPEN in the insert row call of IGS_PS_UNIT_OFR_OPT

2451: --Who When What
2452: --sarakshi 17-Oct-2005 Bug#4657596, added fnd logging
2453: --sarakshi 14-oct-2004 Bug#3945817, passsing unit section status as mentioned in the bug.
2454: --sarakshi 14-Sep-2004 Enh#3888835, added cursor c_teach_date and it's related logic.
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

Line 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

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

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

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

Line 2462: --sarakshi 18-Apr-2003 Bug#2910695,passed null to actual_enrollment,actual_waitlist to IGS_PS_UNIT_OFR_OPT_ALL

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
2466: --sarakshi 06-Jun-2002 Local procedure to handle the exception condition ,bug#2332807

Line 2464: -- igs_ps_unit_ofr_opt_pkg.check_call_number.Also coded logic for validating/generating call_number

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:

Line 2489: l_old_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;

2485: l_var VARCHAR2(1);
2486: l_var_log cur_check_log%ROWTYPE;
2487: l_rowid VARCHAR2(25);
2488: x_rowid VARCHAR2(25);
2489: l_old_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;
2490: v_new_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;
2491:
2492:
2493: BEGIN -- crsp_ins_uop_uoo

Line 2490: v_new_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;

2486: l_var_log cur_check_log%ROWTYPE;
2487: l_rowid VARCHAR2(25);
2488: x_rowid VARCHAR2(25);
2489: l_old_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;
2490: v_new_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;
2491:
2492:
2493: BEGIN -- crsp_ins_uop_uoo
2494: -- Copy the IGS_PS_UNIT offering options and IGS_PS_UNIT assessment patterns from

Line 2512: v_unit_contact igs_ps_unit_ofr_opt.unit_contact%TYPE;

2508: v_successful_pattern_mbr BOOLEAN ;
2509: v_exam_cal_type igs_ca_inst.cal_type%TYPE;
2510: v_exam_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
2511: v_latest_gs_version igs_as_grd_schema.version_number%TYPE;
2512: v_unit_contact igs_ps_unit_ofr_opt.unit_contact%TYPE;
2513: v_assessment_type igs_as_assessmnt_typ.assessment_type%TYPE;
2514: v_reference igs_as_unitass_item.reference%TYPE;
2515: v_uai_seq_num igs_as_unitass_item.sequence_number%TYPE;
2516: l_org_id NUMBER(15);

Line 2531: FROM igs_ps_unit_ofr_opt uoo

2527: AND uop.delete_flag = 'N';
2528:
2529: CURSOR c_uoo_source_rec IS
2530: SELECT *
2531: FROM igs_ps_unit_ofr_opt uoo
2532: WHERE uoo.unit_cd = p_unit_cd
2533: AND uoo.version_number = p_version_number
2534: AND uoo.cal_type = p_source_cal_type
2535: AND uoo.ci_sequence_number = p_source_ci_sequence_number;

Line 2578: cp_location_cd IGS_PS_UNIT_OFR_OPT.location_cd%TYPE,

2574: cp_unit_cd IGS_PS_UNIT_OFR_PAT.unit_cd%TYPE,
2575: cp_version_number IGS_PS_UNIT_OFR_PAT.version_number%TYPE,
2576: cp_cal_type IGS_PS_UNIT_OFR_PAT.cal_type%TYPE,
2577: cp_dest_ci_sequence_number IGS_PS_UNIT_OFR_PAT.ci_sequence_number%TYPE,
2578: cp_location_cd IGS_PS_UNIT_OFR_OPT.location_cd%TYPE,
2579: cp_unit_class IGS_PS_UNIT_OFR_PAT.unit_cd%TYPE) IS
2580: SELECT *
2581: FROM igs_ps_unit_ofr_opt uoo
2582: WHERE uoo.unit_cd = cp_unit_cd

Line 2581: FROM igs_ps_unit_ofr_opt uoo

2577: cp_dest_ci_sequence_number IGS_PS_UNIT_OFR_PAT.ci_sequence_number%TYPE,
2578: cp_location_cd IGS_PS_UNIT_OFR_OPT.location_cd%TYPE,
2579: cp_unit_class IGS_PS_UNIT_OFR_PAT.unit_cd%TYPE) IS
2580: SELECT *
2581: FROM igs_ps_unit_ofr_opt uoo
2582: WHERE uoo.unit_cd = cp_unit_cd
2583: AND uoo.version_number = cp_version_number
2584: AND uoo.cal_type = cp_cal_type
2585: AND uoo.ci_sequence_number = cp_dest_ci_sequence_number

Line 2591: SELECT IGS_PS_UNIT_OFR_OPT_UOO_ID_S.NEXTVAL

2587: AND uoo.unit_class = cp_unit_class;
2588: v_uoo_rec_exists c_uoo_rec_exists%ROWTYPE;
2589:
2590: CURSOR c_uoo_seq_num IS
2591: SELECT IGS_PS_UNIT_OFR_OPT_UOO_ID_S.NEXTVAL
2592: FROM DUAL;
2593:
2594: CURSOR c_uai_seq_num IS
2595: SELECT IGS_AS_UNITASS_ITEM_SEQ_NUM_S.NEXTVAL

Line 2612: l_c_usec_status igs_ps_unit_ofr_opt_all.unit_section_status%TYPE;

2608: l_n_num_end_days NUMBER;
2609: l_d_us_dest_start_dt DATE;
2610: l_d_us_dest_end_dt DATE;
2611:
2612: l_c_usec_status igs_ps_unit_ofr_opt_all.unit_section_status%TYPE;
2613:
2614: -- jbegum As part of bug#2563596 the call to IGS_GE_GEN_003.genp_ins_log_entry was modified .
2615: -- The concatenated string being passed to parameter p_key has the substring FND_MESSAGE.GET_STRING('IGS', l_message_name)
2616: -- removed as this was causing the TBH procedure IGS_GE_S_LOG_ENTRY_PKG.INSERT_ROW to throw up an invalid value error,which

Line 2623: PROCEDURE handle_excp( p_old_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE ) AS

2619: -- FND_MESSAGE.GET_STRING('IGS', l_message_name)
2620:
2621:
2622:
2623: PROCEDURE handle_excp( p_old_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE ) AS
2624: -------------------------------------------------------------------------------------------
2625: --Change History:
2626: --Who When What
2627: --

Line 2631: FROM igs_ps_unit_ofr_opt

2627: --
2628: -------------------------------------------------------------------------------------------
2629: CURSOR cur_org_unit (cp_uoo_id IN NUMBER) IS
2630: SELECT owner_org_unit_cd
2631: FROM igs_ps_unit_ofr_opt
2632: WHERE uoo_id = cp_uoo_id;
2633: lcur_org_unit cur_org_unit%rowtype;
2634: l_message_name fnd_new_messages.message_text%TYPE;
2635: BEGIN

Line 2687: FROM igs_ps_unit_ofr_opt

2683:
2684: --Cursor to get list the subordinate unit sections whose superior unit sections have been rolled over
2685: CURSOR c_get_sub_us_list IS
2686: SELECT *
2687: FROM igs_ps_unit_ofr_opt
2688: WHERE sup_uoo_id IN ( SELECT uoo_id
2689: FROM igs_ps_unit_ofr_opt
2690: WHERE cal_type = p_src_cal_type
2691: AND ci_sequence_number = p_src_sequence_num

Line 2689: FROM igs_ps_unit_ofr_opt

2685: CURSOR c_get_sub_us_list IS
2686: SELECT *
2687: FROM igs_ps_unit_ofr_opt
2688: WHERE sup_uoo_id IN ( SELECT uoo_id
2689: FROM igs_ps_unit_ofr_opt
2690: WHERE cal_type = p_src_cal_type
2691: AND ci_sequence_number = p_src_sequence_num
2692: AND unit_cd = p_unit_cd
2693: AND version_number = p_version_number

Line 2697: CURSOR c_get_old_uoo_det(cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS

2693: AND version_number = p_version_number
2694: );
2695:
2696: --Cursor to get unit_cd,version_number, location_code and unit_class for SUP_UOO_ID
2697: CURSOR c_get_old_uoo_det(cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
2698: SELECT unit_cd,version_number,location_cd,unit_class
2699: FROM igs_ps_unit_ofr_opt
2700: WHERE uoo_id = cp_uoo_id;
2701:

Line 2699: FROM igs_ps_unit_ofr_opt

2695:
2696: --Cursor to get unit_cd,version_number, location_code and unit_class for SUP_UOO_ID
2697: CURSOR c_get_old_uoo_det(cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
2698: SELECT unit_cd,version_number,location_cd,unit_class
2699: FROM igs_ps_unit_ofr_opt
2700: WHERE uoo_id = cp_uoo_id;
2701:
2702: --Cursor to get the new UOO_ID for the old SUP_UOO_ID
2703: CURSOR c_new_sup_uoo_id(cp_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE,

Line 2703: CURSOR c_new_sup_uoo_id(cp_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE,

2699: FROM igs_ps_unit_ofr_opt
2700: WHERE uoo_id = cp_uoo_id;
2701:
2702: --Cursor to get the new UOO_ID for the old SUP_UOO_ID
2703: CURSOR c_new_sup_uoo_id(cp_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE,
2704: cp_version_number igs_ps_unit_ofr_opt.version_number%TYPE,
2705: cp_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE,
2706: cp_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE) IS
2707: SELECT uoo_id

Line 2704: cp_version_number igs_ps_unit_ofr_opt.version_number%TYPE,

2700: WHERE uoo_id = cp_uoo_id;
2701:
2702: --Cursor to get the new UOO_ID for the old SUP_UOO_ID
2703: CURSOR c_new_sup_uoo_id(cp_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE,
2704: cp_version_number igs_ps_unit_ofr_opt.version_number%TYPE,
2705: cp_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE,
2706: cp_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE) IS
2707: SELECT uoo_id
2708: FROM igs_ps_unit_ofr_opt

Line 2705: cp_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE,

2701:
2702: --Cursor to get the new UOO_ID for the old SUP_UOO_ID
2703: CURSOR c_new_sup_uoo_id(cp_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE,
2704: cp_version_number igs_ps_unit_ofr_opt.version_number%TYPE,
2705: cp_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE,
2706: cp_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE) IS
2707: SELECT uoo_id
2708: FROM igs_ps_unit_ofr_opt
2709: WHERE unit_cd = cp_unit_cd

Line 2706: cp_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE) IS

2702: --Cursor to get the new UOO_ID for the old SUP_UOO_ID
2703: CURSOR c_new_sup_uoo_id(cp_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE,
2704: cp_version_number igs_ps_unit_ofr_opt.version_number%TYPE,
2705: cp_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE,
2706: cp_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE) IS
2707: SELECT uoo_id
2708: FROM igs_ps_unit_ofr_opt
2709: WHERE unit_cd = cp_unit_cd
2710: AND version_number = cp_version_number

Line 2708: FROM igs_ps_unit_ofr_opt

2704: cp_version_number igs_ps_unit_ofr_opt.version_number%TYPE,
2705: cp_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE,
2706: cp_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE) IS
2707: SELECT uoo_id
2708: FROM igs_ps_unit_ofr_opt
2709: WHERE unit_cd = cp_unit_cd
2710: AND version_number = cp_version_number
2711: AND cal_type = p_dst_cal_type
2712: AND ci_sequence_number = p_dst_sequence_num

Line 2717: CURSOR c_new_sub_us (cp_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE,

2713: AND location_cd = cp_location_cd
2714: AND unit_class = cp_unit_class;
2715:
2716: --Cursor to get the new subordinate unit sections
2717: CURSOR c_new_sub_us (cp_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE,
2718: cp_version_number igs_ps_unit_ofr_opt.version_number%TYPE,
2719: cp_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE,
2720: cp_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE) IS
2721: SELECT uoo.*

Line 2718: cp_version_number igs_ps_unit_ofr_opt.version_number%TYPE,

2714: AND unit_class = cp_unit_class;
2715:
2716: --Cursor to get the new subordinate unit sections
2717: CURSOR c_new_sub_us (cp_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE,
2718: cp_version_number igs_ps_unit_ofr_opt.version_number%TYPE,
2719: cp_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE,
2720: cp_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE) IS
2721: SELECT uoo.*
2722: FROM igs_ps_unit_ofr_opt uoo,

Line 2719: cp_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE,

2715:
2716: --Cursor to get the new subordinate unit sections
2717: CURSOR c_new_sub_us (cp_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE,
2718: cp_version_number igs_ps_unit_ofr_opt.version_number%TYPE,
2719: cp_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE,
2720: cp_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE) IS
2721: SELECT uoo.*
2722: FROM igs_ps_unit_ofr_opt uoo,
2723: igs_ps_unit_ver_all uv,

Line 2720: cp_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE) IS

2716: --Cursor to get the new subordinate unit sections
2717: CURSOR c_new_sub_us (cp_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE,
2718: cp_version_number igs_ps_unit_ofr_opt.version_number%TYPE,
2719: cp_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE,
2720: cp_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE) IS
2721: SELECT uoo.*
2722: FROM igs_ps_unit_ofr_opt uoo,
2723: igs_ps_unit_ver_all uv,
2724: igs_ps_unit_stat us

Line 2722: FROM igs_ps_unit_ofr_opt uoo,

2718: cp_version_number igs_ps_unit_ofr_opt.version_number%TYPE,
2719: cp_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE,
2720: cp_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE) IS
2721: SELECT uoo.*
2722: FROM igs_ps_unit_ofr_opt uoo,
2723: igs_ps_unit_ver_all uv,
2724: igs_ps_unit_stat us
2725: WHERE uoo.unit_cd = cp_unit_cd
2726: AND uoo.version_number = cp_version_number

Line 2741: FROM igs_ps_unit_ofr_opt

2737:
2738: --Cursor to get list the subordiante unit sections have been rolled over
2739: CURSOR c_get_sub_us_list1 IS
2740: SELECT *
2741: FROM igs_ps_unit_ofr_opt
2742: WHERE cal_type = p_src_cal_type
2743: AND ci_sequence_number = p_src_sequence_num
2744: AND unit_cd = p_unit_cd
2745: AND version_number = p_version_number

Line 2749: CURSOR c_get_new_sub (cp_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE,

2745: AND version_number = p_version_number
2746: AND relation_type = l_c_subordinate;
2747:
2748: --Cursor to get from the new subordinate unit section details
2749: CURSOR c_get_new_sub (cp_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE,
2750: cp_version_number igs_ps_unit_ofr_opt.version_number%TYPE,
2751: cp_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE,
2752: cp_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE) IS
2753: SELECT *

Line 2750: cp_version_number igs_ps_unit_ofr_opt.version_number%TYPE,

2746: AND relation_type = l_c_subordinate;
2747:
2748: --Cursor to get from the new subordinate unit section details
2749: CURSOR c_get_new_sub (cp_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE,
2750: cp_version_number igs_ps_unit_ofr_opt.version_number%TYPE,
2751: cp_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE,
2752: cp_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE) IS
2753: SELECT *
2754: FROM igs_ps_unit_ofr_opt

Line 2751: cp_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE,

2747:
2748: --Cursor to get from the new subordinate unit section details
2749: CURSOR c_get_new_sub (cp_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE,
2750: cp_version_number igs_ps_unit_ofr_opt.version_number%TYPE,
2751: cp_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE,
2752: cp_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE) IS
2753: SELECT *
2754: FROM igs_ps_unit_ofr_opt
2755: WHERE unit_cd = cp_unit_cd

Line 2752: cp_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE) IS

2748: --Cursor to get from the new subordinate unit section details
2749: CURSOR c_get_new_sub (cp_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE,
2750: cp_version_number igs_ps_unit_ofr_opt.version_number%TYPE,
2751: cp_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE,
2752: cp_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE) IS
2753: SELECT *
2754: FROM igs_ps_unit_ofr_opt
2755: WHERE unit_cd = cp_unit_cd
2756: AND version_number = cp_version_number

Line 2754: FROM igs_ps_unit_ofr_opt

2750: cp_version_number igs_ps_unit_ofr_opt.version_number%TYPE,
2751: cp_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE,
2752: cp_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE) IS
2753: SELECT *
2754: FROM igs_ps_unit_ofr_opt
2755: WHERE unit_cd = cp_unit_cd
2756: AND version_number = cp_version_number
2757: AND location_cd = cp_location_cd
2758: AND unit_class = cp_unit_class

Line 2763: CURSOR c_get_old_sup_det (cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS

2759: AND cal_type = p_dst_cal_type
2760: AND ci_sequence_number = p_dst_sequence_num;
2761:
2762: --Cursor to get the old superior unit section details
2763: CURSOR c_get_old_sup_det (cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
2764: SELECT *
2765: FROM igs_ps_unit_ofr_opt
2766: WHERE uoo_id = cp_uoo_id;
2767:

Line 2765: FROM igs_ps_unit_ofr_opt

2761:
2762: --Cursor to get the old superior unit section details
2763: CURSOR c_get_old_sup_det (cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
2764: SELECT *
2765: FROM igs_ps_unit_ofr_opt
2766: WHERE uoo_id = cp_uoo_id;
2767:
2768:
2769: --Cursor to get the new superior unit sections

Line 2770: CURSOR c_new_sup_us(cp_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE,

2766: WHERE uoo_id = cp_uoo_id;
2767:
2768:
2769: --Cursor to get the new superior unit sections
2770: CURSOR c_new_sup_us(cp_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE,
2771: cp_version_number igs_ps_unit_ofr_opt.version_number%TYPE,
2772: cp_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE,
2773: cp_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE) IS
2774: SELECT uoo.uoo_id,uoo.sup_uoo_id

Line 2771: cp_version_number igs_ps_unit_ofr_opt.version_number%TYPE,

2767:
2768:
2769: --Cursor to get the new superior unit sections
2770: CURSOR c_new_sup_us(cp_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE,
2771: cp_version_number igs_ps_unit_ofr_opt.version_number%TYPE,
2772: cp_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE,
2773: cp_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE) IS
2774: SELECT uoo.uoo_id,uoo.sup_uoo_id
2775: FROM igs_ps_unit_ofr_opt uoo,

Line 2772: cp_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE,

2768:
2769: --Cursor to get the new superior unit sections
2770: CURSOR c_new_sup_us(cp_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE,
2771: cp_version_number igs_ps_unit_ofr_opt.version_number%TYPE,
2772: cp_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE,
2773: cp_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE) IS
2774: SELECT uoo.uoo_id,uoo.sup_uoo_id
2775: FROM igs_ps_unit_ofr_opt uoo,
2776: igs_ps_unit_ver_all uv,

Line 2773: cp_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE) IS

2769: --Cursor to get the new superior unit sections
2770: CURSOR c_new_sup_us(cp_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE,
2771: cp_version_number igs_ps_unit_ofr_opt.version_number%TYPE,
2772: cp_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE,
2773: cp_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE) IS
2774: SELECT uoo.uoo_id,uoo.sup_uoo_id
2775: FROM igs_ps_unit_ofr_opt uoo,
2776: igs_ps_unit_ver_all uv,
2777: igs_ps_unit_stat us

Line 2775: FROM igs_ps_unit_ofr_opt uoo,

2771: cp_version_number igs_ps_unit_ofr_opt.version_number%TYPE,
2772: cp_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE,
2773: cp_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE) IS
2774: SELECT uoo.uoo_id,uoo.sup_uoo_id
2775: FROM igs_ps_unit_ofr_opt uoo,
2776: igs_ps_unit_ver_all uv,
2777: igs_ps_unit_stat us
2778: WHERE uoo.unit_cd = cp_unit_cd
2779: AND uoo.version_number = cp_version_number

Line 2792: CURSOR c_new_sup_us1 (cp_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE,

2788: AND us.s_unit_status <> l_c_inactive
2789: AND uoo.uoo_id NOT IN (SELECT uoo_id FROM igs_ps_usec_x_grpmem)
2790: AND uoo.unit_section_status <> l_c_notoffered;
2791:
2792: CURSOR c_new_sup_us1 (cp_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE,
2793: cp_version_number igs_ps_unit_ofr_opt.version_number%TYPE,
2794: cp_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE,
2795: cp_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE) IS
2796: SELECT uoo_id,sup_uoo_id,cal_type,ci_sequence_number

Line 2793: cp_version_number igs_ps_unit_ofr_opt.version_number%TYPE,

2789: AND uoo.uoo_id NOT IN (SELECT uoo_id FROM igs_ps_usec_x_grpmem)
2790: AND uoo.unit_section_status <> l_c_notoffered;
2791:
2792: CURSOR c_new_sup_us1 (cp_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE,
2793: cp_version_number igs_ps_unit_ofr_opt.version_number%TYPE,
2794: cp_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE,
2795: cp_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE) IS
2796: SELECT uoo_id,sup_uoo_id,cal_type,ci_sequence_number
2797: FROM igs_ps_unit_ofr_opt

Line 2794: cp_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE,

2790: AND uoo.unit_section_status <> l_c_notoffered;
2791:
2792: CURSOR c_new_sup_us1 (cp_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE,
2793: cp_version_number igs_ps_unit_ofr_opt.version_number%TYPE,
2794: cp_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE,
2795: cp_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE) IS
2796: SELECT uoo_id,sup_uoo_id,cal_type,ci_sequence_number
2797: FROM igs_ps_unit_ofr_opt
2798: WHERE unit_cd = cp_unit_cd

Line 2795: cp_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE) IS

2791:
2792: CURSOR c_new_sup_us1 (cp_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE,
2793: cp_version_number igs_ps_unit_ofr_opt.version_number%TYPE,
2794: cp_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE,
2795: cp_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE) IS
2796: SELECT uoo_id,sup_uoo_id,cal_type,ci_sequence_number
2797: FROM igs_ps_unit_ofr_opt
2798: WHERE unit_cd = cp_unit_cd
2799: AND version_number = cp_version_number

Line 2797: FROM igs_ps_unit_ofr_opt

2793: cp_version_number igs_ps_unit_ofr_opt.version_number%TYPE,
2794: cp_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE,
2795: cp_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE) IS
2796: SELECT uoo_id,sup_uoo_id,cal_type,ci_sequence_number
2797: FROM igs_ps_unit_ofr_opt
2798: WHERE unit_cd = cp_unit_cd
2799: AND version_number = cp_version_number
2800: AND location_cd = cp_location_cd
2801: AND unit_class = cp_unit_class

Line 3139: -- Select the source IGS_PS_UNIT_OFR_OPT records.

3135: END IF;
3136: CLOSE cur_check_log;
3137:
3138:
3139: -- Select the source IGS_PS_UNIT_OFR_OPT records.
3140: OPEN c_uoo_source_rec;
3141: LOOP
3142: BEGIN
3143: FETCH c_uoo_source_rec INTO v_uoo_rec;

Line 3147: -- IGS_PS_UNIT_OFR_OPT record

3143: FETCH c_uoo_source_rec INTO v_uoo_rec;
3144: EXIT WHEN c_uoo_source_rec%NOTFOUND;
3145: -- all of the below conditions must be true for the
3146: -- insert to proceed, else don't insert this particular
3147: -- IGS_PS_UNIT_OFR_OPT record
3148: -- get the max version number for grading schema
3149:
3150: -- lpriyadh for enhancement bug# 1516959
3151: l_old_uoo_id := v_uoo_rec.uoo_id;

Line 3190: -- checking that no other IGS_PS_UNIT_OFR_OPT record exists

3186: p_dest_ci_sequence_number,
3187: v_uoo_rec.location_cd,
3188: v_uoo_rec.unit_class);
3189: FETCH c_uoo_rec_exists INTO v_uoo_rec_exists;
3190: -- checking that no other IGS_PS_UNIT_OFR_OPT record exists
3191: IF (c_uoo_rec_exists%NOTFOUND) THEN
3192: CLOSE c_uoo_rec_exists;
3193:
3194: -- get the next IGS_PS_UNIT_OFR_OPT_UOO_ID_S from the system

Line 3194: -- get the next IGS_PS_UNIT_OFR_OPT_UOO_ID_S from the system

3190: -- checking that no other IGS_PS_UNIT_OFR_OPT record exists
3191: IF (c_uoo_rec_exists%NOTFOUND) THEN
3192: CLOSE c_uoo_rec_exists;
3193:
3194: -- get the next IGS_PS_UNIT_OFR_OPT_UOO_ID_S from the system
3195: OPEN c_uoo_seq_num;
3196: FETCH c_uoo_seq_num INTO v_new_uoo_id;
3197: CLOSE c_uoo_seq_num;
3198:

Line 3199: -- insert the IGS_PS_UNIT_OFR_OPT record, with this next uoo_id

3195: OPEN c_uoo_seq_num;
3196: FETCH c_uoo_seq_num INTO v_new_uoo_id;
3197: CLOSE c_uoo_seq_num;
3198:
3199: -- insert the IGS_PS_UNIT_OFR_OPT record, with this next uoo_id
3200: x_rowid := NULL;
3201: l_org_id := igs_ge_gen_003.get_org_id;
3202:
3203:

Line 3212: IF NOT igs_ps_unit_ofr_opt_pkg.check_call_number ( p_teach_cal_type => p_cal_type,

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;

Line 3262: igs_ps_unit_ofr_opt_pkg.insert_row(

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,

Line 3322: -- increment count to reflect that a successful insert of a IGS_PS_UNIT_OFR_OPT record occurred

3318: p_log_creation_date );
3319:
3320: -- passing p_log_creation_date parameter enhancement bug 1800179 pmarada
3321:
3322: -- increment count to reflect that a successful insert of a IGS_PS_UNIT_OFR_OPT record occurred
3323: v_uoo_inserted_cnt := v_uoo_inserted_cnt + 1;
3324:
3325: ELSE
3326: -- if uoo record already exists not perform insert.

Line 3871: FROM igs_ps_unit_ofr_opt

3867: WHEN OTHERS THEN
3868: DECLARE
3869: CURSOR cur_org_unit (cp_uoo_id IN NUMBER) IS
3870: SELECT owner_org_unit_cd
3871: FROM igs_ps_unit_ofr_opt
3872: WHERE uoo_id = cp_uoo_id;
3873: lcur_org_unit cur_org_unit%rowtype;
3874: BEGIN
3875: --Fnd log implementation