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

Line 304: FROM igs_ps_unit_ofr_opt

300: -- previous the cursor was doing a select count(*) from igs_en_su_attempt
301: -- now changed it to use the enrollment actual from the unit section table
302: CURSOR usec_enr_act(p_uoo_id NUMBER) IS
303: SELECT ENROLLMENT_ACTUAL
304: FROM igs_ps_unit_ofr_opt
305: WHERE uoo_id = p_uoo_id;
306: BEGIN
307: -- This procedure checks the maximum enrollment for the unit section and
308: -- Raises a error message.

Line 390: CURSOR c_admin_priority (cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS

386: add_units_api for Calling Object as 'PLAN' as a part of bug#4666102
387:
388: */
389: --Getting the max administrative priority value, bug 2526021
390: CURSOR c_admin_priority (cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
391: SELECT max(ADMINISTRATIVE_PRIORITY) FROM igs_en_su_attempt
392: WHERE uoo_id = cp_uoo_id;
393:
394: CURSOR c_unit_opt (cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS

Line 394: CURSOR c_unit_opt (cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS

390: CURSOR c_admin_priority (cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
391: SELECT max(ADMINISTRATIVE_PRIORITY) FROM igs_en_su_attempt
392: WHERE uoo_id = cp_uoo_id;
393:
394: CURSOR c_unit_opt (cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
395: SELECT 1 FROM igs_ps_unit_ofr_opt
396: WHERE uoo_id = cp_uoo_id FOR UPDATE;
397: CURSOR cur_load(cp_teach_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
398: cp_teach_ci_sequence_num IGS_CA_INST.SEQUENCE_NUMBER%TYPE) IS

Line 395: SELECT 1 FROM igs_ps_unit_ofr_opt

391: SELECT max(ADMINISTRATIVE_PRIORITY) FROM igs_en_su_attempt
392: WHERE uoo_id = cp_uoo_id;
393:
394: CURSOR c_unit_opt (cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
395: SELECT 1 FROM igs_ps_unit_ofr_opt
396: WHERE uoo_id = cp_uoo_id FOR UPDATE;
397: CURSOR cur_load(cp_teach_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
398: cp_teach_ci_sequence_num IGS_CA_INST.SEQUENCE_NUMBER%TYPE) IS
399: SELECT load_cal_type, load_ci_sequence_number FROM igs_ca_teach_to_load_v

Line 406: FROM igs_ps_unit_ofr_opt sub, igs_ps_unit_ofr_opt sup

402: ORDER BY load_start_dt ASC;
403:
404: CURSOR cur_sub_uoo IS
405: SELECT sup.unit_cd, sup.version_number
406: FROM igs_ps_unit_ofr_opt sub, igs_ps_unit_ofr_opt sup
407: WHERE sub.uoo_id = new_references.uoo_id
408: AND sub.relation_type = 'SUBORDINATE'
409: AND sub.sup_uoo_id = sup.uoo_id;
410:

Line 417: l_sup_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE;

413: FROM igs_ps_unit_ver
414: WHERE unit_cd = new_references.unit_cd
415: AND version_number = new_references.version_number
416: AND practical_ind = 'Y';
417: l_sup_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE;
418: l_sup_ver igs_ps_unit_ofr_opt.version_number%TYPE;
419: l_placement_unit NUMBER;
420:
421: l_admin_priority igs_en_su_attempt.administrative_priority%TYPE;

Line 418: l_sup_ver igs_ps_unit_ofr_opt.version_number%TYPE;

414: WHERE unit_cd = new_references.unit_cd
415: AND version_number = new_references.version_number
416: AND practical_ind = 'Y';
417: l_sup_unit_cd igs_ps_unit_ofr_opt.unit_cd%TYPE;
418: l_sup_ver igs_ps_unit_ofr_opt.version_number%TYPE;
419: l_placement_unit NUMBER;
420:
421: l_admin_priority igs_en_su_attempt.administrative_priority%TYPE;
422: v_message_name VARCHAR2(30);

Line 561: -- Set IGS_PS_UNIT_OFR_OPT key.

557: END IF;
558: ELSE
559: v_effective_dt := SYSDATE;
560: END IF;
561: -- Set IGS_PS_UNIT_OFR_OPT key.
562: IGS_PS_GEN_006.CRSP_GET_UOO_KEY (
563: new_references.unit_cd,
564: new_references.version_number,
565: new_references.cal_type,

Line 1628: ELSIF NOT IGS_PS_UNIT_OFR_OPT_PKG.Get_PK_For_Validation (

1624: (new_references.ci_sequence_number IS NULL) OR
1625: (new_references.location_cd IS NULL) OR
1626: (new_references.unit_class IS NULL))) THEN
1627: NULL;
1628: ELSIF NOT IGS_PS_UNIT_OFR_OPT_PKG.Get_PK_For_Validation (
1629: new_references.unit_cd,
1630: new_references.version_number,
1631: new_references.cal_type,
1632: new_references.ci_sequence_number,

Line 1964: PROCEDURE GET_FK_IGS_PS_UNIT_OFR_OPT (

1960: END IF;
1961: CLOSE cur_rowid;
1962: END GET_FK_IGS_PS_UNIT;
1963:
1964: PROCEDURE GET_FK_IGS_PS_UNIT_OFR_OPT (
1965: x_unit_cd IN VARCHAR2,
1966: x_version_number IN NUMBER,
1967: x_cal_type IN VARCHAR2,
1968: x_ci_sequence_number IN NUMBER,

Line 1993: END GET_FK_IGS_PS_UNIT_OFR_OPT;

1989: APP_EXCEPTION.RAISE_EXCEPTION;
1990: RETURN;
1991: END IF;
1992: CLOSE cur_rowid;
1993: END GET_FK_IGS_PS_UNIT_OFR_OPT;
1994:
1995: PROCEDURE GET_UFK_IGS_PS_UNIT_OFR_OPT (
1996: x_uoo_id IN NUMBER
1997: ) AS

Line 1995: PROCEDURE GET_UFK_IGS_PS_UNIT_OFR_OPT (

1991: END IF;
1992: CLOSE cur_rowid;
1993: END GET_FK_IGS_PS_UNIT_OFR_OPT;
1994:
1995: PROCEDURE GET_UFK_IGS_PS_UNIT_OFR_OPT (
1996: x_uoo_id IN NUMBER
1997: ) AS
1998: CURSOR cur_rowid IS
1999: SELECT ROWID

Line 2014: END GET_UFK_IGS_PS_UNIT_OFR_OPT;

2010: APP_EXCEPTION.RAISE_EXCEPTION;
2011: RETURN;
2012: END IF;
2013: CLOSE cur_rowid;
2014: END GET_UFK_IGS_PS_UNIT_OFR_OPT;
2015:
2016: PROCEDURE GET_UFK_IGS_PS_UNIT_GRD_SCHM ( x_version_number IN NUMBER,
2017: x_grading_schema_code IN VARCHAR2,
2018: x_gs_version_number IN NUMBER,

Line 2198: FROM igs_ps_unit_ofr_opt uoo

2194: l_result BOOLEAN ;
2195:
2196: CURSOR usec_cur(p_uoo_id NUMBER) IS
2197: SELECT unit_section_status
2198: FROM igs_ps_unit_ofr_opt uoo
2199: WHERE uoo_id = p_uoo_id;
2200:
2201: usec_cur_row usec_cur%ROWTYPE;
2202:

Line 2458: CURSOR c_unit_sec_lock(cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS

2454: unit_attempt_status = 'WAITLISTED'
2455: ORDER BY administrative_priority ASC;
2456:
2457: -- Cursor to lock parent unit section record. Bug# 3052426 - ptandon
2458: CURSOR c_unit_sec_lock(cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
2459: SELECT uoo_id
2460: FROM igs_ps_unit_ofr_opt
2461: WHERE uoo_id = cp_uoo_id
2462: FOR UPDATE;

Line 2460: FROM igs_ps_unit_ofr_opt

2456:
2457: -- Cursor to lock parent unit section record. Bug# 3052426 - ptandon
2458: CURSOR c_unit_sec_lock(cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
2459: SELECT uoo_id
2460: FROM igs_ps_unit_ofr_opt
2461: WHERE uoo_id = cp_uoo_id
2462: FOR UPDATE;
2463:
2464: CURSOR c_repeatable_unit (cp_unit_cd igs_ps_unit_ver.unit_cd%TYPE,