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

Source


1 PACKAGE ASO_QUOTE_EBIZAD AUTHID CURRENT_USER AS
2 /* $Header: asopebzs.pls 120.2 2010/08/20 21:30:27 cazhou noship $ */
3 /*
4  * @rep:scope public
5  * @rep:product ASO
6  * @rep:displayname Order Capture
7  * @rep:lifecycle active
8  * @rep:compatibility S
9  * @rep:category BUSINESS_ENTITY ASO_QUOTE
10 */
11 
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 --
21 --   SQL Object and Tables:
22 
23 --   ASO_QUOTE_PUB_CONTROL_REC_TYP
24 --   ASO_QUOTE_PUB_QTE_HEADER_REC_
25 --   ASO_QUOTE_PUB_PRICE_ATTRIBU34
26 --   ASO_QUOTE_PUB_PRICE_ATTRIBUTE AS TABLE OF ASO_QUOTE_PUB_PRICE_ATTRIBU34;
27 --   ASO_QUOTE_PUB_PAYMENT_REC_TYP
28 --   ASO_QUOTE_PUB_PAYMENT_TBL_TYP AS TABLE OF ASO_QUOTE_PUB_PAYMENT_REC_TYP;
29 --   ASO_QUOTE_PUB_SHIPMENT_REC_TY
30 --   ASO_QUOTE_PUB_FREIGHT_CHARG35
31 --   ASO_QUOTE_PUB_FREIGHT_CHARGE_ AS TABLE OF ASO_QUOTE_PUB_FREIGHT_CHARG35;
32 --   ASO_QUOTE_PUB_TAX_DETAIL_REC_
33 --   ASO_QUOTE_PUB_TAX_DETAIL_TBL_ AS TABLE OF ASO_QUOTE_PUB_TAX_DETAIL_REC_;
34 --   ASO_QUOTE_PUB_LINE_ATTRIBS_36
35 --   ASO_QUOTE_PUB_LINE_ATTRIBS_EX AS TABLE OF ASO_QUOTE_PUB_LINE_ATTRIBS_36;
36 --   ASO_QUOTE_PUB_SALES_CREDIT_RE
37 --   ASO_QUOTE_PUB_SALES_CREDIT_TB AS TABLE OF ASO_QUOTE_PUB_SALES_CREDIT_RE;
38 --   ASO_QUOTE_PUB_QUOTE_PARTY_REC
39 --   ASO_QUOTE_PUB_QUOTE_PARTY_TBL AS TABLE OF ASO_QUOTE_PUB_QUOTE_PARTY_REC;
40 --   ASO_QUOTE_PUB_QTE_LINE_REC_TY
41 --   ASO_QUOTE_PUB_QTE_LINE_TBL_TY AS TABLE OF ASO_QUOTE_PUB_QTE_LINE_REC_TY;
42 --   ASO_QUOTE_PUB_QTE_LINE_DTL_RE
43 --   ASO_QUOTE_PUB_QTE_LINE_DTL_TB AS TABLE OF ASO_QUOTE_PUB_QTE_LINE_DTL_RE;
44 --   ASO_QUOTE_PUB_LINE_RLTSHIP_RE
45 --   ASO_QUOTE_PUB_LINE_RLTSHIP_TB AS TABLE OF ASO_QUOTE_PUB_LINE_RLTSHIP_RE;
46 --   ASO_QUOTE_PUB_PRICE_ADJ_REC_T
47 --   ASO_QUOTE_PUB_PRICE_ADJ_TBL_T AS TABLE OF ASO_QUOTE_PUB_PRICE_ADJ_REC_T;
48 --   ASO_QUOTE_PUB_PRICE_ADJ_ATT37
49 --   ASO_QUOTE_PUB_PRICE_ADJ_ATTR_ AS TABLE OF ASO_QUOTE_PUB_PRICE_ADJ_ATT37;
50 --   ASO_QUOTE_PUB_PRICE_ADJ_RLT38
51 --   ASO_QUOTE_PUB_PRICE_ADJ_RLTSH AS TABLE OF ASO_QUOTE_PUB_PRICE_ADJ_RLT38;
52 --   ASO_QUOTE_PUB_SHIPMENT_TBL_TY AS TABLE OF ASO_QUOTE_PUB_SHIPMENT_REC_TY;
53 --   ASO_QUOTE_PUB_QTE_ACCESS_REC_
54 --   ASO_QUOTE_PUB_QTE_ACCESS_TBL_ AS TABLE OF ASO_QUOTE_PUB_QTE_ACCESS_REC_;
55 --   ASO_QUOTE_PUB_TEMPLATE_REC_TY
56 --   ASO_QUOTE_PUB_TEMPLATE_TBL_TY AS TABLE OF ASO_QUOTE_PUB_TEMPLATE_REC_TY;
57 --   ASO_QUOTE_PUB_RELATED_OBJ_REC
58 --   ASO_QUOTE_PUB_RELATED_OBJ_TBL AS TABLE OF ASO_QUOTE_PUB_RELATED_OBJ_REC;
59 
60 - History          :
61 -- NOTE             :
62 
63 -- End of Comments
64 */
65 
66 	-- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.CONTROL_REC_TYPE
67 	FUNCTION PL_TO_SQL19(aPlsqlItem ASO_QUOTE_PUB.CONTROL_REC_TYPE)
68  	RETURN ASO_QUOTE_PUB_CONTROL_REC_TYP;
69 	FUNCTION SQL_TO_PL0(aSqlItem ASO_QUOTE_PUB_CONTROL_REC_TYP)
70 	RETURN ASO_QUOTE_PUB.CONTROL_REC_TYPE;
71 	-- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE
72 	FUNCTION PL_TO_SQL0(aPlsqlItem ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE)
73 
74  	RETURN ASO_QUOTE_PUB_QTE_HEADER_REC_;
75 	FUNCTION SQL_TO_PL1(aSqlItem ASO_QUOTE_PUB_QTE_HEADER_REC_)
76 	RETURN ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE;
77 	-- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.PRICE_ATTRIBUTES_REC_TYPE
78 	FUNCTION PL_TO_SQL20(aPlsqlItem ASO_QUOTE_PUB.PRICE_ATTRIBUTES_REC_TYPE)
79  	RETURN ASO_QUOTE_PUB_PRICE_ATTRIBU34;
80 	FUNCTION SQL_TO_PL20(aSqlItem ASO_QUOTE_PUB_PRICE_ATTRIBU34)
81 	RETURN ASO_QUOTE_PUB.PRICE_ATTRIBUTES_REC_TYPE;
82 	-- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE
83 	FUNCTION PL_TO_SQL3(aPlsqlItem ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE)
84  	RETURN ASO_QUOTE_PUB_PRICE_ATTRIBUTE;
85 	FUNCTION SQL_TO_PL2(aSqlItem ASO_QUOTE_PUB_PRICE_ATTRIBUTE)
86 	RETURN ASO_QUOTE_PUB.PRICE_ATTRIBUTES_TBL_TYPE;
87 	-- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.PAYMENT_REC_TYPE
88 	FUNCTION PL_TO_SQL21(aPlsqlItem ASO_QUOTE_PUB.PAYMENT_REC_TYPE)
89  	RETURN ASO_QUOTE_PUB_PAYMENT_REC_TYP;
90 	FUNCTION SQL_TO_PL21(aSqlItem ASO_QUOTE_PUB_PAYMENT_REC_TYP)
91 	RETURN ASO_QUOTE_PUB.PAYMENT_REC_TYPE;
92 	-- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.PAYMENT_TBL_TYPE
93 	FUNCTION PL_TO_SQL4(aPlsqlItem ASO_QUOTE_PUB.PAYMENT_TBL_TYPE)
94  	RETURN ASO_QUOTE_PUB_PAYMENT_TBL_TYP;
95 	FUNCTION SQL_TO_PL3(aSqlItem ASO_QUOTE_PUB_PAYMENT_TBL_TYP)
96 	RETURN ASO_QUOTE_PUB.PAYMENT_TBL_TYPE;
97 	-- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.SHIPMENT_REC_TYPE
98 	FUNCTION PL_TO_SQL5(aPlsqlItem ASO_QUOTE_PUB.SHIPMENT_REC_TYPE)
99  	RETURN ASO_QUOTE_PUB_SHIPMENT_REC_TY;
100 	FUNCTION SQL_TO_PL4(aSqlItem ASO_QUOTE_PUB_SHIPMENT_REC_TY)
101 	RETURN ASO_QUOTE_PUB.SHIPMENT_REC_TYPE;
102 	-- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.FREIGHT_CHARGE_REC_TYPE
103 	FUNCTION PL_TO_SQL22(aPlsqlItem ASO_QUOTE_PUB.FREIGHT_CHARGE_REC_TYPE)
104  	RETURN ASO_QUOTE_PUB_FREIGHT_CHARG35;
105 	FUNCTION SQL_TO_PL22(aSqlItem ASO_QUOTE_PUB_FREIGHT_CHARG35)
106 	RETURN ASO_QUOTE_PUB.FREIGHT_CHARGE_REC_TYPE;
107 	-- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE
108 	FUNCTION PL_TO_SQL6(aPlsqlItem ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE)
109  	RETURN ASO_QUOTE_PUB_FREIGHT_CHARGE_;
110 	FUNCTION SQL_TO_PL5(aSqlItem ASO_QUOTE_PUB_FREIGHT_CHARGE_)
111 	RETURN ASO_QUOTE_PUB.FREIGHT_CHARGE_TBL_TYPE;
112 	-- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE
113 	FUNCTION PL_TO_SQL23(aPlsqlItem ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE)
114  	RETURN ASO_QUOTE_PUB_TAX_DETAIL_REC_;
115 	FUNCTION SQL_TO_PL23(aSqlItem ASO_QUOTE_PUB_TAX_DETAIL_REC_)
116 	RETURN ASO_QUOTE_PUB.TAX_DETAIL_REC_TYPE;
117 	-- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.TAX_DETAIL_TBL_TYPE
118 	FUNCTION PL_TO_SQL7(aPlsqlItem ASO_QUOTE_PUB.TAX_DETAIL_TBL_TYPE)
119  	RETURN ASO_QUOTE_PUB_TAX_DETAIL_TBL_;
120 	FUNCTION SQL_TO_PL6(aSqlItem ASO_QUOTE_PUB_TAX_DETAIL_TBL_)
121 	RETURN ASO_QUOTE_PUB.TAX_DETAIL_TBL_TYPE;
122 	-- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_REC_TYPE
123 	FUNCTION PL_TO_SQL24(aPlsqlItem ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_REC_TYPE)
124  	RETURN ASO_QUOTE_PUB_LINE_ATTRIBS_36;
125 	FUNCTION SQL_TO_PL24(aSqlItem ASO_QUOTE_PUB_LINE_ATTRIBS_36)
126 	RETURN ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_REC_TYPE;
127 	-- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_TBL_TYPE
128 	FUNCTION PL_TO_SQL8(aPlsqlItem ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_TBL_TYPE)
129  	RETURN ASO_QUOTE_PUB_LINE_ATTRIBS_EX;
130 	FUNCTION SQL_TO_PL7(aSqlItem ASO_QUOTE_PUB_LINE_ATTRIBS_EX)
131 	RETURN ASO_QUOTE_PUB.LINE_ATTRIBS_EXT_TBL_TYPE;
132 	-- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.SALES_CREDIT_REC_TYPE
133 	FUNCTION PL_TO_SQL25(aPlsqlItem ASO_QUOTE_PUB.SALES_CREDIT_REC_TYPE)
134  	RETURN ASO_QUOTE_PUB_SALES_CREDIT_RE;
135 	FUNCTION SQL_TO_PL25(aSqlItem ASO_QUOTE_PUB_SALES_CREDIT_RE)
136 	RETURN ASO_QUOTE_PUB.SALES_CREDIT_REC_TYPE;
137 	-- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.SALES_CREDIT_TBL_TYPE
138 	FUNCTION PL_TO_SQL9(aPlsqlItem ASO_QUOTE_PUB.SALES_CREDIT_TBL_TYPE)
139  	RETURN ASO_QUOTE_PUB_SALES_CREDIT_TB;
140 	FUNCTION SQL_TO_PL8(aSqlItem ASO_QUOTE_PUB_SALES_CREDIT_TB)
141 	RETURN ASO_QUOTE_PUB.SALES_CREDIT_TBL_TYPE;
142 	-- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.QUOTE_PARTY_REC_TYPE
143 	FUNCTION PL_TO_SQL26(aPlsqlItem ASO_QUOTE_PUB.QUOTE_PARTY_REC_TYPE)
144  	RETURN ASO_QUOTE_PUB_QUOTE_PARTY_REC;
145 	FUNCTION SQL_TO_PL26(aSqlItem ASO_QUOTE_PUB_QUOTE_PARTY_REC)
146 	RETURN ASO_QUOTE_PUB.QUOTE_PARTY_REC_TYPE;
147 	-- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.QUOTE_PARTY_TBL_TYPE
148 	FUNCTION PL_TO_SQL10(aPlsqlItem ASO_QUOTE_PUB.QUOTE_PARTY_TBL_TYPE)
149  	RETURN ASO_QUOTE_PUB_QUOTE_PARTY_TBL;
150 	FUNCTION SQL_TO_PL9(aSqlItem ASO_QUOTE_PUB_QUOTE_PARTY_TBL)
151 	RETURN ASO_QUOTE_PUB.QUOTE_PARTY_TBL_TYPE;
152 	-- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.QTE_LINE_REC_TYPE
153 	FUNCTION PL_TO_SQL27(aPlsqlItem ASO_QUOTE_PUB.QTE_LINE_REC_TYPE)
154  	RETURN ASO_QUOTE_PUB_QTE_LINE_REC_TY;
155 	FUNCTION SQL_TO_PL27(aSqlItem ASO_QUOTE_PUB_QTE_LINE_REC_TY)
156 	RETURN ASO_QUOTE_PUB.QTE_LINE_REC_TYPE;
157 	-- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.QTE_LINE_TBL_TYPE
158 	FUNCTION PL_TO_SQL1(aPlsqlItem ASO_QUOTE_PUB.QTE_LINE_TBL_TYPE)
159  	RETURN ASO_QUOTE_PUB_QTE_LINE_TBL_TY;
160 	FUNCTION SQL_TO_PL10(aSqlItem ASO_QUOTE_PUB_QTE_LINE_TBL_TY)
161 	RETURN ASO_QUOTE_PUB.QTE_LINE_TBL_TYPE;
162 	-- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.QTE_LINE_DTL_REC_TYPE
163 	FUNCTION PL_TO_SQL28(aPlsqlItem ASO_QUOTE_PUB.QTE_LINE_DTL_REC_TYPE)
164  	RETURN ASO_QUOTE_PUB_QTE_LINE_DTL_RE;
165 	FUNCTION SQL_TO_PL28(aSqlItem ASO_QUOTE_PUB_QTE_LINE_DTL_RE)
166 	RETURN ASO_QUOTE_PUB.QTE_LINE_DTL_REC_TYPE;
167 	-- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.QTE_LINE_DTL_TBL_TYPE
168 	FUNCTION PL_TO_SQL2(aPlsqlItem ASO_QUOTE_PUB.QTE_LINE_DTL_TBL_TYPE)
169  	RETURN ASO_QUOTE_PUB_QTE_LINE_DTL_TB;
170 	FUNCTION SQL_TO_PL11(aSqlItem ASO_QUOTE_PUB_QTE_LINE_DTL_TB)
171 	RETURN ASO_QUOTE_PUB.QTE_LINE_DTL_TBL_TYPE;
172 	-- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.LINE_RLTSHIP_REC_TYPE
173 	FUNCTION PL_TO_SQL29(aPlsqlItem ASO_QUOTE_PUB.LINE_RLTSHIP_REC_TYPE)
174  	RETURN ASO_QUOTE_PUB_LINE_RLTSHIP_RE;
175 	FUNCTION SQL_TO_PL29(aSqlItem ASO_QUOTE_PUB_LINE_RLTSHIP_RE)
176 	RETURN ASO_QUOTE_PUB.LINE_RLTSHIP_REC_TYPE;
177 	-- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.LINE_RLTSHIP_TBL_TYPE
178 	FUNCTION PL_TO_SQL11(aPlsqlItem ASO_QUOTE_PUB.LINE_RLTSHIP_TBL_TYPE)
179  	RETURN ASO_QUOTE_PUB_LINE_RLTSHIP_TB;
180 	FUNCTION SQL_TO_PL12(aSqlItem ASO_QUOTE_PUB_LINE_RLTSHIP_TB)
181 	RETURN ASO_QUOTE_PUB.LINE_RLTSHIP_TBL_TYPE;
182 	-- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.PRICE_ADJ_REC_TYPE
183 	FUNCTION PL_TO_SQL30(aPlsqlItem ASO_QUOTE_PUB.PRICE_ADJ_REC_TYPE)
184  	RETURN ASO_QUOTE_PUB_PRICE_ADJ_REC_T;
185 	FUNCTION SQL_TO_PL30(aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_REC_T)
186 	RETURN ASO_QUOTE_PUB.PRICE_ADJ_REC_TYPE;
187 	-- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.PRICE_ADJ_TBL_TYPE
188 	FUNCTION PL_TO_SQL12(aPlsqlItem ASO_QUOTE_PUB.PRICE_ADJ_TBL_TYPE)
189  	RETURN ASO_QUOTE_PUB_PRICE_ADJ_TBL_T;
190 	FUNCTION SQL_TO_PL13(aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_TBL_T)
191 	RETURN ASO_QUOTE_PUB.PRICE_ADJ_TBL_TYPE;
192 	-- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.PRICE_ADJ_ATTR_REC_TYPE
193 	FUNCTION PL_TO_SQL31(aPlsqlItem ASO_QUOTE_PUB.PRICE_ADJ_ATTR_REC_TYPE)
194  	RETURN ASO_QUOTE_PUB_PRICE_ADJ_ATT37;
195 	FUNCTION SQL_TO_PL31(aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_ATT37)
196 	RETURN ASO_QUOTE_PUB.PRICE_ADJ_ATTR_REC_TYPE;
197 	-- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.PRICE_ADJ_ATTR_TBL_TYPE
198 	FUNCTION PL_TO_SQL13(aPlsqlItem ASO_QUOTE_PUB.PRICE_ADJ_ATTR_TBL_TYPE)
199  	RETURN ASO_QUOTE_PUB_PRICE_ADJ_ATTR_;
200 	FUNCTION SQL_TO_PL14(aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_ATTR_)
201 	RETURN ASO_QUOTE_PUB.PRICE_ADJ_ATTR_TBL_TYPE;
202 	-- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_REC_TYPE
203 	FUNCTION PL_TO_SQL32(aPlsqlItem ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_REC_TYPE)
204  	RETURN ASO_QUOTE_PUB_PRICE_ADJ_RLT38;
205 	FUNCTION SQL_TO_PL32(aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_RLT38)
206 	RETURN ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_REC_TYPE;
207 	-- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_TBL_TYPE
208 	FUNCTION PL_TO_SQL14(aPlsqlItem ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_TBL_TYPE)
209  	RETURN ASO_QUOTE_PUB_PRICE_ADJ_RLTSH;
210 	FUNCTION SQL_TO_PL15(aSqlItem ASO_QUOTE_PUB_PRICE_ADJ_RLTSH)
211 	RETURN ASO_QUOTE_PUB.PRICE_ADJ_RLTSHIP_TBL_TYPE;
212 	-- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.SHIPMENT_TBL_TYPE
213 	FUNCTION PL_TO_SQL15(aPlsqlItem ASO_QUOTE_PUB.SHIPMENT_TBL_TYPE)
214  	RETURN ASO_QUOTE_PUB_SHIPMENT_TBL_TY;
215 	FUNCTION SQL_TO_PL16(aSqlItem ASO_QUOTE_PUB_SHIPMENT_TBL_TY)
216 	RETURN ASO_QUOTE_PUB.SHIPMENT_TBL_TYPE;
217 	-- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.QTE_ACCESS_REC_TYPE
218 	FUNCTION PL_TO_SQL33(aPlsqlItem ASO_QUOTE_PUB.QTE_ACCESS_REC_TYPE)
219  	RETURN ASO_QUOTE_PUB_QTE_ACCESS_REC_;
220 	FUNCTION SQL_TO_PL33(aSqlItem ASO_QUOTE_PUB_QTE_ACCESS_REC_)
221 	RETURN ASO_QUOTE_PUB.QTE_ACCESS_REC_TYPE;
222 	-- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.QTE_ACCESS_TBL_TYPE
223 	FUNCTION PL_TO_SQL16(aPlsqlItem ASO_QUOTE_PUB.QTE_ACCESS_TBL_TYPE)
224  	RETURN ASO_QUOTE_PUB_QTE_ACCESS_TBL_;
225 	FUNCTION SQL_TO_PL17(aSqlItem ASO_QUOTE_PUB_QTE_ACCESS_TBL_)
226 	RETURN ASO_QUOTE_PUB.QTE_ACCESS_TBL_TYPE;
227 	-- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.TEMPLATE_REC_TYPE
228 	FUNCTION PL_TO_SQL34(aPlsqlItem ASO_QUOTE_PUB.TEMPLATE_REC_TYPE)
229  	RETURN ASO_QUOTE_PUB_TEMPLATE_REC_TY;
230 	FUNCTION SQL_TO_PL34(aSqlItem ASO_QUOTE_PUB_TEMPLATE_REC_TY)
231 	RETURN ASO_QUOTE_PUB.TEMPLATE_REC_TYPE;
232 	-- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.TEMPLATE_TBL_TYPE
233 	FUNCTION PL_TO_SQL17(aPlsqlItem ASO_QUOTE_PUB.TEMPLATE_TBL_TYPE)
234  	RETURN ASO_QUOTE_PUB_TEMPLATE_TBL_TY;
235 	FUNCTION SQL_TO_PL18(aSqlItem ASO_QUOTE_PUB_TEMPLATE_TBL_TY)
236 	RETURN ASO_QUOTE_PUB.TEMPLATE_TBL_TYPE;
240 	FUNCTION SQL_TO_PL35(aSqlItem ASO_QUOTE_PUB_RELATED_OBJ_REC)
237 	-- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.RELATED_OBJ_REC_TYPE
238 	FUNCTION PL_TO_SQL35(aPlsqlItem ASO_QUOTE_PUB.RELATED_OBJ_REC_TYPE)
239  	RETURN ASO_QUOTE_PUB_RELATED_OBJ_REC;
241 	RETURN ASO_QUOTE_PUB.RELATED_OBJ_REC_TYPE;
242 	-- Declare the conversion functions the PL/SQL type ASO_QUOTE_PUB.RELATED_OBJ_TBL_TYPE
243 	FUNCTION PL_TO_SQL18(aPlsqlItem ASO_QUOTE_PUB.RELATED_OBJ_TBL_TYPE)
244  	RETURN ASO_QUOTE_PUB_RELATED_OBJ_TBL;
245 	FUNCTION SQL_TO_PL19(aSqlItem ASO_QUOTE_PUB_RELATED_OBJ_TBL)
246 	RETURN ASO_QUOTE_PUB.RELATED_OBJ_TBL_TYPE;
247 
248 PROCEDURE CREATE_QUOTE_SERVICE (
249     P_API_VERSION_NUMBER IN NUMBER,
250     P_INIT_MSG_LIST IN VARCHAR2,
251     P_COMMIT IN VARCHAR2,
252     P_VALIDATION_LEVEL IN NUMBER,
253     P_CONTROL_REC IN ASO_QUOTE_PUB_CONTROL_REC_TYP,
254     P_QTE_HEADER_REC IN ASO_QUOTE_PUB_QTE_HEADER_REC_,
255     P_HD_PRICE_ATTRIBUTES_TBL IN ASO_QUOTE_PUB_PRICE_ATTRIBUTE,
256     P_HD_PAYMENT_TBL IN ASO_QUOTE_PUB_PAYMENT_TBL_TYP,
257     P_HD_SHIPMENT_REC IN ASO_QUOTE_PUB_SHIPMENT_REC_TY,
258     P_HD_FREIGHT_CHARGE_TBL IN ASO_QUOTE_PUB_FREIGHT_CHARGE_,
259     P_HD_TAX_DETAIL_TBL IN ASO_QUOTE_PUB_TAX_DETAIL_TBL_,
260     P_HD_ATTR_EXT_TBL IN ASO_QUOTE_PUB_LINE_ATTRIBS_EX,
261     P_HD_SALES_CREDIT_TBL IN ASO_QUOTE_PUB_SALES_CREDIT_TB,
262     P_HD_QUOTE_PARTY_TBL IN ASO_QUOTE_PUB_QUOTE_PARTY_TBL,
263     P_QTE_LINE_TBL IN ASO_QUOTE_PUB_QTE_LINE_TBL_TY,
264     P_QTE_LINE_DTL_TBL IN ASO_QUOTE_PUB_QTE_LINE_DTL_TB,
265     P_LINE_ATTR_EXT_TBL IN ASO_QUOTE_PUB_LINE_ATTRIBS_EX,
266     P_LINE_RLTSHIP_TBL IN ASO_QUOTE_PUB_LINE_RLTSHIP_TB,
267     P_PRICE_ADJUSTMENT_TBL IN ASO_QUOTE_PUB_PRICE_ADJ_TBL_T,
268     P_PRICE_ADJ_ATTR_TBL IN ASO_QUOTE_PUB_PRICE_ADJ_ATTR_,
269     P_PRICE_ADJ_RLTSHIP_TBL IN ASO_QUOTE_PUB_PRICE_ADJ_RLTSH,
270     P_LN_PRICE_ATTRIBUTES_TBL IN ASO_QUOTE_PUB_PRICE_ATTRIBUTE,
271     P_LN_PAYMENT_TBL IN ASO_QUOTE_PUB_PAYMENT_TBL_TYP,
272     P_LN_SHIPMENT_TBL IN ASO_QUOTE_PUB_SHIPMENT_TBL_TY,
273     P_LN_FREIGHT_CHARGE_TBL IN ASO_QUOTE_PUB_FREIGHT_CHARGE_,
274     P_LN_TAX_DETAIL_TBL IN ASO_QUOTE_PUB_TAX_DETAIL_TBL_,
275     P_LN_SALES_CREDIT_TBL IN ASO_QUOTE_PUB_SALES_CREDIT_TB,
276     P_LN_QUOTE_PARTY_TBL IN ASO_QUOTE_PUB_QUOTE_PARTY_TBL,
277     P_QTE_ACCESS_TBL IN ASO_QUOTE_PUB_QTE_ACCESS_TBL_,
278     P_TEMPLATE_TBL IN ASO_QUOTE_PUB_TEMPLATE_TBL_TY,
279     P_RELATED_OBJ_TBL IN ASO_QUOTE_PUB_RELATED_OBJ_TBL,
280     X_QTE_HEADER_REC OUT NOCOPY ASO_QUOTE_PUB_QTE_HEADER_REC_,
281     X_QTE_LINE_TBL OUT NOCOPY ASO_QUOTE_PUB_QTE_LINE_TBL_TY,
282     X_QTE_LINE_DTL_TBL OUT NOCOPY ASO_QUOTE_PUB_QTE_LINE_DTL_TB,
283     X_HD_PRICE_ATTRIBUTES_TBL OUT NOCOPY ASO_QUOTE_PUB_PRICE_ATTRIBUTE,
284     X_HD_PAYMENT_TBL OUT NOCOPY ASO_QUOTE_PUB_PAYMENT_TBL_TYP,
285     X_HD_SHIPMENT_REC OUT NOCOPY ASO_QUOTE_PUB_SHIPMENT_REC_TY,
286     X_HD_FREIGHT_CHARGE_TBL OUT NOCOPY ASO_QUOTE_PUB_FREIGHT_CHARGE_,
287     X_HD_TAX_DETAIL_TBL OUT NOCOPY ASO_QUOTE_PUB_TAX_DETAIL_TBL_,
288     X_HD_ATTR_EXT_TBL OUT NOCOPY ASO_QUOTE_PUB_LINE_ATTRIBS_EX,
289     X_HD_SALES_CREDIT_TBL OUT NOCOPY ASO_QUOTE_PUB_SALES_CREDIT_TB,
290     X_HD_QUOTE_PARTY_TBL OUT NOCOPY ASO_QUOTE_PUB_QUOTE_PARTY_TBL,
291     X_LINE_ATTR_EXT_TBL OUT NOCOPY ASO_QUOTE_PUB_LINE_ATTRIBS_EX,
292     X_LINE_RLTSHIP_TBL OUT NOCOPY ASO_QUOTE_PUB_LINE_RLTSHIP_TB,
293     X_PRICE_ADJUSTMENT_TBL OUT NOCOPY ASO_QUOTE_PUB_PRICE_ADJ_TBL_T,
294     X_PRICE_ADJ_ATTR_TBL OUT NOCOPY ASO_QUOTE_PUB_PRICE_ADJ_ATTR_,
295     X_PRICE_ADJ_RLTSHIP_TBL OUT NOCOPY ASO_QUOTE_PUB_PRICE_ADJ_RLTSH,
296     X_LN_PRICE_ATTRIBUTES_TBL OUT NOCOPY ASO_QUOTE_PUB_PRICE_ATTRIBUTE,
297     X_LN_PAYMENT_TBL OUT NOCOPY ASO_QUOTE_PUB_PAYMENT_TBL_TYP,
298     X_LN_SHIPMENT_TBL OUT NOCOPY ASO_QUOTE_PUB_SHIPMENT_TBL_TY,
299     X_LN_FREIGHT_CHARGE_TBL OUT NOCOPY ASO_QUOTE_PUB_FREIGHT_CHARGE_,
300     X_LN_TAX_DETAIL_TBL OUT NOCOPY ASO_QUOTE_PUB_TAX_DETAIL_TBL_,
301     X_LN_SALES_CREDIT_TBL OUT NOCOPY ASO_QUOTE_PUB_SALES_CREDIT_TB,
302     X_LN_QUOTE_PARTY_TBL OUT NOCOPY ASO_QUOTE_PUB_QUOTE_PARTY_TBL,
303     X_QTE_ACCESS_TBL OUT NOCOPY ASO_QUOTE_PUB_QTE_ACCESS_TBL_,
304     X_TEMPLATE_TBL OUT NOCOPY ASO_QUOTE_PUB_TEMPLATE_TBL_TY,
305     X_RELATED_OBJ_TBL OUT NOCOPY ASO_QUOTE_PUB_RELATED_OBJ_TBL,
306     X_RETURN_STATUS OUT NOCOPY VARCHAR2,
307     X_MSG_COUNT OUT NOCOPY NUMBER,
308     X_MSG_DATA OUT NOCOPY VARCHAR2
309 );
310 
311 
312 END ASO_QUOTE_EBIZAD;