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_BLANKET_FORM_CONTROL SQL Statements

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

Line: 268


           Select meaning
                  INTO p_header_val_rec.shipping_method
           FROM   oe_ship_methods_v
           WHERE  lookup_code=p_header_rec.shipping_method_code;

Line: 389


           Select meaning
                  INTO p_Line_val_rec.shipping_method
           FROM   oe_ship_methods_v
           WHERE  lookup_code=p_line_rec.shipping_method_code;

Line: 484


         Update_Header_Cache(p_header_rec);

Line: 583


         Update_Line_Cache(p_line_rec);

Line: 641


     PROCEDURE Insert_Row
----------------------------------------------------------
     (p_header_rec     IN OUT NOCOPY  OE_Blanket_PUB.Header_rec_type,
      x_return_status  OUT NOCOPY VARCHAR2,
      x_msg_count      OUT NOCOPY NUMBER,
      x_msg_data       OUT NOCOPY VARCHAR2
     )
     IS
       l_api_name         CONSTANT VARCHAR2(30)         := 'Insert_Row';

Line: 653


         oe_debug_pub.add('Entering Header OE_Blanket_Form_Control.Insert_row', 1);

Line: 655


         OE_Blanket_Util.Insert_Row(p_header_rec,X_RETURN_STATUS);

Line: 667


         oe_debug_pub.add('Entering Header OE_Blanket_Form_Control.Insert_row', 1);

Line: 708


     End Insert_Row;

Line: 712


     PROCEDURE Update_Row
----------------------------------------------------------
     (p_header_rec     IN  OUT NOCOPY OE_Blanket_PUB.Header_rec_type,
      x_return_status  OUT NOCOPY VARCHAR2,
      x_msg_count      OUT NOCOPY NUMBER,
      x_msg_data       OUT NOCOPY VARCHAR2
     )
     IS
       l_api_name         CONSTANT VARCHAR2(30)     := 'Update_Row';

Line: 725


         oe_debug_pub.add('Entering Header OE_Blanket_Form_Control.Update_row', 1);

Line: 727


         OE_Blanket_Util.Update_Row(p_header_rec,X_RETURN_STATUS);

Line: 739


         oe_debug_pub.add('Existing Header OE_Blanket_Form_Control.Update_row', 1);

Line: 781


     End Update_Row;

Line: 784


     PROCEDURE Delete_Row
----------------------------------------------------------
     (p_header_id     IN NUMBER,
      x_return_status  OUT NOCOPY VARCHAR2,
      x_msg_count      OUT NOCOPY NUMBER,
      x_msg_data       OUT NOCOPY VARCHAR2
     )
     IS
       l_api_name         CONSTANT VARCHAR2(30)         := 'Delete_Row';

Line: 798


         oe_debug_pub.add('Entering Header OE_Blanket_Form_Control.Delete_row', 1);

Line: 800


         OE_Blanket_Util.Delete_Row(p_header_id => p_header_id
				,X_RETURN_STATUS => x_return_status);

Line: 813


         oe_debug_pub.add('Exiting Header OE_Blanket_Form_Control.Delete_row', 1);

Line: 854


     End Delete_Row;

Line: 858


     PROCEDURE Insert_Row
----------------------------------------------------------
     (p_line_rec       IN  OUT NOCOPY OE_Blanket_PUB.line_rec_type,
      x_return_status  OUT NOCOPY  VARCHAR2,
      x_msg_count      OUT NOCOPY NUMBER,
      x_msg_data       OUT NOCOPY VARCHAR2
     )
     IS
       l_api_name         CONSTANT VARCHAR2(30)     := 'Update_Row';

Line: 870


         oe_debug_pub.add('Entering Lines OE_Blanket_Form_Control.Insert_row', 1);

Line: 872


         OE_Blanket_Util.Insert_Row(p_line_rec,X_RETURN_STATUS);

Line: 884


         oe_debug_pub.add('Existing Lines OE_Blanket_Form_Control.Insert_row', 1);

Line: 925


     End Insert_Row;

Line: 929


     PROCEDURE Update_Row
----------------------------------------------------------
     (   p_line_rec       IN  OUT NOCOPY OE_Blanket_PUB.line_rec_type,
         x_return_status  OUT  NOCOPY  VARCHAR2,
         x_msg_count      OUT  NOCOPY NUMBER,
         x_msg_data       OUT  NOCOPY VARCHAR2
     )
     IS
       l_api_name         CONSTANT VARCHAR2(30)     := 'Update_Row';

Line: 941


         oe_debug_pub.add('Entering Lines OE_Blanket_Form_Control.Update_row', 1);

Line: 942


         OE_Blanket_Util.Update_Row(p_line_rec,X_RETURN_STATUS);

Line: 954


         oe_debug_pub.add('Existing Lines OE_Blanket_Form_Control.Update_row', 1);

Line: 995


     End Update_Row;

Line: 998


     PROCEDURE Delete_Row
----------------------------------------------------------
     (p_line_id       IN NUMBER,
      x_return_status  OUT NOCOPY  VARCHAR2,
      x_msg_count      OUT NOCOPY NUMBER,
      x_msg_data       OUT NOCOPY VARCHAR2
     )
     IS
       l_api_name         CONSTANT VARCHAR2(30)     := 'Delete_Row';

Line: 1011


         oe_debug_pub.add('Entering Lines OE_Blanket_Form_Control.Delete_row', 1);

Line: 1013


         OE_Blanket_Util.Delete_Row(p_line_id => p_line_id
				,x_return_status => X_RETURN_STATUS);

Line: 1026


         oe_debug_pub.add('Exiting Lines OE_Blanket_Form_Control.Delete_row', 1);

Line: 1067


     End Delete_Row;

Line: 1088


         g_line_cache_rec.delete;

Line: 1256


        (OE_GLOBALS.G_OPR_CREATE,OE_GLOBALS.G_OPR_UPDATE) then
		IF G_header_cache_rec(ctr).operation =OE_GLOBALS.G_OPR_CREATE
		THEN
        	l_dummy_header_rec := NULL;

Line: 1261


				=OE_GLOBALS.G_OPR_UPDATE THEN
                	OE_Blanket_util.Query_Header(
              				p_header_id =>G_header_cache_rec(ctr).header_id,
              				x_header_rec =>l_dummy_header_Rec,
              		 		x_return_status =>l_return_status);

Line: 1297


        (OE_GLOBALS.G_OPR_CREATE,OE_GLOBALS.G_OPR_UPDATE) then
		If G_line_cache_rec(ctr).operation = OE_GLOBALS.G_OPR_CREATE
		THEN
        	l_dummy_line_rec := NULL;

Line: 1301


		ELSIF G_line_cache_rec(ctr).operation = OE_GLOBALS.G_OPR_UPDATE
		THEN
		l_dummy_line_rec := OE_Blanket_util.Query_Row(p_line_id => 											G_LIne_cache_rec(ctr).line_id);

Line: 1347


              If G_header_cache_rec(ctr).operation = OE_GLOBALS.G_OPR_UPDATE then
                 oe_debug_pub.add('Operation in Update Condi: '||G_header_cache_rec(ctr).operation);

Line: 1349


                 OE_Blanket_Util.Update_Row(G_header_Cache_Rec(ctr),x_return_status);

Line: 1351


                 oe_debug_pub.add('Operation IN Insert Condi: '||G_header_cache_rec(ctr).operation);

Line: 1352


                 OE_Blanket_Util.Insert_Row(G_header_Cache_Rec(ctr),x_return_status);

Line: 1361


              ElsIf G_header_cache_rec(ctr).operation = OE_GLOBALS.G_OPR_DELETE then
                    oe_debug_pub.add('Operation IS Delete Condi: '||G_header_cache_rec(ctr).operation);

Line: 1363


                    OE_Blanket_Util.Delete_Row(p_header_id     => G_header_Cache_Rec(ctr).header_id,
                                               x_return_status => x_return_status);

Line: 1398


               If G_line_cache_rec(ctr).operation = OE_GLOBALS.G_OPR_UPDATE then
                  oe_debug_pub.add('Process_object for Lines update', 4);

Line: 1400


                  OE_Blanket_Util.Update_Row(G_line_Cache_Rec(ctr),x_return_status);

Line: 1402


                  oe_debug_pub.add('Process_object for Lines Insert', 5);

Line: 1403


                  OE_Blanket_Util.Insert_Row(G_line_Cache_Rec(ctr),x_return_status);

Line: 1405


               ElsIf G_line_cache_rec(ctr).operation = OE_GLOBALS.G_OPR_DELETE then
                  oe_debug_pub.add('Process_object for Lines Delete', 6);

Line: 1407


                  OE_Blanket_Util.Delete_Row(p_line_id => G_line_Cache_Rec(ctr).line_id, x_return_status => x_return_status);

Line: 1438


            g_header_cache_rec.delete;

Line: 1439


            g_line_cache_rec.delete;

Line: 1530


              elsif p_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE then
                 l_operation := OE_PC_GLOBALS.UPDATE_OP;

Line: 1822


     PROCEDURE Update_Header_Cache
----------------------------------------------------------
     (p_x_header_rec            IN OUT NOCOPY OE_Blanket_PUB.header_rec_type,
      delete_flag               IN            Varchar2 )
     IS
         ctr                    number;

Line: 1832


         oe_debug_pub.add('Entering Update_Header_Cache OE_Blanket_Form_Control.Update_Header_Cache ', 0);

Line: 1849


            oe_debug_pub.add('Update_Header_Cache is Zero ', 1);

Line: 1850


            if delete_flag <> 'Y' THEN
               G_Header_Cache_Rec(ctr) := p_x_header_rec;

Line: 1854


            oe_debug_pub.add('Update_Header_Cache is greater then Zero ', 2);

Line: 1864


         /* Later change it to update only for changed attributes */

         If delete_flag = 'Y' then
            If found_flag = 'Y' then
               G_Header_Cache_Rec(ctr) := NULL;

Line: 1869


               OE_DELAYED_REQUESTS_PVT.Delete_Reqs_for_Deleted_Entity(
                         p_entity_code  => OE_BLANKET_PUB.G_ENTITY_BLANKET_HEADER
                         ,p_entity_id    => p_x_header_rec.header_id
			 , p_delete_against => FALSE
                         ,x_return_status => l_return_status);

Line: 1876


            oe_debug_pub.add('Update_Header_Cache is  OE_Blanket_Form_Control.Update_Header_Cache ', 3);

Line: 1880


         oe_debug_pub.add('Exiting Update_Header_Cache OE_Blanket_Form_Control.Update_Header_Cache ', 4);

Line: 1882


     END Update_Header_Cache;

Line: 1886


     PROCEDURE Update_Line_Cache
----------------------------------------------------------
         (p_x_line_rec            IN OUT NOCOPY OE_Blanket_PUB.line_rec_type,
          delete_flag             IN            VARCHAR2 := NULL)
     IS
         ctr                      number;

Line: 1896


         oe_debug_pub.add('Entering Update_line_Cache OE_Blanket_Form_Control.Update_line_Cache ', 0);

Line: 1902


            oe_debug_pub.add('Update_line_Cache is Zero ', 1);

Line: 1903


            if  delete_flag <> 'Y' then
                G_Line_Cache_Rec(ctr) := p_x_Line_rec;

Line: 1907


            oe_debug_pub.add('Update_line_Cache is greater then Zero ', 2);

Line: 1918


         /* Later change it to update only changed attributes */

         If delete_flag = 'Y' then

            If found_flag = 'Y' then
               OE_DELAYED_REQUESTS_PVT.Delete_Reqs_for_Deleted_Entity(
                         p_entity_code  => OE_BLANKET_PUB.G_ENTITY_BLANKET_LINE
                         ,p_entity_id    => p_x_Line_rec.Line_id
			, p_delete_against => FALSE
                         ,x_return_status => l_return_status);

Line: 1935


         oe_debug_pub.add('Exiting Update_line_Cache OE_Blanket_Form_Control.Update_line_Cache ', 4);

Line: 1936


     END Update_Line_Cache;

Line: 1947


         select order_number into dummy_id from oe_blanket_headers
         where rowid = p_row_id for update;

Line: 1961


         select line_id into dummy_id from oe_blanket_Lines
         where rowid = p_row_id for update;

Line: 1975


         select max(line_number) into l_blanket_line_number
         from oe_blanket_lines
         where header_id = l_x_header_id;

Line: 2085


                  SELECT
                          ACCOUNTING_RULE_ID
                  ,       AGREEMENT_ID
                  ,       ATTRIBUTE1
                  ,       ATTRIBUTE10
                  ,       ATTRIBUTE11
                  ,       ATTRIBUTE12
                  ,       ATTRIBUTE13
                  ,       ATTRIBUTE14
                  ,       ATTRIBUTE15
                  ,       ATTRIBUTE2
                  ,       ATTRIBUTE3
                  ,       ATTRIBUTE4
                  ,       ATTRIBUTE5
                  ,       ATTRIBUTE6
                  ,       ATTRIBUTE7
                  ,       ATTRIBUTE8
                  ,       ATTRIBUTE9
                  ,       CONTEXT
                  ,       CREATED_BY
                  ,       CREATION_DATE
                  ,       CUST_PO_NUMBER
                  ,       DELIVER_TO_ORG_ID
                  ,       FREIGHT_TERMS_CODE
                  ,       header_id
                  ,       INVENTORY_ITEM_ID
                  ,       INVOICE_TO_ORG_ID
                  ,       INVOICING_RULE_ID
                  ,       ORDERED_ITEM_ID
                  ,       ITEM_IDENTIFIER_TYPE
                  ,       ORDERED_ITEM
                  ,       ITEM_TYPE_CODE
                  ,       LAST_UPDATED_BY
                  ,       LAST_UPDATE_DATE
                  ,       LAST_UPDATE_LOGIN
                  ,       line_id
                  ,       line_number
                  ,       PAYMENT_TERM_ID
                  ,       PREFERRED_GRADE
                  ,       PRICE_LIST_ID
                  ,       PROGRAM_APPLICATION_ID
                  ,       PROGRAM_ID
                  ,       PROGRAM_UPDATE_DATE
                  ,       REQUEST_ID
                  ,       SALESREP_ID
                  ,       SHIPPING_METHOD_CODE
                  ,       ship_from_org_id
                  ,       SHIP_TO_ORG_ID
                  ,       SHIPPING_INSTRUCTIONS
                  ,       PACKING_INSTRUCTIONS
                  ,       START_DATE_ACTIVE
                  ,       END_DATE_ACTIVE
                  ,       MAX_RELEASE_AMOUNT
                  ,       MIN_RELEASE_AMOUNT
                  ,       MAX_RELEASE_QUANTITY
                  ,       MIN_RELEASE_QUANTITY
                  ,       BLANKET_LINE_MAX_AMOUNT
                  ,       BLANKET_LINE_MIN_AMOUNT
                  ,       BLANKET_MAX_QUANTITY
                  ,       BLANKET_MIN_QUANTITY
                  ,       OVERRIDE_BLANKET_CONTROLS_FLAG
                  ,       ENFORCE_PRICE_LIST_FLAG
                  ,       ORDER_QUANTITY_UOM
                  ,       RELEASED_QUANTITY
                  ,       FULFILLED_QUANTITY
                  ,       RETURNED_QUANTITY
                  ,       RELEASED_AMOUNT
                  ,       LOCK_CONTROL
                  ,       fulfilled_amount
		  ,	  transaction_phase_code   -- hashraf ... pack J
                  ,       source_document_version_number
                  INTO
                          p_x_old_line_rec.ACCOUNTING_RULE_ID
                  ,       p_x_old_line_rec.AGREEMENT_ID
                  ,       p_x_old_line_rec.ATTRIBUTE1
                  ,       p_x_old_line_rec.ATTRIBUTE10
                  ,       p_x_old_line_rec.ATTRIBUTE11
                  ,       p_x_old_line_rec.ATTRIBUTE12
                  ,       p_x_old_line_rec.ATTRIBUTE13
                  ,       p_x_old_line_rec.ATTRIBUTE14
                  ,       p_x_old_line_rec.ATTRIBUTE15
                  ,       p_x_old_line_rec.ATTRIBUTE2
                  ,       p_x_old_line_rec.ATTRIBUTE3
                  ,       p_x_old_line_rec.ATTRIBUTE4
                  ,       p_x_old_line_rec.ATTRIBUTE5
                  ,       p_x_old_line_rec.ATTRIBUTE6
                  ,       p_x_old_line_rec.ATTRIBUTE7
                  ,       p_x_old_line_rec.ATTRIBUTE8
                  ,       p_x_old_line_rec.ATTRIBUTE9
                  ,       p_x_old_line_rec.CONTEXT
                  ,       p_x_old_line_rec.CREATED_BY
                  ,       p_x_old_line_rec.CREATION_DATE
                  ,       p_x_old_line_rec.CUST_PO_NUMBER
                  ,       p_x_old_line_rec.DELIVER_TO_ORG_ID
                  ,       p_x_old_line_rec.FREIGHT_TERMS_CODE
                  ,       p_x_old_line_rec.header_id
                  ,       p_x_old_line_rec.INVENTORY_ITEM_ID
                  ,       p_x_old_line_rec.INVOICE_TO_ORG_ID
                  ,       p_x_old_line_rec.INVOICING_RULE_ID
                  ,       p_x_old_line_rec.ORDERED_ITEM_ID
                  ,       p_x_old_line_rec.ITEM_IDENTIFIER_TYPE
                  ,       p_x_old_line_rec.ORDERED_ITEM
                  ,       p_x_old_line_rec.ITEM_TYPE_CODE
                  ,       p_x_old_line_rec.LAST_UPDATED_BY
                  ,       p_x_old_line_rec.LAST_UPDATE_DATE
                  ,       p_x_old_line_rec.LAST_UPDATE_LOGIN
                  ,       p_x_old_line_rec.line_id
                  ,       p_x_old_line_rec.line_number
                  ,       p_x_old_line_rec.PAYMENT_TERM_ID
                  ,       p_x_old_line_rec.PREFERRED_GRADE
                  ,       p_x_old_line_rec.PRICE_LIST_ID
                  ,       p_x_old_line_rec.PROGRAM_APPLICATION_ID
                  ,       p_x_old_line_rec.PROGRAM_ID
                  ,       p_x_old_line_rec.PROGRAM_UPDATE_DATE
                  ,       p_x_old_line_rec.REQUEST_ID
                  ,       p_x_old_line_rec.SALESREP_ID
                  ,       p_x_old_line_rec.SHIPPING_METHOD_CODE
                  ,       p_x_old_line_rec.ship_from_org_id
                  ,       p_x_old_line_rec.SHIP_TO_ORG_ID
                  ,       p_x_old_line_rec.SHIPPING_INSTRUCTIONS
                  ,       p_x_old_line_rec.PACKING_INSTRUCTIONS
                  ,       p_x_old_line_rec.START_DATE_ACTIVE
                  ,       p_x_old_line_rec.END_DATE_ACTIVE
                  ,       p_x_old_line_rec.MAX_RELEASE_AMOUNT
                  ,       p_x_old_line_rec.MIN_RELEASE_AMOUNT
                  ,       p_x_old_line_rec.MAX_RELEASE_QUANTITY
                  ,       p_x_old_line_rec.MIN_RELEASE_QUANTITY
                  ,       p_x_old_line_rec.blanket_max_amount
                  ,       p_x_old_line_rec.blanket_min_amount
                  ,       p_x_old_line_rec.BLANKET_MAX_QUANTITY
                  ,       p_x_old_line_rec.BLANKET_MIN_QUANTITY
                  ,       p_x_old_line_rec.OVERRIDE_BLANKET_CONTROLS_FLAG
                  ,       p_x_old_line_rec.ENFORCE_PRICE_LIST_FLAG
                  ,       p_x_old_line_rec.order_quantity_UOM
                  ,       p_x_old_line_rec.RELEASED_QUANTITY
                  ,       p_x_old_line_rec.FULFILLED_QUANTITY
                  ,       p_x_old_line_rec.RETURNED_QUANTITY
                  ,       p_x_old_line_rec.RELEASED_AMOUNT
                  ,       p_x_old_line_rec.LOCK_CONTROL
                  ,       p_x_old_line_rec.fulfilled_amount
		  ,	  p_x_old_line_rec.transaction_phase_code -- hashraf pack J
		  ,	  p_x_old_line_rec.source_document_version_number
                  FROM    OE_BLANKET_LINES_V bl
                  WHERE   line_id = p_x_line_rec.line_id;

Line: 2259


               select max(line_number) into l_line_number
               from oe_blanket_lines
               where header_id = p_header_id;

Line: 2296


        select
	name into l_order_type
        from 	oe_transaction_types_vl
        where 	SALES_DOCUMENT_TYPE_CODE = 'B'
        AND     transaction_type_id = p_order_type_id;

Line: 2348


        SELECT meaning
        INTO  l_item_identifier
        FROM oe_lookups
        WHERE lookup_type = 'ITEM_IDENTIFIER_TYPE'
        AND   lookup_code = p_item_identifier_type;

Line: 2401


     FUNCTION Get_Opr_Update
----------------------------------------------------------
     RETURN varchar2
     IS
     BEGIN
         RETURN OE_GLOBALS.G_OPR_UPDATE;

Line: 2410


     FUNCTION Get_Opr_Delete
----------------------------------------------------------
     RETURN varchar2
     IS
     BEGIN
         -- hashraf new function for pack J
         RETURN OE_GLOBALS.G_OPR_DELETE;

Line: 2437


               SELECT 'TRUE'
               INTO  l_return
               FROM oe_order_headers
               WHERE blanket_number = p_blanket_number
               AND ROWNUM = 1;

Line: 2447


                    SELECT 'TRUE'
                    INTO  l_return
                    FROM oe_order_lines
                    WHERE blanket_number = p_blanket_number
                    AND ROWNUM = 1;

Line: 2500


               SELECT 'TRUE'
               INTO  l_return
               FROM oe_order_lines
               WHERE blanket_number = p_blanket_number
               AND BLANKET_LINE_NUMBER = p_blanket_line_number
               AND rownum = 1;

Line: 2574


               SELECT 'TRUE'
               INTO  l_return
               FROM  oe_blanket_headers_all
               WHERE order_number     = p_blanket_number
               AND   version_number   = p_version_number
               AND   rownum           = 1;

Line: 2630


       g_header_cache_rec.delete;

Line: 2633


       g_line_cache_rec.delete;

Line: 2673


               SELECT DEF_TRANSACTION_PHASE_CODE
               INTO  l_return
               FROM oe_transaction_types_all
               WHERE TRANSACTION_TYPE_ID = p_order_type_id;