APPS.ASO_PRICING_CALLBACK_PVT dependencies on ASO_QUOTE_PUB

Line 18: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,

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

Line 19: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type

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

Line 20: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,

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

Line 21: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type

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

Line 22: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,

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

Line 23: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,

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

Line 24: p_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type

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

Line 25: := ASO_QUOTE_PUB.G_Miss_Line_Rltship_Tbl,

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

Line 26: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type

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

Line 27: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl,

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

Line 28: p_ln_shipment_tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type

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

Line 29: := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl,

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

Line 30: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type

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

Line 31: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 47: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,

43: P_Api_Version_Number IN NUMBER,
44: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
45: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
46: p_control_rec IN ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE,
47: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
48: p_qte_header_id IN NUMBER,
49: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
50: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
51: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);

Line 78: p_pricing_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,

74:
75:
76: procedure Append_asked_for(
77: p_line_index NUMBER,
78: p_pricing_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
79: px_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
80: px_Req_qual_tbl IN OUT NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.QUAL_TBL_TYPE);
81:
82: procedure copy_Header_to_request(

Line 85: p_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type,

81:
82: procedure copy_Header_to_request(
83: p_Request_Type VARCHAR2,
84: p_pricing_event VARCHAR2,
85: p_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type,
86: px_req_line_tbl IN OUT NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.LINE_TBL_TYPE);
87:
88:
89: PROCEDURE Copy_Req_Dtl_To_Price_Adj (

Line 91: p_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,

87:
88:
89: PROCEDURE Copy_Req_Dtl_To_Price_Adj (
90: p_qte_line_index IN NUMBER,
91: p_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
92: p_req_line_dtl_index IN NUMBER,
93: p_req_line_detail_rec IN QP_PREQ_GRP.LINE_DETAIL_REC_TYPE,
94: p_req_line_detail_qual_tbl IN QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
95: p_req_line_detail_attr_tbl IN QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,

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

92: p_req_line_dtl_index IN NUMBER,
93: p_req_line_detail_rec IN QP_PREQ_GRP.LINE_DETAIL_REC_TYPE,
94: p_req_line_detail_qual_tbl IN QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
95: p_req_line_detail_attr_tbl IN QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
96: px_price_adj_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
97: px_price_adj_attr_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Tbl_Type,
98: px_price_adj_prcd IN OUT NOCOPY /* file.sql.39 change */ Index_Link_Tbl_Type);
99:
100: PROCEDURE Copy_Req_Dtl_To_Price_Adj (

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

93: p_req_line_detail_rec IN QP_PREQ_GRP.LINE_DETAIL_REC_TYPE,
94: p_req_line_detail_qual_tbl IN QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
95: p_req_line_detail_attr_tbl IN QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
96: px_price_adj_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
97: px_price_adj_attr_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Tbl_Type,
98: px_price_adj_prcd IN OUT NOCOPY /* file.sql.39 change */ Index_Link_Tbl_Type);
99:
100: PROCEDURE Copy_Req_Dtl_To_Price_Adj (
101: p_qte_header_rec IN ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE,

Line 101: p_qte_header_rec IN ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE,

97: px_price_adj_attr_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Tbl_Type,
98: px_price_adj_prcd IN OUT NOCOPY /* file.sql.39 change */ Index_Link_Tbl_Type);
99:
100: PROCEDURE Copy_Req_Dtl_To_Price_Adj (
101: p_qte_header_rec IN ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE,
102: p_req_line_dtl_index IN NUMBER,
103: p_req_line_detail_rec IN QP_PREQ_GRP.LINE_DETAIL_REC_TYPE,
104: p_req_line_detail_qual_tbl IN QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
105: p_req_line_detail_attr_tbl IN QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,

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

102: p_req_line_dtl_index IN NUMBER,
103: p_req_line_detail_rec IN QP_PREQ_GRP.LINE_DETAIL_REC_TYPE,
104: p_req_line_detail_qual_tbl IN QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
105: p_req_line_detail_attr_tbl IN QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
106: px_price_adj_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
107: px_price_adj_attr_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Tbl_Type,
108: px_price_adj_prcd IN OUT NOCOPY /* file.sql.39 change */ Index_Link_Tbl_Type);
109:
110: procedure copy_Line_to_request(

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

103: p_req_line_detail_rec IN QP_PREQ_GRP.LINE_DETAIL_REC_TYPE,
104: p_req_line_detail_qual_tbl IN QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
105: p_req_line_detail_attr_tbl IN QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
106: px_price_adj_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
107: px_price_adj_attr_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Tbl_Type,
108: px_price_adj_prcd IN OUT NOCOPY /* file.sql.39 change */ Index_Link_Tbl_Type);
109:
110: procedure copy_Line_to_request(
111: p_Request_Type VARCHAR2,

Line 113: p_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type,

109:
110: procedure copy_Line_to_request(
111: p_Request_Type VARCHAR2,
112: p_pricing_event VARCHAR2,
113: p_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type,
114: p_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type,
115: p_control_rec IN ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE,
116: px_req_line_tbl IN OUT NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.LINE_TBL_TYPE);
117:

Line 114: p_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type,

110: procedure copy_Line_to_request(
111: p_Request_Type VARCHAR2,
112: p_pricing_event VARCHAR2,
113: p_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type,
114: p_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type,
115: p_control_rec IN ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE,
116: px_req_line_tbl IN OUT NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.LINE_TBL_TYPE);
117:
118: PROCEDURE Copy_Request_To_Quote(

Line 126: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,

122: p_req_line_detail_tbl IN QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
123: p_req_line_detail_qual_tbl IN QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
124: p_req_line_detail_attr_tbl IN QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
125: p_req_related_lines_tbl IN QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
126: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
127: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
128: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
129: x_qte_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
130: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,

Line 127: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,

123: p_req_line_detail_qual_tbl IN QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
124: p_req_line_detail_attr_tbl IN QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
125: p_req_related_lines_tbl IN QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
126: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
127: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
128: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
129: x_qte_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
130: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
131: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,

Line 128: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,

124: p_req_line_detail_attr_tbl IN QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
125: p_req_related_lines_tbl IN QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
126: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
127: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
128: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
129: x_qte_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
130: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
131: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
132: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,

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

125: p_req_related_lines_tbl IN QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
126: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
127: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
128: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
129: x_qte_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
130: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
131: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
132: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
133: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Tbl_Type,

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

126: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
127: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
128: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
129: x_qte_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
130: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
131: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
132: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
133: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Tbl_Type,
134: x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type);

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

127: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
128: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
129: x_qte_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
130: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
131: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
132: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
133: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Tbl_Type,
134: x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type);
135:

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

128: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
129: x_qte_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
130: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
131: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
132: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
133: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Tbl_Type,
134: x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type);
135:
136: -- Bug 2430068. This following procedure was copied from asoiprcb.pls.115.141 version

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

129: x_qte_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
130: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
131: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
132: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
133: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Tbl_Type,
134: x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type);
135:
136: -- Bug 2430068. This following procedure was copied from asoiprcb.pls.115.141 version
137: -- This is the right version as per vakapoor.

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

130: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
131: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
132: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
133: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Tbl_Type,
134: x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type);
135:
136: -- Bug 2430068. This following procedure was copied from asoiprcb.pls.115.141 version
137: -- This is the right version as per vakapoor.
138: -- Original One was giving no data found.

Line 148: p_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,

144: p_req_line_detail_tbl IN QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
145: p_req_line_detail_qual_tbl IN QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
146: p_req_line_detail_attr_tbl IN QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
147: p_req_related_lines_tbl IN QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
148: p_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
149: p_qte_line_dtl_rec IN ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type,
150: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
151: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
152: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,

Line 149: p_qte_line_dtl_rec IN ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type,

145: p_req_line_detail_qual_tbl IN QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
146: p_req_line_detail_attr_tbl IN QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
147: p_req_related_lines_tbl IN QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
148: p_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
149: p_qte_line_dtl_rec IN ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type,
150: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
151: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
152: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
153: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Tbl_Type,

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

146: p_req_line_detail_attr_tbl IN QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
147: p_req_related_lines_tbl IN QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
148: p_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
149: p_qte_line_dtl_rec IN ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type,
150: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
151: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
152: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
153: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Tbl_Type,
154: x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type);

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

147: p_req_related_lines_tbl IN QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
148: p_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
149: p_qte_line_dtl_rec IN ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type,
150: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
151: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
152: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
153: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Tbl_Type,
154: x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type);
155:

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

148: p_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
149: p_qte_line_dtl_rec IN ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type,
150: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
151: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
152: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
153: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Tbl_Type,
154: x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type);
155:
156:

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

149: p_qte_line_dtl_rec IN ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type,
150: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
151: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
152: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
153: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Tbl_Type,
154: x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type);
155:
156:
157: PROCEDURE Update_Quote_Rows(

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

150: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
151: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
152: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
153: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Tbl_Type,
154: x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type);
155:
156:
157: PROCEDURE Update_Quote_Rows(
158: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type

Line 158: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type

154: x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type);
155:
156:
157: PROCEDURE Update_Quote_Rows(
158: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
159: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
160: P_Qte_Line_Dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_tbl_Type
161: := ASO_QUOTE_PUB.G_MISS_qte_line_dtl_tbl,
162: P_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type

Line 159: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,

155:
156:
157: PROCEDURE Update_Quote_Rows(
158: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
159: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
160: P_Qte_Line_Dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_tbl_Type
161: := ASO_QUOTE_PUB.G_MISS_qte_line_dtl_tbl,
162: P_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
163: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,

Line 160: P_Qte_Line_Dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_tbl_Type

156:
157: PROCEDURE Update_Quote_Rows(
158: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
159: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
160: P_Qte_Line_Dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_tbl_Type
161: := ASO_QUOTE_PUB.G_MISS_qte_line_dtl_tbl,
162: P_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
163: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
164: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type

Line 161: := ASO_QUOTE_PUB.G_MISS_qte_line_dtl_tbl,

157: PROCEDURE Update_Quote_Rows(
158: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
159: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
160: P_Qte_Line_Dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_tbl_Type
161: := ASO_QUOTE_PUB.G_MISS_qte_line_dtl_tbl,
162: P_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
163: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
164: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
165: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,

Line 162: P_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type

158: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
159: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
160: P_Qte_Line_Dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_tbl_Type
161: := ASO_QUOTE_PUB.G_MISS_qte_line_dtl_tbl,
162: P_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
163: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
164: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
165: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
166: P_Price_Adj_Rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type

Line 163: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,

159: := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
160: P_Qte_Line_Dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_tbl_Type
161: := ASO_QUOTE_PUB.G_MISS_qte_line_dtl_tbl,
162: P_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
163: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
164: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
165: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
166: P_Price_Adj_Rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
167: := ASO_QUOTE_PUB.G_Miss_Price_Adj_Rltship_Tbl);

Line 164: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type

160: P_Qte_Line_Dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_tbl_Type
161: := ASO_QUOTE_PUB.G_MISS_qte_line_dtl_tbl,
162: P_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
163: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
164: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
165: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
166: P_Price_Adj_Rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
167: := ASO_QUOTE_PUB.G_Miss_Price_Adj_Rltship_Tbl);
168:

Line 165: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,

161: := ASO_QUOTE_PUB.G_MISS_qte_line_dtl_tbl,
162: P_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
163: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
164: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
165: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
166: P_Price_Adj_Rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
167: := ASO_QUOTE_PUB.G_Miss_Price_Adj_Rltship_Tbl);
168:
169:

Line 166: P_Price_Adj_Rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type

162: P_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
163: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
164: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
165: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
166: P_Price_Adj_Rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
167: := ASO_QUOTE_PUB.G_Miss_Price_Adj_Rltship_Tbl);
168:
169:
170: End ASO_PRICING_CALLBACK_PVT;

Line 167: := ASO_QUOTE_PUB.G_Miss_Price_Adj_Rltship_Tbl);

163: := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
164: P_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
165: := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
166: P_Price_Adj_Rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
167: := ASO_QUOTE_PUB.G_Miss_Price_Adj_Rltship_Tbl);
168:
169:
170: End ASO_PRICING_CALLBACK_PVT;