APPS.ASO_PRICING_CALLBACK_PVT dependencies on ASO_QUOTE_PUB

Line 20: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,

16: P_Api_Version_Number IN NUMBER,
17: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
18: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
19: p_control_rec IN ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE,
20: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
21: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
22: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
23: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
24: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,

Line 21: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type

17: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
18: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
19: p_control_rec IN ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE,
20: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
21: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
22: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
23: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
24: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
25: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,

Line 22: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,

18: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
19: p_control_rec IN ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE,
20: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
21: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
22: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
23: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
24: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
25: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
26: p_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type

Line 23: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type

19: p_control_rec IN ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE,
20: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
21: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
22: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
23: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
24: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
25: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
26: p_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
27: := ASO_QUOTE_PUB.G_Miss_Line_Rltship_Tbl,

Line 24: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,

20: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
21: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
22: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
23: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
24: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
25: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
26: p_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
27: := ASO_QUOTE_PUB.G_Miss_Line_Rltship_Tbl,
28: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type

Line 25: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,

21: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
22: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
23: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
24: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
25: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
26: p_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
27: := ASO_QUOTE_PUB.G_Miss_Line_Rltship_Tbl,
28: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
29: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl,

Line 26: p_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type

22: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
23: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
24: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
25: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
26: p_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
27: := ASO_QUOTE_PUB.G_Miss_Line_Rltship_Tbl,
28: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
29: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl,
30: p_ln_shipment_tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type

Line 27: := ASO_QUOTE_PUB.G_Miss_Line_Rltship_Tbl,

23: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
24: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
25: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
26: p_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
27: := ASO_QUOTE_PUB.G_Miss_Line_Rltship_Tbl,
28: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
29: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl,
30: p_ln_shipment_tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
31: := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl,

Line 28: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type

24: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
25: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
26: p_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
27: := ASO_QUOTE_PUB.G_Miss_Line_Rltship_Tbl,
28: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
29: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl,
30: p_ln_shipment_tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
31: := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl,
32: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type

Line 29: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl,

25: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
26: p_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
27: := ASO_QUOTE_PUB.G_Miss_Line_Rltship_Tbl,
28: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
29: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl,
30: p_ln_shipment_tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
31: := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl,
32: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
33: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,

Line 30: p_ln_shipment_tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type

26: p_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
27: := ASO_QUOTE_PUB.G_Miss_Line_Rltship_Tbl,
28: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
29: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl,
30: p_ln_shipment_tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
31: := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl,
32: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
33: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
34: x_qte_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,

Line 31: := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl,

27: := ASO_QUOTE_PUB.G_Miss_Line_Rltship_Tbl,
28: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
29: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl,
30: p_ln_shipment_tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
31: := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl,
32: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
33: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
34: x_qte_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
35: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,

Line 32: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type

28: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
29: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl,
30: p_ln_shipment_tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
31: := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl,
32: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
33: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
34: x_qte_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
35: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
36: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,

Line 33: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,

29: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl,
30: p_ln_shipment_tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
31: := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl,
32: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
33: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
34: x_qte_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
35: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
36: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
37: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,

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

30: p_ln_shipment_tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
31: := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl,
32: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
33: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
34: x_qte_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
35: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
36: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
37: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
38: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,

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

31: := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl,
32: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
33: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
34: x_qte_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
35: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
36: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
37: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
38: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
39: x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,

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

32: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
33: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
34: x_qte_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
35: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
36: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
37: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
38: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
39: x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
40: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

33: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
34: x_qte_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
35: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
36: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
37: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
38: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
39: x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
40: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
41: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

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

34: x_qte_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
35: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
36: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
37: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
38: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
39: x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
40: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
41: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
42: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)

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

35: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
36: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
37: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
38: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
39: x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
40: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
41: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
42: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
43: IS

Line 69: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;

65: lx_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
66: lx_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
67: lx_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
68: l_qte_line_id NUMBER;
69: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
70: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
71: l_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
72: l_qte_line_prcd Index_Link_Tbl_Type;
73: l_return_status VARCHAR2(1);

Line 70: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;

66: lx_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
67: lx_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
68: l_qte_line_id NUMBER;
69: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
70: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
71: l_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
72: l_qte_line_prcd Index_Link_Tbl_Type;
73: l_return_status VARCHAR2(1);
74: lv_return_status VARCHAR2(1);

Line 71: l_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

67: lx_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
68: l_qte_line_id NUMBER;
69: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
70: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
71: l_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
72: l_qte_line_prcd Index_Link_Tbl_Type;
73: l_return_status VARCHAR2(1);
74: lv_return_status VARCHAR2(1);
75: l_return_status_text VARCHAR2(2000);

Line 80: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;

76: l_message_text VARCHAR2(2000);
77: lx_req_line_rec QP_PREQ_GRP.LINE_REC_TYPE;
78: i BINARY_INTEGER;
79: j BINARY_INTEGER;
80: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
81: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
82: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
83: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
84: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

Line 81: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;

77: lx_req_line_rec QP_PREQ_GRP.LINE_REC_TYPE;
78: i BINARY_INTEGER;
79: j BINARY_INTEGER;
80: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
81: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
82: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
83: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
84: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
85: l_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

Line 82: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

78: i BINARY_INTEGER;
79: j BINARY_INTEGER;
80: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
81: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
82: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
83: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
84: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
85: l_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
86: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;

Line 83: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;

79: j BINARY_INTEGER;
80: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
81: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
82: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
83: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
84: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
85: l_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
86: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
87: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

Line 84: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

80: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
81: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
82: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
83: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
84: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
85: l_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
86: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
87: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
88: lx_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

Line 85: l_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

81: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
82: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
83: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
84: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
85: l_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
86: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
87: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
88: lx_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
89: lx_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;

Line 86: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;

82: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
83: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
84: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
85: l_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
86: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
87: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
88: lx_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
89: lx_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
90: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;

Line 87: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

83: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
84: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
85: l_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
86: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
87: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
88: lx_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
89: lx_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
90: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
91: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_rec_Type;

Line 88: lx_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

84: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
85: l_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
86: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
87: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
88: lx_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
89: lx_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
90: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
91: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_rec_Type;
92: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

Line 89: lx_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;

85: l_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
86: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
87: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
88: lx_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
89: lx_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
90: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
91: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_rec_Type;
92: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
93: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

Line 90: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;

86: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
87: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
88: lx_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
89: lx_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
90: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
91: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_rec_Type;
92: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
93: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
94:

Line 91: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_rec_Type;

87: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
88: lx_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
89: lx_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
90: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
91: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_rec_Type;
92: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
93: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
94:
95: BEGIN

Line 192: l_qte_line_dtl_rec := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_REC ;

188: OR l_qte_line_tbl(i).price_list_id= FND_API.G_MISS_NUM) Then
189: l_qte_line_tbl(i).price_list_id := p_qte_header_rec.price_list_id;
190: End if;
191:
192: l_qte_line_dtl_rec := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_REC ;
193: IF l_qte_line_dtl_tbl.count = 1 THEN
194: l_qte_line_dtl_rec := l_qte_line_dtl_tbl(1);
195: END IF;
196:

Line 372: p_qte_line_dtl_tbl => ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl,

368: p_req_line_detail_attr_tbl => lx_req_line_detail_attr_tbl,
369: p_req_related_lines_tbl => lx_req_related_lines_tbl,
370: p_qte_header_rec => p_qte_header_rec,
371: p_qte_line_tbl => l_qte_line_tbl,
372: p_qte_line_dtl_tbl => ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl,
373: x_qte_header_rec => lx_qte_header_rec,
374: x_qte_line_tbl => lx_qte_line_tbl,
375: x_qte_line_dtl_tbl => lx_qte_line_dtl_tbl,
376: x_price_adj_tbl => lx_price_adj_tbl,

Line 460: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,

456: P_Api_Version_Number IN NUMBER,
457: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
458: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
459: p_control_rec IN ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE,
460: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
461: p_qte_header_id IN NUMBER,
462: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
463: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
464: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)

Line 488: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;

484: lx_req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
485: lx_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
486: lx_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
487: lx_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
488: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
489: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
490: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
491: l_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
492: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;

Line 489: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

485: lx_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
486: lx_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
487: lx_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
488: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
489: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
490: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
491: l_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
492: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
493: l_qte_line_id NUMBER;

Line 490: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;

486: lx_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
487: lx_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
488: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
489: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
490: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
491: l_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
492: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
493: l_qte_line_id NUMBER;
494: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;

Line 491: l_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

487: lx_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
488: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
489: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
490: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
491: l_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
492: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
493: l_qte_line_id NUMBER;
494: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
495: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

Line 492: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;

488: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
489: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
490: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
491: l_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
492: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
493: l_qte_line_id NUMBER;
494: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
495: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
496: l_return_status VARCHAR2(1);

Line 494: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;

490: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
491: l_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
492: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
493: l_qte_line_id NUMBER;
494: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
495: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
496: l_return_status VARCHAR2(1);
497: l_return_status_text VARCHAR2(2000);
498: l_request_type VARCHAR2(60);

Line 495: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

491: l_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
492: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
493: l_qte_line_id NUMBER;
494: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
495: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
496: l_return_status VARCHAR2(1);
497: l_return_status_text VARCHAR2(2000);
498: l_request_type VARCHAR2(60);
499: l_pricing_event VARCHAR2(30);

Line 500: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_rec_Type;

496: l_return_status VARCHAR2(1);
497: l_return_status_text VARCHAR2(2000);
498: l_request_type VARCHAR2(60);
499: l_pricing_event VARCHAR2(30);
500: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_rec_Type;
501: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
502: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
503: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
504: lx_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

Line 501: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;

497: l_return_status_text VARCHAR2(2000);
498: l_request_type VARCHAR2(60);
499: l_pricing_event VARCHAR2(30);
500: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_rec_Type;
501: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
502: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
503: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
504: lx_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
505: lx_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;

Line 502: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;

498: l_request_type VARCHAR2(60);
499: l_pricing_event VARCHAR2(30);
500: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_rec_Type;
501: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
502: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
503: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
504: lx_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
505: lx_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
506: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;

Line 503: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

499: l_pricing_event VARCHAR2(30);
500: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_rec_Type;
501: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
502: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
503: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
504: lx_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
505: lx_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
506: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
507:

Line 504: lx_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

500: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_rec_Type;
501: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
502: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
503: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
504: lx_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
505: lx_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
506: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
507:
508: l_qte_line_prcd Index_Link_Tbl_Type;

Line 505: lx_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;

501: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
502: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
503: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
504: lx_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
505: lx_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
506: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
507:
508: l_qte_line_prcd Index_Link_Tbl_Type;
509: l_message_text VARCHAR2(2000);

Line 506: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;

502: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
503: lx_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
504: lx_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
505: lx_price_adj_attr_tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
506: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
507:
508: l_qte_line_prcd Index_Link_Tbl_Type;
509: l_message_text VARCHAR2(2000);
510: lx_req_line_rec QP_PREQ_GRP.LINE_REC_TYPE;

Line 512: ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

508: l_qte_line_prcd Index_Link_Tbl_Type;
509: l_message_text VARCHAR2(2000);
510: lx_req_line_rec QP_PREQ_GRP.LINE_REC_TYPE;
511: i BINARY_INTEGER;
512: ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
513: l_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
514: l_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
515: l_hd_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
516: lx_return_status VARCHAR2(50);

Line 513: l_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;

509: l_message_text VARCHAR2(2000);
510: lx_req_line_rec QP_PREQ_GRP.LINE_REC_TYPE;
511: i BINARY_INTEGER;
512: ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
513: l_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
514: l_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
515: l_hd_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
516: lx_return_status VARCHAR2(50);
517: lx_msg_count NUMBER;

Line 514: l_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

510: lx_req_line_rec QP_PREQ_GRP.LINE_REC_TYPE;
511: i BINARY_INTEGER;
512: ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
513: l_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
514: l_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
515: l_hd_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
516: lx_return_status VARCHAR2(50);
517: lx_msg_count NUMBER;
518: lx_msg_data VARCHAR2(2000);

Line 515: l_hd_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;

511: i BINARY_INTEGER;
512: ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
513: l_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
514: l_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
515: l_hd_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
516: lx_return_status VARCHAR2(50);
517: lx_msg_count NUMBER;
518: lx_msg_data VARCHAR2(2000);
519:

Line 1677: p_pricing_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,

1673:
1674:
1675: procedure Append_asked_for(
1676: p_line_index NUMBER,
1677: p_pricing_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
1678: px_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
1679: px_Req_qual_tbl IN OUT NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.QUAL_TBL_TYPE)
1680: IS
1681: i NUMBER;

Line 1683: l_pricing_attr_rec ASO_QUOTE_PUB.Price_Attributes_Rec_Type;

1679: px_Req_qual_tbl IN OUT NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.QUAL_TBL_TYPE)
1680: IS
1681: i NUMBER;
1682: l_price_list_id NUMBER;
1683: l_pricing_attr_rec ASO_QUOTE_PUB.Price_Attributes_Rec_Type;
1684: BEGIN
1685: FOR j IN 1..p_pricing_attr_tbl.count LOOP
1686: l_pricing_attr_rec := p_pricing_attr_tbl(j);
1687: IF l_pricing_attr_rec.flex_title = 'QP_ATTR_DEFNS_PRICING' THEN

Line 2534: p_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type,

2530:
2531: procedure copy_Header_to_request(
2532: p_Request_Type VARCHAR2,
2533: p_pricing_event VARCHAR2,
2534: p_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type,
2535: px_req_line_tbl IN OUT NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.LINE_TBL_TYPE)
2536: IS
2537: BEGIN
2538: px_req_line_tbl(1).REQUEST_TYPE_CODE := p_Request_Type;

Line 2567: p_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type,

2563:
2564: procedure copy_Line_to_request(
2565: p_Request_Type VARCHAR2,
2566: p_pricing_event VARCHAR2,
2567: p_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type,
2568: p_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type,
2569: p_control_rec IN ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE,
2570: px_req_line_tbl IN OUT NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.LINE_TBL_TYPE)
2571: is

Line 2568: p_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type,

2564: procedure copy_Line_to_request(
2565: p_Request_Type VARCHAR2,
2566: p_pricing_event VARCHAR2,
2567: p_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type,
2568: p_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type,
2569: p_control_rec IN ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE,
2570: px_req_line_tbl IN OUT NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.LINE_TBL_TYPE)
2571: is
2572: l_req_line_rec QP_PREQ_GRP.LINE_REC_TYPE;

Line 2656: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,

2652: p_req_line_detail_tbl IN QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
2653: p_req_line_detail_qual_tbl IN QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
2654: p_req_line_detail_attr_tbl IN QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
2655: p_req_related_lines_tbl IN QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
2656: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
2657: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
2658: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
2659: x_qte_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
2660: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,

Line 2657: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,

2653: p_req_line_detail_qual_tbl IN QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
2654: p_req_line_detail_attr_tbl IN QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
2655: p_req_related_lines_tbl IN QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
2656: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
2657: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
2658: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
2659: x_qte_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
2660: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
2661: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,

Line 2658: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,

2654: p_req_line_detail_attr_tbl IN QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
2655: p_req_related_lines_tbl IN QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
2656: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
2657: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
2658: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
2659: x_qte_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
2660: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
2661: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
2662: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,

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

2655: p_req_related_lines_tbl IN QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
2656: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
2657: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
2658: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
2659: x_qte_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
2660: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
2661: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
2662: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
2663: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Tbl_Type,

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

2656: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
2657: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
2658: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
2659: x_qte_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
2660: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
2661: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
2662: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
2663: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Tbl_Type,
2664: x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type)

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

2657: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
2658: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
2659: x_qte_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
2660: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
2661: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
2662: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
2663: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Tbl_Type,
2664: x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type)
2665: IS

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

2658: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
2659: x_qte_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
2660: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
2661: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
2662: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
2663: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Tbl_Type,
2664: x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type)
2665: IS
2666: l_index NUMBER;

Line 2663: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Tbl_Type,

2659: x_qte_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
2660: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
2661: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
2662: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
2663: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Tbl_Type,
2664: x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type)
2665: IS
2666: l_index NUMBER;
2667: l_req_line_rec QP_PREQ_GRP.LINE_REC_TYPE;

Line 2664: x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type)

2660: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
2661: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
2662: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
2663: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Tbl_Type,
2664: x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type)
2665: IS
2666: l_index NUMBER;
2667: l_req_line_rec QP_PREQ_GRP.LINE_REC_TYPE;
2668: l_req_line_dtl_rec QP_PREQ_GRP.LINE_DETAIL_REC_TYPE;

Line 2669: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;

2665: IS
2666: l_index NUMBER;
2667: l_req_line_rec QP_PREQ_GRP.LINE_REC_TYPE;
2668: l_req_line_dtl_rec QP_PREQ_GRP.LINE_DETAIL_REC_TYPE;
2669: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
2670: i BINARY_INTEGER;
2671: j BINARY_INTEGER;
2672: l_base_price NUMBER := FND_API.G_MISS_NUM;
2673: l_price_adj_rltship_rec ASO_QUOTE_PUB.Price_Adj_Rltship_Rec_Type;

Line 2673: l_price_adj_rltship_rec ASO_QUOTE_PUB.Price_Adj_Rltship_Rec_Type;

2669: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
2670: i BINARY_INTEGER;
2671: j BINARY_INTEGER;
2672: l_base_price NUMBER := FND_API.G_MISS_NUM;
2673: l_price_adj_rltship_rec ASO_QUOTE_PUB.Price_Adj_Rltship_Rec_Type;
2674: l_qte_line_prcd Index_Link_Tbl_Type;
2675: l_price_adj_prcd Index_Link_Tbl_Type;
2676: lx_price_adj_prcd Index_Link_Tbl_Type;
2677: l_message_text VARCHAR2(2000);

Line 2882: p_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,

2878:
2879:
2880: PROCEDURE Copy_Req_Dtl_To_Price_Adj (
2881: p_qte_line_index IN NUMBER,
2882: p_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
2883: p_req_line_dtl_index IN NUMBER,
2884: p_req_line_detail_rec IN QP_PREQ_GRP.LINE_DETAIL_REC_TYPE,
2885: p_req_line_detail_qual_tbl IN QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
2886: p_req_line_detail_attr_tbl IN QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,

Line 2887: px_price_adj_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,

2883: p_req_line_dtl_index IN NUMBER,
2884: p_req_line_detail_rec IN QP_PREQ_GRP.LINE_DETAIL_REC_TYPE,
2885: p_req_line_detail_qual_tbl IN QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
2886: p_req_line_detail_attr_tbl IN QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
2887: px_price_adj_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
2888: px_price_adj_attr_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Tbl_Type,
2889: px_price_adj_prcd IN OUT NOCOPY /* file.sql.39 change */ Index_Link_Tbl_Type)
2890: IS
2891: l_price_adj_rec ASO_QUOTE_PUB.Price_Adj_Rec_Type;

Line 2888: px_price_adj_attr_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Tbl_Type,

2884: p_req_line_detail_rec IN QP_PREQ_GRP.LINE_DETAIL_REC_TYPE,
2885: p_req_line_detail_qual_tbl IN QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
2886: p_req_line_detail_attr_tbl IN QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
2887: px_price_adj_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
2888: px_price_adj_attr_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Tbl_Type,
2889: px_price_adj_prcd IN OUT NOCOPY /* file.sql.39 change */ Index_Link_Tbl_Type)
2890: IS
2891: l_price_adj_rec ASO_QUOTE_PUB.Price_Adj_Rec_Type;
2892: l_price_adj_attr_rec ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Rec_Type;

Line 2891: l_price_adj_rec ASO_QUOTE_PUB.Price_Adj_Rec_Type;

2887: px_price_adj_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
2888: px_price_adj_attr_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Tbl_Type,
2889: px_price_adj_prcd IN OUT NOCOPY /* file.sql.39 change */ Index_Link_Tbl_Type)
2890: IS
2891: l_price_adj_rec ASO_QUOTE_PUB.Price_Adj_Rec_Type;
2892: l_price_adj_attr_rec ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Rec_Type;
2893: i BINARY_INTEGER;
2894: BEGIN
2895: l_price_adj_rec.operation_code := 'CREATE';

Line 2892: l_price_adj_attr_rec ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Rec_Type;

2888: px_price_adj_attr_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Tbl_Type,
2889: px_price_adj_prcd IN OUT NOCOPY /* file.sql.39 change */ Index_Link_Tbl_Type)
2890: IS
2891: l_price_adj_rec ASO_QUOTE_PUB.Price_Adj_Rec_Type;
2892: l_price_adj_attr_rec ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Rec_Type;
2893: i BINARY_INTEGER;
2894: BEGIN
2895: l_price_adj_rec.operation_code := 'CREATE';
2896: l_price_adj_rec.quote_header_id := p_qte_line_rec.quote_header_id;

Line 2994: p_qte_header_rec IN ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE,

2990: END LOOP;
2991: END Copy_Req_Dtl_To_Price_Adj;
2992:
2993: PROCEDURE Copy_Req_Dtl_To_Price_Adj (
2994: p_qte_header_rec IN ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE,
2995: p_req_line_dtl_index IN NUMBER,
2996: p_req_line_detail_rec IN QP_PREQ_GRP.LINE_DETAIL_REC_TYPE,
2997: p_req_line_detail_qual_tbl IN QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
2998: p_req_line_detail_attr_tbl IN QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,

Line 2999: px_price_adj_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,

2995: p_req_line_dtl_index IN NUMBER,
2996: p_req_line_detail_rec IN QP_PREQ_GRP.LINE_DETAIL_REC_TYPE,
2997: p_req_line_detail_qual_tbl IN QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
2998: p_req_line_detail_attr_tbl IN QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
2999: px_price_adj_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
3000: px_price_adj_attr_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Tbl_Type,
3001: px_price_adj_prcd IN OUT NOCOPY /* file.sql.39 change */ Index_Link_Tbl_Type)
3002: IS
3003: l_price_adj_rec ASO_QUOTE_PUB.Price_Adj_Rec_Type;

Line 3000: px_price_adj_attr_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Tbl_Type,

2996: p_req_line_detail_rec IN QP_PREQ_GRP.LINE_DETAIL_REC_TYPE,
2997: p_req_line_detail_qual_tbl IN QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
2998: p_req_line_detail_attr_tbl IN QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
2999: px_price_adj_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
3000: px_price_adj_attr_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Tbl_Type,
3001: px_price_adj_prcd IN OUT NOCOPY /* file.sql.39 change */ Index_Link_Tbl_Type)
3002: IS
3003: l_price_adj_rec ASO_QUOTE_PUB.Price_Adj_Rec_Type;
3004: l_price_adj_attr_rec ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Rec_Type;

Line 3003: l_price_adj_rec ASO_QUOTE_PUB.Price_Adj_Rec_Type;

2999: px_price_adj_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
3000: px_price_adj_attr_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Tbl_Type,
3001: px_price_adj_prcd IN OUT NOCOPY /* file.sql.39 change */ Index_Link_Tbl_Type)
3002: IS
3003: l_price_adj_rec ASO_QUOTE_PUB.Price_Adj_Rec_Type;
3004: l_price_adj_attr_rec ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Rec_Type;
3005: i BINARY_INTEGER;
3006: BEGIN
3007: l_price_adj_rec.operation_code := 'CREATE';

Line 3004: l_price_adj_attr_rec ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Rec_Type;

3000: px_price_adj_attr_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Tbl_Type,
3001: px_price_adj_prcd IN OUT NOCOPY /* file.sql.39 change */ Index_Link_Tbl_Type)
3002: IS
3003: l_price_adj_rec ASO_QUOTE_PUB.Price_Adj_Rec_Type;
3004: l_price_adj_attr_rec ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Rec_Type;
3005: i BINARY_INTEGER;
3006: BEGIN
3007: l_price_adj_rec.operation_code := 'CREATE';
3008: l_price_adj_rec.quote_header_id := p_qte_header_rec.quote_header_id;

Line 3105: p_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,

3101: p_req_line_detail_tbl IN QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
3102: p_req_line_detail_qual_tbl IN QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
3103: p_req_line_detail_attr_tbl IN QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
3104: p_req_related_lines_tbl IN QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
3105: p_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
3106: p_qte_line_dtl_rec IN ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type,
3107: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
3108: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
3109: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,

Line 3106: p_qte_line_dtl_rec IN ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type,

3102: p_req_line_detail_qual_tbl IN QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
3103: p_req_line_detail_attr_tbl IN QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
3104: p_req_related_lines_tbl IN QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
3105: p_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
3106: p_qte_line_dtl_rec IN ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type,
3107: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
3108: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
3109: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
3110: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Tbl_Type,

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

3103: p_req_line_detail_attr_tbl IN QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
3104: p_req_related_lines_tbl IN QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
3105: p_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
3106: p_qte_line_dtl_rec IN ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type,
3107: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
3108: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
3109: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
3110: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Tbl_Type,
3111: x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type)

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

3104: p_req_related_lines_tbl IN QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
3105: p_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
3106: p_qte_line_dtl_rec IN ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type,
3107: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
3108: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
3109: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
3110: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Tbl_Type,
3111: x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type)
3112: IS

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

3105: p_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
3106: p_qte_line_dtl_rec IN ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type,
3107: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
3108: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
3109: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
3110: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Tbl_Type,
3111: x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type)
3112: IS
3113: l_index NUMBER;

Line 3110: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Tbl_Type,

3106: p_qte_line_dtl_rec IN ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type,
3107: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
3108: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
3109: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
3110: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Tbl_Type,
3111: x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type)
3112: IS
3113: l_index NUMBER;
3114: l_req_line_rec QP_PREQ_GRP.LINE_REC_TYPE;

Line 3111: x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type)

3107: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
3108: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
3109: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
3110: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Tbl_Type,
3111: x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type)
3112: IS
3113: l_index NUMBER;
3114: l_req_line_rec QP_PREQ_GRP.LINE_REC_TYPE;
3115: l_req_line_dtl_rec QP_PREQ_GRP.LINE_DETAIL_REC_TYPE;

Line 3116: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;

3112: IS
3113: l_index NUMBER;
3114: l_req_line_rec QP_PREQ_GRP.LINE_REC_TYPE;
3115: l_req_line_dtl_rec QP_PREQ_GRP.LINE_DETAIL_REC_TYPE;
3116: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
3117: i BINARY_INTEGER;
3118: j BINARY_INTEGER;
3119: l_base_price NUMBER := FND_API.G_MISS_NUM;
3120: l_price_adj_rltship_rec ASO_QUOTE_PUB.Price_Adj_Rltship_Rec_Type;

Line 3120: l_price_adj_rltship_rec ASO_QUOTE_PUB.Price_Adj_Rltship_Rec_Type;

3116: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
3117: i BINARY_INTEGER;
3118: j BINARY_INTEGER;
3119: l_base_price NUMBER := FND_API.G_MISS_NUM;
3120: l_price_adj_rltship_rec ASO_QUOTE_PUB.Price_Adj_Rltship_Rec_Type;
3121: l_qte_line_prcd Index_Link_Tbl_Type;
3122: l_price_adj_prcd Index_Link_Tbl_Type;
3123: l_message_text VARCHAR2(2000);
3124: BEGIN

Line 3224: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type

3220: END Copy_Request_To_Line;
3221:
3222:
3223: PROCEDURE Update_Quote_Rows(
3224: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
3225: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
3226: P_Qte_Line_Dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_tbl_Type
3227: := ASO_QUOTE_PUB.G_MISS_qte_line_dtl_tbl,
3228: P_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type

Line 3225: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,

3221:
3222:
3223: PROCEDURE Update_Quote_Rows(
3224: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
3225: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
3226: P_Qte_Line_Dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_tbl_Type
3227: := ASO_QUOTE_PUB.G_MISS_qte_line_dtl_tbl,
3228: P_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
3229: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,

Line 3226: P_Qte_Line_Dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_tbl_Type

3222:
3223: PROCEDURE Update_Quote_Rows(
3224: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
3225: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
3226: P_Qte_Line_Dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_tbl_Type
3227: := ASO_QUOTE_PUB.G_MISS_qte_line_dtl_tbl,
3228: P_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
3229: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
3230: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type

Line 3227: := ASO_QUOTE_PUB.G_MISS_qte_line_dtl_tbl,

3223: PROCEDURE Update_Quote_Rows(
3224: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
3225: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
3226: P_Qte_Line_Dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_tbl_Type
3227: := ASO_QUOTE_PUB.G_MISS_qte_line_dtl_tbl,
3228: P_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
3229: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
3230: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
3231: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,

Line 3228: P_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type

3224: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
3225: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
3226: P_Qte_Line_Dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_tbl_Type
3227: := ASO_QUOTE_PUB.G_MISS_qte_line_dtl_tbl,
3228: P_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
3229: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
3230: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
3231: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
3232: P_Price_Adj_Rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type

Line 3229: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,

3225: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
3226: P_Qte_Line_Dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_tbl_Type
3227: := ASO_QUOTE_PUB.G_MISS_qte_line_dtl_tbl,
3228: P_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
3229: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
3230: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
3231: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
3232: P_Price_Adj_Rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
3233: := ASO_QUOTE_PUB.G_Miss_Price_Adj_Rltship_Tbl)

Line 3230: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type

3226: P_Qte_Line_Dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_tbl_Type
3227: := ASO_QUOTE_PUB.G_MISS_qte_line_dtl_tbl,
3228: P_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
3229: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
3230: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
3231: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
3232: P_Price_Adj_Rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
3233: := ASO_QUOTE_PUB.G_Miss_Price_Adj_Rltship_Tbl)
3234: IS

Line 3231: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,

3227: := ASO_QUOTE_PUB.G_MISS_qte_line_dtl_tbl,
3228: P_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
3229: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
3230: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
3231: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
3232: P_Price_Adj_Rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
3233: := ASO_QUOTE_PUB.G_Miss_Price_Adj_Rltship_Tbl)
3234: IS
3235: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

Line 3232: P_Price_Adj_Rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type

3228: P_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
3229: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
3230: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
3231: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
3232: P_Price_Adj_Rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
3233: := ASO_QUOTE_PUB.G_Miss_Price_Adj_Rltship_Tbl)
3234: IS
3235: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
3236: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

Line 3233: := ASO_QUOTE_PUB.G_Miss_Price_Adj_Rltship_Tbl)

3229: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
3230: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
3231: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
3232: P_Price_Adj_Rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
3233: := ASO_QUOTE_PUB.G_Miss_Price_Adj_Rltship_Tbl)
3234: IS
3235: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
3236: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
3237: l_Qte_Line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;

Line 3237: l_Qte_Line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;

3233: := ASO_QUOTE_PUB.G_Miss_Price_Adj_Rltship_Tbl)
3234: IS
3235: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
3236: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
3237: l_Qte_Line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
3238: l_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type
3239: := P_Price_Adj_Tbl;
3240: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
3241: := P_Price_Adj_Attr_Tbl;

Line 3238: l_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type

3234: IS
3235: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
3236: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
3237: l_Qte_Line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
3238: l_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type
3239: := P_Price_Adj_Tbl;
3240: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
3241: := P_Price_Adj_Attr_Tbl;
3242: l_Price_Adj_Rltship_Tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type

Line 3240: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type

3236: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
3237: l_Qte_Line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
3238: l_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type
3239: := P_Price_Adj_Tbl;
3240: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
3241: := P_Price_Adj_Attr_Tbl;
3242: l_Price_Adj_Rltship_Tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
3243: := P_Price_Adj_Rltship_Tbl;
3244: l_price_adj_rec ASO_QUOTE_PUB.Price_Adj_Rec_Type;

Line 3242: l_Price_Adj_Rltship_Tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type

3238: l_price_adj_tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type
3239: := P_Price_Adj_Tbl;
3240: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
3241: := P_Price_Adj_Attr_Tbl;
3242: l_Price_Adj_Rltship_Tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
3243: := P_Price_Adj_Rltship_Tbl;
3244: l_price_adj_rec ASO_QUOTE_PUB.Price_Adj_Rec_Type;
3245: l_Price_Adj_Attr_rec ASO_QUOTE_PUB.Price_Adj_Attr_Rec_Type ;
3246: l_Price_Adj_Rltship_rec ASO_QUOTE_PUB.Price_Adj_Rltship_Rec_Type;

Line 3244: l_price_adj_rec ASO_QUOTE_PUB.Price_Adj_Rec_Type;

3240: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
3241: := P_Price_Adj_Attr_Tbl;
3242: l_Price_Adj_Rltship_Tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
3243: := P_Price_Adj_Rltship_Tbl;
3244: l_price_adj_rec ASO_QUOTE_PUB.Price_Adj_Rec_Type;
3245: l_Price_Adj_Attr_rec ASO_QUOTE_PUB.Price_Adj_Attr_Rec_Type ;
3246: l_Price_Adj_Rltship_rec ASO_QUOTE_PUB.Price_Adj_Rltship_Rec_Type;
3247: l_quote_line_id NUMBER;
3248: l_price_adjustment_id NUMBER;

Line 3245: l_Price_Adj_Attr_rec ASO_QUOTE_PUB.Price_Adj_Attr_Rec_Type ;

3241: := P_Price_Adj_Attr_Tbl;
3242: l_Price_Adj_Rltship_Tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
3243: := P_Price_Adj_Rltship_Tbl;
3244: l_price_adj_rec ASO_QUOTE_PUB.Price_Adj_Rec_Type;
3245: l_Price_Adj_Attr_rec ASO_QUOTE_PUB.Price_Adj_Attr_Rec_Type ;
3246: l_Price_Adj_Rltship_rec ASO_QUOTE_PUB.Price_Adj_Rltship_Rec_Type;
3247: l_quote_line_id NUMBER;
3248: l_price_adjustment_id NUMBER;
3249: BEGIN

Line 3246: l_Price_Adj_Rltship_rec ASO_QUOTE_PUB.Price_Adj_Rltship_Rec_Type;

3242: l_Price_Adj_Rltship_Tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
3243: := P_Price_Adj_Rltship_Tbl;
3244: l_price_adj_rec ASO_QUOTE_PUB.Price_Adj_Rec_Type;
3245: l_Price_Adj_Attr_rec ASO_QUOTE_PUB.Price_Adj_Attr_Rec_Type ;
3246: l_Price_Adj_Rltship_rec ASO_QUOTE_PUB.Price_Adj_Rltship_Rec_Type;
3247: l_quote_line_id NUMBER;
3248: l_price_adjustment_id NUMBER;
3249: BEGIN
3250: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN