249:
250: G_LINE_REC PRICING_LINE_REC_TYPE;
251:
252: FUNCTION Set_Global_Rec (
253: p_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type,
254: p_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type)
255: RETURN PRICING_HEADER_REC_TYPE;
256:
257: FUNCTION Set_Global_Rec (
250: G_LINE_REC PRICING_LINE_REC_TYPE;
251:
252: FUNCTION Set_Global_Rec (
253: p_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type,
254: p_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type)
255: RETURN PRICING_HEADER_REC_TYPE;
256:
257: FUNCTION Set_Global_Rec (
258: p_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type,
254: p_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type)
255: RETURN PRICING_HEADER_REC_TYPE;
256:
257: FUNCTION Set_Global_Rec (
258: p_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type,
259: p_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type,
260: p_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type)
261: RETURN PRICING_LINE_REC_TYPE;
262:
255: RETURN PRICING_HEADER_REC_TYPE;
256:
257: FUNCTION Set_Global_Rec (
258: p_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type,
259: p_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type,
260: p_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type)
261: RETURN PRICING_LINE_REC_TYPE;
262:
263:
256:
257: FUNCTION Set_Global_Rec (
258: p_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type,
259: p_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type,
260: p_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type)
261: RETURN PRICING_LINE_REC_TYPE;
262:
263:
264: --wli_start
325: P_Api_Version_Number IN NUMBER,
326: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
327: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
328: p_control_rec IN PRICING_CONTROL_REC_TYPE,
329: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
330: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
331: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
332: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
333: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
326: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
327: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
328: p_control_rec IN PRICING_CONTROL_REC_TYPE,
329: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
330: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
331: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
332: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
333: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
334: p_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
327: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
328: p_control_rec IN PRICING_CONTROL_REC_TYPE,
329: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
330: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
331: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
332: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
333: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
334: p_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
335: p_qte_line_dtl_rec IN ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type
328: p_control_rec IN PRICING_CONTROL_REC_TYPE,
329: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
330: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
331: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
332: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
333: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
334: p_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
335: p_qte_line_dtl_rec IN ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type
336: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Rec,
329: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
330: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
331: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
332: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
333: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
334: p_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
335: p_qte_line_dtl_rec IN ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type
336: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Rec,
337: p_ln_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
330: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
331: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
332: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
333: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
334: p_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
335: p_qte_line_dtl_rec IN ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type
336: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Rec,
337: p_ln_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
338: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
331: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
332: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
333: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
334: p_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
335: p_qte_line_dtl_rec IN ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type
336: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Rec,
337: p_ln_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
338: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
339: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
332: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
333: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
334: p_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
335: p_qte_line_dtl_rec IN ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type
336: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Rec,
337: p_ln_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
338: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
339: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
340: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
333: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
334: p_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
335: p_qte_line_dtl_rec IN ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type
336: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Rec,
337: p_ln_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
338: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
339: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
340: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
341: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
334: p_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
335: p_qte_line_dtl_rec IN ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type
336: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Rec,
337: p_ln_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
338: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
339: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
340: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
341: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
342: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
335: p_qte_line_dtl_rec IN ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type
336: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Rec,
337: p_ln_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
338: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
339: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
340: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
341: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
342: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
343: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
336: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Rec,
337: p_ln_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
338: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
339: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
340: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
341: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
342: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
343: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
344: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
337: p_ln_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
338: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
339: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
340: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
341: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
342: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
343: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
344: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
345: x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
338: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
339: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
340: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
341: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
342: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
343: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
344: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
345: x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
346: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
339: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
340: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
341: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
342: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
343: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
344: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
345: x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
346: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
347: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
340: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
341: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
342: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
343: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
344: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
345: x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
346: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
347: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
348: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
341: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
342: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
343: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
344: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
345: x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
346: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
347: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
348: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
349:
351: P_Api_Version_Number IN NUMBER,
352: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
353: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
354: p_control_rec IN PRICING_CONTROL_REC_TYPE,
355: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
356: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
357: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
358: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
359: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
352: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
353: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
354: p_control_rec IN PRICING_CONTROL_REC_TYPE,
355: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
356: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
357: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
358: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
359: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
360: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
353: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
354: p_control_rec IN PRICING_CONTROL_REC_TYPE,
355: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
356: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
357: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
358: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
359: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
360: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
361: p_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
354: p_control_rec IN PRICING_CONTROL_REC_TYPE,
355: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
356: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
357: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
358: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
359: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
360: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
361: p_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
362: := ASO_QUOTE_PUB.G_Miss_Line_Rltship_Tbl,
355: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
356: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
357: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
358: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
359: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
360: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
361: p_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
362: := ASO_QUOTE_PUB.G_Miss_Line_Rltship_Tbl,
363: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
356: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
357: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
358: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
359: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
360: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
361: p_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
362: := ASO_QUOTE_PUB.G_Miss_Line_Rltship_Tbl,
363: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
364: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl,
357: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
358: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
359: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
360: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
361: p_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
362: := ASO_QUOTE_PUB.G_Miss_Line_Rltship_Tbl,
363: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
364: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl,
365: p_ln_shipment_tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
358: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
359: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
360: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
361: p_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
362: := ASO_QUOTE_PUB.G_Miss_Line_Rltship_Tbl,
363: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
364: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl,
365: p_ln_shipment_tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
366: := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl,
359: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
360: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
361: p_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
362: := ASO_QUOTE_PUB.G_Miss_Line_Rltship_Tbl,
363: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
364: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl,
365: p_ln_shipment_tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
366: := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl,
367: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
360: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
361: p_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
362: := ASO_QUOTE_PUB.G_Miss_Line_Rltship_Tbl,
363: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
364: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl,
365: p_ln_shipment_tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
366: := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl,
367: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
368: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
361: p_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
362: := ASO_QUOTE_PUB.G_Miss_Line_Rltship_Tbl,
363: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
364: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl,
365: p_ln_shipment_tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
366: := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl,
367: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
368: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
369: x_qte_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
362: := ASO_QUOTE_PUB.G_Miss_Line_Rltship_Tbl,
363: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
364: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl,
365: p_ln_shipment_tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
366: := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl,
367: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
368: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
369: x_qte_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
370: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
363: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
364: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl,
365: p_ln_shipment_tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
366: := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl,
367: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
368: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
369: x_qte_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
370: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
371: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
364: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl,
365: p_ln_shipment_tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
366: := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl,
367: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
368: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
369: x_qte_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
370: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
371: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
372: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
365: p_ln_shipment_tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
366: := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl,
367: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
368: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
369: x_qte_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
370: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
371: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
372: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
373: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
366: := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl,
367: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
368: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
369: x_qte_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
370: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
371: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
372: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
373: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
374: x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
367: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
368: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
369: x_qte_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
370: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
371: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
372: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
373: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
374: x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
375: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
368: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
369: x_qte_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
370: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
371: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
372: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
373: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
374: x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
375: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
376: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
369: x_qte_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
370: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
371: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
372: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
373: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
374: x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
375: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
376: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
377: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
370: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
371: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
372: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
373: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
374: x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
375: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
376: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
377: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
378:
390: P_Api_Version_Number IN NUMBER,
391: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
392: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
393: p_control_rec IN PRICING_CONTROL_REC_TYPE,
394: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
395: p_qte_header_id IN NUMBER,
396: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
397: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
398: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
400: Procedure Delete_Promotion (
401: P_Api_Version_Number IN NUMBER,
402: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
403: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
404: p_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
405: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
406: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
407: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
408: