APPS.GML_BATCH_WORKFLOW_PKG SQL Statements

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

Line: 16

 | --  Insert_gml_batch_so_workflow()			      	           |
 |                                                                         |
 | HISTORY                                                                 |
 |              10-Oct-2003  nchekuri        Created                       |
 |                                                                         |
 +=========================================================================+ */


PROCEDURE init_wf (
      	p_session_id	IN   NUMBER
      ,	p_approver   	IN   NUMBER
      , p_so_header_id  IN   NUMBER
      ,	p_so_line_id	IN   NUMBER
      ,	p_batch_id	IN   NUMBER
      , p_batch_line_id IN   NUMBER
      , p_whse_code     IN   VARCHAR2
      , p_lot_no	IN   VARCHAR2 DEFAULT NULL
      ,	p_action_code   IN   VARCHAR2 )IS

   l_itemtype		VARCHAR2(240) :=  'GMLBTRES';

Line: 54

      SELECT user_name
        FROM fnd_user
       WHERE user_id = p_user_id;

Line: 59

      SELECT  ol.line_number, mtl.segment1,
              ot.transaction_type_code,
              oh.order_number
        FROM  oe_order_headers_all oh
             ,oe_order_lines_all ol
     	     ,oe_transaction_types_all ot
	     ,mtl_system_items mtl
       WHERE  ol.line_id = p_so_line_id
         and  ol.header_id = oh.header_id
	 and  oh.order_type_id = ot.transaction_type_id
         and  mtl.inventory_item_id = ol.inventory_item_id;

Line: 72

       SELECT batch_no,plant_code,
              plan_cmplt_date
         FROM gme_batch_header
         WHERE batch_id = p_batch_id;

Line: 286

   /* Insert the workflow/batch/so information into Gml_batch_so_workflow table for
      future reference. */

   GMI_RESERVATION_UTIL.PrintLn('In GML_BATCH_WORKFLOW_PKG. Init_wf Before Insert Record');

Line: 291

   INSERT_GML_BATCH_SO_WORKFLOW(
                         l_itemtype
                       , l_itemkey
		       , p_so_header_id
                       , p_so_line_id
                       , p_batch_id
		       , p_batch_line_id
		       , p_action_code);

Line: 300

   GMI_RESERVATION_UTIL.PrintLn('In GML_BATCH_WORKFLOW_PKG. Init_wf After  Insert Record');

Line: 341

PROCEDURE INSERT_GML_BATCH_SO_WORKFLOW(
             p_itemtype     IN 	VARCHAR2
           , p_itemkey      IN	VARCHAR2
           , p_so_header_id IN	NUMBER
           , p_so_line_id   IN	NUMBER
           , p_batch_id	    IN	NUMBER
           , p_batch_line_id IN	NUMBER
           , p_action_code   IN	VARCHAR2) IS

   l_wf_item_id  NUMBER;

Line: 354

  GMI_RESERVATION_UTIL.PrintLn('In GML_BATCH_WORKFLOW_PKG. INSERT_GML_BATCH_SO_WORKFLOW..... ');

Line: 356

  SELECT GML_BATCH_SO_WORKFLOW_S.nextval
    INTO l_wf_item_id FROM DUAL;

Line: 359

  GMI_RESERVATION_UTIL.PrintLn('In  GML_BATCH_WORKFLOW_PKG. INSERT_GML_BATCH_SO_WORKFLOW Before Insert ');

Line: 361

  INSERT INTO Gml_batch_so_workflow (
		  WF_ITEM_ID
   		, WF_ITEM_TYPE
   		, WF_ITEM_KEY
   		, SO_HEADER_ID
   		, SO_LINE_ID
   		, BATCH_ID
   		, BATCH_LINE_ID
   		, ACTION_CODE
   		, CREATION_DATE
   		, CREATED_BY
   		, LAST_UPDATE_DATE
   		, LAST_UPDATED_BY ) VALUES

                ( l_wf_item_id
		, p_itemtype
                , p_itemkey
                , p_so_header_id
                , p_so_line_id
                , p_batch_id
                , p_batch_line_id
                , p_action_code
                , sysdate
                , fnd_global.user_id
                , sysdate
                , fnd_global.user_id);

Line: 388

  GMI_RESERVATION_UTIL.PrintLn('In  GML_BATCH_WORKFLOW_PKG. INSERT_GML_BATCH_SO_WORKFLOW After Insert ');

Line: 393

    GMI_RESERVATION_UTIL.PrintLn('WARNING!  GML_BATCH_WORKFLOW_PKG. INSERT_GML_BATCH_SO_WORKFLOW OTHERS Exception ');

Line: 396

END INSERT_GML_BATCH_SO_WORKFLOW;