eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 942: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,

938: P_Api_Version_Number IN NUMBER,
939: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
940: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
941: p_control_rec IN PRICING_CONTROL_REC_TYPE,
942: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
943: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
944: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
945: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
946: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,

Line 943: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type

939: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
940: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
941: p_control_rec IN PRICING_CONTROL_REC_TYPE,
942: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
943: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
944: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
945: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
946: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
947: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,

Line 944: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,

940: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
941: p_control_rec IN PRICING_CONTROL_REC_TYPE,
942: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
943: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
944: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
945: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
946: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
947: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
948: p_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type

Line 945: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type

941: p_control_rec IN PRICING_CONTROL_REC_TYPE,
942: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
943: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
944: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
945: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
946: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
947: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
948: p_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
949: := ASO_QUOTE_PUB.G_Miss_Line_Rltship_Tbl,

Line 946: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,

942: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
943: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
944: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
945: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
946: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
947: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
948: p_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
949: := ASO_QUOTE_PUB.G_Miss_Line_Rltship_Tbl,
950: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type

Line 947: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,

943: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
944: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
945: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
946: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
947: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
948: p_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
949: := ASO_QUOTE_PUB.G_Miss_Line_Rltship_Tbl,
950: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
951: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl,

Line 948: p_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type

944: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
945: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
946: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
947: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
948: p_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
949: := ASO_QUOTE_PUB.G_Miss_Line_Rltship_Tbl,
950: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
951: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl,
952: p_ln_shipment_tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type

Line 949: := ASO_QUOTE_PUB.G_Miss_Line_Rltship_Tbl,

945: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
946: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
947: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
948: p_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
949: := ASO_QUOTE_PUB.G_Miss_Line_Rltship_Tbl,
950: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
951: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl,
952: p_ln_shipment_tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
953: := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl,

Line 950: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type

946: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
947: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
948: p_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
949: := ASO_QUOTE_PUB.G_Miss_Line_Rltship_Tbl,
950: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
951: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl,
952: p_ln_shipment_tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
953: := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl,
954: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type

Line 951: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl,

947: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
948: p_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
949: := ASO_QUOTE_PUB.G_Miss_Line_Rltship_Tbl,
950: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
951: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl,
952: p_ln_shipment_tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
953: := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl,
954: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
955: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,

Line 952: p_ln_shipment_tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type

948: p_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
949: := ASO_QUOTE_PUB.G_Miss_Line_Rltship_Tbl,
950: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
951: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl,
952: p_ln_shipment_tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
953: := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl,
954: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
955: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
956: x_qte_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,

Line 953: := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl,

949: := ASO_QUOTE_PUB.G_Miss_Line_Rltship_Tbl,
950: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
951: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl,
952: p_ln_shipment_tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
953: := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl,
954: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
955: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
956: x_qte_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
957: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,

Line 954: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type

950: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
951: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl,
952: p_ln_shipment_tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
953: := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl,
954: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
955: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
956: x_qte_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
957: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
958: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,

Line 955: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,

951: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl,
952: p_ln_shipment_tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
953: := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl,
954: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
955: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
956: x_qte_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
957: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
958: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
959: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,

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

952: p_ln_shipment_tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
953: := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl,
954: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
955: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
956: x_qte_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
957: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
958: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
959: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
960: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,

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

953: := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl,
954: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
955: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
956: x_qte_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
957: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
958: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
959: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
960: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
961: x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,

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

954: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
955: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
956: x_qte_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
957: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
958: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
959: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
960: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
961: x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
962: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

955: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
956: x_qte_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
957: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
958: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
959: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
960: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
961: x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
962: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
963: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

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

956: x_qte_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
957: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
958: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
959: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
960: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
961: x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
962: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
963: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
964: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)

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

957: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
958: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
959: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
960: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
961: x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
962: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
963: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
964: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
965: IS

Line 972: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;

968: l_request_type VARCHAR2(60);
969: l_pricing_event VARCHAR2(30);
970: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
971: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
972: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
973:
974: BEGIN
975: -- Standard Start of API savepoint
976: SAVEPOINT PRICING_ORDER_PVT;

Line 1225: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;

1221: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
1222: IS
1223: l_api_name CONSTANT VARCHAR2(30) := 'Pricing_Item';
1224: l_api_version_number CONSTANT NUMBER := 1.0;
1225: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
1226: l_qte_header_id NUMBER;
1227: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1228: l_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1229: l_hd_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;

Line 1227: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;

1223: l_api_name CONSTANT VARCHAR2(30) := 'Pricing_Item';
1224: l_api_version_number CONSTANT NUMBER := 1.0;
1225: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
1226: l_qte_header_id NUMBER;
1227: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1228: l_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1229: l_hd_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1230: l_hd_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1231: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;

Line 1228: l_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

1224: l_api_version_number CONSTANT NUMBER := 1.0;
1225: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
1226: l_qte_header_id NUMBER;
1227: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1228: l_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1229: l_hd_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1230: l_hd_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1231: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
1232: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

Line 1229: l_hd_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;

1225: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
1226: l_qte_header_id NUMBER;
1227: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1228: l_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1229: l_hd_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1230: l_hd_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1231: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
1232: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1233: l_ln_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;

Line 1230: l_hd_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

1226: l_qte_header_id NUMBER;
1227: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1228: l_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1229: l_hd_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1230: l_hd_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1231: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
1232: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1233: l_ln_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1234: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

Line 1231: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;

1227: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1228: l_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1229: l_hd_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1230: l_hd_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1231: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
1232: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1233: l_ln_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1234: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1235: l_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

Line 1232: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

1228: l_hd_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1229: l_hd_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1230: l_hd_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1231: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
1232: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1233: l_ln_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1234: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1235: l_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1236: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;

Line 1233: l_ln_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;

1229: l_hd_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1230: l_hd_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1231: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
1232: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1233: l_ln_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1234: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1235: l_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1236: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1237: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

Line 1234: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

1230: l_hd_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1231: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
1232: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1233: l_ln_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1234: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1235: l_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1236: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1237: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1238: lx_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

Line 1235: l_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

1231: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
1232: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1233: l_ln_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1234: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1235: l_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1236: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1237: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1238: lx_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1239: lx_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;

Line 1236: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;

1232: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1233: l_ln_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1234: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1235: l_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1236: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1237: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1238: lx_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1239: lx_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1240: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;

Line 1237: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

1233: l_ln_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1234: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1235: l_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1236: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1237: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1238: lx_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1239: lx_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1240: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
1241:

Line 1238: lx_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

1234: l_ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1235: l_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1236: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1237: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1238: lx_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1239: lx_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1240: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
1241:
1242: l_price_list_id NUMBER;

Line 1239: lx_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;

1235: l_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1236: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1237: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1238: lx_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1239: lx_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1240: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
1241:
1242: l_price_list_id NUMBER;
1243: l_CURRENCY_CODE VARCHAR2(15);

Line 1240: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;

1236: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1237: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1238: lx_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1239: lx_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1240: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
1241:
1242: l_price_list_id NUMBER;
1243: l_CURRENCY_CODE VARCHAR2(15);
1244:

Line 1428: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,

1424: P_Api_Version_Number IN NUMBER,
1425: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1426: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1427: p_control_rec IN PRICING_CONTROL_REC_TYPE,
1428: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
1429: p_qte_header_id IN NUMBER,
1430: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1431: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
1432: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)

Line 1456: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;

1452: lx_req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
1453: lx_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
1454: lx_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
1455: lx_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
1456: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1457: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1458: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1459: l_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1460: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;

Line 1457: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

1453: lx_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
1454: lx_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
1455: lx_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
1456: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1457: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1458: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1459: l_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1460: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1461: l_qte_line_id NUMBER;

Line 1458: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;

1454: lx_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
1455: lx_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
1456: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1457: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1458: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1459: l_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1460: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1461: l_qte_line_id NUMBER;
1462: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;

Line 1459: l_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

1455: lx_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
1456: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1457: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1458: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1459: l_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1460: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1461: l_qte_line_id NUMBER;
1462: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
1463: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

Line 1460: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;

1456: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1457: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1458: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1459: l_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1460: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1461: l_qte_line_id NUMBER;
1462: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
1463: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1464: l_return_status VARCHAR2(1);

Line 1462: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;

1458: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1459: l_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1460: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1461: l_qte_line_id NUMBER;
1462: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
1463: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1464: l_return_status VARCHAR2(1);
1465: l_return_status_text VARCHAR2(2000);
1466: l_request_type VARCHAR2(60);

Line 1463: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

1459: l_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1460: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1461: l_qte_line_id NUMBER;
1462: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
1463: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1464: l_return_status VARCHAR2(1);
1465: l_return_status_text VARCHAR2(2000);
1466: l_request_type VARCHAR2(60);
1467: l_pricing_event VARCHAR2(30);

Line 1468: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_rec_Type;

1464: l_return_status VARCHAR2(1);
1465: l_return_status_text VARCHAR2(2000);
1466: l_request_type VARCHAR2(60);
1467: l_pricing_event VARCHAR2(30);
1468: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_rec_Type;
1469: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1470: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1471: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1472: lx_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

Line 1469: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;

1465: l_return_status_text VARCHAR2(2000);
1466: l_request_type VARCHAR2(60);
1467: l_pricing_event VARCHAR2(30);
1468: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_rec_Type;
1469: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1470: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1471: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1472: lx_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1473: lx_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;

Line 1470: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;

1466: l_request_type VARCHAR2(60);
1467: l_pricing_event VARCHAR2(30);
1468: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_rec_Type;
1469: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1470: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1471: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1472: lx_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1473: lx_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1474: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;

Line 1471: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

1467: l_pricing_event VARCHAR2(30);
1468: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_rec_Type;
1469: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1470: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1471: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1472: lx_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1473: lx_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1474: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
1475: l_message_text VARCHAR2(2000);

Line 1472: lx_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

1468: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_rec_Type;
1469: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1470: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1471: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1472: lx_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1473: lx_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1474: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
1475: l_message_text VARCHAR2(2000);
1476: i BINARY_INTEGER;

Line 1473: lx_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;

1469: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1470: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1471: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1472: lx_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1473: lx_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1474: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
1475: l_message_text VARCHAR2(2000);
1476: i BINARY_INTEGER;
1477: ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

Line 1474: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;

1470: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1471: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1472: lx_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1473: lx_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1474: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
1475: l_message_text VARCHAR2(2000);
1476: i BINARY_INTEGER;
1477: ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1478: l_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;

Line 1477: ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

1473: lx_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1474: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
1475: l_message_text VARCHAR2(2000);
1476: i BINARY_INTEGER;
1477: ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1478: l_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
1479: l_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1480: lx_return_status VARCHAR2(50);
1481: lx_msg_count NUMBER;

Line 1478: l_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;

1474: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
1475: l_message_text VARCHAR2(2000);
1476: i BINARY_INTEGER;
1477: ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1478: l_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
1479: l_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1480: lx_return_status VARCHAR2(50);
1481: lx_msg_count NUMBER;
1482: lx_msg_data VARCHAR2(2000);

Line 1479: l_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

1475: l_message_text VARCHAR2(2000);
1476: i BINARY_INTEGER;
1477: ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1478: l_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
1479: l_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1480: lx_return_status VARCHAR2(50);
1481: lx_msg_count NUMBER;
1482: lx_msg_data VARCHAR2(2000);
1483:

Line 1598: p_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,

1594: Procedure Delete_Promotion (
1595: P_Api_Version_Number IN NUMBER,
1596: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1597: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1598: p_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
1599: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1600: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
1601: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
1602: IS