DBA Data[Home] [Help]

APPS.OE_DELAYED_REQUESTS_PVT SQL Statements

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

Line: 31

   should be inserted.
*/

PROCEDURE Process_Scheduling_Request
( p_request_ind    IN  NUMBER
 ,p_request_rec    IN  OE_Order_PUB.request_rec_type
,x_return_status OUT NOCOPY VARCHAR2);
Line: 162

   ,p_delete            IN Varchar2 default  FND_API.G_FALSE
,x_return_status OUT NOCOPY VARCHAR2)

IS
cursor included_lines_cur(p_header_id in number) is
select line_id
from oe_order_lines_all
where header_id = p_header_id
and item_type_code = 'INCLUDED';
Line: 182

l_deleted_options_tbl  OE_Order_PUB.request_tbl_type;
Line: 183

l_updated_options_tbl  OE_Order_PUB.request_tbl_type;
Line: 483

               OE_DELAYED_REQUESTS_UTIL.Insert_Set
			(p_request_rec  => l_request_rec,
			 x_return_status     => l_return_status);
Line: 486

       ELSIF  l_request_type = OE_GLOBALS.G_INSERT_INTO_SETS then
           IF l_entity_code = OE_GLOBALS.G_ENTITY_LINE then
/* Commenting out nocopy per Rupal */

		 null;
Line: 491

           /*  OE_Process_Models.Insert_Into_Line_Sets
                  (p_line_id            =>l_entity_id
                   ,p_top_model_line_id =>l_request_rec.param2
                   ,p_set_type          => 'ALL'
                   ,x_return_status     =>l_return_status
                 ); */
Line: 519

                        OE_GLOBALS.G_INSERT_RMA then
               OE_DELAYED_REQUESTS_UTIL.INSERT_RMA_SCREDIT_ADJUSTMENT
                 ( x_return_status      =>l_return_status
                  ,p_line_id     => l_entity_id
                 );
Line: 524

               OE_DELAYED_REQUESTS_UTIL.INSERT_RMA_OPTIONS_INCLUDED
                 ( x_return_status      =>l_return_status
                  ,p_line_id     => l_entity_id
                 );
Line: 530

               IF NOT((l_request_rec.param1 = OE_GLOBALS.G_OPR_UPDATE and
                   nvl(l_request_rec.param2,'USER') = 'SYSTEM' and
                   NVL(l_request_rec.param3,'X') = 'SPLIT')
                   OR
                   (l_request_rec.param1 = OE_GLOBALS.G_OPR_CREATE AND
                    l_request_rec.param4 IS NOT NULL AND
                    nvl(l_request_rec.param2, 'USER') = 'SYSTEM'))
               THEN
                   OE_DELAYED_REQUESTS_UTIL.INSERT_RMA_LOT_SERIAL
                   ( x_return_status      =>l_return_status
                    ,p_line_id     => l_entity_id
                   );
Line: 631

      ELSIF l_request_rec.request_type = OE_GLOBALS.G_UPDATE_SHIPPING THEN

		OE_Delayed_Requests_UTIL.Update_Shipping
			( p_update_shipping_tbl => g_delayed_requests
			, p_line_id		    => l_request_rec.entity_id
			, p_operation           => l_request_rec.request_unique_key1
			, x_return_status       => l_return_status
		  );
Line: 695

 ELSIF l_request_rec.request_type = OE_GLOBALS.G_UPDATE_REQUISITION THEN

   IF NVL(l_request_rec.param2,'N') = 'Y' THEN
     IF l_debug_level > 0 THEN
       oe_debug_pub.add('Requisition Header Cancellation is TRUE',5);
Line: 722

   OE_Delayed_Requests_UTIL.Update_Requisition_Info
         ( P_Requisition_Header_id  => l_request_rec.request_unique_key2
         , P_Requisition_Line_id    => l_request_rec.request_unique_key3
         , P_Header_id              => l_header_id
         , p_Line_id                => l_line_id
         , p_Line_ids               => l_request_rec.long_param1
         , p_num_records            => l_request_rec.param3
         , P_Quantity_Change        => l_request_rec.param1
         , P_Quantity2_Change       => l_request_rec.param4 --Bug 14211120
         , P_New_Schedule_Ship_Date => l_request_rec.date_param1
         , P_Cancel_order           => l_cancel_order  -- Param2
         , X_Return_Status          => l_return_status
         );
Line: 806

       ELSIF l_request_type = OE_GLOBALS.G_UPDATE_OPTION THEN
         IF l_debug_level > 0 THEN
            oe_debug_pub.add('upd: processed with cfg val', 3);
Line: 812

       ELSIF l_request_type = OE_GLOBALS.G_DELETE_OPTION THEN
         IF l_debug_level > 0 THEN
            oe_debug_pub.add('del: processed with cfg val', 3);
Line: 832

            IF G_Delayed_Requests(K).request_type = OE_GLOBALS.G_DELETE_OPTION  OR
               G_Delayed_Requests(K).request_type = OE_GLOBALS.G_UPDATE_OPTION
            THEN

                IF G_Delayed_Requests(K).request_type = OE_GLOBALS.G_DELETE_OPTION
                   AND G_Delayed_Requests(K).param1 = l_request_rec.entity_id
                THEN
                    l_d_index := l_d_index + 1;
Line: 840

	    	      l_deleted_options_tbl(l_d_index) :=
                                   g_delayed_requests(K);
Line: 844

                IF G_Delayed_Requests(K).request_type = OE_GLOBALS.G_UPDATE_OPTION
                   AND G_Delayed_Requests(K).param1 = l_request_rec.entity_id
                THEN
                    l_u_index := l_u_index + 1;
Line: 848

	  	        l_updated_options_tbl(l_u_index) :=
                                   g_delayed_requests(K);
Line: 863

                , p_deleted_options_tbl => l_deleted_options_tbl
                , p_updated_options_tbl => l_updated_options_tbl
                , x_return_status       => l_return_status
                );
Line: 872

           oe_debug_pub.add('deleteing after success ', 3);
Line: 878

                   OE_GLOBALS.G_DELETE_OPTION  OR
                 G_Delayed_Requests(K).request_type =
                   OE_GLOBALS.G_UPDATE_OPTION ) AND
                 G_Delayed_Requests(K).param1 = l_request_rec.entity_id
             THEN
               G_Delayed_Requests.delete(K);
Line: 1010

             oe_debug_pub.add('deleteing after success ', 3);
Line: 1020

               G_Delayed_Requests.delete(K);
Line: 1072

         l_sch_set_tbl.delete;
Line: 1117

         l_sch_set_tbl.delete;
Line: 1119

					   OE_GLOBALS.G_INSERT_SERVICE then
              OE_DELAYED_REQUESTS_UTIL.INSERT_SERVICE_FOR_OPTIONS
			  ( x_return_status    => l_return_status
			  , p_serviced_line_id => l_entity_id
			  );
Line: 1276

		  g_delayed_requests.delete(l_prc_adj_index);
Line: 1382

       ELSIF  l_request_type = OE_GLOBALS.G_UPDATE_SERVICE THEN
           IF l_debug_level > 0 THEN
              oe_debug_pub.add('CSH-- Before calls OE_Service_Util.cascade_changes', 1);
Line: 1433

        ELSIF l_request_type = OE_GLOBALS.G_DELETE_CHARGES THEN
          OE_Header_Util.cancel_header_charges
                     (
                      p_header_id       => l_request_rec.entity_id,
                      --p_x_line_id         => to_number(l_request_rec.param1),
                      x_return_status      => l_return_status
                     );
Line: 1462

                g_delayed_requests.delete(K);
Line: 1497

                g_delayed_requests.delete(K);
Line: 1550

                  g_delayed_requests.delete(l_count);
Line: 1576

                        OE_GLOBALS.G_DELETE_SET THEN
          l_set_id := l_request_rec.param1;
Line: 1585

                           OE_GLOBALS.G_DELETE_SET)
               AND G_Delayed_Requests(K).param1 = l_set_id
               AND K <> p_request_ind THEN

                g_delayed_requests.delete(K);
Line: 1597

          oe_set_util.Delete_Set(p_request_rec      => l_request_rec
                               , x_return_status    => l_return_status);
Line: 1599

          oe_debug_pub.add('Delete Set Return Status ' || l_return_status,1);
Line: 1679

       ELSIF  l_request_type = OE_GLOBALS.G_UPDATE_COMMITMENT THEN

			OE_Commitment_Pvt.update_commitment
                          ( p_line_id       => l_request_rec.entity_id
                           ,x_return_status => l_return_status
                          );
Line: 1686

       ELSIF  l_request_type = OE_GLOBALS.G_UPDATE_COMMITMENT_APPLIED THEN
         IF l_debug_level > 0 THEN
         oe_debug_pub.add('OEXVREQB param1 is: '||l_request_rec.param1,3);
Line: 1692

			OE_Commitment_Pvt.update_commitment_applied
                          ( p_line_id       => l_request_rec.entity_id
                           ,p_amount	    => l_request_rec.param1
                           ,p_header_id     => l_request_rec.param2
                           ,p_commitment_id => l_request_rec.param3
                           ,x_return_status => l_return_status
                          );
Line: 1799

          oe_debug_pub.add('Executing Delete_Changed_Lines delayed request');
Line: 1802

          Oe_Line_Adj_Util.Delete_Changed_Lines_Tbl;
Line: 1804

          oe_debug_pub.add('After Delete_Changed_Lines delayed request');
Line: 1867

       ELSIF l_request_type = OE_GLOBALS.G_UPDATE_HDR_PAYMENT then

         IF l_debug_level > 0 THEN
           oe_debug_pub.add('param1 is : ' || l_request_rec.param1);
Line: 1877

            AND l_request_rec.param1 = 'UPDATE_LINE' THEN
               payment_line_id := l_request_rec.entity_id;
Line: 1887

              oe_debug_pub.add('header id for update_hdr_payment is : ' || payment_header_id,3);
Line: 1888

              oe_debug_pub.add('line id for update_hdr_payment is : ' || payment_line_id,3);
Line: 1891

	    OE_PrePayment_Pvt.Update_Hdr_Payment (
	                    p_header_id             => payment_header_id
                          , p_action                => l_request_rec.param1
                          , p_line_id               => payment_line_id
	                  , x_return_status         => l_return_status
	                  , x_msg_count             => l_msg_count
	                  , x_msg_data              => l_msg_data
	                  );
Line: 1908

                       p_calling_action => 'UPDATE',
                       p_amount         => null,
                       p_delayed_request=> FND_API.G_TRUE,
                       x_msg_data	=> l_msg_data,
                       x_msg_count	=> l_msg_count,
                       x_return_status	=> l_return_status);
Line: 1954

       ELSIF l_request_type = OE_GLOBALS.G_DELETE_PAYMENT_HOLD  THEN
         IF l_request_rec.entity_code = OE_GLOBALS.G_ENTITY_LINE_PAYMENT THEN
            payment_line_id := l_request_rec.entity_id;
Line: 1964

           oe_debug_pub.add('header id for delete_payment_hold is : ' || payment_header_id,3);
Line: 1965

           oe_debug_pub.add('line id for delete_payment_hold is : ' || payment_line_id,3);
Line: 1968

	 OE_PrePayment_Pvt.Delete_Payment_Hold
                          ( p_line_id          	  => payment_line_id
	                  , p_header_id           => payment_header_id
	                  , p_hold_type           => l_request_rec.param1
	                  , x_return_status       => l_return_status
	                  , x_msg_count           => l_msg_count
	                  , x_msg_data            => l_msg_data
	                  );
Line: 2001

	ELSIF l_request_type = OE_GLOBALS.G_DELETE_PAYMENTS  THEN
		IF l_request_rec.entity_code = OE_GLOBALS.G_ENTITY_LINE_PAYMENT THEN
			payment_line_id := l_request_rec.entity_id;
Line: 2013

                  oe_debug_pub.add('header id for delete_payments is : ' || payment_header_id,3);
Line: 2014

                  oe_debug_pub.add('line id for delete_payments is : ' || payment_line_id,3);
Line: 2017

		OE_PrePayment_Pvt.Delete_Payments
		 ( p_line_id             => payment_line_id
		, p_header_id           => payment_header_id
		, p_invoice_to_org_id	=> old_invoice_to_org_id
		, x_return_status       => l_return_status
                , x_msg_count           => l_msg_count
		, x_msg_data            => l_msg_data
		);
Line: 2069

       IF (p_delete = FND_API.G_TRUE) then

             G_Delayed_Requests.Delete(p_request_ind);
Line: 2074

       BUG 1794544 - do not delete from req entities table
       , delete table in the end when all requests are processed
       This to improve performance as this search loops through
       the entire pl/sql table which becomes very large with
       greater number of lines being processed
	-- Delete all the records in the requesting entities table
	-- that have this request.

	l_req_entity_ind := G_Requesting_Entities.First;
Line: 2088

		G_Requesting_Entities.Delete(l_req_entity_ind);
Line: 2125

	   IF (p_delete = FND_API.G_TRUE)
             AND G_Delayed_Requests.EXISTS(p_request_ind) THEN --13737412
		-- Bug 11811300 starts
    		IF G_Delayed_Requests(p_request_ind).request_type IN
    		(OE_GLOBALS.G_SCHEDULE_LINE,OE_GLOBALS.G_GROUP_SCHEDULE,OE_GLOBALS.G_SCHEDULE_ATO,OE_GLOBALS.G_SCHEDULE_SMC,OE_GLOBALS.G_SCHEDULE_NONSMC,OE_GLOBALS.G_DELAYED_SCHEDULE)
    		-- Bug 11811300 ends
		THEN -- 9714072
            		G_Delayed_Requests.Delete(p_request_ind);
Line: 2143

            IF (p_delete = FND_API.G_TRUE)
              AND G_Delayed_Requests.EXISTS(p_request_ind) THEN --13737412
		-- Bug 11811300 starts
    		IF G_Delayed_Requests(p_request_ind).request_type IN
    		(OE_GLOBALS.G_SCHEDULE_LINE,OE_GLOBALS.G_GROUP_SCHEDULE,OE_GLOBALS.G_SCHEDULE_ATO,OE_GLOBALS.G_SCHEDULE_SMC,OE_GLOBALS.G_SCHEDULE_NONSMC,OE_GLOBALS.G_DELAYED_SCHEDULE)
    		-- Bug 11811300 ends
		THEN -- 9714072
            		G_Delayed_Requests.Delete(p_request_ind);
Line: 2159

	    IF (p_delete = FND_API.G_TRUE)
               AND G_Delayed_Requests.EXISTS(p_request_ind) THEN --13737412
		-- Bug 11811300 starts
    		IF G_Delayed_Requests(p_request_ind).request_type IN
    		(OE_GLOBALS.G_SCHEDULE_LINE,OE_GLOBALS.G_GROUP_SCHEDULE,OE_GLOBALS.G_SCHEDULE_ATO,OE_GLOBALS.G_SCHEDULE_SMC,OE_GLOBALS.G_SCHEDULE_NONSMC,OE_GLOBALS.G_DELAYED_SCHEDULE)
    		-- Bug 11811300 ends
		THEN -- 9714072
            		G_Delayed_Requests.Delete(p_request_ind);
Line: 2182

	     IF (p_delete = FND_API.G_TRUE)
               AND G_Delayed_Requests.EXISTS(p_request_ind) THEN --13737412
		-- Bug 11811300 starts
    		IF G_Delayed_Requests(p_request_ind).request_type IN
    		(OE_GLOBALS.G_SCHEDULE_LINE,OE_GLOBALS.G_GROUP_SCHEDULE,OE_GLOBALS.G_SCHEDULE_ATO,OE_GLOBALS.G_SCHEDULE_SMC,OE_GLOBALS.G_SCHEDULE_NONSMC,OE_GLOBALS.G_DELAYED_SCHEDULE)
    		-- Bug 11811300 ends
		THEN -- 9714072
            		G_Delayed_Requests.Delete(p_request_ind);
Line: 2432

           OE_GLOBALS.G_UPDATE_OPTION THEN
          IF l_debug_level > 0 THEN
          OE_Debug_PUB.ADD('update option, orig qty '||
          g_delayed_requests(l_request_ind).param4, 3);
Line: 2565

   ELSIF p_request_type = OE_GLOBALS.G_UPDATE_REQUISITION THEN
     IF l_debug_level > 0 THEN
       oe_debug_pub.add('Type: G_UPDATE_REQUISITION, retain old parameter values',5);
Line: 2664

       ELSE					   -- insert the new request
    IF l_debug_level > 0 THEN
	OE_Debug_PUB.ADD('New request inserted');
Line: 2759

Procedure Delete_Request(p_entity_code     IN VARCHAR2
                        ,p_entity_id       IN NUMBER
                        ,p_request_Type    IN VARCHAR2
                        ,p_request_unique_key1 	IN VARCHAR2 := NULL
			,p_request_unique_key2 	IN VARCHAR2 := NULL
			,p_request_unique_key3 	IN VARCHAR2 := NULL
			,p_request_unique_key4 	IN VARCHAR2 := NULL
			,p_request_unique_key5 	IN VARCHAR2 := NULL
,x_return_status OUT NOCOPY VARCHAR2)

  IS
     l_request_search_rslt  Varchar2(1);
Line: 2779

   oe_debug_pub.add('Entering Procedure Delete_Request in Package OE_Delayed_Requests_Pvt');
Line: 2802

   if l_request_search_rslt = FND_API.G_TRUE     -- delete the request
     then
      G_Delayed_Requests.Delete(l_request_ind);
Line: 2806

       BUG 1794544 - do not delete from req entities table
       , delete table in the end when all requests are processed
       This to improve performance as this search loops through
       the entire pl/sql table which becomes very large with
       greater number of lines being processed
      -- Delete all the records in the requesting entities table
      -- that have this request.
        l_req_entity_ind := G_Requesting_Entities.First;
Line: 2817

                G_Requesting_Entities.Delete(l_req_entity_ind);
Line: 2839

	    ,'DeleteRequest');
Line: 2844

End Delete_Request;
Line: 2859

      G_Delayed_Requests.DELETE;
Line: 2860

      g_requesting_entities.DELETE;
Line: 2863

        OE_Config_Schedule_Pvt.Delete_Attribute_Changes;
Line: 2867

         Oe_Line_Adj_Util.Delete_Changed_Lines_Tbl;
Line: 2872

                OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL.DELETE;
Line: 2898

                        ,p_delete                 IN Varchar2 Default
											FND_API.G_TRUE
,x_return_status OUT NOCOPY Varchar2)

IS
l_request_ind          Number;
Line: 2935

         ,p_delete            => p_delete
         ,x_return_status     => l_return_status
         );
Line: 2972

     ,p_delete            in Varchar2 Default FND_API.G_TRUE
,x_return_status OUT NOCOPY Varchar2) IS

l_return_status        Varchar2(30);
Line: 3004

           ,p_delete            => p_delete
           ,x_return_status     => l_return_status
           );
Line: 3068

           ,p_delete         in Varchar2 Default FND_API.G_TRUE
,x_return_status OUT NOCOPY Varchar2

          ) IS
l_return_status        Varchar2(30);
Line: 3117

               ,p_delete            => p_delete
               ,x_return_status     => l_return_status
               );
Line: 3143

		 G_Delayed_Requests.DELETE(l_entity_id_tbl(l_count).request_ind);
Line: 3145

       BUG 1794544 - do not delete from req entities table
       , delete table in the end when all requests are processed
       This to improve performance as this search loops through
       the entire pl/sql table which becomes very large with
       greater number of lines being processed
           l_req_entity_ind := G_Requesting_Entities.First;
Line: 3155

                   G_Requesting_Entities.Delete(l_req_entity_ind);
Line: 3232

         ,p_delete        => FND_API.G_TRUE
         ,x_return_status => l_return_status
        );
Line: 3244

         ,p_delete        => FND_API.G_TRUE
         ,x_return_status => l_return_status
        );
Line: 3256

         ,p_delete        => FND_API.G_TRUE
         ,x_return_status => l_return_status
        );
Line: 3268

         ,p_delete        => FND_API.G_TRUE
         ,x_return_status => l_return_status
        );
Line: 3281

         ,p_delete        => FND_API.G_TRUE
         ,x_return_status => l_return_status
        );
Line: 3295

         ,p_delete        => FND_API.G_TRUE
         ,x_return_status => l_return_status
        );
Line: 3306

        (p_request_type   => OE_GLOBALS.G_INSERT_INTO_SETS
         ,p_delete        => FND_API.G_TRUE
         ,x_return_status => l_return_status
        );
Line: 3319

        , p_delete        => FND_API.G_TRUE
        , x_return_status => l_return_status );
Line: 3332

         ,p_delete        => FND_API.G_TRUE
         ,x_return_status => l_return_status
        );
Line: 3345

        (p_request_type   => OE_GLOBALS.G_INSERT_RMA
         ,p_delete        => FND_API.G_TRUE
         ,x_return_status => l_return_status
        );
Line: 3358

         ,p_delete        => FND_API.G_TRUE
         ,x_return_status => l_return_status
        );
Line: 3370

         ,p_delete        => FND_API.G_TRUE
         ,x_return_status => l_return_status
        );
Line: 3382

         ,p_delete        => FND_API.G_TRUE
         ,x_return_status => l_return_status
        );
Line: 3395

         ,p_delete        => FND_API.G_TRUE
         ,x_return_status => l_return_status
        );
Line: 3407

         ,p_delete        => FND_API.G_TRUE
         ,x_return_status => l_return_status
        );
Line: 3420

         ,p_delete        => FND_API.G_TRUE
         ,x_return_status => l_return_status
        );
Line: 3432

         ,p_delete        => FND_API.G_TRUE
         ,x_return_status => l_return_status
        );
Line: 3444

         ,p_delete        => FND_API.G_TRUE
         ,x_return_status => l_return_status
        );
Line: 3456

         ,p_delete        => FND_API.G_TRUE
         ,x_return_status => l_return_status
        );
Line: 3468

         ,p_delete        => FND_API.G_TRUE
         ,x_return_status => l_return_status
        );
Line: 3479

        (p_request_type   => OE_GLOBALS.G_INSERT_SERVICE
         ,p_delete        => FND_API.G_TRUE
         ,x_return_status => l_return_status
        );
Line: 3492

         ,p_delete        => FND_API.G_TRUE
         ,x_return_status => l_return_status
        );
Line: 3503

         ,p_delete        => FND_API.G_TRUE
         ,x_return_status => l_return_status
        );
Line: 3515

         ,p_delete        => FND_API.G_TRUE
         ,x_return_status => l_return_status
        );
Line: 3528

          ,p_delete        => FND_API.G_TRUE
          ,x_return_status => l_return_status
          );
Line: 3542

          ,p_delete        => FND_API.G_TRUE
          ,x_return_status => l_return_status
          );
Line: 3554

          ,p_delete        => FND_API.G_TRUE
          ,x_return_status => l_return_status
          );
Line: 3570

          ,p_delete        => FND_API.G_TRUE
          ,x_return_status => l_return_status
          );
Line: 3583

          ,p_delete        => FND_API.G_TRUE
          ,x_return_status => l_return_status
          );
Line: 3597

          ,p_delete        => FND_API.G_TRUE
          ,x_return_status => l_return_status
          );
Line: 3611

          ,p_delete        => FND_API.G_TRUE
          ,x_return_status => l_return_status
          );
Line: 3622

          ,p_delete        => FND_API.G_TRUE
          ,x_return_status => l_return_status
          );
Line: 3634

          ,p_delete        => FND_API.G_TRUE
          ,x_return_status => l_return_status
          );
Line: 3645

          ,p_delete        => FND_API.G_TRUE
          ,x_return_status => l_return_status
          );
Line: 3656

        (p_request_type   => OE_GLOBALS.G_DELETE_CHARGES
         ,p_delete        => FND_API.G_TRUE
         ,x_return_status => l_return_status
        );
Line: 3669

         ,p_delete        => FND_API.G_TRUE
         ,x_return_status => l_return_status
        );
Line: 3682

         ,p_delete        => FND_API.G_TRUE
         ,x_return_status => l_return_status
        );
Line: 3693

        (p_request_type   => OE_GLOBALS.G_UPDATE_COMMITMENT
         ,p_delete        => FND_API.G_TRUE
         ,x_return_status => l_return_status
        );
Line: 3705

        (p_request_type   => OE_GLOBALS.G_UPDATE_COMMITMENT_APPLIED
         ,p_delete        => FND_API.G_TRUE
         ,x_return_status => l_return_status
        );
Line: 3718

	         ,p_delete        	=> FND_API.G_TRUE
	         ,x_return_status 	=> l_return_status
	        );
Line: 3728

	        (p_request_type  	=> OE_GLOBALS.G_UPDATE_HDR_PAYMENT
	         ,p_delete        	=> FND_API.G_TRUE
	         ,x_return_status 	=> l_return_status
	        );
Line: 3741

         ,p_delete        => FND_API.G_TRUE
         ,x_return_status => l_return_status
        );
Line: 3751

	        (p_request_type  	=> OE_GLOBALS.G_DELETE_PAYMENT_HOLD
	         ,p_delete        	=> FND_API.G_TRUE
	         ,x_return_status 	=> l_return_status
	        );
Line: 3764

          ,p_delete        => FND_API.G_TRUE
          ,x_return_status => l_return_status
          );
Line: 3776

          ,p_delete        => FND_API.G_TRUE
          ,x_return_status => l_return_status
          );
Line: 3792

              ,p_delete        => FND_API.G_TRUE
             ,x_return_status => l_return_status);
Line: 3807

          ,p_delete        => FND_API.G_TRUE
          ,x_return_status => l_return_status
          );
Line: 3819

          ,p_delete        => FND_API.G_TRUE
          ,x_return_status => l_return_status
          );
Line: 3840

          ,p_delete        => FND_API.G_TRUE
          ,x_return_status => l_return_status
         );
Line: 3853

          ,p_delete        => FND_API.G_TRUE
          ,x_return_status => l_return_status
          );
Line: 3867

          ,p_delete        => FND_API.G_TRUE
          ,x_return_status => l_return_status
          );
Line: 3916

         ( p_request_type  => OE_GLOBALS.G_UPDATE_REQUISITION
         , p_delete        => FND_API.G_TRUE
         , x_return_status => l_return_status
         );
Line: 3935

          ,p_delete        => FND_API.G_TRUE
          ,x_return_status => l_return_status
          );
Line: 3956

           ,p_delete            => FND_API.G_TRUE
           ,x_return_status     => l_return_status
           );
Line: 3971

          ,p_delete        => FND_API.G_TRUE
          ,x_return_status => l_return_status
          );
Line: 4099

               SELECT order_source_id, orig_sys_document_ref, change_sequence,
               source_document_type_id, source_document_id
               INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence,
               l_source_document_type_id, l_source_document_id
               FROM   OE_ORDER_HEADERS_ALL
               WHERE  header_id = l_request_rec.entity_id;
Line: 4127

               SELECT order_source_id, orig_sys_document_ref, change_sequence,
               source_document_type_id, source_document_id,  orig_sys_line_ref,
               source_document_line_id, orig_sys_shipment_ref, header_id
               INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence,
               l_source_document_type_id, l_source_document_id, l_orig_sys_line_ref,
               l_source_document_line_id, l_orig_sys_shipment_ref, l_header_id
               FROM   OE_ORDER_LINES_ALL
               WHERE  line_id = l_request_rec.entity_id;
Line: 4164

               SELECT header_id
               INTO   l_header_id
               FROM   oe_price_adjustments
               WHERE  price_adjustment_id = l_request_rec.entity_id;
Line: 4180

               SELECT order_source_id, orig_sys_document_ref, change_sequence,
               source_document_type_id, source_document_id
               INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence,
               l_source_document_type_id, l_source_document_id
               FROM   OE_ORDER_HEADERS_ALL
               WHERE  header_id = l_header_id;
Line: 4207

               SELECT line_id
               INTO   l_line_id
               FROM   oe_price_adjustments
               WHERE  price_adjustment_id = l_request_rec.entity_id;
Line: 4223

               SELECT order_source_id, orig_sys_document_ref, change_sequence,
               source_document_type_id, source_document_id,  orig_sys_line_ref,
               source_document_line_id, orig_sys_shipment_ref, header_id
               INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence,
               l_source_document_type_id, l_source_document_id, l_orig_sys_line_ref,
               l_source_document_line_id, l_orig_sys_shipment_ref, l_header_id
               FROM   OE_ORDER_LINES_ALL
               WHERE  line_id = l_line_id;
Line: 4260

               SELECT header_id
               INTO   l_header_id
               FROM   oe_sales_credits
               WHERE  sales_credit_id = l_request_rec.entity_id;
Line: 4276

               SELECT order_source_id, orig_sys_document_ref, change_sequence,
               source_document_type_id, source_document_id
               INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence,
               l_source_document_type_id, l_source_document_id
               FROM   OE_ORDER_HEADERS_ALL
               WHERE  header_id = l_header_id;
Line: 4303

               SELECT line_id
               INTO   l_line_id
               FROM   oe_sales_credits
               WHERE  sales_credit_id = l_request_rec.entity_id;
Line: 4319

               SELECT order_source_id, orig_sys_document_ref, change_sequence,
               source_document_type_id, source_document_id,  orig_sys_line_ref,
               source_document_line_id, orig_sys_shipment_ref, header_id
               INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence,
               l_source_document_type_id, l_source_document_id, l_orig_sys_line_ref,
               l_source_document_line_id, l_orig_sys_shipment_ref, l_header_id
               FROM   OE_ORDER_LINES_ALL
               WHERE  line_id = l_line_id;
Line: 4656

             OE_MSG_PUB.update_msg_context(
                         p_header_id   => l_request_rec.entity_id);
Line: 4660

              OE_MSG_PUB.update_msg_context(
  	           p_line_id  	=> l_request_rec.entity_id);
Line: 4765

Procedure Delete_Reqs_for_Deleted_Entity ( p_entity_code	IN Varchar2
                                        ,  p_delete_against    IN BOOLEAN := TRUE
					,   p_entity_id       in Number := NULL
, x_return_status OUT NOCOPY Varchar2)

IS
     i			       	number;
Line: 4774

     request_delete		BOOLEAN;
Line: 4789

   oe_debug_pub.add('In Delete_Reqs_for_Deleted_Entity');
Line: 4811

     IF (G_Delayed_Requests(i).request_type = OE_GLOBALS.G_DELETE_OPTION) THEN --Bug # 12316022
	config_req_id := i;
Line: 4825

        oe_debug_pub.add('Delete above request');
Line: 4828

	-- delete records in requesting entity tables with this request
	j := G_Requesting_Entities.first;
Line: 4832

 		  G_Requesting_Entities.Delete(j);
Line: 4837

	-- delete the delayed request
	   G_Delayed_Requests.Delete(i);
Line: 4851

IF NOT p_delete_against THEN
   IF l_debug_level > 0 THEN
   oe_debug_pub.add('Delete against is FALSE');
Line: 4871

	-- initialize request delete to TRUE
	request_delete := TRUE;
Line: 4874

	-- set the delete to FALSE if there are other entities that
	-- logged the same request but if the same entity has logged this
	-- request, then delete in the requesting entities table

	j := G_Requesting_Entities.first;
Line: 4889

 		  G_Requesting_Entities.Delete(j);
Line: 4891

		  request_delete := FALSE;
Line: 4898

	IF request_delete
           AND G_Delayed_Requests.Exists(req_ind) THEN
              IF l_debug_level > 0 THEN
              oe_debug_pub.add('Delete following request =>');
Line: 4920

	   G_Delayed_Requests.Delete(req_ind);
Line: 4945

	    ,'Delete_Reqs_for_Deleted_Entity');
Line: 4950

End Delete_Reqs_for_Deleted_Entity;
Line: 4998

          SELECT ato_line_id
          INTO   l_ato_line_id
          FROM   oe_order_lines
          WHERE  line_id = G_Delayed_Requests(K).entity_id;
Line: 5007

            G_Delayed_Requests.DELETE(K);
Line: 5045

          SELECT ato_line_id
          INTO   l_ato_line_id
          FROM   oe_order_lines
          WHERE  line_id = G_Delayed_Requests(K).entity_id;
Line: 5067

        G_Delayed_Requests.DELETE(K);
Line: 5363

            delete_request(p_entity_code         => p_request_rec.entity_code,
                           p_entity_id           => p_request_rec.entity_id,
                           p_request_type        => p_request_rec.request_type,
                           p_request_unique_key1 => 'BATCH',
                           p_request_unique_key2 => 'Y',
                           x_return_status       => l_return_status);
Line: 5390

           oe_debug_pub.add('delete all other price_order request.',1);
Line: 5392

        delete_request(p_entity_code   =>OE_GLOBALS.G_ENTITY_ALL,
                       p_entity_id     => p_request_rec.entity_id,
                       p_request_type  => p_request_rec.request_type,
                       p_request_unique_key1 => 'ORDER',
                       x_return_status => l_return_status);
Line: 5397

        delete_request(p_entity_code   =>OE_GLOBALS.G_ENTITY_ALL,
                       p_entity_id     => p_request_rec.entity_id,
                       p_request_type  => p_request_rec.request_type,
                       p_request_unique_key1 => 'BATCH',
                       x_return_status => l_return_status);
Line: 5405

        delete_request(p_entity_code   =>OE_GLOBALS.G_ENTITY_ALL,
                       p_entity_id     => p_request_rec.entity_id,
                       p_request_type  => p_request_rec.request_type,
                       p_request_unique_key1 => 'ORDER,BOOK',
                       x_return_status => l_return_status);
Line: 5410

        delete_request(p_entity_code   =>OE_GLOBALS.G_ENTITY_ALL,
                       p_entity_id     => p_request_rec.entity_id,
                       p_request_type  => p_request_rec.request_type,
                       p_request_unique_key1 => 'BATCH,BOOK',
                       x_return_status => l_return_status);
Line: 5471

               oe_debug_pub.add('need to have two separate requests ORDER,BOOK + N and LINE + Y and delete BATCH,BOOK + Y',1);
Line: 5473

            delete_request(p_entity_code     => p_request_rec.entity_code,
                       p_entity_id           => p_request_rec.entity_id,
                       p_request_type        => p_request_rec.request_type,
                       p_request_unique_key1 => 'BATCH,BOOK',
                       p_request_unique_key2 => 'Y',
                       x_return_status       => l_return_status);
Line: 5555

                   oe_debug_pub.add('Delete Line',3);
Line: 5557

                delete_request(p_entity_code         => p_request_rec.entity_code,
                               p_entity_id           => p_request_rec.entity_id,
                               p_request_type        => p_request_rec.request_type,
                               p_request_unique_key1 => 'LINE',
                               p_request_unique_key2 => NULL,
                               x_return_status       => l_return_status);