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

APPS.ASO_VALIDATE_PRICING_PVT dependencies on ASO_QUOTE_PUB

Line 104: p_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type,

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;

Line 134: p_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_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

Line 135: p_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type,

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;

Line 209: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_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,

Line 210: p_hd_shipment_rec IN ASO_QUOTE_PUB.Shipment_Rec_Type

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,

Line 211: := ASO_QUOTE_PUB.G_Miss_Shipment_Rec,

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

Line 212: p_hd_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_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,

Line 213: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_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

Line 214: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_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,

Line 215: p_line_rltship_tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_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,
219: p_ln_shipment_tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type

Line 216: := ASO_QUOTE_PUB.G_Miss_Line_Rltship_Tbl,

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,

Line 217: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_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,
221: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type

Line 218: := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_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
222: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,

Line 219: p_ln_shipment_tbl IN ASO_QUOTE_PUB.Shipment_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,
223: x_qte_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,

Line 220: := ASO_QUOTE_PUB.G_Miss_Shipment_Tbl,

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,

Line 221: p_ln_price_attr_tbl IN ASO_QUOTE_PUB.Price_Attributes_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,

Line 222: := ASO_QUOTE_PUB.G_Miss_Price_Attributes_Tbl,

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,

Line 223: x_qte_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_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,

Line 224: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_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,

Line 225: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_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,

Line 226: x_price_adj_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_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,
230: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

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

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)

Line 228: x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_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)
232:

Line 259: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;

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;

Line 260: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_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;
264: j BINARY_INTEGER;

Line 266: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;

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;

Line 267: lx_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_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;

Line 268: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_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;

Line 269: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_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;

Line 270: l_srv_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_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;

Line 271: l_shipment_tbl ASO_QUOTE_PUB.Shipment_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;
275: l_call_flg Varchar2(1):='Q';

Line 418: l_qte_line_dtl_rec := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_REC ;

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:

Line 425: l_shipment_rec := ASO_QUOTE_PUB.G_Miss_Shipment_rec;

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