APPS.GMI_SUMM_INV_DB_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 43

FUNCTION UPDATE_IC_SUMM_INV
(
 p_summ_inv IN IC_SUMM_INV%ROWTYPE
)
RETURN BOOLEAN
IS

err_num       NUMBER;

Line: 59

UPDATE IC_SUMM_INV
SET
    onhand_qty           = onhand_qty + p_summ_inv.onhand_qty,
    onhand_qty2          = onhand_qty2 + NVL(p_summ_inv.onhand_qty2,0),
    onhand_prod_qty      = onhand_prod_qty +  p_summ_inv.onhand_prod_qty,
    onhand_prod_qty2     = NVL(onhand_prod_qty2,0) +
                           NVL(p_summ_inv.onhand_prod_qty2,0),
    onhand_order_qty     = onhand_order_qty +  p_summ_inv.onhand_order_qty,
    onhand_order_qty2    = NVL(onhand_order_qty2,0) +
                           NVL(p_summ_inv.onhand_order_qty2,0),
    onhand_ship_qty      = onhand_ship_qty +  p_summ_inv.onhand_ship_qty,
    onhand_ship_qty2     = NVL(onhand_ship_qty2,0) +
                           NVL(p_summ_inv.onhand_ship_qty2,0),
    onpurch_qty          = onpurch_qty +  p_summ_inv.onpurch_qty,
    onpurch_qty2         = NVL(onpurch_qty2,0) +
                           NVL(p_summ_inv.onpurch_qty2,0),
    onprod_qty           = onprod_qty +  p_summ_inv.onprod_qty,
    onprod_qty2          = NVL(onprod_qty2,0) +
                           NVL(p_summ_inv.onprod_qty2,0),
    committedsales_qty   = committedsales_qty + p_summ_inv.committedsales_qty,
    committedsales_qty2  = NVL(committedsales_qty2,0) +
                           NVL(p_summ_inv.committedsales_qty2,0),
    committedprod_qty    = committedprod_qty +  p_summ_inv.committedprod_qty,
    committedprod_qty2   = NVL(committedprod_qty2,0) +
                           NVL(p_summ_inv.committedprod_qty2,0),
    intransit_qty        = intransit_qty +  p_summ_inv.intransit_qty,
    intransit_qty2       = NVL(intransit_qty2,0) +
                           NVL(p_summ_inv.intransit_qty2,0),
    last_updated_by      = p_summ_inv.last_updated_by,
    created_by           = p_summ_inv.created_by,
    last_update_date     = p_summ_inv.last_update_date,
    creation_date        = p_summ_inv.creation_date
WHERE item_id   = p_summ_inv.item_id
AND  whse_code = p_summ_inv.whse_code
AND  qc_grade  IS NULL;

Line: 97

UPDATE IC_SUMM_INV
SET
    onhand_qty           = onhand_qty + p_summ_inv.onhand_qty,
    onhand_qty2          = onhand_qty2 +  NVL(p_summ_inv.onhand_qty2,0),
    onhand_prod_qty      = onhand_prod_qty +  p_summ_inv.onhand_prod_qty,
    onhand_prod_qty2     = NVL(onhand_prod_qty2,0) +
                           NVL(p_summ_inv.onhand_prod_qty2,0),
    onhand_order_qty     = onhand_order_qty +  p_summ_inv.onhand_order_qty,
    onhand_order_qty2    = NVL(onhand_order_qty2,0) +
                           NVL(p_summ_inv.onhand_order_qty2,0),
    onhand_ship_qty      = onhand_ship_qty +  p_summ_inv.onhand_ship_qty,
    onhand_ship_qty2     = NVL(onhand_ship_qty2,0) +
                           NVL(p_summ_inv.onhand_ship_qty2,0),
    onpurch_qty          = onpurch_qty +  p_summ_inv.onpurch_qty,
    onpurch_qty2         = NVL(onpurch_qty2,0) +
                           NVL(p_summ_inv.onpurch_qty2,0),
    onprod_qty           = onprod_qty +  p_summ_inv.onprod_qty,
    onprod_qty2          = NVL(onprod_qty2,0) +
                           NVL(p_summ_inv.onprod_qty2,0),
    committedsales_qty   = committedsales_qty + p_summ_inv.committedsales_qty,
    committedsales_qty2  = NVL(committedsales_qty2,0) +
                           NVL(p_summ_inv.committedsales_qty2,0),
    committedprod_qty    = committedprod_qty +  p_summ_inv.committedprod_qty,
    committedprod_qty2   = NVL(committedprod_qty2,0) +
                           NVL(p_summ_inv.committedprod_qty2,0),
    intransit_qty        = intransit_qty +  p_summ_inv.intransit_qty,
    intransit_qty2       = NVL(intransit_qty2,0) +
                           NVL(p_summ_inv.intransit_qty2,0),
    last_updated_by      = p_summ_inv.last_updated_by,
    created_by           = p_summ_inv.created_by,
    last_update_date     = p_summ_inv.last_update_date,
    creation_date        = p_summ_inv.creation_date
WHERE item_id   = p_summ_inv.item_id
AND  whse_code  = p_summ_inv.whse_code
AND  qc_grade   = p_summ_inv.qc_grade;

Line: 148

                             , 'update_ic_summ_inv'
                            );

Line: 152

END UPDATE_IC_SUMM_INV;

Line: 154

FUNCTION INSERT_IC_SUMM_INV
(
 p_summ_inv IN IC_SUMM_INV%ROWTYPE
)
RETURN BOOLEAN
IS
err_num NUMBER;

Line: 168

    SELECT GEM5_SUMM_INV_ID_S.nextval
    INTO   l_summ_inv_id
    FROM   dual;

Line: 173

INSERT INTO IC_SUMM_INV
(
 summ_inv_id,
 item_id,
 whse_code,
 qc_grade,
 onhand_qty,
 onhand_qty2,
 onhand_prod_qty,
 onhand_prod_qty2,
 onhand_order_qty,
 onhand_order_qty2,
 onhand_ship_qty,
 onhand_ship_qty2,
 onpurch_qty,
 onpurch_qty2,
 onprod_qty,
 onprod_qty2,
 committedsales_qty,
 committedsales_qty2,
 committedprod_qty,
 committedprod_qty2,
 intransit_qty,
 intransit_qty2,
 last_updated_by,
 created_by,
 last_update_date,
 creation_date
)
VALUES
(
 l_summ_inv_id,
 p_summ_inv.item_id,
 p_summ_inv.whse_code,
 p_summ_inv.qc_grade,
 p_summ_inv.onhand_qty,
 nvl(p_summ_inv.onhand_qty2,0),
 p_summ_inv.onhand_prod_qty,
 nvl(p_summ_inv.onhand_prod_qty2,0),
 p_summ_inv.onhand_order_qty,
 nvl(p_summ_inv.onhand_order_qty2,0),
 p_summ_inv.onhand_ship_qty,
 nvl(p_summ_inv.onhand_ship_qty2,0),
 p_summ_inv.onpurch_qty,
 nvl(p_summ_inv.onpurch_qty2,0),
 p_summ_inv.onprod_qty,
 nvl(p_summ_inv.onprod_qty2,0),
 p_summ_inv.committedsales_qty,
 nvl(p_summ_inv.committedsales_qty2,0),
 p_summ_inv.committedprod_qty,
 nvl(p_summ_inv.committedprod_qty2,0),
 p_summ_inv.intransit_qty,
 nvl(p_summ_inv.intransit_qty2,0),
 p_summ_inv.last_updated_by,
 p_summ_inv.created_by,
 p_summ_inv.last_update_date,
 p_summ_inv.creation_date
);

Line: 239

                             , 'insert_ic_summ_inv'
                            );

Line: 244

END INSERT_IC_SUMM_INV;

Line: 258

SELECT *
FROM   IC_LOTS_STS
WHERE  UPPER(lot_status) = UPPER(v_lot_status)
AND    DELETE_MARK <> 1;

Line: 285

                             , 'insert_ic_summ_inv'
                            );