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

Line 10: p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,

6: PROCEDURE validate_prog_pro(
7: p_person_id igs_en_su_attempt.person_id%TYPE,
8: p_cal_type igs_ca_inst.cal_type%TYPE,
9: p_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
10: p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
11: p_course_cd igs_en_su_attempt.course_cd%TYPE,
12: p_enr_method_type igs_en_su_attempt.enr_method_type%TYPE,
13: p_message_name OUT NOCOPY VARCHAR2,
14: p_deny_warn OUT NOCOPY VARCHAR2,

Line 184: p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE,

180: PROCEDURE validate_unit_steps(
181: p_person_id IN igs_en_su_attempt.person_id%TYPE,
182: p_cal_type IN igs_ca_inst.cal_type%TYPE,
183: p_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,
184: p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE,
185: p_course_cd IN igs_en_su_attempt.course_cd%TYPE,
186: p_return_status OUT NOCOPY VARCHAR2,
187: p_message_name OUT NOCOPY VARCHAR2,
188: p_deny_warn OUT NOCOPY VARCHAR2

Line 483: l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;

479: -- enrol_cart_unit
480: -------------------------------------------------------------------------------------
481:
482: l_drop_uoo_ids VARCHAR2(255);
483: l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;
484: l_unit_cd igs_ps_unit_ver.unit_cd%TYPE;
485: l_unit_version igs_ps_unit_ver.version_number%TYPE;
486: lv_message_name VARCHAR2(2000);
487: lv_message_name2 VARCHAR2(2000);

Line 493: CURSOR c_uv (cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS

489: l_enr_method IGS_EN_METHOD_TYPE.enr_method_type%TYPE;
490: l_message VARCHAR2(2000);
491: l_return_status VARCHAR2(10);
492:
493: CURSOR c_uv (cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
494: SELECT unit_cd, version_number
495: FROM igs_ps_unit_ofr_opt
496: WHERE uoo_id = cp_uoo_id;
497:

Line 495: FROM igs_ps_unit_ofr_opt

491: l_return_status VARCHAR2(10);
492:
493: CURSOR c_uv (cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
494: SELECT unit_cd, version_number
495: FROM igs_ps_unit_ofr_opt
496: WHERE uoo_id = cp_uoo_id;
497:
498:
499:

Line 808: IGS_PS_UNIT_OFR_OPT UOO

804: SELECT count(*) UNITS_IN_CART
805: FROM
806: IGS_EN_SU_ATTEMPT SUA,
807: IGS_EN_USEC_STAT_DSP_V ENUSECSTAT,
808: IGS_PS_UNIT_OFR_OPT UOO
809: WHERE sua.person_id = cp_person_id
810: AND sua.course_cd = cp_course_cd
811: AND sua.uoo_id = uoo.uoo_id
812: AND enusecstat.unit_section_status = uoo.unit_section_status

Line 827: igs_ps_unit_ofr_opt uoo,

823: SELECT SUM(NVL(sua.override_enrolled_cp,NVL(cps.enrolled_credit_points,
824: uv.enrolled_credit_points))) total_credit_points
825: FROM igs_en_su_attempt sua,
826: igs_en_usec_stat_dsp_v enusecstat,
827: igs_ps_unit_ofr_opt uoo,
828: igs_ps_usec_cps cps,
829: igs_ps_unit_ver uv
830: WHERE sua.person_id = cp_person_id AND
831: sua.course_cd = cp_course_cd AND

Line 985: l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;

981: which failed even before the drop. Bug # 3926541
982: */
983:
984:
985: l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE;
986: l_deny_warn_min_cp VARCHAR2(10) := NULL ;
987: l_deny_warn_coreq VARCHAR2(10) := NULL ;
988: l_deny_warn_prereq VARCHAR2(10) := NULL ;
989: l_deny_warn_att_type VARCHAR2(100) := NULL ;

Line 1040: CURSOR cur_uoo_id (p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS

1036:
1037: NO_AUSL_RECORD_FOUND EXCEPTION;
1038: pragma exception_init(NO_AUSL_RECORD_FOUND,-20010);
1039:
1040: CURSOR cur_uoo_id (p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
1041: SELECT unit_cd, version_number
1042: FROM igs_ps_unit_ofr_opt
1043: WHERE uoo_id = p_uoo_id;
1044:

Line 1042: FROM igs_ps_unit_ofr_opt

1038: pragma exception_init(NO_AUSL_RECORD_FOUND,-20010);
1039:
1040: CURSOR cur_uoo_id (p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
1041: SELECT unit_cd, version_number
1042: FROM igs_ps_unit_ofr_opt
1043: WHERE uoo_id = p_uoo_id;
1044:
1045:
1046: CURSOR c_dcnt_rsn IS

Line 1307: '||p_person_id|| 'AND sua.course_cd = '''|| p_program_cd|| '''AND exists (SELECT ''X'' from igs_ps_unit_ofr_opt uoo

1303: --cursor to
1304: IF l_sub_drop_uoo_ids IS NOT NULL THEN
1305:
1306: OPEN c_chk_sub FOR 'Select ''X'' from igs_en_su_attempt sua where sua.uoo_id in ('||l_sub_drop_uoo_ids||') AND sua.person_id =
1307: '||p_person_id|| 'AND sua.course_cd = '''|| p_program_cd|| '''AND exists (SELECT ''X'' from igs_ps_unit_ofr_opt uoo
1308: WHERE uoo.sup_uoo_id IN (' ||l_drop_alluoo_ids||') AND uoo.relation_type = ''SUBORDINATE'' AND uoo.uoo_id = sua.uoo_id)';
1309:
1310: FETCH c_chk_sub INTO l_chk_sub;
1311: IF c_chk_sub%FOUND THEN

Line 1427: '||p_person_id|| 'AND sua.course_cd = '''|| p_program_cd|| '''AND exists (SELECT ''X'' from igs_ps_unit_ofr_opt uoo

1423: --cursor to
1424: IF l_sub_drop_uoo_ids IS NOT NULL THEN
1425:
1426: OPEN c_chk_sub FOR 'Select ''X'' from igs_en_su_attempt sua where sua.uoo_id in ('||l_sub_drop_uoo_ids||') AND sua.person_id =
1427: '||p_person_id|| 'AND sua.course_cd = '''|| p_program_cd|| '''AND exists (SELECT ''X'' from igs_ps_unit_ofr_opt uoo
1428: WHERE uoo.sup_uoo_id IN (' ||l_drop_alluoo_ids||') AND uoo.relation_type = ''SUBORDINATE'' AND uoo.uoo_id = sua.uoo_id)';
1429:
1430: FETCH c_chk_sub INTO l_chk_sub;
1431: IF c_chk_sub%FOUND THEN

Line 1955: FROM igs_ps_unit_ofr_opt

1951: AND unit_version_number = l_unit_version ;
1952:
1953: CURSOR c_unit_cd IS
1954: SELECT unit_cd, version_number
1955: FROM igs_ps_unit_ofr_opt
1956: WHERE uoo_id = p_uoo_ids ;
1957:
1958: l_unit_cd c_unit_cd%ROWTYPE;
1959: l_grad_schema c_grad_schema%ROWTYPE;

Line 2689: l_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE;

2685: l_eftsu_total igs_en_su_attempt.override_eftsu%type;
2686: l_total_credit_points NUMBER;
2687: l_credit_points igs_en_su_attempt.override_enrolled_cp%TYPE := 0;
2688: l_unit_version_number igs_ps_unit_ver.VERSION_NUMBER%TYPE;
2689: l_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE;
2690: l_acad_start_dt igs_ca_inst.start_dt%type;
2691: l_acad_end_dt igs_ca_inst.end_dt%type;
2692: l_alternate_code igs_ca_inst.alternate_code%type;
2693:

Line 2695: CURSOR cur_uoo_id (p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS

2691: l_acad_end_dt igs_ca_inst.end_dt%type;
2692: l_alternate_code igs_ca_inst.alternate_code%type;
2693:
2694:
2695: CURSOR cur_uoo_id (p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
2696: SELECT version_number
2697: FROM igs_ps_unit_ofr_opt
2698: WHERE uoo_id = p_uoo_id;
2699:

Line 2697: FROM igs_ps_unit_ofr_opt

2693:
2694:
2695: CURSOR cur_uoo_id (p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
2696: SELECT version_number
2697: FROM igs_ps_unit_ofr_opt
2698: WHERE uoo_id = p_uoo_id;
2699:
2700:
2701: CURSOR c_dcnt_rsn IS

Line 2745: CURSOR cur_unit_cd (p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS

2741:
2742: --
2743: -- Cursor to find the Unit Code - ptandon, Enh Bug# 3052432
2744: --
2745: CURSOR cur_unit_cd (p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
2746: SELECT unit_cd
2747: FROM igs_ps_unit_ofr_opt
2748: WHERE uoo_id = p_uoo_id;
2749:

Line 2747: FROM igs_ps_unit_ofr_opt

2743: -- Cursor to find the Unit Code - ptandon, Enh Bug# 3052432
2744: --
2745: CURSOR cur_unit_cd (p_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
2746: SELECT unit_cd
2747: FROM igs_ps_unit_ofr_opt
2748: WHERE uoo_id = p_uoo_id;
2749:
2750: TYPE c_ref_cursor IS REF CURSOR;
2751: c_ref_cur_inst c_ref_cursor;

Line 3353: v_sup_uoo_id IGS_PS_UNIT_OFR_OPT.UOO_ID%TYPE;

3349: c_sup_uoo_cur_inst t_uoo_ref_cur;
3350: c_sub_sua_cur_inst t_uoo_ref_cur;
3351:
3352: v_select_stmt VARCHAR2(2000);
3353: v_sup_uoo_id IGS_PS_UNIT_OFR_OPT.UOO_ID%TYPE;
3354: v_sup_unit_cd IGS_PS_UNIT_OFR_OPT.UNIT_CD%TYPE;
3355:
3356: v_uoo_id IGS_PS_UNIT_OFR_OPT.UOO_ID%TYPE;
3357: v_row_id VARCHAR2(25);

Line 3354: v_sup_unit_cd IGS_PS_UNIT_OFR_OPT.UNIT_CD%TYPE;

3350: c_sub_sua_cur_inst t_uoo_ref_cur;
3351:
3352: v_select_stmt VARCHAR2(2000);
3353: v_sup_uoo_id IGS_PS_UNIT_OFR_OPT.UOO_ID%TYPE;
3354: v_sup_unit_cd IGS_PS_UNIT_OFR_OPT.UNIT_CD%TYPE;
3355:
3356: v_uoo_id IGS_PS_UNIT_OFR_OPT.UOO_ID%TYPE;
3357: v_row_id VARCHAR2(25);
3358:

Line 3356: v_uoo_id IGS_PS_UNIT_OFR_OPT.UOO_ID%TYPE;

3352: v_select_stmt VARCHAR2(2000);
3353: v_sup_uoo_id IGS_PS_UNIT_OFR_OPT.UOO_ID%TYPE;
3354: v_sup_unit_cd IGS_PS_UNIT_OFR_OPT.UNIT_CD%TYPE;
3355:
3356: v_uoo_id IGS_PS_UNIT_OFR_OPT.UOO_ID%TYPE;
3357: v_row_id VARCHAR2(25);
3358:
3359:
3360: CURSOR c_plan_status IS

Line 3489: FROM IGS_PS_UNIT_OFR_OPT UOO

3485: FROM igs_en_plan_units pl
3486: WHERE pl.person_id = p_person_id
3487: AND pl.course_cd = p_course_cd
3488: AND EXISTS ( SELECT 'X'
3489: FROM IGS_PS_UNIT_OFR_OPT UOO
3490: WHERE UOO.SUP_UOO_ID = P_UOOID
3491: AND UOO.RELATION_TYPE = 'SUBORDINATE'
3492: AND UOO.UOO_ID = pl.UOO_ID)
3493:

Line 3543: || ' FROM IGS_PS_UNIT_OFR_OPT UOO'

3539: || ' AND SUA.COURSE_CD = :2 '
3540: || ' AND SUA.UNIT_ATTEMPT_STATUS NOT IN (''DROPPED'',''DISCONTIN'',''COMPLETED'') '
3541: || ' AND (( SUA.UOO_ID IN (' || P_SELECTED_UOO_IDS || ') )'
3542: || ' OR ( EXISTS ( SELECT ''X'' '
3543: || ' FROM IGS_PS_UNIT_OFR_OPT UOO'
3544: || ' WHERE UOO.SUP_UOO_ID IN (' || P_SELECTED_UOO_IDS || ')'
3545: || ' AND UOO.RELATION_TYPE = ''SUBORDINATE'' '
3546: || ' AND UOO.UOO_ID = SUA.UOO_ID ) ) ) '
3547: || ' ORDER BY SUA.SUP_UNIT_CD ';

Line 4082: igs_ps_unit_ofr_opt uoo

4078: CURSOR c_usec_audit_lim IS
4079: SELECT NVL (usec.max_auditors_allowed, NVL(uv.max_auditors_allowed,999999) )
4080: FROM igs_ps_usec_lim_wlst usec,
4081: igs_ps_unit_ver uv,
4082: igs_ps_unit_ofr_opt uoo
4083: WHERE uoo.unit_cd = uv.unit_cd
4084: AND uoo.version_number = uv.version_number
4085: AND uoo.uoo_id = usec.uoo_id (+)
4086: AND uoo.uoo_id = p_uoo_id;

Line 4112: FROM igs_ps_unit_ofr_opt

4108: AND transaction_type <> 'WITHDRAWN' ;
4109:
4110: CURSOR cur_chk_au_allowed IS
4111: SELECT NVL(auditable_ind, 'N'), unit_cd, unit_class, NVL(audit_permission_ind, 'N')
4112: FROM igs_ps_unit_ofr_opt
4113: WHERE uoo_id = p_uoo_id;
4114:
4115: CURSOR cur_step_def_var(cp_enr_cat igs_en_cpd_ext.enrolment_cat%TYPE,
4116: cp_enr_method igs_en_cpd_ext.enr_method_type%TYPE,

Line 4153: l_audit_allowed igs_ps_unit_ofr_opt.auditable_ind%TYPE;

4149: l_notification_flag igs_en_cpd_ext.notification_flag%TYPE;
4150: l_message fnd_new_messages.message_name%TYPE;
4151: l_acad_cal_type igs_ca_inst_rel.sub_cal_type%TYPE;
4152: l_approval_status igs_en_spl_perm.approval_status%TYPE;
4153: l_audit_allowed igs_ps_unit_ofr_opt.auditable_ind%TYPE;
4154: l_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE;
4155: l_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE;
4156: l_au_perm_req igs_ps_unit_ofr_opt.audit_permission_ind%TYPE;
4157: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;

Line 4154: l_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE;

4150: l_message fnd_new_messages.message_name%TYPE;
4151: l_acad_cal_type igs_ca_inst_rel.sub_cal_type%TYPE;
4152: l_approval_status igs_en_spl_perm.approval_status%TYPE;
4153: l_audit_allowed igs_ps_unit_ofr_opt.auditable_ind%TYPE;
4154: l_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE;
4155: l_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE;
4156: l_au_perm_req igs_ps_unit_ofr_opt.audit_permission_ind%TYPE;
4157: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
4158: l_enrol_sequence_number igs_ca_inst.sequence_number%TYPE;

Line 4155: l_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE;

4151: l_acad_cal_type igs_ca_inst_rel.sub_cal_type%TYPE;
4152: l_approval_status igs_en_spl_perm.approval_status%TYPE;
4153: l_audit_allowed igs_ps_unit_ofr_opt.auditable_ind%TYPE;
4154: l_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE;
4155: l_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE;
4156: l_au_perm_req igs_ps_unit_ofr_opt.audit_permission_ind%TYPE;
4157: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
4158: l_enrol_sequence_number igs_ca_inst.sequence_number%TYPE;
4159: l_enrol_cal_type igs_ca_inst.cal_type%TYPE;

Line 4156: l_au_perm_req igs_ps_unit_ofr_opt.audit_permission_ind%TYPE;

4152: l_approval_status igs_en_spl_perm.approval_status%TYPE;
4153: l_audit_allowed igs_ps_unit_ofr_opt.auditable_ind%TYPE;
4154: l_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE;
4155: l_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE;
4156: l_au_perm_req igs_ps_unit_ofr_opt.audit_permission_ind%TYPE;
4157: l_acad_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
4158: l_enrol_sequence_number igs_ca_inst.sequence_number%TYPE;
4159: l_enrol_cal_type igs_ca_inst.cal_type%TYPE;
4160: l_usec_audit_lim igs_ps_usec_lim_wlst.max_auditors_allowed%TYPE;