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

Line 9: uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,

5: g_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6: g_person_type igs_pe_typ_instances.person_type_code%TYPE;
7:
8: TYPE l_units_rec IS RECORD (
9: uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
10: ass_ind igs_en_su_attempt.no_assessment_ind%TYPE,
11: grading_schema_cd igs_en_su_attempt.grading_schema_code%TYPE,
12: gs_version_number igs_en_su_attempt. gs_version_number %TYPE,
13: override_enrolled_cp igs_en_su_attempt.override_enrolled_cp%TYPE,

Line 362: CURSOR c_get_unit_sec(cp_uoo_id IGS_PS_UNIT_OFR_OPT.sup_uoo_id%TYPE) IS

358: --Who When What
359:
360: -------------------------------------------------------------------------------------------
361:
362: CURSOR c_get_unit_sec(cp_uoo_id IGS_PS_UNIT_OFR_OPT.sup_uoo_id%TYPE) IS
363: SELECT unit_cd||'/'||unit_class unit_sec
364: FROM IGS_PS_UNIT_OFR_OPT
365: WHERE uoo_id = cp_uoo_id;
366:

Line 364: FROM IGS_PS_UNIT_OFR_OPT

360: -------------------------------------------------------------------------------------------
361:
362: CURSOR c_get_unit_sec(cp_uoo_id IGS_PS_UNIT_OFR_OPT.sup_uoo_id%TYPE) IS
363: SELECT unit_cd||'/'||unit_class unit_sec
364: FROM IGS_PS_UNIT_OFR_OPT
365: WHERE uoo_id = cp_uoo_id;
366:
367: l_unit_sec VARCHAR2(50);
368:

Line 582: FROM igs_ps_unit_ofr_opt

578:
579: -- cursor to check wheter a unit is subordinate
580: CURSOR cur_chk_unit_is_sub(cp_uoo_id igs_en_su_attempt.uoo_id%TYPE)IS
581: SELECT sup_uoo_id
582: FROM igs_ps_unit_ofr_opt
583: WHERE uoo_id = cp_uoo_id
584: AND sup_uoo_id IS NOT NULL
585: AND relation_type = 'SUBORDINATE';
586:

Line 596: l_sup_uoo_id igs_ps_unit_ofr_opt.sup_uoo_id%TYPE;

592: AND course_cd = p_course_cd
593: AND uoo_id = cp_uoo_id
594: AND unit_attempt_status IN ('UNCONFIRM','INVALID','WAITLISTED','ENROLLED');
595:
596: l_sup_uoo_id igs_ps_unit_ofr_opt.sup_uoo_id%TYPE;
597: l_create_sub BOOLEAN;
598: l_sup_created BOOLEAN;
599: l_sup_exists VARCHAR2(1);
600: l_unit_sec VARCHAR2(100);

Line 1266: l_usec_status igs_ps_unit_ofr_opt.unit_section_status%TYPE;

1262: l_message_name VARCHAR2(4000);
1263: l_audit_msg_name VARCHAR2(100);
1264: l_return_status VARCHAR2(100);
1265: l_audit_status VARCHAR2(100);
1266: l_usec_status igs_ps_unit_ofr_opt.unit_section_status%TYPE;
1267: l_waitlist_ind VARCHAR2(10);
1268: l_enc_message_name VARCHAR2(2000);
1269: l_app_short_name VARCHAR2(100);
1270: l_msg_index NUMBER;

Line 1452: CURSOR c_fetch_sup(cp_uoo_id IGS_PS_UNIT_OFR_OPT.sup_uoo_id%TYPE) IS

1448:
1449: -------------------------------------------------------------------------------------------
1450:
1451: -- cursor to get the superior unit of a unit
1452: CURSOR c_fetch_sup(cp_uoo_id IGS_PS_UNIT_OFR_OPT.sup_uoo_id%TYPE) IS
1453: SELECT sup_uoo_id
1454: FROM IGS_PS_UNIT_OFR_OPT
1455: WHERE uoo_id = cp_uoo_id
1456: AND relation_type = 'SUBORDINATE';

Line 1454: FROM IGS_PS_UNIT_OFR_OPT

1450:
1451: -- cursor to get the superior unit of a unit
1452: CURSOR c_fetch_sup(cp_uoo_id IGS_PS_UNIT_OFR_OPT.sup_uoo_id%TYPE) IS
1453: SELECT sup_uoo_id
1454: FROM IGS_PS_UNIT_OFR_OPT
1455: WHERE uoo_id = cp_uoo_id
1456: AND relation_type = 'SUBORDINATE';
1457:
1458: -- cursor to get request id

Line 1820: CURSOR c_fetch_sup(cp_uoo_id IGS_PS_UNIT_OFR_OPT.sup_uoo_id%TYPE) IS

1816:
1817: l_person_number HZ_PARTIES.party_number%TYPE;
1818:
1819: -- cursor to fetch the superior units
1820: CURSOR c_fetch_sup(cp_uoo_id IGS_PS_UNIT_OFR_OPT.sup_uoo_id%TYPE) IS
1821: SELECT sup_uoo_id
1822: FROM IGS_PS_UNIT_OFR_OPT
1823: WHERE uoo_id = cp_uoo_id
1824: AND relation_type = 'SUBORDINATE';

Line 1822: FROM IGS_PS_UNIT_OFR_OPT

1818:
1819: -- cursor to fetch the superior units
1820: CURSOR c_fetch_sup(cp_uoo_id IGS_PS_UNIT_OFR_OPT.sup_uoo_id%TYPE) IS
1821: SELECT sup_uoo_id
1822: FROM IGS_PS_UNIT_OFR_OPT
1823: WHERE uoo_id = cp_uoo_id
1824: AND relation_type = 'SUBORDINATE';
1825:
1826: l_unit_sec VARCHAR2(50);

Line 2236: CURSOR c_rel_type(p_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE) IS

2232: v_oth_index BINARY_INTEGER := 1;
2233: v_all_index BINARY_INTEGER := 1;
2234:
2235: -- cursor to get uooid relation type of the uooid passed
2236: CURSOR c_rel_type(p_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE) IS
2237: SELECT relation_type
2238: FROM igs_ps_unit_ofr_opt
2239: WHERE uoo_id = p_uoo_id;
2240:

Line 2238: FROM igs_ps_unit_ofr_opt

2234:
2235: -- cursor to get uooid relation type of the uooid passed
2236: CURSOR c_rel_type(p_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE) IS
2237: SELECT relation_type
2238: FROM igs_ps_unit_ofr_opt
2239: WHERE uoo_id = p_uoo_id;
2240:
2241:
2242: -- cursor to get planning sheet error units or plan units in case of plan

Line 2255: CURSOR c_fetch_sup(cp_uoo_id IGS_PS_UNIT_OFR_OPT.sup_uoo_id%TYPE) IS

2251: AND( (p_calling_obj in('PLAN','SUBMITPLAN') and cart_error_flag = 'N')OR
2252: (p_calling_obj <> 'PLAN' and cart_error_flag = 'Y'));
2253:
2254: -- cursor to fetch the superior unit
2255: CURSOR c_fetch_sup(cp_uoo_id IGS_PS_UNIT_OFR_OPT.sup_uoo_id%TYPE) IS
2256: SELECT sup_uoo_id
2257: FROM igs_ps_unit_ofr_opt
2258: WHERE uoo_id = cp_uoo_id
2259: AND relation_type = 'SUBORDINATE';

Line 2257: FROM igs_ps_unit_ofr_opt

2253:
2254: -- cursor to fetch the superior unit
2255: CURSOR c_fetch_sup(cp_uoo_id IGS_PS_UNIT_OFR_OPT.sup_uoo_id%TYPE) IS
2256: SELECT sup_uoo_id
2257: FROM igs_ps_unit_ofr_opt
2258: WHERE uoo_id = cp_uoo_id
2259: AND relation_type = 'SUBORDINATE';
2260:
2261: -- cursor to fetch the subordinate units

Line 2262: CURSOR c_sub_uoo_ids(cp_uoo_id IGS_PS_UNIT_OFR_OPT.sup_uoo_id%TYPE) IS

2258: WHERE uoo_id = cp_uoo_id
2259: AND relation_type = 'SUBORDINATE';
2260:
2261: -- cursor to fetch the subordinate units
2262: CURSOR c_sub_uoo_ids(cp_uoo_id IGS_PS_UNIT_OFR_OPT.sup_uoo_id%TYPE) IS
2263: SELECT uoo_id,default_enroll_flag
2264: FROM igs_ps_unit_ofr_opt
2265: WHERE sup_uoo_id = cp_uoo_id
2266: AND relation_type = 'SUBORDINATE' ;

Line 2264: FROM igs_ps_unit_ofr_opt

2260:
2261: -- cursor to fetch the subordinate units
2262: CURSOR c_sub_uoo_ids(cp_uoo_id IGS_PS_UNIT_OFR_OPT.sup_uoo_id%TYPE) IS
2263: SELECT uoo_id,default_enroll_flag
2264: FROM igs_ps_unit_ofr_opt
2265: WHERE sup_uoo_id = cp_uoo_id
2266: AND relation_type = 'SUBORDINATE' ;
2267:
2268: -- cursor which checks wheter a unit attempt exists

Line 2269: CURSOR c_sua_exists(cp_uoo_id IGS_PS_UNIT_OFR_OPT.sup_uoo_id%TYPE) IS

2265: WHERE sup_uoo_id = cp_uoo_id
2266: AND relation_type = 'SUBORDINATE' ;
2267:
2268: -- cursor which checks wheter a unit attempt exists
2269: CURSOR c_sua_exists(cp_uoo_id IGS_PS_UNIT_OFR_OPT.sup_uoo_id%TYPE) IS
2270: SELECT 'X'
2271: FROM igs_en_su_attempt
2272: WHERE person_id = p_person_id
2273: AND course_cd = p_course_cd

Line 2278: l_sup_uoo_id IGS_PS_UNIT_OFR_OPT.sup_uoo_id%TYPE;

2274: AND uoo_id = cp_uoo_id
2275: AND unit_attempt_status NOT IN ('DROPPED');
2276:
2277:
2278: l_sup_uoo_id IGS_PS_UNIT_OFR_OPT.sup_uoo_id%TYPE;
2279: l_sub_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE;
2280: l_sua_exists VARCHAR2(1);
2281: l_unit_sec VARCHAR2(50);
2282: l_sup_exists BOOLEAN;

Line 2279: l_sub_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE;

2275: AND unit_attempt_status NOT IN ('DROPPED');
2276:
2277:
2278: l_sup_uoo_id IGS_PS_UNIT_OFR_OPT.sup_uoo_id%TYPE;
2279: l_sub_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE;
2280: l_sua_exists VARCHAR2(1);
2281: l_unit_sec VARCHAR2(50);
2282: l_sup_exists BOOLEAN;
2283: l_sub_exists BOOLEAN;

Line 2287: l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;

2283: l_sub_exists BOOLEAN;
2284: l_uoo_ids VARCHAR2(10000);
2285: l_ps_units VARCHAR2(3000);
2286: l_temp VARCHAR2(200);
2287: l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;
2288: l_ass_ind igs_en_su_attempt.no_assessment_ind%TYPE;
2289: l_gradsch_cd igs_en_su_attempt.grading_schema_code%TYPE;
2290: l_gs_version_number NUMBER;
2291: l_override_cp NUMBER;

Line 2293: l_rel_type IGS_PS_UNIT_OFR_OPT.relation_type%TYPE;

2289: l_gradsch_cd igs_en_su_attempt.grading_schema_code%TYPE;
2290: l_gs_version_number NUMBER;
2291: l_override_cp NUMBER;
2292: lunit VARCHAR2(500);
2293: l_rel_type IGS_PS_UNIT_OFR_OPT.relation_type%TYPE;
2294: l_message_name VARCHAR2(4000);
2295: l_return_status VARCHAR2(100);
2296: l_enc_message_name VARCHAR2(100);
2297: l_app_short_name VARCHAR2(100);

Line 2749: CURSOR c_sua_exists(cp_uoo_id IGS_PS_UNIT_OFR_OPT.sup_uoo_id%TYPE) IS

2745: FROM igs_pe_person_types
2746: WHERE person_type_code = g_person_type;
2747:
2748: -- cursor to get the unit code and unit class
2749: CURSOR c_sua_exists(cp_uoo_id IGS_PS_UNIT_OFR_OPT.sup_uoo_id%TYPE) IS
2750: SELECT unit_cd||'/'||unit_class
2751: FROM igs_en_su_attempt
2752: WHERE person_id = p_person_id
2753: AND course_cd = p_course_cd

Line 2761: FROM igs_ps_unit_ofr_opt ofr, igs_ca_inst_all ca

2757: -- cursor to get the unit details
2758: CURSOR c_unit_dtls (cp_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS
2759: SELECT ofr.unit_cd, ofr.version_number, ofr.cal_type, ofr.ci_sequence_number,
2760: ofr.location_cd, ofr.unit_class, ca.start_dt, ca.end_dt
2761: FROM igs_ps_unit_ofr_opt ofr, igs_ca_inst_all ca
2762: WHERE ofr.uoo_id = cp_uoo_id
2763: AND ofr.cal_type = ca.cal_type
2764: AND ofr.ci_sequence_number = ca.sequence_number;
2765:

Line 3304: FROM igs_ps_unit_ofr_opt ofr, igs_ca_inst_all ca

3300: -- cursor to fetch the unit details
3301: CURSOR c_get_unit_dtls (cp_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS
3302: SELECT ofr.unit_cd, ofr.version_number, ofr.cal_type, ofr.ci_sequence_number,
3303: ofr.location_cd, ofr.unit_class, ca.start_dt, ca.end_dt
3304: FROM igs_ps_unit_ofr_opt ofr, igs_ca_inst_all ca
3305: WHERE ofr.uoo_id = cp_uoo_id
3306: AND ofr.cal_type = ca.cal_type
3307: AND ofr.ci_sequence_number = ca.sequence_number;
3308:

Line 3362: lv_teach_cal_type igs_ps_unit_ofr_opt.cal_type%TYPE;

3358: l_no_ass_ind igs_en_su_attempt.no_assessment_ind%TYPE;
3359: x_OVERRIDE_ACHIEVABLE_CP NUMBER;
3360: x_OVERRIDE_ENROLLED_CP NUMBER;
3361: lv_message_name VARCHAR2(100);
3362: lv_teach_cal_type igs_ps_unit_ofr_opt.cal_type%TYPE;
3363: lv_teach_ci_sequence_number igs_ps_unit_ofr_opt.ci_sequence_number%TYPE;
3364: lv_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE;
3365: lv_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE;
3366: crse_hold_fail BOOLEAN ;

Line 3363: lv_teach_ci_sequence_number igs_ps_unit_ofr_opt.ci_sequence_number%TYPE;

3359: x_OVERRIDE_ACHIEVABLE_CP NUMBER;
3360: x_OVERRIDE_ENROLLED_CP NUMBER;
3361: lv_message_name VARCHAR2(100);
3362: lv_teach_cal_type igs_ps_unit_ofr_opt.cal_type%TYPE;
3363: lv_teach_ci_sequence_number igs_ps_unit_ofr_opt.ci_sequence_number%TYPE;
3364: lv_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE;
3365: lv_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE;
3366: crse_hold_fail BOOLEAN ;
3367: l_message_for VARCHAR2(100);

Line 3364: lv_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE;

3360: x_OVERRIDE_ENROLLED_CP NUMBER;
3361: lv_message_name VARCHAR2(100);
3362: lv_teach_cal_type igs_ps_unit_ofr_opt.cal_type%TYPE;
3363: lv_teach_ci_sequence_number igs_ps_unit_ofr_opt.ci_sequence_number%TYPE;
3364: lv_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE;
3365: lv_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE;
3366: crse_hold_fail BOOLEAN ;
3367: l_message_for VARCHAR2(100);
3368: l_message_tokens VARCHAR2(200);

Line 3365: lv_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE;

3361: lv_message_name VARCHAR2(100);
3362: lv_teach_cal_type igs_ps_unit_ofr_opt.cal_type%TYPE;
3363: lv_teach_ci_sequence_number igs_ps_unit_ofr_opt.ci_sequence_number%TYPE;
3364: lv_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE;
3365: lv_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE;
3366: crse_hold_fail BOOLEAN ;
3367: l_message_for VARCHAR2(100);
3368: l_message_tokens VARCHAR2(200);
3369:

Line 3370: CURSOR c_teach_cal (cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS

3366: crse_hold_fail BOOLEAN ;
3367: l_message_for VARCHAR2(100);
3368: l_message_tokens VARCHAR2(200);
3369:
3370: CURSOR c_teach_cal (cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
3371: SELECT cal_type, ci_sequence_number,unit_cd,unit_class
3372: FROM igs_ps_unit_ofr_opt
3373: WHERE uoo_id = cp_uoo_id;
3374:

Line 3372: FROM igs_ps_unit_ofr_opt

3368: l_message_tokens VARCHAR2(200);
3369:
3370: CURSOR c_teach_cal (cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
3371: SELECT cal_type, ci_sequence_number,unit_cd,unit_class
3372: FROM igs_ps_unit_ofr_opt
3373: WHERE uoo_id = cp_uoo_id;
3374:
3375: CURSOR c_teach_census_dt(p_cal_type igs_ps_unit_ofr_opt.cal_type%TYPE,
3376: p_ci_sequence_number igs_ps_unit_ofr_opt.ci_sequence_number%TYPE)IS

Line 3375: CURSOR c_teach_census_dt(p_cal_type igs_ps_unit_ofr_opt.cal_type%TYPE,

3371: SELECT cal_type, ci_sequence_number,unit_cd,unit_class
3372: FROM igs_ps_unit_ofr_opt
3373: WHERE uoo_id = cp_uoo_id;
3374:
3375: CURSOR c_teach_census_dt(p_cal_type igs_ps_unit_ofr_opt.cal_type%TYPE,
3376: p_ci_sequence_number igs_ps_unit_ofr_opt.ci_sequence_number%TYPE)IS
3377: SELECT daiv.alias_val,
3378: ci.start_dt,
3379: ci.end_dt

Line 3376: p_ci_sequence_number igs_ps_unit_ofr_opt.ci_sequence_number%TYPE)IS

3372: FROM igs_ps_unit_ofr_opt
3373: WHERE uoo_id = cp_uoo_id;
3374:
3375: CURSOR c_teach_census_dt(p_cal_type igs_ps_unit_ofr_opt.cal_type%TYPE,
3376: p_ci_sequence_number igs_ps_unit_ofr_opt.ci_sequence_number%TYPE)IS
3377: SELECT daiv.alias_val,
3378: ci.start_dt,
3379: ci.end_dt
3380: FROM IGS_CA_DA_INST_V daiv,