APPS.IBE_ONECLK_PVT SQL Statements

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

Line: 20

 x_last_update_date DATE;

Line: 49

 SELECT  h.quote_header_id,
  h.total_quote_price,
  h.party_id,
  h.cust_account_id,
  h.org_id
 FROM aso_quote_headers h
 WHERE
  trunc(h.quote_expiration_date) >= trunc(sysdate) and
  h.quote_source_code = 'IStore Oneclick' and
  h.order_id is null and
  h.last_update_date < c_earliest_time;

Line: 62

 SELECT  ord_oneclick_id
 FROM IBE_ORD_ONECLICK
 WHERE
  party_id = c_party_id and
  cust_account_id = c_acct_id;

Line: 69

    select status_code
    from aso_quote_headers_all a,   aso_quote_statuses_vl b
    where quote_header_id = quote_hdr_id
    and a.quote_status_id = b.quote_status_id;

Line: 109

 FND_FILE.PUT_LINE(FND_FILE.LOG,'Looking for quotes last updated before: ' || to_char(l_earliest_time,'DD-MON-YYYY:HH:MI:SS'));

Line: 179

         ,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_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
       */
       P_submit_Control_Rec => l_control_rec,
       -- 9/17/02: added to not validate the user
       p_validate_user      => FND_API.G_FALSE,

       x_order_header_rec   => l_order_header_rec,
       x_Return_Status      => x_return_status ,
       x_Msg_Count          => x_msg_count ,
       x_Msg_Data           => x_msg_data,
       x_hold_flag          => l_hold_flag  );