APPS.PV_PRGM_PTR_TYPES_PKG SQL Statements

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

Line: 43

PROCEDURE Insert_Row(
            px_program_partner_types_id   IN OUT NOCOPY NUMBER
           ,p_PROGRAM_TYPE_ID              NUMBER
           ,p_partner_type                       VARCHAR2
           ,p_last_update_date                   DATE
           ,p_last_updated_by                    NUMBER
           ,p_creation_date                      DATE
           ,p_created_by                         NUMBER
           ,p_last_update_login                  NUMBER
           ,p_object_version_number              NUMBER
           )

  IS

 BEGIN

    INSERT INTO PV_PROGRAM_PARTNER_TYPES(
             program_partner_types_id
            ,PROGRAM_TYPE_ID
            ,partner_type
            ,last_update_date
            ,last_updated_by
            ,creation_date
            ,created_by
            ,last_update_login
            ,object_version_number
    ) VALUES (
             DECODE( px_program_partner_types_id, NULL, px_program_partner_types_id, FND_API.g_miss_num, NULL, px_program_partner_types_id)
            ,DECODE( p_PROGRAM_TYPE_ID, NULL, p_PROGRAM_TYPE_ID, FND_API.g_miss_num, NULL, p_PROGRAM_TYPE_ID)
            ,DECODE( p_partner_type, NULL, p_partner_type, FND_API.g_miss_char, NULL, p_partner_type)
            ,DECODE( p_last_update_date, NULL, p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date)
            ,DECODE( p_last_updated_by, NULL, p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by)
            ,DECODE( p_creation_date, NULL, p_creation_date, FND_API.g_miss_date, NULL, p_creation_date)
            ,DECODE( p_created_by, NULL, p_created_by, FND_API.g_miss_num, NULL, p_created_by)
            ,DECODE( p_last_update_login, NULL, p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login)
            ,DECODE( p_object_version_number, NULL, p_object_version_number, FND_API.g_miss_num, NULL, p_object_version_number)
            );

Line: 80

 END Insert_Row;

Line: 96

 PROCEDURE Update_Row(
            p_program_partner_types_id    NUMBER
           ,p_PROGRAM_TYPE_ID       NUMBER
           ,p_partner_type                VARCHAR2
           ,p_last_update_date            DATE
           ,p_last_updated_by             NUMBER
           ,p_last_update_login           NUMBER
           ,p_object_version_number       NUMBER
           )

  IS

  BEGIN

     UPDATE PV_PROGRAM_PARTNER_TYPES
     SET
        program_partner_types_id = DECODE( p_program_partner_types_id, NULL, program_partner_types_id, FND_API.g_miss_num, NULL, p_program_partner_types_id)
       ,PROGRAM_TYPE_ID          = DECODE( p_PROGRAM_TYPE_ID, NULL, PROGRAM_TYPE_ID, FND_API.g_miss_num, NULL, p_PROGRAM_TYPE_ID)
       ,partner_type             = DECODE( p_partner_type, NULL, partner_type, FND_API.g_miss_char, NULL, p_partner_type)
       ,last_update_date         = DECODE( p_last_update_date, NULL, last_update_date, FND_API.g_miss_date, NULL, p_last_update_date)
       ,last_updated_by          = DECODE( p_last_updated_by, NULL, last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by)
       ,last_update_login        = DECODE( p_last_update_login, NULL, last_update_login, FND_API.g_miss_num, NULL, p_last_update_login)
       ,object_version_number    = DECODE( p_object_version_number, NULL, object_version_number, FND_API.g_miss_num, NULL, p_object_version_number+1)
    WHERE PROGRAM_PARTNER_TYPES_ID = p_program_partner_types_id
    AND object_version_number = p_object_version_number;

Line: 130

 END Update_Row;

Line: 146

PROCEDURE Delete_Row(
     p_program_partner_types_id  NUMBER
    ,p_object_version_number     NUMBER
    )
 IS

 BEGIN

   DELETE FROM PV_PROGRAM_PARTNER_TYPES
    WHERE program_partner_types_id = p_program_partner_types_id
     AND object_version_number = p_object_version_number;

Line: 166

  END Delete_Row ;

Line: 186

           ,p_last_update_date                      DATE
           ,p_last_updated_by                       NUMBER
           ,p_creation_date                         DATE
           ,p_created_by                            NUMBER
           ,p_last_update_login                     NUMBER
           ,px_object_version_number        IN OUT NOCOPY  NUMBER
           )

  IS
    CURSOR C IS
         SELECT *
          FROM PV_PROGRAM_PARTNER_TYPES
         WHERE PROGRAM_PARTNER_TYPES_ID =  px_program_partner_types_id
         FOR UPDATE of PROGRAM_PARTNER_TYPES_ID NOWAIT;

Line: 206

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

Line: 218

        AND (    ( Recinfo.last_update_date = p_last_update_date)
             OR (    ( Recinfo.last_update_date IS NULL )
                 AND (  p_last_update_date IS NULL )))
        AND (    ( Recinfo.last_updated_by = p_last_updated_by)
             OR (    ( Recinfo.last_updated_by IS NULL )
                 AND (  p_last_updated_by IS NULL )))
        AND (    ( Recinfo.creation_date = p_creation_date)
             OR (    ( Recinfo.creation_date IS NULL )
                 AND (  p_creation_date IS NULL )))
        AND (    ( Recinfo.created_by = p_created_by)
             OR (    ( Recinfo.created_by IS NULL )
                 AND (  p_created_by IS NULL )))
        AND (    ( Recinfo.last_update_login = p_last_update_login)
             OR (    ( Recinfo.last_update_login IS NULL )
                 AND (  p_last_update_login IS NULL )))
        AND (    ( Recinfo.object_version_number = px_object_version_number)
             OR (    ( Recinfo.object_version_number IS NULL )
                 AND (  px_object_version_number IS NULL )))
        ) THEN
        RETURN;