DBA Data[Home] [Help]

APPS.ASO_PRICING_INT dependencies on ASO_QUOTE_PUB

Line 241: p_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type,

237:
238: G_LINE_REC PRICING_LINE_REC_TYPE;
239:
240: FUNCTION Set_Global_Rec (
241: p_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type,
242: p_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type)
243: RETURN PRICING_HEADER_REC_TYPE;
244:
245: FUNCTION Set_Global_Rec (

Line 242: p_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type)

238: G_LINE_REC PRICING_LINE_REC_TYPE;
239:
240: FUNCTION Set_Global_Rec (
241: p_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type,
242: p_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type)
243: RETURN PRICING_HEADER_REC_TYPE;
244:
245: FUNCTION Set_Global_Rec (
246: p_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type,

Line 246: p_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type,

242: p_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type)
243: RETURN PRICING_HEADER_REC_TYPE;
244:
245: FUNCTION Set_Global_Rec (
246: p_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type,
247: p_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type,
248: p_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type)
249: RETURN PRICING_LINE_REC_TYPE;
250:

Line 247: p_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type,

243: RETURN PRICING_HEADER_REC_TYPE;
244:
245: FUNCTION Set_Global_Rec (
246: p_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type,
247: p_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type,
248: p_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type)
249: RETURN PRICING_LINE_REC_TYPE;
250:
251:

Line 248: p_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type)

244:
245: FUNCTION Set_Global_Rec (
246: p_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type,
247: p_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type,
248: p_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type)
249: RETURN PRICING_LINE_REC_TYPE;
250:
251:
252: --wli_start

Line 317: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,

313: P_Api_Version_Number IN NUMBER,
314: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
315: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
316: p_control_rec IN PRICING_CONTROL_REC_TYPE,
317: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
318: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
319: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
320: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
321: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,

Line 318: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type

314: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
315: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
316: p_control_rec IN PRICING_CONTROL_REC_TYPE,
317: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
318: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
319: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
320: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
321: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
322: p_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,

Line 319: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,

315: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
316: p_control_rec IN PRICING_CONTROL_REC_TYPE,
317: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
318: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
319: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
320: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
321: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
322: p_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
323: p_qte_line_dtl_rec IN ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type

Line 320: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type

316: p_control_rec IN PRICING_CONTROL_REC_TYPE,
317: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
318: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
319: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
320: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
321: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
322: p_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
323: p_qte_line_dtl_rec IN ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type
324: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Rec,

Line 321: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,

317: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
318: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
319: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
320: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
321: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
322: p_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
323: p_qte_line_dtl_rec IN ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type
324: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Rec,
325: p_ln_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type

Line 322: p_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,

318: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
319: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
320: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
321: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
322: p_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
323: p_qte_line_dtl_rec IN ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type
324: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Rec,
325: p_ln_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
326: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,

Line 323: p_qte_line_dtl_rec IN ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type

319: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
320: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
321: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
322: p_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
323: p_qte_line_dtl_rec IN ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type
324: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Rec,
325: p_ln_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
326: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
327: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type

Line 324: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Rec,

320: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
321: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
322: p_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
323: p_qte_line_dtl_rec IN ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type
324: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Rec,
325: p_ln_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
326: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
327: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
328: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,

Line 325: p_ln_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type

321: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
322: p_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
323: p_qte_line_dtl_rec IN ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type
324: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Rec,
325: p_ln_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
326: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
327: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
328: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
329: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,

Line 326: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,

322: p_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
323: p_qte_line_dtl_rec IN ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type
324: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Rec,
325: p_ln_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
326: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
327: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
328: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
329: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
330: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,

Line 327: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type

323: p_qte_line_dtl_rec IN ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type
324: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Rec,
325: p_ln_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
326: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
327: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
328: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
329: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
330: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
331: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,

Line 328: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,

324: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Rec,
325: p_ln_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
326: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
327: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
328: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
329: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
330: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
331: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
332: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,

Line 329: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,

325: p_ln_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
326: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
327: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
328: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
329: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
330: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
331: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
332: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
333: x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,

Line 330: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,

326: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
327: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
328: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
329: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
330: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
331: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
332: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
333: x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
334: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 331: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,

327: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
328: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
329: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
330: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
331: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
332: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
333: x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
334: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
335: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 332: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,

328: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
329: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
330: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
331: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
332: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
333: x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
334: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
335: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
336: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);

Line 333: x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,

329: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
330: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
331: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
332: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
333: x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
334: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
335: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
336: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
337:

Line 343: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,

339: P_Api_Version_Number IN NUMBER,
340: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
341: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
342: p_control_rec IN PRICING_CONTROL_REC_TYPE,
343: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
344: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
345: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
346: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
347: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,

Line 344: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type

340: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
341: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
342: p_control_rec IN PRICING_CONTROL_REC_TYPE,
343: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
344: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
345: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
346: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
347: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
348: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,

Line 345: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,

341: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
342: p_control_rec IN PRICING_CONTROL_REC_TYPE,
343: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
344: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
345: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
346: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
347: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
348: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
349: p_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type

Line 346: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type

342: p_control_rec IN PRICING_CONTROL_REC_TYPE,
343: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
344: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
345: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
346: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
347: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
348: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
349: p_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
350: := ASO_QUOTE_PUB.G_Miss_Line_Rltship_Tbl,

Line 347: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,

343: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
344: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
345: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
346: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
347: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
348: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
349: p_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
350: := ASO_QUOTE_PUB.G_Miss_Line_Rltship_Tbl,
351: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type

Line 348: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,

344: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
345: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
346: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
347: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
348: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
349: p_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
350: := ASO_QUOTE_PUB.G_Miss_Line_Rltship_Tbl,
351: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
352: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl,

Line 349: p_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type

345: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
346: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
347: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
348: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
349: p_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
350: := ASO_QUOTE_PUB.G_Miss_Line_Rltship_Tbl,
351: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
352: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl,
353: p_ln_shipment_tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type

Line 350: := ASO_QUOTE_PUB.G_Miss_Line_Rltship_Tbl,

346: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
347: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
348: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
349: p_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
350: := ASO_QUOTE_PUB.G_Miss_Line_Rltship_Tbl,
351: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
352: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl,
353: p_ln_shipment_tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
354: := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl,

Line 351: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type

347: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
348: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
349: p_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
350: := ASO_QUOTE_PUB.G_Miss_Line_Rltship_Tbl,
351: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
352: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl,
353: p_ln_shipment_tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
354: := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl,
355: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type

Line 352: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl,

348: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
349: p_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
350: := ASO_QUOTE_PUB.G_Miss_Line_Rltship_Tbl,
351: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
352: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl,
353: p_ln_shipment_tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
354: := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl,
355: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
356: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,

Line 353: p_ln_shipment_tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type

349: p_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
350: := ASO_QUOTE_PUB.G_Miss_Line_Rltship_Tbl,
351: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
352: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl,
353: p_ln_shipment_tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
354: := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl,
355: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
356: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
357: x_qte_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,

Line 354: := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl,

350: := ASO_QUOTE_PUB.G_Miss_Line_Rltship_Tbl,
351: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
352: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl,
353: p_ln_shipment_tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
354: := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl,
355: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
356: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
357: x_qte_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
358: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,

Line 355: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type

351: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
352: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl,
353: p_ln_shipment_tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
354: := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl,
355: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
356: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
357: x_qte_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
358: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
359: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,

Line 356: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,

352: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl,
353: p_ln_shipment_tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
354: := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl,
355: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
356: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
357: x_qte_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
358: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
359: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
360: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,

Line 357: x_qte_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,

353: p_ln_shipment_tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
354: := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl,
355: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
356: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
357: x_qte_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
358: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
359: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
360: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
361: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,

Line 358: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,

354: := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl,
355: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
356: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
357: x_qte_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
358: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
359: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
360: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
361: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
362: x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,

Line 359: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,

355: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
356: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
357: x_qte_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
358: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
359: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
360: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
361: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
362: x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
363: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 360: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,

356: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
357: x_qte_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
358: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
359: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
360: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
361: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
362: x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
363: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
364: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 361: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,

357: x_qte_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
358: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
359: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
360: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
361: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
362: x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
363: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
364: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
365: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);

Line 362: x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,

358: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
359: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
360: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
361: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
362: x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
363: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
364: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
365: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
366:

Line 382: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,

378: P_Api_Version_Number IN NUMBER,
379: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
380: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
381: p_control_rec IN PRICING_CONTROL_REC_TYPE,
382: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
383: p_qte_header_id IN NUMBER,
384: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
385: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
386: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);

Line 392: p_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,

388: Procedure Delete_Promotion (
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_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
393: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
394: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
395: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
396: