APPS.OE_VERSIONING_UTIL SQL Statements

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

Line: 9

FUNCTION Delete_Created_Records
RETURN VARCHAR2
IS
i           NUMBER;

Line: 24

        oe_debug_pub.add('Entering Delete_Created_Records ',1);

Line: 39

        DELETE FROM OE_ORDER_LINES_HISTORY
        WHERE line_id = l_temp_table(i);

Line: 41

     l_temp_table.DELETE;

Line: 62

        DELETE FROM OE_PRICE_ADJS_HISTORY
        WHERE price_adjustment_id = l_temp_table(i);

Line: 64

     l_temp_table.DELETE;

Line: 85

        DELETE FROM OE_SALES_CREDIT_HISTORY
        WHERE sales_credit_id = l_temp_table(i);

Line: 87

     l_temp_table.DELETE;

Line: 91

        oe_debug_pub.add('Exiting Delete_Created_Records ',1);

Line: 103

        ,   'Delete_Created_Records'
        );

Line: 108

END Delete_Created_Records;

Line: 210

            select version_number into l_version_number from oe_order_headers_all where header_id = p_header_id;

Line: 224

         select version_number into l_version_number from oe_order_headers_all where header_id = p_header_id;

Line: 238

    SELECT LOCK_CONTROL, VERSION_NUMBER
    INTO l_lock_control, l_version_number
    FROM OE_BLANKET_HEADERS_ALL
    WHERE HEADER_ID = p_header_id;

Line: 245

     UPDATE OE_BLANKET_HEADERS_ALL
     SET VERSION_NUMBER = l_version_number + 1,
     LOCK_CONTROL = l_lock_control + 1
     WHERE HEADER_ID = p_header_id;

Line: 273

    UPDATE OE_BLANKET_HEADERS_HIST
    SET REASON_ID = l_reason_id
    WHERE phase_change_flag = l_phase_change_flag
    AND version_flag = l_version_flag
    AND version_number = OE_Blanket_Util.g_old_header_hist_rec.version_number;

Line: 357

  l_return_status := Delete_Created_Records;

Line: 401

    UPDATE OE_ORDER_HEADER_HISTORY
    SET REASON_ID = l_reason_id
    WHERE HEADER_ID = p_header_id
    AND phase_change_flag = l_phase_change_flag
    AND version_flag = l_version_flag
    AND version_number = l_version_number;

Line: 422

    SELECT LOCK_CONTROL
    INTO l_lock_control
    FROM OE_ORDER_HEADERS_ALL
    WHERE HEADER_ID = p_header_id;

Line: 432

      UPDATE OE_ORDER_HEADERS_ALL
      SET VERSION_NUMBER = l_version_number + 1,
      LOCK_CONTROL = l_lock_control + 1
      WHERE HEADER_ID = p_header_id;

Line: 437

      /* update the order cache so that the header can be updated without requery
         after creating a new version from line, bug 4523686*/
       IF l_debug_level  > 0 THEN
          oe_debug_pub.add(' Updating oe_order_cache.g_header_rec with version number, lock control ',1);

Line: 634

      select version_number into l_version_number from oe_order_headers_all where header_id = l_header_id;

Line: 707

	        oe_debug_pub.add('Inserting Header History Caused Error ',1);

Line: 751

              OR (l_hist_type_code IN ('CANCELLATION','QUANTITY UPDATE')
                  and OE_ORDER_UTIL.g_line_tbl(i).change_reason is not null
                  and OE_ORDER_UTIL.g_line_tbl(i).change_reason <> fnd_api.g_miss_char
                  )
              ) then
           --Apply Reason for audit
            OE_Reasons_Util.Apply_Reason(
                  p_entity_code => 'LINE',
                  p_entity_id => oe_order_util.g_old_line_tbl(i).line_id,
                  p_header_id => oe_order_util.g_old_line_tbl(i).header_id,
                  p_version_number => l_version_number,
                  p_reason_type => 'CANCEL_CODE',
                  p_reason_code => OE_ORDER_UTIL.g_line_tbl(i).change_reason,
                  p_reason_comments => OE_ORDER_UTIL.g_line_tbl(i).change_comments,
                  x_reason_id => l_reason_id,
                  x_return_status => l_return_status);

Line: 806

                     oe_debug_pub.add('Inserting Line Audit History error',1);

Line: 889

                      oe_debug_pub.add('Inserting Line Audit History error',1);

Line: 974

                      oe_debug_pub.add('Inserting Line Audit History error',1);

Line: 1056

                      oe_debug_pub.add('Inserting Line Audit History error',1);

Line: 1139

                      oe_debug_pub.add('Inserting Line Audit History error',1);

Line: 1192

      G_Audit_Line_ID_Tbl.DELETE;

Line: 1193

      G_Audit_Header_Adj_ID_Tbl.DELETE;

Line: 1194

      G_Audit_Line_Adj_ID_Tbl.DELETE;

Line: 1195

      G_Audit_Header_Scredit_ID_Tbl.DELETE;

Line: 1196

      G_Audit_Line_Scredit_ID_Tbl.DELETE;

Line: 1383

           G_Audit_Header_Hist_Code := 'UPDATE';