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_ALL

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