APPS.OE_BLANKET_WF SQL Statements

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

Line: 27

     select count(1)
     into l_count
     from wf_items
     where item_type  = OE_GLOBALS.G_WFI_NGO
     and item_key     = itemkey;

Line: 66

      OE_ORDER_WF_UTIL.Update_Quote_Blanket(p_item_type => OE_GLOBALS.G_WFI_BKT,
                                            p_item_key => itemkey,
                                            p_flow_status_code => 'DRAFT_SUBMITTED',
                                            p_draft_submitted_flag => 'Y',
                                            x_return_status => l_return_status);

Line: 117

       select count(1)
       into l_count
       from wf_items
       where item_type = OE_GLOBALS.G_WFI_NGO
       and item_key = itemkey;

Line: 176

      SELECT obhe.Start_Date_Active, obhe.End_Date_Active
      INTO   l_start_date, l_end_date
      FROM   oe_blanket_headers_all obha, oe_blanket_headers_ext obhe
      WHERE  obha.header_id = to_number(itemkey)
      AND    obha.order_number = obhe.order_number;

Line: 189

         oe_order_wf_util.update_flow_status_code(p_header_id => to_number(itemkey),
                                                  p_flow_status_code => 'AWAITING_START_DATE',
                                                  p_item_type => OE_GLOBALS.G_WFI_BKT,
                                                  x_return_status => l_return_status);

Line: 200

           oe_order_wf_util.update_flow_status_code(p_header_id => to_number(itemkey),
                                                  p_flow_status_code => 'ACTIVE',
                                                  p_item_type => OE_GLOBALS.G_WFI_BKT,
                                                  x_return_status => l_return_status);

Line: 232

         oe_order_wf_util.update_flow_status_code(p_header_id => to_number(itemkey),
                                                  p_flow_status_code => 'ACTIVE',
                                                  p_item_type => OE_GLOBALS.G_WFI_BKT,
                                                  x_return_status => l_return_status);

Line: 249

              oe_order_wf_util.update_flow_status_code(p_header_id => to_number(itemkey),
                                                  p_flow_status_code => 'ACTIVE',
                                                  p_item_type => OE_GLOBALS.G_WFI_BKT,
                                                  x_return_status => l_return_status);

Line: 269

              oe_order_wf_util.update_flow_status_code(p_header_id => to_number(itemkey),
                                                  p_flow_status_code => 'ACTIVE',
                                                  p_item_type => OE_GLOBALS.G_WFI_BKT,
                                                  x_return_status => l_return_status);

Line: 313

   SELECT item_key
   INTO l_header_id
   FROM wf_item_activity_statuses
   where notification_id = to_number(document_id);

Line: 323

  SELECT order_number
  INTO   l_blanket_number
  FROM   oe_blanket_headers_all
  WHERE  header_id = l_header_id;

Line: 361

   SELECT item_key
   INTO l_header_id
   FROM wf_item_activity_statuses
   where notification_id = to_number(document_id);

Line: 371

  SELECT obhe.end_date_active
  INTO   l_end_date
  FROM   oe_blanket_headers_all obha, oe_blanket_headers_ext obhe
  WHERE  obha.header_id = l_header_id
  AND    obha.order_number = obhe.order_number;

Line: 418

      OE_ORDER_WF_UTIL.Update_Quote_Blanket( p_item_type => OE_GLOBALS.G_WFI_BKT,
                                        p_item_key => itemkey,
                                        p_flow_status_code => 'EXPIRED',
                                        x_return_status => l_return_status);

Line: 430

      select bh.sold_to_org_id, bhx.end_date_active, bh.salesrep_id
      into   l_sold_to_org_id, l_end_date, l_salesrep_id
      from   oe_blanket_headers_all bh, oe_blanket_headers_ext bhx
      where  bh.header_id = to_number(itemkey)
      and    bh.order_number = bhx.order_number;

Line: 488

      OE_ORDER_WF_UTIL.Update_Quote_Blanket( p_item_type => OE_GLOBALS.G_WFI_BKT,
                                        p_item_key => itemkey,
                                        p_flow_status_code => 'TERMINATED',
                                        x_return_status => l_return_status);

Line: 548

      OE_ORDER_WF_UTIL.Update_Quote_Blanket( p_item_type => OE_GLOBALS.G_WFI_BKT,
                                        p_item_key => itemkey,
                                        p_flow_status_code => 'CLOSED',--bug#5589336
                                        p_open_flag => 'N',
                                        x_return_status => l_return_status);

Line: 592

    SELECT transaction_phase_code
    INTO   l_transaction_phase_code
    FROM   oe_blanket_headers_all
    WHERE  header_id = p_header_id;

Line: 605

      select wpa.activity_name
      into l_activity_name
      from wf_item_activity_statuses wias, wf_process_activities wpa
      where item_type = OE_GLOBALS.G_WFI_BKT
      and item_key = to_char(p_header_id)
      and activity_status = 'NOTIFIED'
      and wpa.activity_name in ('WAIT_FOR_START_DATE', 'BLANKET_NO_END_DATE', 'WAIT_FOR_EXPIRATION', 'WAIT_FOR_FINAL_EXPIRATION', 'BLANKET_SUBMIT_DRAFT_ELIGIBLE')
      and wias.process_activity = wpa.instance_id;

Line: 670

      select wpa.activity_name
      into l_activity_name
      from wf_item_activity_statuses wias, wf_process_activities wpa
      where item_type = OE_GLOBALS.G_WFI_BKT
      and item_key = to_char(p_header_id)
      and activity_status = 'NOTIFIED'
      and wpa.activity_name = 'BLANKET_SUBMIT_DRAFT_ELIGIBLE'
      and wias.process_activity = wpa.instance_id;

Line: 734

      select wpa.activity_name
      into l_activity_name
      from wf_item_activity_statuses wias, wf_process_activities wpa
      where item_type = OE_GLOBALS.G_WFI_BKT
      and item_key = to_char(p_header_id)
      and activity_status = 'NOTIFIED'
      and wpa.activity_name = 'CLOSE_BLANKET_ELIGIBLE'
      and wias.process_activity = wpa.instance_id;

Line: 811

      select wpa.activity_name
      into l_activity_name
      from wf_item_activity_statuses wias, wf_process_activities wpa
      where item_type = OE_GLOBALS.G_WFI_BKT
      and item_key = to_char(p_header_id)
      and activity_status = 'NOTIFIED'
      and wpa.activity_name in ('WAIT_FOR_START_DATE', 'BLANKET_NO_END_DATE', 'WAIT_FOR_EXPIRATION', 'WAIT_FOR_FINAL_EXPIRATION')
      and wias.process_activity = wpa.instance_id;

Line: 843

    SELECT USER_NAME
    INTO   l_terminator
    FROM FND_USER
    WHERE USER_ID = p_terminated_by;

Line: 854

    select bh.sold_to_org_id, bhx.end_date_active, bh.salesrep_id
    into   l_sold_to_org_id, l_end_date, l_salesrep_id
    from   oe_blanket_headers_all bh, oe_blanket_headers_ext bhx
    where  bh.header_id = p_header_id
    and    bh.order_number = bhx.order_number;

Line: 914

      select wpa.activity_name
      into l_activity_name
      from wf_item_activity_statuses wias, wf_process_activities wpa
      where item_type = OE_GLOBALS.G_WFI_BKT
      and item_key = to_char(p_header_id)
      and activity_status = 'NOTIFIED'
      and wpa.activity_name = 'CLOSE_BLANKET_ELIGIBLE'
      and wias.process_activity = wpa.instance_id;

Line: 975

      select bh.sold_to_org_id, bhx.end_date_active, bh.salesrep_id
      into   l_sold_to_org_id, l_end_date, l_salesrep_id
      from   oe_blanket_headers_all bh, oe_blanket_headers_ext bhx
      where  bh.header_id = p_header_id
      and    bh.order_number = bhx.order_number;

Line: 1068

      SELECT obhe.End_Date_Active
      INTO   l_end_date
      FROM   oe_blanket_headers_all obha, oe_blanket_headers_ext obhe
      WHERE  obha.header_id = to_number(itemkey)
      AND    obha.order_number = obhe.order_number;