DBA Data[Home] [Help]

APPS.CSE_PROJ_ITEM_INST_PKG SQL Statements

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

Line: 69

PROCEDURE Update_Ib_Repository(
   P_Proj_Item_Inst_Attr_Rec   IN  Proj_Item_Inst_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_INST_PKG';
Line: 131

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

   Update_Ib_Exp                   EXCEPTION;
Line: 244

     RAISE Update_Ib_Exp;
Line: 254

      RAISE Update_Ib_Exp;
Line: 264

      RAISE Update_Ib_Exp;
Line: 292

      RAISE Update_Ib_Exp;
Line: 302

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

       l_Instance_Rec := CSE_UTIL_PKG.Init_Instance_Update_Rec;
Line: 334

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

       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: 367

     RAISE Update_Ib_Exp;
Line: 428

     RAISE Update_Ib_Exp;
Line: 434

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

       l_Instance_Rec  := CSE_UTIL_PKG.Init_Instance_Update_Rec;
Line: 443

       l_Party_tbl.delete;
Line: 459

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

       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: 491

     RAISE Update_Ib_Exp;
Line: 509

   RAISE Update_Ib_Exp;
Line: 520

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

    l_Instance_Rec := CSE_UTIL_PKG.Init_Instance_Update_Rec;
Line: 559

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

       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: 593

     RAISE Update_Ib_Exp;
Line: 691

    RAISE Update_Ib_Exp;
Line: 710

   CSE_DEBUG_PUB.ADD('Before calling csi_transactions_pvt.update_transactions');
Line: 712

     csi_transactions_pvt.update_transactions(
        P_api_version      => l_api_version,
        P_Init_Msg_List    => l_Init_Msg_List,
        P_Commit           => l_Commit,
        p_validation_level => l_validation_level,
        P_transaction_rec  => l_upd_txn_rec,
        X_Return_Status    => l_Return_Status,
        X_Msg_Count        => l_Msg_Count,
        X_Msg_Data         => l_Msg_Data);
Line: 723

     CSE_DEBUG_PUB.ADD('after calling csi_transactions_pvt.update_transactions');
Line: 734

    RAISE Update_Ib_Exp;
Line: 747

 WHEN Update_Ib_Exp THEN
  X_Return_Status := l_Return_Status;
Line: 756

 END Update_Ib_Repository;
Line: 757

PROCEDURE Update_eib_instances(
   P_proj_item_inst_Attr_tbl  IN  proj_item_inst_Attr_tbl_Type,
   X_Return_Status        OUT NOCOPY VARCHAR2,
   X_Error_Message        OUT NOCOPY VARCHAR2) IS

BEGIN
 IF NOT p_proj_item_inst_attr_tbl.COUNT = 0 THEN

 FOR i IN p_proj_item_inst_attr_tbl.FIRST .. p_proj_item_inst_attr_tbl.LAST
 LOOP
   IF p_proj_item_inst_attr_tbl.EXISTS(i) THEN
      update_ib_repository( p_proj_item_inst_attr_tbl(i),
                            x_return_status,
                            x_error_message);
Line: 778

  fnd_message.set_token('ERR_MSG','CSE_PROJ_ITEM_INST_PKG.UPDATE_EIB_INSTANCES'||'='|| SQLERRM);
Line: 782

END update_eib_instances;