APPS.OE_RMA_WF SQL Statements

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

Line: 172

    oe_debug_pub.add('Calling Update Row', 2);

Line: 173

        OE_Line_Util.Update_Row (l_x_line_rec);

Line: 278

  		SELECT DECODE(l.shippable_flag,NULL,m.shippable_item_flag ,
				    l.shippable_flag),
			  mtl_transactions_enabled_flag
		INTO l_shippable_flag,l_transactable_flag
  		FROM mtl_system_items m, oe_order_lines_all l
  		WHERE m.inventory_item_id = l.inventory_item_id
  		AND l.line_id = to_number(itemkey)
  		AND m.organization_id = l.ship_from_org_id;

Line: 375

          	    OE_Order_WF_Util.Update_Flow_Status_Code
                    (p_line_id               =>   to_number(itemkey),
                     p_flow_status_code      =>   'AWAITING_RETURN',
                     x_return_status         =>   l_return_status
                     );

Line: 391

                   UPDATE OE_ORDER_LINES_ALL
			    SET flow_status_code = 'AWAITING_RETURN'
			    WHERE line_id = to_number(itemkey);

Line: 453

 * Following procedures added to update flow status codes
 * 1. UPD_FLOW_STATUS_CODE_REJ
 * 2. UPD_FLOW_STATUS_CODE_MIX_REJ
 * Changes in one procedure may be needed in the other procedure also.
 * Because both procedures performs same action of updating flow status
 * code.
 */
PROCEDURE UPD_FLOW_STATUS_CODE_REJ(
 itemtype 	IN 	VARCHAR2
,itemkey 	IN 	VARCHAR2
,actid 	IN 	NUMBER
,funcmode 	IN 	VARCHAR2
,resultout 	IN OUT NOCOPY /* file.sql.39 change */ 	VARCHAR2
) AS
  l_return_status VARCHAR2(1);

Line: 471

  SELECT line_id,wias.item_type,wias.item_key
  FROM oe_order_lines l
      ,WF_ITEM_ACTIVITY_STATUSES WIAS
      ,WF_PROCESS_ACTIVITIES WPA
  WHERE l.header_id = To_Number(itemkey)
  AND l.line_category_code = 'RETURN'
  AND l.open_flag = 'Y'
  AND WIAS.item_type = 'OEOL'
  AND WIAS.item_key = To_Char(l.line_id)
  AND WPA.instance_id = WIAS.process_activity
  AND WIAS.activity_status = 'NOTIFIED'
  AND WPA.activity_name = 'APPROVE_WAIT_FOR_H';

Line: 488

  oe_order_wf_util.update_flow_status_code (
      P_HEADER_ID => To_Number(itemkey)
     ,P_FLOW_STATUS_CODE => 'REJECTED_PENDING_CANC'
     ,X_RETURN_STATUS => l_return_status);

Line: 495

      oe_debug_pub.add('Update flow status code: '||L_RETURN_STATUS
                       ||' - '||itemtype||'/'||itemkey,1);

Line: 506

    OE_Order_WF_Util.Update_Flow_Status_Code (
        p_line_id => lines.line_id
       ,p_flow_status_code => 'REJECTED_PENDING_CANC'
       ,x_return_status => l_return_status
       );

Line: 513

        oe_debug_pub.add('Update flow status code: '||L_RETURN_STATUS
                         ||' - '||lines.item_type||'/'||lines.item_key,1);

Line: 544

 * Following procedures added to update flow status codes
 * 1. UPD_FLOW_STATUS_CODE_REJ
 * 2. UPD_FLOW_STATUS_CODE_MIX_REJ
 * Changes in one procedure may be needed in the other procedure also.
 * Because both procedures performs same action of updating flow status
 * code.
 */
PROCEDURE UPD_FLOW_STATUS_CODE_MIX_REJ(
 itemtype 	IN 	VARCHAR2
,itemkey 	IN 	VARCHAR2
,actid 	IN 	NUMBER
,funcmode 	IN 	VARCHAR2
,resultout 	IN OUT NOCOPY /* file.sql.39 change */ 	VARCHAR2
) AS
  l_return_status VARCHAR2(1);

Line: 562

  SELECT line_id,wias.item_type,wias.item_key
  FROM oe_order_lines l
      ,WF_ITEM_ACTIVITY_STATUSES WIAS
      ,WF_PROCESS_ACTIVITIES WPA
  WHERE l.header_id = To_Number(itemkey)
  AND l.line_category_code = 'RETURN'
  AND l.open_flag = 'Y'
  AND WIAS.item_type = 'OEOL'
  AND WIAS.item_key = To_Char(l.line_id)
  AND WPA.instance_id = WIAS.process_activity
  AND WIAS.activity_status = 'NOTIFIED'
  AND WPA.activity_name = 'APPROVE_WAIT_FOR_H';

Line: 579

  oe_order_wf_util.update_flow_status_code (
      P_HEADER_ID => To_Number(itemkey)
     ,P_FLOW_STATUS_CODE => 'RETURN_REJECTED'
     ,X_RETURN_STATUS => l_return_status);

Line: 586

      oe_debug_pub.add('Update flow status code: '||L_RETURN_STATUS
                       ||' - '||itemtype||'/'||itemkey,1);

Line: 597

    OE_Order_WF_Util.Update_Flow_Status_Code (
        p_line_id => lines.line_id
       ,p_flow_status_code => 'REJECTED_PENDING_CANC'
       ,x_return_status => l_return_status
       );

Line: 604

        oe_debug_pub.add('Update flow status code: '||L_RETURN_STATUS
                         ||' - '||lines.item_type||'/'||lines.item_key,1);