APPS.IBE_DELIVERABLE_GRP SQL Statements

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

Line: 214

      || 'AND item_id NOT IN (SELECT item_id ' ||
      ' FROM ibe_dsp_tpl_ctg '
      || 'WHERE category_id = :ctg_id) ';

Line: 226

  sql_stmt := 'SELECT COUNT(*) ' || sql_cond;

Line: 328

    || 'SELECT item_id, access_name, item_name, deliverable_type_code, '

    --modified by G. Zhang 05/17/01 5:42PM
    || 'applicable_to_code, description, keyword, file_name, file_id, '

    || 'object_version_number '
    || 'BULK COLLECT INTO :id_tbl, :acc_tbl, :dsp_tbl, :type_tbl, '

    --modified by G. Zhang 05/17/01 5:42PM
    || ':appl_tbl, :desc_tbl, :key_tbl, :file_tbl, :file_id_tbl, :version_tbl '

    || 'FROM (SELECT * '
    || sql_cond
    || 'ORDER BY item_name ) '
    || 'WHERE ROWNUM <= :row_num '
    || '; END;';

Line: 707

  l_operation_type VARCHAR2(10) := 'INSERT';

Line: 758

  l_item_rec.last_update_date := NULL;

Line: 759

  l_item_rec.last_updated_by := NULL;

Line: 760

  l_item_rec.last_update_login := NULL;

Line: 790

    l_operation_type := 'UPDATE';

Line: 793

  IF (l_operation_type = 'INSERT') THEN
    l_item_rec.deliverable_type_code
      := TRIM(p_deliverable_rec.item_type);

Line: 859

	 p_operation => 'UPDATE',
	 p_access_name => l_item_rec.access_name,
	 p_deliverable_type_code => l_item_rec.deliverable_type_code,
	 p_applicable_to_code => l_item_rec.applicable_to_code);

Line: 867

    JTF_AMV_ITEM_PUB.update_item(
      p_api_version       => g_amv_api_version,
      x_return_status     => l_return_status,
      x_msg_count         => x_msg_count,
      x_msg_data          => x_msg_data,
      p_item_rec          => l_item_rec
                                );

Line: 882

    JTF_AMV_ITEM_PUB.delete_itemkeyword(
      p_api_version		=> g_amv_api_version,
      x_return_status	=> l_return_status,
      x_msg_count		=> x_msg_count,
      x_msg_data		=> x_msg_data,
      p_item_id	=> p_deliverable_rec.deliverable_id,
      p_keyword_tab		=> NULL
                                       );

Line: 1153

  l_operation_type VARCHAR2(10) := 'INSERT';

Line: 1155

  l_delete_mapping VARCHAR2(1) := FND_API.g_false;

Line: 1193

    l_operation_type := 'UPDATE';

Line: 1230

    IF l_operation_type = 'INSERT' THEN

      -- Create an attachment for all-site and all-language if any
      IF TRIM(p_dlv_ath_rec.ath_file_name) IS NOT NULL THEN
        l_create_attachment := FND_API.g_true;

Line: 1244

        l_delete_mapping := FND_API.g_true;

Line: 1271

            l_delete_mapping := FND_API.g_true;

Line: 1278

          l_delete_mapping := FND_API.g_true;

Line: 1319

    IF l_delete_mapping = FND_API.g_true THEN
      -- Delete all-site and all-lang mapping for this deliverable
      IBE_PhysicalMap_GRP.delete_dlv_all_all(
        p_deliverable_id         => p_dlv_ath_rec.deliverable_id
                                            );

Line: 1583

PROCEDURE delete_deliverable (
                              p_api_version            IN   NUMBER,
                              p_init_msg_list          IN   VARCHAR2 := FND_API.g_false,
  p_commit                 IN   VARCHAR2  := FND_API.g_false,
  x_return_status          OUT NOCOPY  VARCHAR2,
  x_msg_count              OUT NOCOPY  NUMBER,
  x_msg_data               OUT NOCOPY  VARCHAR2,
  p_dlv_id_ver_tbl		IN OUT NOCOPY DLV_ID_VER_TBL_TYPE ) IS

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

Line: 1602

  SAVEPOINT delete_deliverable_grp;

Line: 1630

  SAVEPOINT delete_one_deliverable_grp;

Line: 1639

  IBE_DSP_SECTION_GRP.update_deliverable_to_null(
    p_api_version			=> p_api_version,
    p_deliverable_id =>	p_dlv_id_ver_tbl(l_index).deliverable_id,
    x_return_status		=> l_return_status,
    x_msg_count			=> x_msg_count,
    x_msg_data			=> x_msg_data
                                                );

Line: 1654

  IBE_DisplayContext_GRP.delete_deliverable(
    p_dlv_id_ver_tbl(l_index).deliverable_id
                                           );

Line: 1659

  IBE_TplCategory_GRP.delete_deliverable(
    p_dlv_id_ver_tbl(l_index).deliverable_id
                                        );

Line: 1664

  IBE_LogicalContent_GRP.delete_deliverable(
    p_dlv_id_ver_tbl(l_index).deliverable_id
                                           );

Line: 1669

  IBE_PhysicalMap_GRP.delete_deliverable(
    p_dlv_id_ver_tbl(l_index).deliverable_id
                                        );

Line: 1674

  JTF_AMV_ITEM_PUB.delete_item(
    p_api_version		=> g_amv_api_version,
    x_return_status	=> l_return_status,
    x_msg_count		=> x_msg_count,
    x_msg_data		=> x_msg_data,
    p_item_id			=> p_dlv_id_ver_tbl(l_index).deliverable_id
                              );

Line: 1694

     ROLLBACK TO delete_one_deliverable_grp;

Line: 1702

     ROLLBACK TO delete_one_deliverable_grp;

Line: 1708

     ROLLBACK TO delete_one_deliverable_grp;

Line: 1738

     ROLLBACK TO delete_deliverable_grp;

Line: 1747

     ROLLBACK TO delete_deliverable_grp;

Line: 1756

     ROLLBACK TO delete_deliverable_grp;

Line: 1769

 END delete_deliverable;