APPS.OE_BULK_ORDER_PVT SQL Statements

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

Line: 11

PROCEDURE Delete_Error_Records(p_batch_id NUMBER,
                               p_adjustments_exist IN VARCHAR2,
                               p_process_tax       IN VARCHAR2,
                               p_process_configurations IN VARCHAR2)
IS
  l_return_status        VARCHAR2(1);

Line: 37

        DELETE from OE_ORDER_HOLDS
        WHERE header_id = G_ERROR_REC.header_id(i);

Line: 42

        DELETE from OE_SALES_CREDITS
        WHERE header_id = G_ERROR_REC.header_id(i);

Line: 46

        INV_SalesOrder.Delete_MTL_Sales_Orders_Bulk
             (p_api_version_number     => 1.0
             ,p_error_rec              => G_ERROR_REC
             ,x_return_status          => l_return_status
             ,x_message_count          => l_msg_count
             ,x_message_data           => l_msg_data
             );

Line: 56

                                oe_debug_pub.add(  'ERROR IN DELETE_MTL_SALES_ORDERS_BULK :' ||L_RETURN_STATUS ) ;

Line: 63

        DELETE from OE_ORDER_LINES
        WHERE orig_sys_line_ref in
               (select orig_sys_line_ref from oe_lines_iface_all a
                where nvl(a.error_flag, 'N') = 'Y'
                and a.orig_sys_document_ref=G_ERROR_REC.orig_sys_document_ref(i));

Line: 71

	DELETE from OE_ORDER_HEADERS
        WHERE header_id = G_ERROR_REC.header_id(i)
        and not exists (select 1 from oe_order_lines
                        where header_id=G_ERROR_REC.header_id(i));

Line: 78

        DELETE from OE_ORDER_LINES
        WHERE header_id = G_ERROR_REC.header_id(i);

Line: 83

        DELETE from OE_ORDER_HEADERS
        WHERE header_id = G_ERROR_REC.header_id(i);

Line: 92

          DELETE from ONT_DBI_CHANGE_LOG
          WHERE header_id = G_ERROR_REC.header_id(i);

Line: 100

            DELETE from OE_PRICE_ADJUSTMENTS
            WHERE header_id = G_ERROR_REC.header_id(i);

Line: 108

            OE_BULK_CONFIG_UTIL.Delete_Configurations
               (   p_error_rec           => G_ERROR_REC
                  ,x_return_status       => l_return_status
               );

Line: 115

                   oe_debug_pub.add( 'ERROR IN OE_BULK_CONFIG_UTIL.Delete_Configurations :'
                        ||L_RETURN_STATUS ) ;

Line: 127

        oe_debug_pub.add(  'Exiting Delete_Error_Records :');

Line: 136

        ,   'Delete_Error_Records'
        );

Line: 139

END Delete_Error_Records;

Line: 179

        UPDATE OE_HEADERS_IFACE_ALL
	SET ERROR_FLAG = 'Y'
	WHERE REQUEST_ID = G_REQUEST_ID
	AND ORDER_SOURCE_ID = G_ERROR_REC.order_source_id(i)
        AND ORIG_SYS_DOCUMENT_REF = G_ERROR_REC.orig_sys_document_ref(i)
        AND NOT EXISTS
	    (SELECT 1
	     FROM oe_lines_iface_all b
	     WHERE b.orig_sys_document_ref = G_ERROR_REC.orig_sys_document_ref(i)
	     AND b.order_source_id = G_ERROR_REC.order_source_id(i)
   	     AND nvl(error_flag, 'N') = 'N');

Line: 196

      	UPDATE OE_HEADERS_IFACE_ALL
        SET ERROR_FLAG = 'Y'
        WHERE REQUEST_ID = G_REQUEST_ID
        AND ORDER_SOURCE_ID = G_ERROR_REC.order_source_id(i)
        AND ORIG_SYS_DOCUMENT_REF = G_ERROR_REC.orig_sys_document_ref(i);

Line: 228

PROCEDURE Update_DBI_Log
( p_line_rec                  IN OE_WSH_BULK_GRP.Line_Rec_Type
, x_return_status OUT NOCOPY VARCHAR2

)
IS
  l_header_id               NUMBER;

Line: 240

  l_last_update_date        DATE;

Line: 263

        INSERT INTO ONT_DBI_CHANGE_LOG
          ( HEADER_ID
           ,LINE_ID
           ,SET_OF_BOOKS_ID
           ,CURRENCY_CODE
           ,LAST_UPDATE_DATE
           )
        VALUES
          ( p_line_rec.header_id(I)
           ,p_line_rec.line_id(I)
           ,l_set_of_books_id
           ,l_currency_code
           ,sysdate
           );

Line: 288

          ,'Update_DBI_log');

Line: 291

END Update_DBI_Log;

Line: 321

     SELECT hsecs INTO l_start_time from v$timer;

Line: 332

     SELECT hsecs INTO l_end_time from v$timer;

Line: 352

     SELECT hsecs INTO l_start_time from v$timer;

Line: 369

     SELECT hsecs INTO l_end_time from v$timer;

Line: 388

     SELECT hsecs INTO l_start_time from v$timer;

Line: 397

     SELECT hsecs INTO l_end_time from v$timer;

Line: 410

     SELECT hsecs INTO l_start_time from v$timer;

Line: 418

     SELECT hsecs INTO l_end_time from v$timer;

Line: 435

     SELECT hsecs INTO l_start_time from v$timer;

Line: 444

     SELECT hsecs INTO l_end_time from v$timer;

Line: 487

     SELECT hsecs INTO l_start_time from v$timer;

Line: 501

     SELECT hsecs INTO l_end_time from v$timer;

Line: 518

     SELECT hsecs INTO l_start_time from v$timer;

Line: 539

     SELECT hsecs INTO l_end_time from v$timer;

Line: 556

     SELECT hsecs INTO l_start_time from v$timer;

Line: 565

     SELECT hsecs INTO l_end_time from v$timer;

Line: 578

     SELECT hsecs INTO l_start_time from v$timer;

Line: 587

     SELECT hsecs INTO l_end_time from v$timer;

Line: 647

     SELECT hsecs INTO l_start_time from v$timer;

Line: 669

     SELECT hsecs INTO l_end_time from v$timer;

Line: 687

     SELECT hsecs INTO l_start_time from v$timer;

Line: 704

     SELECT hsecs INTO l_end_time from v$timer;

Line: 721

	   -- Selecting hsecs from v$times is changed to execute only when debug
	   -- is enabled, as hsec is used for logging only when debug is enabled.
	   IF l_debug_level > 0 Then
	     SELECT hsecs INTO l_start_time from v$timer;

Line: 753

	   -- Selecting hsecs from v$times is changed to execute only when debug
	   -- is enabled, as hsec is used for logging only when debug is enabled.
	   IF l_debug_level > 0 Then
	     SELECT hsecs INTO l_end_time from v$timer;

Line: 770

           select hsecs into l_start_time from v$timer;

Line: 774

            select hsecs into l_end_time from v$timer;

Line: 797

     SELECT hsecs INTO l_start_time from v$timer;

Line: 800

   OE_Bulk_Header_Util.Insert_Headers
                ( p_header_rec      => G_HEADER_REC
                 ,p_batch_id        => p_batch_id
                 );

Line: 809

     SELECT hsecs INTO l_end_time from v$timer;

Line: 812

   FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Insert_headers is (sec) '||((l_end_time-l_start_time)/100));

Line: 818

     SELECT hsecs INTO l_start_time from v$timer;

Line: 821

   OE_Bulk_Line_Util.Insert_Lines
                ( p_line_rec         => G_LINE_REC
                 );

Line: 829

     SELECT hsecs INTO l_end_time from v$timer;

Line: 832

   FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Insert_Lines is (sec) '||((l_end_time-l_start_time)/100));

Line: 843

     SELECT hsecs INTO l_start_time from v$timer;

Line: 852

     SELECT hsecs INTO l_end_time from v$timer;

Line: 866

	   -- Selecting hsecs from v$times is changed to execute only when debug
	   -- is enabled, as hsec is used for logging only when debug is enabled.
	   IF l_debug_level > 0 Then
	     SELECT hsecs INTO l_start_time from v$timer;

Line: 872

      Update_DBI_Log(p_line_rec         => G_LINE_REC
                    ,x_return_status    => l_return_status
                    );

Line: 883

	   -- Selecting hsecs from v$times is changed to execute only when debug
	   -- is enabled, as hsec is used for logging only when debug is enabled.
	   IF l_debug_level > 0 Then
	     SELECT hsecs INTO l_end_time from v$timer;

Line: 889

      FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Update DBI Logs is (sec) '
            ||((l_end_time-l_start_time)/100));

Line: 913

	   -- Selecting hsecs from v$times is changed to execute only when debug
	   -- is enabled, as hsec is used for logging only when debug is enabled.
	   IF l_debug_level > 0 Then
	     SELECT hsecs INTO l_start_time from v$timer;

Line: 919

      OE_Bulk_Price_Pvt.Insert_Adjustments(p_batch_id, l_return_status);

Line: 926

	   -- Selecting hsecs from v$times is changed to execute only when debug
	   -- is enabled, as hsec is used for logging only when debug is enabled.
	   IF l_debug_level > 0 Then
	     SELECT hsecs INTO l_end_time from v$timer;

Line: 932

      FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Inserting Price Adjs is (sec) '
          ||((l_end_time-l_start_time)/100));

Line: 942

	   -- Selecting hsecs from v$times is changed to execute only when debug
	   -- is enabled, as hsec is used for logging only when debug is enabled.
	   IF l_debug_level > 0 Then
	     SELECT hsecs INTO l_start_time from v$timer;

Line: 967

	   -- Selecting hsecs from v$times is changed to execute only when debug
	   -- is enabled, as hsec is used for logging only when debug is enabled.
	   IF l_debug_level > 0 Then
	     SELECT hsecs INTO l_end_time from v$timer;

Line: 986

   Delete_Error_Records(p_batch_id,
                        p_adjustments_exist,
                        p_process_tax,
                        p_process_configurations);

Line: 998

	   -- Selecting hsecs from v$times is changed to execute only when debug
	   -- is enabled, as hsec is used for logging only when debug is enabled.
	   IF l_debug_level > 0 Then
	     SELECT hsecs INTO l_start_time from v$timer;

Line: 1011

	   -- Selecting hsecs from v$times is changed to execute only when debug
	   -- is enabled, as hsec is used for logging only when debug is enabled.
	   IF l_debug_level > 0 Then
	     SELECT hsecs INTO l_end_time from v$timer;

Line: 1031

     SELECT hsecs INTO l_start_time from v$timer;

Line: 1047

     SELECT hsecs INTO l_end_time from v$timer;

Line: 1063

     SELECT hsecs INTO l_start_time from v$timer;

Line: 1089

     SELECT hsecs INTO l_end_time from v$timer;

Line: 1165

     SELECT 'Y'
     INTO l_adjustments_exist
     FROM OE_PRICE_ADJS_INTERFACE a, OE_HEADERS_IFACE_ALL h
     WHERE h.batch_id = p_batch_id
      AND a.order_source_id = h.order_source_id
      AND a.orig_sys_document_ref = h.orig_sys_document_ref
      AND rownum = 1;

Line: 1203

     SELECT hsecs INTO l_start_time from v$timer;

Line: 1210

     SELECT hsecs INTO l_end_time from v$timer;

Line: 1224

     SELECT hsecs INTO l_start_time from v$timer;

Line: 1231

     SELECT hsecs INTO l_end_time from v$timer;

Line: 1245

     SELECT hsecs INTO l_start_time from v$timer;

Line: 1264

   OE_Bulk_Value_To_Id.INSERT_ERROR_MESSAGES(p_batch_id);

Line: 1270

     SELECT hsecs INTO l_end_time from v$timer;

Line: 1298

       SELECT hsecs INTO l_start_time from v$timer;

Line: 1306

       SELECT hsecs INTO l_end_time from v$timer;

Line: 1426

    SELECT count(*)
    INTO l_count
    FROM fnd_descr_flex_column_usages
    WHERE APPLICATION_ID = 660
    AND DESCRIPTIVE_FLEXFIELD_NAME = p_flex_name
    AND ENABLED_FLAG = 'Y'
    AND ROWNUM = 1;