APPS.PV_PRGM_CONTRACTS_PKG SQL Statements

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

Line: 45

PROCEDURE Insert_Row(
           px_program_contracts_id    IN OUT NOCOPY   NUMBER
          ,p_program_id                        NUMBER
          ,p_geo_hierarchy_id                  NUMBER
          ,p_contract_id                       NUMBER
          ,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
          ,p_member_type_code                  VARCHAR2
          )

 IS

BEGIN

   INSERT INTO PV_PROGRAM_CONTRACTS(
            program_contracts_id
           ,program_id
           ,geo_hierarchy_id
           ,contract_id
           ,last_update_date
           ,last_updated_by
           ,creation_date
           ,created_by
           ,last_update_login
           ,object_version_number
           ,member_type_code
           )
       VALUES (
            DECODE( px_program_contracts_id, NULL, px_program_contracts_id, FND_API.g_miss_num, NULL, px_program_contracts_id)
           ,DECODE( p_program_id, NULL, p_program_id, FND_API.g_miss_num, NULL, p_program_id)
           ,DECODE( p_geo_hierarchy_id, NULL, p_geo_hierarchy_id, FND_API.g_miss_num, NULL, p_geo_hierarchy_id)
           ,DECODE( p_contract_id, NULL, p_contract_id, FND_API.g_miss_num, NULL, p_contract_id)
           ,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)
           ,DECODE( p_member_type_code, NULL, p_member_type_code, FND_API.g_miss_num, NULL, p_member_type_code)
           );

Line: 89

END Insert_Row;

Line: 105

PROCEDURE Update_Row(
           p_program_contracts_id            NUMBER
          ,p_program_id                      NUMBER
          ,p_geo_hierarchy_id                NUMBER
          ,p_contract_id                     NUMBER
          ,p_last_update_date                DATE
          ,p_last_updated_by                 NUMBER
          ,p_last_update_login               NUMBER
          ,p_object_version_number           NUMBER
          ,p_member_type_code                 VARCHAR2
         )

 IS
 BEGIN
    Update PV_PROGRAM_CONTRACTS
    SET
               program_contracts_id  = DECODE( p_program_contracts_id, NULL, program_contracts_id, FND_API.g_miss_num, NULL, p_program_contracts_id)
              ,program_id            = DECODE( p_program_id, NULL, program_id, FND_API.g_miss_num, NULL, p_program_id)
              ,geo_hierarchy_id      = DECODE( p_geo_hierarchy_id, NULL, geo_hierarchy_id, FND_API.g_miss_num, NULL, p_geo_hierarchy_id)
              ,contract_id           = DECODE( p_contract_id, NULL, contract_id, FND_API.g_miss_num, NULL, p_contract_id)
              ,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)
              ,member_type_code       = DECODE( p_member_type_code, NULL, member_type_code, FND_API.g_miss_char, NULL, p_member_type_code)
   WHERE program_contracts_id = p_program_contracts_id
   AND object_version_number = p_object_version_number;

Line: 141

END Update_Row;

Line: 157

PROCEDURE Delete_Row(
     p_program_contracts_id  NUMBER
    ,p_object_version_number NUMBER
    )
 IS

 BEGIN

   DELETE FROM PV_PROGRAM_CONTRACTS
    WHERE program_contracts_id = p_program_contracts_id
     AND object_version_number = p_object_version_number;

Line: 177

 END DELETE_ROW ;

Line: 199

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

 IS
   CURSOR C IS
        SELECT *
         FROM PV_PROGRAM_CONTRACTS
        WHERE program_contracts_id =  px_program_contracts_id
        FOR UPDATE of program_contracts_id NOWAIT;

Line: 221

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

Line: 236

       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.member_type_code = p_member_type_code)
            OR (    ( Recinfo.member_type_code IS NULL )
                AND (  p_member_type_code 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;