12:
13: /*-- Start of Comments
14: -- Package name : ASO_QUOTE_EBIZAD
15: -- Purpose :
16: -- These public APIs wrapper for the ASO_QUOTE_PUB.CREATE_QUOTE_SERVICE. The wrapper exposes this service to be invoked from the Oracle Apps Adapter by using the SQL
17: -- Object types for the parameter instead of the PL SQL Record types. This is done by defining the Functions to convert from SQL Object type to and from PL SQL Object
18: -- type and in the CREATE_QUOTE_SERVICE procedure invokes the ASO_QUOTE_PUB.CREATE_QUOTE_SERVICE after doing the required convertion from the SQL object type to
19: --PL/SQL record type. The return values from ASO_QUOTE_PUB.CREATE_QUOTE_SERVICE is converted from PL/SQL Record Type to SQL Object types.
20: --
14: -- Package name : ASO_QUOTE_EBIZAD
15: -- Purpose :
16: -- These public APIs wrapper for the ASO_QUOTE_PUB.CREATE_QUOTE_SERVICE. The wrapper exposes this service to be invoked from the Oracle Apps Adapter by using the SQL
17: -- Object types for the parameter instead of the PL SQL Record types. This is done by defining the Functions to convert from SQL Object type to and from PL SQL Object
18: -- type and in the CREATE_QUOTE_SERVICE procedure invokes the ASO_QUOTE_PUB.CREATE_QUOTE_SERVICE after doing the required convertion from the SQL object type to
19: --PL/SQL record type. The return values from ASO_QUOTE_PUB.CREATE_QUOTE_SERVICE is converted from PL/SQL Record Type to SQL Object types.
20: --
21: -- History : In SQL_TO_PL27 ORGANIZATION_ID is set to FND_API.G_MISS_NUM if NULL to avoid error in creating quote with line items.
22: -- In CREATE_QUOTE_SERVICE call to po_moac_utils_pvt.set_org_context(P_QTE_HEADER_REC_.ORG_ID); added
15: -- Purpose :
16: -- These public APIs wrapper for the ASO_QUOTE_PUB.CREATE_QUOTE_SERVICE. The wrapper exposes this service to be invoked from the Oracle Apps Adapter by using the SQL
17: -- Object types for the parameter instead of the PL SQL Record types. This is done by defining the Functions to convert from SQL Object type to and from PL SQL Object
18: -- type and in the CREATE_QUOTE_SERVICE procedure invokes the ASO_QUOTE_PUB.CREATE_QUOTE_SERVICE after doing the required convertion from the SQL object type to
19: --PL/SQL record type. The return values from ASO_QUOTE_PUB.CREATE_QUOTE_SERVICE is converted from PL/SQL Record Type to SQL Object types.
20: --
21: -- History : In SQL_TO_PL27 ORGANIZATION_ID is set to FND_API.G_MISS_NUM if NULL to avoid error in creating quote with line items.
22: -- In CREATE_QUOTE_SERVICE call to po_moac_utils_pvt.set_org_context(P_QTE_HEADER_REC_.ORG_ID); added
23: -- NOTE :
25: -- End of Comments
26: */
27:
28:
29: FUNCTION PL_TO_SQL19(aPlsqlItem ASO_QUOTE_PUB.CONTROL_REC_TYPE)
30: RETURN ASO_QUOTE_PUB_CONTROL_REC_TYP IS
31: aSqlItem ASO_QUOTE_PUB_CONTROL_REC_TYP;
32: BEGIN
33: -- initialize the object
26: */
27:
28:
29: FUNCTION PL_TO_SQL19(aPlsqlItem ASO_QUOTE_PUB.CONTROL_REC_TYPE)
30: RETURN ASO_QUOTE_PUB_CONTROL_REC_TYP IS
31: aSqlItem ASO_QUOTE_PUB_CONTROL_REC_TYP;
32: BEGIN
33: -- initialize the object
34: aSqlItem := ASO_QUOTE_PUB_CONTROL_REC_TYP(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
27:
28:
29: FUNCTION PL_TO_SQL19(aPlsqlItem ASO_QUOTE_PUB.CONTROL_REC_TYPE)
30: RETURN ASO_QUOTE_PUB_CONTROL_REC_TYP IS
31: aSqlItem ASO_QUOTE_PUB_CONTROL_REC_TYP;
32: BEGIN
33: -- initialize the object
34: aSqlItem := ASO_QUOTE_PUB_CONTROL_REC_TYP(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
35: aSqlItem.LAST_UPDATE_DATE := aPlsqlItem.LAST_UPDATE_DATE;
30: RETURN ASO_QUOTE_PUB_CONTROL_REC_TYP IS
31: aSqlItem ASO_QUOTE_PUB_CONTROL_REC_TYP;
32: BEGIN
33: -- initialize the object
34: aSqlItem := ASO_QUOTE_PUB_CONTROL_REC_TYP(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
35: aSqlItem.LAST_UPDATE_DATE := aPlsqlItem.LAST_UPDATE_DATE;
36: aSqlItem.AUTO_VERSION_FLAG := aPlsqlItem.AUTO_VERSION_FLAG;
37: aSqlItem.PRICING_REQUEST_TYPE := aPlsqlItem.PRICING_REQUEST_TYPE;
38: aSqlItem.HEADER_PRICING_EVENT := aPlsqlItem.HEADER_PRICING_EVENT;
51: aSqlItem.DEFAULTING_FWK_FLAG := aPlsqlItem.DEFAULTING_FWK_FLAG;
52: aSqlItem.APPLICATION_TYPE_CODE := aPlsqlItem.APPLICATION_TYPE_CODE;
53: RETURN aSqlItem;
54: END PL_TO_SQL19;
55: FUNCTION SQL_TO_PL0(aSqlItem ASO_QUOTE_PUB_CONTROL_REC_TYP)
56: RETURN ASO_QUOTE_PUB.CONTROL_REC_TYPE IS
57: aPlsqlItem ASO_QUOTE_PUB.CONTROL_REC_TYPE;
58: BEGIN
59: aPlsqlItem.LAST_UPDATE_DATE := aSqlItem.LAST_UPDATE_DATE;
52: aSqlItem.APPLICATION_TYPE_CODE := aPlsqlItem.APPLICATION_TYPE_CODE;
53: RETURN aSqlItem;
54: END PL_TO_SQL19;
55: FUNCTION SQL_TO_PL0(aSqlItem ASO_QUOTE_PUB_CONTROL_REC_TYP)
56: RETURN ASO_QUOTE_PUB.CONTROL_REC_TYPE IS
57: aPlsqlItem ASO_QUOTE_PUB.CONTROL_REC_TYPE;
58: BEGIN
59: aPlsqlItem.LAST_UPDATE_DATE := aSqlItem.LAST_UPDATE_DATE;
60: aPlsqlItem.AUTO_VERSION_FLAG := aSqlItem.AUTO_VERSION_FLAG;
53: RETURN aSqlItem;
54: END PL_TO_SQL19;
55: FUNCTION SQL_TO_PL0(aSqlItem ASO_QUOTE_PUB_CONTROL_REC_TYP)
56: RETURN ASO_QUOTE_PUB.CONTROL_REC_TYPE IS
57: aPlsqlItem ASO_QUOTE_PUB.CONTROL_REC_TYPE;
58: BEGIN
59: aPlsqlItem.LAST_UPDATE_DATE := aSqlItem.LAST_UPDATE_DATE;
60: aPlsqlItem.AUTO_VERSION_FLAG := aSqlItem.AUTO_VERSION_FLAG;
61: aPlsqlItem.PRICING_REQUEST_TYPE := aSqlItem.PRICING_REQUEST_TYPE;
75: aPlsqlItem.DEFAULTING_FWK_FLAG := aSqlItem.DEFAULTING_FWK_FLAG;
76: aPlsqlItem.APPLICATION_TYPE_CODE := aSqlItem.APPLICATION_TYPE_CODE;
77: RETURN aPlsqlItem;
78: END SQL_TO_PL0;
79: FUNCTION PL_TO_SQL0(aPlsqlItem ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE)
80: RETURN ASO_QUOTE_PUB_QTE_HEADER_REC_ IS
81: aSqlItem ASO_QUOTE_PUB_QTE_HEADER_REC_;
82: BEGIN
83: -- initialize the object
76: aPlsqlItem.APPLICATION_TYPE_CODE := aSqlItem.APPLICATION_TYPE_CODE;
77: RETURN aPlsqlItem;
78: END SQL_TO_PL0;
79: FUNCTION PL_TO_SQL0(aPlsqlItem ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE)
80: RETURN ASO_QUOTE_PUB_QTE_HEADER_REC_ IS
81: aSqlItem ASO_QUOTE_PUB_QTE_HEADER_REC_;
82: BEGIN
83: -- initialize the object
84: aSqlItem := ASO_QUOTE_PUB_QTE_HEADER_REC_(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
77: RETURN aPlsqlItem;
78: END SQL_TO_PL0;
79: FUNCTION PL_TO_SQL0(aPlsqlItem ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE)
80: RETURN ASO_QUOTE_PUB_QTE_HEADER_REC_ IS
81: aSqlItem ASO_QUOTE_PUB_QTE_HEADER_REC_;
82: BEGIN
83: -- initialize the object
84: aSqlItem := ASO_QUOTE_PUB_QTE_HEADER_REC_(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
85: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
80: RETURN ASO_QUOTE_PUB_QTE_HEADER_REC_ IS
81: aSqlItem ASO_QUOTE_PUB_QTE_HEADER_REC_;
82: BEGIN
83: -- initialize the object
84: aSqlItem := ASO_QUOTE_PUB_QTE_HEADER_REC_(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
85: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
86: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
87: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
88: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
229: aSqlItem.ATTRIBUTE20 := aPlsqlItem.ATTRIBUTE20;
230: aSqlItem.HEADER_PAYNOW_CHARGES := aPlsqlItem.HEADER_PAYNOW_CHARGES;
231: RETURN aSqlItem;
232: END PL_TO_SQL0;
233: FUNCTION SQL_TO_PL1(aSqlItem ASO_QUOTE_PUB_QTE_HEADER_REC_)
234: RETURN ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE IS
235: aPlsqlItem ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE;
236: BEGIN
237: aPlsqlItem.QUOTE_HEADER_ID := aSqlItem.QUOTE_HEADER_ID;
230: aSqlItem.HEADER_PAYNOW_CHARGES := aPlsqlItem.HEADER_PAYNOW_CHARGES;
231: RETURN aSqlItem;
232: END PL_TO_SQL0;
233: FUNCTION SQL_TO_PL1(aSqlItem ASO_QUOTE_PUB_QTE_HEADER_REC_)
234: RETURN ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE IS
235: aPlsqlItem ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE;
236: BEGIN
237: aPlsqlItem.QUOTE_HEADER_ID := aSqlItem.QUOTE_HEADER_ID;
238: aPlsqlItem.CREATION_DATE := aSqlItem.CREATION_DATE;
231: RETURN aSqlItem;
232: END PL_TO_SQL0;
233: FUNCTION SQL_TO_PL1(aSqlItem ASO_QUOTE_PUB_QTE_HEADER_REC_)
234: RETURN ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE IS
235: aPlsqlItem ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE;
236: BEGIN
237: aPlsqlItem.QUOTE_HEADER_ID := aSqlItem.QUOTE_HEADER_ID;
238: aPlsqlItem.CREATION_DATE := aSqlItem.CREATION_DATE;
239: aPlsqlItem.CREATED_BY := aSqlItem.CREATED_BY;
376: aPlsqlItem.ATTRIBUTE20 := aSqlItem.ATTRIBUTE20;
377: aPlsqlItem.HEADER_PAYNOW_CHARGES := aSqlItem.HEADER_PAYNOW_CHARGES;
378: RETURN aPlsqlItem;
379: END SQL_TO_PL1;
380: FUNCTION PL_TO_SQL20(aPlsqlItem ASO_QUOTE_PUB.PRICE_ATTRIBUTES_REC_TYPE)
381: RETURN ASO_QUOTE_PUB_PRICE_ATTRIBU34 IS
382: aSqlItem ASO_QUOTE_PUB_PRICE_ATTRIBU34;
383: BEGIN
384: -- initialize the object
377: aPlsqlItem.HEADER_PAYNOW_CHARGES := aSqlItem.HEADER_PAYNOW_CHARGES;
378: RETURN aPlsqlItem;
379: END SQL_TO_PL1;
380: FUNCTION PL_TO_SQL20(aPlsqlItem ASO_QUOTE_PUB.PRICE_ATTRIBUTES_REC_TYPE)
381: RETURN ASO_QUOTE_PUB_PRICE_ATTRIBU34 IS
382: aSqlItem ASO_QUOTE_PUB_PRICE_ATTRIBU34;
383: BEGIN
384: -- initialize the object
385: aSqlItem := ASO_QUOTE_PUB_PRICE_ATTRIBU34(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
378: RETURN aPlsqlItem;
379: END SQL_TO_PL1;
380: FUNCTION PL_TO_SQL20(aPlsqlItem ASO_QUOTE_PUB.PRICE_ATTRIBUTES_REC_TYPE)
381: RETURN ASO_QUOTE_PUB_PRICE_ATTRIBU34 IS
382: aSqlItem ASO_QUOTE_PUB_PRICE_ATTRIBU34;
383: BEGIN
384: -- initialize the object
385: aSqlItem := ASO_QUOTE_PUB_PRICE_ATTRIBU34(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
386: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
381: RETURN ASO_QUOTE_PUB_PRICE_ATTRIBU34 IS
382: aSqlItem ASO_QUOTE_PUB_PRICE_ATTRIBU34;
383: BEGIN
384: -- initialize the object
385: aSqlItem := ASO_QUOTE_PUB_PRICE_ATTRIBU34(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
386: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
387: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
388: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
389: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
526: aSqlItem.ATTRIBUTE20 := aPlsqlItem.ATTRIBUTE20;
527: aSqlItem.OBJECT_VERSION_NUMBER := aPlsqlItem.OBJECT_VERSION_NUMBER;
528: RETURN aSqlItem;
529: END PL_TO_SQL20;
530: FUNCTION SQL_TO_PL20(aSqlItem ASO_QUOTE_PUB_PRICE_ATTRIBU34)
531: RETURN ASO_QUOTE_PUB.PRICE_ATTRIBUTES_REC_TYPE IS
532: aPlsqlItem ASO_QUOTE_PUB.PRICE_ATTRIBUTES_REC_TYPE;
533: BEGIN
534: aPlsqlItem.OPERATION_CODE := aSqlItem.OPERATION_CODE;
527: aSqlItem.OBJECT_VERSION_NUMBER := aPlsqlItem.OBJECT_VERSION_NUMBER;
528: RETURN aSqlItem;
529: END PL_TO_SQL20;
530: FUNCTION SQL_TO_PL20(aSqlItem ASO_QUOTE_PUB_PRICE_ATTRIBU34)
531: RETURN ASO_QUOTE_PUB.PRICE_ATTRIBUTES_REC_TYPE IS
532: aPlsqlItem ASO_QUOTE_PUB.PRICE_ATTRIBUTES_REC_TYPE;
533: BEGIN
534: aPlsqlItem.OPERATION_CODE := aSqlItem.OPERATION_CODE;
535: aPlsqlItem.QTE_LINE_INDEX := aSqlItem.QTE_LINE_INDEX;
528: RETURN aSqlItem;
529: END PL_TO_SQL20;
530: FUNCTION SQL_TO_PL20(aSqlItem ASO_QUOTE_PUB_PRICE_ATTRIBU34)
531: RETURN ASO_QUOTE_PUB.PRICE_ATTRIBUTES_REC_TYPE IS
532: aPlsqlItem ASO_QUOTE_PUB.PRICE_ATTRIBUTES_REC_TYPE;
533: BEGIN
534: aPlsqlItem.OPERATION_CODE := aSqlItem.OPERATION_CODE;
535: aPlsqlItem.QTE_LINE_INDEX := aSqlItem.QTE_LINE_INDEX;
536: aPlsqlItem.PRICE_ATTRIBUTE_ID := aSqlItem.PRICE_ATTRIBUTE_ID;
671: aPlsqlItem.ATTRIBUTE20 := aSqlItem.ATTRIBUTE20;
672: aPlsqlItem.OBJECT_VERSION_NUMBER := aSqlItem.OBJECT_VERSION_NUMBER;
673: RETURN aPlsqlItem;
674: END SQL_TO_PL20;
675: FUNCTION PL_TO_SQL3(aPlsqlItem ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE)
676: RETURN ASO_QUOTE_PUB_PRICE_ATTRIBUTE IS
677: aSqlItem ASO_QUOTE_PUB_PRICE_ATTRIBUTE;
678: BEGIN
679: -- initialize the table
672: aPlsqlItem.OBJECT_VERSION_NUMBER := aSqlItem.OBJECT_VERSION_NUMBER;
673: RETURN aPlsqlItem;
674: END SQL_TO_PL20;
675: FUNCTION PL_TO_SQL3(aPlsqlItem ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE)
676: RETURN ASO_QUOTE_PUB_PRICE_ATTRIBUTE IS
677: aSqlItem ASO_QUOTE_PUB_PRICE_ATTRIBUTE;
678: BEGIN
679: -- initialize the table
680: aSqlItem := ASO_QUOTE_PUB_PRICE_ATTRIBUTE();
673: RETURN aPlsqlItem;
674: END SQL_TO_PL20;
675: FUNCTION PL_TO_SQL3(aPlsqlItem ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE)
676: RETURN ASO_QUOTE_PUB_PRICE_ATTRIBUTE IS
677: aSqlItem ASO_QUOTE_PUB_PRICE_ATTRIBUTE;
678: BEGIN
679: -- initialize the table
680: aSqlItem := ASO_QUOTE_PUB_PRICE_ATTRIBUTE();
681: IF aPlsqlItem.COUNT > 0 THEN
676: RETURN ASO_QUOTE_PUB_PRICE_ATTRIBUTE IS
677: aSqlItem ASO_QUOTE_PUB_PRICE_ATTRIBUTE;
678: BEGIN
679: -- initialize the table
680: aSqlItem := ASO_QUOTE_PUB_PRICE_ATTRIBUTE();
681: IF aPlsqlItem.COUNT > 0 THEN
682: aSqlItem.EXTEND(aPlsqlItem.COUNT);
683: FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
684: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL20(aPlsqlItem(I));
685: END LOOP;
686: END IF;
687: RETURN aSqlItem;
688: END PL_TO_SQL3;
689: FUNCTION SQL_TO_PL2(aSqlItem ASO_QUOTE_PUB_PRICE_ATTRIBUTE)
690: RETURN ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE IS
691: aPlsqlItem ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE;
692: BEGIN
693: -- Added to take care of 'reference to uninitialized collection' error.
686: END IF;
687: RETURN aSqlItem;
688: END PL_TO_SQL3;
689: FUNCTION SQL_TO_PL2(aSqlItem ASO_QUOTE_PUB_PRICE_ATTRIBUTE)
690: RETURN ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE IS
691: aPlsqlItem ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE;
692: BEGIN
693: -- Added to take care of 'reference to uninitialized collection' error.
694: begin
687: RETURN aSqlItem;
688: END PL_TO_SQL3;
689: FUNCTION SQL_TO_PL2(aSqlItem ASO_QUOTE_PUB_PRICE_ATTRIBUTE)
690: RETURN ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE IS
691: aPlsqlItem ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE;
692: BEGIN
693: -- Added to take care of 'reference to uninitialized collection' error.
694: begin
695: FOR I IN 1..aSqlItem.COUNT LOOP
700: null;
701: end;
702: RETURN aPlsqlItem;
703: END SQL_TO_PL2;
704: FUNCTION PL_TO_SQL21(aPlsqlItem ASO_QUOTE_PUB.PAYMENT_REC_TYPE)
705: RETURN ASO_QUOTE_PUB_PAYMENT_REC_TYP IS
706: aSqlItem ASO_QUOTE_PUB_PAYMENT_REC_TYP;
707: BEGIN
708: -- initialize the object
701: end;
702: RETURN aPlsqlItem;
703: END SQL_TO_PL2;
704: FUNCTION PL_TO_SQL21(aPlsqlItem ASO_QUOTE_PUB.PAYMENT_REC_TYPE)
705: RETURN ASO_QUOTE_PUB_PAYMENT_REC_TYP IS
706: aSqlItem ASO_QUOTE_PUB_PAYMENT_REC_TYP;
707: BEGIN
708: -- initialize the object
709: aSqlItem := ASO_QUOTE_PUB_PAYMENT_REC_TYP(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
702: RETURN aPlsqlItem;
703: END SQL_TO_PL2;
704: FUNCTION PL_TO_SQL21(aPlsqlItem ASO_QUOTE_PUB.PAYMENT_REC_TYPE)
705: RETURN ASO_QUOTE_PUB_PAYMENT_REC_TYP IS
706: aSqlItem ASO_QUOTE_PUB_PAYMENT_REC_TYP;
707: BEGIN
708: -- initialize the object
709: aSqlItem := ASO_QUOTE_PUB_PAYMENT_REC_TYP(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
710: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
705: RETURN ASO_QUOTE_PUB_PAYMENT_REC_TYP IS
706: aSqlItem ASO_QUOTE_PUB_PAYMENT_REC_TYP;
707: BEGIN
708: -- initialize the object
709: aSqlItem := ASO_QUOTE_PUB_PAYMENT_REC_TYP(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
710: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
711: NULL, NULL, NULL, NULL, NULL);
712: aSqlItem.OPERATION_CODE := aPlsqlItem.OPERATION_CODE;
713: aSqlItem.QTE_LINE_INDEX := aPlsqlItem.QTE_LINE_INDEX;
766: aSqlItem.INSTRUMENT_ID := aPlsqlItem.INSTRUMENT_ID;
767: aSqlItem.TRXN_EXTENSION_ID := aPlsqlItem.TRXN_EXTENSION_ID;
768: RETURN aSqlItem;
769: END PL_TO_SQL21;
770: FUNCTION SQL_TO_PL21(aSqlItem ASO_QUOTE_PUB_PAYMENT_REC_TYP)
771: RETURN ASO_QUOTE_PUB.PAYMENT_REC_TYPE IS
772: aPlsqlItem ASO_QUOTE_PUB.PAYMENT_REC_TYPE;
773: BEGIN
774: aPlsqlItem.OPERATION_CODE := aSqlItem.OPERATION_CODE;
767: aSqlItem.TRXN_EXTENSION_ID := aPlsqlItem.TRXN_EXTENSION_ID;
768: RETURN aSqlItem;
769: END PL_TO_SQL21;
770: FUNCTION SQL_TO_PL21(aSqlItem ASO_QUOTE_PUB_PAYMENT_REC_TYP)
771: RETURN ASO_QUOTE_PUB.PAYMENT_REC_TYPE IS
772: aPlsqlItem ASO_QUOTE_PUB.PAYMENT_REC_TYPE;
773: BEGIN
774: aPlsqlItem.OPERATION_CODE := aSqlItem.OPERATION_CODE;
775: aPlsqlItem.QTE_LINE_INDEX := aSqlItem.QTE_LINE_INDEX;
768: RETURN aSqlItem;
769: END PL_TO_SQL21;
770: FUNCTION SQL_TO_PL21(aSqlItem ASO_QUOTE_PUB_PAYMENT_REC_TYP)
771: RETURN ASO_QUOTE_PUB.PAYMENT_REC_TYPE IS
772: aPlsqlItem ASO_QUOTE_PUB.PAYMENT_REC_TYPE;
773: BEGIN
774: aPlsqlItem.OPERATION_CODE := aSqlItem.OPERATION_CODE;
775: aPlsqlItem.QTE_LINE_INDEX := aSqlItem.QTE_LINE_INDEX;
776: aPlsqlItem.SHIPMENT_INDEX := aSqlItem.SHIPMENT_INDEX;
828: aPlsqlItem.INSTRUMENT_ID := aSqlItem.INSTRUMENT_ID;
829: aPlsqlItem.TRXN_EXTENSION_ID := aSqlItem.TRXN_EXTENSION_ID;
830: RETURN aPlsqlItem;
831: END SQL_TO_PL21;
832: FUNCTION PL_TO_SQL4(aPlsqlItem ASO_QUOTE_PUB.PAYMENT_TBL_TYPE)
833: RETURN ASO_QUOTE_PUB_PAYMENT_TBL_TYP IS
834: aSqlItem ASO_QUOTE_PUB_PAYMENT_TBL_TYP;
835: BEGIN
836: -- initialize the table
829: aPlsqlItem.TRXN_EXTENSION_ID := aSqlItem.TRXN_EXTENSION_ID;
830: RETURN aPlsqlItem;
831: END SQL_TO_PL21;
832: FUNCTION PL_TO_SQL4(aPlsqlItem ASO_QUOTE_PUB.PAYMENT_TBL_TYPE)
833: RETURN ASO_QUOTE_PUB_PAYMENT_TBL_TYP IS
834: aSqlItem ASO_QUOTE_PUB_PAYMENT_TBL_TYP;
835: BEGIN
836: -- initialize the table
837: aSqlItem := ASO_QUOTE_PUB_PAYMENT_TBL_TYP();
830: RETURN aPlsqlItem;
831: END SQL_TO_PL21;
832: FUNCTION PL_TO_SQL4(aPlsqlItem ASO_QUOTE_PUB.PAYMENT_TBL_TYPE)
833: RETURN ASO_QUOTE_PUB_PAYMENT_TBL_TYP IS
834: aSqlItem ASO_QUOTE_PUB_PAYMENT_TBL_TYP;
835: BEGIN
836: -- initialize the table
837: aSqlItem := ASO_QUOTE_PUB_PAYMENT_TBL_TYP();
838: IF aPlsqlItem.COUNT > 0 THEN
833: RETURN ASO_QUOTE_PUB_PAYMENT_TBL_TYP IS
834: aSqlItem ASO_QUOTE_PUB_PAYMENT_TBL_TYP;
835: BEGIN
836: -- initialize the table
837: aSqlItem := ASO_QUOTE_PUB_PAYMENT_TBL_TYP();
838: IF aPlsqlItem.COUNT > 0 THEN
839: aSqlItem.EXTEND(aPlsqlItem.COUNT);
840: FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
841: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL21(aPlsqlItem(I));
842: END LOOP;
843: END IF;
844: RETURN aSqlItem;
845: END PL_TO_SQL4;
846: FUNCTION SQL_TO_PL3(aSqlItem ASO_QUOTE_PUB_PAYMENT_TBL_TYP)
847: RETURN ASO_QUOTE_PUB.PAYMENT_TBL_TYPE IS
848: aPlsqlItem ASO_QUOTE_PUB.PAYMENT_TBL_TYPE;
849: BEGIN
850: begin
843: END IF;
844: RETURN aSqlItem;
845: END PL_TO_SQL4;
846: FUNCTION SQL_TO_PL3(aSqlItem ASO_QUOTE_PUB_PAYMENT_TBL_TYP)
847: RETURN ASO_QUOTE_PUB.PAYMENT_TBL_TYPE IS
848: aPlsqlItem ASO_QUOTE_PUB.PAYMENT_TBL_TYPE;
849: BEGIN
850: begin
851: FOR I IN 1..aSqlItem.COUNT LOOP
844: RETURN aSqlItem;
845: END PL_TO_SQL4;
846: FUNCTION SQL_TO_PL3(aSqlItem ASO_QUOTE_PUB_PAYMENT_TBL_TYP)
847: RETURN ASO_QUOTE_PUB.PAYMENT_TBL_TYPE IS
848: aPlsqlItem ASO_QUOTE_PUB.PAYMENT_TBL_TYPE;
849: BEGIN
850: begin
851: FOR I IN 1..aSqlItem.COUNT LOOP
852: aPlsqlItem(I) := SQL_TO_PL21(aSqlItem(I));
856: null;
857: end;
858: RETURN aPlsqlItem;
859: END SQL_TO_PL3;
860: FUNCTION PL_TO_SQL5(aPlsqlItem ASO_QUOTE_PUB.SHIPMENT_REC_TYPE)
861: RETURN ASO_QUOTE_PUB_SHIPMENT_REC_TY IS
862: aSqlItem ASO_QUOTE_PUB_SHIPMENT_REC_TY;
863: BEGIN
864: -- initialize the object
857: end;
858: RETURN aPlsqlItem;
859: END SQL_TO_PL3;
860: FUNCTION PL_TO_SQL5(aPlsqlItem ASO_QUOTE_PUB.SHIPMENT_REC_TYPE)
861: RETURN ASO_QUOTE_PUB_SHIPMENT_REC_TY IS
862: aSqlItem ASO_QUOTE_PUB_SHIPMENT_REC_TY;
863: BEGIN
864: -- initialize the object
865: aSqlItem := ASO_QUOTE_PUB_SHIPMENT_REC_TY(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
858: RETURN aPlsqlItem;
859: END SQL_TO_PL3;
860: FUNCTION PL_TO_SQL5(aPlsqlItem ASO_QUOTE_PUB.SHIPMENT_REC_TYPE)
861: RETURN ASO_QUOTE_PUB_SHIPMENT_REC_TY IS
862: aSqlItem ASO_QUOTE_PUB_SHIPMENT_REC_TY;
863: BEGIN
864: -- initialize the object
865: aSqlItem := ASO_QUOTE_PUB_SHIPMENT_REC_TY(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
866: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
861: RETURN ASO_QUOTE_PUB_SHIPMENT_REC_TY IS
862: aSqlItem ASO_QUOTE_PUB_SHIPMENT_REC_TY;
863: BEGIN
864: -- initialize the object
865: aSqlItem := ASO_QUOTE_PUB_SHIPMENT_REC_TY(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
866: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
867: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
868: aSqlItem.OPERATION_CODE := aPlsqlItem.OPERATION_CODE;
869: aSqlItem.QTE_LINE_INDEX := aPlsqlItem.QTE_LINE_INDEX;
944: aSqlItem.ATTRIBUTE19 := aPlsqlItem.ATTRIBUTE19;
945: aSqlItem.ATTRIBUTE20 := aPlsqlItem.ATTRIBUTE20;
946: RETURN aSqlItem;
947: END PL_TO_SQL5;
948: FUNCTION SQL_TO_PL4(aSqlItem ASO_QUOTE_PUB_SHIPMENT_REC_TY)
949: RETURN ASO_QUOTE_PUB.SHIPMENT_REC_TYPE IS
950: aPlsqlItem ASO_QUOTE_PUB.SHIPMENT_REC_TYPE;
951: BEGIN
952: aPlsqlItem.OPERATION_CODE := aSqlItem.OPERATION_CODE;
945: aSqlItem.ATTRIBUTE20 := aPlsqlItem.ATTRIBUTE20;
946: RETURN aSqlItem;
947: END PL_TO_SQL5;
948: FUNCTION SQL_TO_PL4(aSqlItem ASO_QUOTE_PUB_SHIPMENT_REC_TY)
949: RETURN ASO_QUOTE_PUB.SHIPMENT_REC_TYPE IS
950: aPlsqlItem ASO_QUOTE_PUB.SHIPMENT_REC_TYPE;
951: BEGIN
952: aPlsqlItem.OPERATION_CODE := aSqlItem.OPERATION_CODE;
953: aPlsqlItem.QTE_LINE_INDEX := aSqlItem.QTE_LINE_INDEX;
946: RETURN aSqlItem;
947: END PL_TO_SQL5;
948: FUNCTION SQL_TO_PL4(aSqlItem ASO_QUOTE_PUB_SHIPMENT_REC_TY)
949: RETURN ASO_QUOTE_PUB.SHIPMENT_REC_TYPE IS
950: aPlsqlItem ASO_QUOTE_PUB.SHIPMENT_REC_TYPE;
951: BEGIN
952: aPlsqlItem.OPERATION_CODE := aSqlItem.OPERATION_CODE;
953: aPlsqlItem.QTE_LINE_INDEX := aSqlItem.QTE_LINE_INDEX;
954: aPlsqlItem.SHIPMENT_ID := aSqlItem.SHIPMENT_ID;
1028: aPlsqlItem.ATTRIBUTE19 := aSqlItem.ATTRIBUTE19;
1029: aPlsqlItem.ATTRIBUTE20 := aSqlItem.ATTRIBUTE20;
1030: RETURN aPlsqlItem;
1031: END SQL_TO_PL4;
1032: FUNCTION PL_TO_SQL22(aPlsqlItem ASO_QUOTE_PUB.FREIGHT_CHARGE_REC_TYPE)
1033: RETURN ASO_QUOTE_PUB_FREIGHT_CHARG35 IS
1034: aSqlItem ASO_QUOTE_PUB_FREIGHT_CHARG35;
1035: BEGIN
1036: -- initialize the object
1029: aPlsqlItem.ATTRIBUTE20 := aSqlItem.ATTRIBUTE20;
1030: RETURN aPlsqlItem;
1031: END SQL_TO_PL4;
1032: FUNCTION PL_TO_SQL22(aPlsqlItem ASO_QUOTE_PUB.FREIGHT_CHARGE_REC_TYPE)
1033: RETURN ASO_QUOTE_PUB_FREIGHT_CHARG35 IS
1034: aSqlItem ASO_QUOTE_PUB_FREIGHT_CHARG35;
1035: BEGIN
1036: -- initialize the object
1037: aSqlItem := ASO_QUOTE_PUB_FREIGHT_CHARG35(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
1030: RETURN aPlsqlItem;
1031: END SQL_TO_PL4;
1032: FUNCTION PL_TO_SQL22(aPlsqlItem ASO_QUOTE_PUB.FREIGHT_CHARGE_REC_TYPE)
1033: RETURN ASO_QUOTE_PUB_FREIGHT_CHARG35 IS
1034: aSqlItem ASO_QUOTE_PUB_FREIGHT_CHARG35;
1035: BEGIN
1036: -- initialize the object
1037: aSqlItem := ASO_QUOTE_PUB_FREIGHT_CHARG35(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
1038: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
1033: RETURN ASO_QUOTE_PUB_FREIGHT_CHARG35 IS
1034: aSqlItem ASO_QUOTE_PUB_FREIGHT_CHARG35;
1035: BEGIN
1036: -- initialize the object
1037: aSqlItem := ASO_QUOTE_PUB_FREIGHT_CHARG35(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
1038: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
1039: aSqlItem.OPERATION_CODE := aPlsqlItem.OPERATION_CODE;
1040: aSqlItem.QTE_LINE_INDEX := aPlsqlItem.QTE_LINE_INDEX;
1041: aSqlItem.SHIPMENT_INDEX := aPlsqlItem.SHIPMENT_INDEX;
1071: aSqlItem.ATTRIBUTE15 := aPlsqlItem.ATTRIBUTE15;
1072: aSqlItem.OBJECT_VERSION_NUMBER := aPlsqlItem.OBJECT_VERSION_NUMBER;
1073: RETURN aSqlItem;
1074: END PL_TO_SQL22;
1075: FUNCTION SQL_TO_PL22(aSqlItem ASO_QUOTE_PUB_FREIGHT_CHARG35)
1076: RETURN ASO_QUOTE_PUB.FREIGHT_CHARGE_REC_TYPE IS
1077: aPlsqlItem ASO_QUOTE_PUB.FREIGHT_CHARGE_REC_TYPE;
1078: BEGIN
1079: aPlsqlItem.OPERATION_CODE := aSqlItem.OPERATION_CODE;
1072: aSqlItem.OBJECT_VERSION_NUMBER := aPlsqlItem.OBJECT_VERSION_NUMBER;
1073: RETURN aSqlItem;
1074: END PL_TO_SQL22;
1075: FUNCTION SQL_TO_PL22(aSqlItem ASO_QUOTE_PUB_FREIGHT_CHARG35)
1076: RETURN ASO_QUOTE_PUB.FREIGHT_CHARGE_REC_TYPE IS
1077: aPlsqlItem ASO_QUOTE_PUB.FREIGHT_CHARGE_REC_TYPE;
1078: BEGIN
1079: aPlsqlItem.OPERATION_CODE := aSqlItem.OPERATION_CODE;
1080: aPlsqlItem.QTE_LINE_INDEX := aSqlItem.QTE_LINE_INDEX;
1073: RETURN aSqlItem;
1074: END PL_TO_SQL22;
1075: FUNCTION SQL_TO_PL22(aSqlItem ASO_QUOTE_PUB_FREIGHT_CHARG35)
1076: RETURN ASO_QUOTE_PUB.FREIGHT_CHARGE_REC_TYPE IS
1077: aPlsqlItem ASO_QUOTE_PUB.FREIGHT_CHARGE_REC_TYPE;
1078: BEGIN
1079: aPlsqlItem.OPERATION_CODE := aSqlItem.OPERATION_CODE;
1080: aPlsqlItem.QTE_LINE_INDEX := aSqlItem.QTE_LINE_INDEX;
1081: aPlsqlItem.SHIPMENT_INDEX := aSqlItem.SHIPMENT_INDEX;
1111: aPlsqlItem.ATTRIBUTE15 := aSqlItem.ATTRIBUTE15;
1112: aPlsqlItem.OBJECT_VERSION_NUMBER := aSqlItem.OBJECT_VERSION_NUMBER;
1113: RETURN aPlsqlItem;
1114: END SQL_TO_PL22;
1115: FUNCTION PL_TO_SQL6(aPlsqlItem ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE)
1116: RETURN ASO_QUOTE_PUB_FREIGHT_CHARGE_ IS
1117: aSqlItem ASO_QUOTE_PUB_FREIGHT_CHARGE_;
1118: BEGIN
1119: -- initialize the table
1112: aPlsqlItem.OBJECT_VERSION_NUMBER := aSqlItem.OBJECT_VERSION_NUMBER;
1113: RETURN aPlsqlItem;
1114: END SQL_TO_PL22;
1115: FUNCTION PL_TO_SQL6(aPlsqlItem ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE)
1116: RETURN ASO_QUOTE_PUB_FREIGHT_CHARGE_ IS
1117: aSqlItem ASO_QUOTE_PUB_FREIGHT_CHARGE_;
1118: BEGIN
1119: -- initialize the table
1120: aSqlItem := ASO_QUOTE_PUB_FREIGHT_CHARGE_();
1113: RETURN aPlsqlItem;
1114: END SQL_TO_PL22;
1115: FUNCTION PL_TO_SQL6(aPlsqlItem ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE)
1116: RETURN ASO_QUOTE_PUB_FREIGHT_CHARGE_ IS
1117: aSqlItem ASO_QUOTE_PUB_FREIGHT_CHARGE_;
1118: BEGIN
1119: -- initialize the table
1120: aSqlItem := ASO_QUOTE_PUB_FREIGHT_CHARGE_();
1121: IF aPlsqlItem.COUNT > 0 THEN
1116: RETURN ASO_QUOTE_PUB_FREIGHT_CHARGE_ IS
1117: aSqlItem ASO_QUOTE_PUB_FREIGHT_CHARGE_;
1118: BEGIN
1119: -- initialize the table
1120: aSqlItem := ASO_QUOTE_PUB_FREIGHT_CHARGE_();
1121: IF aPlsqlItem.COUNT > 0 THEN
1122: aSqlItem.EXTEND(aPlsqlItem.COUNT);
1123: FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
1124: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL22(aPlsqlItem(I));
1125: END LOOP;
1126: END IF;
1127: RETURN aSqlItem;
1128: END PL_TO_SQL6;
1129: FUNCTION SQL_TO_PL5(aSqlItem ASO_QUOTE_PUB_FREIGHT_CHARGE_)
1130: RETURN ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE IS
1131: aPlsqlItem ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE;
1132: BEGIN
1133: BEGIN
1126: END IF;
1127: RETURN aSqlItem;
1128: END PL_TO_SQL6;
1129: FUNCTION SQL_TO_PL5(aSqlItem ASO_QUOTE_PUB_FREIGHT_CHARGE_)
1130: RETURN ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE IS
1131: aPlsqlItem ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE;
1132: BEGIN
1133: BEGIN
1134: FOR I IN 1..aSqlItem.COUNT LOOP
1127: RETURN aSqlItem;
1128: END PL_TO_SQL6;
1129: FUNCTION SQL_TO_PL5(aSqlItem ASO_QUOTE_PUB_FREIGHT_CHARGE_)
1130: RETURN ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE IS
1131: aPlsqlItem ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE;
1132: BEGIN
1133: BEGIN
1134: FOR I IN 1..aSqlItem.COUNT LOOP
1135: aPlsqlItem(I) := SQL_TO_PL22(aSqlItem(I));
1139: NULL;
1140: END;
1141: RETURN aPlsqlItem;
1142: END SQL_TO_PL5;
1143: FUNCTION PL_TO_SQL23(aPlsqlItem ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE)
1144: RETURN ASO_QUOTE_PUB_TAX_DETAIL_REC_ IS
1145: aSqlItem ASO_QUOTE_PUB_TAX_DETAIL_REC_;
1146: BEGIN
1147: -- initialize the object
1140: END;
1141: RETURN aPlsqlItem;
1142: END SQL_TO_PL5;
1143: FUNCTION PL_TO_SQL23(aPlsqlItem ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE)
1144: RETURN ASO_QUOTE_PUB_TAX_DETAIL_REC_ IS
1145: aSqlItem ASO_QUOTE_PUB_TAX_DETAIL_REC_;
1146: BEGIN
1147: -- initialize the object
1148: aSqlItem := ASO_QUOTE_PUB_TAX_DETAIL_REC_(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
1141: RETURN aPlsqlItem;
1142: END SQL_TO_PL5;
1143: FUNCTION PL_TO_SQL23(aPlsqlItem ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE)
1144: RETURN ASO_QUOTE_PUB_TAX_DETAIL_REC_ IS
1145: aSqlItem ASO_QUOTE_PUB_TAX_DETAIL_REC_;
1146: BEGIN
1147: -- initialize the object
1148: aSqlItem := ASO_QUOTE_PUB_TAX_DETAIL_REC_(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
1149: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
1144: RETURN ASO_QUOTE_PUB_TAX_DETAIL_REC_ IS
1145: aSqlItem ASO_QUOTE_PUB_TAX_DETAIL_REC_;
1146: BEGIN
1147: -- initialize the object
1148: aSqlItem := ASO_QUOTE_PUB_TAX_DETAIL_REC_(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
1149: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
1150: aSqlItem.OPERATION_CODE := aPlsqlItem.OPERATION_CODE;
1151: aSqlItem.QTE_LINE_INDEX := aPlsqlItem.QTE_LINE_INDEX;
1152: aSqlItem.SHIPMENT_INDEX := aPlsqlItem.SHIPMENT_INDEX;
1196: aSqlItem.ATTRIBUTE20 := aPlsqlItem.ATTRIBUTE20;
1197: aSqlItem.TAX_RATE_ID := aPlsqlItem.TAX_RATE_ID;
1198: RETURN aSqlItem;
1199: END PL_TO_SQL23;
1200: FUNCTION SQL_TO_PL23(aSqlItem ASO_QUOTE_PUB_TAX_DETAIL_REC_)
1201: RETURN ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE IS
1202: aPlsqlItem ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE;
1203: BEGIN
1204: aPlsqlItem.OPERATION_CODE := aSqlItem.OPERATION_CODE;
1197: aSqlItem.TAX_RATE_ID := aPlsqlItem.TAX_RATE_ID;
1198: RETURN aSqlItem;
1199: END PL_TO_SQL23;
1200: FUNCTION SQL_TO_PL23(aSqlItem ASO_QUOTE_PUB_TAX_DETAIL_REC_)
1201: RETURN ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE IS
1202: aPlsqlItem ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE;
1203: BEGIN
1204: aPlsqlItem.OPERATION_CODE := aSqlItem.OPERATION_CODE;
1205: aPlsqlItem.QTE_LINE_INDEX := aSqlItem.QTE_LINE_INDEX;
1198: RETURN aSqlItem;
1199: END PL_TO_SQL23;
1200: FUNCTION SQL_TO_PL23(aSqlItem ASO_QUOTE_PUB_TAX_DETAIL_REC_)
1201: RETURN ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE IS
1202: aPlsqlItem ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE;
1203: BEGIN
1204: aPlsqlItem.OPERATION_CODE := aSqlItem.OPERATION_CODE;
1205: aPlsqlItem.QTE_LINE_INDEX := aSqlItem.QTE_LINE_INDEX;
1206: aPlsqlItem.SHIPMENT_INDEX := aSqlItem.SHIPMENT_INDEX;
1250: aPlsqlItem.ATTRIBUTE20 := aSqlItem.ATTRIBUTE20;
1251: aPlsqlItem.TAX_RATE_ID := aSqlItem.TAX_RATE_ID;
1252: RETURN aPlsqlItem;
1253: END SQL_TO_PL23;
1254: FUNCTION PL_TO_SQL7(aPlsqlItem ASO_QUOTE_PUB.TAX_DETAIL_TBL_TYPE)
1255: RETURN ASO_QUOTE_PUB_TAX_DETAIL_TBL_ IS
1256: aSqlItem ASO_QUOTE_PUB_TAX_DETAIL_TBL_;
1257: BEGIN
1258: -- initialize the table
1251: aPlsqlItem.TAX_RATE_ID := aSqlItem.TAX_RATE_ID;
1252: RETURN aPlsqlItem;
1253: END SQL_TO_PL23;
1254: FUNCTION PL_TO_SQL7(aPlsqlItem ASO_QUOTE_PUB.TAX_DETAIL_TBL_TYPE)
1255: RETURN ASO_QUOTE_PUB_TAX_DETAIL_TBL_ IS
1256: aSqlItem ASO_QUOTE_PUB_TAX_DETAIL_TBL_;
1257: BEGIN
1258: -- initialize the table
1259: aSqlItem := ASO_QUOTE_PUB_TAX_DETAIL_TBL_();
1252: RETURN aPlsqlItem;
1253: END SQL_TO_PL23;
1254: FUNCTION PL_TO_SQL7(aPlsqlItem ASO_QUOTE_PUB.TAX_DETAIL_TBL_TYPE)
1255: RETURN ASO_QUOTE_PUB_TAX_DETAIL_TBL_ IS
1256: aSqlItem ASO_QUOTE_PUB_TAX_DETAIL_TBL_;
1257: BEGIN
1258: -- initialize the table
1259: aSqlItem := ASO_QUOTE_PUB_TAX_DETAIL_TBL_();
1260: IF aPlsqlItem.COUNT > 0 THEN
1255: RETURN ASO_QUOTE_PUB_TAX_DETAIL_TBL_ IS
1256: aSqlItem ASO_QUOTE_PUB_TAX_DETAIL_TBL_;
1257: BEGIN
1258: -- initialize the table
1259: aSqlItem := ASO_QUOTE_PUB_TAX_DETAIL_TBL_();
1260: IF aPlsqlItem.COUNT > 0 THEN
1261: aSqlItem.EXTEND(aPlsqlItem.COUNT);
1262: FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
1263: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL23(aPlsqlItem(I));
1264: END LOOP;
1265: END IF;
1266: RETURN aSqlItem;
1267: END PL_TO_SQL7;
1268: FUNCTION SQL_TO_PL6(aSqlItem ASO_QUOTE_PUB_TAX_DETAIL_TBL_)
1269: RETURN ASO_QUOTE_PUB.TAX_DETAIL_TBL_TYPE IS
1270: aPlsqlItem ASO_QUOTE_PUB.TAX_DETAIL_TBL_TYPE;
1271: BEGIN
1272: begin
1265: END IF;
1266: RETURN aSqlItem;
1267: END PL_TO_SQL7;
1268: FUNCTION SQL_TO_PL6(aSqlItem ASO_QUOTE_PUB_TAX_DETAIL_TBL_)
1269: RETURN ASO_QUOTE_PUB.TAX_DETAIL_TBL_TYPE IS
1270: aPlsqlItem ASO_QUOTE_PUB.TAX_DETAIL_TBL_TYPE;
1271: BEGIN
1272: begin
1273: FOR I IN 1..aSqlItem.COUNT LOOP
1266: RETURN aSqlItem;
1267: END PL_TO_SQL7;
1268: FUNCTION SQL_TO_PL6(aSqlItem ASO_QUOTE_PUB_TAX_DETAIL_TBL_)
1269: RETURN ASO_QUOTE_PUB.TAX_DETAIL_TBL_TYPE IS
1270: aPlsqlItem ASO_QUOTE_PUB.TAX_DETAIL_TBL_TYPE;
1271: BEGIN
1272: begin
1273: FOR I IN 1..aSqlItem.COUNT LOOP
1274: aPlsqlItem(I) := SQL_TO_PL23(aSqlItem(I));
1278: null;
1279: end;
1280: RETURN aPlsqlItem;
1281: END SQL_TO_PL6;
1282: FUNCTION PL_TO_SQL24(aPlsqlItem ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_REC_TYPE)
1283: RETURN ASO_QUOTE_PUB_LINE_ATTRIBS_36 IS
1284: aSqlItem ASO_QUOTE_PUB_LINE_ATTRIBS_36;
1285: BEGIN
1286: -- initialize the object
1279: end;
1280: RETURN aPlsqlItem;
1281: END SQL_TO_PL6;
1282: FUNCTION PL_TO_SQL24(aPlsqlItem ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_REC_TYPE)
1283: RETURN ASO_QUOTE_PUB_LINE_ATTRIBS_36 IS
1284: aSqlItem ASO_QUOTE_PUB_LINE_ATTRIBS_36;
1285: BEGIN
1286: -- initialize the object
1287: aSqlItem := ASO_QUOTE_PUB_LINE_ATTRIBS_36(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
1280: RETURN aPlsqlItem;
1281: END SQL_TO_PL6;
1282: FUNCTION PL_TO_SQL24(aPlsqlItem ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_REC_TYPE)
1283: RETURN ASO_QUOTE_PUB_LINE_ATTRIBS_36 IS
1284: aSqlItem ASO_QUOTE_PUB_LINE_ATTRIBS_36;
1285: BEGIN
1286: -- initialize the object
1287: aSqlItem := ASO_QUOTE_PUB_LINE_ATTRIBS_36(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
1288: NULL, NULL, NULL);
1283: RETURN ASO_QUOTE_PUB_LINE_ATTRIBS_36 IS
1284: aSqlItem ASO_QUOTE_PUB_LINE_ATTRIBS_36;
1285: BEGIN
1286: -- initialize the object
1287: aSqlItem := ASO_QUOTE_PUB_LINE_ATTRIBS_36(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
1288: NULL, NULL, NULL);
1289: aSqlItem.QTE_LINE_INDEX := aPlsqlItem.QTE_LINE_INDEX;
1290: aSqlItem.SHIPMENT_INDEX := aPlsqlItem.SHIPMENT_INDEX;
1291: aSqlItem.LINE_ATTRIBUTE_ID := aPlsqlItem.LINE_ATTRIBUTE_ID;
1312: aSqlItem.OPERATION_CODE := aPlsqlItem.OPERATION_CODE;
1313: aSqlItem.OBJECT_VERSION_NUMBER := aPlsqlItem.OBJECT_VERSION_NUMBER;
1314: RETURN aSqlItem;
1315: END PL_TO_SQL24;
1316: FUNCTION SQL_TO_PL24(aSqlItem ASO_QUOTE_PUB_LINE_ATTRIBS_36)
1317: RETURN ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_REC_TYPE IS
1318: aPlsqlItem ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_REC_TYPE;
1319: BEGIN
1320: aPlsqlItem.QTE_LINE_INDEX := aSqlItem.QTE_LINE_INDEX;
1313: aSqlItem.OBJECT_VERSION_NUMBER := aPlsqlItem.OBJECT_VERSION_NUMBER;
1314: RETURN aSqlItem;
1315: END PL_TO_SQL24;
1316: FUNCTION SQL_TO_PL24(aSqlItem ASO_QUOTE_PUB_LINE_ATTRIBS_36)
1317: RETURN ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_REC_TYPE IS
1318: aPlsqlItem ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_REC_TYPE;
1319: BEGIN
1320: aPlsqlItem.QTE_LINE_INDEX := aSqlItem.QTE_LINE_INDEX;
1321: aPlsqlItem.SHIPMENT_INDEX := aSqlItem.SHIPMENT_INDEX;
1314: RETURN aSqlItem;
1315: END PL_TO_SQL24;
1316: FUNCTION SQL_TO_PL24(aSqlItem ASO_QUOTE_PUB_LINE_ATTRIBS_36)
1317: RETURN ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_REC_TYPE IS
1318: aPlsqlItem ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_REC_TYPE;
1319: BEGIN
1320: aPlsqlItem.QTE_LINE_INDEX := aSqlItem.QTE_LINE_INDEX;
1321: aPlsqlItem.SHIPMENT_INDEX := aSqlItem.SHIPMENT_INDEX;
1322: aPlsqlItem.LINE_ATTRIBUTE_ID := aSqlItem.LINE_ATTRIBUTE_ID;
1343: aPlsqlItem.OPERATION_CODE := aSqlItem.OPERATION_CODE;
1344: aPlsqlItem.OBJECT_VERSION_NUMBER := aSqlItem.OBJECT_VERSION_NUMBER;
1345: RETURN aPlsqlItem;
1346: END SQL_TO_PL24;
1347: FUNCTION PL_TO_SQL8(aPlsqlItem ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_TBL_TYPE)
1348: RETURN ASO_QUOTE_PUB_LINE_ATTRIBS_EX IS
1349: aSqlItem ASO_QUOTE_PUB_LINE_ATTRIBS_EX;
1350: BEGIN
1351: -- initialize the table
1344: aPlsqlItem.OBJECT_VERSION_NUMBER := aSqlItem.OBJECT_VERSION_NUMBER;
1345: RETURN aPlsqlItem;
1346: END SQL_TO_PL24;
1347: FUNCTION PL_TO_SQL8(aPlsqlItem ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_TBL_TYPE)
1348: RETURN ASO_QUOTE_PUB_LINE_ATTRIBS_EX IS
1349: aSqlItem ASO_QUOTE_PUB_LINE_ATTRIBS_EX;
1350: BEGIN
1351: -- initialize the table
1352: aSqlItem := ASO_QUOTE_PUB_LINE_ATTRIBS_EX();
1345: RETURN aPlsqlItem;
1346: END SQL_TO_PL24;
1347: FUNCTION PL_TO_SQL8(aPlsqlItem ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_TBL_TYPE)
1348: RETURN ASO_QUOTE_PUB_LINE_ATTRIBS_EX IS
1349: aSqlItem ASO_QUOTE_PUB_LINE_ATTRIBS_EX;
1350: BEGIN
1351: -- initialize the table
1352: aSqlItem := ASO_QUOTE_PUB_LINE_ATTRIBS_EX();
1353: IF aPlsqlItem.COUNT > 0 THEN
1348: RETURN ASO_QUOTE_PUB_LINE_ATTRIBS_EX IS
1349: aSqlItem ASO_QUOTE_PUB_LINE_ATTRIBS_EX;
1350: BEGIN
1351: -- initialize the table
1352: aSqlItem := ASO_QUOTE_PUB_LINE_ATTRIBS_EX();
1353: IF aPlsqlItem.COUNT > 0 THEN
1354: aSqlItem.EXTEND(aPlsqlItem.COUNT);
1355: FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
1356: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL24(aPlsqlItem(I));
1357: END LOOP;
1358: END IF;
1359: RETURN aSqlItem;
1360: END PL_TO_SQL8;
1361: FUNCTION SQL_TO_PL7(aSqlItem ASO_QUOTE_PUB_LINE_ATTRIBS_EX)
1362: RETURN ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_TBL_TYPE IS
1363: aPlsqlItem ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_TBL_TYPE;
1364: BEGIN
1365: BEGIN
1358: END IF;
1359: RETURN aSqlItem;
1360: END PL_TO_SQL8;
1361: FUNCTION SQL_TO_PL7(aSqlItem ASO_QUOTE_PUB_LINE_ATTRIBS_EX)
1362: RETURN ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_TBL_TYPE IS
1363: aPlsqlItem ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_TBL_TYPE;
1364: BEGIN
1365: BEGIN
1366: FOR I IN 1..aSqlItem.COUNT LOOP
1359: RETURN aSqlItem;
1360: END PL_TO_SQL8;
1361: FUNCTION SQL_TO_PL7(aSqlItem ASO_QUOTE_PUB_LINE_ATTRIBS_EX)
1362: RETURN ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_TBL_TYPE IS
1363: aPlsqlItem ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_TBL_TYPE;
1364: BEGIN
1365: BEGIN
1366: FOR I IN 1..aSqlItem.COUNT LOOP
1367: aPlsqlItem(I) := SQL_TO_PL24(aSqlItem(I));
1372: END;
1373:
1374: RETURN aPlsqlItem;
1375: END SQL_TO_PL7;
1376: FUNCTION PL_TO_SQL25(aPlsqlItem ASO_QUOTE_PUB.SALES_CREDIT_REC_TYPE)
1377: RETURN ASO_QUOTE_PUB_SALES_CREDIT_RE IS
1378: aSqlItem ASO_QUOTE_PUB_SALES_CREDIT_RE;
1379: BEGIN
1380: -- initialize the object
1373:
1374: RETURN aPlsqlItem;
1375: END SQL_TO_PL7;
1376: FUNCTION PL_TO_SQL25(aPlsqlItem ASO_QUOTE_PUB.SALES_CREDIT_REC_TYPE)
1377: RETURN ASO_QUOTE_PUB_SALES_CREDIT_RE IS
1378: aSqlItem ASO_QUOTE_PUB_SALES_CREDIT_RE;
1379: BEGIN
1380: -- initialize the object
1381: aSqlItem := ASO_QUOTE_PUB_SALES_CREDIT_RE(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
1374: RETURN aPlsqlItem;
1375: END SQL_TO_PL7;
1376: FUNCTION PL_TO_SQL25(aPlsqlItem ASO_QUOTE_PUB.SALES_CREDIT_REC_TYPE)
1377: RETURN ASO_QUOTE_PUB_SALES_CREDIT_RE IS
1378: aSqlItem ASO_QUOTE_PUB_SALES_CREDIT_RE;
1379: BEGIN
1380: -- initialize the object
1381: aSqlItem := ASO_QUOTE_PUB_SALES_CREDIT_RE(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
1382: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
1377: RETURN ASO_QUOTE_PUB_SALES_CREDIT_RE IS
1378: aSqlItem ASO_QUOTE_PUB_SALES_CREDIT_RE;
1379: BEGIN
1380: -- initialize the object
1381: aSqlItem := ASO_QUOTE_PUB_SALES_CREDIT_RE(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
1382: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
1383: aSqlItem.QTE_LINE_INDEX := aPlsqlItem.QTE_LINE_INDEX;
1384: aSqlItem.OPERATION_CODE := aPlsqlItem.OPERATION_CODE;
1385: aSqlItem.SALES_CREDIT_ID := aPlsqlItem.SALES_CREDIT_ID;
1427: aSqlItem.ATTRIBUTE19 := aPlsqlItem.ATTRIBUTE19;
1428: aSqlItem.ATTRIBUTE20 := aPlsqlItem.ATTRIBUTE20;
1429: RETURN aSqlItem;
1430: END PL_TO_SQL25;
1431: FUNCTION SQL_TO_PL25(aSqlItem ASO_QUOTE_PUB_SALES_CREDIT_RE)
1432: RETURN ASO_QUOTE_PUB.SALES_CREDIT_REC_TYPE IS
1433: aPlsqlItem ASO_QUOTE_PUB.SALES_CREDIT_REC_TYPE;
1434: BEGIN
1435: aPlsqlItem.QTE_LINE_INDEX := aSqlItem.QTE_LINE_INDEX;
1428: aSqlItem.ATTRIBUTE20 := aPlsqlItem.ATTRIBUTE20;
1429: RETURN aSqlItem;
1430: END PL_TO_SQL25;
1431: FUNCTION SQL_TO_PL25(aSqlItem ASO_QUOTE_PUB_SALES_CREDIT_RE)
1432: RETURN ASO_QUOTE_PUB.SALES_CREDIT_REC_TYPE IS
1433: aPlsqlItem ASO_QUOTE_PUB.SALES_CREDIT_REC_TYPE;
1434: BEGIN
1435: aPlsqlItem.QTE_LINE_INDEX := aSqlItem.QTE_LINE_INDEX;
1436: aPlsqlItem.OPERATION_CODE := aSqlItem.OPERATION_CODE;
1429: RETURN aSqlItem;
1430: END PL_TO_SQL25;
1431: FUNCTION SQL_TO_PL25(aSqlItem ASO_QUOTE_PUB_SALES_CREDIT_RE)
1432: RETURN ASO_QUOTE_PUB.SALES_CREDIT_REC_TYPE IS
1433: aPlsqlItem ASO_QUOTE_PUB.SALES_CREDIT_REC_TYPE;
1434: BEGIN
1435: aPlsqlItem.QTE_LINE_INDEX := aSqlItem.QTE_LINE_INDEX;
1436: aPlsqlItem.OPERATION_CODE := aSqlItem.OPERATION_CODE;
1437: aPlsqlItem.SALES_CREDIT_ID := aSqlItem.SALES_CREDIT_ID;
1479: aPlsqlItem.ATTRIBUTE19 := aSqlItem.ATTRIBUTE19;
1480: aPlsqlItem.ATTRIBUTE20 := aSqlItem.ATTRIBUTE20;
1481: RETURN aPlsqlItem;
1482: END SQL_TO_PL25;
1483: FUNCTION PL_TO_SQL9(aPlsqlItem ASO_QUOTE_PUB.SALES_CREDIT_TBL_TYPE)
1484: RETURN ASO_QUOTE_PUB_SALES_CREDIT_TB IS
1485: aSqlItem ASO_QUOTE_PUB_SALES_CREDIT_TB;
1486: BEGIN
1487: -- initialize the table
1480: aPlsqlItem.ATTRIBUTE20 := aSqlItem.ATTRIBUTE20;
1481: RETURN aPlsqlItem;
1482: END SQL_TO_PL25;
1483: FUNCTION PL_TO_SQL9(aPlsqlItem ASO_QUOTE_PUB.SALES_CREDIT_TBL_TYPE)
1484: RETURN ASO_QUOTE_PUB_SALES_CREDIT_TB IS
1485: aSqlItem ASO_QUOTE_PUB_SALES_CREDIT_TB;
1486: BEGIN
1487: -- initialize the table
1488: aSqlItem := ASO_QUOTE_PUB_SALES_CREDIT_TB();
1481: RETURN aPlsqlItem;
1482: END SQL_TO_PL25;
1483: FUNCTION PL_TO_SQL9(aPlsqlItem ASO_QUOTE_PUB.SALES_CREDIT_TBL_TYPE)
1484: RETURN ASO_QUOTE_PUB_SALES_CREDIT_TB IS
1485: aSqlItem ASO_QUOTE_PUB_SALES_CREDIT_TB;
1486: BEGIN
1487: -- initialize the table
1488: aSqlItem := ASO_QUOTE_PUB_SALES_CREDIT_TB();
1489: IF aPlsqlItem.COUNT > 0 THEN
1484: RETURN ASO_QUOTE_PUB_SALES_CREDIT_TB IS
1485: aSqlItem ASO_QUOTE_PUB_SALES_CREDIT_TB;
1486: BEGIN
1487: -- initialize the table
1488: aSqlItem := ASO_QUOTE_PUB_SALES_CREDIT_TB();
1489: IF aPlsqlItem.COUNT > 0 THEN
1490: aSqlItem.EXTEND(aPlsqlItem.COUNT);
1491: FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
1492: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL25(aPlsqlItem(I));
1493: END LOOP;
1494: END IF;
1495: RETURN aSqlItem;
1496: END PL_TO_SQL9;
1497: FUNCTION SQL_TO_PL8(aSqlItem ASO_QUOTE_PUB_SALES_CREDIT_TB)
1498: RETURN ASO_QUOTE_PUB.SALES_CREDIT_TBL_TYPE IS
1499: aPlsqlItem ASO_QUOTE_PUB.SALES_CREDIT_TBL_TYPE;
1500: BEGIN
1501: begin
1494: END IF;
1495: RETURN aSqlItem;
1496: END PL_TO_SQL9;
1497: FUNCTION SQL_TO_PL8(aSqlItem ASO_QUOTE_PUB_SALES_CREDIT_TB)
1498: RETURN ASO_QUOTE_PUB.SALES_CREDIT_TBL_TYPE IS
1499: aPlsqlItem ASO_QUOTE_PUB.SALES_CREDIT_TBL_TYPE;
1500: BEGIN
1501: begin
1502: FOR I IN 1..aSqlItem.COUNT LOOP
1495: RETURN aSqlItem;
1496: END PL_TO_SQL9;
1497: FUNCTION SQL_TO_PL8(aSqlItem ASO_QUOTE_PUB_SALES_CREDIT_TB)
1498: RETURN ASO_QUOTE_PUB.SALES_CREDIT_TBL_TYPE IS
1499: aPlsqlItem ASO_QUOTE_PUB.SALES_CREDIT_TBL_TYPE;
1500: BEGIN
1501: begin
1502: FOR I IN 1..aSqlItem.COUNT LOOP
1503: aPlsqlItem(I) := SQL_TO_PL25(aSqlItem(I));
1507: null;
1508: end;
1509: RETURN aPlsqlItem;
1510: END SQL_TO_PL8;
1511: FUNCTION PL_TO_SQL26(aPlsqlItem ASO_QUOTE_PUB.QUOTE_PARTY_REC_TYPE)
1512: RETURN ASO_QUOTE_PUB_QUOTE_PARTY_REC IS
1513: aSqlItem ASO_QUOTE_PUB_QUOTE_PARTY_REC;
1514: BEGIN
1515: -- initialize the object
1508: end;
1509: RETURN aPlsqlItem;
1510: END SQL_TO_PL8;
1511: FUNCTION PL_TO_SQL26(aPlsqlItem ASO_QUOTE_PUB.QUOTE_PARTY_REC_TYPE)
1512: RETURN ASO_QUOTE_PUB_QUOTE_PARTY_REC IS
1513: aSqlItem ASO_QUOTE_PUB_QUOTE_PARTY_REC;
1514: BEGIN
1515: -- initialize the object
1516: aSqlItem := ASO_QUOTE_PUB_QUOTE_PARTY_REC(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
1509: RETURN aPlsqlItem;
1510: END SQL_TO_PL8;
1511: FUNCTION PL_TO_SQL26(aPlsqlItem ASO_QUOTE_PUB.QUOTE_PARTY_REC_TYPE)
1512: RETURN ASO_QUOTE_PUB_QUOTE_PARTY_REC IS
1513: aSqlItem ASO_QUOTE_PUB_QUOTE_PARTY_REC;
1514: BEGIN
1515: -- initialize the object
1516: aSqlItem := ASO_QUOTE_PUB_QUOTE_PARTY_REC(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
1517: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
1512: RETURN ASO_QUOTE_PUB_QUOTE_PARTY_REC IS
1513: aSqlItem ASO_QUOTE_PUB_QUOTE_PARTY_REC;
1514: BEGIN
1515: -- initialize the object
1516: aSqlItem := ASO_QUOTE_PUB_QUOTE_PARTY_REC(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
1517: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
1518: aSqlItem.QTE_LINE_INDEX := aPlsqlItem.QTE_LINE_INDEX;
1519: aSqlItem.SHIPMENT_INDEX := aPlsqlItem.SHIPMENT_INDEX;
1520: aSqlItem.OPERATION_CODE := aPlsqlItem.OPERATION_CODE;
1553: aSqlItem.ATTRIBUTE15 := aPlsqlItem.ATTRIBUTE15;
1554: aSqlItem.OBJECT_VERSION_NUMBER := aPlsqlItem.OBJECT_VERSION_NUMBER;
1555: RETURN aSqlItem;
1556: END PL_TO_SQL26;
1557: FUNCTION SQL_TO_PL26(aSqlItem ASO_QUOTE_PUB_QUOTE_PARTY_REC)
1558: RETURN ASO_QUOTE_PUB.QUOTE_PARTY_REC_TYPE IS
1559: aPlsqlItem ASO_QUOTE_PUB.QUOTE_PARTY_REC_TYPE;
1560: BEGIN
1561: aPlsqlItem.QTE_LINE_INDEX := aSqlItem.QTE_LINE_INDEX;
1554: aSqlItem.OBJECT_VERSION_NUMBER := aPlsqlItem.OBJECT_VERSION_NUMBER;
1555: RETURN aSqlItem;
1556: END PL_TO_SQL26;
1557: FUNCTION SQL_TO_PL26(aSqlItem ASO_QUOTE_PUB_QUOTE_PARTY_REC)
1558: RETURN ASO_QUOTE_PUB.QUOTE_PARTY_REC_TYPE IS
1559: aPlsqlItem ASO_QUOTE_PUB.QUOTE_PARTY_REC_TYPE;
1560: BEGIN
1561: aPlsqlItem.QTE_LINE_INDEX := aSqlItem.QTE_LINE_INDEX;
1562: aPlsqlItem.SHIPMENT_INDEX := aSqlItem.SHIPMENT_INDEX;
1555: RETURN aSqlItem;
1556: END PL_TO_SQL26;
1557: FUNCTION SQL_TO_PL26(aSqlItem ASO_QUOTE_PUB_QUOTE_PARTY_REC)
1558: RETURN ASO_QUOTE_PUB.QUOTE_PARTY_REC_TYPE IS
1559: aPlsqlItem ASO_QUOTE_PUB.QUOTE_PARTY_REC_TYPE;
1560: BEGIN
1561: aPlsqlItem.QTE_LINE_INDEX := aSqlItem.QTE_LINE_INDEX;
1562: aPlsqlItem.SHIPMENT_INDEX := aSqlItem.SHIPMENT_INDEX;
1563: aPlsqlItem.OPERATION_CODE := aSqlItem.OPERATION_CODE;
1596: aPlsqlItem.ATTRIBUTE15 := aSqlItem.ATTRIBUTE15;
1597: aPlsqlItem.OBJECT_VERSION_NUMBER := aSqlItem.OBJECT_VERSION_NUMBER;
1598: RETURN aPlsqlItem;
1599: END SQL_TO_PL26;
1600: FUNCTION PL_TO_SQL10(aPlsqlItem ASO_QUOTE_PUB.QUOTE_PARTY_TBL_TYPE)
1601: RETURN ASO_QUOTE_PUB_QUOTE_PARTY_TBL IS
1602: aSqlItem ASO_QUOTE_PUB_QUOTE_PARTY_TBL;
1603: BEGIN
1604: -- initialize the table
1597: aPlsqlItem.OBJECT_VERSION_NUMBER := aSqlItem.OBJECT_VERSION_NUMBER;
1598: RETURN aPlsqlItem;
1599: END SQL_TO_PL26;
1600: FUNCTION PL_TO_SQL10(aPlsqlItem ASO_QUOTE_PUB.QUOTE_PARTY_TBL_TYPE)
1601: RETURN ASO_QUOTE_PUB_QUOTE_PARTY_TBL IS
1602: aSqlItem ASO_QUOTE_PUB_QUOTE_PARTY_TBL;
1603: BEGIN
1604: -- initialize the table
1605: aSqlItem := ASO_QUOTE_PUB_QUOTE_PARTY_TBL();
1598: RETURN aPlsqlItem;
1599: END SQL_TO_PL26;
1600: FUNCTION PL_TO_SQL10(aPlsqlItem ASO_QUOTE_PUB.QUOTE_PARTY_TBL_TYPE)
1601: RETURN ASO_QUOTE_PUB_QUOTE_PARTY_TBL IS
1602: aSqlItem ASO_QUOTE_PUB_QUOTE_PARTY_TBL;
1603: BEGIN
1604: -- initialize the table
1605: aSqlItem := ASO_QUOTE_PUB_QUOTE_PARTY_TBL();
1606: IF aPlsqlItem.COUNT > 0 THEN
1601: RETURN ASO_QUOTE_PUB_QUOTE_PARTY_TBL IS
1602: aSqlItem ASO_QUOTE_PUB_QUOTE_PARTY_TBL;
1603: BEGIN
1604: -- initialize the table
1605: aSqlItem := ASO_QUOTE_PUB_QUOTE_PARTY_TBL();
1606: IF aPlsqlItem.COUNT > 0 THEN
1607: aSqlItem.EXTEND(aPlsqlItem.COUNT);
1608: FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
1609: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL26(aPlsqlItem(I));
1610: END LOOP;
1611: END IF;
1612: RETURN aSqlItem;
1613: END PL_TO_SQL10;
1614: FUNCTION SQL_TO_PL9(aSqlItem ASO_QUOTE_PUB_QUOTE_PARTY_TBL)
1615: RETURN ASO_QUOTE_PUB.QUOTE_PARTY_TBL_TYPE IS
1616: aPlsqlItem ASO_QUOTE_PUB.QUOTE_PARTY_TBL_TYPE;
1617: BEGIN
1618: BEGIN
1611: END IF;
1612: RETURN aSqlItem;
1613: END PL_TO_SQL10;
1614: FUNCTION SQL_TO_PL9(aSqlItem ASO_QUOTE_PUB_QUOTE_PARTY_TBL)
1615: RETURN ASO_QUOTE_PUB.QUOTE_PARTY_TBL_TYPE IS
1616: aPlsqlItem ASO_QUOTE_PUB.QUOTE_PARTY_TBL_TYPE;
1617: BEGIN
1618: BEGIN
1619:
1612: RETURN aSqlItem;
1613: END PL_TO_SQL10;
1614: FUNCTION SQL_TO_PL9(aSqlItem ASO_QUOTE_PUB_QUOTE_PARTY_TBL)
1615: RETURN ASO_QUOTE_PUB.QUOTE_PARTY_TBL_TYPE IS
1616: aPlsqlItem ASO_QUOTE_PUB.QUOTE_PARTY_TBL_TYPE;
1617: BEGIN
1618: BEGIN
1619:
1620: FOR I IN 1..aSqlItem.COUNT LOOP
1625: NULL;
1626: END;
1627: RETURN aPlsqlItem;
1628: END SQL_TO_PL9;
1629: FUNCTION PL_TO_SQL27(aPlsqlItem ASO_QUOTE_PUB.QTE_LINE_REC_TYPE)
1630: RETURN ASO_QUOTE_PUB_QTE_LINE_REC_TY IS
1631: aSqlItem ASO_QUOTE_PUB_QTE_LINE_REC_TY;
1632: BEGIN
1633: -- initialize the object
1626: END;
1627: RETURN aPlsqlItem;
1628: END SQL_TO_PL9;
1629: FUNCTION PL_TO_SQL27(aPlsqlItem ASO_QUOTE_PUB.QTE_LINE_REC_TYPE)
1630: RETURN ASO_QUOTE_PUB_QTE_LINE_REC_TY IS
1631: aSqlItem ASO_QUOTE_PUB_QTE_LINE_REC_TY;
1632: BEGIN
1633: -- initialize the object
1634: aSqlItem := ASO_QUOTE_PUB_QTE_LINE_REC_TY(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
1627: RETURN aPlsqlItem;
1628: END SQL_TO_PL9;
1629: FUNCTION PL_TO_SQL27(aPlsqlItem ASO_QUOTE_PUB.QTE_LINE_REC_TYPE)
1630: RETURN ASO_QUOTE_PUB_QTE_LINE_REC_TY IS
1631: aSqlItem ASO_QUOTE_PUB_QTE_LINE_REC_TY;
1632: BEGIN
1633: -- initialize the object
1634: aSqlItem := ASO_QUOTE_PUB_QTE_LINE_REC_TY(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
1635: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
1630: RETURN ASO_QUOTE_PUB_QTE_LINE_REC_TY IS
1631: aSqlItem ASO_QUOTE_PUB_QTE_LINE_REC_TY;
1632: BEGIN
1633: -- initialize the object
1634: aSqlItem := ASO_QUOTE_PUB_QTE_LINE_REC_TY(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
1635: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
1636: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
1637: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
1638: aSqlItem.OPERATION_CODE := aPlsqlItem.OPERATION_CODE;
1734: aSqlItem.PRICING_QUANTITY := aPlsqlItem.PRICING_QUANTITY;
1735: aSqlItem.CONFIG_MODEL_TYPE := aPlsqlItem.CONFIG_MODEL_TYPE;
1736: RETURN aSqlItem;
1737: END PL_TO_SQL27;
1738: FUNCTION SQL_TO_PL27(aSqlItem ASO_QUOTE_PUB_QTE_LINE_REC_TY)
1739: RETURN ASO_QUOTE_PUB.QTE_LINE_REC_TYPE IS
1740: aPlsqlItem ASO_QUOTE_PUB.QTE_LINE_REC_TYPE;
1741: BEGIN
1742: aPlsqlItem.OPERATION_CODE := aSqlItem.OPERATION_CODE;
1735: aSqlItem.CONFIG_MODEL_TYPE := aPlsqlItem.CONFIG_MODEL_TYPE;
1736: RETURN aSqlItem;
1737: END PL_TO_SQL27;
1738: FUNCTION SQL_TO_PL27(aSqlItem ASO_QUOTE_PUB_QTE_LINE_REC_TY)
1739: RETURN ASO_QUOTE_PUB.QTE_LINE_REC_TYPE IS
1740: aPlsqlItem ASO_QUOTE_PUB.QTE_LINE_REC_TYPE;
1741: BEGIN
1742: aPlsqlItem.OPERATION_CODE := aSqlItem.OPERATION_CODE;
1743: aPlsqlItem.QUOTE_LINE_ID := aSqlItem.QUOTE_LINE_ID;
1736: RETURN aSqlItem;
1737: END PL_TO_SQL27;
1738: FUNCTION SQL_TO_PL27(aSqlItem ASO_QUOTE_PUB_QTE_LINE_REC_TY)
1739: RETURN ASO_QUOTE_PUB.QTE_LINE_REC_TYPE IS
1740: aPlsqlItem ASO_QUOTE_PUB.QTE_LINE_REC_TYPE;
1741: BEGIN
1742: aPlsqlItem.OPERATION_CODE := aSqlItem.OPERATION_CODE;
1743: aPlsqlItem.QUOTE_LINE_ID := aSqlItem.QUOTE_LINE_ID;
1744: aPlsqlItem.CREATION_DATE := aSqlItem.CREATION_DATE;
1841: aPlsqlItem.PRICING_QUANTITY := aSqlItem.PRICING_QUANTITY;
1842: aPlsqlItem.CONFIG_MODEL_TYPE := aSqlItem.CONFIG_MODEL_TYPE;
1843: RETURN aPlsqlItem;
1844: END SQL_TO_PL27;
1845: FUNCTION PL_TO_SQL1(aPlsqlItem ASO_QUOTE_PUB.QTE_LINE_TBL_TYPE)
1846: RETURN ASO_QUOTE_PUB_QTE_LINE_TBL_TY IS
1847: aSqlItem ASO_QUOTE_PUB_QTE_LINE_TBL_TY;
1848: BEGIN
1849: -- initialize the table
1842: aPlsqlItem.CONFIG_MODEL_TYPE := aSqlItem.CONFIG_MODEL_TYPE;
1843: RETURN aPlsqlItem;
1844: END SQL_TO_PL27;
1845: FUNCTION PL_TO_SQL1(aPlsqlItem ASO_QUOTE_PUB.QTE_LINE_TBL_TYPE)
1846: RETURN ASO_QUOTE_PUB_QTE_LINE_TBL_TY IS
1847: aSqlItem ASO_QUOTE_PUB_QTE_LINE_TBL_TY;
1848: BEGIN
1849: -- initialize the table
1850: aSqlItem := ASO_QUOTE_PUB_QTE_LINE_TBL_TY();
1843: RETURN aPlsqlItem;
1844: END SQL_TO_PL27;
1845: FUNCTION PL_TO_SQL1(aPlsqlItem ASO_QUOTE_PUB.QTE_LINE_TBL_TYPE)
1846: RETURN ASO_QUOTE_PUB_QTE_LINE_TBL_TY IS
1847: aSqlItem ASO_QUOTE_PUB_QTE_LINE_TBL_TY;
1848: BEGIN
1849: -- initialize the table
1850: aSqlItem := ASO_QUOTE_PUB_QTE_LINE_TBL_TY();
1851: IF aPlsqlItem.COUNT > 0 THEN
1846: RETURN ASO_QUOTE_PUB_QTE_LINE_TBL_TY IS
1847: aSqlItem ASO_QUOTE_PUB_QTE_LINE_TBL_TY;
1848: BEGIN
1849: -- initialize the table
1850: aSqlItem := ASO_QUOTE_PUB_QTE_LINE_TBL_TY();
1851: IF aPlsqlItem.COUNT > 0 THEN
1852: aSqlItem.EXTEND(aPlsqlItem.COUNT);
1853: FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
1854: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL27(aPlsqlItem(I));
1855: END LOOP;
1856: END IF;
1857: RETURN aSqlItem;
1858: END PL_TO_SQL1;
1859: FUNCTION SQL_TO_PL10(aSqlItem ASO_QUOTE_PUB_QTE_LINE_TBL_TY)
1860: RETURN ASO_QUOTE_PUB.QTE_LINE_TBL_TYPE IS
1861: aPlsqlItem ASO_QUOTE_PUB.QTE_LINE_TBL_TYPE;
1862: BEGIN
1863: begin
1856: END IF;
1857: RETURN aSqlItem;
1858: END PL_TO_SQL1;
1859: FUNCTION SQL_TO_PL10(aSqlItem ASO_QUOTE_PUB_QTE_LINE_TBL_TY)
1860: RETURN ASO_QUOTE_PUB.QTE_LINE_TBL_TYPE IS
1861: aPlsqlItem ASO_QUOTE_PUB.QTE_LINE_TBL_TYPE;
1862: BEGIN
1863: begin
1864: FOR I IN 1..aSqlItem.COUNT LOOP
1857: RETURN aSqlItem;
1858: END PL_TO_SQL1;
1859: FUNCTION SQL_TO_PL10(aSqlItem ASO_QUOTE_PUB_QTE_LINE_TBL_TY)
1860: RETURN ASO_QUOTE_PUB.QTE_LINE_TBL_TYPE IS
1861: aPlsqlItem ASO_QUOTE_PUB.QTE_LINE_TBL_TYPE;
1862: BEGIN
1863: begin
1864: FOR I IN 1..aSqlItem.COUNT LOOP
1865: aPlsqlItem(I) := SQL_TO_PL27(aSqlItem(I));
1869: null;
1870: end;
1871: RETURN aPlsqlItem;
1872: END SQL_TO_PL10;
1873: FUNCTION PL_TO_SQL28(aPlsqlItem ASO_QUOTE_PUB.QTE_LINE_DTL_REC_TYPE)
1874: RETURN ASO_QUOTE_PUB_QTE_LINE_DTL_RE IS
1875: aSqlItem ASO_QUOTE_PUB_QTE_LINE_DTL_RE;
1876: BEGIN
1877: -- initialize the object
1870: end;
1871: RETURN aPlsqlItem;
1872: END SQL_TO_PL10;
1873: FUNCTION PL_TO_SQL28(aPlsqlItem ASO_QUOTE_PUB.QTE_LINE_DTL_REC_TYPE)
1874: RETURN ASO_QUOTE_PUB_QTE_LINE_DTL_RE IS
1875: aSqlItem ASO_QUOTE_PUB_QTE_LINE_DTL_RE;
1876: BEGIN
1877: -- initialize the object
1878: aSqlItem := ASO_QUOTE_PUB_QTE_LINE_DTL_RE(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
1871: RETURN aPlsqlItem;
1872: END SQL_TO_PL10;
1873: FUNCTION PL_TO_SQL28(aPlsqlItem ASO_QUOTE_PUB.QTE_LINE_DTL_REC_TYPE)
1874: RETURN ASO_QUOTE_PUB_QTE_LINE_DTL_RE IS
1875: aSqlItem ASO_QUOTE_PUB_QTE_LINE_DTL_RE;
1876: BEGIN
1877: -- initialize the object
1878: aSqlItem := ASO_QUOTE_PUB_QTE_LINE_DTL_RE(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
1879: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
1874: RETURN ASO_QUOTE_PUB_QTE_LINE_DTL_RE IS
1875: aSqlItem ASO_QUOTE_PUB_QTE_LINE_DTL_RE;
1876: BEGIN
1877: -- initialize the object
1878: aSqlItem := ASO_QUOTE_PUB_QTE_LINE_DTL_RE(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
1879: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
1880: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
1881: NULL, NULL, NULL, NULL, NULL, NULL, NULL);
1882: aSqlItem.OPERATION_CODE := aPlsqlItem.OPERATION_CODE;
1970: aSqlItem.ATTRIBUTE19 := aPlsqlItem.ATTRIBUTE19;
1971: aSqlItem.ATTRIBUTE20 := aPlsqlItem.ATTRIBUTE20;
1972: RETURN aSqlItem;
1973: END PL_TO_SQL28;
1974: FUNCTION SQL_TO_PL28(aSqlItem ASO_QUOTE_PUB_QTE_LINE_DTL_RE)
1975: RETURN ASO_QUOTE_PUB.QTE_LINE_DTL_REC_TYPE IS
1976: aPlsqlItem ASO_QUOTE_PUB.QTE_LINE_DTL_REC_TYPE;
1977: BEGIN
1978: aPlsqlItem.OPERATION_CODE := aSqlItem.OPERATION_CODE;
1971: aSqlItem.ATTRIBUTE20 := aPlsqlItem.ATTRIBUTE20;
1972: RETURN aSqlItem;
1973: END PL_TO_SQL28;
1974: FUNCTION SQL_TO_PL28(aSqlItem ASO_QUOTE_PUB_QTE_LINE_DTL_RE)
1975: RETURN ASO_QUOTE_PUB.QTE_LINE_DTL_REC_TYPE IS
1976: aPlsqlItem ASO_QUOTE_PUB.QTE_LINE_DTL_REC_TYPE;
1977: BEGIN
1978: aPlsqlItem.OPERATION_CODE := aSqlItem.OPERATION_CODE;
1979: aPlsqlItem.QTE_LINE_INDEX := aSqlItem.QTE_LINE_INDEX;
1972: RETURN aSqlItem;
1973: END PL_TO_SQL28;
1974: FUNCTION SQL_TO_PL28(aSqlItem ASO_QUOTE_PUB_QTE_LINE_DTL_RE)
1975: RETURN ASO_QUOTE_PUB.QTE_LINE_DTL_REC_TYPE IS
1976: aPlsqlItem ASO_QUOTE_PUB.QTE_LINE_DTL_REC_TYPE;
1977: BEGIN
1978: aPlsqlItem.OPERATION_CODE := aSqlItem.OPERATION_CODE;
1979: aPlsqlItem.QTE_LINE_INDEX := aSqlItem.QTE_LINE_INDEX;
1980: aPlsqlItem.QUOTE_LINE_DETAIL_ID := aSqlItem.QUOTE_LINE_DETAIL_ID;
2066: aPlsqlItem.ATTRIBUTE19 := aSqlItem.ATTRIBUTE19;
2067: aPlsqlItem.ATTRIBUTE20 := aSqlItem.ATTRIBUTE20;
2068: RETURN aPlsqlItem;
2069: END SQL_TO_PL28;
2070: FUNCTION PL_TO_SQL2(aPlsqlItem ASO_QUOTE_PUB.QTE_LINE_DTL_TBL_TYPE)
2071: RETURN ASO_QUOTE_PUB_QTE_LINE_DTL_TB IS
2072: aSqlItem ASO_QUOTE_PUB_QTE_LINE_DTL_TB;
2073: BEGIN
2074: -- initialize the table
2067: aPlsqlItem.ATTRIBUTE20 := aSqlItem.ATTRIBUTE20;
2068: RETURN aPlsqlItem;
2069: END SQL_TO_PL28;
2070: FUNCTION PL_TO_SQL2(aPlsqlItem ASO_QUOTE_PUB.QTE_LINE_DTL_TBL_TYPE)
2071: RETURN ASO_QUOTE_PUB_QTE_LINE_DTL_TB IS
2072: aSqlItem ASO_QUOTE_PUB_QTE_LINE_DTL_TB;
2073: BEGIN
2074: -- initialize the table
2075: aSqlItem := ASO_QUOTE_PUB_QTE_LINE_DTL_TB();
2068: RETURN aPlsqlItem;
2069: END SQL_TO_PL28;
2070: FUNCTION PL_TO_SQL2(aPlsqlItem ASO_QUOTE_PUB.QTE_LINE_DTL_TBL_TYPE)
2071: RETURN ASO_QUOTE_PUB_QTE_LINE_DTL_TB IS
2072: aSqlItem ASO_QUOTE_PUB_QTE_LINE_DTL_TB;
2073: BEGIN
2074: -- initialize the table
2075: aSqlItem := ASO_QUOTE_PUB_QTE_LINE_DTL_TB();
2076: IF aPlsqlItem.COUNT > 0 THEN
2071: RETURN ASO_QUOTE_PUB_QTE_LINE_DTL_TB IS
2072: aSqlItem ASO_QUOTE_PUB_QTE_LINE_DTL_TB;
2073: BEGIN
2074: -- initialize the table
2075: aSqlItem := ASO_QUOTE_PUB_QTE_LINE_DTL_TB();
2076: IF aPlsqlItem.COUNT > 0 THEN
2077: aSqlItem.EXTEND(aPlsqlItem.COUNT);
2078: FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
2079: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL28(aPlsqlItem(I));
2080: END LOOP;
2081: END IF;
2082: RETURN aSqlItem;
2083: END PL_TO_SQL2;
2084: FUNCTION SQL_TO_PL11(aSqlItem ASO_QUOTE_PUB_QTE_LINE_DTL_TB)
2085: RETURN ASO_QUOTE_PUB.QTE_LINE_DTL_TBL_TYPE IS
2086: aPlsqlItem ASO_QUOTE_PUB.QTE_LINE_DTL_TBL_TYPE;
2087: BEGIN
2088: begin
2081: END IF;
2082: RETURN aSqlItem;
2083: END PL_TO_SQL2;
2084: FUNCTION SQL_TO_PL11(aSqlItem ASO_QUOTE_PUB_QTE_LINE_DTL_TB)
2085: RETURN ASO_QUOTE_PUB.QTE_LINE_DTL_TBL_TYPE IS
2086: aPlsqlItem ASO_QUOTE_PUB.QTE_LINE_DTL_TBL_TYPE;
2087: BEGIN
2088: begin
2089: FOR I IN 1..aSqlItem.COUNT LOOP
2082: RETURN aSqlItem;
2083: END PL_TO_SQL2;
2084: FUNCTION SQL_TO_PL11(aSqlItem ASO_QUOTE_PUB_QTE_LINE_DTL_TB)
2085: RETURN ASO_QUOTE_PUB.QTE_LINE_DTL_TBL_TYPE IS
2086: aPlsqlItem ASO_QUOTE_PUB.QTE_LINE_DTL_TBL_TYPE;
2087: BEGIN
2088: begin
2089: FOR I IN 1..aSqlItem.COUNT LOOP
2090: aPlsqlItem(I) := SQL_TO_PL28(aSqlItem(I));
2094: null;
2095: end;
2096: RETURN aPlsqlItem;
2097: END SQL_TO_PL11;
2098: FUNCTION PL_TO_SQL29(aPlsqlItem ASO_QUOTE_PUB.LINE_RLTSHIP_REC_TYPE)
2099: RETURN ASO_QUOTE_PUB_LINE_RLTSHIP_RE IS
2100: aSqlItem ASO_QUOTE_PUB_LINE_RLTSHIP_RE;
2101: BEGIN
2102: -- initialize the object
2095: end;
2096: RETURN aPlsqlItem;
2097: END SQL_TO_PL11;
2098: FUNCTION PL_TO_SQL29(aPlsqlItem ASO_QUOTE_PUB.LINE_RLTSHIP_REC_TYPE)
2099: RETURN ASO_QUOTE_PUB_LINE_RLTSHIP_RE IS
2100: aSqlItem ASO_QUOTE_PUB_LINE_RLTSHIP_RE;
2101: BEGIN
2102: -- initialize the object
2103: aSqlItem := ASO_QUOTE_PUB_LINE_RLTSHIP_RE(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
2096: RETURN aPlsqlItem;
2097: END SQL_TO_PL11;
2098: FUNCTION PL_TO_SQL29(aPlsqlItem ASO_QUOTE_PUB.LINE_RLTSHIP_REC_TYPE)
2099: RETURN ASO_QUOTE_PUB_LINE_RLTSHIP_RE IS
2100: aSqlItem ASO_QUOTE_PUB_LINE_RLTSHIP_RE;
2101: BEGIN
2102: -- initialize the object
2103: aSqlItem := ASO_QUOTE_PUB_LINE_RLTSHIP_RE(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
2104: aSqlItem.OPERATION_CODE := aPlsqlItem.OPERATION_CODE;
2099: RETURN ASO_QUOTE_PUB_LINE_RLTSHIP_RE IS
2100: aSqlItem ASO_QUOTE_PUB_LINE_RLTSHIP_RE;
2101: BEGIN
2102: -- initialize the object
2103: aSqlItem := ASO_QUOTE_PUB_LINE_RLTSHIP_RE(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
2104: aSqlItem.OPERATION_CODE := aPlsqlItem.OPERATION_CODE;
2105: aSqlItem.LINE_RELATIONSHIP_ID := aPlsqlItem.LINE_RELATIONSHIP_ID;
2106: aSqlItem.CREATION_DATE := aPlsqlItem.CREATION_DATE;
2107: aSqlItem.CREATED_BY := aPlsqlItem.CREATED_BY;
2120: aSqlItem.RECIPROCAL_FLAG := aPlsqlItem.RECIPROCAL_FLAG;
2121: aSqlItem.OBJECT_VERSION_NUMBER := aPlsqlItem.OBJECT_VERSION_NUMBER;
2122: RETURN aSqlItem;
2123: END PL_TO_SQL29;
2124: FUNCTION SQL_TO_PL29(aSqlItem ASO_QUOTE_PUB_LINE_RLTSHIP_RE)
2125: RETURN ASO_QUOTE_PUB.LINE_RLTSHIP_REC_TYPE IS
2126: aPlsqlItem ASO_QUOTE_PUB.LINE_RLTSHIP_REC_TYPE;
2127: BEGIN
2128: aPlsqlItem.OPERATION_CODE := aSqlItem.OPERATION_CODE;
2121: aSqlItem.OBJECT_VERSION_NUMBER := aPlsqlItem.OBJECT_VERSION_NUMBER;
2122: RETURN aSqlItem;
2123: END PL_TO_SQL29;
2124: FUNCTION SQL_TO_PL29(aSqlItem ASO_QUOTE_PUB_LINE_RLTSHIP_RE)
2125: RETURN ASO_QUOTE_PUB.LINE_RLTSHIP_REC_TYPE IS
2126: aPlsqlItem ASO_QUOTE_PUB.LINE_RLTSHIP_REC_TYPE;
2127: BEGIN
2128: aPlsqlItem.OPERATION_CODE := aSqlItem.OPERATION_CODE;
2129: aPlsqlItem.LINE_RELATIONSHIP_ID := aSqlItem.LINE_RELATIONSHIP_ID;
2122: RETURN aSqlItem;
2123: END PL_TO_SQL29;
2124: FUNCTION SQL_TO_PL29(aSqlItem ASO_QUOTE_PUB_LINE_RLTSHIP_RE)
2125: RETURN ASO_QUOTE_PUB.LINE_RLTSHIP_REC_TYPE IS
2126: aPlsqlItem ASO_QUOTE_PUB.LINE_RLTSHIP_REC_TYPE;
2127: BEGIN
2128: aPlsqlItem.OPERATION_CODE := aSqlItem.OPERATION_CODE;
2129: aPlsqlItem.LINE_RELATIONSHIP_ID := aSqlItem.LINE_RELATIONSHIP_ID;
2130: aPlsqlItem.CREATION_DATE := aSqlItem.CREATION_DATE;
2144: aPlsqlItem.RECIPROCAL_FLAG := aSqlItem.RECIPROCAL_FLAG;
2145: aPlsqlItem.OBJECT_VERSION_NUMBER := aSqlItem.OBJECT_VERSION_NUMBER;
2146: RETURN aPlsqlItem;
2147: END SQL_TO_PL29;
2148: FUNCTION PL_TO_SQL11(aPlsqlItem ASO_QUOTE_PUB.LINE_RLTSHIP_TBL_TYPE)
2149: RETURN ASO_QUOTE_PUB_LINE_RLTSHIP_TB IS
2150: aSqlItem ASO_QUOTE_PUB_LINE_RLTSHIP_TB;
2151: BEGIN
2152: -- initialize the table
2145: aPlsqlItem.OBJECT_VERSION_NUMBER := aSqlItem.OBJECT_VERSION_NUMBER;
2146: RETURN aPlsqlItem;
2147: END SQL_TO_PL29;
2148: FUNCTION PL_TO_SQL11(aPlsqlItem ASO_QUOTE_PUB.LINE_RLTSHIP_TBL_TYPE)
2149: RETURN ASO_QUOTE_PUB_LINE_RLTSHIP_TB IS
2150: aSqlItem ASO_QUOTE_PUB_LINE_RLTSHIP_TB;
2151: BEGIN
2152: -- initialize the table
2153: aSqlItem := ASO_QUOTE_PUB_LINE_RLTSHIP_TB();
2146: RETURN aPlsqlItem;
2147: END SQL_TO_PL29;
2148: FUNCTION PL_TO_SQL11(aPlsqlItem ASO_QUOTE_PUB.LINE_RLTSHIP_TBL_TYPE)
2149: RETURN ASO_QUOTE_PUB_LINE_RLTSHIP_TB IS
2150: aSqlItem ASO_QUOTE_PUB_LINE_RLTSHIP_TB;
2151: BEGIN
2152: -- initialize the table
2153: aSqlItem := ASO_QUOTE_PUB_LINE_RLTSHIP_TB();
2154: IF aPlsqlItem.COUNT > 0 THEN
2149: RETURN ASO_QUOTE_PUB_LINE_RLTSHIP_TB IS
2150: aSqlItem ASO_QUOTE_PUB_LINE_RLTSHIP_TB;
2151: BEGIN
2152: -- initialize the table
2153: aSqlItem := ASO_QUOTE_PUB_LINE_RLTSHIP_TB();
2154: IF aPlsqlItem.COUNT > 0 THEN
2155: aSqlItem.EXTEND(aPlsqlItem.COUNT);
2156: FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
2157: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL29(aPlsqlItem(I));
2158: END LOOP;
2159: END IF;
2160: RETURN aSqlItem;
2161: END PL_TO_SQL11;
2162: FUNCTION SQL_TO_PL12(aSqlItem ASO_QUOTE_PUB_LINE_RLTSHIP_TB)
2163: RETURN ASO_QUOTE_PUB.LINE_RLTSHIP_TBL_TYPE IS
2164: aPlsqlItem ASO_QUOTE_PUB.LINE_RLTSHIP_TBL_TYPE;
2165: BEGIN
2166: begin
2159: END IF;
2160: RETURN aSqlItem;
2161: END PL_TO_SQL11;
2162: FUNCTION SQL_TO_PL12(aSqlItem ASO_QUOTE_PUB_LINE_RLTSHIP_TB)
2163: RETURN ASO_QUOTE_PUB.LINE_RLTSHIP_TBL_TYPE IS
2164: aPlsqlItem ASO_QUOTE_PUB.LINE_RLTSHIP_TBL_TYPE;
2165: BEGIN
2166: begin
2167: FOR I IN 1..aSqlItem.COUNT LOOP
2160: RETURN aSqlItem;
2161: END PL_TO_SQL11;
2162: FUNCTION SQL_TO_PL12(aSqlItem ASO_QUOTE_PUB_LINE_RLTSHIP_TB)
2163: RETURN ASO_QUOTE_PUB.LINE_RLTSHIP_TBL_TYPE IS
2164: aPlsqlItem ASO_QUOTE_PUB.LINE_RLTSHIP_TBL_TYPE;
2165: BEGIN
2166: begin
2167: FOR I IN 1..aSqlItem.COUNT LOOP
2168: aPlsqlItem(I) := SQL_TO_PL29(aSqlItem(I));
2172: null;
2173: end;
2174: RETURN aPlsqlItem;
2175: END SQL_TO_PL12;
2176: FUNCTION PL_TO_SQL30(aPlsqlItem ASO_QUOTE_PUB.PRICE_ADJ_REC_TYPE)
2177: RETURN ASO_QUOTE_PUB_PRICE_ADJ_REC_T IS
2178: aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_REC_T;
2179: BEGIN
2180: -- initialize the object
2173: end;
2174: RETURN aPlsqlItem;
2175: END SQL_TO_PL12;
2176: FUNCTION PL_TO_SQL30(aPlsqlItem ASO_QUOTE_PUB.PRICE_ADJ_REC_TYPE)
2177: RETURN ASO_QUOTE_PUB_PRICE_ADJ_REC_T IS
2178: aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_REC_T;
2179: BEGIN
2180: -- initialize the object
2181: aSqlItem := ASO_QUOTE_PUB_PRICE_ADJ_REC_T(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
2174: RETURN aPlsqlItem;
2175: END SQL_TO_PL12;
2176: FUNCTION PL_TO_SQL30(aPlsqlItem ASO_QUOTE_PUB.PRICE_ADJ_REC_TYPE)
2177: RETURN ASO_QUOTE_PUB_PRICE_ADJ_REC_T IS
2178: aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_REC_T;
2179: BEGIN
2180: -- initialize the object
2181: aSqlItem := ASO_QUOTE_PUB_PRICE_ADJ_REC_T(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
2182: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
2177: RETURN ASO_QUOTE_PUB_PRICE_ADJ_REC_T IS
2178: aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_REC_T;
2179: BEGIN
2180: -- initialize the object
2181: aSqlItem := ASO_QUOTE_PUB_PRICE_ADJ_REC_T(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
2182: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
2183: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
2184: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
2185: aSqlItem.OPERATION_CODE := aPlsqlItem.OPERATION_CODE;
2276: aSqlItem.OPERAND_PER_PQTY := aPlsqlItem.OPERAND_PER_PQTY;
2277: aSqlItem.ADJUSTED_AMOUNT_PER_PQTY := aPlsqlItem.ADJUSTED_AMOUNT_PER_PQTY;
2278: RETURN aSqlItem;
2279: END PL_TO_SQL30;
2280: FUNCTION SQL_TO_PL30(aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_REC_T)
2281: RETURN ASO_QUOTE_PUB.PRICE_ADJ_REC_TYPE IS
2282: aPlsqlItem ASO_QUOTE_PUB.PRICE_ADJ_REC_TYPE;
2283: BEGIN
2284: aPlsqlItem.OPERATION_CODE := aSqlItem.OPERATION_CODE;
2277: aSqlItem.ADJUSTED_AMOUNT_PER_PQTY := aPlsqlItem.ADJUSTED_AMOUNT_PER_PQTY;
2278: RETURN aSqlItem;
2279: END PL_TO_SQL30;
2280: FUNCTION SQL_TO_PL30(aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_REC_T)
2281: RETURN ASO_QUOTE_PUB.PRICE_ADJ_REC_TYPE IS
2282: aPlsqlItem ASO_QUOTE_PUB.PRICE_ADJ_REC_TYPE;
2283: BEGIN
2284: aPlsqlItem.OPERATION_CODE := aSqlItem.OPERATION_CODE;
2285: aPlsqlItem.QTE_LINE_INDEX := aSqlItem.QTE_LINE_INDEX;
2278: RETURN aSqlItem;
2279: END PL_TO_SQL30;
2280: FUNCTION SQL_TO_PL30(aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_REC_T)
2281: RETURN ASO_QUOTE_PUB.PRICE_ADJ_REC_TYPE IS
2282: aPlsqlItem ASO_QUOTE_PUB.PRICE_ADJ_REC_TYPE;
2283: BEGIN
2284: aPlsqlItem.OPERATION_CODE := aSqlItem.OPERATION_CODE;
2285: aPlsqlItem.QTE_LINE_INDEX := aSqlItem.QTE_LINE_INDEX;
2286: aPlsqlItem.SHIPMENT_INDEX := aSqlItem.SHIPMENT_INDEX;
2375: aPlsqlItem.OPERAND_PER_PQTY := aSqlItem.OPERAND_PER_PQTY;
2376: aPlsqlItem.ADJUSTED_AMOUNT_PER_PQTY := aSqlItem.ADJUSTED_AMOUNT_PER_PQTY;
2377: RETURN aPlsqlItem;
2378: END SQL_TO_PL30;
2379: FUNCTION PL_TO_SQL12(aPlsqlItem ASO_QUOTE_PUB.PRICE_ADJ_TBL_TYPE)
2380: RETURN ASO_QUOTE_PUB_PRICE_ADJ_TBL_T IS
2381: aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_TBL_T;
2382: BEGIN
2383: -- initialize the table
2376: aPlsqlItem.ADJUSTED_AMOUNT_PER_PQTY := aSqlItem.ADJUSTED_AMOUNT_PER_PQTY;
2377: RETURN aPlsqlItem;
2378: END SQL_TO_PL30;
2379: FUNCTION PL_TO_SQL12(aPlsqlItem ASO_QUOTE_PUB.PRICE_ADJ_TBL_TYPE)
2380: RETURN ASO_QUOTE_PUB_PRICE_ADJ_TBL_T IS
2381: aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_TBL_T;
2382: BEGIN
2383: -- initialize the table
2384: aSqlItem := ASO_QUOTE_PUB_PRICE_ADJ_TBL_T();
2377: RETURN aPlsqlItem;
2378: END SQL_TO_PL30;
2379: FUNCTION PL_TO_SQL12(aPlsqlItem ASO_QUOTE_PUB.PRICE_ADJ_TBL_TYPE)
2380: RETURN ASO_QUOTE_PUB_PRICE_ADJ_TBL_T IS
2381: aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_TBL_T;
2382: BEGIN
2383: -- initialize the table
2384: aSqlItem := ASO_QUOTE_PUB_PRICE_ADJ_TBL_T();
2385: IF aPlsqlItem.COUNT > 0 THEN
2380: RETURN ASO_QUOTE_PUB_PRICE_ADJ_TBL_T IS
2381: aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_TBL_T;
2382: BEGIN
2383: -- initialize the table
2384: aSqlItem := ASO_QUOTE_PUB_PRICE_ADJ_TBL_T();
2385: IF aPlsqlItem.COUNT > 0 THEN
2386: aSqlItem.EXTEND(aPlsqlItem.COUNT);
2387: FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
2388: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL30(aPlsqlItem(I));
2389: END LOOP;
2390: END IF;
2391: RETURN aSqlItem;
2392: END PL_TO_SQL12;
2393: FUNCTION SQL_TO_PL13(aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_TBL_T)
2394: RETURN ASO_QUOTE_PUB.PRICE_ADJ_TBL_TYPE IS
2395: aPlsqlItem ASO_QUOTE_PUB.PRICE_ADJ_TBL_TYPE;
2396: BEGIN
2397: begin
2390: END IF;
2391: RETURN aSqlItem;
2392: END PL_TO_SQL12;
2393: FUNCTION SQL_TO_PL13(aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_TBL_T)
2394: RETURN ASO_QUOTE_PUB.PRICE_ADJ_TBL_TYPE IS
2395: aPlsqlItem ASO_QUOTE_PUB.PRICE_ADJ_TBL_TYPE;
2396: BEGIN
2397: begin
2398: FOR I IN 1..aSqlItem.COUNT LOOP
2391: RETURN aSqlItem;
2392: END PL_TO_SQL12;
2393: FUNCTION SQL_TO_PL13(aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_TBL_T)
2394: RETURN ASO_QUOTE_PUB.PRICE_ADJ_TBL_TYPE IS
2395: aPlsqlItem ASO_QUOTE_PUB.PRICE_ADJ_TBL_TYPE;
2396: BEGIN
2397: begin
2398: FOR I IN 1..aSqlItem.COUNT LOOP
2399: aPlsqlItem(I) := SQL_TO_PL30(aSqlItem(I));
2403: null;
2404: end;
2405: RETURN aPlsqlItem;
2406: END SQL_TO_PL13;
2407: FUNCTION PL_TO_SQL31(aPlsqlItem ASO_QUOTE_PUB.PRICE_ADJ_ATTR_REC_TYPE)
2408: RETURN ASO_QUOTE_PUB_PRICE_ADJ_ATT37 IS
2409: aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_ATT37;
2410: BEGIN
2411: -- initialize the object
2404: end;
2405: RETURN aPlsqlItem;
2406: END SQL_TO_PL13;
2407: FUNCTION PL_TO_SQL31(aPlsqlItem ASO_QUOTE_PUB.PRICE_ADJ_ATTR_REC_TYPE)
2408: RETURN ASO_QUOTE_PUB_PRICE_ADJ_ATT37 IS
2409: aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_ATT37;
2410: BEGIN
2411: -- initialize the object
2412: aSqlItem := ASO_QUOTE_PUB_PRICE_ADJ_ATT37(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
2405: RETURN aPlsqlItem;
2406: END SQL_TO_PL13;
2407: FUNCTION PL_TO_SQL31(aPlsqlItem ASO_QUOTE_PUB.PRICE_ADJ_ATTR_REC_TYPE)
2408: RETURN ASO_QUOTE_PUB_PRICE_ADJ_ATT37 IS
2409: aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_ATT37;
2410: BEGIN
2411: -- initialize the object
2412: aSqlItem := ASO_QUOTE_PUB_PRICE_ADJ_ATT37(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
2413: aSqlItem.OPERATION_CODE := aPlsqlItem.OPERATION_CODE;
2408: RETURN ASO_QUOTE_PUB_PRICE_ADJ_ATT37 IS
2409: aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_ATT37;
2410: BEGIN
2411: -- initialize the object
2412: aSqlItem := ASO_QUOTE_PUB_PRICE_ADJ_ATT37(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
2413: aSqlItem.OPERATION_CODE := aPlsqlItem.OPERATION_CODE;
2414: aSqlItem.QTE_LINE_INDEX := aPlsqlItem.QTE_LINE_INDEX;
2415: aSqlItem.SHIPMENT_INDEX := aPlsqlItem.SHIPMENT_INDEX;
2416: aSqlItem.PRICE_ADJ_INDEX := aPlsqlItem.PRICE_ADJ_INDEX;
2433: aSqlItem.FLEX_TITLE := aPlsqlItem.FLEX_TITLE;
2434: aSqlItem.OBJECT_VERSION_NUMBER := aPlsqlItem.OBJECT_VERSION_NUMBER;
2435: RETURN aSqlItem;
2436: END PL_TO_SQL31;
2437: FUNCTION SQL_TO_PL31(aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_ATT37)
2438: RETURN ASO_QUOTE_PUB.PRICE_ADJ_ATTR_REC_TYPE IS
2439: aPlsqlItem ASO_QUOTE_PUB.PRICE_ADJ_ATTR_REC_TYPE;
2440: BEGIN
2441: aPlsqlItem.OPERATION_CODE := aSqlItem.OPERATION_CODE;
2434: aSqlItem.OBJECT_VERSION_NUMBER := aPlsqlItem.OBJECT_VERSION_NUMBER;
2435: RETURN aSqlItem;
2436: END PL_TO_SQL31;
2437: FUNCTION SQL_TO_PL31(aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_ATT37)
2438: RETURN ASO_QUOTE_PUB.PRICE_ADJ_ATTR_REC_TYPE IS
2439: aPlsqlItem ASO_QUOTE_PUB.PRICE_ADJ_ATTR_REC_TYPE;
2440: BEGIN
2441: aPlsqlItem.OPERATION_CODE := aSqlItem.OPERATION_CODE;
2442: aPlsqlItem.QTE_LINE_INDEX := aSqlItem.QTE_LINE_INDEX;
2435: RETURN aSqlItem;
2436: END PL_TO_SQL31;
2437: FUNCTION SQL_TO_PL31(aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_ATT37)
2438: RETURN ASO_QUOTE_PUB.PRICE_ADJ_ATTR_REC_TYPE IS
2439: aPlsqlItem ASO_QUOTE_PUB.PRICE_ADJ_ATTR_REC_TYPE;
2440: BEGIN
2441: aPlsqlItem.OPERATION_CODE := aSqlItem.OPERATION_CODE;
2442: aPlsqlItem.QTE_LINE_INDEX := aSqlItem.QTE_LINE_INDEX;
2443: aPlsqlItem.SHIPMENT_INDEX := aSqlItem.SHIPMENT_INDEX;
2461: aPlsqlItem.FLEX_TITLE := aSqlItem.FLEX_TITLE;
2462: aPlsqlItem.OBJECT_VERSION_NUMBER := aSqlItem.OBJECT_VERSION_NUMBER;
2463: RETURN aPlsqlItem;
2464: END SQL_TO_PL31;
2465: FUNCTION PL_TO_SQL13(aPlsqlItem ASO_QUOTE_PUB.PRICE_ADJ_ATTR_TBL_TYPE)
2466: RETURN ASO_QUOTE_PUB_PRICE_ADJ_ATTR_ IS
2467: aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_ATTR_;
2468: BEGIN
2469: -- initialize the table
2462: aPlsqlItem.OBJECT_VERSION_NUMBER := aSqlItem.OBJECT_VERSION_NUMBER;
2463: RETURN aPlsqlItem;
2464: END SQL_TO_PL31;
2465: FUNCTION PL_TO_SQL13(aPlsqlItem ASO_QUOTE_PUB.PRICE_ADJ_ATTR_TBL_TYPE)
2466: RETURN ASO_QUOTE_PUB_PRICE_ADJ_ATTR_ IS
2467: aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_ATTR_;
2468: BEGIN
2469: -- initialize the table
2470: aSqlItem := ASO_QUOTE_PUB_PRICE_ADJ_ATTR_();
2463: RETURN aPlsqlItem;
2464: END SQL_TO_PL31;
2465: FUNCTION PL_TO_SQL13(aPlsqlItem ASO_QUOTE_PUB.PRICE_ADJ_ATTR_TBL_TYPE)
2466: RETURN ASO_QUOTE_PUB_PRICE_ADJ_ATTR_ IS
2467: aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_ATTR_;
2468: BEGIN
2469: -- initialize the table
2470: aSqlItem := ASO_QUOTE_PUB_PRICE_ADJ_ATTR_();
2471: IF aPlsqlItem.COUNT > 0 THEN
2466: RETURN ASO_QUOTE_PUB_PRICE_ADJ_ATTR_ IS
2467: aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_ATTR_;
2468: BEGIN
2469: -- initialize the table
2470: aSqlItem := ASO_QUOTE_PUB_PRICE_ADJ_ATTR_();
2471: IF aPlsqlItem.COUNT > 0 THEN
2472: aSqlItem.EXTEND(aPlsqlItem.COUNT);
2473: FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
2474: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL31(aPlsqlItem(I));
2475: END LOOP;
2476: END IF;
2477: RETURN aSqlItem;
2478: END PL_TO_SQL13;
2479: FUNCTION SQL_TO_PL14(aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_ATTR_)
2480: RETURN ASO_QUOTE_PUB.PRICE_ADJ_ATTR_TBL_TYPE IS
2481: aPlsqlItem ASO_QUOTE_PUB.PRICE_ADJ_ATTR_TBL_TYPE;
2482: BEGIN
2483: BEGIN
2476: END IF;
2477: RETURN aSqlItem;
2478: END PL_TO_SQL13;
2479: FUNCTION SQL_TO_PL14(aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_ATTR_)
2480: RETURN ASO_QUOTE_PUB.PRICE_ADJ_ATTR_TBL_TYPE IS
2481: aPlsqlItem ASO_QUOTE_PUB.PRICE_ADJ_ATTR_TBL_TYPE;
2482: BEGIN
2483: BEGIN
2484: FOR I IN 1..aSqlItem.COUNT LOOP
2477: RETURN aSqlItem;
2478: END PL_TO_SQL13;
2479: FUNCTION SQL_TO_PL14(aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_ATTR_)
2480: RETURN ASO_QUOTE_PUB.PRICE_ADJ_ATTR_TBL_TYPE IS
2481: aPlsqlItem ASO_QUOTE_PUB.PRICE_ADJ_ATTR_TBL_TYPE;
2482: BEGIN
2483: BEGIN
2484: FOR I IN 1..aSqlItem.COUNT LOOP
2485: aPlsqlItem(I) := SQL_TO_PL31(aSqlItem(I));
2489: null;
2490: end;
2491: RETURN aPlsqlItem;
2492: END SQL_TO_PL14;
2493: FUNCTION PL_TO_SQL32(aPlsqlItem ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_REC_TYPE)
2494: RETURN ASO_QUOTE_PUB_PRICE_ADJ_RLT38 IS
2495: aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_RLT38;
2496: BEGIN
2497: -- initialize the object
2490: end;
2491: RETURN aPlsqlItem;
2492: END SQL_TO_PL14;
2493: FUNCTION PL_TO_SQL32(aPlsqlItem ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_REC_TYPE)
2494: RETURN ASO_QUOTE_PUB_PRICE_ADJ_RLT38 IS
2495: aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_RLT38;
2496: BEGIN
2497: -- initialize the object
2498: aSqlItem := ASO_QUOTE_PUB_PRICE_ADJ_RLT38(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
2491: RETURN aPlsqlItem;
2492: END SQL_TO_PL14;
2493: FUNCTION PL_TO_SQL32(aPlsqlItem ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_REC_TYPE)
2494: RETURN ASO_QUOTE_PUB_PRICE_ADJ_RLT38 IS
2495: aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_RLT38;
2496: BEGIN
2497: -- initialize the object
2498: aSqlItem := ASO_QUOTE_PUB_PRICE_ADJ_RLT38(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
2499: aSqlItem.OPERATION_CODE := aPlsqlItem.OPERATION_CODE;
2494: RETURN ASO_QUOTE_PUB_PRICE_ADJ_RLT38 IS
2495: aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_RLT38;
2496: BEGIN
2497: -- initialize the object
2498: aSqlItem := ASO_QUOTE_PUB_PRICE_ADJ_RLT38(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
2499: aSqlItem.OPERATION_CODE := aPlsqlItem.OPERATION_CODE;
2500: aSqlItem.ADJ_RELATIONSHIP_ID := aPlsqlItem.ADJ_RELATIONSHIP_ID;
2501: aSqlItem.CREATION_DATE := aPlsqlItem.CREATION_DATE;
2502: aSqlItem.CREATED_BY := aPlsqlItem.CREATED_BY;
2517: aSqlItem.RLTD_PRICE_ADJ_INDEX := aPlsqlItem.RLTD_PRICE_ADJ_INDEX;
2518: aSqlItem.OBJECT_VERSION_NUMBER := aPlsqlItem.OBJECT_VERSION_NUMBER;
2519: RETURN aSqlItem;
2520: END PL_TO_SQL32;
2521: FUNCTION SQL_TO_PL32(aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_RLT38)
2522: RETURN ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_REC_TYPE IS
2523: aPlsqlItem ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_REC_TYPE;
2524: BEGIN
2525: aPlsqlItem.OPERATION_CODE := aSqlItem.OPERATION_CODE;
2518: aSqlItem.OBJECT_VERSION_NUMBER := aPlsqlItem.OBJECT_VERSION_NUMBER;
2519: RETURN aSqlItem;
2520: END PL_TO_SQL32;
2521: FUNCTION SQL_TO_PL32(aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_RLT38)
2522: RETURN ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_REC_TYPE IS
2523: aPlsqlItem ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_REC_TYPE;
2524: BEGIN
2525: aPlsqlItem.OPERATION_CODE := aSqlItem.OPERATION_CODE;
2526: aPlsqlItem.ADJ_RELATIONSHIP_ID := aSqlItem.ADJ_RELATIONSHIP_ID;
2519: RETURN aSqlItem;
2520: END PL_TO_SQL32;
2521: FUNCTION SQL_TO_PL32(aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_RLT38)
2522: RETURN ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_REC_TYPE IS
2523: aPlsqlItem ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_REC_TYPE;
2524: BEGIN
2525: aPlsqlItem.OPERATION_CODE := aSqlItem.OPERATION_CODE;
2526: aPlsqlItem.ADJ_RELATIONSHIP_ID := aSqlItem.ADJ_RELATIONSHIP_ID;
2527: aPlsqlItem.CREATION_DATE := aSqlItem.CREATION_DATE;
2543: aPlsqlItem.RLTD_PRICE_ADJ_INDEX := aSqlItem.RLTD_PRICE_ADJ_INDEX;
2544: aPlsqlItem.OBJECT_VERSION_NUMBER := aSqlItem.OBJECT_VERSION_NUMBER;
2545: RETURN aPlsqlItem;
2546: END SQL_TO_PL32;
2547: FUNCTION PL_TO_SQL14(aPlsqlItem ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_TBL_TYPE)
2548: RETURN ASO_QUOTE_PUB_PRICE_ADJ_RLTSH IS
2549: aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_RLTSH;
2550: BEGIN
2551: -- initialize the table
2544: aPlsqlItem.OBJECT_VERSION_NUMBER := aSqlItem.OBJECT_VERSION_NUMBER;
2545: RETURN aPlsqlItem;
2546: END SQL_TO_PL32;
2547: FUNCTION PL_TO_SQL14(aPlsqlItem ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_TBL_TYPE)
2548: RETURN ASO_QUOTE_PUB_PRICE_ADJ_RLTSH IS
2549: aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_RLTSH;
2550: BEGIN
2551: -- initialize the table
2552: aSqlItem := ASO_QUOTE_PUB_PRICE_ADJ_RLTSH();
2545: RETURN aPlsqlItem;
2546: END SQL_TO_PL32;
2547: FUNCTION PL_TO_SQL14(aPlsqlItem ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_TBL_TYPE)
2548: RETURN ASO_QUOTE_PUB_PRICE_ADJ_RLTSH IS
2549: aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_RLTSH;
2550: BEGIN
2551: -- initialize the table
2552: aSqlItem := ASO_QUOTE_PUB_PRICE_ADJ_RLTSH();
2553: IF aPlsqlItem.COUNT > 0 THEN
2548: RETURN ASO_QUOTE_PUB_PRICE_ADJ_RLTSH IS
2549: aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_RLTSH;
2550: BEGIN
2551: -- initialize the table
2552: aSqlItem := ASO_QUOTE_PUB_PRICE_ADJ_RLTSH();
2553: IF aPlsqlItem.COUNT > 0 THEN
2554: aSqlItem.EXTEND(aPlsqlItem.COUNT);
2555: FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
2556: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL32(aPlsqlItem(I));
2557: END LOOP;
2558: END IF ;
2559: RETURN aSqlItem;
2560: END PL_TO_SQL14;
2561: FUNCTION SQL_TO_PL15(aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_RLTSH)
2562: RETURN ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_TBL_TYPE IS
2563: aPlsqlItem ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_TBL_TYPE;
2564: BEGIN
2565: begin
2558: END IF ;
2559: RETURN aSqlItem;
2560: END PL_TO_SQL14;
2561: FUNCTION SQL_TO_PL15(aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_RLTSH)
2562: RETURN ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_TBL_TYPE IS
2563: aPlsqlItem ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_TBL_TYPE;
2564: BEGIN
2565: begin
2566: FOR I IN 1..aSqlItem.COUNT LOOP
2559: RETURN aSqlItem;
2560: END PL_TO_SQL14;
2561: FUNCTION SQL_TO_PL15(aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_RLTSH)
2562: RETURN ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_TBL_TYPE IS
2563: aPlsqlItem ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_TBL_TYPE;
2564: BEGIN
2565: begin
2566: FOR I IN 1..aSqlItem.COUNT LOOP
2567: aPlsqlItem(I) := SQL_TO_PL32(aSqlItem(I));
2571: null;
2572: end;
2573: RETURN aPlsqlItem;
2574: END SQL_TO_PL15;
2575: FUNCTION PL_TO_SQL15(aPlsqlItem ASO_QUOTE_PUB.SHIPMENT_TBL_TYPE)
2576: RETURN ASO_QUOTE_PUB_SHIPMENT_TBL_TY IS
2577: aSqlItem ASO_QUOTE_PUB_SHIPMENT_TBL_TY;
2578: BEGIN
2579: -- initialize the table
2572: end;
2573: RETURN aPlsqlItem;
2574: END SQL_TO_PL15;
2575: FUNCTION PL_TO_SQL15(aPlsqlItem ASO_QUOTE_PUB.SHIPMENT_TBL_TYPE)
2576: RETURN ASO_QUOTE_PUB_SHIPMENT_TBL_TY IS
2577: aSqlItem ASO_QUOTE_PUB_SHIPMENT_TBL_TY;
2578: BEGIN
2579: -- initialize the table
2580: aSqlItem := ASO_QUOTE_PUB_SHIPMENT_TBL_TY();
2573: RETURN aPlsqlItem;
2574: END SQL_TO_PL15;
2575: FUNCTION PL_TO_SQL15(aPlsqlItem ASO_QUOTE_PUB.SHIPMENT_TBL_TYPE)
2576: RETURN ASO_QUOTE_PUB_SHIPMENT_TBL_TY IS
2577: aSqlItem ASO_QUOTE_PUB_SHIPMENT_TBL_TY;
2578: BEGIN
2579: -- initialize the table
2580: aSqlItem := ASO_QUOTE_PUB_SHIPMENT_TBL_TY();
2581: IF aPlsqlItem.COUNT > 0 THEN
2576: RETURN ASO_QUOTE_PUB_SHIPMENT_TBL_TY IS
2577: aSqlItem ASO_QUOTE_PUB_SHIPMENT_TBL_TY;
2578: BEGIN
2579: -- initialize the table
2580: aSqlItem := ASO_QUOTE_PUB_SHIPMENT_TBL_TY();
2581: IF aPlsqlItem.COUNT > 0 THEN
2582: aSqlItem.EXTEND(aPlsqlItem.COUNT);
2583: FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
2584: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL5(aPlsqlItem(I));
2585: END LOOP;
2586: END IF;
2587: RETURN aSqlItem;
2588: END PL_TO_SQL15;
2589: FUNCTION SQL_TO_PL16(aSqlItem ASO_QUOTE_PUB_SHIPMENT_TBL_TY)
2590: RETURN ASO_QUOTE_PUB.SHIPMENT_TBL_TYPE IS
2591: aPlsqlItem ASO_QUOTE_PUB.SHIPMENT_TBL_TYPE;
2592: BEGIN
2593: begin
2586: END IF;
2587: RETURN aSqlItem;
2588: END PL_TO_SQL15;
2589: FUNCTION SQL_TO_PL16(aSqlItem ASO_QUOTE_PUB_SHIPMENT_TBL_TY)
2590: RETURN ASO_QUOTE_PUB.SHIPMENT_TBL_TYPE IS
2591: aPlsqlItem ASO_QUOTE_PUB.SHIPMENT_TBL_TYPE;
2592: BEGIN
2593: begin
2594: FOR I IN 1..aSqlItem.COUNT LOOP
2587: RETURN aSqlItem;
2588: END PL_TO_SQL15;
2589: FUNCTION SQL_TO_PL16(aSqlItem ASO_QUOTE_PUB_SHIPMENT_TBL_TY)
2590: RETURN ASO_QUOTE_PUB.SHIPMENT_TBL_TYPE IS
2591: aPlsqlItem ASO_QUOTE_PUB.SHIPMENT_TBL_TYPE;
2592: BEGIN
2593: begin
2594: FOR I IN 1..aSqlItem.COUNT LOOP
2595: aPlsqlItem(I) := SQL_TO_PL4(aSqlItem(I));
2599: null;
2600: end;
2601: RETURN aPlsqlItem;
2602: END SQL_TO_PL16;
2603: FUNCTION PL_TO_SQL33(aPlsqlItem ASO_QUOTE_PUB.QTE_ACCESS_REC_TYPE)
2604: RETURN ASO_QUOTE_PUB_QTE_ACCESS_REC_ IS
2605: aSqlItem ASO_QUOTE_PUB_QTE_ACCESS_REC_;
2606: BEGIN
2607: -- initialize the object
2600: end;
2601: RETURN aPlsqlItem;
2602: END SQL_TO_PL16;
2603: FUNCTION PL_TO_SQL33(aPlsqlItem ASO_QUOTE_PUB.QTE_ACCESS_REC_TYPE)
2604: RETURN ASO_QUOTE_PUB_QTE_ACCESS_REC_ IS
2605: aSqlItem ASO_QUOTE_PUB_QTE_ACCESS_REC_;
2606: BEGIN
2607: -- initialize the object
2608: aSqlItem := ASO_QUOTE_PUB_QTE_ACCESS_REC_(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
2601: RETURN aPlsqlItem;
2602: END SQL_TO_PL16;
2603: FUNCTION PL_TO_SQL33(aPlsqlItem ASO_QUOTE_PUB.QTE_ACCESS_REC_TYPE)
2604: RETURN ASO_QUOTE_PUB_QTE_ACCESS_REC_ IS
2605: aSqlItem ASO_QUOTE_PUB_QTE_ACCESS_REC_;
2606: BEGIN
2607: -- initialize the object
2608: aSqlItem := ASO_QUOTE_PUB_QTE_ACCESS_REC_(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
2609: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
2604: RETURN ASO_QUOTE_PUB_QTE_ACCESS_REC_ IS
2605: aSqlItem ASO_QUOTE_PUB_QTE_ACCESS_REC_;
2606: BEGIN
2607: -- initialize the object
2608: aSqlItem := ASO_QUOTE_PUB_QTE_ACCESS_REC_(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
2609: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
2610: aSqlItem.ACCESS_ID := aPlsqlItem.ACCESS_ID;
2611: aSqlItem.QUOTE_NUMBER := aPlsqlItem.QUOTE_NUMBER;
2612: aSqlItem.RESOURCE_ID := aPlsqlItem.RESOURCE_ID;
2651: aSqlItem.ATTRIBUTE20 := aPlsqlItem.ATTRIBUTE20;
2652: aSqlItem.OPERATION_CODE := aPlsqlItem.OPERATION_CODE;
2653: RETURN aSqlItem;
2654: END PL_TO_SQL33;
2655: FUNCTION SQL_TO_PL33(aSqlItem ASO_QUOTE_PUB_QTE_ACCESS_REC_)
2656: RETURN ASO_QUOTE_PUB.QTE_ACCESS_REC_TYPE IS
2657: aPlsqlItem ASO_QUOTE_PUB.QTE_ACCESS_REC_TYPE;
2658: BEGIN
2659: aPlsqlItem.ACCESS_ID := aSqlItem.ACCESS_ID;
2652: aSqlItem.OPERATION_CODE := aPlsqlItem.OPERATION_CODE;
2653: RETURN aSqlItem;
2654: END PL_TO_SQL33;
2655: FUNCTION SQL_TO_PL33(aSqlItem ASO_QUOTE_PUB_QTE_ACCESS_REC_)
2656: RETURN ASO_QUOTE_PUB.QTE_ACCESS_REC_TYPE IS
2657: aPlsqlItem ASO_QUOTE_PUB.QTE_ACCESS_REC_TYPE;
2658: BEGIN
2659: aPlsqlItem.ACCESS_ID := aSqlItem.ACCESS_ID;
2660: aPlsqlItem.QUOTE_NUMBER := aSqlItem.QUOTE_NUMBER;
2653: RETURN aSqlItem;
2654: END PL_TO_SQL33;
2655: FUNCTION SQL_TO_PL33(aSqlItem ASO_QUOTE_PUB_QTE_ACCESS_REC_)
2656: RETURN ASO_QUOTE_PUB.QTE_ACCESS_REC_TYPE IS
2657: aPlsqlItem ASO_QUOTE_PUB.QTE_ACCESS_REC_TYPE;
2658: BEGIN
2659: aPlsqlItem.ACCESS_ID := aSqlItem.ACCESS_ID;
2660: aPlsqlItem.QUOTE_NUMBER := aSqlItem.QUOTE_NUMBER;
2661: aPlsqlItem.RESOURCE_ID := aSqlItem.RESOURCE_ID;
2700: aPlsqlItem.ATTRIBUTE20 := aSqlItem.ATTRIBUTE20;
2701: aPlsqlItem.OPERATION_CODE := aSqlItem.OPERATION_CODE;
2702: RETURN aPlsqlItem;
2703: END SQL_TO_PL33;
2704: FUNCTION PL_TO_SQL16(aPlsqlItem ASO_QUOTE_PUB.QTE_ACCESS_TBL_TYPE)
2705: RETURN ASO_QUOTE_PUB_QTE_ACCESS_TBL_ IS
2706: aSqlItem ASO_QUOTE_PUB_QTE_ACCESS_TBL_;
2707: BEGIN
2708: -- initialize the table
2701: aPlsqlItem.OPERATION_CODE := aSqlItem.OPERATION_CODE;
2702: RETURN aPlsqlItem;
2703: END SQL_TO_PL33;
2704: FUNCTION PL_TO_SQL16(aPlsqlItem ASO_QUOTE_PUB.QTE_ACCESS_TBL_TYPE)
2705: RETURN ASO_QUOTE_PUB_QTE_ACCESS_TBL_ IS
2706: aSqlItem ASO_QUOTE_PUB_QTE_ACCESS_TBL_;
2707: BEGIN
2708: -- initialize the table
2709: aSqlItem := ASO_QUOTE_PUB_QTE_ACCESS_TBL_();
2702: RETURN aPlsqlItem;
2703: END SQL_TO_PL33;
2704: FUNCTION PL_TO_SQL16(aPlsqlItem ASO_QUOTE_PUB.QTE_ACCESS_TBL_TYPE)
2705: RETURN ASO_QUOTE_PUB_QTE_ACCESS_TBL_ IS
2706: aSqlItem ASO_QUOTE_PUB_QTE_ACCESS_TBL_;
2707: BEGIN
2708: -- initialize the table
2709: aSqlItem := ASO_QUOTE_PUB_QTE_ACCESS_TBL_();
2710: IF aPlsqlItem.COUNT > 0 THEN
2705: RETURN ASO_QUOTE_PUB_QTE_ACCESS_TBL_ IS
2706: aSqlItem ASO_QUOTE_PUB_QTE_ACCESS_TBL_;
2707: BEGIN
2708: -- initialize the table
2709: aSqlItem := ASO_QUOTE_PUB_QTE_ACCESS_TBL_();
2710: IF aPlsqlItem.COUNT > 0 THEN
2711: aSqlItem.EXTEND(aPlsqlItem.COUNT);
2712: FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
2713: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL33(aPlsqlItem(I));
2714: END LOOP;
2715: END IF;
2716: RETURN aSqlItem;
2717: END PL_TO_SQL16;
2718: FUNCTION SQL_TO_PL17(aSqlItem ASO_QUOTE_PUB_QTE_ACCESS_TBL_)
2719: RETURN ASO_QUOTE_PUB.QTE_ACCESS_TBL_TYPE IS
2720: aPlsqlItem ASO_QUOTE_PUB.QTE_ACCESS_TBL_TYPE;
2721: BEGIN
2722: BEGIN
2715: END IF;
2716: RETURN aSqlItem;
2717: END PL_TO_SQL16;
2718: FUNCTION SQL_TO_PL17(aSqlItem ASO_QUOTE_PUB_QTE_ACCESS_TBL_)
2719: RETURN ASO_QUOTE_PUB.QTE_ACCESS_TBL_TYPE IS
2720: aPlsqlItem ASO_QUOTE_PUB.QTE_ACCESS_TBL_TYPE;
2721: BEGIN
2722: BEGIN
2723: FOR I IN 1..aSqlItem.COUNT LOOP
2716: RETURN aSqlItem;
2717: END PL_TO_SQL16;
2718: FUNCTION SQL_TO_PL17(aSqlItem ASO_QUOTE_PUB_QTE_ACCESS_TBL_)
2719: RETURN ASO_QUOTE_PUB.QTE_ACCESS_TBL_TYPE IS
2720: aPlsqlItem ASO_QUOTE_PUB.QTE_ACCESS_TBL_TYPE;
2721: BEGIN
2722: BEGIN
2723: FOR I IN 1..aSqlItem.COUNT LOOP
2724: aPlsqlItem(I) := SQL_TO_PL33(aSqlItem(I));
2728: NULL;
2729: END;
2730: RETURN aPlsqlItem;
2731: END SQL_TO_PL17;
2732: FUNCTION PL_TO_SQL34(aPlsqlItem ASO_QUOTE_PUB.TEMPLATE_REC_TYPE)
2733: RETURN ASO_QUOTE_PUB_TEMPLATE_REC_TY IS
2734: aSqlItem ASO_QUOTE_PUB_TEMPLATE_REC_TY;
2735: BEGIN
2736: -- initialize the object
2729: END;
2730: RETURN aPlsqlItem;
2731: END SQL_TO_PL17;
2732: FUNCTION PL_TO_SQL34(aPlsqlItem ASO_QUOTE_PUB.TEMPLATE_REC_TYPE)
2733: RETURN ASO_QUOTE_PUB_TEMPLATE_REC_TY IS
2734: aSqlItem ASO_QUOTE_PUB_TEMPLATE_REC_TY;
2735: BEGIN
2736: -- initialize the object
2737: aSqlItem := ASO_QUOTE_PUB_TEMPLATE_REC_TY(NULL);
2730: RETURN aPlsqlItem;
2731: END SQL_TO_PL17;
2732: FUNCTION PL_TO_SQL34(aPlsqlItem ASO_QUOTE_PUB.TEMPLATE_REC_TYPE)
2733: RETURN ASO_QUOTE_PUB_TEMPLATE_REC_TY IS
2734: aSqlItem ASO_QUOTE_PUB_TEMPLATE_REC_TY;
2735: BEGIN
2736: -- initialize the object
2737: aSqlItem := ASO_QUOTE_PUB_TEMPLATE_REC_TY(NULL);
2738: aSqlItem.TEMPLATE_ID := aPlsqlItem.TEMPLATE_ID;
2733: RETURN ASO_QUOTE_PUB_TEMPLATE_REC_TY IS
2734: aSqlItem ASO_QUOTE_PUB_TEMPLATE_REC_TY;
2735: BEGIN
2736: -- initialize the object
2737: aSqlItem := ASO_QUOTE_PUB_TEMPLATE_REC_TY(NULL);
2738: aSqlItem.TEMPLATE_ID := aPlsqlItem.TEMPLATE_ID;
2739: RETURN aSqlItem;
2740: END PL_TO_SQL34;
2741: FUNCTION SQL_TO_PL34(aSqlItem ASO_QUOTE_PUB_TEMPLATE_REC_TY)
2737: aSqlItem := ASO_QUOTE_PUB_TEMPLATE_REC_TY(NULL);
2738: aSqlItem.TEMPLATE_ID := aPlsqlItem.TEMPLATE_ID;
2739: RETURN aSqlItem;
2740: END PL_TO_SQL34;
2741: FUNCTION SQL_TO_PL34(aSqlItem ASO_QUOTE_PUB_TEMPLATE_REC_TY)
2742: RETURN ASO_QUOTE_PUB.TEMPLATE_REC_TYPE IS
2743: aPlsqlItem ASO_QUOTE_PUB.TEMPLATE_REC_TYPE;
2744: BEGIN
2745: aPlsqlItem.TEMPLATE_ID := aSqlItem.TEMPLATE_ID;
2738: aSqlItem.TEMPLATE_ID := aPlsqlItem.TEMPLATE_ID;
2739: RETURN aSqlItem;
2740: END PL_TO_SQL34;
2741: FUNCTION SQL_TO_PL34(aSqlItem ASO_QUOTE_PUB_TEMPLATE_REC_TY)
2742: RETURN ASO_QUOTE_PUB.TEMPLATE_REC_TYPE IS
2743: aPlsqlItem ASO_QUOTE_PUB.TEMPLATE_REC_TYPE;
2744: BEGIN
2745: aPlsqlItem.TEMPLATE_ID := aSqlItem.TEMPLATE_ID;
2746: RETURN aPlsqlItem;
2739: RETURN aSqlItem;
2740: END PL_TO_SQL34;
2741: FUNCTION SQL_TO_PL34(aSqlItem ASO_QUOTE_PUB_TEMPLATE_REC_TY)
2742: RETURN ASO_QUOTE_PUB.TEMPLATE_REC_TYPE IS
2743: aPlsqlItem ASO_QUOTE_PUB.TEMPLATE_REC_TYPE;
2744: BEGIN
2745: aPlsqlItem.TEMPLATE_ID := aSqlItem.TEMPLATE_ID;
2746: RETURN aPlsqlItem;
2747: END SQL_TO_PL34;
2744: BEGIN
2745: aPlsqlItem.TEMPLATE_ID := aSqlItem.TEMPLATE_ID;
2746: RETURN aPlsqlItem;
2747: END SQL_TO_PL34;
2748: FUNCTION PL_TO_SQL17(aPlsqlItem ASO_QUOTE_PUB.TEMPLATE_TBL_TYPE)
2749: RETURN ASO_QUOTE_PUB_TEMPLATE_TBL_TY IS
2750: aSqlItem ASO_QUOTE_PUB_TEMPLATE_TBL_TY;
2751: BEGIN
2752: -- initialize the table
2745: aPlsqlItem.TEMPLATE_ID := aSqlItem.TEMPLATE_ID;
2746: RETURN aPlsqlItem;
2747: END SQL_TO_PL34;
2748: FUNCTION PL_TO_SQL17(aPlsqlItem ASO_QUOTE_PUB.TEMPLATE_TBL_TYPE)
2749: RETURN ASO_QUOTE_PUB_TEMPLATE_TBL_TY IS
2750: aSqlItem ASO_QUOTE_PUB_TEMPLATE_TBL_TY;
2751: BEGIN
2752: -- initialize the table
2753: aSqlItem := ASO_QUOTE_PUB_TEMPLATE_TBL_TY();
2746: RETURN aPlsqlItem;
2747: END SQL_TO_PL34;
2748: FUNCTION PL_TO_SQL17(aPlsqlItem ASO_QUOTE_PUB.TEMPLATE_TBL_TYPE)
2749: RETURN ASO_QUOTE_PUB_TEMPLATE_TBL_TY IS
2750: aSqlItem ASO_QUOTE_PUB_TEMPLATE_TBL_TY;
2751: BEGIN
2752: -- initialize the table
2753: aSqlItem := ASO_QUOTE_PUB_TEMPLATE_TBL_TY();
2754: IF aPlsqlItem.COUNT > 0 THEN
2749: RETURN ASO_QUOTE_PUB_TEMPLATE_TBL_TY IS
2750: aSqlItem ASO_QUOTE_PUB_TEMPLATE_TBL_TY;
2751: BEGIN
2752: -- initialize the table
2753: aSqlItem := ASO_QUOTE_PUB_TEMPLATE_TBL_TY();
2754: IF aPlsqlItem.COUNT > 0 THEN
2755: aSqlItem.EXTEND(aPlsqlItem.COUNT);
2756: FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
2757: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL34(aPlsqlItem(I));
2758: END LOOP;
2759: END IF;
2760: RETURN aSqlItem;
2761: END PL_TO_SQL17;
2762: FUNCTION SQL_TO_PL18(aSqlItem ASO_QUOTE_PUB_TEMPLATE_TBL_TY)
2763: RETURN ASO_QUOTE_PUB.TEMPLATE_TBL_TYPE IS
2764: aPlsqlItem ASO_QUOTE_PUB.TEMPLATE_TBL_TYPE;
2765: BEGIN
2766: BEGIN
2759: END IF;
2760: RETURN aSqlItem;
2761: END PL_TO_SQL17;
2762: FUNCTION SQL_TO_PL18(aSqlItem ASO_QUOTE_PUB_TEMPLATE_TBL_TY)
2763: RETURN ASO_QUOTE_PUB.TEMPLATE_TBL_TYPE IS
2764: aPlsqlItem ASO_QUOTE_PUB.TEMPLATE_TBL_TYPE;
2765: BEGIN
2766: BEGIN
2767: FOR I IN 1..aSqlItem.COUNT LOOP
2760: RETURN aSqlItem;
2761: END PL_TO_SQL17;
2762: FUNCTION SQL_TO_PL18(aSqlItem ASO_QUOTE_PUB_TEMPLATE_TBL_TY)
2763: RETURN ASO_QUOTE_PUB.TEMPLATE_TBL_TYPE IS
2764: aPlsqlItem ASO_QUOTE_PUB.TEMPLATE_TBL_TYPE;
2765: BEGIN
2766: BEGIN
2767: FOR I IN 1..aSqlItem.COUNT LOOP
2768: aPlsqlItem(I) := SQL_TO_PL34(aSqlItem(I));
2772: NULL;
2773: END;
2774: RETURN aPlsqlItem;
2775: END SQL_TO_PL18;
2776: FUNCTION PL_TO_SQL35(aPlsqlItem ASO_QUOTE_PUB.RELATED_OBJ_REC_TYPE)
2777: RETURN ASO_QUOTE_PUB_RELATED_OBJ_REC IS
2778: aSqlItem ASO_QUOTE_PUB_RELATED_OBJ_REC;
2779: BEGIN
2780: -- initialize the object
2773: END;
2774: RETURN aPlsqlItem;
2775: END SQL_TO_PL18;
2776: FUNCTION PL_TO_SQL35(aPlsqlItem ASO_QUOTE_PUB.RELATED_OBJ_REC_TYPE)
2777: RETURN ASO_QUOTE_PUB_RELATED_OBJ_REC IS
2778: aSqlItem ASO_QUOTE_PUB_RELATED_OBJ_REC;
2779: BEGIN
2780: -- initialize the object
2781: aSqlItem := ASO_QUOTE_PUB_RELATED_OBJ_REC(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
2774: RETURN aPlsqlItem;
2775: END SQL_TO_PL18;
2776: FUNCTION PL_TO_SQL35(aPlsqlItem ASO_QUOTE_PUB.RELATED_OBJ_REC_TYPE)
2777: RETURN ASO_QUOTE_PUB_RELATED_OBJ_REC IS
2778: aSqlItem ASO_QUOTE_PUB_RELATED_OBJ_REC;
2779: BEGIN
2780: -- initialize the object
2781: aSqlItem := ASO_QUOTE_PUB_RELATED_OBJ_REC(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
2782: aSqlItem.RELATED_OBJECT_ID := aPlsqlItem.RELATED_OBJECT_ID;
2777: RETURN ASO_QUOTE_PUB_RELATED_OBJ_REC IS
2778: aSqlItem ASO_QUOTE_PUB_RELATED_OBJ_REC;
2779: BEGIN
2780: -- initialize the object
2781: aSqlItem := ASO_QUOTE_PUB_RELATED_OBJ_REC(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
2782: aSqlItem.RELATED_OBJECT_ID := aPlsqlItem.RELATED_OBJECT_ID;
2783: aSqlItem.CREATION_DATE := aPlsqlItem.CREATION_DATE;
2784: aSqlItem.CREATED_BY := aPlsqlItem.CREATED_BY;
2785: aSqlItem.LAST_UPDATE_DATE := aPlsqlItem.LAST_UPDATE_DATE;
2799: aSqlItem.OBJECT_VERSION_NUMBER := aPlsqlItem.OBJECT_VERSION_NUMBER;
2800: aSqlItem.OPERATION_CODE := aPlsqlItem.OPERATION_CODE;
2801: RETURN aSqlItem;
2802: END PL_TO_SQL35;
2803: FUNCTION SQL_TO_PL35(aSqlItem ASO_QUOTE_PUB_RELATED_OBJ_REC)
2804: RETURN ASO_QUOTE_PUB.RELATED_OBJ_REC_TYPE IS
2805: aPlsqlItem ASO_QUOTE_PUB.RELATED_OBJ_REC_TYPE;
2806: BEGIN
2807: aPlsqlItem.RELATED_OBJECT_ID := aSqlItem.RELATED_OBJECT_ID;
2800: aSqlItem.OPERATION_CODE := aPlsqlItem.OPERATION_CODE;
2801: RETURN aSqlItem;
2802: END PL_TO_SQL35;
2803: FUNCTION SQL_TO_PL35(aSqlItem ASO_QUOTE_PUB_RELATED_OBJ_REC)
2804: RETURN ASO_QUOTE_PUB.RELATED_OBJ_REC_TYPE IS
2805: aPlsqlItem ASO_QUOTE_PUB.RELATED_OBJ_REC_TYPE;
2806: BEGIN
2807: aPlsqlItem.RELATED_OBJECT_ID := aSqlItem.RELATED_OBJECT_ID;
2808: aPlsqlItem.CREATION_DATE := aSqlItem.CREATION_DATE;
2801: RETURN aSqlItem;
2802: END PL_TO_SQL35;
2803: FUNCTION SQL_TO_PL35(aSqlItem ASO_QUOTE_PUB_RELATED_OBJ_REC)
2804: RETURN ASO_QUOTE_PUB.RELATED_OBJ_REC_TYPE IS
2805: aPlsqlItem ASO_QUOTE_PUB.RELATED_OBJ_REC_TYPE;
2806: BEGIN
2807: aPlsqlItem.RELATED_OBJECT_ID := aSqlItem.RELATED_OBJECT_ID;
2808: aPlsqlItem.CREATION_DATE := aSqlItem.CREATION_DATE;
2809: aPlsqlItem.CREATED_BY := aSqlItem.CREATED_BY;
2824: aPlsqlItem.OBJECT_VERSION_NUMBER := aSqlItem.OBJECT_VERSION_NUMBER;
2825: aPlsqlItem.OPERATION_CODE := aSqlItem.OPERATION_CODE;
2826: RETURN aPlsqlItem;
2827: END SQL_TO_PL35;
2828: FUNCTION PL_TO_SQL18(aPlsqlItem ASO_QUOTE_PUB.RELATED_OBJ_TBL_TYPE)
2829: RETURN ASO_QUOTE_PUB_RELATED_OBJ_TBL IS
2830: aSqlItem ASO_QUOTE_PUB_RELATED_OBJ_TBL;
2831: BEGIN
2832: -- initialize the table
2825: aPlsqlItem.OPERATION_CODE := aSqlItem.OPERATION_CODE;
2826: RETURN aPlsqlItem;
2827: END SQL_TO_PL35;
2828: FUNCTION PL_TO_SQL18(aPlsqlItem ASO_QUOTE_PUB.RELATED_OBJ_TBL_TYPE)
2829: RETURN ASO_QUOTE_PUB_RELATED_OBJ_TBL IS
2830: aSqlItem ASO_QUOTE_PUB_RELATED_OBJ_TBL;
2831: BEGIN
2832: -- initialize the table
2833: aSqlItem := ASO_QUOTE_PUB_RELATED_OBJ_TBL();
2826: RETURN aPlsqlItem;
2827: END SQL_TO_PL35;
2828: FUNCTION PL_TO_SQL18(aPlsqlItem ASO_QUOTE_PUB.RELATED_OBJ_TBL_TYPE)
2829: RETURN ASO_QUOTE_PUB_RELATED_OBJ_TBL IS
2830: aSqlItem ASO_QUOTE_PUB_RELATED_OBJ_TBL;
2831: BEGIN
2832: -- initialize the table
2833: aSqlItem := ASO_QUOTE_PUB_RELATED_OBJ_TBL();
2834: IF aPlsqlItem.COUNT > 0 THEN
2829: RETURN ASO_QUOTE_PUB_RELATED_OBJ_TBL IS
2830: aSqlItem ASO_QUOTE_PUB_RELATED_OBJ_TBL;
2831: BEGIN
2832: -- initialize the table
2833: aSqlItem := ASO_QUOTE_PUB_RELATED_OBJ_TBL();
2834: IF aPlsqlItem.COUNT > 0 THEN
2835: aSqlItem.EXTEND(aPlsqlItem.COUNT);
2836: FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
2837: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL35(aPlsqlItem(I));
2838: END LOOP;
2839: END IF;
2840: RETURN aSqlItem;
2841: END PL_TO_SQL18;
2842: FUNCTION SQL_TO_PL19(aSqlItem ASO_QUOTE_PUB_RELATED_OBJ_TBL)
2843: RETURN ASO_QUOTE_PUB.RELATED_OBJ_TBL_TYPE IS
2844: aPlsqlItem ASO_QUOTE_PUB.RELATED_OBJ_TBL_TYPE;
2845: BEGIN
2846: BEGIN
2839: END IF;
2840: RETURN aSqlItem;
2841: END PL_TO_SQL18;
2842: FUNCTION SQL_TO_PL19(aSqlItem ASO_QUOTE_PUB_RELATED_OBJ_TBL)
2843: RETURN ASO_QUOTE_PUB.RELATED_OBJ_TBL_TYPE IS
2844: aPlsqlItem ASO_QUOTE_PUB.RELATED_OBJ_TBL_TYPE;
2845: BEGIN
2846: BEGIN
2847: FOR I IN 1..aSqlItem.COUNT LOOP
2840: RETURN aSqlItem;
2841: END PL_TO_SQL18;
2842: FUNCTION SQL_TO_PL19(aSqlItem ASO_QUOTE_PUB_RELATED_OBJ_TBL)
2843: RETURN ASO_QUOTE_PUB.RELATED_OBJ_TBL_TYPE IS
2844: aPlsqlItem ASO_QUOTE_PUB.RELATED_OBJ_TBL_TYPE;
2845: BEGIN
2846: BEGIN
2847: FOR I IN 1..aSqlItem.COUNT LOOP
2848: aPlsqlItem(I) := SQL_TO_PL35(aSqlItem(I));
2858: P_API_VERSION_NUMBER IN NUMBER,
2859: P_INIT_MSG_LIST IN VARCHAR2,
2860: P_COMMIT IN VARCHAR2,
2861: P_VALIDATION_LEVEL IN NUMBER,
2862: P_CONTROL_REC IN ASO_QUOTE_PUB_CONTROL_REC_TYP,
2863: P_QTE_HEADER_REC IN ASO_QUOTE_PUB_QTE_HEADER_REC_,
2864: P_HD_PRICE_ATTRIBUTES_TBL IN ASO_QUOTE_PUB_PRICE_ATTRIBUTE,
2865: P_HD_PAYMENT_TBL IN ASO_QUOTE_PUB_PAYMENT_TBL_TYP,
2866: P_HD_SHIPMENT_REC IN ASO_QUOTE_PUB_SHIPMENT_REC_TY,
2859: P_INIT_MSG_LIST IN VARCHAR2,
2860: P_COMMIT IN VARCHAR2,
2861: P_VALIDATION_LEVEL IN NUMBER,
2862: P_CONTROL_REC IN ASO_QUOTE_PUB_CONTROL_REC_TYP,
2863: P_QTE_HEADER_REC IN ASO_QUOTE_PUB_QTE_HEADER_REC_,
2864: P_HD_PRICE_ATTRIBUTES_TBL IN ASO_QUOTE_PUB_PRICE_ATTRIBUTE,
2865: P_HD_PAYMENT_TBL IN ASO_QUOTE_PUB_PAYMENT_TBL_TYP,
2866: P_HD_SHIPMENT_REC IN ASO_QUOTE_PUB_SHIPMENT_REC_TY,
2867: P_HD_FREIGHT_CHARGE_TBL IN ASO_QUOTE_PUB_FREIGHT_CHARGE_,
2860: P_COMMIT IN VARCHAR2,
2861: P_VALIDATION_LEVEL IN NUMBER,
2862: P_CONTROL_REC IN ASO_QUOTE_PUB_CONTROL_REC_TYP,
2863: P_QTE_HEADER_REC IN ASO_QUOTE_PUB_QTE_HEADER_REC_,
2864: P_HD_PRICE_ATTRIBUTES_TBL IN ASO_QUOTE_PUB_PRICE_ATTRIBUTE,
2865: P_HD_PAYMENT_TBL IN ASO_QUOTE_PUB_PAYMENT_TBL_TYP,
2866: P_HD_SHIPMENT_REC IN ASO_QUOTE_PUB_SHIPMENT_REC_TY,
2867: P_HD_FREIGHT_CHARGE_TBL IN ASO_QUOTE_PUB_FREIGHT_CHARGE_,
2868: P_HD_TAX_DETAIL_TBL IN ASO_QUOTE_PUB_TAX_DETAIL_TBL_,
2861: P_VALIDATION_LEVEL IN NUMBER,
2862: P_CONTROL_REC IN ASO_QUOTE_PUB_CONTROL_REC_TYP,
2863: P_QTE_HEADER_REC IN ASO_QUOTE_PUB_QTE_HEADER_REC_,
2864: P_HD_PRICE_ATTRIBUTES_TBL IN ASO_QUOTE_PUB_PRICE_ATTRIBUTE,
2865: P_HD_PAYMENT_TBL IN ASO_QUOTE_PUB_PAYMENT_TBL_TYP,
2866: P_HD_SHIPMENT_REC IN ASO_QUOTE_PUB_SHIPMENT_REC_TY,
2867: P_HD_FREIGHT_CHARGE_TBL IN ASO_QUOTE_PUB_FREIGHT_CHARGE_,
2868: P_HD_TAX_DETAIL_TBL IN ASO_QUOTE_PUB_TAX_DETAIL_TBL_,
2869: P_HD_ATTR_EXT_TBL IN ASO_QUOTE_PUB_LINE_ATTRIBS_EX,
2862: P_CONTROL_REC IN ASO_QUOTE_PUB_CONTROL_REC_TYP,
2863: P_QTE_HEADER_REC IN ASO_QUOTE_PUB_QTE_HEADER_REC_,
2864: P_HD_PRICE_ATTRIBUTES_TBL IN ASO_QUOTE_PUB_PRICE_ATTRIBUTE,
2865: P_HD_PAYMENT_TBL IN ASO_QUOTE_PUB_PAYMENT_TBL_TYP,
2866: P_HD_SHIPMENT_REC IN ASO_QUOTE_PUB_SHIPMENT_REC_TY,
2867: P_HD_FREIGHT_CHARGE_TBL IN ASO_QUOTE_PUB_FREIGHT_CHARGE_,
2868: P_HD_TAX_DETAIL_TBL IN ASO_QUOTE_PUB_TAX_DETAIL_TBL_,
2869: P_HD_ATTR_EXT_TBL IN ASO_QUOTE_PUB_LINE_ATTRIBS_EX,
2870: P_HD_SALES_CREDIT_TBL IN ASO_QUOTE_PUB_SALES_CREDIT_TB,
2863: P_QTE_HEADER_REC IN ASO_QUOTE_PUB_QTE_HEADER_REC_,
2864: P_HD_PRICE_ATTRIBUTES_TBL IN ASO_QUOTE_PUB_PRICE_ATTRIBUTE,
2865: P_HD_PAYMENT_TBL IN ASO_QUOTE_PUB_PAYMENT_TBL_TYP,
2866: P_HD_SHIPMENT_REC IN ASO_QUOTE_PUB_SHIPMENT_REC_TY,
2867: P_HD_FREIGHT_CHARGE_TBL IN ASO_QUOTE_PUB_FREIGHT_CHARGE_,
2868: P_HD_TAX_DETAIL_TBL IN ASO_QUOTE_PUB_TAX_DETAIL_TBL_,
2869: P_HD_ATTR_EXT_TBL IN ASO_QUOTE_PUB_LINE_ATTRIBS_EX,
2870: P_HD_SALES_CREDIT_TBL IN ASO_QUOTE_PUB_SALES_CREDIT_TB,
2871: P_HD_QUOTE_PARTY_TBL IN ASO_QUOTE_PUB_QUOTE_PARTY_TBL,
2864: P_HD_PRICE_ATTRIBUTES_TBL IN ASO_QUOTE_PUB_PRICE_ATTRIBUTE,
2865: P_HD_PAYMENT_TBL IN ASO_QUOTE_PUB_PAYMENT_TBL_TYP,
2866: P_HD_SHIPMENT_REC IN ASO_QUOTE_PUB_SHIPMENT_REC_TY,
2867: P_HD_FREIGHT_CHARGE_TBL IN ASO_QUOTE_PUB_FREIGHT_CHARGE_,
2868: P_HD_TAX_DETAIL_TBL IN ASO_QUOTE_PUB_TAX_DETAIL_TBL_,
2869: P_HD_ATTR_EXT_TBL IN ASO_QUOTE_PUB_LINE_ATTRIBS_EX,
2870: P_HD_SALES_CREDIT_TBL IN ASO_QUOTE_PUB_SALES_CREDIT_TB,
2871: P_HD_QUOTE_PARTY_TBL IN ASO_QUOTE_PUB_QUOTE_PARTY_TBL,
2872: P_QTE_LINE_TBL IN ASO_QUOTE_PUB_QTE_LINE_TBL_TY,
2865: P_HD_PAYMENT_TBL IN ASO_QUOTE_PUB_PAYMENT_TBL_TYP,
2866: P_HD_SHIPMENT_REC IN ASO_QUOTE_PUB_SHIPMENT_REC_TY,
2867: P_HD_FREIGHT_CHARGE_TBL IN ASO_QUOTE_PUB_FREIGHT_CHARGE_,
2868: P_HD_TAX_DETAIL_TBL IN ASO_QUOTE_PUB_TAX_DETAIL_TBL_,
2869: P_HD_ATTR_EXT_TBL IN ASO_QUOTE_PUB_LINE_ATTRIBS_EX,
2870: P_HD_SALES_CREDIT_TBL IN ASO_QUOTE_PUB_SALES_CREDIT_TB,
2871: P_HD_QUOTE_PARTY_TBL IN ASO_QUOTE_PUB_QUOTE_PARTY_TBL,
2872: P_QTE_LINE_TBL IN ASO_QUOTE_PUB_QTE_LINE_TBL_TY,
2873: P_QTE_LINE_DTL_TBL IN ASO_QUOTE_PUB_QTE_LINE_DTL_TB,
2866: P_HD_SHIPMENT_REC IN ASO_QUOTE_PUB_SHIPMENT_REC_TY,
2867: P_HD_FREIGHT_CHARGE_TBL IN ASO_QUOTE_PUB_FREIGHT_CHARGE_,
2868: P_HD_TAX_DETAIL_TBL IN ASO_QUOTE_PUB_TAX_DETAIL_TBL_,
2869: P_HD_ATTR_EXT_TBL IN ASO_QUOTE_PUB_LINE_ATTRIBS_EX,
2870: P_HD_SALES_CREDIT_TBL IN ASO_QUOTE_PUB_SALES_CREDIT_TB,
2871: P_HD_QUOTE_PARTY_TBL IN ASO_QUOTE_PUB_QUOTE_PARTY_TBL,
2872: P_QTE_LINE_TBL IN ASO_QUOTE_PUB_QTE_LINE_TBL_TY,
2873: P_QTE_LINE_DTL_TBL IN ASO_QUOTE_PUB_QTE_LINE_DTL_TB,
2874: P_LINE_ATTR_EXT_TBL IN ASO_QUOTE_PUB_LINE_ATTRIBS_EX,
2867: P_HD_FREIGHT_CHARGE_TBL IN ASO_QUOTE_PUB_FREIGHT_CHARGE_,
2868: P_HD_TAX_DETAIL_TBL IN ASO_QUOTE_PUB_TAX_DETAIL_TBL_,
2869: P_HD_ATTR_EXT_TBL IN ASO_QUOTE_PUB_LINE_ATTRIBS_EX,
2870: P_HD_SALES_CREDIT_TBL IN ASO_QUOTE_PUB_SALES_CREDIT_TB,
2871: P_HD_QUOTE_PARTY_TBL IN ASO_QUOTE_PUB_QUOTE_PARTY_TBL,
2872: P_QTE_LINE_TBL IN ASO_QUOTE_PUB_QTE_LINE_TBL_TY,
2873: P_QTE_LINE_DTL_TBL IN ASO_QUOTE_PUB_QTE_LINE_DTL_TB,
2874: P_LINE_ATTR_EXT_TBL IN ASO_QUOTE_PUB_LINE_ATTRIBS_EX,
2875: P_LINE_RLTSHIP_TBL IN ASO_QUOTE_PUB_LINE_RLTSHIP_TB,
2868: P_HD_TAX_DETAIL_TBL IN ASO_QUOTE_PUB_TAX_DETAIL_TBL_,
2869: P_HD_ATTR_EXT_TBL IN ASO_QUOTE_PUB_LINE_ATTRIBS_EX,
2870: P_HD_SALES_CREDIT_TBL IN ASO_QUOTE_PUB_SALES_CREDIT_TB,
2871: P_HD_QUOTE_PARTY_TBL IN ASO_QUOTE_PUB_QUOTE_PARTY_TBL,
2872: P_QTE_LINE_TBL IN ASO_QUOTE_PUB_QTE_LINE_TBL_TY,
2873: P_QTE_LINE_DTL_TBL IN ASO_QUOTE_PUB_QTE_LINE_DTL_TB,
2874: P_LINE_ATTR_EXT_TBL IN ASO_QUOTE_PUB_LINE_ATTRIBS_EX,
2875: P_LINE_RLTSHIP_TBL IN ASO_QUOTE_PUB_LINE_RLTSHIP_TB,
2876: P_PRICE_ADJUSTMENT_TBL IN ASO_QUOTE_PUB_PRICE_ADJ_TBL_T,
2869: P_HD_ATTR_EXT_TBL IN ASO_QUOTE_PUB_LINE_ATTRIBS_EX,
2870: P_HD_SALES_CREDIT_TBL IN ASO_QUOTE_PUB_SALES_CREDIT_TB,
2871: P_HD_QUOTE_PARTY_TBL IN ASO_QUOTE_PUB_QUOTE_PARTY_TBL,
2872: P_QTE_LINE_TBL IN ASO_QUOTE_PUB_QTE_LINE_TBL_TY,
2873: P_QTE_LINE_DTL_TBL IN ASO_QUOTE_PUB_QTE_LINE_DTL_TB,
2874: P_LINE_ATTR_EXT_TBL IN ASO_QUOTE_PUB_LINE_ATTRIBS_EX,
2875: P_LINE_RLTSHIP_TBL IN ASO_QUOTE_PUB_LINE_RLTSHIP_TB,
2876: P_PRICE_ADJUSTMENT_TBL IN ASO_QUOTE_PUB_PRICE_ADJ_TBL_T,
2877: P_PRICE_ADJ_ATTR_TBL IN ASO_QUOTE_PUB_PRICE_ADJ_ATTR_,
2870: P_HD_SALES_CREDIT_TBL IN ASO_QUOTE_PUB_SALES_CREDIT_TB,
2871: P_HD_QUOTE_PARTY_TBL IN ASO_QUOTE_PUB_QUOTE_PARTY_TBL,
2872: P_QTE_LINE_TBL IN ASO_QUOTE_PUB_QTE_LINE_TBL_TY,
2873: P_QTE_LINE_DTL_TBL IN ASO_QUOTE_PUB_QTE_LINE_DTL_TB,
2874: P_LINE_ATTR_EXT_TBL IN ASO_QUOTE_PUB_LINE_ATTRIBS_EX,
2875: P_LINE_RLTSHIP_TBL IN ASO_QUOTE_PUB_LINE_RLTSHIP_TB,
2876: P_PRICE_ADJUSTMENT_TBL IN ASO_QUOTE_PUB_PRICE_ADJ_TBL_T,
2877: P_PRICE_ADJ_ATTR_TBL IN ASO_QUOTE_PUB_PRICE_ADJ_ATTR_,
2878: P_PRICE_ADJ_RLTSHIP_TBL IN ASO_QUOTE_PUB_PRICE_ADJ_RLTSH,
2871: P_HD_QUOTE_PARTY_TBL IN ASO_QUOTE_PUB_QUOTE_PARTY_TBL,
2872: P_QTE_LINE_TBL IN ASO_QUOTE_PUB_QTE_LINE_TBL_TY,
2873: P_QTE_LINE_DTL_TBL IN ASO_QUOTE_PUB_QTE_LINE_DTL_TB,
2874: P_LINE_ATTR_EXT_TBL IN ASO_QUOTE_PUB_LINE_ATTRIBS_EX,
2875: P_LINE_RLTSHIP_TBL IN ASO_QUOTE_PUB_LINE_RLTSHIP_TB,
2876: P_PRICE_ADJUSTMENT_TBL IN ASO_QUOTE_PUB_PRICE_ADJ_TBL_T,
2877: P_PRICE_ADJ_ATTR_TBL IN ASO_QUOTE_PUB_PRICE_ADJ_ATTR_,
2878: P_PRICE_ADJ_RLTSHIP_TBL IN ASO_QUOTE_PUB_PRICE_ADJ_RLTSH,
2879: P_LN_PRICE_ATTRIBUTES_TBL IN ASO_QUOTE_PUB_PRICE_ATTRIBUTE,
2872: P_QTE_LINE_TBL IN ASO_QUOTE_PUB_QTE_LINE_TBL_TY,
2873: P_QTE_LINE_DTL_TBL IN ASO_QUOTE_PUB_QTE_LINE_DTL_TB,
2874: P_LINE_ATTR_EXT_TBL IN ASO_QUOTE_PUB_LINE_ATTRIBS_EX,
2875: P_LINE_RLTSHIP_TBL IN ASO_QUOTE_PUB_LINE_RLTSHIP_TB,
2876: P_PRICE_ADJUSTMENT_TBL IN ASO_QUOTE_PUB_PRICE_ADJ_TBL_T,
2877: P_PRICE_ADJ_ATTR_TBL IN ASO_QUOTE_PUB_PRICE_ADJ_ATTR_,
2878: P_PRICE_ADJ_RLTSHIP_TBL IN ASO_QUOTE_PUB_PRICE_ADJ_RLTSH,
2879: P_LN_PRICE_ATTRIBUTES_TBL IN ASO_QUOTE_PUB_PRICE_ATTRIBUTE,
2880: P_LN_PAYMENT_TBL IN ASO_QUOTE_PUB_PAYMENT_TBL_TYP,
2873: P_QTE_LINE_DTL_TBL IN ASO_QUOTE_PUB_QTE_LINE_DTL_TB,
2874: P_LINE_ATTR_EXT_TBL IN ASO_QUOTE_PUB_LINE_ATTRIBS_EX,
2875: P_LINE_RLTSHIP_TBL IN ASO_QUOTE_PUB_LINE_RLTSHIP_TB,
2876: P_PRICE_ADJUSTMENT_TBL IN ASO_QUOTE_PUB_PRICE_ADJ_TBL_T,
2877: P_PRICE_ADJ_ATTR_TBL IN ASO_QUOTE_PUB_PRICE_ADJ_ATTR_,
2878: P_PRICE_ADJ_RLTSHIP_TBL IN ASO_QUOTE_PUB_PRICE_ADJ_RLTSH,
2879: P_LN_PRICE_ATTRIBUTES_TBL IN ASO_QUOTE_PUB_PRICE_ATTRIBUTE,
2880: P_LN_PAYMENT_TBL IN ASO_QUOTE_PUB_PAYMENT_TBL_TYP,
2881: P_LN_SHIPMENT_TBL IN ASO_QUOTE_PUB_SHIPMENT_TBL_TY,
2874: P_LINE_ATTR_EXT_TBL IN ASO_QUOTE_PUB_LINE_ATTRIBS_EX,
2875: P_LINE_RLTSHIP_TBL IN ASO_QUOTE_PUB_LINE_RLTSHIP_TB,
2876: P_PRICE_ADJUSTMENT_TBL IN ASO_QUOTE_PUB_PRICE_ADJ_TBL_T,
2877: P_PRICE_ADJ_ATTR_TBL IN ASO_QUOTE_PUB_PRICE_ADJ_ATTR_,
2878: P_PRICE_ADJ_RLTSHIP_TBL IN ASO_QUOTE_PUB_PRICE_ADJ_RLTSH,
2879: P_LN_PRICE_ATTRIBUTES_TBL IN ASO_QUOTE_PUB_PRICE_ATTRIBUTE,
2880: P_LN_PAYMENT_TBL IN ASO_QUOTE_PUB_PAYMENT_TBL_TYP,
2881: P_LN_SHIPMENT_TBL IN ASO_QUOTE_PUB_SHIPMENT_TBL_TY,
2882: P_LN_FREIGHT_CHARGE_TBL IN ASO_QUOTE_PUB_FREIGHT_CHARGE_,
2875: P_LINE_RLTSHIP_TBL IN ASO_QUOTE_PUB_LINE_RLTSHIP_TB,
2876: P_PRICE_ADJUSTMENT_TBL IN ASO_QUOTE_PUB_PRICE_ADJ_TBL_T,
2877: P_PRICE_ADJ_ATTR_TBL IN ASO_QUOTE_PUB_PRICE_ADJ_ATTR_,
2878: P_PRICE_ADJ_RLTSHIP_TBL IN ASO_QUOTE_PUB_PRICE_ADJ_RLTSH,
2879: P_LN_PRICE_ATTRIBUTES_TBL IN ASO_QUOTE_PUB_PRICE_ATTRIBUTE,
2880: P_LN_PAYMENT_TBL IN ASO_QUOTE_PUB_PAYMENT_TBL_TYP,
2881: P_LN_SHIPMENT_TBL IN ASO_QUOTE_PUB_SHIPMENT_TBL_TY,
2882: P_LN_FREIGHT_CHARGE_TBL IN ASO_QUOTE_PUB_FREIGHT_CHARGE_,
2883: P_LN_TAX_DETAIL_TBL IN ASO_QUOTE_PUB_TAX_DETAIL_TBL_,
2876: P_PRICE_ADJUSTMENT_TBL IN ASO_QUOTE_PUB_PRICE_ADJ_TBL_T,
2877: P_PRICE_ADJ_ATTR_TBL IN ASO_QUOTE_PUB_PRICE_ADJ_ATTR_,
2878: P_PRICE_ADJ_RLTSHIP_TBL IN ASO_QUOTE_PUB_PRICE_ADJ_RLTSH,
2879: P_LN_PRICE_ATTRIBUTES_TBL IN ASO_QUOTE_PUB_PRICE_ATTRIBUTE,
2880: P_LN_PAYMENT_TBL IN ASO_QUOTE_PUB_PAYMENT_TBL_TYP,
2881: P_LN_SHIPMENT_TBL IN ASO_QUOTE_PUB_SHIPMENT_TBL_TY,
2882: P_LN_FREIGHT_CHARGE_TBL IN ASO_QUOTE_PUB_FREIGHT_CHARGE_,
2883: P_LN_TAX_DETAIL_TBL IN ASO_QUOTE_PUB_TAX_DETAIL_TBL_,
2884: P_LN_SALES_CREDIT_TBL IN ASO_QUOTE_PUB_SALES_CREDIT_TB,
2877: P_PRICE_ADJ_ATTR_TBL IN ASO_QUOTE_PUB_PRICE_ADJ_ATTR_,
2878: P_PRICE_ADJ_RLTSHIP_TBL IN ASO_QUOTE_PUB_PRICE_ADJ_RLTSH,
2879: P_LN_PRICE_ATTRIBUTES_TBL IN ASO_QUOTE_PUB_PRICE_ATTRIBUTE,
2880: P_LN_PAYMENT_TBL IN ASO_QUOTE_PUB_PAYMENT_TBL_TYP,
2881: P_LN_SHIPMENT_TBL IN ASO_QUOTE_PUB_SHIPMENT_TBL_TY,
2882: P_LN_FREIGHT_CHARGE_TBL IN ASO_QUOTE_PUB_FREIGHT_CHARGE_,
2883: P_LN_TAX_DETAIL_TBL IN ASO_QUOTE_PUB_TAX_DETAIL_TBL_,
2884: P_LN_SALES_CREDIT_TBL IN ASO_QUOTE_PUB_SALES_CREDIT_TB,
2885: P_LN_QUOTE_PARTY_TBL IN ASO_QUOTE_PUB_QUOTE_PARTY_TBL,
2878: P_PRICE_ADJ_RLTSHIP_TBL IN ASO_QUOTE_PUB_PRICE_ADJ_RLTSH,
2879: P_LN_PRICE_ATTRIBUTES_TBL IN ASO_QUOTE_PUB_PRICE_ATTRIBUTE,
2880: P_LN_PAYMENT_TBL IN ASO_QUOTE_PUB_PAYMENT_TBL_TYP,
2881: P_LN_SHIPMENT_TBL IN ASO_QUOTE_PUB_SHIPMENT_TBL_TY,
2882: P_LN_FREIGHT_CHARGE_TBL IN ASO_QUOTE_PUB_FREIGHT_CHARGE_,
2883: P_LN_TAX_DETAIL_TBL IN ASO_QUOTE_PUB_TAX_DETAIL_TBL_,
2884: P_LN_SALES_CREDIT_TBL IN ASO_QUOTE_PUB_SALES_CREDIT_TB,
2885: P_LN_QUOTE_PARTY_TBL IN ASO_QUOTE_PUB_QUOTE_PARTY_TBL,
2886: P_QTE_ACCESS_TBL IN ASO_QUOTE_PUB_QTE_ACCESS_TBL_,
2879: P_LN_PRICE_ATTRIBUTES_TBL IN ASO_QUOTE_PUB_PRICE_ATTRIBUTE,
2880: P_LN_PAYMENT_TBL IN ASO_QUOTE_PUB_PAYMENT_TBL_TYP,
2881: P_LN_SHIPMENT_TBL IN ASO_QUOTE_PUB_SHIPMENT_TBL_TY,
2882: P_LN_FREIGHT_CHARGE_TBL IN ASO_QUOTE_PUB_FREIGHT_CHARGE_,
2883: P_LN_TAX_DETAIL_TBL IN ASO_QUOTE_PUB_TAX_DETAIL_TBL_,
2884: P_LN_SALES_CREDIT_TBL IN ASO_QUOTE_PUB_SALES_CREDIT_TB,
2885: P_LN_QUOTE_PARTY_TBL IN ASO_QUOTE_PUB_QUOTE_PARTY_TBL,
2886: P_QTE_ACCESS_TBL IN ASO_QUOTE_PUB_QTE_ACCESS_TBL_,
2887: P_TEMPLATE_TBL IN ASO_QUOTE_PUB_TEMPLATE_TBL_TY,
2880: P_LN_PAYMENT_TBL IN ASO_QUOTE_PUB_PAYMENT_TBL_TYP,
2881: P_LN_SHIPMENT_TBL IN ASO_QUOTE_PUB_SHIPMENT_TBL_TY,
2882: P_LN_FREIGHT_CHARGE_TBL IN ASO_QUOTE_PUB_FREIGHT_CHARGE_,
2883: P_LN_TAX_DETAIL_TBL IN ASO_QUOTE_PUB_TAX_DETAIL_TBL_,
2884: P_LN_SALES_CREDIT_TBL IN ASO_QUOTE_PUB_SALES_CREDIT_TB,
2885: P_LN_QUOTE_PARTY_TBL IN ASO_QUOTE_PUB_QUOTE_PARTY_TBL,
2886: P_QTE_ACCESS_TBL IN ASO_QUOTE_PUB_QTE_ACCESS_TBL_,
2887: P_TEMPLATE_TBL IN ASO_QUOTE_PUB_TEMPLATE_TBL_TY,
2888: P_RELATED_OBJ_TBL IN ASO_QUOTE_PUB_RELATED_OBJ_TBL,
2881: P_LN_SHIPMENT_TBL IN ASO_QUOTE_PUB_SHIPMENT_TBL_TY,
2882: P_LN_FREIGHT_CHARGE_TBL IN ASO_QUOTE_PUB_FREIGHT_CHARGE_,
2883: P_LN_TAX_DETAIL_TBL IN ASO_QUOTE_PUB_TAX_DETAIL_TBL_,
2884: P_LN_SALES_CREDIT_TBL IN ASO_QUOTE_PUB_SALES_CREDIT_TB,
2885: P_LN_QUOTE_PARTY_TBL IN ASO_QUOTE_PUB_QUOTE_PARTY_TBL,
2886: P_QTE_ACCESS_TBL IN ASO_QUOTE_PUB_QTE_ACCESS_TBL_,
2887: P_TEMPLATE_TBL IN ASO_QUOTE_PUB_TEMPLATE_TBL_TY,
2888: P_RELATED_OBJ_TBL IN ASO_QUOTE_PUB_RELATED_OBJ_TBL,
2889: X_QTE_HEADER_REC OUT NOCOPY ASO_QUOTE_PUB_QTE_HEADER_REC_,
2882: P_LN_FREIGHT_CHARGE_TBL IN ASO_QUOTE_PUB_FREIGHT_CHARGE_,
2883: P_LN_TAX_DETAIL_TBL IN ASO_QUOTE_PUB_TAX_DETAIL_TBL_,
2884: P_LN_SALES_CREDIT_TBL IN ASO_QUOTE_PUB_SALES_CREDIT_TB,
2885: P_LN_QUOTE_PARTY_TBL IN ASO_QUOTE_PUB_QUOTE_PARTY_TBL,
2886: P_QTE_ACCESS_TBL IN ASO_QUOTE_PUB_QTE_ACCESS_TBL_,
2887: P_TEMPLATE_TBL IN ASO_QUOTE_PUB_TEMPLATE_TBL_TY,
2888: P_RELATED_OBJ_TBL IN ASO_QUOTE_PUB_RELATED_OBJ_TBL,
2889: X_QTE_HEADER_REC OUT NOCOPY ASO_QUOTE_PUB_QTE_HEADER_REC_,
2890: X_QTE_LINE_TBL OUT NOCOPY ASO_QUOTE_PUB_QTE_LINE_TBL_TY,
2883: P_LN_TAX_DETAIL_TBL IN ASO_QUOTE_PUB_TAX_DETAIL_TBL_,
2884: P_LN_SALES_CREDIT_TBL IN ASO_QUOTE_PUB_SALES_CREDIT_TB,
2885: P_LN_QUOTE_PARTY_TBL IN ASO_QUOTE_PUB_QUOTE_PARTY_TBL,
2886: P_QTE_ACCESS_TBL IN ASO_QUOTE_PUB_QTE_ACCESS_TBL_,
2887: P_TEMPLATE_TBL IN ASO_QUOTE_PUB_TEMPLATE_TBL_TY,
2888: P_RELATED_OBJ_TBL IN ASO_QUOTE_PUB_RELATED_OBJ_TBL,
2889: X_QTE_HEADER_REC OUT NOCOPY ASO_QUOTE_PUB_QTE_HEADER_REC_,
2890: X_QTE_LINE_TBL OUT NOCOPY ASO_QUOTE_PUB_QTE_LINE_TBL_TY,
2891: X_QTE_LINE_DTL_TBL OUT NOCOPY ASO_QUOTE_PUB_QTE_LINE_DTL_TB,
2884: P_LN_SALES_CREDIT_TBL IN ASO_QUOTE_PUB_SALES_CREDIT_TB,
2885: P_LN_QUOTE_PARTY_TBL IN ASO_QUOTE_PUB_QUOTE_PARTY_TBL,
2886: P_QTE_ACCESS_TBL IN ASO_QUOTE_PUB_QTE_ACCESS_TBL_,
2887: P_TEMPLATE_TBL IN ASO_QUOTE_PUB_TEMPLATE_TBL_TY,
2888: P_RELATED_OBJ_TBL IN ASO_QUOTE_PUB_RELATED_OBJ_TBL,
2889: X_QTE_HEADER_REC OUT NOCOPY ASO_QUOTE_PUB_QTE_HEADER_REC_,
2890: X_QTE_LINE_TBL OUT NOCOPY ASO_QUOTE_PUB_QTE_LINE_TBL_TY,
2891: X_QTE_LINE_DTL_TBL OUT NOCOPY ASO_QUOTE_PUB_QTE_LINE_DTL_TB,
2892: X_HD_PRICE_ATTRIBUTES_TBL OUT NOCOPY ASO_QUOTE_PUB_PRICE_ATTRIBUTE,
2885: P_LN_QUOTE_PARTY_TBL IN ASO_QUOTE_PUB_QUOTE_PARTY_TBL,
2886: P_QTE_ACCESS_TBL IN ASO_QUOTE_PUB_QTE_ACCESS_TBL_,
2887: P_TEMPLATE_TBL IN ASO_QUOTE_PUB_TEMPLATE_TBL_TY,
2888: P_RELATED_OBJ_TBL IN ASO_QUOTE_PUB_RELATED_OBJ_TBL,
2889: X_QTE_HEADER_REC OUT NOCOPY ASO_QUOTE_PUB_QTE_HEADER_REC_,
2890: X_QTE_LINE_TBL OUT NOCOPY ASO_QUOTE_PUB_QTE_LINE_TBL_TY,
2891: X_QTE_LINE_DTL_TBL OUT NOCOPY ASO_QUOTE_PUB_QTE_LINE_DTL_TB,
2892: X_HD_PRICE_ATTRIBUTES_TBL OUT NOCOPY ASO_QUOTE_PUB_PRICE_ATTRIBUTE,
2893: X_HD_PAYMENT_TBL OUT NOCOPY ASO_QUOTE_PUB_PAYMENT_TBL_TYP,
2886: P_QTE_ACCESS_TBL IN ASO_QUOTE_PUB_QTE_ACCESS_TBL_,
2887: P_TEMPLATE_TBL IN ASO_QUOTE_PUB_TEMPLATE_TBL_TY,
2888: P_RELATED_OBJ_TBL IN ASO_QUOTE_PUB_RELATED_OBJ_TBL,
2889: X_QTE_HEADER_REC OUT NOCOPY ASO_QUOTE_PUB_QTE_HEADER_REC_,
2890: X_QTE_LINE_TBL OUT NOCOPY ASO_QUOTE_PUB_QTE_LINE_TBL_TY,
2891: X_QTE_LINE_DTL_TBL OUT NOCOPY ASO_QUOTE_PUB_QTE_LINE_DTL_TB,
2892: X_HD_PRICE_ATTRIBUTES_TBL OUT NOCOPY ASO_QUOTE_PUB_PRICE_ATTRIBUTE,
2893: X_HD_PAYMENT_TBL OUT NOCOPY ASO_QUOTE_PUB_PAYMENT_TBL_TYP,
2894: X_HD_SHIPMENT_REC OUT NOCOPY ASO_QUOTE_PUB_SHIPMENT_REC_TY,
2887: P_TEMPLATE_TBL IN ASO_QUOTE_PUB_TEMPLATE_TBL_TY,
2888: P_RELATED_OBJ_TBL IN ASO_QUOTE_PUB_RELATED_OBJ_TBL,
2889: X_QTE_HEADER_REC OUT NOCOPY ASO_QUOTE_PUB_QTE_HEADER_REC_,
2890: X_QTE_LINE_TBL OUT NOCOPY ASO_QUOTE_PUB_QTE_LINE_TBL_TY,
2891: X_QTE_LINE_DTL_TBL OUT NOCOPY ASO_QUOTE_PUB_QTE_LINE_DTL_TB,
2892: X_HD_PRICE_ATTRIBUTES_TBL OUT NOCOPY ASO_QUOTE_PUB_PRICE_ATTRIBUTE,
2893: X_HD_PAYMENT_TBL OUT NOCOPY ASO_QUOTE_PUB_PAYMENT_TBL_TYP,
2894: X_HD_SHIPMENT_REC OUT NOCOPY ASO_QUOTE_PUB_SHIPMENT_REC_TY,
2895: X_HD_FREIGHT_CHARGE_TBL OUT NOCOPY ASO_QUOTE_PUB_FREIGHT_CHARGE_,
2888: P_RELATED_OBJ_TBL IN ASO_QUOTE_PUB_RELATED_OBJ_TBL,
2889: X_QTE_HEADER_REC OUT NOCOPY ASO_QUOTE_PUB_QTE_HEADER_REC_,
2890: X_QTE_LINE_TBL OUT NOCOPY ASO_QUOTE_PUB_QTE_LINE_TBL_TY,
2891: X_QTE_LINE_DTL_TBL OUT NOCOPY ASO_QUOTE_PUB_QTE_LINE_DTL_TB,
2892: X_HD_PRICE_ATTRIBUTES_TBL OUT NOCOPY ASO_QUOTE_PUB_PRICE_ATTRIBUTE,
2893: X_HD_PAYMENT_TBL OUT NOCOPY ASO_QUOTE_PUB_PAYMENT_TBL_TYP,
2894: X_HD_SHIPMENT_REC OUT NOCOPY ASO_QUOTE_PUB_SHIPMENT_REC_TY,
2895: X_HD_FREIGHT_CHARGE_TBL OUT NOCOPY ASO_QUOTE_PUB_FREIGHT_CHARGE_,
2896: X_HD_TAX_DETAIL_TBL OUT NOCOPY ASO_QUOTE_PUB_TAX_DETAIL_TBL_,
2889: X_QTE_HEADER_REC OUT NOCOPY ASO_QUOTE_PUB_QTE_HEADER_REC_,
2890: X_QTE_LINE_TBL OUT NOCOPY ASO_QUOTE_PUB_QTE_LINE_TBL_TY,
2891: X_QTE_LINE_DTL_TBL OUT NOCOPY ASO_QUOTE_PUB_QTE_LINE_DTL_TB,
2892: X_HD_PRICE_ATTRIBUTES_TBL OUT NOCOPY ASO_QUOTE_PUB_PRICE_ATTRIBUTE,
2893: X_HD_PAYMENT_TBL OUT NOCOPY ASO_QUOTE_PUB_PAYMENT_TBL_TYP,
2894: X_HD_SHIPMENT_REC OUT NOCOPY ASO_QUOTE_PUB_SHIPMENT_REC_TY,
2895: X_HD_FREIGHT_CHARGE_TBL OUT NOCOPY ASO_QUOTE_PUB_FREIGHT_CHARGE_,
2896: X_HD_TAX_DETAIL_TBL OUT NOCOPY ASO_QUOTE_PUB_TAX_DETAIL_TBL_,
2897: X_HD_ATTR_EXT_TBL OUT NOCOPY ASO_QUOTE_PUB_LINE_ATTRIBS_EX,
2890: X_QTE_LINE_TBL OUT NOCOPY ASO_QUOTE_PUB_QTE_LINE_TBL_TY,
2891: X_QTE_LINE_DTL_TBL OUT NOCOPY ASO_QUOTE_PUB_QTE_LINE_DTL_TB,
2892: X_HD_PRICE_ATTRIBUTES_TBL OUT NOCOPY ASO_QUOTE_PUB_PRICE_ATTRIBUTE,
2893: X_HD_PAYMENT_TBL OUT NOCOPY ASO_QUOTE_PUB_PAYMENT_TBL_TYP,
2894: X_HD_SHIPMENT_REC OUT NOCOPY ASO_QUOTE_PUB_SHIPMENT_REC_TY,
2895: X_HD_FREIGHT_CHARGE_TBL OUT NOCOPY ASO_QUOTE_PUB_FREIGHT_CHARGE_,
2896: X_HD_TAX_DETAIL_TBL OUT NOCOPY ASO_QUOTE_PUB_TAX_DETAIL_TBL_,
2897: X_HD_ATTR_EXT_TBL OUT NOCOPY ASO_QUOTE_PUB_LINE_ATTRIBS_EX,
2898: X_HD_SALES_CREDIT_TBL OUT NOCOPY ASO_QUOTE_PUB_SALES_CREDIT_TB,
2891: X_QTE_LINE_DTL_TBL OUT NOCOPY ASO_QUOTE_PUB_QTE_LINE_DTL_TB,
2892: X_HD_PRICE_ATTRIBUTES_TBL OUT NOCOPY ASO_QUOTE_PUB_PRICE_ATTRIBUTE,
2893: X_HD_PAYMENT_TBL OUT NOCOPY ASO_QUOTE_PUB_PAYMENT_TBL_TYP,
2894: X_HD_SHIPMENT_REC OUT NOCOPY ASO_QUOTE_PUB_SHIPMENT_REC_TY,
2895: X_HD_FREIGHT_CHARGE_TBL OUT NOCOPY ASO_QUOTE_PUB_FREIGHT_CHARGE_,
2896: X_HD_TAX_DETAIL_TBL OUT NOCOPY ASO_QUOTE_PUB_TAX_DETAIL_TBL_,
2897: X_HD_ATTR_EXT_TBL OUT NOCOPY ASO_QUOTE_PUB_LINE_ATTRIBS_EX,
2898: X_HD_SALES_CREDIT_TBL OUT NOCOPY ASO_QUOTE_PUB_SALES_CREDIT_TB,
2899: X_HD_QUOTE_PARTY_TBL OUT NOCOPY ASO_QUOTE_PUB_QUOTE_PARTY_TBL,
2892: X_HD_PRICE_ATTRIBUTES_TBL OUT NOCOPY ASO_QUOTE_PUB_PRICE_ATTRIBUTE,
2893: X_HD_PAYMENT_TBL OUT NOCOPY ASO_QUOTE_PUB_PAYMENT_TBL_TYP,
2894: X_HD_SHIPMENT_REC OUT NOCOPY ASO_QUOTE_PUB_SHIPMENT_REC_TY,
2895: X_HD_FREIGHT_CHARGE_TBL OUT NOCOPY ASO_QUOTE_PUB_FREIGHT_CHARGE_,
2896: X_HD_TAX_DETAIL_TBL OUT NOCOPY ASO_QUOTE_PUB_TAX_DETAIL_TBL_,
2897: X_HD_ATTR_EXT_TBL OUT NOCOPY ASO_QUOTE_PUB_LINE_ATTRIBS_EX,
2898: X_HD_SALES_CREDIT_TBL OUT NOCOPY ASO_QUOTE_PUB_SALES_CREDIT_TB,
2899: X_HD_QUOTE_PARTY_TBL OUT NOCOPY ASO_QUOTE_PUB_QUOTE_PARTY_TBL,
2900: X_LINE_ATTR_EXT_TBL OUT NOCOPY ASO_QUOTE_PUB_LINE_ATTRIBS_EX,
2893: X_HD_PAYMENT_TBL OUT NOCOPY ASO_QUOTE_PUB_PAYMENT_TBL_TYP,
2894: X_HD_SHIPMENT_REC OUT NOCOPY ASO_QUOTE_PUB_SHIPMENT_REC_TY,
2895: X_HD_FREIGHT_CHARGE_TBL OUT NOCOPY ASO_QUOTE_PUB_FREIGHT_CHARGE_,
2896: X_HD_TAX_DETAIL_TBL OUT NOCOPY ASO_QUOTE_PUB_TAX_DETAIL_TBL_,
2897: X_HD_ATTR_EXT_TBL OUT NOCOPY ASO_QUOTE_PUB_LINE_ATTRIBS_EX,
2898: X_HD_SALES_CREDIT_TBL OUT NOCOPY ASO_QUOTE_PUB_SALES_CREDIT_TB,
2899: X_HD_QUOTE_PARTY_TBL OUT NOCOPY ASO_QUOTE_PUB_QUOTE_PARTY_TBL,
2900: X_LINE_ATTR_EXT_TBL OUT NOCOPY ASO_QUOTE_PUB_LINE_ATTRIBS_EX,
2901: X_LINE_RLTSHIP_TBL OUT NOCOPY ASO_QUOTE_PUB_LINE_RLTSHIP_TB,
2894: X_HD_SHIPMENT_REC OUT NOCOPY ASO_QUOTE_PUB_SHIPMENT_REC_TY,
2895: X_HD_FREIGHT_CHARGE_TBL OUT NOCOPY ASO_QUOTE_PUB_FREIGHT_CHARGE_,
2896: X_HD_TAX_DETAIL_TBL OUT NOCOPY ASO_QUOTE_PUB_TAX_DETAIL_TBL_,
2897: X_HD_ATTR_EXT_TBL OUT NOCOPY ASO_QUOTE_PUB_LINE_ATTRIBS_EX,
2898: X_HD_SALES_CREDIT_TBL OUT NOCOPY ASO_QUOTE_PUB_SALES_CREDIT_TB,
2899: X_HD_QUOTE_PARTY_TBL OUT NOCOPY ASO_QUOTE_PUB_QUOTE_PARTY_TBL,
2900: X_LINE_ATTR_EXT_TBL OUT NOCOPY ASO_QUOTE_PUB_LINE_ATTRIBS_EX,
2901: X_LINE_RLTSHIP_TBL OUT NOCOPY ASO_QUOTE_PUB_LINE_RLTSHIP_TB,
2902: X_PRICE_ADJUSTMENT_TBL OUT NOCOPY ASO_QUOTE_PUB_PRICE_ADJ_TBL_T,
2895: X_HD_FREIGHT_CHARGE_TBL OUT NOCOPY ASO_QUOTE_PUB_FREIGHT_CHARGE_,
2896: X_HD_TAX_DETAIL_TBL OUT NOCOPY ASO_QUOTE_PUB_TAX_DETAIL_TBL_,
2897: X_HD_ATTR_EXT_TBL OUT NOCOPY ASO_QUOTE_PUB_LINE_ATTRIBS_EX,
2898: X_HD_SALES_CREDIT_TBL OUT NOCOPY ASO_QUOTE_PUB_SALES_CREDIT_TB,
2899: X_HD_QUOTE_PARTY_TBL OUT NOCOPY ASO_QUOTE_PUB_QUOTE_PARTY_TBL,
2900: X_LINE_ATTR_EXT_TBL OUT NOCOPY ASO_QUOTE_PUB_LINE_ATTRIBS_EX,
2901: X_LINE_RLTSHIP_TBL OUT NOCOPY ASO_QUOTE_PUB_LINE_RLTSHIP_TB,
2902: X_PRICE_ADJUSTMENT_TBL OUT NOCOPY ASO_QUOTE_PUB_PRICE_ADJ_TBL_T,
2903: X_PRICE_ADJ_ATTR_TBL OUT NOCOPY ASO_QUOTE_PUB_PRICE_ADJ_ATTR_,
2896: X_HD_TAX_DETAIL_TBL OUT NOCOPY ASO_QUOTE_PUB_TAX_DETAIL_TBL_,
2897: X_HD_ATTR_EXT_TBL OUT NOCOPY ASO_QUOTE_PUB_LINE_ATTRIBS_EX,
2898: X_HD_SALES_CREDIT_TBL OUT NOCOPY ASO_QUOTE_PUB_SALES_CREDIT_TB,
2899: X_HD_QUOTE_PARTY_TBL OUT NOCOPY ASO_QUOTE_PUB_QUOTE_PARTY_TBL,
2900: X_LINE_ATTR_EXT_TBL OUT NOCOPY ASO_QUOTE_PUB_LINE_ATTRIBS_EX,
2901: X_LINE_RLTSHIP_TBL OUT NOCOPY ASO_QUOTE_PUB_LINE_RLTSHIP_TB,
2902: X_PRICE_ADJUSTMENT_TBL OUT NOCOPY ASO_QUOTE_PUB_PRICE_ADJ_TBL_T,
2903: X_PRICE_ADJ_ATTR_TBL OUT NOCOPY ASO_QUOTE_PUB_PRICE_ADJ_ATTR_,
2904: X_PRICE_ADJ_RLTSHIP_TBL OUT NOCOPY ASO_QUOTE_PUB_PRICE_ADJ_RLTSH,
2897: X_HD_ATTR_EXT_TBL OUT NOCOPY ASO_QUOTE_PUB_LINE_ATTRIBS_EX,
2898: X_HD_SALES_CREDIT_TBL OUT NOCOPY ASO_QUOTE_PUB_SALES_CREDIT_TB,
2899: X_HD_QUOTE_PARTY_TBL OUT NOCOPY ASO_QUOTE_PUB_QUOTE_PARTY_TBL,
2900: X_LINE_ATTR_EXT_TBL OUT NOCOPY ASO_QUOTE_PUB_LINE_ATTRIBS_EX,
2901: X_LINE_RLTSHIP_TBL OUT NOCOPY ASO_QUOTE_PUB_LINE_RLTSHIP_TB,
2902: X_PRICE_ADJUSTMENT_TBL OUT NOCOPY ASO_QUOTE_PUB_PRICE_ADJ_TBL_T,
2903: X_PRICE_ADJ_ATTR_TBL OUT NOCOPY ASO_QUOTE_PUB_PRICE_ADJ_ATTR_,
2904: X_PRICE_ADJ_RLTSHIP_TBL OUT NOCOPY ASO_QUOTE_PUB_PRICE_ADJ_RLTSH,
2905: X_LN_PRICE_ATTRIBUTES_TBL OUT NOCOPY ASO_QUOTE_PUB_PRICE_ATTRIBUTE,
2898: X_HD_SALES_CREDIT_TBL OUT NOCOPY ASO_QUOTE_PUB_SALES_CREDIT_TB,
2899: X_HD_QUOTE_PARTY_TBL OUT NOCOPY ASO_QUOTE_PUB_QUOTE_PARTY_TBL,
2900: X_LINE_ATTR_EXT_TBL OUT NOCOPY ASO_QUOTE_PUB_LINE_ATTRIBS_EX,
2901: X_LINE_RLTSHIP_TBL OUT NOCOPY ASO_QUOTE_PUB_LINE_RLTSHIP_TB,
2902: X_PRICE_ADJUSTMENT_TBL OUT NOCOPY ASO_QUOTE_PUB_PRICE_ADJ_TBL_T,
2903: X_PRICE_ADJ_ATTR_TBL OUT NOCOPY ASO_QUOTE_PUB_PRICE_ADJ_ATTR_,
2904: X_PRICE_ADJ_RLTSHIP_TBL OUT NOCOPY ASO_QUOTE_PUB_PRICE_ADJ_RLTSH,
2905: X_LN_PRICE_ATTRIBUTES_TBL OUT NOCOPY ASO_QUOTE_PUB_PRICE_ATTRIBUTE,
2906: X_LN_PAYMENT_TBL OUT NOCOPY ASO_QUOTE_PUB_PAYMENT_TBL_TYP,
2899: X_HD_QUOTE_PARTY_TBL OUT NOCOPY ASO_QUOTE_PUB_QUOTE_PARTY_TBL,
2900: X_LINE_ATTR_EXT_TBL OUT NOCOPY ASO_QUOTE_PUB_LINE_ATTRIBS_EX,
2901: X_LINE_RLTSHIP_TBL OUT NOCOPY ASO_QUOTE_PUB_LINE_RLTSHIP_TB,
2902: X_PRICE_ADJUSTMENT_TBL OUT NOCOPY ASO_QUOTE_PUB_PRICE_ADJ_TBL_T,
2903: X_PRICE_ADJ_ATTR_TBL OUT NOCOPY ASO_QUOTE_PUB_PRICE_ADJ_ATTR_,
2904: X_PRICE_ADJ_RLTSHIP_TBL OUT NOCOPY ASO_QUOTE_PUB_PRICE_ADJ_RLTSH,
2905: X_LN_PRICE_ATTRIBUTES_TBL OUT NOCOPY ASO_QUOTE_PUB_PRICE_ATTRIBUTE,
2906: X_LN_PAYMENT_TBL OUT NOCOPY ASO_QUOTE_PUB_PAYMENT_TBL_TYP,
2907: X_LN_SHIPMENT_TBL OUT NOCOPY ASO_QUOTE_PUB_SHIPMENT_TBL_TY,
2900: X_LINE_ATTR_EXT_TBL OUT NOCOPY ASO_QUOTE_PUB_LINE_ATTRIBS_EX,
2901: X_LINE_RLTSHIP_TBL OUT NOCOPY ASO_QUOTE_PUB_LINE_RLTSHIP_TB,
2902: X_PRICE_ADJUSTMENT_TBL OUT NOCOPY ASO_QUOTE_PUB_PRICE_ADJ_TBL_T,
2903: X_PRICE_ADJ_ATTR_TBL OUT NOCOPY ASO_QUOTE_PUB_PRICE_ADJ_ATTR_,
2904: X_PRICE_ADJ_RLTSHIP_TBL OUT NOCOPY ASO_QUOTE_PUB_PRICE_ADJ_RLTSH,
2905: X_LN_PRICE_ATTRIBUTES_TBL OUT NOCOPY ASO_QUOTE_PUB_PRICE_ATTRIBUTE,
2906: X_LN_PAYMENT_TBL OUT NOCOPY ASO_QUOTE_PUB_PAYMENT_TBL_TYP,
2907: X_LN_SHIPMENT_TBL OUT NOCOPY ASO_QUOTE_PUB_SHIPMENT_TBL_TY,
2908: X_LN_FREIGHT_CHARGE_TBL OUT NOCOPY ASO_QUOTE_PUB_FREIGHT_CHARGE_,
2901: X_LINE_RLTSHIP_TBL OUT NOCOPY ASO_QUOTE_PUB_LINE_RLTSHIP_TB,
2902: X_PRICE_ADJUSTMENT_TBL OUT NOCOPY ASO_QUOTE_PUB_PRICE_ADJ_TBL_T,
2903: X_PRICE_ADJ_ATTR_TBL OUT NOCOPY ASO_QUOTE_PUB_PRICE_ADJ_ATTR_,
2904: X_PRICE_ADJ_RLTSHIP_TBL OUT NOCOPY ASO_QUOTE_PUB_PRICE_ADJ_RLTSH,
2905: X_LN_PRICE_ATTRIBUTES_TBL OUT NOCOPY ASO_QUOTE_PUB_PRICE_ATTRIBUTE,
2906: X_LN_PAYMENT_TBL OUT NOCOPY ASO_QUOTE_PUB_PAYMENT_TBL_TYP,
2907: X_LN_SHIPMENT_TBL OUT NOCOPY ASO_QUOTE_PUB_SHIPMENT_TBL_TY,
2908: X_LN_FREIGHT_CHARGE_TBL OUT NOCOPY ASO_QUOTE_PUB_FREIGHT_CHARGE_,
2909: X_LN_TAX_DETAIL_TBL OUT NOCOPY ASO_QUOTE_PUB_TAX_DETAIL_TBL_,
2902: X_PRICE_ADJUSTMENT_TBL OUT NOCOPY ASO_QUOTE_PUB_PRICE_ADJ_TBL_T,
2903: X_PRICE_ADJ_ATTR_TBL OUT NOCOPY ASO_QUOTE_PUB_PRICE_ADJ_ATTR_,
2904: X_PRICE_ADJ_RLTSHIP_TBL OUT NOCOPY ASO_QUOTE_PUB_PRICE_ADJ_RLTSH,
2905: X_LN_PRICE_ATTRIBUTES_TBL OUT NOCOPY ASO_QUOTE_PUB_PRICE_ATTRIBUTE,
2906: X_LN_PAYMENT_TBL OUT NOCOPY ASO_QUOTE_PUB_PAYMENT_TBL_TYP,
2907: X_LN_SHIPMENT_TBL OUT NOCOPY ASO_QUOTE_PUB_SHIPMENT_TBL_TY,
2908: X_LN_FREIGHT_CHARGE_TBL OUT NOCOPY ASO_QUOTE_PUB_FREIGHT_CHARGE_,
2909: X_LN_TAX_DETAIL_TBL OUT NOCOPY ASO_QUOTE_PUB_TAX_DETAIL_TBL_,
2910: X_LN_SALES_CREDIT_TBL OUT NOCOPY ASO_QUOTE_PUB_SALES_CREDIT_TB,
2903: X_PRICE_ADJ_ATTR_TBL OUT NOCOPY ASO_QUOTE_PUB_PRICE_ADJ_ATTR_,
2904: X_PRICE_ADJ_RLTSHIP_TBL OUT NOCOPY ASO_QUOTE_PUB_PRICE_ADJ_RLTSH,
2905: X_LN_PRICE_ATTRIBUTES_TBL OUT NOCOPY ASO_QUOTE_PUB_PRICE_ATTRIBUTE,
2906: X_LN_PAYMENT_TBL OUT NOCOPY ASO_QUOTE_PUB_PAYMENT_TBL_TYP,
2907: X_LN_SHIPMENT_TBL OUT NOCOPY ASO_QUOTE_PUB_SHIPMENT_TBL_TY,
2908: X_LN_FREIGHT_CHARGE_TBL OUT NOCOPY ASO_QUOTE_PUB_FREIGHT_CHARGE_,
2909: X_LN_TAX_DETAIL_TBL OUT NOCOPY ASO_QUOTE_PUB_TAX_DETAIL_TBL_,
2910: X_LN_SALES_CREDIT_TBL OUT NOCOPY ASO_QUOTE_PUB_SALES_CREDIT_TB,
2911: X_LN_QUOTE_PARTY_TBL OUT NOCOPY ASO_QUOTE_PUB_QUOTE_PARTY_TBL,
2904: X_PRICE_ADJ_RLTSHIP_TBL OUT NOCOPY ASO_QUOTE_PUB_PRICE_ADJ_RLTSH,
2905: X_LN_PRICE_ATTRIBUTES_TBL OUT NOCOPY ASO_QUOTE_PUB_PRICE_ATTRIBUTE,
2906: X_LN_PAYMENT_TBL OUT NOCOPY ASO_QUOTE_PUB_PAYMENT_TBL_TYP,
2907: X_LN_SHIPMENT_TBL OUT NOCOPY ASO_QUOTE_PUB_SHIPMENT_TBL_TY,
2908: X_LN_FREIGHT_CHARGE_TBL OUT NOCOPY ASO_QUOTE_PUB_FREIGHT_CHARGE_,
2909: X_LN_TAX_DETAIL_TBL OUT NOCOPY ASO_QUOTE_PUB_TAX_DETAIL_TBL_,
2910: X_LN_SALES_CREDIT_TBL OUT NOCOPY ASO_QUOTE_PUB_SALES_CREDIT_TB,
2911: X_LN_QUOTE_PARTY_TBL OUT NOCOPY ASO_QUOTE_PUB_QUOTE_PARTY_TBL,
2912: X_QTE_ACCESS_TBL OUT NOCOPY ASO_QUOTE_PUB_QTE_ACCESS_TBL_,
2905: X_LN_PRICE_ATTRIBUTES_TBL OUT NOCOPY ASO_QUOTE_PUB_PRICE_ATTRIBUTE,
2906: X_LN_PAYMENT_TBL OUT NOCOPY ASO_QUOTE_PUB_PAYMENT_TBL_TYP,
2907: X_LN_SHIPMENT_TBL OUT NOCOPY ASO_QUOTE_PUB_SHIPMENT_TBL_TY,
2908: X_LN_FREIGHT_CHARGE_TBL OUT NOCOPY ASO_QUOTE_PUB_FREIGHT_CHARGE_,
2909: X_LN_TAX_DETAIL_TBL OUT NOCOPY ASO_QUOTE_PUB_TAX_DETAIL_TBL_,
2910: X_LN_SALES_CREDIT_TBL OUT NOCOPY ASO_QUOTE_PUB_SALES_CREDIT_TB,
2911: X_LN_QUOTE_PARTY_TBL OUT NOCOPY ASO_QUOTE_PUB_QUOTE_PARTY_TBL,
2912: X_QTE_ACCESS_TBL OUT NOCOPY ASO_QUOTE_PUB_QTE_ACCESS_TBL_,
2913: X_TEMPLATE_TBL OUT NOCOPY ASO_QUOTE_PUB_TEMPLATE_TBL_TY,
2906: X_LN_PAYMENT_TBL OUT NOCOPY ASO_QUOTE_PUB_PAYMENT_TBL_TYP,
2907: X_LN_SHIPMENT_TBL OUT NOCOPY ASO_QUOTE_PUB_SHIPMENT_TBL_TY,
2908: X_LN_FREIGHT_CHARGE_TBL OUT NOCOPY ASO_QUOTE_PUB_FREIGHT_CHARGE_,
2909: X_LN_TAX_DETAIL_TBL OUT NOCOPY ASO_QUOTE_PUB_TAX_DETAIL_TBL_,
2910: X_LN_SALES_CREDIT_TBL OUT NOCOPY ASO_QUOTE_PUB_SALES_CREDIT_TB,
2911: X_LN_QUOTE_PARTY_TBL OUT NOCOPY ASO_QUOTE_PUB_QUOTE_PARTY_TBL,
2912: X_QTE_ACCESS_TBL OUT NOCOPY ASO_QUOTE_PUB_QTE_ACCESS_TBL_,
2913: X_TEMPLATE_TBL OUT NOCOPY ASO_QUOTE_PUB_TEMPLATE_TBL_TY,
2914: X_RELATED_OBJ_TBL OUT NOCOPY ASO_QUOTE_PUB_RELATED_OBJ_TBL,
2907: X_LN_SHIPMENT_TBL OUT NOCOPY ASO_QUOTE_PUB_SHIPMENT_TBL_TY,
2908: X_LN_FREIGHT_CHARGE_TBL OUT NOCOPY ASO_QUOTE_PUB_FREIGHT_CHARGE_,
2909: X_LN_TAX_DETAIL_TBL OUT NOCOPY ASO_QUOTE_PUB_TAX_DETAIL_TBL_,
2910: X_LN_SALES_CREDIT_TBL OUT NOCOPY ASO_QUOTE_PUB_SALES_CREDIT_TB,
2911: X_LN_QUOTE_PARTY_TBL OUT NOCOPY ASO_QUOTE_PUB_QUOTE_PARTY_TBL,
2912: X_QTE_ACCESS_TBL OUT NOCOPY ASO_QUOTE_PUB_QTE_ACCESS_TBL_,
2913: X_TEMPLATE_TBL OUT NOCOPY ASO_QUOTE_PUB_TEMPLATE_TBL_TY,
2914: X_RELATED_OBJ_TBL OUT NOCOPY ASO_QUOTE_PUB_RELATED_OBJ_TBL,
2915: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2908: X_LN_FREIGHT_CHARGE_TBL OUT NOCOPY ASO_QUOTE_PUB_FREIGHT_CHARGE_,
2909: X_LN_TAX_DETAIL_TBL OUT NOCOPY ASO_QUOTE_PUB_TAX_DETAIL_TBL_,
2910: X_LN_SALES_CREDIT_TBL OUT NOCOPY ASO_QUOTE_PUB_SALES_CREDIT_TB,
2911: X_LN_QUOTE_PARTY_TBL OUT NOCOPY ASO_QUOTE_PUB_QUOTE_PARTY_TBL,
2912: X_QTE_ACCESS_TBL OUT NOCOPY ASO_QUOTE_PUB_QTE_ACCESS_TBL_,
2913: X_TEMPLATE_TBL OUT NOCOPY ASO_QUOTE_PUB_TEMPLATE_TBL_TY,
2914: X_RELATED_OBJ_TBL OUT NOCOPY ASO_QUOTE_PUB_RELATED_OBJ_TBL,
2915: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2916: X_MSG_COUNT OUT NOCOPY NUMBER,
2909: X_LN_TAX_DETAIL_TBL OUT NOCOPY ASO_QUOTE_PUB_TAX_DETAIL_TBL_,
2910: X_LN_SALES_CREDIT_TBL OUT NOCOPY ASO_QUOTE_PUB_SALES_CREDIT_TB,
2911: X_LN_QUOTE_PARTY_TBL OUT NOCOPY ASO_QUOTE_PUB_QUOTE_PARTY_TBL,
2912: X_QTE_ACCESS_TBL OUT NOCOPY ASO_QUOTE_PUB_QTE_ACCESS_TBL_,
2913: X_TEMPLATE_TBL OUT NOCOPY ASO_QUOTE_PUB_TEMPLATE_TBL_TY,
2914: X_RELATED_OBJ_TBL OUT NOCOPY ASO_QUOTE_PUB_RELATED_OBJ_TBL,
2915: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2916: X_MSG_COUNT OUT NOCOPY NUMBER,
2917: X_MSG_DATA OUT NOCOPY VARCHAR2
2910: X_LN_SALES_CREDIT_TBL OUT NOCOPY ASO_QUOTE_PUB_SALES_CREDIT_TB,
2911: X_LN_QUOTE_PARTY_TBL OUT NOCOPY ASO_QUOTE_PUB_QUOTE_PARTY_TBL,
2912: X_QTE_ACCESS_TBL OUT NOCOPY ASO_QUOTE_PUB_QTE_ACCESS_TBL_,
2913: X_TEMPLATE_TBL OUT NOCOPY ASO_QUOTE_PUB_TEMPLATE_TBL_TY,
2914: X_RELATED_OBJ_TBL OUT NOCOPY ASO_QUOTE_PUB_RELATED_OBJ_TBL,
2915: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2916: X_MSG_COUNT OUT NOCOPY NUMBER,
2917: X_MSG_DATA OUT NOCOPY VARCHAR2
2918: )
2917: X_MSG_DATA OUT NOCOPY VARCHAR2
2918: )
2919:
2920: IS
2921: P_CONTROL_REC_ APPS.ASO_QUOTE_PUB.CONTROL_REC_TYPE;
2922:
2923: P_QTE_HEADER_REC_ APPS.ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE;
2924: P_HD_PRICE_ATTRIBUTES_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE;
2925: P_HD_PAYMENT_TBL_ APPS.ASO_QUOTE_PUB.PAYMENT_TBL_TYPE;
2919:
2920: IS
2921: P_CONTROL_REC_ APPS.ASO_QUOTE_PUB.CONTROL_REC_TYPE;
2922:
2923: P_QTE_HEADER_REC_ APPS.ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE;
2924: P_HD_PRICE_ATTRIBUTES_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE;
2925: P_HD_PAYMENT_TBL_ APPS.ASO_QUOTE_PUB.PAYMENT_TBL_TYPE;
2926: P_HD_SHIPMENT_REC_ APPS.ASO_QUOTE_PUB.SHIPMENT_REC_TYPE;
2927: P_HD_FREIGHT_CHARGE_TBL_ APPS.ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE;
2920: IS
2921: P_CONTROL_REC_ APPS.ASO_QUOTE_PUB.CONTROL_REC_TYPE;
2922:
2923: P_QTE_HEADER_REC_ APPS.ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE;
2924: P_HD_PRICE_ATTRIBUTES_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE;
2925: P_HD_PAYMENT_TBL_ APPS.ASO_QUOTE_PUB.PAYMENT_TBL_TYPE;
2926: P_HD_SHIPMENT_REC_ APPS.ASO_QUOTE_PUB.SHIPMENT_REC_TYPE;
2927: P_HD_FREIGHT_CHARGE_TBL_ APPS.ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE;
2928: P_HD_TAX_DETAIL_TBL_ APPS.ASO_QUOTE_PUB.TAX_DETAIL_TBL_TYPE;
2921: P_CONTROL_REC_ APPS.ASO_QUOTE_PUB.CONTROL_REC_TYPE;
2922:
2923: P_QTE_HEADER_REC_ APPS.ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE;
2924: P_HD_PRICE_ATTRIBUTES_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE;
2925: P_HD_PAYMENT_TBL_ APPS.ASO_QUOTE_PUB.PAYMENT_TBL_TYPE;
2926: P_HD_SHIPMENT_REC_ APPS.ASO_QUOTE_PUB.SHIPMENT_REC_TYPE;
2927: P_HD_FREIGHT_CHARGE_TBL_ APPS.ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE;
2928: P_HD_TAX_DETAIL_TBL_ APPS.ASO_QUOTE_PUB.TAX_DETAIL_TBL_TYPE;
2929: P_HD_ATTR_EXT_TBL_ APPS.ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_TBL_TYPE;
2922:
2923: P_QTE_HEADER_REC_ APPS.ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE;
2924: P_HD_PRICE_ATTRIBUTES_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE;
2925: P_HD_PAYMENT_TBL_ APPS.ASO_QUOTE_PUB.PAYMENT_TBL_TYPE;
2926: P_HD_SHIPMENT_REC_ APPS.ASO_QUOTE_PUB.SHIPMENT_REC_TYPE;
2927: P_HD_FREIGHT_CHARGE_TBL_ APPS.ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE;
2928: P_HD_TAX_DETAIL_TBL_ APPS.ASO_QUOTE_PUB.TAX_DETAIL_TBL_TYPE;
2929: P_HD_ATTR_EXT_TBL_ APPS.ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_TBL_TYPE;
2930: P_HD_SALES_CREDIT_TBL_ APPS.ASO_QUOTE_PUB.SALES_CREDIT_TBL_TYPE;
2923: P_QTE_HEADER_REC_ APPS.ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE;
2924: P_HD_PRICE_ATTRIBUTES_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE;
2925: P_HD_PAYMENT_TBL_ APPS.ASO_QUOTE_PUB.PAYMENT_TBL_TYPE;
2926: P_HD_SHIPMENT_REC_ APPS.ASO_QUOTE_PUB.SHIPMENT_REC_TYPE;
2927: P_HD_FREIGHT_CHARGE_TBL_ APPS.ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE;
2928: P_HD_TAX_DETAIL_TBL_ APPS.ASO_QUOTE_PUB.TAX_DETAIL_TBL_TYPE;
2929: P_HD_ATTR_EXT_TBL_ APPS.ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_TBL_TYPE;
2930: P_HD_SALES_CREDIT_TBL_ APPS.ASO_QUOTE_PUB.SALES_CREDIT_TBL_TYPE;
2931: P_HD_QUOTE_PARTY_TBL_ APPS.ASO_QUOTE_PUB.QUOTE_PARTY_TBL_TYPE;
2924: P_HD_PRICE_ATTRIBUTES_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE;
2925: P_HD_PAYMENT_TBL_ APPS.ASO_QUOTE_PUB.PAYMENT_TBL_TYPE;
2926: P_HD_SHIPMENT_REC_ APPS.ASO_QUOTE_PUB.SHIPMENT_REC_TYPE;
2927: P_HD_FREIGHT_CHARGE_TBL_ APPS.ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE;
2928: P_HD_TAX_DETAIL_TBL_ APPS.ASO_QUOTE_PUB.TAX_DETAIL_TBL_TYPE;
2929: P_HD_ATTR_EXT_TBL_ APPS.ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_TBL_TYPE;
2930: P_HD_SALES_CREDIT_TBL_ APPS.ASO_QUOTE_PUB.SALES_CREDIT_TBL_TYPE;
2931: P_HD_QUOTE_PARTY_TBL_ APPS.ASO_QUOTE_PUB.QUOTE_PARTY_TBL_TYPE;
2932: P_QTE_LINE_TBL_ APPS.ASO_QUOTE_PUB.QTE_LINE_TBL_TYPE;
2925: P_HD_PAYMENT_TBL_ APPS.ASO_QUOTE_PUB.PAYMENT_TBL_TYPE;
2926: P_HD_SHIPMENT_REC_ APPS.ASO_QUOTE_PUB.SHIPMENT_REC_TYPE;
2927: P_HD_FREIGHT_CHARGE_TBL_ APPS.ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE;
2928: P_HD_TAX_DETAIL_TBL_ APPS.ASO_QUOTE_PUB.TAX_DETAIL_TBL_TYPE;
2929: P_HD_ATTR_EXT_TBL_ APPS.ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_TBL_TYPE;
2930: P_HD_SALES_CREDIT_TBL_ APPS.ASO_QUOTE_PUB.SALES_CREDIT_TBL_TYPE;
2931: P_HD_QUOTE_PARTY_TBL_ APPS.ASO_QUOTE_PUB.QUOTE_PARTY_TBL_TYPE;
2932: P_QTE_LINE_TBL_ APPS.ASO_QUOTE_PUB.QTE_LINE_TBL_TYPE;
2933: P_QTE_LINE_DTL_TBL_ APPS.ASO_QUOTE_PUB.QTE_LINE_DTL_TBL_TYPE;
2926: P_HD_SHIPMENT_REC_ APPS.ASO_QUOTE_PUB.SHIPMENT_REC_TYPE;
2927: P_HD_FREIGHT_CHARGE_TBL_ APPS.ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE;
2928: P_HD_TAX_DETAIL_TBL_ APPS.ASO_QUOTE_PUB.TAX_DETAIL_TBL_TYPE;
2929: P_HD_ATTR_EXT_TBL_ APPS.ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_TBL_TYPE;
2930: P_HD_SALES_CREDIT_TBL_ APPS.ASO_QUOTE_PUB.SALES_CREDIT_TBL_TYPE;
2931: P_HD_QUOTE_PARTY_TBL_ APPS.ASO_QUOTE_PUB.QUOTE_PARTY_TBL_TYPE;
2932: P_QTE_LINE_TBL_ APPS.ASO_QUOTE_PUB.QTE_LINE_TBL_TYPE;
2933: P_QTE_LINE_DTL_TBL_ APPS.ASO_QUOTE_PUB.QTE_LINE_DTL_TBL_TYPE;
2934: P_LINE_ATTR_EXT_TBL_ APPS.ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_TBL_TYPE;
2927: P_HD_FREIGHT_CHARGE_TBL_ APPS.ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE;
2928: P_HD_TAX_DETAIL_TBL_ APPS.ASO_QUOTE_PUB.TAX_DETAIL_TBL_TYPE;
2929: P_HD_ATTR_EXT_TBL_ APPS.ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_TBL_TYPE;
2930: P_HD_SALES_CREDIT_TBL_ APPS.ASO_QUOTE_PUB.SALES_CREDIT_TBL_TYPE;
2931: P_HD_QUOTE_PARTY_TBL_ APPS.ASO_QUOTE_PUB.QUOTE_PARTY_TBL_TYPE;
2932: P_QTE_LINE_TBL_ APPS.ASO_QUOTE_PUB.QTE_LINE_TBL_TYPE;
2933: P_QTE_LINE_DTL_TBL_ APPS.ASO_QUOTE_PUB.QTE_LINE_DTL_TBL_TYPE;
2934: P_LINE_ATTR_EXT_TBL_ APPS.ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_TBL_TYPE;
2935: P_LINE_RLTSHIP_TBL_ APPS.ASO_QUOTE_PUB.LINE_RLTSHIP_TBL_TYPE;
2928: P_HD_TAX_DETAIL_TBL_ APPS.ASO_QUOTE_PUB.TAX_DETAIL_TBL_TYPE;
2929: P_HD_ATTR_EXT_TBL_ APPS.ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_TBL_TYPE;
2930: P_HD_SALES_CREDIT_TBL_ APPS.ASO_QUOTE_PUB.SALES_CREDIT_TBL_TYPE;
2931: P_HD_QUOTE_PARTY_TBL_ APPS.ASO_QUOTE_PUB.QUOTE_PARTY_TBL_TYPE;
2932: P_QTE_LINE_TBL_ APPS.ASO_QUOTE_PUB.QTE_LINE_TBL_TYPE;
2933: P_QTE_LINE_DTL_TBL_ APPS.ASO_QUOTE_PUB.QTE_LINE_DTL_TBL_TYPE;
2934: P_LINE_ATTR_EXT_TBL_ APPS.ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_TBL_TYPE;
2935: P_LINE_RLTSHIP_TBL_ APPS.ASO_QUOTE_PUB.LINE_RLTSHIP_TBL_TYPE;
2936: P_PRICE_ADJUSTMENT_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ADJ_TBL_TYPE;
2929: P_HD_ATTR_EXT_TBL_ APPS.ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_TBL_TYPE;
2930: P_HD_SALES_CREDIT_TBL_ APPS.ASO_QUOTE_PUB.SALES_CREDIT_TBL_TYPE;
2931: P_HD_QUOTE_PARTY_TBL_ APPS.ASO_QUOTE_PUB.QUOTE_PARTY_TBL_TYPE;
2932: P_QTE_LINE_TBL_ APPS.ASO_QUOTE_PUB.QTE_LINE_TBL_TYPE;
2933: P_QTE_LINE_DTL_TBL_ APPS.ASO_QUOTE_PUB.QTE_LINE_DTL_TBL_TYPE;
2934: P_LINE_ATTR_EXT_TBL_ APPS.ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_TBL_TYPE;
2935: P_LINE_RLTSHIP_TBL_ APPS.ASO_QUOTE_PUB.LINE_RLTSHIP_TBL_TYPE;
2936: P_PRICE_ADJUSTMENT_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ADJ_TBL_TYPE;
2937: P_PRICE_ADJ_ATTR_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ADJ_ATTR_TBL_TYPE;
2930: P_HD_SALES_CREDIT_TBL_ APPS.ASO_QUOTE_PUB.SALES_CREDIT_TBL_TYPE;
2931: P_HD_QUOTE_PARTY_TBL_ APPS.ASO_QUOTE_PUB.QUOTE_PARTY_TBL_TYPE;
2932: P_QTE_LINE_TBL_ APPS.ASO_QUOTE_PUB.QTE_LINE_TBL_TYPE;
2933: P_QTE_LINE_DTL_TBL_ APPS.ASO_QUOTE_PUB.QTE_LINE_DTL_TBL_TYPE;
2934: P_LINE_ATTR_EXT_TBL_ APPS.ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_TBL_TYPE;
2935: P_LINE_RLTSHIP_TBL_ APPS.ASO_QUOTE_PUB.LINE_RLTSHIP_TBL_TYPE;
2936: P_PRICE_ADJUSTMENT_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ADJ_TBL_TYPE;
2937: P_PRICE_ADJ_ATTR_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ADJ_ATTR_TBL_TYPE;
2938: P_PRICE_ADJ_RLTSHIP_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_TBL_TYPE;
2931: P_HD_QUOTE_PARTY_TBL_ APPS.ASO_QUOTE_PUB.QUOTE_PARTY_TBL_TYPE;
2932: P_QTE_LINE_TBL_ APPS.ASO_QUOTE_PUB.QTE_LINE_TBL_TYPE;
2933: P_QTE_LINE_DTL_TBL_ APPS.ASO_QUOTE_PUB.QTE_LINE_DTL_TBL_TYPE;
2934: P_LINE_ATTR_EXT_TBL_ APPS.ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_TBL_TYPE;
2935: P_LINE_RLTSHIP_TBL_ APPS.ASO_QUOTE_PUB.LINE_RLTSHIP_TBL_TYPE;
2936: P_PRICE_ADJUSTMENT_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ADJ_TBL_TYPE;
2937: P_PRICE_ADJ_ATTR_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ADJ_ATTR_TBL_TYPE;
2938: P_PRICE_ADJ_RLTSHIP_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_TBL_TYPE;
2939: P_LN_PRICE_ATTRIBUTES_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE;
2932: P_QTE_LINE_TBL_ APPS.ASO_QUOTE_PUB.QTE_LINE_TBL_TYPE;
2933: P_QTE_LINE_DTL_TBL_ APPS.ASO_QUOTE_PUB.QTE_LINE_DTL_TBL_TYPE;
2934: P_LINE_ATTR_EXT_TBL_ APPS.ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_TBL_TYPE;
2935: P_LINE_RLTSHIP_TBL_ APPS.ASO_QUOTE_PUB.LINE_RLTSHIP_TBL_TYPE;
2936: P_PRICE_ADJUSTMENT_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ADJ_TBL_TYPE;
2937: P_PRICE_ADJ_ATTR_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ADJ_ATTR_TBL_TYPE;
2938: P_PRICE_ADJ_RLTSHIP_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_TBL_TYPE;
2939: P_LN_PRICE_ATTRIBUTES_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE;
2940: P_LN_PAYMENT_TBL_ APPS.ASO_QUOTE_PUB.PAYMENT_TBL_TYPE;
2933: P_QTE_LINE_DTL_TBL_ APPS.ASO_QUOTE_PUB.QTE_LINE_DTL_TBL_TYPE;
2934: P_LINE_ATTR_EXT_TBL_ APPS.ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_TBL_TYPE;
2935: P_LINE_RLTSHIP_TBL_ APPS.ASO_QUOTE_PUB.LINE_RLTSHIP_TBL_TYPE;
2936: P_PRICE_ADJUSTMENT_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ADJ_TBL_TYPE;
2937: P_PRICE_ADJ_ATTR_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ADJ_ATTR_TBL_TYPE;
2938: P_PRICE_ADJ_RLTSHIP_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_TBL_TYPE;
2939: P_LN_PRICE_ATTRIBUTES_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE;
2940: P_LN_PAYMENT_TBL_ APPS.ASO_QUOTE_PUB.PAYMENT_TBL_TYPE;
2941: P_LN_SHIPMENT_TBL_ APPS.ASO_QUOTE_PUB.SHIPMENT_TBL_TYPE;
2934: P_LINE_ATTR_EXT_TBL_ APPS.ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_TBL_TYPE;
2935: P_LINE_RLTSHIP_TBL_ APPS.ASO_QUOTE_PUB.LINE_RLTSHIP_TBL_TYPE;
2936: P_PRICE_ADJUSTMENT_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ADJ_TBL_TYPE;
2937: P_PRICE_ADJ_ATTR_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ADJ_ATTR_TBL_TYPE;
2938: P_PRICE_ADJ_RLTSHIP_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_TBL_TYPE;
2939: P_LN_PRICE_ATTRIBUTES_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE;
2940: P_LN_PAYMENT_TBL_ APPS.ASO_QUOTE_PUB.PAYMENT_TBL_TYPE;
2941: P_LN_SHIPMENT_TBL_ APPS.ASO_QUOTE_PUB.SHIPMENT_TBL_TYPE;
2942: P_LN_FREIGHT_CHARGE_TBL_ APPS.ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE;
2935: P_LINE_RLTSHIP_TBL_ APPS.ASO_QUOTE_PUB.LINE_RLTSHIP_TBL_TYPE;
2936: P_PRICE_ADJUSTMENT_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ADJ_TBL_TYPE;
2937: P_PRICE_ADJ_ATTR_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ADJ_ATTR_TBL_TYPE;
2938: P_PRICE_ADJ_RLTSHIP_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_TBL_TYPE;
2939: P_LN_PRICE_ATTRIBUTES_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE;
2940: P_LN_PAYMENT_TBL_ APPS.ASO_QUOTE_PUB.PAYMENT_TBL_TYPE;
2941: P_LN_SHIPMENT_TBL_ APPS.ASO_QUOTE_PUB.SHIPMENT_TBL_TYPE;
2942: P_LN_FREIGHT_CHARGE_TBL_ APPS.ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE;
2943: P_LN_TAX_DETAIL_TBL_ APPS.ASO_QUOTE_PUB.TAX_DETAIL_TBL_TYPE;
2936: P_PRICE_ADJUSTMENT_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ADJ_TBL_TYPE;
2937: P_PRICE_ADJ_ATTR_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ADJ_ATTR_TBL_TYPE;
2938: P_PRICE_ADJ_RLTSHIP_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_TBL_TYPE;
2939: P_LN_PRICE_ATTRIBUTES_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE;
2940: P_LN_PAYMENT_TBL_ APPS.ASO_QUOTE_PUB.PAYMENT_TBL_TYPE;
2941: P_LN_SHIPMENT_TBL_ APPS.ASO_QUOTE_PUB.SHIPMENT_TBL_TYPE;
2942: P_LN_FREIGHT_CHARGE_TBL_ APPS.ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE;
2943: P_LN_TAX_DETAIL_TBL_ APPS.ASO_QUOTE_PUB.TAX_DETAIL_TBL_TYPE;
2944: P_LN_SALES_CREDIT_TBL_ APPS.ASO_QUOTE_PUB.SALES_CREDIT_TBL_TYPE;
2937: P_PRICE_ADJ_ATTR_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ADJ_ATTR_TBL_TYPE;
2938: P_PRICE_ADJ_RLTSHIP_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_TBL_TYPE;
2939: P_LN_PRICE_ATTRIBUTES_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE;
2940: P_LN_PAYMENT_TBL_ APPS.ASO_QUOTE_PUB.PAYMENT_TBL_TYPE;
2941: P_LN_SHIPMENT_TBL_ APPS.ASO_QUOTE_PUB.SHIPMENT_TBL_TYPE;
2942: P_LN_FREIGHT_CHARGE_TBL_ APPS.ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE;
2943: P_LN_TAX_DETAIL_TBL_ APPS.ASO_QUOTE_PUB.TAX_DETAIL_TBL_TYPE;
2944: P_LN_SALES_CREDIT_TBL_ APPS.ASO_QUOTE_PUB.SALES_CREDIT_TBL_TYPE;
2945: P_LN_QUOTE_PARTY_TBL_ APPS.ASO_QUOTE_PUB.QUOTE_PARTY_TBL_TYPE;
2938: P_PRICE_ADJ_RLTSHIP_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_TBL_TYPE;
2939: P_LN_PRICE_ATTRIBUTES_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE;
2940: P_LN_PAYMENT_TBL_ APPS.ASO_QUOTE_PUB.PAYMENT_TBL_TYPE;
2941: P_LN_SHIPMENT_TBL_ APPS.ASO_QUOTE_PUB.SHIPMENT_TBL_TYPE;
2942: P_LN_FREIGHT_CHARGE_TBL_ APPS.ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE;
2943: P_LN_TAX_DETAIL_TBL_ APPS.ASO_QUOTE_PUB.TAX_DETAIL_TBL_TYPE;
2944: P_LN_SALES_CREDIT_TBL_ APPS.ASO_QUOTE_PUB.SALES_CREDIT_TBL_TYPE;
2945: P_LN_QUOTE_PARTY_TBL_ APPS.ASO_QUOTE_PUB.QUOTE_PARTY_TBL_TYPE;
2946: P_QTE_ACCESS_TBL_ APPS.ASO_QUOTE_PUB.QTE_ACCESS_TBL_TYPE;
2939: P_LN_PRICE_ATTRIBUTES_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE;
2940: P_LN_PAYMENT_TBL_ APPS.ASO_QUOTE_PUB.PAYMENT_TBL_TYPE;
2941: P_LN_SHIPMENT_TBL_ APPS.ASO_QUOTE_PUB.SHIPMENT_TBL_TYPE;
2942: P_LN_FREIGHT_CHARGE_TBL_ APPS.ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE;
2943: P_LN_TAX_DETAIL_TBL_ APPS.ASO_QUOTE_PUB.TAX_DETAIL_TBL_TYPE;
2944: P_LN_SALES_CREDIT_TBL_ APPS.ASO_QUOTE_PUB.SALES_CREDIT_TBL_TYPE;
2945: P_LN_QUOTE_PARTY_TBL_ APPS.ASO_QUOTE_PUB.QUOTE_PARTY_TBL_TYPE;
2946: P_QTE_ACCESS_TBL_ APPS.ASO_QUOTE_PUB.QTE_ACCESS_TBL_TYPE;
2947: P_TEMPLATE_TBL_ APPS.ASO_QUOTE_PUB.TEMPLATE_TBL_TYPE;
2940: P_LN_PAYMENT_TBL_ APPS.ASO_QUOTE_PUB.PAYMENT_TBL_TYPE;
2941: P_LN_SHIPMENT_TBL_ APPS.ASO_QUOTE_PUB.SHIPMENT_TBL_TYPE;
2942: P_LN_FREIGHT_CHARGE_TBL_ APPS.ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE;
2943: P_LN_TAX_DETAIL_TBL_ APPS.ASO_QUOTE_PUB.TAX_DETAIL_TBL_TYPE;
2944: P_LN_SALES_CREDIT_TBL_ APPS.ASO_QUOTE_PUB.SALES_CREDIT_TBL_TYPE;
2945: P_LN_QUOTE_PARTY_TBL_ APPS.ASO_QUOTE_PUB.QUOTE_PARTY_TBL_TYPE;
2946: P_QTE_ACCESS_TBL_ APPS.ASO_QUOTE_PUB.QTE_ACCESS_TBL_TYPE;
2947: P_TEMPLATE_TBL_ APPS.ASO_QUOTE_PUB.TEMPLATE_TBL_TYPE;
2948: P_RELATED_OBJ_TBL_ APPS.ASO_QUOTE_PUB.RELATED_OBJ_TBL_TYPE;
2941: P_LN_SHIPMENT_TBL_ APPS.ASO_QUOTE_PUB.SHIPMENT_TBL_TYPE;
2942: P_LN_FREIGHT_CHARGE_TBL_ APPS.ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE;
2943: P_LN_TAX_DETAIL_TBL_ APPS.ASO_QUOTE_PUB.TAX_DETAIL_TBL_TYPE;
2944: P_LN_SALES_CREDIT_TBL_ APPS.ASO_QUOTE_PUB.SALES_CREDIT_TBL_TYPE;
2945: P_LN_QUOTE_PARTY_TBL_ APPS.ASO_QUOTE_PUB.QUOTE_PARTY_TBL_TYPE;
2946: P_QTE_ACCESS_TBL_ APPS.ASO_QUOTE_PUB.QTE_ACCESS_TBL_TYPE;
2947: P_TEMPLATE_TBL_ APPS.ASO_QUOTE_PUB.TEMPLATE_TBL_TYPE;
2948: P_RELATED_OBJ_TBL_ APPS.ASO_QUOTE_PUB.RELATED_OBJ_TBL_TYPE;
2949: X_QTE_HEADER_REC_ APPS.ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE;
2942: P_LN_FREIGHT_CHARGE_TBL_ APPS.ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE;
2943: P_LN_TAX_DETAIL_TBL_ APPS.ASO_QUOTE_PUB.TAX_DETAIL_TBL_TYPE;
2944: P_LN_SALES_CREDIT_TBL_ APPS.ASO_QUOTE_PUB.SALES_CREDIT_TBL_TYPE;
2945: P_LN_QUOTE_PARTY_TBL_ APPS.ASO_QUOTE_PUB.QUOTE_PARTY_TBL_TYPE;
2946: P_QTE_ACCESS_TBL_ APPS.ASO_QUOTE_PUB.QTE_ACCESS_TBL_TYPE;
2947: P_TEMPLATE_TBL_ APPS.ASO_QUOTE_PUB.TEMPLATE_TBL_TYPE;
2948: P_RELATED_OBJ_TBL_ APPS.ASO_QUOTE_PUB.RELATED_OBJ_TBL_TYPE;
2949: X_QTE_HEADER_REC_ APPS.ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE;
2950: X_QTE_LINE_TBL_ APPS.ASO_QUOTE_PUB.QTE_LINE_TBL_TYPE;
2943: P_LN_TAX_DETAIL_TBL_ APPS.ASO_QUOTE_PUB.TAX_DETAIL_TBL_TYPE;
2944: P_LN_SALES_CREDIT_TBL_ APPS.ASO_QUOTE_PUB.SALES_CREDIT_TBL_TYPE;
2945: P_LN_QUOTE_PARTY_TBL_ APPS.ASO_QUOTE_PUB.QUOTE_PARTY_TBL_TYPE;
2946: P_QTE_ACCESS_TBL_ APPS.ASO_QUOTE_PUB.QTE_ACCESS_TBL_TYPE;
2947: P_TEMPLATE_TBL_ APPS.ASO_QUOTE_PUB.TEMPLATE_TBL_TYPE;
2948: P_RELATED_OBJ_TBL_ APPS.ASO_QUOTE_PUB.RELATED_OBJ_TBL_TYPE;
2949: X_QTE_HEADER_REC_ APPS.ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE;
2950: X_QTE_LINE_TBL_ APPS.ASO_QUOTE_PUB.QTE_LINE_TBL_TYPE;
2951: X_QTE_LINE_DTL_TBL_ APPS.ASO_QUOTE_PUB.QTE_LINE_DTL_TBL_TYPE;
2944: P_LN_SALES_CREDIT_TBL_ APPS.ASO_QUOTE_PUB.SALES_CREDIT_TBL_TYPE;
2945: P_LN_QUOTE_PARTY_TBL_ APPS.ASO_QUOTE_PUB.QUOTE_PARTY_TBL_TYPE;
2946: P_QTE_ACCESS_TBL_ APPS.ASO_QUOTE_PUB.QTE_ACCESS_TBL_TYPE;
2947: P_TEMPLATE_TBL_ APPS.ASO_QUOTE_PUB.TEMPLATE_TBL_TYPE;
2948: P_RELATED_OBJ_TBL_ APPS.ASO_QUOTE_PUB.RELATED_OBJ_TBL_TYPE;
2949: X_QTE_HEADER_REC_ APPS.ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE;
2950: X_QTE_LINE_TBL_ APPS.ASO_QUOTE_PUB.QTE_LINE_TBL_TYPE;
2951: X_QTE_LINE_DTL_TBL_ APPS.ASO_QUOTE_PUB.QTE_LINE_DTL_TBL_TYPE;
2952: X_HD_PRICE_ATTRIBUTES_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE;
2945: P_LN_QUOTE_PARTY_TBL_ APPS.ASO_QUOTE_PUB.QUOTE_PARTY_TBL_TYPE;
2946: P_QTE_ACCESS_TBL_ APPS.ASO_QUOTE_PUB.QTE_ACCESS_TBL_TYPE;
2947: P_TEMPLATE_TBL_ APPS.ASO_QUOTE_PUB.TEMPLATE_TBL_TYPE;
2948: P_RELATED_OBJ_TBL_ APPS.ASO_QUOTE_PUB.RELATED_OBJ_TBL_TYPE;
2949: X_QTE_HEADER_REC_ APPS.ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE;
2950: X_QTE_LINE_TBL_ APPS.ASO_QUOTE_PUB.QTE_LINE_TBL_TYPE;
2951: X_QTE_LINE_DTL_TBL_ APPS.ASO_QUOTE_PUB.QTE_LINE_DTL_TBL_TYPE;
2952: X_HD_PRICE_ATTRIBUTES_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE;
2953: X_HD_PAYMENT_TBL_ APPS.ASO_QUOTE_PUB.PAYMENT_TBL_TYPE;
2946: P_QTE_ACCESS_TBL_ APPS.ASO_QUOTE_PUB.QTE_ACCESS_TBL_TYPE;
2947: P_TEMPLATE_TBL_ APPS.ASO_QUOTE_PUB.TEMPLATE_TBL_TYPE;
2948: P_RELATED_OBJ_TBL_ APPS.ASO_QUOTE_PUB.RELATED_OBJ_TBL_TYPE;
2949: X_QTE_HEADER_REC_ APPS.ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE;
2950: X_QTE_LINE_TBL_ APPS.ASO_QUOTE_PUB.QTE_LINE_TBL_TYPE;
2951: X_QTE_LINE_DTL_TBL_ APPS.ASO_QUOTE_PUB.QTE_LINE_DTL_TBL_TYPE;
2952: X_HD_PRICE_ATTRIBUTES_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE;
2953: X_HD_PAYMENT_TBL_ APPS.ASO_QUOTE_PUB.PAYMENT_TBL_TYPE;
2954: X_HD_SHIPMENT_REC_ APPS.ASO_QUOTE_PUB.SHIPMENT_REC_TYPE;
2947: P_TEMPLATE_TBL_ APPS.ASO_QUOTE_PUB.TEMPLATE_TBL_TYPE;
2948: P_RELATED_OBJ_TBL_ APPS.ASO_QUOTE_PUB.RELATED_OBJ_TBL_TYPE;
2949: X_QTE_HEADER_REC_ APPS.ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE;
2950: X_QTE_LINE_TBL_ APPS.ASO_QUOTE_PUB.QTE_LINE_TBL_TYPE;
2951: X_QTE_LINE_DTL_TBL_ APPS.ASO_QUOTE_PUB.QTE_LINE_DTL_TBL_TYPE;
2952: X_HD_PRICE_ATTRIBUTES_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE;
2953: X_HD_PAYMENT_TBL_ APPS.ASO_QUOTE_PUB.PAYMENT_TBL_TYPE;
2954: X_HD_SHIPMENT_REC_ APPS.ASO_QUOTE_PUB.SHIPMENT_REC_TYPE;
2955: X_HD_FREIGHT_CHARGE_TBL_ APPS.ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE;
2948: P_RELATED_OBJ_TBL_ APPS.ASO_QUOTE_PUB.RELATED_OBJ_TBL_TYPE;
2949: X_QTE_HEADER_REC_ APPS.ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE;
2950: X_QTE_LINE_TBL_ APPS.ASO_QUOTE_PUB.QTE_LINE_TBL_TYPE;
2951: X_QTE_LINE_DTL_TBL_ APPS.ASO_QUOTE_PUB.QTE_LINE_DTL_TBL_TYPE;
2952: X_HD_PRICE_ATTRIBUTES_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE;
2953: X_HD_PAYMENT_TBL_ APPS.ASO_QUOTE_PUB.PAYMENT_TBL_TYPE;
2954: X_HD_SHIPMENT_REC_ APPS.ASO_QUOTE_PUB.SHIPMENT_REC_TYPE;
2955: X_HD_FREIGHT_CHARGE_TBL_ APPS.ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE;
2956: X_HD_TAX_DETAIL_TBL_ APPS.ASO_QUOTE_PUB.TAX_DETAIL_TBL_TYPE;
2949: X_QTE_HEADER_REC_ APPS.ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE;
2950: X_QTE_LINE_TBL_ APPS.ASO_QUOTE_PUB.QTE_LINE_TBL_TYPE;
2951: X_QTE_LINE_DTL_TBL_ APPS.ASO_QUOTE_PUB.QTE_LINE_DTL_TBL_TYPE;
2952: X_HD_PRICE_ATTRIBUTES_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE;
2953: X_HD_PAYMENT_TBL_ APPS.ASO_QUOTE_PUB.PAYMENT_TBL_TYPE;
2954: X_HD_SHIPMENT_REC_ APPS.ASO_QUOTE_PUB.SHIPMENT_REC_TYPE;
2955: X_HD_FREIGHT_CHARGE_TBL_ APPS.ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE;
2956: X_HD_TAX_DETAIL_TBL_ APPS.ASO_QUOTE_PUB.TAX_DETAIL_TBL_TYPE;
2957: X_HD_ATTR_EXT_TBL_ APPS.ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_TBL_TYPE;
2950: X_QTE_LINE_TBL_ APPS.ASO_QUOTE_PUB.QTE_LINE_TBL_TYPE;
2951: X_QTE_LINE_DTL_TBL_ APPS.ASO_QUOTE_PUB.QTE_LINE_DTL_TBL_TYPE;
2952: X_HD_PRICE_ATTRIBUTES_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE;
2953: X_HD_PAYMENT_TBL_ APPS.ASO_QUOTE_PUB.PAYMENT_TBL_TYPE;
2954: X_HD_SHIPMENT_REC_ APPS.ASO_QUOTE_PUB.SHIPMENT_REC_TYPE;
2955: X_HD_FREIGHT_CHARGE_TBL_ APPS.ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE;
2956: X_HD_TAX_DETAIL_TBL_ APPS.ASO_QUOTE_PUB.TAX_DETAIL_TBL_TYPE;
2957: X_HD_ATTR_EXT_TBL_ APPS.ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_TBL_TYPE;
2958: X_HD_SALES_CREDIT_TBL_ APPS.ASO_QUOTE_PUB.SALES_CREDIT_TBL_TYPE;
2951: X_QTE_LINE_DTL_TBL_ APPS.ASO_QUOTE_PUB.QTE_LINE_DTL_TBL_TYPE;
2952: X_HD_PRICE_ATTRIBUTES_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE;
2953: X_HD_PAYMENT_TBL_ APPS.ASO_QUOTE_PUB.PAYMENT_TBL_TYPE;
2954: X_HD_SHIPMENT_REC_ APPS.ASO_QUOTE_PUB.SHIPMENT_REC_TYPE;
2955: X_HD_FREIGHT_CHARGE_TBL_ APPS.ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE;
2956: X_HD_TAX_DETAIL_TBL_ APPS.ASO_QUOTE_PUB.TAX_DETAIL_TBL_TYPE;
2957: X_HD_ATTR_EXT_TBL_ APPS.ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_TBL_TYPE;
2958: X_HD_SALES_CREDIT_TBL_ APPS.ASO_QUOTE_PUB.SALES_CREDIT_TBL_TYPE;
2959: X_HD_QUOTE_PARTY_TBL_ APPS.ASO_QUOTE_PUB.QUOTE_PARTY_TBL_TYPE;
2952: X_HD_PRICE_ATTRIBUTES_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE;
2953: X_HD_PAYMENT_TBL_ APPS.ASO_QUOTE_PUB.PAYMENT_TBL_TYPE;
2954: X_HD_SHIPMENT_REC_ APPS.ASO_QUOTE_PUB.SHIPMENT_REC_TYPE;
2955: X_HD_FREIGHT_CHARGE_TBL_ APPS.ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE;
2956: X_HD_TAX_DETAIL_TBL_ APPS.ASO_QUOTE_PUB.TAX_DETAIL_TBL_TYPE;
2957: X_HD_ATTR_EXT_TBL_ APPS.ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_TBL_TYPE;
2958: X_HD_SALES_CREDIT_TBL_ APPS.ASO_QUOTE_PUB.SALES_CREDIT_TBL_TYPE;
2959: X_HD_QUOTE_PARTY_TBL_ APPS.ASO_QUOTE_PUB.QUOTE_PARTY_TBL_TYPE;
2960: X_LINE_ATTR_EXT_TBL_ APPS.ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_TBL_TYPE;
2953: X_HD_PAYMENT_TBL_ APPS.ASO_QUOTE_PUB.PAYMENT_TBL_TYPE;
2954: X_HD_SHIPMENT_REC_ APPS.ASO_QUOTE_PUB.SHIPMENT_REC_TYPE;
2955: X_HD_FREIGHT_CHARGE_TBL_ APPS.ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE;
2956: X_HD_TAX_DETAIL_TBL_ APPS.ASO_QUOTE_PUB.TAX_DETAIL_TBL_TYPE;
2957: X_HD_ATTR_EXT_TBL_ APPS.ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_TBL_TYPE;
2958: X_HD_SALES_CREDIT_TBL_ APPS.ASO_QUOTE_PUB.SALES_CREDIT_TBL_TYPE;
2959: X_HD_QUOTE_PARTY_TBL_ APPS.ASO_QUOTE_PUB.QUOTE_PARTY_TBL_TYPE;
2960: X_LINE_ATTR_EXT_TBL_ APPS.ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_TBL_TYPE;
2961: X_LINE_RLTSHIP_TBL_ APPS.ASO_QUOTE_PUB.LINE_RLTSHIP_TBL_TYPE;
2954: X_HD_SHIPMENT_REC_ APPS.ASO_QUOTE_PUB.SHIPMENT_REC_TYPE;
2955: X_HD_FREIGHT_CHARGE_TBL_ APPS.ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE;
2956: X_HD_TAX_DETAIL_TBL_ APPS.ASO_QUOTE_PUB.TAX_DETAIL_TBL_TYPE;
2957: X_HD_ATTR_EXT_TBL_ APPS.ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_TBL_TYPE;
2958: X_HD_SALES_CREDIT_TBL_ APPS.ASO_QUOTE_PUB.SALES_CREDIT_TBL_TYPE;
2959: X_HD_QUOTE_PARTY_TBL_ APPS.ASO_QUOTE_PUB.QUOTE_PARTY_TBL_TYPE;
2960: X_LINE_ATTR_EXT_TBL_ APPS.ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_TBL_TYPE;
2961: X_LINE_RLTSHIP_TBL_ APPS.ASO_QUOTE_PUB.LINE_RLTSHIP_TBL_TYPE;
2962: X_PRICE_ADJUSTMENT_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ADJ_TBL_TYPE;
2955: X_HD_FREIGHT_CHARGE_TBL_ APPS.ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE;
2956: X_HD_TAX_DETAIL_TBL_ APPS.ASO_QUOTE_PUB.TAX_DETAIL_TBL_TYPE;
2957: X_HD_ATTR_EXT_TBL_ APPS.ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_TBL_TYPE;
2958: X_HD_SALES_CREDIT_TBL_ APPS.ASO_QUOTE_PUB.SALES_CREDIT_TBL_TYPE;
2959: X_HD_QUOTE_PARTY_TBL_ APPS.ASO_QUOTE_PUB.QUOTE_PARTY_TBL_TYPE;
2960: X_LINE_ATTR_EXT_TBL_ APPS.ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_TBL_TYPE;
2961: X_LINE_RLTSHIP_TBL_ APPS.ASO_QUOTE_PUB.LINE_RLTSHIP_TBL_TYPE;
2962: X_PRICE_ADJUSTMENT_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ADJ_TBL_TYPE;
2963: X_PRICE_ADJ_ATTR_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ADJ_ATTR_TBL_TYPE;
2956: X_HD_TAX_DETAIL_TBL_ APPS.ASO_QUOTE_PUB.TAX_DETAIL_TBL_TYPE;
2957: X_HD_ATTR_EXT_TBL_ APPS.ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_TBL_TYPE;
2958: X_HD_SALES_CREDIT_TBL_ APPS.ASO_QUOTE_PUB.SALES_CREDIT_TBL_TYPE;
2959: X_HD_QUOTE_PARTY_TBL_ APPS.ASO_QUOTE_PUB.QUOTE_PARTY_TBL_TYPE;
2960: X_LINE_ATTR_EXT_TBL_ APPS.ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_TBL_TYPE;
2961: X_LINE_RLTSHIP_TBL_ APPS.ASO_QUOTE_PUB.LINE_RLTSHIP_TBL_TYPE;
2962: X_PRICE_ADJUSTMENT_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ADJ_TBL_TYPE;
2963: X_PRICE_ADJ_ATTR_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ADJ_ATTR_TBL_TYPE;
2964: X_PRICE_ADJ_RLTSHIP_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_TBL_TYPE;
2957: X_HD_ATTR_EXT_TBL_ APPS.ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_TBL_TYPE;
2958: X_HD_SALES_CREDIT_TBL_ APPS.ASO_QUOTE_PUB.SALES_CREDIT_TBL_TYPE;
2959: X_HD_QUOTE_PARTY_TBL_ APPS.ASO_QUOTE_PUB.QUOTE_PARTY_TBL_TYPE;
2960: X_LINE_ATTR_EXT_TBL_ APPS.ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_TBL_TYPE;
2961: X_LINE_RLTSHIP_TBL_ APPS.ASO_QUOTE_PUB.LINE_RLTSHIP_TBL_TYPE;
2962: X_PRICE_ADJUSTMENT_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ADJ_TBL_TYPE;
2963: X_PRICE_ADJ_ATTR_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ADJ_ATTR_TBL_TYPE;
2964: X_PRICE_ADJ_RLTSHIP_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_TBL_TYPE;
2965: X_LN_PRICE_ATTRIBUTES_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE;
2958: X_HD_SALES_CREDIT_TBL_ APPS.ASO_QUOTE_PUB.SALES_CREDIT_TBL_TYPE;
2959: X_HD_QUOTE_PARTY_TBL_ APPS.ASO_QUOTE_PUB.QUOTE_PARTY_TBL_TYPE;
2960: X_LINE_ATTR_EXT_TBL_ APPS.ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_TBL_TYPE;
2961: X_LINE_RLTSHIP_TBL_ APPS.ASO_QUOTE_PUB.LINE_RLTSHIP_TBL_TYPE;
2962: X_PRICE_ADJUSTMENT_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ADJ_TBL_TYPE;
2963: X_PRICE_ADJ_ATTR_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ADJ_ATTR_TBL_TYPE;
2964: X_PRICE_ADJ_RLTSHIP_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_TBL_TYPE;
2965: X_LN_PRICE_ATTRIBUTES_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE;
2966: X_LN_PAYMENT_TBL_ APPS.ASO_QUOTE_PUB.PAYMENT_TBL_TYPE;
2959: X_HD_QUOTE_PARTY_TBL_ APPS.ASO_QUOTE_PUB.QUOTE_PARTY_TBL_TYPE;
2960: X_LINE_ATTR_EXT_TBL_ APPS.ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_TBL_TYPE;
2961: X_LINE_RLTSHIP_TBL_ APPS.ASO_QUOTE_PUB.LINE_RLTSHIP_TBL_TYPE;
2962: X_PRICE_ADJUSTMENT_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ADJ_TBL_TYPE;
2963: X_PRICE_ADJ_ATTR_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ADJ_ATTR_TBL_TYPE;
2964: X_PRICE_ADJ_RLTSHIP_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_TBL_TYPE;
2965: X_LN_PRICE_ATTRIBUTES_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE;
2966: X_LN_PAYMENT_TBL_ APPS.ASO_QUOTE_PUB.PAYMENT_TBL_TYPE;
2967: X_LN_SHIPMENT_TBL_ APPS.ASO_QUOTE_PUB.SHIPMENT_TBL_TYPE;
2960: X_LINE_ATTR_EXT_TBL_ APPS.ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_TBL_TYPE;
2961: X_LINE_RLTSHIP_TBL_ APPS.ASO_QUOTE_PUB.LINE_RLTSHIP_TBL_TYPE;
2962: X_PRICE_ADJUSTMENT_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ADJ_TBL_TYPE;
2963: X_PRICE_ADJ_ATTR_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ADJ_ATTR_TBL_TYPE;
2964: X_PRICE_ADJ_RLTSHIP_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_TBL_TYPE;
2965: X_LN_PRICE_ATTRIBUTES_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE;
2966: X_LN_PAYMENT_TBL_ APPS.ASO_QUOTE_PUB.PAYMENT_TBL_TYPE;
2967: X_LN_SHIPMENT_TBL_ APPS.ASO_QUOTE_PUB.SHIPMENT_TBL_TYPE;
2968: X_LN_FREIGHT_CHARGE_TBL_ APPS.ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE;
2961: X_LINE_RLTSHIP_TBL_ APPS.ASO_QUOTE_PUB.LINE_RLTSHIP_TBL_TYPE;
2962: X_PRICE_ADJUSTMENT_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ADJ_TBL_TYPE;
2963: X_PRICE_ADJ_ATTR_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ADJ_ATTR_TBL_TYPE;
2964: X_PRICE_ADJ_RLTSHIP_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_TBL_TYPE;
2965: X_LN_PRICE_ATTRIBUTES_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE;
2966: X_LN_PAYMENT_TBL_ APPS.ASO_QUOTE_PUB.PAYMENT_TBL_TYPE;
2967: X_LN_SHIPMENT_TBL_ APPS.ASO_QUOTE_PUB.SHIPMENT_TBL_TYPE;
2968: X_LN_FREIGHT_CHARGE_TBL_ APPS.ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE;
2969: X_LN_TAX_DETAIL_TBL_ APPS.ASO_QUOTE_PUB.TAX_DETAIL_TBL_TYPE;
2962: X_PRICE_ADJUSTMENT_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ADJ_TBL_TYPE;
2963: X_PRICE_ADJ_ATTR_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ADJ_ATTR_TBL_TYPE;
2964: X_PRICE_ADJ_RLTSHIP_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_TBL_TYPE;
2965: X_LN_PRICE_ATTRIBUTES_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE;
2966: X_LN_PAYMENT_TBL_ APPS.ASO_QUOTE_PUB.PAYMENT_TBL_TYPE;
2967: X_LN_SHIPMENT_TBL_ APPS.ASO_QUOTE_PUB.SHIPMENT_TBL_TYPE;
2968: X_LN_FREIGHT_CHARGE_TBL_ APPS.ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE;
2969: X_LN_TAX_DETAIL_TBL_ APPS.ASO_QUOTE_PUB.TAX_DETAIL_TBL_TYPE;
2970: X_LN_SALES_CREDIT_TBL_ APPS.ASO_QUOTE_PUB.SALES_CREDIT_TBL_TYPE;
2963: X_PRICE_ADJ_ATTR_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ADJ_ATTR_TBL_TYPE;
2964: X_PRICE_ADJ_RLTSHIP_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_TBL_TYPE;
2965: X_LN_PRICE_ATTRIBUTES_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE;
2966: X_LN_PAYMENT_TBL_ APPS.ASO_QUOTE_PUB.PAYMENT_TBL_TYPE;
2967: X_LN_SHIPMENT_TBL_ APPS.ASO_QUOTE_PUB.SHIPMENT_TBL_TYPE;
2968: X_LN_FREIGHT_CHARGE_TBL_ APPS.ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE;
2969: X_LN_TAX_DETAIL_TBL_ APPS.ASO_QUOTE_PUB.TAX_DETAIL_TBL_TYPE;
2970: X_LN_SALES_CREDIT_TBL_ APPS.ASO_QUOTE_PUB.SALES_CREDIT_TBL_TYPE;
2971: X_LN_QUOTE_PARTY_TBL_ APPS.ASO_QUOTE_PUB.QUOTE_PARTY_TBL_TYPE;
2964: X_PRICE_ADJ_RLTSHIP_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_TBL_TYPE;
2965: X_LN_PRICE_ATTRIBUTES_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE;
2966: X_LN_PAYMENT_TBL_ APPS.ASO_QUOTE_PUB.PAYMENT_TBL_TYPE;
2967: X_LN_SHIPMENT_TBL_ APPS.ASO_QUOTE_PUB.SHIPMENT_TBL_TYPE;
2968: X_LN_FREIGHT_CHARGE_TBL_ APPS.ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE;
2969: X_LN_TAX_DETAIL_TBL_ APPS.ASO_QUOTE_PUB.TAX_DETAIL_TBL_TYPE;
2970: X_LN_SALES_CREDIT_TBL_ APPS.ASO_QUOTE_PUB.SALES_CREDIT_TBL_TYPE;
2971: X_LN_QUOTE_PARTY_TBL_ APPS.ASO_QUOTE_PUB.QUOTE_PARTY_TBL_TYPE;
2972: X_QTE_ACCESS_TBL_ APPS.ASO_QUOTE_PUB.QTE_ACCESS_TBL_TYPE;
2965: X_LN_PRICE_ATTRIBUTES_TBL_ APPS.ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE;
2966: X_LN_PAYMENT_TBL_ APPS.ASO_QUOTE_PUB.PAYMENT_TBL_TYPE;
2967: X_LN_SHIPMENT_TBL_ APPS.ASO_QUOTE_PUB.SHIPMENT_TBL_TYPE;
2968: X_LN_FREIGHT_CHARGE_TBL_ APPS.ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE;
2969: X_LN_TAX_DETAIL_TBL_ APPS.ASO_QUOTE_PUB.TAX_DETAIL_TBL_TYPE;
2970: X_LN_SALES_CREDIT_TBL_ APPS.ASO_QUOTE_PUB.SALES_CREDIT_TBL_TYPE;
2971: X_LN_QUOTE_PARTY_TBL_ APPS.ASO_QUOTE_PUB.QUOTE_PARTY_TBL_TYPE;
2972: X_QTE_ACCESS_TBL_ APPS.ASO_QUOTE_PUB.QTE_ACCESS_TBL_TYPE;
2973: X_TEMPLATE_TBL_ APPS.ASO_QUOTE_PUB.TEMPLATE_TBL_TYPE;
2966: X_LN_PAYMENT_TBL_ APPS.ASO_QUOTE_PUB.PAYMENT_TBL_TYPE;
2967: X_LN_SHIPMENT_TBL_ APPS.ASO_QUOTE_PUB.SHIPMENT_TBL_TYPE;
2968: X_LN_FREIGHT_CHARGE_TBL_ APPS.ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE;
2969: X_LN_TAX_DETAIL_TBL_ APPS.ASO_QUOTE_PUB.TAX_DETAIL_TBL_TYPE;
2970: X_LN_SALES_CREDIT_TBL_ APPS.ASO_QUOTE_PUB.SALES_CREDIT_TBL_TYPE;
2971: X_LN_QUOTE_PARTY_TBL_ APPS.ASO_QUOTE_PUB.QUOTE_PARTY_TBL_TYPE;
2972: X_QTE_ACCESS_TBL_ APPS.ASO_QUOTE_PUB.QTE_ACCESS_TBL_TYPE;
2973: X_TEMPLATE_TBL_ APPS.ASO_QUOTE_PUB.TEMPLATE_TBL_TYPE;
2974: X_RELATED_OBJ_TBL_ APPS.ASO_QUOTE_PUB.RELATED_OBJ_TBL_TYPE;
2967: X_LN_SHIPMENT_TBL_ APPS.ASO_QUOTE_PUB.SHIPMENT_TBL_TYPE;
2968: X_LN_FREIGHT_CHARGE_TBL_ APPS.ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE;
2969: X_LN_TAX_DETAIL_TBL_ APPS.ASO_QUOTE_PUB.TAX_DETAIL_TBL_TYPE;
2970: X_LN_SALES_CREDIT_TBL_ APPS.ASO_QUOTE_PUB.SALES_CREDIT_TBL_TYPE;
2971: X_LN_QUOTE_PARTY_TBL_ APPS.ASO_QUOTE_PUB.QUOTE_PARTY_TBL_TYPE;
2972: X_QTE_ACCESS_TBL_ APPS.ASO_QUOTE_PUB.QTE_ACCESS_TBL_TYPE;
2973: X_TEMPLATE_TBL_ APPS.ASO_QUOTE_PUB.TEMPLATE_TBL_TYPE;
2974: X_RELATED_OBJ_TBL_ APPS.ASO_QUOTE_PUB.RELATED_OBJ_TBL_TYPE;
2975: x_msg_data_temp VARCHAR2(2000);
2968: X_LN_FREIGHT_CHARGE_TBL_ APPS.ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE;
2969: X_LN_TAX_DETAIL_TBL_ APPS.ASO_QUOTE_PUB.TAX_DETAIL_TBL_TYPE;
2970: X_LN_SALES_CREDIT_TBL_ APPS.ASO_QUOTE_PUB.SALES_CREDIT_TBL_TYPE;
2971: X_LN_QUOTE_PARTY_TBL_ APPS.ASO_QUOTE_PUB.QUOTE_PARTY_TBL_TYPE;
2972: X_QTE_ACCESS_TBL_ APPS.ASO_QUOTE_PUB.QTE_ACCESS_TBL_TYPE;
2973: X_TEMPLATE_TBL_ APPS.ASO_QUOTE_PUB.TEMPLATE_TBL_TYPE;
2974: X_RELATED_OBJ_TBL_ APPS.ASO_QUOTE_PUB.RELATED_OBJ_TBL_TYPE;
2975: x_msg_data_temp VARCHAR2(2000);
2976: lx_msg_index_out NUMBER;
2969: X_LN_TAX_DETAIL_TBL_ APPS.ASO_QUOTE_PUB.TAX_DETAIL_TBL_TYPE;
2970: X_LN_SALES_CREDIT_TBL_ APPS.ASO_QUOTE_PUB.SALES_CREDIT_TBL_TYPE;
2971: X_LN_QUOTE_PARTY_TBL_ APPS.ASO_QUOTE_PUB.QUOTE_PARTY_TBL_TYPE;
2972: X_QTE_ACCESS_TBL_ APPS.ASO_QUOTE_PUB.QTE_ACCESS_TBL_TYPE;
2973: X_TEMPLATE_TBL_ APPS.ASO_QUOTE_PUB.TEMPLATE_TBL_TYPE;
2974: X_RELATED_OBJ_TBL_ APPS.ASO_QUOTE_PUB.RELATED_OBJ_TBL_TYPE;
2975: x_msg_data_temp VARCHAR2(2000);
2976: lx_msg_index_out NUMBER;
2977: BEGIN
2970: X_LN_SALES_CREDIT_TBL_ APPS.ASO_QUOTE_PUB.SALES_CREDIT_TBL_TYPE;
2971: X_LN_QUOTE_PARTY_TBL_ APPS.ASO_QUOTE_PUB.QUOTE_PARTY_TBL_TYPE;
2972: X_QTE_ACCESS_TBL_ APPS.ASO_QUOTE_PUB.QTE_ACCESS_TBL_TYPE;
2973: X_TEMPLATE_TBL_ APPS.ASO_QUOTE_PUB.TEMPLATE_TBL_TYPE;
2974: X_RELATED_OBJ_TBL_ APPS.ASO_QUOTE_PUB.RELATED_OBJ_TBL_TYPE;
2975: x_msg_data_temp VARCHAR2(2000);
2976: lx_msg_index_out NUMBER;
2977: BEGIN
2978: P_CONTROL_REC_ := ASO_QUOTE_EBIZAD.SQL_TO_PL0(P_CONTROL_REC);
3004: P_RELATED_OBJ_TBL_ := ASO_QUOTE_EBIZAD.SQL_TO_PL19(P_RELATED_OBJ_TBL);
3005:
3006: po_moac_utils_pvt.set_org_context(P_QTE_HEADER_REC_.ORG_ID);
3007:
3008: APPS.ASO_QUOTE_PUB.CREATE_QUOTE_SERVICE(1.0,P_INIT_MSG_LIST,P_COMMIT,P_VALIDATION_LEVEL,P_CONTROL_REC_,P_QTE_HEADER_REC_,P_HD_PRICE_ATTRIBUTES_TBL_,P_HD_PAYMENT_TBL_,
3009: P_HD_SHIPMENT_REC_,P_HD_FREIGHT_CHARGE_TBL_,P_HD_TAX_DETAIL_TBL_,P_HD_ATTR_EXT_TBL_,P_HD_SALES_CREDIT_TBL_,P_HD_QUOTE_PARTY_TBL_,P_QTE_LINE_TBL_,P_QTE_LINE_DTL_TBL_,
3010: P_LINE_ATTR_EXT_TBL_,P_LINE_RLTSHIP_TBL_,P_PRICE_ADJUSTMENT_TBL_,P_PRICE_ADJ_ATTR_TBL_,P_PRICE_ADJ_RLTSHIP_TBL_,P_LN_PRICE_ATTRIBUTES_TBL_,P_LN_PAYMENT_TBL_,P_LN_SHIPMENT_TBL_,
3011: P_LN_FREIGHT_CHARGE_TBL_,P_LN_TAX_DETAIL_TBL_,P_LN_SALES_CREDIT_TBL_,P_LN_QUOTE_PARTY_TBL_,P_QTE_ACCESS_TBL_,P_TEMPLATE_TBL_,P_RELATED_OBJ_TBL_,X_QTE_HEADER_REC_,
3012: X_QTE_LINE_TBL_,X_QTE_LINE_DTL_TBL_,X_HD_PRICE_ATTRIBUTES_TBL_,X_HD_PAYMENT_TBL_,X_HD_SHIPMENT_REC_,X_HD_FREIGHT_CHARGE_TBL_,X_HD_TAX_DETAIL_TBL_,