DBA Data[Home] [Help]

APPS.ASO_PRICING_INT dependencies on ASO_QUOTE_PUB

Line 253: p_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type,

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 (

Line 254: p_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type)

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,

Line 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:

Line 259: p_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_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:
263:

Line 260: p_shipment_rec ASO_QUOTE_PUB.Shipment_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:
264: --wli_start

Line 329: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,

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,

Line 330: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type

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,

Line 331: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,

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

Line 332: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_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,

Line 333: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,

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

Line 334: p_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_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,

Line 335: p_qte_line_dtl_rec IN ASO_QUOTE_PUB.Qte_Line_Dtl_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,
339: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type

Line 336: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_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
340: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,

Line 337: p_ln_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_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,
341: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,

Line 338: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,

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,

Line 339: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_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,

Line 340: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,

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,

Line 341: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_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,

Line 342: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_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,

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

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,

Line 344: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Attr_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,
348: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);

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

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:

Line 355: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,

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,

Line 356: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type

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,

Line 357: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,

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

Line 358: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_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,

Line 359: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_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

Line 360: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_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,

Line 361: p_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_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,
365: p_ln_shipment_tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type

Line 362: := ASO_QUOTE_PUB.G_Miss_Line_Rltship_Tbl,

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,

Line 363: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_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,
367: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type

Line 364: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_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
368: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,

Line 365: p_ln_shipment_tbl IN ASO_QUOTE_PUB.Shipment_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,
369: x_qte_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,

Line 366: := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl,

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,

Line 367: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_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,

Line 368: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,

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,

Line 369: x_qte_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_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,

Line 370: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_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,

Line 371: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_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,

Line 372: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_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,
376: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

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

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);

Line 374: x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_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);
378:

Line 394: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,

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);

Line 404: p_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,

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: