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,
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,
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
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,
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
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,
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
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,
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
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,
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,
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,
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,
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,
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,
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,
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,
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,
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);
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:
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);
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(
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 (
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,
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 (
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,
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,
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(
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,
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:
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(
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,
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,
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,
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,
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);
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:
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
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.
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.
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,
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,
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);
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:
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:
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(
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
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
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,
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
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,
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
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);
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:
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:
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;
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;