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

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

Line: 58


PROCEDURE Insert_Row(
           px_program_id               IN OUT NOCOPY   NUMBER
          ,p_PROGRAM_TYPE_ID              NUMBER
          ,p_custom_setup_id                    NUMBER
          ,p_program_level_code                 VARCHAR2
          ,p_program_parent_id                  NUMBER
          ,p_program_owner_resource_id          NUMBER
          ,p_program_start_date                 DATE
          ,p_program_end_date                   DATE
	  ,p_allow_enrl_until_date              DATE
	  ,p_citem_version_id                   NUMBER
          ,p_membership_valid_period            NUMBER
          ,p_membership_period_unit             VARCHAR2
          ,p_process_rule_id                    NUMBER
          ,p_prereq_process_rule_Id             NUMBER
          ,p_program_status_code                VARCHAR2
          ,p_submit_child_nodes                 VARCHAR2
          ,p_inventory_item_id                  NUMBER
          ,p_inventory_item_org_id              NUMBER
          ,p_bus_user_resp_id                   NUMBER
          ,p_admin_resp_id                      NUMBER
          ,p_no_fee_flag                        VARCHAR2
          ,p_vad_invite_allow_flag              VARCHAR2
          ,p_global_mmbr_reqd_flag              VARCHAR2
          ,p_waive_subsidiary_fee_flag          VARCHAR2
          ,p_qsnr_ttl_all_page_dsp_flag        VARCHAR2
          ,p_qsnr_hdr_all_page_dsp_flag      VARCHAR2
          ,p_qsnr_ftr_all_page_dsp_flag      VARCHAR2
          ,p_allow_enrl_wout_chklst_flag     VARCHAR2
          ,p_user_status_id                     NUMBER
          ,p_enabled_flag                       VARCHAR2
          ,p_attribute_category                 VARCHAR2
          ,p_attribute1                         VARCHAR2
          ,p_attribute2                         VARCHAR2
          ,p_attribute3                         VARCHAR2
          ,p_attribute4                         VARCHAR2
          ,p_attribute5                         VARCHAR2
          ,p_attribute6                         VARCHAR2
          ,p_attribute7                         VARCHAR2
          ,p_attribute8                         VARCHAR2
          ,p_attribute9                         VARCHAR2
          ,p_attribute10                        VARCHAR2
          ,p_attribute11                        VARCHAR2
          ,p_attribute12                        VARCHAR2
          ,p_attribute13                        VARCHAR2
          ,p_attribute14                        VARCHAR2
          ,p_attribute15                        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_program_name                       VARCHAR2
          ,p_program_description                VARCHAR2
          ,p_source_lang                        VARCHAR2
          ,p_qsnr_title                         VARCHAR2
          ,p_qsnr_header                        VARCHAR2
          ,p_qsnr_footer                        VARCHAR2
          )

 IS

BEGIN

   INSERT INTO PV_PARTNER_PROGRAM_B(
            program_id
           ,PROGRAM_TYPE_ID
           ,custom_setup_id
           ,program_level_code
           ,program_parent_id
           ,program_owner_resource_id
           ,program_start_date
           ,program_end_date
       	   ,allow_enrl_until_date
    	   ,citem_version_id
           ,membership_valid_period
           ,membership_period_unit
           ,process_rule_id
           ,prereq_process_rule_Id
           ,program_status_code
           ,submit_child_nodes
           ,inventory_item_id
           ,inventory_item_org_id
           ,bus_user_resp_id
           ,admin_resp_id
           ,no_fee_flag
           ,vad_invite_allow_flag
           ,global_mmbr_reqd_flag
           ,waive_subsidiary_fee_flag
           ,qsnr_ttl_all_page_dsp_flag
           ,qsnr_hdr_all_page_dsp_flag
           ,qsnr_ftr_all_page_dsp_flag
           ,allow_enrl_wout_chklst_flag
           ,user_status_id
           ,enabled_flag
           ,attribute_category
           ,attribute1
           ,attribute2
           ,attribute3
           ,attribute4
           ,attribute5
           ,attribute6
           ,attribute7
           ,attribute8
           ,attribute9
           ,attribute10
           ,attribute11
           ,attribute12
           ,attribute13
           ,attribute14
           ,attribute15
           ,last_update_date
           ,last_updated_by
           ,creation_date
           ,created_by
           ,last_update_login
           ,object_version_number
         ) VALUES (
            DECODE( px_program_id, NULL, px_program_id, FND_API.g_miss_num, NULL, px_program_id)
           ,DECODE( p_PROGRAM_TYPE_ID, NULL, p_PROGRAM_TYPE_ID, FND_API.g_miss_num, NULL, p_PROGRAM_TYPE_ID)
           ,DECODE( p_custom_setup_id, NULL,p_custom_setup_id, FND_API.g_miss_num, NULL, p_custom_setup_id)
           ,DECODE( p_program_level_code, NULL, p_program_level_code, FND_API.g_miss_char, NULL, p_program_level_code)
           ,DECODE( p_program_parent_id, NULL, p_program_parent_id,FND_API.g_miss_num, NULL, p_program_parent_id)
           ,DECODE( p_program_owner_resource_id, NULL, p_program_owner_resource_id,FND_API.g_miss_num, NULL, p_program_owner_resource_id)
           ,DECODE( p_program_start_date, NULL, p_program_start_date, FND_API.g_miss_date, NULL, p_program_start_date)
           ,DECODE( p_program_end_date,  NULL, p_program_end_date,FND_API.g_miss_date, NULL, p_program_end_date)
           ,DECODE( p_allow_enrl_until_date,  NULL, p_allow_enrl_until_date,FND_API.g_miss_date, NULL, p_allow_enrl_until_date)
	   ,DECODE( p_citem_version_id , NULL, p_citem_version_id , FND_API.g_miss_num, NULL, p_citem_version_id)
       	   ,DECODE( p_membership_valid_period, NULL, p_membership_valid_period, FND_API.g_miss_num, NULL, p_membership_valid_period)
           ,DECODE( p_membership_period_unit, NULL, p_membership_period_unit,FND_API.g_miss_char, NULL, p_membership_period_unit)
           ,DECODE( p_process_rule_id, NULL, p_process_rule_id, FND_API.g_miss_num, NULL, p_process_rule_id)
           ,DECODE( p_prereq_process_rule_Id, NULL, p_prereq_process_rule_Id, FND_API.g_miss_num, NULL, p_prereq_process_rule_Id)
           ,DECODE( p_program_status_code, NULL, p_program_status_code,FND_API.g_miss_char, NULL, p_program_status_code)
           ,DECODE( p_submit_child_nodes, NULL, p_submit_child_nodes,FND_API.g_miss_char, NULL, p_submit_child_nodes)
           ,DECODE( p_inventory_item_id, NULL, p_inventory_item_id,FND_API.g_miss_num, NULL, p_inventory_item_id)
           ,DECODE( p_inventory_item_org_id, NULL, p_inventory_item_org_id,FND_API.g_miss_num, NULL, p_inventory_item_org_id)
           ,DECODE( p_bus_user_resp_id, NULL, p_bus_user_resp_id,FND_API.g_miss_num, NULL, p_bus_user_resp_id)
           ,DECODE( p_admin_resp_id, NULL, p_admin_resp_id,FND_API.g_miss_num, NULL, p_admin_resp_id)
           ,DECODE( p_no_fee_flag, NULL, p_no_fee_flag,FND_API.g_miss_char, NULL, p_no_fee_flag)
           ,DECODE( p_vad_invite_allow_flag, NULL, p_vad_invite_allow_flag,FND_API.g_miss_char, NULL, p_vad_invite_allow_flag)
           ,DECODE( p_global_mmbr_reqd_flag, NULL, p_global_mmbr_reqd_flag,FND_API.g_miss_char, NULL, p_global_mmbr_reqd_flag)
           ,DECODE( p_waive_subsidiary_fee_flag, NULL, p_waive_subsidiary_fee_flag,FND_API.g_miss_char, NULL, p_waive_subsidiary_fee_flag)
           ,DECODE( p_qsnr_ttl_all_page_dsp_flag , NULL, p_qsnr_ttl_all_page_dsp_flag ,FND_API.g_miss_char, NULL, p_qsnr_ttl_all_page_dsp_flag )
           ,DECODE( p_qsnr_hdr_all_page_dsp_flag , NULL, p_qsnr_hdr_all_page_dsp_flag ,FND_API.g_miss_char, NULL, p_qsnr_hdr_all_page_dsp_flag )
           ,DECODE( p_qsnr_ftr_all_page_dsp_flag, NULL, p_qsnr_ftr_all_page_dsp_flag,FND_API.g_miss_char, NULL, p_qsnr_ftr_all_page_dsp_flag)
           ,DECODE( p_allow_enrl_wout_chklst_flag, NULL, p_allow_enrl_wout_chklst_flag,FND_API.g_miss_char, NULL, p_allow_enrl_wout_chklst_flag)
           ,DECODE( p_user_status_id, NULL, p_user_status_id, FND_API.g_miss_num, NULL, p_user_status_id)
           ,DECODE( p_enabled_flag, NULL, p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag)
           ,DECODE( p_attribute_category, NULL, p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category)
           ,DECODE( p_attribute1, NULL, p_attribute1, FND_API.g_miss_char, NULL, p_attribute1)
           ,DECODE( p_attribute2, NULL, p_attribute2, FND_API.g_miss_char, NULL, p_attribute2)
           ,DECODE( p_attribute3, NULL, p_attribute3,  FND_API.g_miss_char, NULL, p_attribute3)
           ,DECODE( p_attribute4, NULL, p_attribute4 , FND_API.g_miss_char, NULL, p_attribute4)
           ,DECODE( p_attribute5, NULL, p_attribute5, FND_API.g_miss_char, NULL, p_attribute5)
           ,DECODE( p_attribute6, NULL, p_attribute6, FND_API.g_miss_char, NULL, p_attribute6)
           ,DECODE( p_attribute7, NULL, p_attribute7, FND_API.g_miss_char, NULL, p_attribute7)
           ,DECODE( p_attribute8, NULL, p_attribute8, FND_API.g_miss_char, NULL, p_attribute8)
           ,DECODE( p_attribute9, NULL, p_attribute9, FND_API.g_miss_char, NULL, p_attribute9)
           ,DECODE( p_attribute10, NULL, p_attribute10, FND_API.g_miss_char, NULL, p_attribute10)
           ,DECODE( p_attribute11, NULL, p_attribute11, FND_API.g_miss_char, NULL, p_attribute11)
           ,DECODE( p_attribute12, NULL, p_attribute12, FND_API.g_miss_char, NULL, p_attribute12)
           ,DECODE( p_attribute13, NULL, p_attribute13, FND_API.g_miss_char, NULL, p_attribute13)
           ,DECODE( p_attribute14, NULL, p_attribute14, FND_API.g_miss_char, NULL, p_attribute14)
           ,DECODE( p_attribute15, NULL, p_attribute15, FND_API.g_miss_char, NULL, p_attribute15)
           ,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: 231


   INSERT INTO PV_PARTNER_PROGRAM_TL(
            program_id
           ,last_update_date
           ,last_updated_by
           ,creation_date
           ,created_by
           ,last_update_login
           ,language
           ,source_lang
           ,program_name
           ,program_description
           ,qsnr_title
           ,qsnr_header
           ,qsnr_footer

           )
   SELECT
           DECODE( px_program_id, NULL, px_program_id, FND_API.g_miss_num, NULL, px_program_id)
           --DECODE( px_program_id, FND_API.g_miss_num, NULL, px_program_id)
	   ,SYSDATE
      	   ,FND_GLOBAL.user_id
      	   ,SYSDATE
      	   ,FND_GLOBAL.user_id
           ,FND_GLOBAL.conc_login_id
           ,l.language_code
           ,USERENV('LANG')
           ,DECODE( p_program_name, NULL, p_program_name, FND_API.g_miss_char, NULL, p_program_name)
           ,DECODE( p_program_description,NULL, p_program_description, FND_API.g_miss_char, NULL, p_program_description)
           ,DECODE( p_qsnr_title, NULL, p_qsnr_title, FND_API.g_miss_char, NULL, p_qsnr_title)
           ,DECODE( p_qsnr_header,NULL, p_qsnr_header, FND_API.g_miss_char, NULL,p_qsnr_header)
           ,DECODE( p_qsnr_footer, NULL, p_qsnr_footer, FND_API.g_miss_char, NULL,p_qsnr_footer)
   FROM FND_LANGUAGES l
   WHERE l.installed_flag in ('I', 'B')
   AND NOT EXISTS(
         SELECT NULL
         FROM PV_PARTNER_PROGRAM_TL t
         --WHERE t.program_id = DECODE( px_program_id, FND_API.g_miss_num, NULL, px_program_id)
         WHERE t.program_id = DECODE( px_program_id, NULL, px_program_id, FND_API.g_miss_num, NULL, px_program_id)
         AND t.language = l.language_code );

Line: 271


END Insert_Row;

Line: 287


PROCEDURE Update_Row(
           p_program_id                         NUMBER
          ,p_PROGRAM_TYPE_ID                    NUMBER
          ,p_custom_setup_id                    NUMBER
          ,p_program_level_code                 VARCHAR2
          ,p_program_parent_id                  NUMBER
          ,p_program_owner_resource_id          NUMBER
          ,p_program_start_date                 DATE
          ,p_program_end_date                   DATE
       	  ,p_allow_enrl_until_date              DATE
	  ,p_citem_version_id                   NUMBER
	  ,p_membership_valid_period            NUMBER
          ,p_membership_period_unit             VARCHAR2
          ,p_process_rule_id                    NUMBER
          ,p_prereq_process_rule_Id             NUMBER
          ,p_program_status_code                VARCHAR2
          ,p_submit_child_nodes                 VARCHAR2
          ,p_inventory_item_id                  NUMBER
          ,p_inventory_item_org_id              NUMBER
          ,p_bus_user_resp_id                   NUMBER
          ,p_admin_resp_id                      NUMBER
          ,p_no_fee_flag                        VARCHAR2
          ,p_vad_invite_allow_flag              VARCHAR2
          ,p_global_mmbr_reqd_flag              VARCHAR2
          ,p_waive_subsidiary_fee_flag          VARCHAR2
          ,p_qsnr_ttl_all_page_dsp_flag        VARCHAR2
          ,p_qsnr_hdr_all_page_dsp_flag      VARCHAR2
          ,p_qsnr_ftr_all_page_dsp_flag      VARCHAR2
          ,p_allow_enrl_wout_chklst_flag     VARCHAR2
          ,p_user_status_id                     NUMBER
          ,p_enabled_flag                       VARCHAR2
          ,p_attribute_category                 VARCHAR2
          ,p_attribute1                         VARCHAR2
          ,p_attribute2                         VARCHAR2
          ,p_attribute3                         VARCHAR2
          ,p_attribute4                         VARCHAR2
          ,p_attribute5                         VARCHAR2
          ,p_attribute6                         VARCHAR2
          ,p_attribute7                         VARCHAR2
          ,p_attribute8                         VARCHAR2
          ,p_attribute9                         VARCHAR2
          ,p_attribute10                        VARCHAR2
          ,p_attribute11                        VARCHAR2
          ,p_attribute12                        VARCHAR2
          ,p_attribute13                        VARCHAR2
          ,p_attribute14                        VARCHAR2
          ,p_attribute15                        VARCHAR2
          ,p_last_update_date                   DATE
          ,p_last_updated_by                    NUMBER
          ,p_last_update_login                  NUMBER
          ,p_object_version_number              NUMBER
          ,p_program_name                       VARCHAR2
          ,p_program_description                VARCHAR2
          ,p_qsnr_title                         VARCHAR2
          ,p_qsnr_header                        VARCHAR2
          ,p_qsnr_footer                        VARCHAR2
          )

 IS

 BEGIN

   IF (PV_DEBUG_HIGH_ON) THEN



   PVX_Utility_PVT.debug_message('Within PV_PARTNER_PROGRAM_PKG.UPDATE_ROW API: ');

Line: 358


   PVX_Utility_PVT.debug_message('Within PV_PARTNER_PROGRAM_PKG.UPDATE_ROW API : object_version_number ' ||p_object_version_number );

Line: 362


   UPDATE PV_PARTNER_PROGRAM_B
   SET

               program_id                = DECODE( p_program_id, NULL ,program_id, FND_API.g_miss_num,  NULL , p_program_id)
              ,PROGRAM_TYPE_ID           = DECODE( p_PROGRAM_TYPE_ID, NULL ,PROGRAM_TYPE_ID,FND_API.g_miss_num,  NULL , p_PROGRAM_TYPE_ID)
              ,custom_setup_id           = DECODE( p_custom_setup_id, NULL ,custom_setup_id, FND_API.g_miss_num, NULL ,  p_custom_setup_id)
              ,program_level_code        = DECODE( p_program_level_code, NULL , program_level_code, FND_API.g_miss_char,  NULL , p_program_level_code)
              ,program_parent_id         = DECODE( p_program_parent_id, NULL , program_parent_id, FND_API.g_miss_num, NULL , p_program_parent_id)
              ,program_owner_resource_id = DECODE( p_program_owner_resource_id, NULL , program_owner_resource_id, FND_API.g_miss_num,  NULL ,p_program_owner_resource_id)
              ,program_start_date        = DECODE( p_program_start_date, NULL , program_start_date, FND_API.g_miss_date, NULL , p_program_start_date)
              ,program_end_date          = DECODE( p_program_end_date, NULL , program_end_date,  FND_API.g_miss_date, NULL ,p_program_end_date)
              ,allow_enrl_until_date     = DECODE( p_allow_enrl_until_date, NULL , allow_enrl_until_date,  FND_API.g_miss_date, NULL ,p_allow_enrl_until_date)
	      ,citem_version_id          = DECODE( p_citem_version_id,  NULL ,citem_version_id, FND_API.g_miss_num,  NULL , p_citem_version_id)
	      ,membership_valid_period   = DECODE( p_membership_valid_period,  NULL ,membership_valid_period, FND_API.g_miss_num,  NULL , p_membership_valid_period)
              ,membership_period_unit    = DECODE( p_membership_period_unit, NULL , membership_period_unit, FND_API.g_miss_char, NULL , p_membership_period_unit)
              ,process_rule_id           = DECODE( p_process_rule_id,  NULL ,process_rule_id, FND_API.g_miss_num, NULL ,  p_process_rule_id)
              ,prereq_process_rule_Id    = DECODE( p_prereq_process_rule_Id,  NULL ,prereq_process_rule_Id, FND_API.g_miss_num, NULL ,  p_prereq_process_rule_Id)
              ,program_status_code       = DECODE( p_program_status_code,  NULL ,program_status_code,FND_API.g_miss_char,  NULL , p_program_status_code)
              ,submit_child_nodes        = DECODE( p_submit_child_nodes,  NULL ,submit_child_nodes,FND_API.g_miss_char,  NULL , p_submit_child_nodes)
              ,inventory_item_id         = DECODE( p_inventory_item_id, NULL , inventory_item_id, FND_API.g_miss_num, NULL , p_inventory_item_id)
              ,inventory_item_org_id     = DECODE( p_inventory_item_org_id, NULL , inventory_item_org_id, FND_API.g_miss_num, NULL , p_inventory_item_org_id)
              ,bus_user_resp_id          = DECODE( p_bus_user_resp_id, NULL , bus_user_resp_id, FND_API.g_miss_num, NULL , p_bus_user_resp_id)
              ,admin_resp_id             = DECODE( p_admin_resp_id, NULL , admin_resp_id, FND_API.g_miss_num, NULL , p_admin_resp_id)
              ,no_fee_flag               = DECODE( p_no_fee_flag,  NULL ,no_fee_flag,FND_API.g_miss_char, NULL ,  p_no_fee_flag)
              ,vad_invite_allow_flag     = DECODE( p_vad_invite_allow_flag,  NULL ,vad_invite_allow_flag,FND_API.g_miss_char, NULL ,  p_vad_invite_allow_flag)
              ,global_mmbr_reqd_flag     = DECODE( p_global_mmbr_reqd_flag,  NULL ,global_mmbr_reqd_flag,FND_API.g_miss_char, NULL ,  p_global_mmbr_reqd_flag)
              ,waive_subsidiary_fee_flag = DECODE( p_waive_subsidiary_fee_flag,  NULL ,waive_subsidiary_fee_flag,FND_API.g_miss_char, NULL ,  p_waive_subsidiary_fee_flag)
              ,qsnr_ttl_all_page_dsp_flag = DECODE( p_qsnr_ttl_all_page_dsp_flag ,  NULL ,qsnr_ttl_all_page_dsp_flag ,FND_API.g_miss_char, NULL ,  p_qsnr_ttl_all_page_dsp_flag )
              ,qsnr_hdr_all_page_dsp_flag = DECODE( p_qsnr_hdr_all_page_dsp_flag,  NULL ,qsnr_hdr_all_page_dsp_flag,FND_API.g_miss_char, NULL ,  p_qsnr_hdr_all_page_dsp_flag)
              ,qsnr_ftr_all_page_dsp_flag = DECODE( p_qsnr_ftr_all_page_dsp_flag ,  NULL ,qsnr_ftr_all_page_dsp_flag ,FND_API.g_miss_char, NULL ,  p_qsnr_ftr_all_page_dsp_flag )
              ,allow_enrl_wout_chklst_flag= DECODE( p_allow_enrl_wout_chklst_flag,  NULL ,allow_enrl_wout_chklst_flag,FND_API.g_miss_char, NULL ,  p_allow_enrl_wout_chklst_flag)
              ,user_status_id            = DECODE( p_user_status_id,  NULL ,user_status_id, FND_API.g_miss_num, NULL , p_user_status_id)
              ,enabled_flag              = DECODE( p_enabled_flag,  NULL ,enabled_flag,FND_API.g_miss_char, NULL ,  p_enabled_flag)
              ,attribute_category        = DECODE( p_attribute_category, attribute_category, FND_API.g_miss_char, NULL , p_attribute_category)
              ,attribute1                = DECODE( p_attribute1,  NULL , attribute1,FND_API.g_miss_char, NULL , p_attribute1)
              ,attribute2                = DECODE( p_attribute2,  NULL ,attribute2, FND_API.g_miss_char, NULL ,  p_attribute2)
              ,attribute3                = DECODE( p_attribute3, NULL , attribute3, FND_API.g_miss_char, NULL ,  p_attribute3)
              ,attribute4                = DECODE( p_attribute4,  NULL ,attribute4, FND_API.g_miss_char, NULL ,  p_attribute4)
              ,attribute5                = DECODE( p_attribute5,  NULL , attribute5,  FND_API.g_miss_char, NULL ,p_attribute5)
              ,attribute6                = DECODE( p_attribute6,  NULL ,attribute6, FND_API.g_miss_char, NULL ,p_attribute6)
              ,attribute7                = DECODE( p_attribute7,  NULL ,attribute7, FND_API.g_miss_char, NULL ,  p_attribute7)
              ,attribute8                = DECODE( p_attribute8,  NULL ,attribute8, FND_API.g_miss_char, NULL ,  p_attribute8)
              ,attribute9                = DECODE( p_attribute9,  NULL ,attribute9, FND_API.g_miss_char, NULL , p_attribute9)
              ,attribute10               = DECODE( p_attribute10,  NULL ,attribute10, FND_API.g_miss_char, NULL , p_attribute10)
              ,attribute11               = DECODE( p_attribute11,  NULL ,attribute11,FND_API.g_miss_char, NULL , p_attribute11)
              ,attribute12               = DECODE( p_attribute12,  NULL ,attribute12, FND_API.g_miss_char, NULL ,  p_attribute12)
              ,attribute13               = DECODE( p_attribute13, NULL ,attribute13,  FND_API.g_miss_char, NULL ,  p_attribute13)
              ,attribute14               = DECODE( p_attribute14,  NULL ,attribute14, FND_API.g_miss_char, NULL , p_attribute14)
              ,attribute15               = DECODE( p_attribute15, NULL , attribute15, FND_API.g_miss_char, NULL , p_attribute15)
              ,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_ID = p_program_id
   AND object_version_number = p_object_version_number;

Line: 428


   Update PV_PARTNER_PROGRAM_TL
   SET
               last_update_date    = SYSDATE
              ,last_updated_by     = FND_GLOBAL.user_id
              ,last_update_login   = FND_GLOBAL.conc_login_id
              ,source_lang         = USERENV('LANG')
              ,program_name        = DECODE( p_program_name, NULL, program_name, FND_API.g_miss_char, NULL, p_program_name)
              ,program_description = DECODE( p_program_description, NULL, program_description, FND_API.g_miss_char, NULL, p_program_description)
              ,qsnr_title         = DECODE( p_qsnr_title, NULL, qsnr_title , FND_API.g_miss_char, NULL, p_qsnr_title )
              ,qsnr_header        = DECODE( p_qsnr_header, NULL, qsnr_header, FND_API.g_miss_char, NULL, p_qsnr_header)
              ,qsnr_footer        = DECODE( p_qsnr_footer, NULL,qsnr_footer, FND_API.g_miss_char, NULL, p_qsnr_footer)
   WHERE PROGRAM_ID = p_program_id
   AND USERENV('LANG') IN (language, source_lang);

Line: 450


END Update_Row;

Line: 466


PROCEDURE Delete_Row(
     p_program_id            NUMBER
    ,p_object_version_number NUMBER
    )
 IS

 BEGIN

UPDATE PV_PARTNER_PROGRAM_B
   SET

               program_id                = DECODE( p_program_id, NULL ,program_id, FND_API.g_miss_num,  NULL , p_program_id)
              ,enabled_flag              ='N'
              ,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_ID = p_program_id
   AND object_version_number = p_object_version_number;

Line: 496


   Update PV_PARTNER_PROGRAM_TL
   SET
               last_update_date    = SYSDATE
              ,last_updated_by     = FND_GLOBAL.user_id
              ,last_update_login   = FND_GLOBAL.conc_login_id
              ,source_lang         = USERENV('LANG')
              --,program_name        = DECODE( p_program_name, NULL, program_name, FND_API.g_miss_char, NULL, p_program_name)
              --,program_description = DECODE( p_program_description, NULL, program_description, FND_API.g_miss_char, NULL, p_program_description)
   WHERE PROGRAM_ID = p_program_id
   AND USERENV('LANG') IN (language, source_lang);

Line: 516


 END Delete_Row ;

Line: 580


          ,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_PARTNER_PROGRAM_B
        WHERE PROGRAM_ID =  px_program_id
        FOR UPDATE of PROGRAM_ID NOWAIT;

Line: 601


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

Line: 739


       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;

Line: 787


  INSERT /*+ append parallel(tt) */ INTO PV_PARTNER_PROGRAM_TL tt
  (
      PROGRAM_ID
     ,LAST_UPDATE_DATE
     ,LAST_UPDATED_BY
     ,CREATION_DATE
     ,CREATED_BY
     ,LAST_UPDATE_LOGIN
     ,LANGUAGE
     ,SOURCE_LANG
     ,PROGRAM_NAME
     ,PROGRAM_DESCRIPTION
  )
  SELECT /*+ parallel(v) parallel(t) use_nl(t)  */ v.*
  FROM
     (
         SELECT /*+ no_merge ordered parallel(b) */
         B.PROGRAM_ID
        ,B.LAST_UPDATE_DATE
        ,B.LAST_UPDATED_BY
        ,B.CREATION_DATE
        ,B.CREATED_BY
        ,B.LAST_UPDATE_LOGIN
        ,L.LANGUAGE_CODE
        ,B.SOURCE_LANG
        ,B.PROGRAM_NAME
        ,B.PROGRAM_DESCRIPTION
        FROM  PV_PARTNER_PROGRAM_TL B , FND_LANGUAGES L
        WHERE L.INSTALLED_FLAG IN ( 'I','B' ) AND B.LANGUAGE = USERENV ( 'LANG' )
     ) v
     , PV_PARTNER_PROGRAM_TL t
  WHERE t.PROGRAM_ID(+) = v.PROGRAM_ID
  AND t.language(+) = v.language_code
  AND t.PROGRAM_ID IS NULL ;

Line: 853


    UPDATE PV_PARTNER_PROGRAM_TL set
       PROGRAM_NAME        = NVL(p_program_name, program_name)
      ,PROGRAM_DESCRIPTION = NVL(p_program_description, program_description)
      ,SOURCE_LANG         = USERENV('LANG')
      ,LAST_UPDATE_DATE    = SYSDATE
      ,LAST_UPDATED_BY     = DECODE(p_owner, 'SEED', 1, 0)
      ,LAST_UPDATE_LOGIN   = 0
      ,qsnr_title          = NVL(p_qsnr_title, qsnr_title )
      ,qsnr_header         = NVL(p_qsnr_header,qsnr_header )
      ,qsnr_footer         = NVL(p_qsnr_footer,qsnr_footer )

      WHERE PROGRAM_ID = px_program_id
      AND USERENV('LANG') IN (language, source_lang);