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_PMT_MODE_PKG SQL Statements

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

Line: 40


PROCEDURE Insert_Row(
           px_program_payment_mode_id  IN OUT NOCOPY  NUMBER
          ,p_program_id                        NUMBER
          ,p_geo_hierarchy_id                  NUMBER
          ,p_mode_of_payment                   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
          ,p_mode_type			       VARCHAR2
          )

 IS

BEGIN

   INSERT INTO PV_PROGRAM_PAYMENT_MODE(
            program_payment_mode_id
           ,program_id
           ,geo_hierarchy_id
           ,mode_of_payment
           ,last_update_date
           ,last_updated_by
           ,creation_date
           ,created_by
           ,last_update_login
           ,object_version_number
           ,mode_type
           )
         VALUES (
           -- DECODE( px_program_payment_mode_id, FND_API.g_miss_num, NULL, px_program_payment_mode_id)
           -- ,DECODE( p_program_id, FND_API.g_miss_num, NULL, p_program_id)
           -- ,DECODE( p_geo_hierarchy_id, FND_API.g_miss_num, NULL, p_geo_hierarchy_id)
           -- ,DECODE( p_mode_of_payment, FND_API.g_miss_char, NULL, p_mode_of_payment)
           -- ,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_creation_date, FND_API.g_miss_date, NULL, p_creation_date)
           -- ,DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by)
           -- ,DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login)
           -- ,DECODE( p_object_version_number, FND_API.g_miss_num, NULL, p_object_version_number)

            DECODE( px_program_payment_mode_id, NULL,px_program_payment_mode_id,FND_API.g_miss_num, NULL, px_program_payment_mode_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_mode_of_payment, NULL,p_mode_of_payment,FND_API.g_miss_char, NULL, p_mode_of_payment)
           ,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_mode_type, NULL,p_mode_type,FND_API.g_miss_char, NULL, p_mode_type)
	   );

Line: 95


END Insert_Row;

Line: 111


PROCEDURE Update_Row(
           p_program_payment_mode_id           NUMBER
          ,p_program_id                        NUMBER
          ,p_geo_hierarchy_id                  NUMBER
          ,p_mode_of_payment                   VARCHAR2
          ,p_last_update_date                  DATE
          ,p_last_updated_by                   NUMBER
          ,p_last_update_login                 NUMBER
          ,p_object_version_number             NUMBER
	  ,p_mode_type                         VARCHAR2
          )

 IS

 BEGIN

    Update PV_PROGRAM_PAYMENT_MODE
    SET
       -- program_payment_mode_id = DECODE( p_program_payment_mode_id, FND_API.g_miss_num, program_payment_mode_id, p_program_payment_mode_id)
       -- ,program_id              = DECODE( p_program_id, FND_API.g_miss_num, program_id, p_program_id)
       -- ,geo_hierarchy_id        = DECODE( p_geo_hierarchy_id, FND_API.g_miss_num, geo_hierarchy_id, p_geo_hierarchy_id)
       -- ,mode_of_payment         = DECODE( p_mode_of_payment, FND_API.g_miss_char, mode_of_payment, p_mode_of_payment)
       -- ,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)
       -- ,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)


        program_payment_mode_id = DECODE( p_program_payment_mode_id, NULL, program_payment_mode_id, FND_API.g_miss_num, NULL, p_program_payment_mode_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)
       ,mode_of_payment         = DECODE( p_mode_of_payment, NULL, mode_of_payment, FND_API.g_miss_char, NULL, p_mode_of_payment)
       ,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)
       ,mode_type         = DECODE( p_mode_type, NULL,p_mode_type,FND_API.g_miss_char, NULL, p_mode_type)

   WHERE PROGRAM_PAYMENT_MODE_ID = p_program_payment_mode_id
   AND object_version_number = p_object_version_number;

Line: 160


END Update_Row;

Line: 176


PROCEDURE Delete_Row(
    p_program_payment_mode_id  NUMBER
    ,p_object_version_number   NUMBER
    )
 IS

 BEGIN

   DELETE FROM PV_PROGRAM_PAYMENT_MODE
    WHERE program_payment_mode_id = p_program_payment_mode_id
     AND object_version_number = p_object_version_number;

Line: 196


 END Delete_Row ;

Line: 217


          ,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
	  ,p_mode_type                       VARCHAR2
          )

 IS
   CURSOR C IS
        SELECT *
         FROM PV_PROGRAM_PAYMENT_MODE
        WHERE PROGRAM_PAYMENT_MODE_ID =  px_program_payment_mode_id
        FOR UPDATE of PROGRAM_PAYMENT_MODE_ID NOWAIT;

Line: 238


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

Line: 253


       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 )))
       AND (    ( Recinfo.mode_type = p_mode_type)
            OR (    ( Recinfo.mode_type IS NULL )
                AND (  p_mode_type IS NULL )))
       ) THEN
       RETURN;