eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_ORDER_IMPORT_UTIL_PVT SQL Statements

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

Line: 20


   Procedure: Delete_Order
   -----------------------------------------------------------
*/
PROCEDURE Delete_Order(
	p_request_id     		IN  NUMBER
       ,p_order_source_id     		IN  NUMBER
       ,p_orig_sys_document_ref 	IN  VARCHAR2
       ,p_sold_to_org_id                IN  NUMBER
       ,p_sold_to_org                   IN  VARCHAR2
       ,p_change_sequence 		IN  VARCHAR2
       ,p_return_status         	OUT NOCOPY /* file.sql.39 change */ VARCHAR2
) IS
      l_api_name            CONSTANT VARCHAR2(30) := 'Delete_Order';

Line: 36


    DELETE FROM oe_actions_interface
    WHERE order_source_id       = p_order_source_id
      AND orig_sys_document_ref = p_orig_sys_document_ref
      AND nvl(  sold_to_org_id, FND_API.G_MISS_NUM)
        = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
      AND nvl(  sold_to_org, FND_API.G_MISS_CHAR)
        = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
      AND nvl(  change_sequence,FND_API.G_MISS_CHAR)
	= nvl(p_change_sequence,FND_API.G_MISS_CHAR)
      AND nvl(  request_id,	FND_API.G_MISS_NUM)
	= nvl(p_request_id,	FND_API.G_MISS_NUM);

Line: 48


    DELETE FROM oe_reservtns_interface
    WHERE order_source_id       = p_order_source_id
      AND orig_sys_document_ref = p_orig_sys_document_ref
      AND nvl(  sold_to_org_id, FND_API.G_MISS_NUM)
        = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
      AND nvl(  sold_to_org, FND_API.G_MISS_CHAR)
        = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
      AND nvl(  change_sequence,FND_API.G_MISS_CHAR)
	= nvl(p_change_sequence,FND_API.G_MISS_CHAR)
      AND nvl(  request_id,	FND_API.G_MISS_NUM)
	= nvl(p_request_id,	FND_API.G_MISS_NUM);

Line: 60


    DELETE FROM oe_lotserials_interface
    WHERE order_source_id       = p_order_source_id
      AND orig_sys_document_ref = p_orig_sys_document_ref
      AND nvl(  sold_to_org_id, FND_API.G_MISS_NUM)
        = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
      AND nvl(  sold_to_org, FND_API.G_MISS_CHAR)
        = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
      AND nvl(  change_sequence,FND_API.G_MISS_CHAR)
	= nvl(p_change_sequence,FND_API.G_MISS_CHAR)
      AND nvl(  request_id,	FND_API.G_MISS_NUM)
	= nvl(p_request_id,	FND_API.G_MISS_NUM);

Line: 72


    DELETE FROM oe_credits_interface
    WHERE order_source_id       = p_order_source_id
      AND orig_sys_document_ref = p_orig_sys_document_ref
      AND nvl(  sold_to_org_id, FND_API.G_MISS_NUM)
        = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
      AND nvl(  sold_to_org, FND_API.G_MISS_CHAR)
        = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
      AND nvl(  change_sequence,FND_API.G_MISS_CHAR)
	= nvl(p_change_sequence,FND_API.G_MISS_CHAR)
      AND nvl(  request_id,	FND_API.G_MISS_NUM)
	= nvl(p_request_id,	FND_API.G_MISS_NUM);

Line: 84


    DELETE FROM oe_payments_interface
    WHERE order_source_id       = p_order_source_id
      AND orig_sys_document_ref = p_orig_sys_document_ref
      AND nvl(  change_sequence,FND_API.G_MISS_CHAR)
	= nvl(p_change_sequence,FND_API.G_MISS_CHAR)
      AND nvl(  request_id,	FND_API.G_MISS_NUM)
	= nvl(p_request_id,	FND_API.G_MISS_NUM);

Line: 92


    DELETE FROM oe_price_adjs_interface
    WHERE order_source_id       = p_order_source_id
      AND orig_sys_document_ref = p_orig_sys_document_ref
      AND nvl(  sold_to_org_id, FND_API.G_MISS_NUM)
        = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
      AND nvl(  sold_to_org, FND_API.G_MISS_CHAR)
        = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
      AND nvl(  change_sequence,FND_API.G_MISS_CHAR)
	= nvl(p_change_sequence,FND_API.G_MISS_CHAR)
      AND nvl(  request_id,	FND_API.G_MISS_NUM)
	= nvl(p_request_id,	FND_API.G_MISS_NUM);

Line: 104


       DELETE FROM oe_price_atts_interface
    WHERE order_source_id       = p_order_source_id
      AND orig_sys_document_ref = p_orig_sys_document_ref
      AND nvl(  sold_to_org_id, FND_API.G_MISS_NUM)
        = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
      AND nvl(  sold_to_org, FND_API.G_MISS_CHAR)
        = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
      AND nvl(  change_sequence,FND_API.G_MISS_CHAR)
        = nvl(p_change_sequence,FND_API.G_MISS_CHAR)
      AND nvl(  request_id,     FND_API.G_MISS_NUM)
        = nvl(p_request_id,     FND_API.G_MISS_NUM);

Line: 128


      SELECT 1
      INTO   l_exists_reject_line
      FROM   oe_lines_interface
      WHERE  order_source_id       = p_order_source_id
      AND    orig_sys_document_ref = p_orig_sys_document_ref
      AND nvl(  sold_to_org_id, FND_API.G_MISS_NUM)
           = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
      AND nvl(  sold_to_org, FND_API.G_MISS_CHAR)
           = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
      AND    nvl(  change_sequence,FND_API.G_MISS_CHAR)
	   = nvl(p_change_sequence,FND_API.G_MISS_CHAR)
      AND    nvl(  request_id,	FND_API.G_MISS_NUM)
	   = nvl(p_request_id,	FND_API.G_MISS_NUM)
      AND    nvl(rejected_flag,'N')= 'Y'
      AND    rownum                = 1;

Line: 144


      DELETE FROM oe_lines_interface
      WHERE order_source_id       = p_order_source_id
        AND orig_sys_document_ref = p_orig_sys_document_ref
        AND nvl(  sold_to_org_id, FND_API.G_MISS_NUM)
          = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
        AND nvl(  sold_to_org, FND_API.G_MISS_CHAR)
          = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
        AND nvl(  change_sequence,FND_API.G_MISS_CHAR)
          = nvl(p_change_sequence,FND_API.G_MISS_CHAR)
        AND nvl(  request_id,	FND_API.G_MISS_NUM)
          = nvl(p_request_id,	FND_API.G_MISS_NUM)
        AND nvl(rejected_flag,'N')= 'N';

Line: 162


      oe_debug_pub.add('Delete_Order - No_DATA - Old Path of execution');

Line: 164


      DELETE FROM oe_lines_interface
      WHERE order_source_id       = p_order_source_id
        AND orig_sys_document_ref = p_orig_sys_document_ref
        AND nvl(  sold_to_org_id, FND_API.G_MISS_NUM)
          = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
        AND nvl(  sold_to_org, FND_API.G_MISS_CHAR)
          = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
        AND nvl(  change_sequence,FND_API.G_MISS_CHAR)
          = nvl(p_change_sequence,FND_API.G_MISS_CHAR)
        AND nvl(  request_id,	FND_API.G_MISS_NUM)
          = nvl(p_request_id,	FND_API.G_MISS_NUM);

Line: 176


      DELETE FROM oe_headers_interface
      WHERE order_source_id       = p_order_source_id
        AND orig_sys_document_ref = p_orig_sys_document_ref
        AND nvl(  sold_to_org_id, FND_API.G_MISS_NUM)
          = nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
        AND nvl(  sold_to_org, FND_API.G_MISS_CHAR)
          = nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
        AND nvl(  change_sequence,FND_API.G_MISS_CHAR)
          = nvl(p_change_sequence,FND_API.G_MISS_CHAR)
        AND nvl(  request_id,	FND_API.G_MISS_NUM)
         = nvl(p_request_id,	FND_API.G_MISS_NUM);

Line: 202


         OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Delete_Order',substr(sqlerrm,1,2000));

Line: 205


END Delete_Order;

Line: 209


   Procedure: Delete_Messages
   -----------------------------------------------------------
*/
PROCEDURE Delete_Messages(
	p_request_id     		IN  NUMBER
       ,p_order_source_id     		IN  NUMBER
       ,p_orig_sys_document_ref 	IN  VARCHAR2
       ,p_sold_to_org_id                IN  NUMBER
       ,p_sold_to_org                   IN  VARCHAR2
       ,p_change_sequence 		IN  VARCHAR2
       ,p_org_id                        IN  VARCHAR2
       ,p_return_status         	OUT NOCOPY /* file.sql.39 change */ VARCHAR2
) IS
	l_api_name            CONSTANT VARCHAR2(30) := 'Delete_Messages';

Line: 235


  /*DELETE FROM OE_PROCESSING_MSGS_VL
    WHERE order_source_id       	= p_order_source_id
      AND original_sys_document_ref 	= p_orig_sys_document_ref
      AND nvl(  change_sequence,	FND_API.G_MISS_CHAR)
	= nvl(p_change_sequence,	FND_API.G_MISS_CHAR);*/

Line: 244


    OE_MSG_PUB.DELETE_OI_MESSAGE(
            p_order_source_id           => l_order_source_id,
            p_orig_sys_document_ref     => l_orig_sys_document_ref,
            p_change_sequence           => l_change_sequence,
            p_org_id                    => l_org_id
           );

Line: 261


             OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Delete_Messages');

Line: 264


END Delete_Messages;