APPS.OE_BULK_WF_UTIL SQL Statements

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

Line: 309

SELECT process_name
  FROM OE_WORKFLOW_ASSIGNMENTS
 WHERE order_type_id = p_type_id
   AND line_type_id IS NULL
   -- 11i10 - only fulfillment orders supported in HVOP so
   -- select fulfillment flow
   AND nvl(wf_item_type,'OEOH') = 'OEOH'
   AND sysdate >= start_date_active
   AND sysdate <= nvl(end_date_active, sysdate);

Line: 381

    SELECT process_name
          ,item_type_code
    FROM OE_WORKFLOW_ASSIGNMENTS
    WHERE order_type_id = p_order_type_id
      AND line_type_id = p_line_rec.line_type_id(p_line_index)
      AND nvl(item_type_code,l_wf_item_type) = l_wf_item_type
      AND sysdate >= start_date_active
      AND sysdate <= nvl(end_date_active, sysdate);

Line: 555

   SELECT user_name
   INTO   l_owner_role
   FROM   FND_USER
   WHERE  USER_ID = FND_GLOBAL.USER_ID;

Line: 770

            WF_Api_l_item_keys.DELETE;

Line: 771

            WF_Api_l_user_keys.DELETE;

Line: 772

            WF_Api_l_owner_roles.DELETE;

Line: 793

        l_process_name_tbl.DELETE;

Line: 794

        l_item_keys.DELETE;

Line: 795

        l_user_keys.DELETE;

Line: 796

        l_itemkeys_4TAttr.DELETE;

Line: 797

        l_aname2.DELETE;

Line: 798

        l_avaluetext.DELETE;

Line: 799

        l_itemkeys_4NAttr.DELETE;

Line: 800

        l_aname.DELETE;

Line: 801

        l_avalue.DELETE;