APPS.QP_PTE_UTIL SQL Statements

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

Line: 236

PROCEDURE Update_Row
(   p_PTE_rec                       IN  QP_Attr_Map_PUB.Pte_Rec_Type
)
IS
BEGIN

   null;

Line: 244

    UPDATE  QP_LOOKUPS
    SET     DESCRIPTION                    = p_PTE_rec.description
    ,       ENABLED_FLAG                   = p_PTE_rec.enabled_flag
    ,       END_DATE_ACTIVE                = p_PTE_rec.end_date_active
    ,       LOOKUP_CODE                    = p_PTE_rec.lookup_code
    ,       LOOKUP_TYPE                    = p_PTE_rec.lookup_type
    ,       MEANING                        = p_PTE_rec.meaning
    ,       START_DATE_ACTIVE              = p_PTE_rec.start_date_active
    WHERE   LOOKUP_CODE = p_PTE_rec.lookup_code
    ;

Line: 264

            ,   'Update_Row'
            );

Line: 270

END Update_Row;

Line: 274

PROCEDURE Insert_Row
(   p_PTE_rec                       IN  QP_Attr_Map_PUB.Pte_Rec_Type
)
IS
BEGIN

    null;

Line: 282

    INSERT  INTO QP_LOOKUPS
    (       DESCRIPTION
    ,       ENABLED_FLAG
    ,       END_DATE_ACTIVE
    ,       LOOKUP_CODE
    ,       LOOKUP_TYPE
    ,       MEANING
    ,       START_DATE_ACTIVE
    )
    VALUES
    (       p_PTE_rec.description
    ,       p_PTE_rec.enabled_flag
    ,       p_PTE_rec.end_date_active
    ,       p_PTE_rec.lookup_code
    ,       p_PTE_rec.lookup_type
    ,       p_PTE_rec.meaning
    ,       p_PTE_rec.start_date_active
    );

Line: 310

            ,   'Insert_Row'
            );

Line: 316

END Insert_Row;

Line: 320

PROCEDURE Delete_Row
(   p_lookup_code                   IN  VARCHAR2
)
IS
BEGIN
    null;

Line: 327

    DELETE  FROM QP_LOOKUPS
    WHERE   LOOKUP_CODE = p_lookup_code
    ;

Line: 340

            ,   'Delete_Row'
            );

Line: 346

END Delete_Row;

Line: 357

    SELECT  DESCRIPTION
    ,       ENABLED_FLAG
    ,       END_DATE_ACTIVE
    ,       LOOKUP_CODE
    ,       LOOKUP_TYPE
    ,       MEANING
    ,       START_DATE_ACTIVE
    INTO    l_PTE_rec.description
    ,       l_PTE_rec.enabled_flag
    ,       l_PTE_rec.end_date_active
    ,       l_PTE_rec.lookup_code
    ,       l_PTE_rec.lookup_type
    ,       l_PTE_rec.meaning
    ,       l_PTE_rec.start_date_active
    FROM    QP_LOOKUPS
    WHERE   LOOKUP_CODE = p_lookup_code
    ;

Line: 406

    SELECT  DESCRIPTION
    ,       ENABLED_FLAG
    ,       END_DATE_ACTIVE
    ,       LOOKUP_CODE
    ,       LOOKUP_TYPE
    ,       MEANING
    ,       START_DATE_ACTIVE
    INTO    l_PTE_rec.description
    ,       l_PTE_rec.enabled_flag
    ,       l_PTE_rec.end_date_active
    ,       l_PTE_rec.lookup_code
    ,       l_PTE_rec.lookup_type
    ,       l_PTE_rec.meaning
    ,       l_PTE_rec.start_date_active
    FROM    QP_LOOKUPS
    WHERE   LOOKUP_CODE = p_PTE_rec.lookup_code
        FOR UPDATE NOWAIT;

Line: 478

            FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_DELETED');