100:
101: procedure copy_Header_to_request(
102: p_Request_Type VARCHAR2,
103: p_pricing_event VARCHAR2,
104: p_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type,
105: px_req_line_tbl IN OUT NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.LINE_TBL_TYPE)
106: IS
107: BEGIN
108: px_req_line_tbl(1).REQUEST_TYPE_CODE := p_Request_Type;
130:
131: procedure copy_Line_to_request(
132: p_Request_Type VARCHAR2,
133: p_pricing_event VARCHAR2,
134: p_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type,
135: p_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type,
136: p_control_rec IN ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE,
137: px_req_line_tbl IN OUT NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.LINE_TBL_TYPE)
138: is
131: procedure copy_Line_to_request(
132: p_Request_Type VARCHAR2,
133: p_pricing_event VARCHAR2,
134: p_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type,
135: p_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type,
136: p_control_rec IN ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE,
137: px_req_line_tbl IN OUT NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.LINE_TBL_TYPE)
138: is
139: l_req_line_rec QP_PREQ_GRP.LINE_REC_TYPE;
205: P_Api_Version_Number IN NUMBER,
206: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
207: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
208: p_control_rec IN ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE,
209: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
210: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
211: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
212: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
213: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
206: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
207: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
208: p_control_rec IN ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE,
209: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
210: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
211: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
212: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
213: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
214: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
207: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
208: p_control_rec IN ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE,
209: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
210: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
211: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
212: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
213: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
214: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
215: p_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
208: p_control_rec IN ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE,
209: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
210: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
211: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
212: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
213: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
214: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
215: p_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
216: := ASO_QUOTE_PUB.G_Miss_Line_Rltship_Tbl,
209: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
210: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
211: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
212: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
213: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
214: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
215: p_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
216: := ASO_QUOTE_PUB.G_Miss_Line_Rltship_Tbl,
217: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
210: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type
211: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
212: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
213: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
214: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
215: p_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
216: := ASO_QUOTE_PUB.G_Miss_Line_Rltship_Tbl,
217: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
218: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl,
211: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,
212: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
213: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
214: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
215: p_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
216: := ASO_QUOTE_PUB.G_Miss_Line_Rltship_Tbl,
217: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
218: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl,
219: p_ln_shipment_tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
212: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
213: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
214: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
215: p_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
216: := ASO_QUOTE_PUB.G_Miss_Line_Rltship_Tbl,
217: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
218: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl,
219: p_ln_shipment_tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
220: := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl,
213: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
214: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
215: p_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
216: := ASO_QUOTE_PUB.G_Miss_Line_Rltship_Tbl,
217: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
218: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl,
219: p_ln_shipment_tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
220: := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl,
221: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
214: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
215: p_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
216: := ASO_QUOTE_PUB.G_Miss_Line_Rltship_Tbl,
217: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
218: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl,
219: p_ln_shipment_tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
220: := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl,
221: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
222: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
215: p_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
216: := ASO_QUOTE_PUB.G_Miss_Line_Rltship_Tbl,
217: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
218: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl,
219: p_ln_shipment_tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
220: := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl,
221: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
222: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
223: x_qte_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
216: := ASO_QUOTE_PUB.G_Miss_Line_Rltship_Tbl,
217: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
218: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl,
219: p_ln_shipment_tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
220: := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl,
221: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
222: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
223: x_qte_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
224: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
217: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type
218: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl,
219: p_ln_shipment_tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
220: := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl,
221: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
222: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
223: x_qte_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
224: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
225: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
218: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl,
219: p_ln_shipment_tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
220: := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl,
221: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
222: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
223: x_qte_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
224: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
225: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
226: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
219: p_ln_shipment_tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
220: := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl,
221: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
222: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
223: x_qte_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
224: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
225: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
226: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
227: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
220: := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl,
221: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
222: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
223: x_qte_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
224: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
225: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
226: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
227: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
228: x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
221: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
222: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
223: x_qte_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
224: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
225: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
226: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
227: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
228: x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
229: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
222: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,
223: x_qte_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
224: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
225: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
226: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
227: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
228: x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
229: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
230: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
223: x_qte_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
224: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
225: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
226: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
227: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
228: x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
229: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
230: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
231: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
224: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
225: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
226: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
227: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
228: x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
229: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
230: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
231: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
232:
255: lx_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
256: lx_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
257: lx_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
258: l_qte_line_id NUMBER;
259: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
260: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
261: l_return_status VARCHAR2(1);
262: l_return_status_text VARCHAR2(2000);
263: i BINARY_INTEGER;
256: lx_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
257: lx_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
258: l_qte_line_id NUMBER;
259: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
260: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
261: l_return_status VARCHAR2(1);
262: l_return_status_text VARCHAR2(2000);
263: i BINARY_INTEGER;
264: j BINARY_INTEGER;
262: l_return_status_text VARCHAR2(2000);
263: i BINARY_INTEGER;
264: j BINARY_INTEGER;
265: k BINARY_INTEGER;
266: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
267: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
268: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
269: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
270: l_srv_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
263: i BINARY_INTEGER;
264: j BINARY_INTEGER;
265: k BINARY_INTEGER;
266: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
267: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
268: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
269: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
270: l_srv_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
271: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
264: j BINARY_INTEGER;
265: k BINARY_INTEGER;
266: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
267: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
268: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
269: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
270: l_srv_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
271: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
272: l_qte_line_prcd_parent ASO_PRICING_INT.Index_Link_Tbl_Type;
265: k BINARY_INTEGER;
266: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
267: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
268: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
269: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
270: l_srv_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
271: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
272: l_qte_line_prcd_parent ASO_PRICING_INT.Index_Link_Tbl_Type;
273: l_qte_line_prcd_child ASO_PRICING_INT.Index_Link_Tbl_Type;
266: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
267: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
268: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
269: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
270: l_srv_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
271: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
272: l_qte_line_prcd_parent ASO_PRICING_INT.Index_Link_Tbl_Type;
273: l_qte_line_prcd_child ASO_PRICING_INT.Index_Link_Tbl_Type;
274: lx_req_line_rec QP_PREQ_GRP.LINE_REC_TYPE;
267: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
268: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
269: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
270: l_srv_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
271: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
272: l_qte_line_prcd_parent ASO_PRICING_INT.Index_Link_Tbl_Type;
273: l_qte_line_prcd_child ASO_PRICING_INT.Index_Link_Tbl_Type;
274: lx_req_line_rec QP_PREQ_GRP.LINE_REC_TYPE;
275: l_call_flg Varchar2(1):='Q';
414: If l_qte_line_dtl_tbl.count >0 then
415: l_srv_line_dtl_tbl(l_srv_line_dtl_tbl.count+1):= l_qte_line_dtl_tbl(1);
416: end if;
417:
418: l_qte_line_dtl_rec := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_REC ;
419: IF l_qte_line_dtl_tbl.count = 1 THEN
420: l_qte_line_dtl_rec := l_qte_line_dtl_tbl(1);
421: END IF;
422:
421: END IF;
422:
423: l_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows(p_qte_header_rec.quote_header_id,
424: l_qte_line_id);
425: l_shipment_rec := ASO_QUOTE_PUB.G_Miss_Shipment_rec;
426: IF l_shipment_tbl.count = 1 THEN
427: l_shipment_rec := l_shipment_tbl(1);
428: END IF;
429: End If;--If l_call_flg = 'Q' then