APPS.IGS_EN_GEN_005 dependencies on IGS_PS_UNIT_OFR_OPT

Line 475: FROM IGS_PS_UNIT_OFR_OPT uoo,

471: DECLARE
472: cst_active CONSTANT VARCHAR2(10) := 'ACTIVE';
473: CURSOR c_uoo IS
474: SELECT uoo_id
475: FROM IGS_PS_UNIT_OFR_OPT uoo,
476: IGS_PS_UNIT_VER uv,
477: IGS_PS_UNIT_STAT us
478: WHERE uoo.unit_cd = p_unit_cd AND
479: uoo.cal_type = p_cal_type AND

Line 492: FROM IGS_PS_UNIT_OFR_OPT uoo,

488: us.s_unit_status = 'ACTIVE';
489: CURSOR c_uoo2 IS
490: SELECT uoo.uoo_id,
491: um.s_unit_mode
492: FROM IGS_PS_UNIT_OFR_OPT uoo,
493: IGS_PS_UNIT_VER uv,
494: IGS_PS_UNIT_STAT us,
495: IGS_AS_UNIT_CLASS uc,
496: IGS_AS_UNIT_MODE um

Line 513: v_full_match_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE DEFAULT NULL;

509: uoo.unit_class = uc.unit_class AND
510: uc.closed_ind = 'N' AND
511: uc.unit_mode = um.unit_mode;
512: v_uoo_rec c_uoo%ROWTYPE;
513: v_full_match_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE DEFAULT NULL;
514: v_partial_match_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE DEFAULT NULL;
515: BEGIN
516: p_uoo_id := NULL;
517: -- If both the mode and class have been specified,

Line 514: v_partial_match_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE DEFAULT NULL;

510: uc.closed_ind = 'N' AND
511: uc.unit_mode = um.unit_mode;
512: v_uoo_rec c_uoo%ROWTYPE;
513: v_full_match_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE DEFAULT NULL;
514: v_partial_match_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE DEFAULT NULL;
515: BEGIN
516: p_uoo_id := NULL;
517: -- If both the mode and class have been specified,
518: -- then search for a uoo matching.