APPS.CSE_PROJ_ITEM_UNINST_PKG SQL Statements

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

Line: 74

PROCEDURE Update_Ib_Repository(
   P_Proj_Item_Uninst_Attr_Rec   IN  Proj_Item_Uninst_Attr_Rec_Type,
   X_Return_Status          OUT NOCOPY VARCHAR2,
   X_Error_Message          OUT NOCOPY VARCHAR2) IS

   l_Api_Name      CONSTANT        VARCHAR2(30) :='CSE_PROJ_ITEM_UNINST_PKG';

Line: 136

   SELECT instance_status_id
   FROM csi_instance_statuses
   WHERE upper(name) ='EXPIRED';

Line: 140

   Update_Ib_Exp                   EXCEPTION;

Line: 227

     RAISE Update_Ib_Exp;

Line: 237

      RAISE Update_Ib_Exp;

Line: 248

      RAISE Update_Ib_Exp;

Line: 273

      RAISE Update_Ib_Exp;

Line: 282

          CSE_DEBUG_PUB.ADD('Initailizing instance Record for update of serialized item inst- step4');

Line: 285

       l_Instance_Rec  := CSE_UTIL_PKG.Init_Instance_Update_Rec;

Line: 311

          CSE_DEBUG_PUB.ADD('Before update of serialized item instanace');

Line: 314

       CSI_Item_Instance_Pub.Update_Item_Instance(
      		p_api_version	         =>	l_api_version,
      		p_commit 		 => l_Commit,
                p_validation_level       => l_Validation_Level,
      		p_init_msg_list          =>l_Init_Msg_List,
      		p_instance_rec           => l_Instance_Rec,
                p_ext_attrib_values_tbl  => l_ext_attrib_values_tbl,
                p_party_tbl              => l_party_tbl,
                p_account_tbl            => l_account_tbl,
                p_pricing_attrib_tbl     => l_pricing_attrib_tbl,
                p_org_assignments_tbl    => l_org_assignments_tbl,
      		p_txn_rec                =>l_Txn_Rec,
                p_asset_assignment_tbl   => l_asset_assignment_tbl,
		x_instance_id_lst	 =>	l_instance_id_lst,
      		x_return_status       	 =>	l_Return_Status,
      		x_msg_count            	 =>	l_Msg_Count,
      		x_msg_data             	 =>	l_Msg_Data );

Line: 341

           RAISE Update_Ib_Exp;

Line: 401

     RAISE Update_Ib_Exp;

Line: 408

         CSE_DEBUG_PUB.ADD('Initailizing instance Record for update of source qty - step5.3');

Line: 411

       l_Instance_Rec := CSE_UTIL_PKG.Init_Instance_Update_Rec;

Line: 417

       l_Party_tbl.delete;

Line: 433

          CSE_DEBUG_PUB.ADD('Before update of source instanace qty - step 5.3');

Line: 437

       CSI_Item_Instance_Pub.Update_Item_Instance(
      		p_api_version	         =>	l_api_version,
      		p_commit 		 => l_Commit,
                p_validation_level       => l_Validation_Level,
      		p_init_msg_list          =>	l_Init_Msg_List,
      		p_instance_rec           => l_Instance_Rec,
                p_ext_attrib_values_tbl  => l_ext_attrib_values_tbl,
                p_party_tbl              => l_party_tbl,
                p_account_tbl            => l_account_tbl,
                p_pricing_attrib_tbl     => l_pricing_attrib_tbl,
                p_org_assignments_tbl    => l_org_assignments_tbl,
      		p_txn_rec                =>	l_Txn_Rec,
                p_asset_assignment_tbl   => l_asset_assignment_tbl,
		x_instance_id_lst	 =>	l_instance_id_lst,
      		x_return_status       	 =>	l_Return_Status,
      		x_msg_count            	 =>	l_Msg_Count,
      		x_msg_data             	 =>	l_Msg_Data );

Line: 465

           RAISE Update_Ib_Exp;

Line: 481

   RAISE Update_Ib_Exp;

Line: 491

      CSE_DEBUG_PUB.ADD('Initailizing instance Record for update Of dest inst - step5.1');

Line: 494

    l_Instance_Rec := CSE_UTIL_PKG.Init_Instance_Update_Rec;

Line: 524

      CSE_DEBUG_PUB.ADD('Before update of destination instanace');

Line: 527

       CSI_Item_Instance_Pub.Update_Item_Instance(
      		p_api_version	         =>l_api_version,
      		p_commit 		 => l_Commit,
                p_validation_level       => l_Validation_Level,
      		p_init_msg_list          =>l_Init_Msg_List,
      		p_instance_rec           => l_Instance_Rec,
                p_ext_attrib_values_tbl  => l_ext_attrib_values_tbl,
                p_party_tbl              => l_party_tbl,
                p_account_tbl            => l_account_tbl,
                p_pricing_attrib_tbl     => l_pricing_attrib_tbl,
                p_org_assignments_tbl    => l_org_assignments_tbl,
      		p_txn_rec                =>l_Txn_Rec,
                p_asset_assignment_tbl   => l_asset_assignment_tbl,
	        x_instance_id_lst	 =>l_instance_id_lst,
      		x_return_status       	 =>l_Return_Status,
      		x_msg_count            	 =>l_Msg_Count,
      		x_msg_data             	 =>l_Msg_Data );

Line: 555

           RAISE Update_Ib_Exp;

Line: 567

   RAISE Update_Ib_Exp;

Line: 575

   RAISE Update_Ib_Exp;

Line: 585

 WHEN Update_Ib_Exp THEN
  X_Return_Status := l_Return_Status;

Line: 595

 END Update_Ib_Repository;

Line: 597

PROCEDURE Update_eib_instances(
   P_Proj_Item_Uninst_Attr_tbl IN  Proj_Item_Uninst_Attr_tbl_Type,
   X_Return_Status         OUT NOCOPY VARCHAR2,
   X_Error_Message         OUT NOCOPY VARCHAR2) IS
BEGIN
 IF NOT P_Proj_Item_Uninst_Attr_tbl.COUNT = 0 THEN
 FOR i IN P_Proj_Item_Uninst_Attr_tbl.FIRST .. P_Proj_Item_Uninst_Attr_tbl.LAST LOOP
 IF P_Proj_Item_Uninst_Attr_tbl.EXISTS(i) THEN
 update_ib_repository( p_proj_item_uninst_attr_tbl(i),
                       x_return_status,
                       x_error_message);

Line: 612

END update_eib_instances;