[Home] [Help]
PACKAGE: APPS.ASO_QUOTE_HEADERS_PVT
Source
1 PACKAGE ASO_QUOTE_HEADERS_PVT AUTHID CURRENT_USER as
2 /* $Header: asovqhds.pls 120.2.12000000.2 2007/01/31 19:46:35 skulkarn ship $ */
3 -- Package name : ASO_QUOTE_HEADERS_PVT
4 -- Purpose :
5 -- History :
6 -- NOTE :
7 -- End of Comments
8
9 -- Default number of records fetch per call
10 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
11
12 -- hyang defaulting framework
13 G_QUOTE_HEADER_DB_NAME CONSTANT VARCHAR2(30) := 'ASO_AK_QUOTE_HEADER_V';
14 G_QUOTE_LINE_DB_NAME CONSTANT VARCHAR2(30) := 'ASO_AK_QUOTE_LINE_V';
15 G_QUOTE_OPPORTUNITY_DB_NAME CONSTANT VARCHAR2(30) := 'ASO_AK_QUOTE_OPPTY_V';
16 G_STORE_CART_HEADER_DB_NAME CONSTANT VARCHAR2(30) := 'ASO_AK_STORE_CART_HEADER_V';
17 G_STORE_CART_LINE_DB_NAME CONSTANT VARCHAR2(30) := 'ASO_AK_STORE_CART_LINES_V';
18 -- hyang defaulting framework end
19
20 TYPE Index_Link_Tbl_Type IS TABLE OF NUMBER INDEX BY VARCHAR2(32767);
21 G_MISS_Link_Tbl Index_Link_Tbl_Type;
22
23 TYPE Instance_Rec_Type IS RECORD
24 (
25 Instance_id NUMBER,
26 Price_List_Id NUMBER := FND_API.G_MISS_NUM
27 );
28 G_MISS_Instance_Rec Instance_Rec_Type;
29
30 TYPE Instance_Tbl_Type IS TABLE OF Instance_Rec_Type INDEX BY BINARY_INTEGER;
31 G_MISS_Instance_Tbl Instance_Tbl_Type;
32
33 TYPE VARCHAR_Tbl_Type IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
34
35
36 -- *******************************************************
37 -- Start of Comments
38 -- *******************************************************
39 -- API Name: Create_quote
40 -- Type : Private
41 -- Pre-Req :
42 -- Parameters:
43 -- IN
44 -- p_api_version_number IN NUMBER Required
45 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
46 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
47 -- P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type Required
48 --
49 -- OUT:
50 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
51 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
52 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
53 -- Version : Current version 2.0
54 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
55 -- and basic operation, developer must manually add parameters and business logic as necessary.
56 --
57 -- End of Comments
58 --
59 PROCEDURE Create_quote(
60 P_Api_Version_Number IN NUMBER,
61 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
62 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
63 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
64 P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type
65 := ASO_QUOTE_PUB.G_Miss_Control_Rec,
66 P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
67 := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
68 P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
69 := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
70 P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
71 := ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL,
72 P_hd_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
73 := ASO_QUOTE_PUB.G_MISS_SHIPMENT_REC,
74 P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type
75 := ASO_QUOTE_PUB.G_Miss_Freight_Charge_Tbl,
76 P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type
77 := ASO_QUOTE_PUB.G_Miss_Tax_Detail_Tbl,
78 P_hd_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
79 := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
80 P_hd_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type
81 := ASO_QUOTE_PUB.G_MISS_Sales_Credit_Tbl,
82 P_hd_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type
83 := ASO_QUOTE_PUB.G_MISS_Quote_Party_Tbl,
84 P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
85 := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL,
86 P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
87 := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL,
88 P_Line_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
89 := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
90 P_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
91 := ASO_QUOTE_PUB.G_MISS_Line_Rltship_Tbl,
92 P_Price_Adjustment_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
93 := ASO_QUOTE_PUB.G_Miss_Price_Adj_Tbl,
94 P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
95 := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
96 P_Price_Adj_Rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
97 := ASO_QUOTE_PUB.G_Miss_Price_Adj_Rltship_Tbl,
98 P_ln_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
99 := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
100 P_ln_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
101 := ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL,
102 P_ln_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
103 := ASO_QUOTE_PUB.G_MISS_SHIPMENT_TBL,
104 P_ln_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type
105 := ASO_QUOTE_PUB.G_Miss_Freight_Charge_Tbl,
106 P_ln_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type
107 := ASO_QUOTE_PUB.G_Miss_Tax_Detail_Tbl,
108 P_ln_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type
109 := ASO_QUOTE_PUB.G_MISS_Sales_Credit_Tbl,
110 P_ln_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type
111 := ASO_QUOTE_PUB.G_MISS_Quote_Party_Tbl,
112 P_Qte_Access_Tbl IN ASO_QUOTE_PUB.Qte_Access_Tbl_Type := ASO_QUOTE_PUB.G_MISS_QTE_ACCESS_TBL,
113 P_Template_Tbl IN ASO_QUOTE_PUB.Template_Tbl_Type := ASO_QUOTE_PUB.G_MISS_TEMPLATE_TBL,
114 P_Related_Obj_Tbl IN ASO_QUOTE_PUB.Related_Obj_Tbl_Type := ASO_QUOTE_PUB.G_MISS_RELATED_OBJ_TBL,
115 x_Qte_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
116 X_Qte_Line_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
117 X_Qte_Line_Dtl_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
118 X_hd_Price_Attributes_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
119 X_hd_Payment_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Payment_Tbl_Type,
120 X_hd_Shipment_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Shipment_Rec_Type,
121 X_hd_Freight_Charge_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
122 X_hd_Tax_Detail_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
123 X_hd_Attr_Ext_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
124 X_hd_Sales_Credit_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
125 X_hd_Quote_Party_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
126 x_Line_Attr_Ext_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
127 X_line_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
128 X_Price_Adjustment_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
129 X_Price_Adj_Attr_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
130 X_Price_Adj_Rltship_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
131 X_ln_Price_Attributes_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
132 X_ln_Payment_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Payment_Tbl_Type,
133 X_ln_Shipment_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Shipment_Tbl_Type,
134 X_ln_Freight_Charge_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
135 X_ln_Tax_Detail_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
136 X_Ln_Sales_Credit_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
137 X_Ln_Quote_Party_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
138 X_Qte_Access_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Access_Tbl_Type,
139 X_Template_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Template_Tbl_Type,
140 X_Related_Obj_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Related_Obj_Tbl_Type,
141 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
142 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
143 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
144 );
145
146 -- *******************************************************
147 -- Start of Comments
148 -- *******************************************************
149 -- API Name: Update_quote
150 -- Type : Private
151 -- Pre-Req :
152 -- Parameters:
153 -- IN
154 -- p_api_version_number IN NUMBER Required
155 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
156 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
157 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
158 -- P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type Required
159 --
160 -- OUT:
161 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
162 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
163 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
164 -- Version : Current version 2.0
165 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
166 -- and basic operation, developer must manually add parameters and business logic as necessary.
167 --
168 -- End of Comments
169 --
170 -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
171
172 PROCEDURE Update_quote(
173 P_Api_Version_Number IN NUMBER,
174 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
175 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
176 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
177 P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type
178 := ASO_QUOTE_PUB.G_Miss_Control_Rec,
179 P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
180 := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
181 P_hd_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
182 := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
183 P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
184 := ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL,
185 P_hd_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
186 := ASO_QUOTE_PUB.G_MISS_SHIPMENT_TBL,
187 P_hd_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type
188 := ASO_QUOTE_PUB.G_Miss_Freight_Charge_Tbl,
189 P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type
190 := ASO_QUOTE_PUB.G_Miss_Tax_Detail_Tbl,
191 P_hd_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
192 := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
193 P_hd_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type
194 := ASO_QUOTE_PUB.G_MISS_Sales_Credit_Tbl,
195 P_hd_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type
196 := ASO_QUOTE_PUB.G_MISS_Quote_Party_Tbl,
197 P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
198 := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL,
199 P_Qte_Line_Dtl_Tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
200 := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL,
201 P_Line_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type
202 := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_TBL,
203 P_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
204 := ASO_QUOTE_PUB.G_MISS_Line_Rltship_Tbl,
205 P_Price_Adjustment_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
206 := ASO_QUOTE_PUB.G_Miss_Price_Adj_Tbl,
207 P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
208 := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
209 P_Price_Adj_Rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
210 := ASO_QUOTE_PUB.G_Miss_Price_Adj_Rltship_Tbl,
211 P_ln_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
212 := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
213 P_ln_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
214 := ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL,
215 P_ln_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
216 := ASO_QUOTE_PUB.G_MISS_SHIPMENT_TBL,
217 P_ln_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type
218 := ASO_QUOTE_PUB.G_Miss_Freight_Charge_Tbl,
219 P_ln_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type
220 := ASO_QUOTE_PUB.G_Miss_Tax_Detail_Tbl,
221 P_ln_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type
222 := ASO_QUOTE_PUB.G_MISS_Sales_Credit_Tbl,
223 P_ln_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type
224 := ASO_QUOTE_PUB.G_MISS_Quote_Party_Tbl,
225 P_Qte_Access_Tbl IN ASO_QUOTE_PUB.Qte_Access_Tbl_Type := ASO_QUOTE_PUB.G_MISS_QTE_ACCESS_TBL,
226 P_Template_Tbl IN ASO_QUOTE_PUB.Template_Tbl_Type := ASO_QUOTE_PUB.G_MISS_TEMPLATE_TBL,
227 P_Related_Obj_Tbl IN ASO_QUOTE_PUB.Related_Obj_Tbl_Type := ASO_QUOTE_PUB.G_MISS_RELATED_OBJ_TBL,
228 x_Qte_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
229 X_Qte_Line_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
230 X_Qte_Line_Dtl_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
231 X_hd_Price_Attributes_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
232 X_hd_Payment_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Payment_Tbl_Type,
236 X_hd_Attr_Ext_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
233 X_hd_Shipment_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Shipment_Tbl_Type,
234 X_hd_Freight_Charge_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
235 X_hd_Tax_Detail_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
237 X_hd_Sales_Credit_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
238 X_hd_Quote_Party_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
239 x_Line_Attr_Ext_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
240 X_line_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Line_Rltship_Tbl_Type,
241 X_Price_Adjustment_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
242 X_Price_Adj_Attr_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
243 X_Price_Adj_Rltship_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
244 X_ln_Price_Attributes_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
245 X_ln_Payment_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Payment_Tbl_Type,
246 X_ln_Shipment_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Shipment_Tbl_Type,
247 X_ln_Freight_Charge_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
248 X_ln_Tax_Detail_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
249 X_Ln_Sales_Credit_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
250 X_Ln_Quote_Party_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
251 X_Qte_Access_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Access_Tbl_Type,
252 X_Template_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Template_Tbl_Type,
253 X_Related_Obj_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Related_Obj_Tbl_Type,
254 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
255 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
256 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
257 );
258
259 -- *******************************************************
260 -- Start of Comments
261 -- *******************************************************
262 -- API Name: Delete_quote
263 -- Type : Private
264 -- Pre-Req :
265 -- Parameters:
266 -- IN
267 -- p_api_version_number IN NUMBER Required
268 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
269 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
270 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
271 -- P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type Required
272 --
273 -- OUT:
274 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
275 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
276 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
277 -- Version : Current version 2.0
278 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
279 -- and basic operation, developer must manually add parameters and business logic as necessary.
280 --
281 -- End of Comments
282 --
283 -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
284 -- The Master delete procedure may not be needed depends on different business requirements.
285 PROCEDURE Delete_quote(
286 P_Api_Version_Number IN NUMBER,
287 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
288 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
289 P_Qte_Header_Id IN NUMBER,
290 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
291 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
292 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
293 );
294
295 -- *******************************************************
296 -- Start of Comments
297 -- *******************************************************
298 -- API Name: Copy_quote
299 -- Type : Private
300 -- Pre-Req :
301 -- Parameters:
302 -- IN
303 -- p_api_version_number IN NUMBER Required
304 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
305 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
306 --
307 -- OUT NOCOPY /* file.sql.39 change */ :
308 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
309 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
310 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
311 -- Version : Current version 2.0
312 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
313 -- and basic operation, developer must manually add parameters and business logic as necessary.
314 --
315 -- End of Comments
316 --
317 PROCEDURE Copy_quote(
318 P_Api_Version_Number IN NUMBER,
319 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
320 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
321 P_control_rec IN ASO_QUOTE_PUB.control_rec_type := ASO_QUOTE_PUB.G_MISS_Control_Rec,
322 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
323 P_Qte_Header_Id IN NUMBER,
324 P_Last_Update_Date IN DATE,
325 P_Copy_Only_Header IN VARCHAR2 := FND_API.G_FALSE,
326 P_New_Version IN VARCHAR2 := FND_API.G_FALSE,
330 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
327 P_Qte_Status_Id IN NUMBER := NULL,
328 P_Qte_Number IN NUMBER := NULL,
329 X_Qte_Header_Id OUT NOCOPY /* file.sql.39 change */ NUMBER,
331 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
332 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
333 );
334
335
336 -- *******************************************************
337 -- Start of Comments
338 -- *******************************************************
339 -- API Name: Validate_Quote
340 -- Type : Private
341 -- Pre-Req :
342 -- Parameters:
343 -- IN
344 -- p_api_version_number IN NUMBER Required
345 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
346 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
347 -- OUT:
348 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
349 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
350 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
351 -- Version : Current version 2.0
352 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
353 -- and basic operation, developer must manually add parameters and business logic as necessary.
354 --
355 -- End of Comments
356 --
357 PROCEDURE Validate_quote(
358 P_Api_Version_Number IN NUMBER,
359 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
360 P_Qte_Header_Id IN NUMBER,
361 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
362 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
363 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
364 );
365
366 -- *******************************************************
367 -- Start of Comments
368 -- *******************************************************
369 -- API Name: Submit_Quote
370 -- Type : Private
371 -- Pre-Req :
372 -- Parameters:
373 -- IN
374 -- p_api_version_number IN NUMBER Required
375 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
376 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
377 -- OUT:
378 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
379 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
380 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
381 -- Version : Current version 2.0
382 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
383 -- and basic operation, developer must manually add parameters and business logic as necessary.
384 --
385 -- End of Comments
386 --
387 PROCEDURE Submit_Quote
388 (
389 P_Api_Version_Number IN NUMBER,
390 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
391 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
392 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
393 p_control_rec IN ASO_QUOTE_PUB.SUBMIT_CONTROL_REC_TYPE
394 := ASO_QUOTE_PUB.G_MISS_SUBMIT_CONTROL_REC,
395 P_Qte_Header_Id IN NUMBER,
396 X_Order_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Order_Header_Rec_Type,
397 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
398 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
399 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
400
401 -- *******************************************************
402 -- Start of Comments
403 -- *******************************************************
404 -- API Name: Get_quote
405 -- Type : Private
406 -- Pre-Req :
407 -- Parameters:
408 -- IN
409 -- p_api_version_number IN NUMBER Required
410 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
411 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
412 -- P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type Required
413 -- Hint: Add List of bind variables here
414 -- p_rec_requested IN NUMBER Optional Default = 30
415 -- p_start_rec_ptr IN NUMBER Optional Default = 1
416 --
417 -- Return Total Records Count Flag. This flag controls whether the total record count
418 -- and total record amount is returned.
419 --
420 -- p_return_tot_count IN VARCHAR2 Optional Default = FND_API.G_FALSE
421 -- Hint: User defined record type
422 -- p_order_by_tbl IN AS_UTILITY_PUB.UTIL_ORDER_BY_TBL_TYPE;
423 --
424 -- OUT:
425 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
426 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
427 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
428 -- X_Qte_Header_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type
429 -- x_returned_rec_count OUT NOCOPY /* file.sql.39 change */ NUMBER
430 -- x_next_rec_ptr OUT NOCOPY /* file.sql.39 change */ NUMBER
431 -- x_tot_rec_count OUT NOCOPY /* file.sql.39 change */ NUMBER
432 -- other optional OUT NOCOPY /* file.sql.39 change */ parameters
433 -- x_tot_rec_amount OUT NOCOPY /* file.sql.39 change */ NUMBER
434 -- Version : Current version 2.0
435 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
439 --
436 -- and basic operation, developer must manually add parameters and business logic as necessary.
437 --
438 -- End of Comments
440 PROCEDURE Get_quote(
441 P_Api_Version_Number IN NUMBER,
442 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
443 P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
444 -- Hint: Add list of bind variables here
445 p_rec_requested IN NUMBER := G_DEFAULT_NUM_REC_FETCH,
446 p_start_rec_prt IN NUMBER := 1,
447 p_return_tot_count IN NUMBER := FND_API.G_FALSE,
448 -- Hint: user defined record type
449 p_order_by_rec IN ASO_QUOTE_PUB.QTE_sort_rec_type,
450 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
451 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
452 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
453 X_Qte_Header_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Tbl_Type,
454 x_returned_rec_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
455 x_next_rec_ptr OUT NOCOPY /* file.sql.39 change */ NUMBER,
456 x_tot_rec_count OUT NOCOPY /* file.sql.39 change */ NUMBER
457 -- other optional parameters
458 -- x_tot_rec_amount OUT NOCOPY /* file.sql.39 change */ NUMBER
459 );
460
461 PROCEDURE Update_Quote_Total (
462 P_Qte_Header_id IN NUMBER,
463 P_Calculate_Tax IN VARCHAR2,
464 P_calculate_Freight_Charge IN VARCHAR2,
465 p_control_rec IN ASO_QUOTE_PUB.CONTROL_REC_TYPE
466 := ASO_QUOTE_PUB.G_MISS_CONTROL_REC,
467 P_Call_Ar_Api_Flag IN VARCHAR2 := FND_API.G_FALSE,
468 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
469 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
470 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
471
472
473 PROCEDURE config_copy(
474 p_qte_line_id IN NUMBER,
475 p_old_config_header_id IN NUMBER,
476 p_old_config_revision_num IN NUMBER,
477 p_config_header_id IN NUMBER,
478 p_config_revision_num IN NUMBER,
479 x_qte_header_id IN NUMBER,
480 qte_header_id IN NUMBER,
481 p_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
482 p_control_rec IN ASO_QUOTE_PUB.CONTROL_REC_TYPE := ASO_QUOTE_PUB.G_MISS_Control_Rec,
483 l_line_index_link_tbl IN OUT NOCOPY ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type,
484 l_price_index_link_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type,
485 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
486 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
487 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
488 );
489
490 PROCEDURE service_copy(
491 p_qte_line_id IN NUMBER,
492 x_qte_header_id IN NUMBER,
493 qte_header_id IN NUMBER,
494 p_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
495 P_control_rec IN ASO_QUOTE_PUB.control_rec_type := ASO_QUOTE_PUB.G_MISS_Control_Rec,
496 l_line_index_link_tbl IN OUT NOCOPY ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type,
497 l_price_index_link_tbl IN OUT NOCOPY ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type,
498 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
499 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
500 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
501 );
502
503 PROCEDURE Quote_Security_Check(
504 P_Api_Version_Number IN NUMBER,
505 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
506 P_User_Id IN NUMBER,
507 X_Resource_Id OUT NOCOPY /* file.sql.39 change */ NUMBER,
508 X_Security_Flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
509 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
510 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
511 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
512 );
513 PROCEDURE Insert_Rows (
514 P_qte_Header_Rec IN ASO_QUOTE_PUB.qte_header_rec_Type,
515 p_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
516 P_Price_Adjustment_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
517 P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
518 P_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type,
519 P_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type,
520 P_Freight_Charge_Tbl IN ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
521 P_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
522 P_hd_Attr_Ext_Tbl IN ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
523 P_Sales_Credit_Tbl IN ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
524 P_Quote_Party_Tbl IN ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
525 P_Qte_Access_Tbl IN ASO_QUOTE_PUB.Qte_Access_Tbl_Type,
526 X_qte_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.qte_header_rec_Type,
527 X_Price_Attributes_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
528 X_Price_Adjustment_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
529 x_Price_Adj_Attr_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
530 X_Payment_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Payment_Tbl_Type,
531 X_Shipment_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Shipment_Rec_Type,
532 X_Freight_Charge_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Freight_Charge_Tbl_Type,
533 X_Tax_Detail_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Tax_Detail_Tbl_Type,
534 X_hd_Attr_Ext_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type,
535 X_Sales_Credit_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Sales_Credit_Tbl_Type,
536 X_Quote_Party_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Quote_Party_Tbl_Type,
537 x_Qte_Access_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Access_Tbl_Type,
538 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
539 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
540 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
541 );
542
543 FUNCTION Shipment_Null_Rec_Exists(
544 p_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type,
545 p_database_object_name IN VARCHAR2
546 ) RETURN BOOLEAN;
547
548 FUNCTION Payment_NULL_Rec_Exists(
549 p_payment_rec IN ASO_QUOTE_PUB.Payment_Rec_Type,
550 p_database_object_name IN VARCHAR2
551 ) RETURN BOOLEAN;
552
553 FUNCTION Tax_Detail_Null_Rec_Exists(
554 p_tax_detail_rec IN ASO_QUOTE_PUB.Tax_Detail_Rec_Type,
555 p_database_object_name IN VARCHAR2
556 ) RETURN BOOLEAN;
557
558
559 End ASO_QUOTE_HEADERS_PVT;