APPS.OE_STANDARD_WF SQL Statements

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

Line: 149

   correctly before executing a function activity. The selector
   function will be run by the workflow engine in the SET_CTX
   mode before executing the activity.
----------------------------------------------------------- */

PROCEDURE OEOH_SELECTOR
(   p_itemtype in  varchar2
,   p_itemkey  in  varchar2
,   p_actid    in  number
,   p_funcmode in  varchar2
,   p_result   in out nocopy varchar2 /* file.sql.39 change */
)
IS
  l_user_id             NUMBER;

Line: 212

      SELECT org_id
	INTO l_org_id
        FROM oe_order_headers_all
       WHERE header_id = to_number (p_itemkey);

Line: 245

               SELECT org_id
     	         INTO l_org_id
               	 FROM oe_order_headers_all
            	WHERE header_id = to_number (p_itemkey);

Line: 267

      oe_debug_pub.add( ' Exiting OEOH_SELECTOR , RESULT = '||P_RESULT
||' ITEMTYPE = '||P_ITEMTYPE||' ITEMKEY = '||P_ITEMKEY,1);

Line: 273

   WF_CORE.Context('OE_STANDARD_WF', 'OEOH_SELECTOR',
                    p_itemtype, p_itemkey, p_actid, p_funcmode);

Line: 278

END OEOH_SELECTOR;

Line: 282

   correctly before executing a function activity. The selector
   function will be run by the workflow engine in the SET_CTX
   mode before executing the activity.
----------------------------------------------------------- */
PROCEDURE OEOL_SELECTOR
(   p_itemtype in  varchar2
,   p_itemkey  in  varchar2
,   p_actid    in  number
,   p_funcmode in  varchar2
,   p_result   in out nocopy varchar2 /* file.sql.39 change */
)
IS
  l_user_id             NUMBER;

Line: 313

       oe_debug_pub.add(  'IN OEOL_SELECTOR , FUNCMODE:' || P_FUNCMODE || ' ' || P_ITEMTYPE || ' ' || P_ITEMKEY , 1 ) ;

Line: 348

         SELECT org_id
           INTO l_org_id
           FROM oe_order_lines_all
          WHERE line_id = to_number (p_itemkey);

Line: 374

           SELECT org_id
             INTO l_org_id
             FROM oe_order_lines_all
            WHERE line_id = to_number (p_itemkey);

Line: 409

   WF_CORE.Context('OE_STANDARD_WF', 'OEOL_SELECTOR',
                    p_itemtype, p_itemkey, p_actid, p_funcmode);

Line: 414

END OEOL_SELECTOR;

Line: 419

   correctly before executing a function activity. The selector
   function will be run by the workflow engine in the SET_CTX
   mode before executing the activity.
----------------------------------------------------------- */

PROCEDURE OENH_SELECTOR
(   p_itemtype in  varchar2
,   p_itemkey  in  varchar2
,   p_actid    in  number
,   p_funcmode in  varchar2
,   p_result   in out nocopy varchar2 /* file.sql.39 change */
)
IS
  l_user_id             NUMBER;

Line: 474

          SELECT org_id
            INTO l_org_id
            FROM oe_order_headers_all
           WHERE header_id = to_number (p_itemkey);

Line: 479

          SELECT org_id
            INTO l_org_id
            FROM oe_blanket_headers_all
           WHERE header_id = to_number (p_itemkey);

Line: 518

                SELECT org_id
                  INTO l_org_id
                  FROM oe_order_headers_all
                 WHERE header_id = to_number (p_itemkey);

Line: 523

                SELECT org_id
                  INTO l_org_id
                  FROM oe_blanket_headers_all
                 WHERE header_id = to_number (p_itemkey);

Line: 554

      oe_debug_pub.add( ' Exiting OENH_SELECTOR , RESULT = '||P_RESULT
||' ITEMTYPE = '||P_ITEMTYPE||' ITEMKEY = '||P_ITEMKEY,1);

Line: 560

   WF_CORE.Context('OE_STANDARD_WF', 'OENH_SELECTOR',
                    p_itemtype, p_itemkey, p_actid, p_funcmode);

Line: 565

END OENH_SELECTOR;

Line: 571

   correctly before executing a function activity. The selector
   function will be run by the workflow engine in the SET_CTX
   mode before executing the activity.
----------------------------------------------------------- */

PROCEDURE OEBH_SELECTOR
(   p_itemtype in  varchar2
,   p_itemkey  in  varchar2
,   p_actid    in  number
,   p_funcmode in  varchar2
,   p_result   in out nocopy varchar2 /* file.sql.39 change */
)
IS
  l_user_id             NUMBER;

Line: 621

     SELECT org_id
       INTO l_org_id
       FROM oe_blanket_headers_all
      WHERE header_id = to_number (p_itemkey);

Line: 652

            SELECT org_id
              INTO l_org_id
               	   FROM oe_blanket_headers_all
            	WHERE header_id = to_number (p_itemkey);

Line: 677

      oe_debug_pub.add( ' Exiting OEBH_SELECTOR , RESULT = '||P_RESULT
||' ITEMTYPE = '||P_ITEMTYPE||' ITEMKEY = '||P_ITEMKEY,1);

Line: 683

   WF_CORE.Context('OE_STANDARD_WF', 'OEBH_SELECTOR',
                    p_itemtype, p_itemkey, p_actid, p_funcmode);

Line: 688

END OEBH_SELECTOR;

Line: 712

	SELECT source_type_code
     INTO l_source_type
     FROM oe_order_lines_all
     WHERE line_id = to_number(p_itemkey);

Line: 831

   SELECT wfa.display_name
     INTO l_activity_name
     FROM wf_activities_vl wfa, wf_process_activities wpa
    WHERE wpa.instance_id = p_actid
      AND wpa.activity_item_type = p_itemtype
      AND wfa.item_type = p_itemtype
      AND wfa.name = wpa.activity_name
      AND (wfa.end_date is null OR wfa.end_date >= sysdate)
      AND rownum = 1;

Line: 859

   PROCEDURE oeame_selector (
      p_itemtype   IN              VARCHAR2,
      p_itemkey    IN              VARCHAR2,
      p_actid      IN              NUMBER,
      p_funcmode   IN              VARCHAR2,
      p_result     IN OUT NOCOPY   VARCHAR2           /* file.sql.39 change */
   )
   IS
      l_user_id                    NUMBER;

Line: 898

         SELECT TO_NUMBER (parent_item_key), parent_item_type
           INTO l_header_id, l_parent_type
           FROM wf_items
          WHERE item_type = p_itemtype AND item_key = p_itemkey;

Line: 938

                  SELECT org_id
                    INTO l_org_id
                    FROM oe_order_headers_all
                   WHERE header_id = l_header_id;

Line: 944

                  SELECT org_id
                    INTO l_org_id
                    FROM oe_blanket_headers_all
                   WHERE header_id = l_header_id;

Line: 971

               SELECT org_id
                 INTO l_org_id
                 FROM oe_order_headers_all
                WHERE header_id = l_header_id;

Line: 1010

                     SELECT org_id
                       INTO l_org_id
                       FROM oe_order_headers_all
                      WHERE header_id = l_header_id;

Line: 1016

                     SELECT org_id
                       INTO l_org_id                                --  AME ER
                       FROM oe_blanket_headers_all
                      WHERE header_id = l_header_id;

Line: 1065

                  SELECT org_id
                    INTO l_org_id
                    FROM oe_order_headers_all
                   WHERE header_id = l_header_id;

Line: 1094

         oe_debug_pub.ADD (   ' Exiting OEAME_SELECTOR , RESULT = '
                           || p_result
                           || ' ITEMTYPE = '
                           || p_itemtype
                           || ' ITEMKEY = '
                           || p_itemkey,
                           1
                          );

Line: 1109

                          'OEAME_SELECTOR',
                          p_itemtype,
                          p_itemkey,
                          p_actid,
                          p_funcmode
                         );

Line: 1116

   END oeame_selector;