DBA Data[Home] [Help]

APPS.IBE_M_IBC_INT_PVT SQL Statements

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

Line: 13

    SELECT b.description
	 FROM ibc_citem_versions_tl a, fnd_languages_vl b
     WHERE a.language = b.language_code
	  AND a.source_lang <> c_base_lang
	  AND a.source_lang = a.language
	  AND a.citem_version_id = c_citem_version_id;
Line: 39

    SELECT b.description
	 FROM ibc_citem_versions_tl a, fnd_languages_vl b
     WHERE a.language = b.language_code
	  AND a.source_lang = a.language
	  AND a.citem_version_id = c_citem_version_id;
Line: 64

    SELECT 1
	 FROM ibc_citem_version_labels
     WHERE citem_version_id = c_item_version_id
	  AND content_item_id = c_citem_id
	  AND label_code = 'IBE';
Line: 85

    SELECT b.version_number
	 FROM ibc_citem_version_labels a, ibc_citem_versions_b b
     WHERE a.citem_version_id = b.citem_version_id
	  AND a.content_item_id = c_citem_id
	  AND a.label_code = 'IBE';
Line: 107

    SELECT decode(b.msite_id, 1, 'All', b.msite_name)
	 FROM ibe_dsp_lgl_phys_map a, ibe_msites_vl b
     WHERE a.msite_id = b.msite_id and b.site_type = 'I'
	  AND a.content_item_key = c_item_key
 	  AND a.attachment_id = -1;
Line: 136

    SELECT MAX(a.version_number)
	 FROM ibc_citem_versions_b a
     WHERE a.citem_version_status = 'APPROVED'
	  AND a.content_item_id = c_citem_id;
Line: 156

    SELECT MAX(a.citem_version_id)
	 FROM ibc_citem_versions_b a
     WHERE a.citem_version_status = 'APPROVED'
	  AND a.content_item_id = c_citem_id;
Line: 175

PROCEDURE Batch_Update_Labels(
  p_api_version IN NUMBER,
  p_init_msg_list IN VARCHAR2,
  p_commit IN VARCHAR2,
  p_content_item_id_tbl IN JTF_NUMBER_TABLE,
  p_version_number_tbl IN JTF_NUMBER_TABLE,
  x_return_status OUT NOCOPY VARCHAR2,
  x_msg_count OUT NOCOPY NUMBER,
  x_msg_data OUT NOCOPY VARCHAR2)
IS
  l_api_version NUMBER := 1.0;
Line: 186

  l_api_name VARCHAR2(50) := 'Batch_Update_Labels';
Line: 195

  SAVEPOINT BATCH_UPDATE_LABELS_SAVE;
Line: 198

  IBE_UTIL.debug('IBE_M_IBC_INT_PVT.Batch_Update_Labels Starts +');
Line: 275

  IBE_UTIL.debug('IBE_M_IBC_INT_PVT.Batch_Update_Labels Ends +');
Line: 279

    ROLLBACK TO BATCH_UPDATE_LABELS_SAVE;
Line: 285

    ROLLBACK TO BATCH_UPDATE_LABELS_SAVE;
Line: 291

    ROLLBACK TO BATCH_UPDATE_LABELS_SAVE;
Line: 309

END Batch_Update_Labels;
Line: 311

PROCEDURE Update_Label_Association(
  p_api_version IN NUMBER,
  p_init_msg_list IN VARCHAR2,
  p_commit IN VARCHAR2,
  p_old_content_item_id IN NUMBER,
  p_old_version_number IN NUMBER,
  p_new_content_item_id IN NUMBER,
  p_new_version_number IN NUMBER,
  p_media_object_id IN NUMBER,
  p_association_type_code IN VARCHAR2,
  x_return_status OUT NOCOPY VARCHAR2,
  x_msg_count OUT NOCOPY NUMBER,
  x_msg_data OUT NOCOPY VARCHAR2)
IS
  l_api_version NUMBER := 1.0;
Line: 326

  l_api_name VARCHAR2(50) := 'Update_Label_Association';
Line: 349

    SELECT citem_version_id
	 FROM ibc_citem_versions_b
     WHERE content_item_id = c_content_item_id
	  AND version_number = c_version_number;
Line: 358

    SELECT ASSOCIATED_OBJECT_VAL1
	 FROM ibc_associations
     WHERE content_item_id = c_content_item_id
	  AND association_type_code = c_label_code;
Line: 365

    SELECT object_version_number
	 FROM IBC_CITEM_VERSION_LABELS
     WHERE content_item_id = c_content_item_id
	  AND label_code = c_label_code;
Line: 372

    SELECT 1
	 FROM IBC_ASSOCIATIONS
     WHERE content_item_id = c_content_item_id
	  AND association_type_code = c_association_type_code;
Line: 379

    SELECT 1
	 FROM IBC_ASSOCIATIONS
     WHERE content_item_id = c_content_item_id
	  AND association_type_code = c_association_type_code
	  AND associated_object_val1 = c_assoc_object;
Line: 387

  SAVEPOINT UPDATE_LABEL_ASSOCIATION_SAVE;
Line: 390

  IBE_UTIL.debug('IBE_M_IBC_INT_PVT.Update_Label_Association starts +');
Line: 591

    l_cv_label_rec.last_updated_by := FND_GLOBAL.user_id;
Line: 592

    l_cv_label_rec.last_update_date := SYSDATE;
Line: 594

    l_cv_label_rec.last_update_login := FND_GLOBAL.login_id;
Line: 596

    IBE_UTIL.debug('Before calling Ibc_Cv_Label_Grp.Update_CV_Label');
Line: 600

    IBE_UTIL.debug('l_cv_label_rec.last_updated_by = '||l_cv_label_rec.last_updated_by);
Line: 604

    Ibc_Cv_Label_Grp.Update_CV_Label(
      p_api_version_number => 1.0,
      P_Init_Msg_List => FND_API.G_FALSE,
      P_Commit => FND_API.G_FALSE,
      P_CV_Label_Rec => l_cv_label_rec,
      x_CV_Label_Rec => r_cv_label_rec,
      x_return_status => x_return_status,
      x_msg_count => x_msg_count,
      x_msg_data => x_msg_data);
Line: 614

    IBE_UTIL.debug('After calling Ibc_Cv_Label_Grp.Update_CV_Label:'||x_return_status);
Line: 618

      IBE_UTIL.debug('Error in Ibc_Cv_Label_Grp.Update_CV_Label');
Line: 627

      IBE_UTIL.debug('Error in Ibc_Cv_Label_Grp.Update_CV_Label');
Line: 661

	   IBE_UTIL.debug('Calling Ibc_Cv_Label_Grp.Delete_CV_Label');
Line: 665

        Ibc_Cv_Label_Grp.Delete_CV_Label(
	     P_Api_Version_Number => 1.0,
	     P_Init_Msg_List => FND_API.G_FALSE,
	     P_Commit => FND_API.G_FALSE,
	     p_label_code => l_label_code,
	     p_content_item_id => l_old_item_id,
          x_return_status => x_return_status,
          x_msg_count => x_msg_count,
          x_msg_data => x_msg_data);
Line: 675

	   IBE_UTIL.debug('After calling Ibc_Cv_Label_Grp.Delete_CV_Label:'||x_return_status);
Line: 679

          IBE_UTIL.debug('Error in Ibc_Cv_Label_Grp.Delete_CV_Label');
Line: 688

          IBE_UTIL.debug('Error in Ibc_Cv_Label_Grp.Delete_CV_Label');
Line: 716

    l_cv_label_rec.last_updated_by := FND_GLOBAL.user_id;
Line: 717

    l_cv_label_rec.last_update_date := SYSDATE;
Line: 719

    l_cv_label_rec.last_update_login := FND_GLOBAL.login_id;
Line: 722

      IBE_UTIL.debug('Calling Ibc_Cv_Label_Grp.Update_CV_Label');
Line: 726

	 IBE_UTIL.debug('P_CV_Label_Rec.last_updated_by = '
	   ||l_cv_label_rec.last_updated_by);
Line: 728

	 IBE_UTIL.debug('P_CV_Label_Rec.last_update_date = '
	   ||to_char(l_cv_label_rec.last_update_date,'MM-DD-RRRR HH24:MI:SS'));
Line: 732

	 IBE_UTIL.debug('P_CV_Label_Rec.last_update_login = '
	   ||l_cv_label_rec.last_update_login);
Line: 735

      Ibc_Cv_Label_Grp.Update_CV_Label(
        p_api_version_number => 1.0,
        P_Init_Msg_List => FND_API.G_FALSE,
        P_Commit => FND_API.G_FALSE,
        P_CV_Label_Rec => l_cv_label_rec,
        x_CV_Label_Rec => r_cv_label_rec,
        x_return_status => x_return_status,
        x_msg_count => x_msg_count,
        x_msg_data => x_msg_data);
Line: 745

      IBE_UTIL.debug('After calling Ibc_Cv_Label_Grp.Update_CV_Label:'||x_return_status);
Line: 752

      IBE_UTIL.debug('Calling Ibc_Cv_Label_Grp.Update_CV_Label');
Line: 756

	 IBE_UTIL.debug('P_CV_Label_Rec.last_updated_by = '
	   ||l_cv_label_rec.last_updated_by);
Line: 758

	 IBE_UTIL.debug('P_CV_Label_Rec.last_update_date = '
	   ||to_char(l_cv_label_rec.last_update_date,'MM-DD-RRRR HH24:MI:SS'));
Line: 762

	 IBE_UTIL.debug('P_CV_Label_Rec.last_update_login = '
	   ||l_cv_label_rec.last_update_login);
Line: 784

      IBE_UTIL.debug('Error in Ibc_Cv_Label_Grp.Update_CV_Label/Create_CV_Label');
Line: 793

      IBE_UTIL.debug('Error in Ibc_Cv_Label_Grp.Update_CV_Label/Create_CV_Label');
Line: 812

  IBE_UTIL.debug('IBE_M_IBC_INT_PVT.Update_Label_Association ends +');
Line: 816

    ROLLBACK TO UPDATE_LABEL_ASSOCIATION_SAVE;
Line: 822

    ROLLBACK TO UPDATE_LABEL_ASSOCIATION_SAVE;
Line: 828

    ROLLBACK TO UPDATE_LABEL_ASSOCIATION_SAVE;
Line: 846

END Update_Label_Association;
Line: 848

PROCEDURE Delete_Label_Association(
  p_api_version IN NUMBER,
  p_init_msg_list IN VARCHAR2,
  p_commit IN VARCHAR2,
  p_content_item_id IN NUMBER,
  p_version_number IN NUMBER,
  p_media_object_id IN NUMBER,
  p_association_type_code IN VARCHAR2,
  x_return_status OUT NOCOPY VARCHAR2,
  x_msg_count OUT NOCOPY NUMBER,
  x_msg_data OUT NOCOPY VARCHAR2)
IS
  l_api_version NUMBER := 1.0;
Line: 861

  l_api_name VARCHAR2(50) := 'Delete_Label_Association';
Line: 872

    SELECT 1
	 FROM IBC_ASSOCIATIONS
     WHERE content_item_id = c_content_item_id
	  AND association_type_code = c_association_type_code;
Line: 879

  SAVEPOINT DELETE_LABEL_ASSOCIATION_SAVE;
Line: 882

  IBE_UTIL.debug('IBE_M_IBC_INT_PVT.Delete_Label_Association Starts +');
Line: 906

  IBE_UTIL.debug('Calling IBC_CITEM_ADMIN_GRP.delete_association starts');
Line: 911

  IBC_CITEM_ADMIN_GRP.delete_association(
    p_content_item_id => l_content_item_id,
    p_association_type_code => l_association_type_code,
    p_associated_object_val1 => TO_CHAR(p_media_object_id),
    p_commit => FND_API.g_false,
    p_api_version_number => 1.0,
    p_init_msg_list => FND_API.g_false,
    x_return_status => x_return_status,
    x_msg_count => x_msg_count,
    x_msg_data => x_msg_data);
Line: 922

  IBE_UTIL.debug('Calling IBC_CITEM_ADMIN_GRP.delete_association ends:'||x_return_status);
Line: 926

    IBE_UTIL.debug('Error in IBC_CITEM_ADMIN_GRP.delete_association');
Line: 935

    IBE_UTIL.debug('Error in IBC_CITEM_ADMIN_GRP.delete_association');
Line: 961

    IBE_UTIL.debug('Calling Ibc_Cv_Label_Grp.Delete_CV_Label');
Line: 965

    Ibc_Cv_Label_Grp.Delete_CV_Label(
      P_Api_Version_Number => 1.0,
      P_Init_Msg_List => FND_API.G_FALSE,
      P_Commit => FND_API.G_FALSE,
      p_label_code => l_label_code,
      p_content_item_id => l_content_item_id,
      x_return_status => x_return_status,
      x_msg_count => x_msg_count,
      x_msg_data => x_msg_data);
Line: 975

    IBE_UTIL.debug('After calling Ibc_Cv_Label_Grp.Delete_CV_Label:'||x_return_status);
Line: 979

      IBE_UTIL.debug('Error in Ibc_Cv_Label_Grp.Delete_CV_Label');
Line: 988

      IBE_UTIL.debug('Error in Ibc_Cv_Label_Grp.Delete_CV_Label');
Line: 1004

  IBE_UTIL.debug('IBE_M_IBC_INT_PVT.Delete_Label_Association ends +');
Line: 1011

    ROLLBACK TO DELETE_LABEL_ASSOCIATION_SAVE;
Line: 1017

    ROLLBACK TO DELETE_LABEL_ASSOCIATION_SAVE;
Line: 1023

    ROLLBACK TO DELETE_LABEL_ASSOCIATION_SAVE;
Line: 1041

END Delete_Label_Association;
Line: 1058

    SELECT item_name, access_name
      FROM JTF_AMV_ITEMS_VL
     WHERE item_id = c_media_obj_id;