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_UOO_ID_S

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