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 QP_PREQ_GRP

Line 20: px_Req_line_attr_tbl IN OUT NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,

16: PROCEDURE Copy_Attribs_To_Req(
17: p_line_index number,
18: p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type,
19: p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type,
20: px_Req_line_attr_tbl IN OUT NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
21: px_Req_qual_tbl IN OUT NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.QUAL_TBL_TYPE)
22: IS
23: l_attr_index number := nvl(px_Req_line_attr_tbl.last,0);
24: l_qual_index number := nvl(px_Req_qual_tbl.last,0);

Line 21: px_Req_qual_tbl IN OUT NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.QUAL_TBL_TYPE)

17: p_line_index number,
18: p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type,
19: p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type,
20: px_Req_line_attr_tbl IN OUT NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
21: px_Req_qual_tbl IN OUT NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.QUAL_TBL_TYPE)
22: IS
23: l_attr_index number := nvl(px_Req_line_attr_tbl.last,0);
24: l_qual_index number := nvl(px_Req_qual_tbl.last,0);
25: BEGIN

Line 56: px_Req_line_attr_tbl IN OUT NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,

52: PROCEDURE Copy_hdr_attr_to_line(
53: p_line_index number,
54: p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type,
55: p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type,
56: px_Req_line_attr_tbl IN OUT NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
57: px_Req_qual_tbl IN OUT NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.QUAL_TBL_TYPE)
58: IS
59: l_attr_index number := nvl(px_Req_line_attr_tbl.last,0);
60: l_qual_index number := nvl(px_Req_qual_tbl.last,0);

Line 57: px_Req_qual_tbl IN OUT NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.QUAL_TBL_TYPE)

53: p_line_index number,
54: p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type,
55: p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type,
56: px_Req_line_attr_tbl IN OUT NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
57: px_Req_qual_tbl IN OUT NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.QUAL_TBL_TYPE)
58: IS
59: l_attr_index number := nvl(px_Req_line_attr_tbl.last,0);
60: l_qual_index number := nvl(px_Req_qual_tbl.last,0);
61: copy_hdr_rec_to_line_flag boolean := TRUE;

Line 105: px_req_line_tbl IN OUT NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.LINE_TBL_TYPE)

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;
109: px_req_line_tbl(1).PRICING_EVENT := p_pricing_event;

Line 137: px_req_line_tbl IN OUT NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.LINE_TBL_TYPE)

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;
140: l_uom_rate NUMBER;
141: begin

Line 139: l_req_line_rec QP_PREQ_GRP.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;
140: l_uom_rate NUMBER;
141: begin
142: /*
143: * New Code: Passing quote line id to QP pl/sql tbl

Line 238: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;

234: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Pricing_Order';
235: l_api_version_number CONSTANT NUMBER := 1.0;
236: l_request_type VARCHAR2(60);
237: l_pricing_event VARCHAR2(30);
238: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
239: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
240: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
241: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
242: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;

Line 239: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;

235: l_api_version_number CONSTANT NUMBER := 1.0;
236: l_request_type VARCHAR2(60);
237: l_pricing_event VARCHAR2(30);
238: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
239: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
240: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
241: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
242: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
243: l_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;

Line 240: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;

236: l_request_type VARCHAR2(60);
237: l_pricing_event VARCHAR2(30);
238: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
239: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
240: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
241: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
242: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
243: l_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
244: l_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;

Line 241: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;

237: l_pricing_event VARCHAR2(30);
238: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
239: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
240: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
241: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
242: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
243: l_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
244: l_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
245: l_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;

Line 242: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;

238: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
239: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
240: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
241: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
242: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
243: l_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
244: l_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
245: l_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
246: l_req_adj_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;

Line 243: l_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;

239: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
240: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
241: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
242: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
243: l_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
244: l_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
245: l_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
246: l_req_adj_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
247: l_hd_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;

Line 244: l_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;

240: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
241: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
242: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
243: l_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
244: l_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
245: l_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
246: l_req_adj_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
247: l_hd_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
248: l_hd_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;

Line 245: l_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;

241: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
242: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
243: l_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
244: l_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
245: l_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
246: l_req_adj_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
247: l_hd_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
248: l_hd_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
249: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;

Line 246: l_req_adj_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;

242: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
243: l_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
244: l_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
245: l_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
246: l_req_adj_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
247: l_hd_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
248: l_hd_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
249: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
250: l_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;

Line 251: lx_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;

247: l_hd_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
248: l_hd_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
249: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
250: l_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
251: lx_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
252: lx_req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
253: lx_req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
254: lx_req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
255: lx_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;

Line 252: lx_req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;

248: l_hd_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
249: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
250: l_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
251: lx_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
252: lx_req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
253: lx_req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
254: lx_req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_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;

Line 253: lx_req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;

249: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
250: l_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
251: lx_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
252: lx_req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
253: lx_req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
254: lx_req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_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;

Line 254: lx_req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;

250: l_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
251: lx_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
252: lx_req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
253: lx_req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
254: lx_req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_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;

Line 255: lx_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;

251: lx_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
252: lx_req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
253: lx_req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
254: lx_req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_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;

Line 256: lx_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;

252: lx_req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
253: lx_req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
254: lx_req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_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;

Line 257: lx_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;

253: lx_req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
254: lx_req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_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);

Line 274: lx_req_line_rec QP_PREQ_GRP.LINE_REC_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';
276: l_db_tbl_flg Varchar2(3);
277: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
278: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

Line 287: QP_PREQ_GRP.g_status_invalid_price_list,

283: pricing_status_text
284: from qp_preq_lines_tmp lines
285: where lines.line_type_code='LINE'
286: and lines.pricing_status_code in(
287: QP_PREQ_GRP.g_status_invalid_price_list,
288: QP_PREQ_GRP.g_sts_lhs_not_found,
289: QP_PREQ_GRP.g_status_formula_error,
290: QP_PREQ_GRP.g_status_other_errors,
291: fnd_api.g_ret_sts_unexp_error,

Line 288: QP_PREQ_GRP.g_sts_lhs_not_found,

284: from qp_preq_lines_tmp lines
285: where lines.line_type_code='LINE'
286: and lines.pricing_status_code in(
287: QP_PREQ_GRP.g_status_invalid_price_list,
288: QP_PREQ_GRP.g_sts_lhs_not_found,
289: QP_PREQ_GRP.g_status_formula_error,
290: QP_PREQ_GRP.g_status_other_errors,
291: fnd_api.g_ret_sts_unexp_error,
292: fnd_api.g_ret_sts_error,

Line 289: QP_PREQ_GRP.g_status_formula_error,

285: where lines.line_type_code='LINE'
286: and lines.pricing_status_code in(
287: QP_PREQ_GRP.g_status_invalid_price_list,
288: QP_PREQ_GRP.g_sts_lhs_not_found,
289: QP_PREQ_GRP.g_status_formula_error,
290: QP_PREQ_GRP.g_status_other_errors,
291: fnd_api.g_ret_sts_unexp_error,
292: fnd_api.g_ret_sts_error,
293: QP_PREQ_GRP.g_status_calc_error,

Line 290: QP_PREQ_GRP.g_status_other_errors,

286: and lines.pricing_status_code in(
287: QP_PREQ_GRP.g_status_invalid_price_list,
288: QP_PREQ_GRP.g_sts_lhs_not_found,
289: QP_PREQ_GRP.g_status_formula_error,
290: QP_PREQ_GRP.g_status_other_errors,
291: fnd_api.g_ret_sts_unexp_error,
292: fnd_api.g_ret_sts_error,
293: QP_PREQ_GRP.g_status_calc_error,
294: QP_PREQ_GRP.g_status_uom_failure,

Line 293: QP_PREQ_GRP.g_status_calc_error,

289: QP_PREQ_GRP.g_status_formula_error,
290: QP_PREQ_GRP.g_status_other_errors,
291: fnd_api.g_ret_sts_unexp_error,
292: fnd_api.g_ret_sts_error,
293: QP_PREQ_GRP.g_status_calc_error,
294: QP_PREQ_GRP.g_status_uom_failure,
295: QP_PREQ_GRP.g_status_invalid_uom,
296: QP_PREQ_GRP.g_status_dup_price_list,
297: QP_PREQ_GRP.g_status_invalid_uom_conv,

Line 294: QP_PREQ_GRP.g_status_uom_failure,

290: QP_PREQ_GRP.g_status_other_errors,
291: fnd_api.g_ret_sts_unexp_error,
292: fnd_api.g_ret_sts_error,
293: QP_PREQ_GRP.g_status_calc_error,
294: QP_PREQ_GRP.g_status_uom_failure,
295: QP_PREQ_GRP.g_status_invalid_uom,
296: QP_PREQ_GRP.g_status_dup_price_list,
297: QP_PREQ_GRP.g_status_invalid_uom_conv,
298: QP_PREQ_GRP.g_status_invalid_incomp,

Line 295: QP_PREQ_GRP.g_status_invalid_uom,

291: fnd_api.g_ret_sts_unexp_error,
292: fnd_api.g_ret_sts_error,
293: QP_PREQ_GRP.g_status_calc_error,
294: QP_PREQ_GRP.g_status_uom_failure,
295: QP_PREQ_GRP.g_status_invalid_uom,
296: QP_PREQ_GRP.g_status_dup_price_list,
297: QP_PREQ_GRP.g_status_invalid_uom_conv,
298: QP_PREQ_GRP.g_status_invalid_incomp,
299: QP_PREQ_GRP.g_status_best_price_eval_error);

Line 296: QP_PREQ_GRP.g_status_dup_price_list,

292: fnd_api.g_ret_sts_error,
293: QP_PREQ_GRP.g_status_calc_error,
294: QP_PREQ_GRP.g_status_uom_failure,
295: QP_PREQ_GRP.g_status_invalid_uom,
296: QP_PREQ_GRP.g_status_dup_price_list,
297: QP_PREQ_GRP.g_status_invalid_uom_conv,
298: QP_PREQ_GRP.g_status_invalid_incomp,
299: QP_PREQ_GRP.g_status_best_price_eval_error);
300:

Line 297: QP_PREQ_GRP.g_status_invalid_uom_conv,

293: QP_PREQ_GRP.g_status_calc_error,
294: QP_PREQ_GRP.g_status_uom_failure,
295: QP_PREQ_GRP.g_status_invalid_uom,
296: QP_PREQ_GRP.g_status_dup_price_list,
297: QP_PREQ_GRP.g_status_invalid_uom_conv,
298: QP_PREQ_GRP.g_status_invalid_incomp,
299: QP_PREQ_GRP.g_status_best_price_eval_error);
300:
301:

Line 298: QP_PREQ_GRP.g_status_invalid_incomp,

294: QP_PREQ_GRP.g_status_uom_failure,
295: QP_PREQ_GRP.g_status_invalid_uom,
296: QP_PREQ_GRP.g_status_dup_price_list,
297: QP_PREQ_GRP.g_status_invalid_uom_conv,
298: QP_PREQ_GRP.g_status_invalid_incomp,
299: QP_PREQ_GRP.g_status_best_price_eval_error);
300:
301:
302:

Line 299: QP_PREQ_GRP.g_status_best_price_eval_error);

295: QP_PREQ_GRP.g_status_invalid_uom,
296: QP_PREQ_GRP.g_status_dup_price_list,
297: QP_PREQ_GRP.g_status_invalid_uom_conv,
298: QP_PREQ_GRP.g_status_invalid_incomp,
299: QP_PREQ_GRP.g_status_best_price_eval_error);
300:
301:
302:
303:

Line 518: l_req_related_lines_tbl(j).RELATIONSHIP_TYPE_CODE :=QP_PREQ_GRP.G_SERVICE_LINE;

514: l_req_related_lines_tbl(j).line_index := l_qte_line_prcd_parent(l_srv_line_dtl_tbl(j).service_ref_line_id)+1;
515: l_req_related_lines_tbl(j).LINE_DETAIL_INDEX := 0;
516: l_req_related_lines_tbl(j).RELATED_LINE_INDEX := l_qte_line_prcd_child(l_srv_line_dtl_tbl(j).quote_line_id)+1;
517: l_req_related_lines_tbl(j).RELATED_LINE_DETAIL_INDEX := 0;
518: l_req_related_lines_tbl(j).RELATIONSHIP_TYPE_CODE :=QP_PREQ_GRP.G_SERVICE_LINE;
519: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
520: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:line_index :'
521: ||l_req_related_lines_tbl(j).line_index, 1, 'Y');
522: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:related line_index: '

Line 544: /* Change for populating QP_PREQ_GRP.CONTROL_RECORD_TYPE.ORG_ID Yogeshwar (MOAC) */

540: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
541: aso_debug_pub.add('ASO_VALIDATE_PRICING_PVT:Start of QP_PREQ_PUB.PRICE_REQUEST', 1, 'Y');
542: END IF;
543:
544: /* Change for populating QP_PREQ_GRP.CONTROL_RECORD_TYPE.ORG_ID Yogeshwar (MOAC) */
545:
546: IF ((p_qte_header_rec.org_id IS NULL) OR (p_qte_header_rec.org_id = FND_API.G_MISS_NUM)) THEN
547: IF fnd_msg_pub.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
548: FND_MESSAGE.Set_Name('ASO', 'ASO_MISSING_OU');