DBA Data[Home] [Help]

APPS.QP_DELAYED_REQUESTS_PVT SQL Statements

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

Line: 29

   should be inserted.
*/
Procedure  Check_for_Request( p_entity_code    in Varchar2
			      ,p_entity_id     in Number
			      ,p_request_type  in Varchar2
			      ,p_request_unique_key1 	IN VARCHAR2
			      ,p_request_unique_key2 	IN VARCHAR2
			      ,p_request_unique_key3 	IN VARCHAR2
			      ,p_request_unique_key4 	IN VARCHAR2
			      ,p_request_unique_key5 	IN VARCHAR2
			      ,x_request_ind   OUT NOCOPY Number
			      ,x_result        OUT NOCOPY Varchar2
			      ,x_return_status OUT NOCOPY Varchar2)
  IS
     l_ind	pls_integer;
Line: 127

   ,p_delete            IN Varchar2 default  FND_API.G_FALSE
   ,x_return_status	OUT NOCOPY VARCHAR2)
IS
l_request_rec       QP_QUALIFIER_RULES_PUB.request_rec_type;
Line: 138

l_deleted_options_tbl  QP_QUALIFIER_RULES_PUB.request_tbl_type;
Line: 139

l_updated_options_tbl  QP_QUALIFIER_RULES_PUB.request_tbl_type;
Line: 387

      IF l_request_type =  QP_GLOBALS.G_UPDATE_LIST_QUAL_IND
	   THEN

           --dbms_output.put_line('calling list qualification indicator');
Line: 391

           QP_DELAYED_REQUESTS_UTIL.Update_List_Qualification_Ind
           ( p_List_header_ID             => l_entity_id
             ,x_return_status             => l_return_status);
Line: 402

       IF l_request_type =  QP_GLOBALS.G_UPDATE_LIMITS_COLUMNS
       THEN

           --dbms_output.put_line('calling UPDATE_LIMITS_COLUMNS');
Line: 406

           QP_DELAYED_REQUESTS_UTIL.Update_Limits_Columns
           ( p_Limit_Id         	    => l_entity_id
             ,x_return_status               => l_return_status);
Line: 417

       IF l_request_type =  QP_GLOBALS.G_UPDATE_QUALIFIER_STATUS
       THEN
           --dbms_output.put_line('calling UPDATE_QUALIFIER_STATUS ');
Line: 420

           QP_DELAYED_REQUESTS_UTIL.Update_Qualifier_Status
           ( p_list_header_id         	    => l_entity_id
            ,p_active_flag         	    => l_request_rec.param1
            ,x_return_status                => l_return_status);
Line: 447

       IF l_request_type =  QP_GLOBALS.G_UPDATE_ATTRIBUTE_STATUS
       THEN
           --dbms_output.put_line('calling UPDATE_ATTRIBUTE_STATUS ');
Line: 450

           QP_DELAYED_REQUESTS_UTIL.Update_Attribute_Status
           ( p_list_header_id         	    => l_entity_id
            ,p_list_line_id          	    => l_request_rec.param1
            ,p_context_type          	    => l_request_rec.param2
            ,p_context_code          	    => l_request_rec.param3
            ,p_segment_mapping_column  	    => l_request_rec.param4
            ,x_return_status                => l_return_status);
Line: 466

      IF l_request_type = QP_GLOBALS.G_UPDATE_CHILD_BREAKS
	 THEN
	   QP_DELAYED_REQUESTS_UTIL.update_child_break_lines(
		p_list_line_id  => l_entity_id,
		x_return_status => l_return_status);
Line: 479

      IF l_request_type = QP_GLOBALS.G_UPDATE_CHILD_PRICING_ATTR
	 THEN
	   QP_DELAYED_REQUESTS_UTIL.update_child_pricing_attr(
		x_return_status => l_return_status,
		p_list_line_id  => l_entity_id);
Line: 494

      IF l_request_type = QP_GLOBALS.G_UPDATE_PRICING_ATTR_PHASE
	 THEN
	   BEGIN	--[Bug 4457903] Call update_pricing_attr_phase only if
			--the line id is present in the QP_LIST_LINES table
	     SELECT 1 into l_count from QP_LIST_LINES
	     WHERE LIST_LINE_ID = l_entity_id;
Line: 506

	     QP_DELAYED_REQUESTS_UTIL.update_pricing_attr_phase(
	  	  p_list_line_id  => l_entity_id,
		  x_return_status => l_return_status);
Line: 558

      IF l_request_type =  QP_GLOBALS.G_UPDATE_LINE_QUAL_IND
	   THEN

           --dbms_output.put_line('calling line qualification indicator');
Line: 562

             QP_DELAYED_REQUESTS_UTIL.Update_Line_Qualification_Ind
             ( p_List_line_ID              => l_entity_id
	       ,x_return_status             => l_return_status);
Line: 573

/*included by spgopal for pricing phase seeded data over-write problem to update the denormalised columns in  QP_PRICING_PHASES*/

      IF l_request_type = QP_GLOBALS.G_UPDATE_PRICING_PHASE
	 THEN
		oe_debug_pub.add('processing req UPDATE_PRICING_PHASE');
Line: 578

	   QP_DELAYED_REQUESTS_UTIL.update_pricing_phase(
		p_pricing_phase_id  => l_request_rec.param1,
                p_automatic_flag    => l_request_rec.param2, --fix for bug 3756625
                p_count       => l_request_rec.param3,
                p_call_from  => l_request_rec.param4,
		x_return_status => l_return_status);
Line: 593

      IF l_request_type = QP_GLOBALS.G_UPDATE_MANUAL_MODIFIER_FLAG
         THEN
           oe_debug_pub.add('processing req UPDATE_MANUAL_MODIFIER_FLAG');
Line: 596

           QP_DELAYED_REQUESTS_UTIL.Update_manual_modifier_flag(
                p_pricing_phase_id  => l_request_rec.param1,
                p_automatic_flag => l_request_rec.param2,
                x_return_status => l_return_status);
Line: 609

      IF l_request_type = QP_GLOBALS.G_UPDATE_HVOP
         THEN
           oe_debug_pub.add('processing req UPDATE_HVOP');
Line: 802

	if l_request_type = QP_GLOBALS.G_UPDATE_CHANGED_LINES_ADD then
		oe_debug_pub.add('processing req G_UPDATE_CHANGED_LINES_ADD');
Line: 804

		QP_DELAYED_REQUESTS_UTIL.update_changed_lines_add(
		    p_list_line_id => l_entity_id,
			p_list_header_id => l_request_rec.param2,
			p_pricing_phase_id => l_request_rec.param1,
			x_return_status => l_return_status);
Line: 809

	elsif l_request_type = QP_GLOBALS.G_UPDATE_CHANGED_LINES_DEL then
		oe_debug_pub.add('processing req G_UPDATE_CHANGED_LINES_DEL');
Line: 811

		QP_DELAYED_REQUESTS_UTIL.update_changed_lines_del(
		    p_list_line_id => l_entity_id,
			p_list_header_id => l_request_rec.param2,
			p_pricing_phase_id => l_request_rec.param1,
			p_product_attribute => l_request_rec.param3,
			p_product_attr_value => l_request_rec.param4,
			x_return_status => l_return_status);
Line: 818

	elsif l_request_type = QP_GLOBALS.G_UPDATE_CHANGED_LINES_PH then
		oe_debug_pub.add('processing req G_UPDATE_CHANGED_LINES_PHASE');
Line: 820

		QP_DELAYED_REQUESTS_UTIL.update_changed_lines_ph(
		    p_list_line_id => l_entity_id,
			p_list_header_id => l_request_rec.param2,
			p_pricing_phase_id => l_request_rec.param1,
			p_old_pricing_phase_id => l_request_rec.param3,
			x_return_status => l_return_status);
Line: 826

	elsif l_request_type = QP_GLOBALS.G_UPDATE_CHANGED_LINES_ACT then
		oe_debug_pub.add('processing req G_UPDATE_CHANGED_LINES_ACTIVE');
Line: 828

		QP_DELAYED_REQUESTS_UTIL.update_changed_lines_act(
			p_list_header_id => l_entity_id,
			p_active_flag => l_request_rec.param1,
			x_return_status => l_return_status);
Line: 833

                oe_debug_pub.add('processing req G_UPDATE_HVOP')
;
Line: 847

       IF (p_delete = FND_API.G_TRUE) then

          G_Delayed_Requests.Delete(p_request_ind);
Line: 851

       BUG 2502849- do not delete from req entities table
       , delete table in the end when all requests are processed
       This is 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: 866

		G_Requesting_Entities.Delete(l_req_entity_ind);
Line: 1035

       ELSE					   -- insert the new request
	OE_Debug_PUB.ADD('New request inserted');
Line: 1114

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: 1130

   oe_debug_pub.add('Entering Procedure Delete_Request in Package QP_Delayed_Requests_Pvt');
Line: 1153

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

/*      BUG 2502849- do not delete from req entities table
       , delete table in the end when all requests are processed
       This is 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: 1169

                G_Requesting_Entities.Delete(l_req_entity_ind);
Line: 1190

	    ,'DeleteRequest');
Line: 1195

End Delete_Request;
Line: 1205

      G_Delayed_Requests.DELETE;
Line: 1206

      g_requesting_entities.DELETE;
Line: 1230

                        ,p_delete                 IN Varchar2 Default
											FND_API.G_TRUE
                        ,x_return_status     OUT NOCOPY Varchar2)
IS
l_request_ind          Number;
Line: 1263

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

     ,p_delete            in Varchar2 Default FND_API.G_TRUE
     ,x_return_status     OUT NOCOPY Varchar2) IS
l_return_status        Varchar2(30);
Line: 1330

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

           ,p_delete         in Varchar2 Default FND_API.G_TRUE
           ,x_return_status  OUT NOCOPY Varchar2
          ) IS
l_return_status        Varchar2(30);
Line: 1390

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

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

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

        (p_request_type   =>QP_GLOBALS.G_UPDATE_PRICING_ATTR_PHASE
        ,p_delete        => FND_API.G_TRUE
         ,x_return_status => l_return_status
        );
Line: 1482

/*included by spgopal for pricing phase seeded data over-write problem to update the denormalised columns in  QP_PRICING_PHASES*/

   	Process_Request_for_ReqType
        (p_request_type   =>QP_GLOBALS.G_UPDATE_PRICING_PHASE
        ,p_delete        => FND_API.G_TRUE
         ,x_return_status => l_return_status
        );
Line: 1498

        (p_request_type   =>QP_GLOBALS.G_UPDATE_PRICING_PHASE
        ,p_delete        => FND_API.G_TRUE
         ,x_return_status => l_return_status
        );
Line: 1512

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

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

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

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

        (p_request_type   =>QP_GLOBALS.G_UPDATE_LIST_QUAL_IND
        ,p_delete        => FND_API.G_TRUE
         ,x_return_status => l_return_status
        );
Line: 1569

        (p_request_type   =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND
        ,p_delete        => FND_API.G_TRUE
         ,x_return_status => l_return_status
        );
Line: 1580

        (p_request_type   =>QP_GLOBALS.G_UPDATE_LIMITS_COLUMNS
        ,p_delete        => FND_API.G_TRUE
         ,x_return_status => l_return_status
        );
Line: 1591

        (p_request_type   =>QP_GLOBALS.G_UPDATE_QUALIFIER_STATUS
        ,p_delete        => FND_API.G_TRUE
         ,x_return_status => l_return_status
        );
Line: 1603

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

        (p_request_type   =>QP_GLOBALS.G_UPDATE_ATTRIBUTE_STATUS
        ,p_delete        => FND_API.G_TRUE
         ,x_return_status => l_return_status
        );
Line: 1624

        (p_request_type   =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND
        ,p_delete        => FND_API.G_TRUE
         ,x_return_status => l_return_status
        );
Line: 1636

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

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

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

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

        (p_request_type   =>QP_GLOBALS.G_UPDATE_CHANGED_LINES_ADD
		,p_delete        => FND_API.G_TRUE
         ,x_return_status => l_return_status
        );
Line: 1697

        (p_request_type   =>QP_GLOBALS.G_UPDATE_CHANGED_LINES_DEL
		,p_delete        => FND_API.G_TRUE
         ,x_return_status => l_return_status
        );
Line: 1708

        (p_request_type   =>QP_GLOBALS.G_UPDATE_CHANGED_LINES_ACT
		,p_delete        => FND_API.G_TRUE
         ,x_return_status => l_return_status
        );
Line: 1719

        (p_request_type   =>QP_GLOBALS.G_UPDATE_CHANGED_LINES_PH
		,p_delete        => FND_API.G_TRUE
         ,x_return_status => l_return_status
        );
Line: 1735

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

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

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

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

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

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

Procedure Delete_Reqs_for_Deleted_Entity ( p_entity_code	IN Varchar2
					,   p_entity_id       in Number
					,   x_return_status   OUT NOCOPY Varchar2)
IS
     i			       	number;
Line: 1850

     request_delete		BOOLEAN;
Line: 1867

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

 		  G_Requesting_Entities.Delete(j);
Line: 1876

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

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

	-- 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: 1911

 		  G_Requesting_Entities.Delete(j);
Line: 1913

		  request_delete := FALSE;
Line: 1920

	IF request_delete
               AND G_Delayed_Requests.Exists(req_ind) THEN
	   G_Delayed_Requests.Delete(req_ind);
Line: 1946

	    ,'Delete_Reqs_for_Deleted_Entity');
Line: 1951

End Delete_Reqs_for_Deleted_Entity;