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 (
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,
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:
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:
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
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,
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,
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
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,
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
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,
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
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,
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,
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,
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,
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,
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,
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,
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,
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);
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:
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,
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,
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
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,
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
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,
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
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,
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
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,
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,
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,
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,
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,
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,
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,
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,
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,
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);
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:
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);
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: