APPS.PRP_IBC_MIGRATION_INT SQL Statements

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

Line: 33

      p_last_updated_by                => FND_GLOBAL.user_id,
      p_last_update_date               => sysdate,
      p_last_update_login              => FND_GLOBAL.login_id
      );

Line: 128

            ,p_update                   => FND_API.g_true
            ,p_commit                   => FND_API.g_false
            ,p_api_version_number       => IBC_CITEM_ADMIN_GRP.G_API_VERSION_DEFAULT
            ,p_init_msg_list            => FND_API.g_true
            ,px_content_item_id         => l_content_item_id
            ,px_object_version_number   => l_object_version_number
            ,px_citem_ver_id            => l_citem_ver_id
            ,x_return_status            => l_return_status
            ,x_msg_count                => l_msg_count
            ,x_msg_data                 => l_msg_data
          );

Line: 182

     Update PRP_COMPONENT_STYLES_B PCS set pcs.content_item_id = l_content_item_id, pcs.content_node_type='HIDDEN'
     Where  pcs.component_style_id = p_component_style_id;

Line: 214

   Update PRP_COMP_STYLE_CTNTVERS PCC set pcc.citem_version_id = l_citem_ver_id
   Where pcc.comp_style_ctntver_id = p_comp_style_ctntver_id;

Line: 273

 * Procedure Name: UPDATE_CONTENT                               *
 *                                                              *
 *                                                              *
 ****************************************************************/

PROCEDURE UPDATE_CONTENT(
                         p_api_version                 IN  NUMBER,
                         p_init_msg_list               IN  VARCHAR2 := FND_API.G_FALSE,
                         p_file_id                     IN  NUMBER,
                         p_component_style_id          IN  NUMBER,
                         p_comp_style_ctntver_id       IN  NUMBER,
                         p_content_item_id             IN  NUMBER,
                         p_citem_version_id            IN  NUMBER,
                         p_language                    IN  VARCHAR2,
                         px_object_version_number      IN  OUT NOCOPY NUMBER,
                         x_return_status               OUT NOCOPY VARCHAR2,
                         x_msg_count                   OUT NOCOPY NUMBER,
                         x_msg_data                    OUT NOCOPY VARCHAR2) IS

l_content_item_id           NUMBER;

Line: 298

l_api_name                  CONSTANT VARCHAR2(30) := 'UPDATE_CONTENT';

Line: 300

l_module_name               CONSTANT VARCHAR2(256) := 'PLSQL.PRP.PRP_IBC_MIGRATION_INT.UPDATE_CONTENT';

Line: 321

      SAVEPOINT svpt_update_content;

Line: 364

            ,p_update                   => FND_API.g_true
            ,p_commit                   => FND_API.g_false
            ,p_api_version_number       => IBC_CITEM_ADMIN_GRP.G_API_VERSION_DEFAULT
            ,p_init_msg_list            => FND_API.g_true
            ,px_content_item_id         => l_content_item_id
            ,px_object_version_number   => l_object_version_number
            ,px_citem_ver_id            => l_citem_ver_id
            ,x_return_status            => l_return_status
            ,x_msg_count                => l_msg_count
            ,x_msg_data                 => l_msg_data
          );

Line: 379

        FND_MESSAGE.Set_Token('PROC', 'PRP_IBC_MIGRATION_INT.UPDATE_CONTENT');

Line: 406

        FND_MESSAGE.Set_Token('PROC','PRP_IBC_MIGRATION_INT.UPDATE_CONTENT');

Line: 416

   Update PRP_COMP_STYLE_CTNTVERS PCC set pcc.citem_version_id = l_citem_ver_id
   Where pcc.comp_style_ctntver_id = p_comp_style_ctntver_id;

Line: 450

     Rollback TO svpt_update_content;

Line: 455

     Rollback TO svpt_update_content;

Line: 460

      Rollback TO svpt_update_content;

Line: 465

END UPDATE_CONTENT;

Line: 555

            ,p_update                   => FND_API.g_true
            ,p_commit                   => FND_API.g_false
            ,p_api_version_number       => IBC_CITEM_ADMIN_GRP.G_API_VERSION_DEFAULT
            ,p_init_msg_list            => FND_API.g_true
            ,px_content_item_id         => l_content_item_id
            ,px_object_version_number   => l_object_version_number
            ,px_citem_ver_id            => l_citem_ver_id
            ,x_return_status            => l_return_status
            ,x_msg_count                => l_msg_count
            ,x_msg_data                 => l_msg_data
          );

Line: 609

     Update PRP_PROPOSALS PP set pp.content_item_id = l_content_item_id
     Where  pp.proposal_id = p_proposal_id;

Line: 641

   Update PRP_PROPOSAL_CTNTVERS PPS set pps.citem_version_id = l_citem_ver_id
   Where pps.proposal_ctntver_id = p_proposal_ctntver_id;