APPS.OE_ACCEPTANCE_PVT SQL Statements

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

Line: 21

 G_LINE_ID_TBL.delete;

Line: 22

 G_HEADER_ID_TBL.delete;

Line: 23

 G_REVREC_COMMENTS_TBL.delete;

Line: 24

 G_REVREC_REF_DOC_TBL.delete;

Line: 25

 G_REVREC_SIGNATURE_TBL.delete;

Line: 26

 G_REVREC_IMPLICIT_FLAG_TBL.delete;

Line: 27

 G_REVREC_SIGNATURE_DATE_TBL.delete;

Line: 28

 G_ACCEPTED_BY_TBL.delete;

Line: 29

 G_ACCEPTED_QUANTITY_TBL.delete;

Line: 30

 G_FLOW_STATUS_TBL.delete;

Line: 106

      oe_debug_pub.add('IN OE_ACCEPTANCE_UTIL.Process_Acceptance - before bulk update' , 1);

Line: 110

   UPDATE oe_order_lines_all
   SET   revrec_comments = g_revrec_comments_tbl(i),
             Revrec_reference_document = g_revrec_ref_doc_tbl(i),
             Revrec_signature = g_revrec_signature_tbl(i),
             Revrec_implicit_flag = g_revrec_implicit_flag_tbl(i),
             Revrec_signature_date = g_revrec_signature_date_tbl(i),
             Accepted_by = g_accepted_by_tbl(i),
             Accepted_quantity = g_accepted_quantity_tbl(i)
   WHERE line_id = g_line_id_tbl(i);

Line: 121

      oe_debug_pub.add('IN OE_ACCEPTANCE_UTIL.Process_Acceptance - after bulk update' , 1);

Line: 177

	                        	                 p_event_name => 'oracle.apps.ont.oip.statuschange.update',
					                 p_nameVal_tbl => l_nameVal_tbl);

Line: 214

    SELECT line_id
    FROM   oe_order_lines_all
    WHERE header_id = l_header_id
    AND   open_flag = 'Y'
    AND   flow_status_code in ('PRE-BILLING_ACCEPTANCE', 'POST-BILLING_ACCEPTANCE');

Line: 268

  SELECT line_id, fulfilled_quantity,shipped_quantity, ordered_quantity,header_id, flow_status_code
  FROM   oe_order_lines_all
  WHERE header_id = l_header_id
  AND   open_flag = 'Y'
  AND top_model_line_id = l_line_id;

Line: 275

  SELECT line_id, fulfilled_quantity, shipped_quantity, ordered_quantity, header_id, flow_status_code
  FROM   oe_order_lines_all
  WHERE open_flag='Y'
  AND service_reference_line_id = l_line_id;

Line: 292

            SELECT header_id, item_type_code, top_model_line_id, fulfilled_quantity,
	           shipped_quantity, ordered_quantity, flow_status_code
            INTO l_header_id, l_item_type_code, l_top_model_line_id, l_fulfilled_quantity,
	           l_shipped_quantity, l_ordered_quantity, l_flow_status_code
            FROM oe_order_lines_all
            WHERE line_id=l_line_id;

Line: 315

            IF OE_GLOBALS.G_UPDATE_GLOBAL_PICTURE = 'Y' THEN
               OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists =>False,
                       p_line_id => l_line_id,
                       x_index => l_notify_index,
                       x_return_status => l_notify_status);

Line: 346

            SELECT header_id, item_type_code, top_model_line_id, fulfilled_quantity,
	           shipped_quantity, ordered_quantity, flow_status_code
              INTO l_header_id, l_item_type_code, l_top_model_line_id, l_fulfilled_quantity,
	           l_shipped_quantity, l_ordered_quantity, l_flow_status_code
              FROM oe_order_lines_all
              WHERE line_id=l_line_id;

Line: 380

             IF OE_GLOBALS.G_UPDATE_GLOBAL_PICTURE = 'Y' THEN
                OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists =>False,
                    p_line_id => l_line_id,
                    x_index => l_notify_index,
                    x_return_status => l_notify_status);

Line: 429

		IF OE_GLOBALS.G_UPDATE_GLOBAL_PICTURE = 'Y' THEN
                  OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists =>False,
                       p_line_id => l_line_id,
                       x_index => l_notify_index,
                       x_return_status => l_notify_status);

Line: 476

        IF OE_GLOBALS.G_UPDATE_GLOBAL_PICTURE = 'Y' THEN
           OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists =>False,
                       p_line_id => l_line_id,
                       x_index => l_notify_index,
                       x_return_status => l_notify_status);

Line: 526

       IF OE_GLOBALS.G_UPDATE_GLOBAL_PICTURE = 'Y' THEN
           OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists =>False,
                       p_line_id => l_line_id,
                       x_index => l_notify_index,
                       x_return_status => l_notify_status);

Line: 623

            	SELECT inventory_item_id, org_id
            	INTO l_inventory_item_id, l_org_id
            	FROM oe_order_lines_all
            	WHERE line_id = g_line_id_tbl(i);

Line: 656

	       	   UPDATE oe_order_lines_all
		   SET flow_status_code='NOTIFY_COSTING_ERROR'
		   WHERE line_id = g_line_id_tbl(i);