44: l_api_name CONSTANT VARCHAR2(30) := 'Config_Callback_Pricing_Order';
45: l_api_version_number CONSTANT NUMBER := 1.0;
46: l_request_type VARCHAR2(60);
47: l_pricing_event VARCHAR2(30);
48: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
49: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
50: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
51: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
52: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
45: l_api_version_number CONSTANT NUMBER := 1.0;
46: l_request_type VARCHAR2(60);
47: l_pricing_event VARCHAR2(30);
48: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
49: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
50: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
51: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
52: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
53: l_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
46: l_request_type VARCHAR2(60);
47: l_pricing_event VARCHAR2(30);
48: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
49: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
50: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
51: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
52: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
53: l_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
54: l_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
47: l_pricing_event VARCHAR2(30);
48: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
49: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
50: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
51: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
52: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
53: l_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
54: l_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
55: l_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
48: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
49: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
50: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
51: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
52: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
53: l_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
54: l_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
55: l_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
56: l_req_adj_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
49: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
50: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
51: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
52: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
53: l_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
54: l_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
55: l_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
56: l_req_adj_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
57: l_hd_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
50: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
51: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
52: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
53: l_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
54: l_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
55: l_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
56: l_req_adj_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
57: l_hd_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
58: l_hd_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
51: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
52: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
53: l_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
54: l_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
55: l_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
56: l_req_adj_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
57: l_hd_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
58: l_hd_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
59: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
52: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
53: l_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
54: l_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
55: l_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
56: l_req_adj_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
57: l_hd_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
58: l_hd_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
59: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
60: l_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
57: l_hd_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
58: l_hd_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
59: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
60: l_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
61: lx_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
62: lx_req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
63: lx_req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
64: lx_req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
65: lx_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
58: l_hd_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
59: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
60: l_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
61: lx_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
62: lx_req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
63: lx_req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
64: lx_req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
65: lx_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
66: lx_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
59: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
60: l_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
61: lx_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
62: lx_req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
63: lx_req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
64: lx_req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
65: lx_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
66: lx_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
67: lx_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
60: l_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
61: lx_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
62: lx_req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
63: lx_req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
64: lx_req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
65: lx_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
66: lx_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
67: lx_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
68: l_qte_line_id NUMBER;
61: lx_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
62: lx_req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
63: lx_req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
64: lx_req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
65: lx_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
66: lx_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
67: lx_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
68: l_qte_line_id NUMBER;
69: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
62: lx_req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
63: lx_req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
64: lx_req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
65: lx_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
66: lx_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
67: lx_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
68: l_qte_line_id NUMBER;
69: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
70: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
63: lx_req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
64: lx_req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
65: lx_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
66: lx_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
67: lx_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
68: l_qte_line_id NUMBER;
69: l_qte_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
70: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
71: l_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
73: l_return_status VARCHAR2(1);
74: lv_return_status VARCHAR2(1);
75: l_return_status_text VARCHAR2(2000);
76: l_message_text VARCHAR2(2000);
77: lx_req_line_rec QP_PREQ_GRP.LINE_REC_TYPE;
78: i BINARY_INTEGER;
79: j BINARY_INTEGER;
80: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
81: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
266:
267: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
268: aso_debug_pub.add('ASO_PRICING_CALLBACK_PVT:Start of QP_PREQ_PUB.PRICE_REQUEST', 1, 'Y');
269: END IF;
270: /* Change for populating QP_PREQ_GRP.CONTROL_RECORD_TYPE.ORG_ID Yogeshwar (MOAC) */
271:
272: l_control_rec.ORG_ID := p_qte_header_rec.org_id;
273:
274: /* End of Change (MOAC) */
304: i := lx_req_line_tbl.FIRST;
305: WHILE i IS NOT NULL LOOP
306: lx_req_line_rec := lx_req_line_tbl(i);
307: x_return_status := FND_API.G_RET_STS_SUCCESS;
308: If lx_req_line_rec.status_code in(QP_PREQ_GRP.g_status_invalid_price_list,
309: QP_PREQ_GRP.g_sts_lhs_not_found,
310: QP_PREQ_GRP.g_status_formula_error,QP_PREQ_GRP.g_status_other_errors,
311: fnd_api.g_ret_sts_unexp_error,fnd_api.g_ret_sts_error,
312: QP_PREQ_GRP.g_status_calc_error,QP_PREQ_GRP.g_status_uom_failure,
305: WHILE i IS NOT NULL LOOP
306: lx_req_line_rec := lx_req_line_tbl(i);
307: x_return_status := FND_API.G_RET_STS_SUCCESS;
308: If lx_req_line_rec.status_code in(QP_PREQ_GRP.g_status_invalid_price_list,
309: QP_PREQ_GRP.g_sts_lhs_not_found,
310: QP_PREQ_GRP.g_status_formula_error,QP_PREQ_GRP.g_status_other_errors,
311: fnd_api.g_ret_sts_unexp_error,fnd_api.g_ret_sts_error,
312: QP_PREQ_GRP.g_status_calc_error,QP_PREQ_GRP.g_status_uom_failure,
313: QP_PREQ_GRP.g_status_invalid_uom,QP_PREQ_GRP.g_status_dup_price_list,
306: lx_req_line_rec := lx_req_line_tbl(i);
307: x_return_status := FND_API.G_RET_STS_SUCCESS;
308: If lx_req_line_rec.status_code in(QP_PREQ_GRP.g_status_invalid_price_list,
309: QP_PREQ_GRP.g_sts_lhs_not_found,
310: QP_PREQ_GRP.g_status_formula_error,QP_PREQ_GRP.g_status_other_errors,
311: fnd_api.g_ret_sts_unexp_error,fnd_api.g_ret_sts_error,
312: QP_PREQ_GRP.g_status_calc_error,QP_PREQ_GRP.g_status_uom_failure,
313: QP_PREQ_GRP.g_status_invalid_uom,QP_PREQ_GRP.g_status_dup_price_list,
314: QP_PREQ_GRP.g_status_invalid_uom_conv,QP_PREQ_GRP.g_status_invalid_incomp,
308: If lx_req_line_rec.status_code in(QP_PREQ_GRP.g_status_invalid_price_list,
309: QP_PREQ_GRP.g_sts_lhs_not_found,
310: QP_PREQ_GRP.g_status_formula_error,QP_PREQ_GRP.g_status_other_errors,
311: fnd_api.g_ret_sts_unexp_error,fnd_api.g_ret_sts_error,
312: QP_PREQ_GRP.g_status_calc_error,QP_PREQ_GRP.g_status_uom_failure,
313: QP_PREQ_GRP.g_status_invalid_uom,QP_PREQ_GRP.g_status_dup_price_list,
314: QP_PREQ_GRP.g_status_invalid_uom_conv,QP_PREQ_GRP.g_status_invalid_incomp,
315: QP_PREQ_GRP.g_status_best_price_eval_error,
316: QP_PREQ_PUB.g_back_calculation_sts) THEN
309: QP_PREQ_GRP.g_sts_lhs_not_found,
310: QP_PREQ_GRP.g_status_formula_error,QP_PREQ_GRP.g_status_other_errors,
311: fnd_api.g_ret_sts_unexp_error,fnd_api.g_ret_sts_error,
312: QP_PREQ_GRP.g_status_calc_error,QP_PREQ_GRP.g_status_uom_failure,
313: QP_PREQ_GRP.g_status_invalid_uom,QP_PREQ_GRP.g_status_dup_price_list,
314: QP_PREQ_GRP.g_status_invalid_uom_conv,QP_PREQ_GRP.g_status_invalid_incomp,
315: QP_PREQ_GRP.g_status_best_price_eval_error,
316: QP_PREQ_PUB.g_back_calculation_sts) THEN
317: x_return_status := FND_API.G_RET_STS_ERROR;
310: QP_PREQ_GRP.g_status_formula_error,QP_PREQ_GRP.g_status_other_errors,
311: fnd_api.g_ret_sts_unexp_error,fnd_api.g_ret_sts_error,
312: QP_PREQ_GRP.g_status_calc_error,QP_PREQ_GRP.g_status_uom_failure,
313: QP_PREQ_GRP.g_status_invalid_uom,QP_PREQ_GRP.g_status_dup_price_list,
314: QP_PREQ_GRP.g_status_invalid_uom_conv,QP_PREQ_GRP.g_status_invalid_incomp,
315: QP_PREQ_GRP.g_status_best_price_eval_error,
316: QP_PREQ_PUB.g_back_calculation_sts) THEN
317: x_return_status := FND_API.G_RET_STS_ERROR;
318: END IF;
311: fnd_api.g_ret_sts_unexp_error,fnd_api.g_ret_sts_error,
312: QP_PREQ_GRP.g_status_calc_error,QP_PREQ_GRP.g_status_uom_failure,
313: QP_PREQ_GRP.g_status_invalid_uom,QP_PREQ_GRP.g_status_dup_price_list,
314: QP_PREQ_GRP.g_status_invalid_uom_conv,QP_PREQ_GRP.g_status_invalid_incomp,
315: QP_PREQ_GRP.g_status_best_price_eval_error,
316: QP_PREQ_PUB.g_back_calculation_sts) THEN
317: x_return_status := FND_API.G_RET_STS_ERROR;
318: END IF;
319: If lx_req_line_rec.status_code = QP_PREQ_GRP.G_STATUS_GSA_VIOLATION Then
315: QP_PREQ_GRP.g_status_best_price_eval_error,
316: QP_PREQ_PUB.g_back_calculation_sts) THEN
317: x_return_status := FND_API.G_RET_STS_ERROR;
318: END IF;
319: If lx_req_line_rec.status_code = QP_PREQ_GRP.G_STATUS_GSA_VIOLATION Then
320: IF FND_PROFILE.value('ASO_GSA_PRICING') = 'ERROR' THEN
321: x_return_status := FND_API.G_RET_STS_ERROR;
322: FND_MESSAGE.Set_Name('ASO', 'GSA Violation in Pricing');
323: FND_MSG_PUB.ADD;
328: FND_MSG_PUB.ADD;
329: END IF;
330: End if;
331:
332: If lx_req_line_rec.status_code <>QP_PREQ_GRP.G_STATUS_GSA_VIOLATION Then
333: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
334: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
335: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
336: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
465: IS
466:
467: l_api_name CONSTANT VARCHAR2(30) := 'Config_Callback_Pricing_Order';
468: l_api_version_number CONSTANT NUMBER := 1.0;
469: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
470: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
471: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
472: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
473: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
466:
467: l_api_name CONSTANT VARCHAR2(30) := 'Config_Callback_Pricing_Order';
468: l_api_version_number CONSTANT NUMBER := 1.0;
469: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
470: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
471: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
472: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
473: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
474: l_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
467: l_api_name CONSTANT VARCHAR2(30) := 'Config_Callback_Pricing_Order';
468: l_api_version_number CONSTANT NUMBER := 1.0;
469: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
470: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
471: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
472: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
473: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
474: l_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
475: l_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
468: l_api_version_number CONSTANT NUMBER := 1.0;
469: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
470: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
471: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
472: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
473: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
474: l_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
475: l_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
476: l_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
469: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
470: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
471: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
472: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
473: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
474: l_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
475: l_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
476: l_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
477: l_hd_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
470: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
471: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
472: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
473: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
474: l_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
475: l_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
476: l_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
477: l_hd_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
478: l_hd_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
471: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
472: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
473: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
474: l_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
475: l_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
476: l_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
477: l_hd_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
478: l_hd_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
479: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
472: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
473: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
474: l_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
475: l_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
476: l_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
477: l_hd_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
478: l_hd_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
479: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
480: l_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
477: l_hd_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
478: l_hd_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
479: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
480: l_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
481: lx_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
482: lx_req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
483: lx_req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
484: lx_req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
485: lx_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
478: l_hd_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
479: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
480: l_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
481: lx_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
482: lx_req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
483: lx_req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
484: lx_req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
485: lx_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
486: lx_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
479: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
480: l_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
481: lx_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
482: lx_req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
483: lx_req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
484: lx_req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
485: lx_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
486: lx_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
487: lx_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
480: l_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
481: lx_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
482: lx_req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
483: lx_req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
484: lx_req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
485: lx_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
486: lx_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
487: lx_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
488: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
481: lx_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
482: lx_req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
483: lx_req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
484: lx_req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
485: lx_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
486: lx_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
487: lx_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
488: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
489: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
482: lx_req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
483: lx_req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
484: lx_req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
485: lx_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
486: lx_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
487: lx_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
488: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
489: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
490: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
483: lx_req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
484: lx_req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
485: lx_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
486: lx_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
487: lx_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
488: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
489: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
490: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
491: l_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
506: lx_price_adj_rltship_tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
507:
508: l_qte_line_prcd Index_Link_Tbl_Type;
509: l_message_text VARCHAR2(2000);
510: lx_req_line_rec QP_PREQ_GRP.LINE_REC_TYPE;
511: i BINARY_INTEGER;
512: ln_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
513: l_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
514: l_ln_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
627: PROCEDURE Copy_Attribs_To_Req(
628: p_line_index number,
629: p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type,
630: p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type,
631: px_Req_line_attr_tbl IN OUT NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
632: px_Req_qual_tbl IN OUT NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.QUAL_TBL_TYPE)
633: IS
634: l_attr_index number := nvl(px_Req_line_attr_tbl.last,0);
635: l_qual_index number := nvl(px_Req_qual_tbl.last,0);
628: p_line_index number,
629: p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type,
630: p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type,
631: px_Req_line_attr_tbl IN OUT NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
632: px_Req_qual_tbl IN OUT NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.QUAL_TBL_TYPE)
633: IS
634: l_attr_index number := nvl(px_Req_line_attr_tbl.last,0);
635: l_qual_index number := nvl(px_Req_qual_tbl.last,0);
636: BEGIN
675: PROCEDURE Copy_hdr_attr_to_line(
676: p_line_index number,
677: p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type,
678: p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type,
679: px_Req_line_attr_tbl IN OUT NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
680: px_Req_qual_tbl IN OUT NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.QUAL_TBL_TYPE)
681: IS
682: l_attr_index number := nvl(px_Req_line_attr_tbl.last,0);
683: l_qual_index number := nvl(px_Req_qual_tbl.last,0);
676: p_line_index number,
677: p_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type,
678: p_qualifier_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type,
679: px_Req_line_attr_tbl IN OUT NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
680: px_Req_qual_tbl IN OUT NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.QUAL_TBL_TYPE)
681: IS
682: l_attr_index number := nvl(px_Req_line_attr_tbl.last,0);
683: l_qual_index number := nvl(px_Req_qual_tbl.last,0);
684: copy_hdr_rec_to_line_flag boolean := TRUE;
736: procedure Append_asked_for(
737: p_header_id number := null
738: ,p_Line_id number := null
739: ,p_line_index number
740: ,px_Req_line_attr_tbl IN OUT NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
741: ,px_Req_qual_tbl IN OUT NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.QUAL_TBL_TYPE)
742: IS
743: i pls_integer;
744: l_price_list_id NUMBER;
737: p_header_id number := null
738: ,p_Line_id number := null
739: ,p_line_index number
740: ,px_Req_line_attr_tbl IN OUT NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
741: ,px_Req_qual_tbl IN OUT NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.QUAL_TBL_TYPE)
742: IS
743: i pls_integer;
744: l_price_list_id NUMBER;
745:
1674:
1675: procedure Append_asked_for(
1676: p_line_index NUMBER,
1677: p_pricing_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
1678: px_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
1679: px_Req_qual_tbl IN OUT NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.QUAL_TBL_TYPE)
1680: IS
1681: i NUMBER;
1682: l_price_list_id NUMBER;
1675: procedure Append_asked_for(
1676: p_line_index NUMBER,
1677: p_pricing_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
1678: px_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
1679: px_Req_qual_tbl IN OUT NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.QUAL_TBL_TYPE)
1680: IS
1681: i NUMBER;
1682: l_price_list_id NUMBER;
1683: l_pricing_attr_rec ASO_QUOTE_PUB.Price_Attributes_Rec_Type;
2531: procedure copy_Header_to_request(
2532: p_Request_Type VARCHAR2,
2533: p_pricing_event VARCHAR2,
2534: p_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type,
2535: px_req_line_tbl IN OUT NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.LINE_TBL_TYPE)
2536: IS
2537: BEGIN
2538: px_req_line_tbl(1).REQUEST_TYPE_CODE := p_Request_Type;
2539: px_req_line_tbl(1).PRICING_EVENT := p_pricing_event;
2566: p_pricing_event VARCHAR2,
2567: p_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type,
2568: p_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type,
2569: p_control_rec IN ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE,
2570: px_req_line_tbl IN OUT NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.LINE_TBL_TYPE)
2571: is
2572: l_req_line_rec QP_PREQ_GRP.LINE_REC_TYPE;
2573: l_uom_rate NUMBER;
2574: begin
2568: p_line_dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type,
2569: p_control_rec IN ASO_PRICING_INT.PRICING_CONTROL_REC_TYPE,
2570: px_req_line_tbl IN OUT NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.LINE_TBL_TYPE)
2571: is
2572: l_req_line_rec QP_PREQ_GRP.LINE_REC_TYPE;
2573: l_uom_rate NUMBER;
2574: begin
2575: /*
2576: * New Code: Passing quote line id to QP pl/sql tbl
2645: px_req_line_tbl(px_req_line_tbl.count+1) := l_req_line_rec;
2646: end copy_Line_to_request;
2647:
2648: PROCEDURE Copy_Request_To_Quote(
2649: p_req_line_tbl IN QP_PREQ_GRP.LINE_TBL_TYPE,
2650: p_req_line_qual IN QP_PREQ_GRP.QUAL_TBL_TYPE,
2651: p_req_line_attr_tbl IN QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
2652: p_req_line_detail_tbl IN QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
2653: p_req_line_detail_qual_tbl IN QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
2646: end copy_Line_to_request;
2647:
2648: PROCEDURE Copy_Request_To_Quote(
2649: p_req_line_tbl IN QP_PREQ_GRP.LINE_TBL_TYPE,
2650: p_req_line_qual IN QP_PREQ_GRP.QUAL_TBL_TYPE,
2651: p_req_line_attr_tbl IN QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
2652: p_req_line_detail_tbl IN QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
2653: p_req_line_detail_qual_tbl IN QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
2654: p_req_line_detail_attr_tbl IN QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
2647:
2648: PROCEDURE Copy_Request_To_Quote(
2649: p_req_line_tbl IN QP_PREQ_GRP.LINE_TBL_TYPE,
2650: p_req_line_qual IN QP_PREQ_GRP.QUAL_TBL_TYPE,
2651: p_req_line_attr_tbl IN QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
2652: p_req_line_detail_tbl IN QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
2653: p_req_line_detail_qual_tbl IN QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
2654: p_req_line_detail_attr_tbl IN QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
2655: p_req_related_lines_tbl IN QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
2648: PROCEDURE Copy_Request_To_Quote(
2649: p_req_line_tbl IN QP_PREQ_GRP.LINE_TBL_TYPE,
2650: p_req_line_qual IN QP_PREQ_GRP.QUAL_TBL_TYPE,
2651: p_req_line_attr_tbl IN QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
2652: p_req_line_detail_tbl IN QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
2653: p_req_line_detail_qual_tbl IN QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
2654: p_req_line_detail_attr_tbl IN QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
2655: p_req_related_lines_tbl IN QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
2656: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
2649: p_req_line_tbl IN QP_PREQ_GRP.LINE_TBL_TYPE,
2650: p_req_line_qual IN QP_PREQ_GRP.QUAL_TBL_TYPE,
2651: p_req_line_attr_tbl IN QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
2652: p_req_line_detail_tbl IN QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
2653: p_req_line_detail_qual_tbl IN QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
2654: p_req_line_detail_attr_tbl IN QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
2655: p_req_related_lines_tbl IN QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
2656: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
2657: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
2650: p_req_line_qual IN QP_PREQ_GRP.QUAL_TBL_TYPE,
2651: p_req_line_attr_tbl IN QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
2652: p_req_line_detail_tbl IN QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
2653: p_req_line_detail_qual_tbl IN QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
2654: p_req_line_detail_attr_tbl IN QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
2655: p_req_related_lines_tbl IN QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
2656: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
2657: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
2658: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
2651: p_req_line_attr_tbl IN QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
2652: p_req_line_detail_tbl IN QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
2653: p_req_line_detail_qual_tbl IN QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
2654: p_req_line_detail_attr_tbl IN QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
2655: p_req_related_lines_tbl IN QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
2656: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
2657: p_qte_line_tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
2658: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
2659: x_qte_header_rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
2663: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Tbl_Type,
2664: x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type)
2665: IS
2666: l_index NUMBER;
2667: l_req_line_rec QP_PREQ_GRP.LINE_REC_TYPE;
2668: l_req_line_dtl_rec QP_PREQ_GRP.LINE_DETAIL_REC_TYPE;
2669: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
2670: i BINARY_INTEGER;
2671: j BINARY_INTEGER;
2664: x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type)
2665: IS
2666: l_index NUMBER;
2667: l_req_line_rec QP_PREQ_GRP.LINE_REC_TYPE;
2668: l_req_line_dtl_rec QP_PREQ_GRP.LINE_DETAIL_REC_TYPE;
2669: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
2670: i BINARY_INTEGER;
2671: j BINARY_INTEGER;
2672: l_base_price NUMBER := FND_API.G_MISS_NUM;
2737: aso_debug_pub.add('ASO_PRICING_CALLBACK_PVT:Status_code for line_detail_tbl: '
2738: ||p_req_line_tbl(l_index).status_code,1,'N');
2739: END IF;
2740: IF p_req_line_tbl(l_index).status_code in (
2741: QP_PREQ_GRP.G_STATUS_UPDATED,
2742: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION,
2743: QP_PREQ_GRP.G_STATUS_UNCHANGED)
2744: THEN
2745: l_req_line_dtl_rec := p_req_line_detail_Tbl(i);
2738: ||p_req_line_tbl(l_index).status_code,1,'N');
2739: END IF;
2740: IF p_req_line_tbl(l_index).status_code in (
2741: QP_PREQ_GRP.G_STATUS_UPDATED,
2742: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION,
2743: QP_PREQ_GRP.G_STATUS_UNCHANGED)
2744: THEN
2745: l_req_line_dtl_rec := p_req_line_detail_Tbl(i);
2746: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2739: END IF;
2740: IF p_req_line_tbl(l_index).status_code in (
2741: QP_PREQ_GRP.G_STATUS_UPDATED,
2742: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION,
2743: QP_PREQ_GRP.G_STATUS_UNCHANGED)
2744: THEN
2745: l_req_line_dtl_rec := p_req_line_detail_Tbl(i);
2746: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
2747: aso_debug_pub.add('ASO_PRICING_CALLBACK_PVT:Req_Line_dtl_rec.created_from_list_type_code:'
2822: aso_debug_pub.add('ASO_PRICING_CALLBACK_PVT:Req_Line_dtl_rec.Relationship_Type_Code:'
2823: ||p_Req_Related_Lines_Tbl(i).Relationship_Type_Code, 1, 'N');
2824: END IF;
2825: IF p_Req_Related_Lines_Tbl(i).Relationship_Type_Code
2826: IN (QP_PREQ_GRP.G_PBH_LINE ,QP_PREQ_GRP.G_GENERATED_LINE )
2827: AND p_req_related_lines_tbl(i).LINE_DETAIL_INDEX is not null
2828: AND p_req_related_lines_tbl(i).RELATED_LINE_DETAIL_INDEX is not null
2829: AND lx_price_adj_prcd.EXISTS(p_req_related_lines_tbl(i).LINE_DETAIL_INDEX)
2830: AND lx_price_adj_prcd.EXISTS(p_req_related_lines_tbl(i).RELATED_LINE_DETAIL_INDEX)
2880: PROCEDURE Copy_Req_Dtl_To_Price_Adj (
2881: p_qte_line_index IN NUMBER,
2882: p_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
2883: p_req_line_dtl_index IN NUMBER,
2884: p_req_line_detail_rec IN QP_PREQ_GRP.LINE_DETAIL_REC_TYPE,
2885: p_req_line_detail_qual_tbl IN QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
2886: p_req_line_detail_attr_tbl IN QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
2887: px_price_adj_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
2888: px_price_adj_attr_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Tbl_Type,
2881: p_qte_line_index IN NUMBER,
2882: p_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
2883: p_req_line_dtl_index IN NUMBER,
2884: p_req_line_detail_rec IN QP_PREQ_GRP.LINE_DETAIL_REC_TYPE,
2885: p_req_line_detail_qual_tbl IN QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
2886: p_req_line_detail_attr_tbl IN QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
2887: px_price_adj_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
2888: px_price_adj_attr_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Tbl_Type,
2889: px_price_adj_prcd IN OUT NOCOPY /* file.sql.39 change */ Index_Link_Tbl_Type)
2882: p_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
2883: p_req_line_dtl_index IN NUMBER,
2884: p_req_line_detail_rec IN QP_PREQ_GRP.LINE_DETAIL_REC_TYPE,
2885: p_req_line_detail_qual_tbl IN QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
2886: p_req_line_detail_attr_tbl IN QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
2887: px_price_adj_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
2888: px_price_adj_attr_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Tbl_Type,
2889: px_price_adj_prcd IN OUT NOCOPY /* file.sql.39 change */ Index_Link_Tbl_Type)
2890: IS
2992:
2993: PROCEDURE Copy_Req_Dtl_To_Price_Adj (
2994: p_qte_header_rec IN ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE,
2995: p_req_line_dtl_index IN NUMBER,
2996: p_req_line_detail_rec IN QP_PREQ_GRP.LINE_DETAIL_REC_TYPE,
2997: p_req_line_detail_qual_tbl IN QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
2998: p_req_line_detail_attr_tbl IN QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
2999: px_price_adj_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
3000: px_price_adj_attr_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Tbl_Type,
2993: PROCEDURE Copy_Req_Dtl_To_Price_Adj (
2994: p_qte_header_rec IN ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE,
2995: p_req_line_dtl_index IN NUMBER,
2996: p_req_line_detail_rec IN QP_PREQ_GRP.LINE_DETAIL_REC_TYPE,
2997: p_req_line_detail_qual_tbl IN QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
2998: p_req_line_detail_attr_tbl IN QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
2999: px_price_adj_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
3000: px_price_adj_attr_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Tbl_Type,
3001: px_price_adj_prcd IN OUT NOCOPY /* file.sql.39 change */ Index_Link_Tbl_Type)
2994: p_qte_header_rec IN ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE,
2995: p_req_line_dtl_index IN NUMBER,
2996: p_req_line_detail_rec IN QP_PREQ_GRP.LINE_DETAIL_REC_TYPE,
2997: p_req_line_detail_qual_tbl IN QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
2998: p_req_line_detail_attr_tbl IN QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
2999: px_price_adj_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
3000: px_price_adj_attr_tbl IN OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Tbl_Type,
3001: px_price_adj_prcd IN OUT NOCOPY /* file.sql.39 change */ Index_Link_Tbl_Type)
3002: IS
3094: -- This is the right version as per vakapoor.
3095: -- Original One was giving no data found.
3096:
3097: PROCEDURE Copy_Request_To_Line(
3098: p_req_line_tbl IN QP_PREQ_GRP.LINE_TBL_TYPE,
3099: p_req_line_qual IN QP_PREQ_GRP.QUAL_TBL_TYPE,
3100: p_req_line_attr_tbl IN QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
3101: p_req_line_detail_tbl IN QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
3102: p_req_line_detail_qual_tbl IN QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
3095: -- Original One was giving no data found.
3096:
3097: PROCEDURE Copy_Request_To_Line(
3098: p_req_line_tbl IN QP_PREQ_GRP.LINE_TBL_TYPE,
3099: p_req_line_qual IN QP_PREQ_GRP.QUAL_TBL_TYPE,
3100: p_req_line_attr_tbl IN QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
3101: p_req_line_detail_tbl IN QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
3102: p_req_line_detail_qual_tbl IN QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
3103: p_req_line_detail_attr_tbl IN QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
3096:
3097: PROCEDURE Copy_Request_To_Line(
3098: p_req_line_tbl IN QP_PREQ_GRP.LINE_TBL_TYPE,
3099: p_req_line_qual IN QP_PREQ_GRP.QUAL_TBL_TYPE,
3100: p_req_line_attr_tbl IN QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
3101: p_req_line_detail_tbl IN QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
3102: p_req_line_detail_qual_tbl IN QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
3103: p_req_line_detail_attr_tbl IN QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
3104: p_req_related_lines_tbl IN QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
3097: PROCEDURE Copy_Request_To_Line(
3098: p_req_line_tbl IN QP_PREQ_GRP.LINE_TBL_TYPE,
3099: p_req_line_qual IN QP_PREQ_GRP.QUAL_TBL_TYPE,
3100: p_req_line_attr_tbl IN QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
3101: p_req_line_detail_tbl IN QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
3102: p_req_line_detail_qual_tbl IN QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
3103: p_req_line_detail_attr_tbl IN QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
3104: p_req_related_lines_tbl IN QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
3105: p_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
3098: p_req_line_tbl IN QP_PREQ_GRP.LINE_TBL_TYPE,
3099: p_req_line_qual IN QP_PREQ_GRP.QUAL_TBL_TYPE,
3100: p_req_line_attr_tbl IN QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
3101: p_req_line_detail_tbl IN QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
3102: p_req_line_detail_qual_tbl IN QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
3103: p_req_line_detail_attr_tbl IN QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
3104: p_req_related_lines_tbl IN QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
3105: p_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
3106: p_qte_line_dtl_rec IN ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type,
3099: p_req_line_qual IN QP_PREQ_GRP.QUAL_TBL_TYPE,
3100: p_req_line_attr_tbl IN QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
3101: p_req_line_detail_tbl IN QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
3102: p_req_line_detail_qual_tbl IN QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
3103: p_req_line_detail_attr_tbl IN QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
3104: p_req_related_lines_tbl IN QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
3105: p_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
3106: p_qte_line_dtl_rec IN ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type,
3107: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
3100: p_req_line_attr_tbl IN QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
3101: p_req_line_detail_tbl IN QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
3102: p_req_line_detail_qual_tbl IN QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
3103: p_req_line_detail_attr_tbl IN QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
3104: p_req_related_lines_tbl IN QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
3105: p_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
3106: p_qte_line_dtl_rec IN ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type,
3107: x_qte_line_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
3108: x_qte_line_dtl_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
3110: x_price_adj_attr_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.PRICE_ADJ_ATTR_Tbl_Type,
3111: x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type)
3112: IS
3113: l_index NUMBER;
3114: l_req_line_rec QP_PREQ_GRP.LINE_REC_TYPE;
3115: l_req_line_dtl_rec QP_PREQ_GRP.LINE_DETAIL_REC_TYPE;
3116: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
3117: i BINARY_INTEGER;
3118: j BINARY_INTEGER;
3111: x_price_adj_rltship_tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type)
3112: IS
3113: l_index NUMBER;
3114: l_req_line_rec QP_PREQ_GRP.LINE_REC_TYPE;
3115: l_req_line_dtl_rec QP_PREQ_GRP.LINE_DETAIL_REC_TYPE;
3116: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
3117: i BINARY_INTEGER;
3118: j BINARY_INTEGER;
3119: l_base_price NUMBER := FND_API.G_MISS_NUM;
3138: ||l_req_line_rec.status_code,1,'Y');
3139: END IF;
3140:
3141: IF l_req_line_rec.line_type_code = 'LINE' AND
3142: l_req_line_rec.status_code in ( QP_PREQ_GRP.G_STATUS_UPDATED,
3143: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION,
3144: QP_PREQ_GRP.G_STATUS_UNCHANGED)
3145:
3146: Then
3139: END IF;
3140:
3141: IF l_req_line_rec.line_type_code = 'LINE' AND
3142: l_req_line_rec.status_code in ( QP_PREQ_GRP.G_STATUS_UPDATED,
3143: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION,
3144: QP_PREQ_GRP.G_STATUS_UNCHANGED)
3145:
3146: Then
3147: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3140:
3141: IF l_req_line_rec.line_type_code = 'LINE' AND
3142: l_req_line_rec.status_code in ( QP_PREQ_GRP.G_STATUS_UPDATED,
3143: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION,
3144: QP_PREQ_GRP.G_STATUS_UNCHANGED)
3145:
3146: Then
3147: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3148: aso_debug_pub.add('ASO_PRICING_CORE_PVT:In Copy Req to line in ELSEIF',1,'Y');
3184: j := p_req_related_lines_tbl.first;
3185: WHILE j IS NOT NULL AND l_base_price = FND_API.G_MISS_NUM LOOP
3186: IF p_req_related_lines_tbl(j).line_index = i AND
3187: p_req_related_lines_tbl(j).relationship_type_code =
3188: QP_PREQ_GRP.G_RELATED_ITEM_PRICE THEN
3189: l_base_price := p_req_line_tbl(p_req_related_lines_tbl(j).related_line_index).unit_price;
3190: END IF;
3191: j := p_req_related_lines_tbl.NEXT(j);
3192: END LOOP;