APPS.ASO_PRICING_INT dependencies on ASO_QUOTE_PUB

Line 16: p_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type,

12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'asoiprcb.pls';
13:
14:
15: FUNCTION Set_Global_Rec (
16: p_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type,
17: p_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type)
18: RETURN PRICING_HEADER_REC_TYPE
19: IS
20: BEGIN

Line 17: p_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type)

13:
14:
15: FUNCTION Set_Global_Rec (
16: p_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type,
17: p_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type)
18: RETURN PRICING_HEADER_REC_TYPE
19: IS
20: BEGIN
21:

Line 27: p_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type,

23: p_shipment_rec => p_shipment_rec);
24: END Set_Global_Rec;
25:
26: FUNCTION Set_Global_Rec (
27: p_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type,
28: p_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type,
29: p_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type)
30: RETURN PRICING_LINE_REC_TYPE
31: IS

Line 28: p_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type,

24: END Set_Global_Rec;
25:
26: FUNCTION Set_Global_Rec (
27: p_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type,
28: p_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type,
29: p_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type)
30: RETURN PRICING_LINE_REC_TYPE
31: IS
32: BEGIN

Line 29: p_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type)

25:
26: FUNCTION Set_Global_Rec (
27: p_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type,
28: p_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type,
29: p_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type)
30: RETURN PRICING_LINE_REC_TYPE
31: IS
32: BEGIN
33:

Line 547: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,

543: P_Api_Version_Number IN NUMBER,
544: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
545: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
546: p_control_rec IN PRICING_CONTROL_REC_TYPE,
547: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
548: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
549: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
550: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
551: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,

Line 548: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type

544: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
545: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
546: p_control_rec IN PRICING_CONTROL_REC_TYPE,
547: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
548: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
549: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
550: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
551: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
552: p_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,

Line 549: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,

545: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
546: p_control_rec IN PRICING_CONTROL_REC_TYPE,
547: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
548: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
549: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
550: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
551: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
552: p_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
553: p_qte_line_dtl_rec IN ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type

Line 550: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type

546: p_control_rec IN PRICING_CONTROL_REC_TYPE,
547: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
548: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
549: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
550: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
551: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
552: p_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
553: p_qte_line_dtl_rec IN ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type
554: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Rec,

Line 551: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,

547: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
548: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
549: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
550: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
551: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
552: p_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
553: p_qte_line_dtl_rec IN ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type
554: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Rec,
555: p_ln_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type

Line 552: p_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,

548: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
549: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
550: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
551: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
552: p_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
553: p_qte_line_dtl_rec IN ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type
554: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Rec,
555: p_ln_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
556: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,

Line 553: p_qte_line_dtl_rec IN ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type

549: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
550: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
551: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
552: p_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
553: p_qte_line_dtl_rec IN ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type
554: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Rec,
555: p_ln_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
556: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
557: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type

Line 554: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Rec,

550: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
551: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
552: p_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
553: p_qte_line_dtl_rec IN ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type
554: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Rec,
555: p_ln_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
556: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
557: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
558: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,

Line 555: p_ln_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type

551: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
552: p_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
553: p_qte_line_dtl_rec IN ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type
554: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Rec,
555: p_ln_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
556: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
557: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
558: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
559: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,

Line 556: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,

552: p_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
553: p_qte_line_dtl_rec IN ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type
554: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Rec,
555: p_ln_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
556: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
557: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
558: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
559: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
560: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,

Line 557: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type

553: p_qte_line_dtl_rec IN ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type
554: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Rec,
555: p_ln_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
556: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
557: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
558: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
559: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
560: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
561: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,

Line 558: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,

554: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Rec,
555: p_ln_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
556: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
557: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
558: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
559: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
560: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
561: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
562: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,

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

555: p_ln_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
556: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
557: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
558: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
559: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
560: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
561: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
562: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
563: x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,

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

556: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
557: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
558: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
559: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
560: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
561: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
562: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
563: x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
564: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

557: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
558: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
559: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
560: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
561: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
562: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
563: x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
564: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
565: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

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

558: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
559: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
560: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
561: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
562: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
563: x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
564: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
565: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
566: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)

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

559: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
560: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
561: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
562: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
563: x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
564: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
565: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
566: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
567: IS

Line 927: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,

923: P_Api_Version_Number IN NUMBER,
924: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
925: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
926: p_control_rec IN PRICING_CONTROL_REC_TYPE,
927: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
928: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
929: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
930: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
931: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,

Line 928: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type

924: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
925: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
926: p_control_rec IN PRICING_CONTROL_REC_TYPE,
927: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
928: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
929: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
930: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
931: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
932: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,

Line 929: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,

925: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
926: p_control_rec IN PRICING_CONTROL_REC_TYPE,
927: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
928: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
929: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
930: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
931: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
932: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
933: p_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type

Line 930: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type

926: p_control_rec IN PRICING_CONTROL_REC_TYPE,
927: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
928: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
929: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
930: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
931: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
932: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
933: p_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
934: := ASO_QUOTE_PUB.G_Miss_Line_Rltship_Tbl,

Line 931: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,

927: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
928: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
929: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
930: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
931: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
932: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
933: p_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
934: := ASO_QUOTE_PUB.G_Miss_Line_Rltship_Tbl,
935: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type

Line 932: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,

928: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
929: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
930: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
931: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
932: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
933: p_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
934: := ASO_QUOTE_PUB.G_Miss_Line_Rltship_Tbl,
935: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
936: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl,

Line 933: p_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type

929: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
930: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
931: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
932: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
933: p_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
934: := ASO_QUOTE_PUB.G_Miss_Line_Rltship_Tbl,
935: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
936: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl,
937: p_ln_shipment_tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type

Line 934: := ASO_QUOTE_PUB.G_Miss_Line_Rltship_Tbl,

930: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
931: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
932: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
933: p_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
934: := ASO_QUOTE_PUB.G_Miss_Line_Rltship_Tbl,
935: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
936: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl,
937: p_ln_shipment_tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
938: := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl,

Line 935: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type

931: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
932: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
933: p_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
934: := ASO_QUOTE_PUB.G_Miss_Line_Rltship_Tbl,
935: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
936: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl,
937: p_ln_shipment_tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
938: := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl,
939: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type

Line 936: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl,

932: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
933: p_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
934: := ASO_QUOTE_PUB.G_Miss_Line_Rltship_Tbl,
935: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
936: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl,
937: p_ln_shipment_tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
938: := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl,
939: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
940: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,

Line 937: p_ln_shipment_tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type

933: p_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
934: := ASO_QUOTE_PUB.G_Miss_Line_Rltship_Tbl,
935: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
936: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl,
937: p_ln_shipment_tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
938: := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl,
939: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
940: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
941: x_qte_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,

Line 938: := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl,

934: := ASO_QUOTE_PUB.G_Miss_Line_Rltship_Tbl,
935: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
936: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl,
937: p_ln_shipment_tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
938: := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl,
939: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
940: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
941: x_qte_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
942: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,

Line 939: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type

935: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
936: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl,
937: p_ln_shipment_tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
938: := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl,
939: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
940: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
941: x_qte_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
942: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
943: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,

Line 940: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,

936: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl,
937: p_ln_shipment_tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
938: := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl,
939: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
940: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
941: x_qte_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
942: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
943: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
944: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,

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

937: p_ln_shipment_tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
938: := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl,
939: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
940: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
941: x_qte_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
942: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
943: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
944: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
945: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,

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

938: := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl,
939: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
940: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
941: x_qte_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
942: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
943: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
944: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
945: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
946: x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,

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

939: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
940: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
941: x_qte_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
942: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
943: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
944: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
945: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
946: x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
947: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

940: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
941: x_qte_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
942: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
943: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
944: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
945: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
946: x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
947: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
948: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

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

941: x_qte_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
942: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
943: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
944: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
945: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
946: x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
947: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
948: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
949: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)

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

942: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
943: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
944: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
945: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
946: x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
947: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
948: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
949: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
950: IS

Line 957: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;

953: l_request_type VARCHAR2(60);
954: l_pricing_event VARCHAR2(30);
955: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
956: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
957: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
958:
959: BEGIN
960: -- Standard Start of API savepoint
961: SAVEPOINT PRICING_ORDER_PVT;

Line 1210: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;

1206: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
1207: IS
1208: l_api_name CONSTANT VARCHAR2(30) := 'Pricing_Item';
1209: l_api_version_number CONSTANT NUMBER := 1.0;
1210: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
1211: l_qte_header_id NUMBER;
1212: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1213: l_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1214: l_hd_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;

Line 1212: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;

1208: l_api_name CONSTANT VARCHAR2(30) := 'Pricing_Item';
1209: l_api_version_number CONSTANT NUMBER := 1.0;
1210: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
1211: l_qte_header_id NUMBER;
1212: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1213: l_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1214: l_hd_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1215: l_hd_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1216: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;

Line 1213: l_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

1209: l_api_version_number CONSTANT NUMBER := 1.0;
1210: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
1211: l_qte_header_id NUMBER;
1212: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1213: l_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1214: l_hd_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1215: l_hd_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1216: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
1217: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

Line 1214: l_hd_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;

1210: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
1211: l_qte_header_id NUMBER;
1212: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1213: l_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1214: l_hd_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1215: l_hd_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1216: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
1217: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1218: l_ln_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;

Line 1215: l_hd_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

1211: l_qte_header_id NUMBER;
1212: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1213: l_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1214: l_hd_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1215: l_hd_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1216: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
1217: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1218: l_ln_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1219: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

Line 1216: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;

1212: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1213: l_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1214: l_hd_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1215: l_hd_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1216: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
1217: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1218: l_ln_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1219: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1220: l_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

Line 1217: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

1213: l_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1214: l_hd_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1215: l_hd_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1216: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
1217: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1218: l_ln_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1219: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1220: l_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1221: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;

Line 1218: l_ln_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;

1214: l_hd_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1215: l_hd_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1216: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
1217: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1218: l_ln_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1219: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1220: l_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1221: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1222: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

Line 1219: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

1215: l_hd_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1216: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
1217: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1218: l_ln_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1219: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1220: l_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1221: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1222: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1223: lx_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

Line 1220: l_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

1216: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
1217: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1218: l_ln_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1219: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1220: l_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1221: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1222: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1223: lx_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1224: lx_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;

Line 1221: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;

1217: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1218: l_ln_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1219: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1220: l_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1221: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1222: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1223: lx_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1224: lx_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1225: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;

Line 1222: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

1218: l_ln_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1219: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1220: l_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1221: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1222: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1223: lx_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1224: lx_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1225: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
1226:

Line 1223: lx_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

1219: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1220: l_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1221: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1222: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1223: lx_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1224: lx_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1225: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
1226:
1227: l_price_list_id NUMBER;

Line 1224: lx_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;

1220: l_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1221: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1222: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1223: lx_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1224: lx_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1225: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
1226:
1227: l_price_list_id NUMBER;
1228: l_CURRENCY_CODE VARCHAR2(15);

Line 1225: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;

1221: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1222: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1223: lx_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1224: lx_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1225: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
1226:
1227: l_price_list_id NUMBER;
1228: l_CURRENCY_CODE VARCHAR2(15);
1229:

Line 1413: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,

1409: P_Api_Version_Number IN NUMBER,
1410: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1411: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1412: p_control_rec IN PRICING_CONTROL_REC_TYPE,
1413: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
1414: p_qte_header_id IN NUMBER,
1415: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1416: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
1417: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)

Line 1441: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;

1437: lx_req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
1438: lx_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
1439: lx_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
1440: lx_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
1441: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1442: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1443: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1444: l_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1445: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;

Line 1442: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

1438: lx_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
1439: lx_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
1440: lx_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
1441: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1442: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1443: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1444: l_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1445: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1446: l_qte_line_id NUMBER;

Line 1443: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;

1439: lx_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
1440: lx_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
1441: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1442: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1443: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1444: l_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1445: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1446: l_qte_line_id NUMBER;
1447: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;

Line 1444: l_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

1440: lx_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
1441: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1442: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1443: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1444: l_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1445: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1446: l_qte_line_id NUMBER;
1447: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
1448: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

Line 1445: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;

1441: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1442: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1443: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1444: l_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1445: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1446: l_qte_line_id NUMBER;
1447: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
1448: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1449: l_return_status VARCHAR2(1);

Line 1447: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;

1443: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1444: l_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1445: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1446: l_qte_line_id NUMBER;
1447: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
1448: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1449: l_return_status VARCHAR2(1);
1450: l_return_status_text VARCHAR2(2000);
1451: l_request_type VARCHAR2(60);

Line 1448: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

1444: l_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1445: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1446: l_qte_line_id NUMBER;
1447: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
1448: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1449: l_return_status VARCHAR2(1);
1450: l_return_status_text VARCHAR2(2000);
1451: l_request_type VARCHAR2(60);
1452: l_pricing_event VARCHAR2(30);

Line 1453: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_rec_Type;

1449: l_return_status VARCHAR2(1);
1450: l_return_status_text VARCHAR2(2000);
1451: l_request_type VARCHAR2(60);
1452: l_pricing_event VARCHAR2(30);
1453: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_rec_Type;
1454: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1455: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1456: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1457: lx_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

Line 1454: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;

1450: l_return_status_text VARCHAR2(2000);
1451: l_request_type VARCHAR2(60);
1452: l_pricing_event VARCHAR2(30);
1453: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_rec_Type;
1454: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1455: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1456: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1457: lx_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1458: lx_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;

Line 1455: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;

1451: l_request_type VARCHAR2(60);
1452: l_pricing_event VARCHAR2(30);
1453: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_rec_Type;
1454: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1455: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1456: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1457: lx_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1458: lx_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1459: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;

Line 1456: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

1452: l_pricing_event VARCHAR2(30);
1453: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_rec_Type;
1454: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1455: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1456: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1457: lx_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1458: lx_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1459: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
1460: l_message_text VARCHAR2(2000);

Line 1457: lx_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

1453: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_rec_Type;
1454: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1455: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1456: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1457: lx_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1458: lx_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1459: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
1460: l_message_text VARCHAR2(2000);
1461: i BINARY_INTEGER;

Line 1458: lx_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;

1454: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1455: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1456: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1457: lx_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1458: lx_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1459: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
1460: l_message_text VARCHAR2(2000);
1461: i BINARY_INTEGER;
1462: ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

Line 1459: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;

1455: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1456: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1457: lx_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1458: lx_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1459: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
1460: l_message_text VARCHAR2(2000);
1461: i BINARY_INTEGER;
1462: ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1463: l_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;

Line 1462: ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

1458: lx_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1459: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
1460: l_message_text VARCHAR2(2000);
1461: i BINARY_INTEGER;
1462: ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1463: l_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
1464: l_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1465: lx_return_status VARCHAR2(50);
1466: lx_msg_count NUMBER;

Line 1463: l_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;

1459: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
1460: l_message_text VARCHAR2(2000);
1461: i BINARY_INTEGER;
1462: ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1463: l_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
1464: l_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1465: lx_return_status VARCHAR2(50);
1466: lx_msg_count NUMBER;
1467: lx_msg_data VARCHAR2(2000);

Line 1464: l_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

1460: l_message_text VARCHAR2(2000);
1461: i BINARY_INTEGER;
1462: ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1463: l_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
1464: l_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1465: lx_return_status VARCHAR2(50);
1466: lx_msg_count NUMBER;
1467: lx_msg_data VARCHAR2(2000);
1468:

Line 1583: p_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,

1579: Procedure Delete_Promotion (
1580: P_Api_Version_Number IN NUMBER,
1581: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1582: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1583: p_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
1584: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1585: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
1586: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
1587: IS