APPS.IBE_QUOTE_CHECKOUT_PVT SQL Statements

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

Line: 48

    select trxn_extension_id
    from aso_payments
    where quote_header_id = c_quote_header_id and quote_line_id is null;

Line: 55

  select  total_quote_price, currency_code, party_id, resource_id, quote_source_code, cust_account_id
    from ibe_quote_headers_v
    where quote_header_id = c_quote_header_id;

Line: 61

    select object_id
    from hz_relationships
    where party_id = c_party_id and directional_flag='F'
    and relationship_code in ('EMPLOYEE_OF','CONTACT_OF') and rownum <2;

Line: 337

     IBE_Util.Debug('Updated Submit_Control_Rec.Book_Flag=' || px_submit_control_rec.book_flag);

Line: 351

  ,p_last_update_date         in  DATE     := FND_API.G_MISS_DATE

  ,p_sharee_party_Id          IN  NUMBER   := FND_API.G_MISS_NUM
  ,p_sharee_cust_account_id   IN  NUMBER   := FND_API.G_MISS_NUM
  ,p_sharee_number	      IN  NUMBER   := FND_API.G_MISS_NUM

  ,p_submit_Control_Rec       IN  ASO_QUOTE_PUB.Submit_Control_Rec_Type
				           := ASO_QUOTE_PUB.G_MISS_Submit_Control_Rec

  ,p_customer_comments        IN  VARCHAR2 := FND_API.G_MISS_CHAR
  ,p_reason_code              IN  VARCHAR2 := FND_API.G_MISS_CHAR
  ,p_salesrep_email_id        IN  VARCHAR2 := FND_API.G_MISS_CHAR

  -- 9/17/02: added to control calling validate_user_update
  ,p_validate_user            IN  VARCHAR2 := FND_API.G_TRUE
  ,p_minisite_id	      IN  NUMBER   := FND_API.G_MISS_NUM

  ,x_order_header_rec         OUT NOCOPY ASO_QUOTE_PUB.Order_Header_Rec_Type
     --Mannamra: Added for bug 4716044
  ,x_hold_flag                OUT NOCOPY VARCHAR2
  ,x_return_status            OUT NOCOPY VARCHAR2
  ,x_msg_count                OUT NOCOPY NUMBER
  ,x_msg_data                 OUT NOCOPY VARCHAR2
)
IS
   L_API_NAME                 CONSTANT VARCHAR2(30)	:= 'SUBMITQUOTE';

Line: 400

   l_last_update_date_tmp DATE;

Line: 406

   l_last_updated_by      NUMBER;

Line: 418

    select quote_source_code, party_id, last_updated_by
    from aso_quote_headers
    where quote_header_id = c_quote_header_id;

Line: 423

    select customer_id
    from fnd_user
    where user_id = c_user_id;

Line: 428

       SELECT authorized_flag
       FROM iby_trxn_extensions_v
       WHERE (trxn_extension_id = ci_extension_id);

Line: 434

    select trxn_extension_id
    FROM ASO_PAYMENTS
    WHERE quote_HEADER_ID = c_quote_header_id and QUOTE_LINE_ID is null;

Line: 475

       IBE_UTIL.DEBUG('Submit_Quote: before calling validate_user_update()');

Line: 478

    IBE_Quote_Misc_pvt.Validate_User_Update(
	   p_init_msg_list          => FND_API.G_TRUE
	  ,p_quote_header_id        => p_quote_Header_Id
	  ,p_quote_retrieval_number => p_sharee_number
	  ,p_validate_user	        => FND_API.G_TRUE
	  ,p_privilege_type_code    => 'A'
      ,p_save_type              => PLACE_ORDER
      ,p_last_update_date       => p_last_update_date
      ,x_return_status          => x_return_status
      ,x_msg_count              => x_msg_count
      ,x_msg_data               => x_msg_data
    );

Line: 498

       IBE_UTIL.debug('SUBmit_quote: after calling validate_user_update()');

Line: 520

        ,x_last_update_date         => l_last_update_date_tmp
        ,x_return_status            => x_return_status
        ,x_msg_count                => x_msg_count
        ,x_msg_data                 => x_msg_data);

Line: 538

      l_qte_header_rec.last_update_date := l_last_update_date_tmp;

Line: 579

                                     l_last_updated_by;

Line: 585

        IBE_Util.Debug('last updated by   = '||l_last_updated_by);

Line: 593

         open c_get_party_id(l_last_updated_by);

Line: 900

      p_delete_context  => 'IBE_SC_CART_ORDERED',
      P_minisite_id     => p_minisite_id        ,
      p_api_version     => p_api_version_number ,
      p_init_msg_list   => fnd_api.g_false      ,
      p_commit          => fnd_api.g_false      ,
      x_return_status   => x_return_status      ,
      x_msg_count       => x_msg_count          ,
      x_msg_data        => x_msg_data           );