eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PV_PRGM_BENEFITS_PKG SQL Statements

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

Line: 41


PROCEDURE Insert_Row(
           px_program_benefits_id       IN OUT NOCOPY  NUMBER
          ,p_program_id                         NUMBER
          ,p_benefit_code                       VARCHAR2
          ,p_benefit_id                         NUMBER
          ,p_benefit_type_code                  VARCHAR2
          ,p_delete_flag                        VARCHAR2
          ,p_last_update_login                  NUMBER
          ,p_last_update_date                   DATE
          ,p_last_updated_by                    NUMBER
          ,p_created_by                         NUMBER
          ,p_creation_date                      DATE
          ,p_object_version_number              NUMBER
          )

 IS

BEGIN

   INSERT INTO PV_PROGRAM_BENEFITS(
            program_benefits_id
           ,program_id
           ,benefit_code
           ,benefit_id
           ,benefit_type_code
           ,delete_flag
           ,last_update_login
           ,last_update_date
           ,last_updated_by
           ,created_by
           ,creation_date
           ,object_version_number
   ) VALUES (
       --     DECODE( px_program_benefits_id, FND_API.g_miss_num, NULL, px_program_benefits_id)
       --    ,DECODE( p_program_id, FND_API.g_miss_num, NULL, p_program_id)
       --    ,DECODE( p_benefit_code, FND_API.g_miss_char, NULL, p_benefit_code)
       --    ,DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login)
       --    ,DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date)
       --    ,DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by)
       --    ,DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by)
       --    ,DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date)
       --    ,DECODE( p_object_version_number, FND_API.g_miss_num, NULL, p_object_version_number)

            DECODE( px_program_benefits_id, NULL,px_program_benefits_id, FND_API.g_miss_num, NULL, px_program_benefits_id)
           ,DECODE( p_program_id, NULL,p_program_id, FND_API.g_miss_num, NULL, p_program_id)
           ,DECODE( p_benefit_code, NULL,p_benefit_code, FND_API.g_miss_char, NULL, p_benefit_code)
           ,DECODE( p_benefit_id, NULL,p_benefit_id, FND_API.g_miss_num, NULL, p_benefit_id)
           ,DECODE( p_benefit_type_code, NULL,p_benefit_type_code, FND_API.g_miss_char, NULL, p_benefit_type_code)
           ,DECODE( p_delete_flag, NULL,p_delete_flag, FND_API.g_miss_char, NULL, p_delete_flag)
           ,DECODE( p_last_update_login, NULL, p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login)
           ,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_created_by, NULL, p_created_by, FND_API.g_miss_num, NULL, p_created_by)
           ,DECODE( p_creation_date, NULL, p_creation_date, FND_API.g_miss_date, NULL, p_creation_date)
           ,DECODE( p_object_version_number, NULL, p_object_version_number, FND_API.g_miss_num, NULL, p_object_version_number)

          );

Line: 98


END Insert_Row;

Line: 113


PROCEDURE Update_Row(
           p_program_benefits_id                NUMBER
          ,p_program_id                         NUMBER
          ,p_benefit_code                       VARCHAR2
          ,p_benefit_id                         NUMBER
          ,p_benefit_type_code                  VARCHAR2
          ,p_delete_flag                        VARCHAR2
          ,p_last_update_login                  NUMBER
          ,p_object_version_number              NUMBER
          ,p_last_update_date                   DATE
          ,p_last_updated_by                    NUMBER
          )

 IS
 BEGIN
    Update PV_PROGRAM_BENEFITS
    SET
          --     program_benefits_id   = DECODE( p_program_benefits_id, FND_API.g_miss_num, program_benefits_id, p_program_benefits_id)
          --    ,program_id            = DECODE( p_program_id, FND_API.g_miss_num, program_id, p_program_id)
          --    ,benefit_code          = DECODE( p_benefit_code, FND_API.g_miss_char, benefit_code, p_benefit_code)
          --    ,last_update_login     = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login)
          --    ,object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1)
          --    ,last_update_date      = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date)
          --    ,last_updated_by       = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by)
               program_benefits_id   = DECODE( p_program_benefits_id, NULL, program_benefits_id, FND_API.g_miss_num, NULL, p_program_benefits_id)
              ,program_id            = DECODE( p_program_id, NULL, program_id, FND_API.g_miss_num, NULL, p_program_id)
              ,benefit_code          = DECODE( p_benefit_code, NULL, benefit_code, FND_API.g_miss_char, NULL, p_benefit_code)
              ,benefit_id            = DECODE( p_benefit_id, NULL, benefit_id, FND_API.g_miss_num, NULL, p_benefit_id)
              ,benefit_type_code     = DECODE( p_benefit_type_code, NULL, benefit_type_code, FND_API.g_miss_char, NULL, p_benefit_type_code)
              ,delete_flag           = DECODE( p_delete_flag, NULL, delete_flag, FND_API.g_miss_char, NULL, p_delete_flag)
              ,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)
              ,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)

   WHERE PROGRAM_BENEFITS_ID = p_program_benefits_id
   AND object_version_number = p_object_version_number;

Line: 159


END Update_Row;

Line: 174


PROCEDURE Delete_Row(
     p_program_benefits_id    NUMBER
    ,p_object_version_number  NUMBER
    )
 IS
 BEGIN
   UPDATE PV_PROGRAM_BENEFITS
   SET
      --program_benefits_id       = DECODE( p_program_benefits_id, NULL ,program_benefits_id, FND_API.g_miss_num,  NULL , p_program_benefits_id)
      delete_flag               ='Y'
     ,last_update_date          = SYSDATE
     ,last_updated_by           = FND_GLOBAL.user_id
     ,last_update_login         = FND_GLOBAL.conc_login_id
     ,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_benefits_id = p_program_benefits_id
   AND object_version_number = p_object_version_number;

Line: 200


 END Delete_Row ;

Line: 220


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

 IS
   CURSOR C IS
        SELECT *
         FROM PV_PROGRAM_BENEFITS
        WHERE PROGRAM_BENEFITS_ID =  px_program_benefits_id
        FOR UPDATE of PROGRAM_BENEFITS_ID NOWAIT;

Line: 242


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

Line: 260


       AND (    ( Recinfo.delete_flag = p_delete_flag)
            OR (    ( Recinfo.delete_flag IS NULL )
                AND (  p_delete_flag 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 )))
       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.created_by = p_created_by)
            OR (    ( Recinfo.created_by IS NULL )
                AND (  p_created_by IS NULL )))
       AND (    ( Recinfo.creation_date = p_creation_date)
            OR (    ( Recinfo.creation_date IS NULL )
                AND (  p_creation_date IS NULL )))
       ) THEN
       RETURN;