APPS.PO_PRICE_DIFFERENTIALS_PKG SQL Statements

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

Line: 23

PROCEDURE insert_row
(   p_price_differential_rec      IN           PO_PRICE_DIFFERENTIALS%ROWTYPE
,   x_row_id                      OUT NOCOPY   ROWID
)
IS
BEGIN

    -- Insert record into PO_PRICE_DIFFERENTIALS base table
    --
    INSERT INTO po_price_differentials
    (   price_differential_id
    ,   price_differential_num
    ,   entity_type
    ,   entity_id
    ,   price_type
    ,   multiplier
    ,   min_multiplier
    ,   max_multiplier
    ,   enabled_flag
    ,   created_by
    ,   creation_date
    ,   last_updated_by
    ,   last_update_date
    ,   last_update_login
    )
    VALUES
    (   p_price_differential_rec.price_differential_id
    ,   p_price_differential_rec.price_differential_num
    ,   p_price_differential_rec.entity_type
    ,   p_price_differential_rec.entity_id
    ,   p_price_differential_rec.price_type
    ,   p_price_differential_rec.multiplier
    ,   p_price_differential_rec.min_multiplier
    ,   p_price_differential_rec.max_multiplier
    ,   p_price_differential_rec.enabled_flag
    ,   p_price_differential_rec.created_by
    ,   p_price_differential_rec.creation_date
    ,   p_price_differential_rec.last_updated_by
    ,   p_price_differential_rec.last_update_date
    ,   p_price_differential_rec.last_update_login
    )
    RETURNING   rowid
    INTO        x_row_id;

Line: 70

        PO_MESSAGE_S.sql_error('PO_PRICE_DIFFERENTIALS_PKG.insert_row','000',sqlcode);

Line: 73

END insert_row;

Line: 94

PROCEDURE update_row
(   p_price_differential_rec      IN        PO_PRICE_DIFFERENTIALS%ROWTYPE
,   p_row_id                      IN        ROWID
)
IS
BEGIN

    -- Update record in PO_PRICE_DIFFERENTIALS base table
    --
    UPDATE po_price_differentials
    SET    price_differential_num = p_price_differential_rec.price_differential_num
    ,      price_type = p_price_differential_rec.price_type
    ,      multiplier = p_price_differential_rec.multiplier
    ,      min_multiplier = p_price_differential_rec.min_multiplier
    ,      max_multiplier = p_price_differential_rec.max_multiplier
    ,      enabled_flag = p_price_differential_rec.enabled_flag
    ,      last_updated_by = p_price_differential_rec.last_updated_by
    ,      last_update_date = p_price_differential_rec.last_update_date
    ,      last_update_login = p_price_differential_rec.last_update_login
    WHERE  rowid = p_row_id;

Line: 121

END update_row;

Line: 151

        SELECT *
        FROM   po_price_differentials
        WHERE  rowid = p_row_id
        FOR UPDATE NOWAIT;

Line: 170

        FND_MESSAGE.set_name('FND','FORM_RECORD_DELETED');

Line: 233

PROCEDURE delete_row
(
    p_row_id                IN        ROWID
)
IS
BEGIN

    DELETE FROM 	PO_PRICE_DIFFERENTIALS
    WHERE 			rowid = p_row_id;

Line: 246

        PO_MESSAGE_S.sql_error('PO_PRICE_DIFFERENTIALS_PKG.delete_row','000',sqlcode);

Line: 249

END delete_row;

Line: 303

  PO_PRICE_DIFFERENTIALS_PVT.delete_price_differentials(
                            p_entity_type => l_entity_type
                            ,p_entity_id  => p_doc_level_id);

Line: 310

    PO_LOG.proc_end(d_module_base,'No of rows deleted',SQL%ROWCOUNT);