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_PRICING_INT dependencies on QP_PREQ_GRP

Line 572: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;

568: l_api_name CONSTANT VARCHAR2(30) := 'Pricing_Item';
569: l_api_version_number CONSTANT NUMBER := 1.0;
570: l_request_type VARCHAR2(60);
571: l_pricing_event VARCHAR2(30);
572: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
573: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
574: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
575: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
576: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;

Line 573: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;

569: l_api_version_number CONSTANT NUMBER := 1.0;
570: l_request_type VARCHAR2(60);
571: l_pricing_event VARCHAR2(30);
572: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
573: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
574: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
575: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
576: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
577: l_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;

Line 574: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;

570: l_request_type VARCHAR2(60);
571: l_pricing_event VARCHAR2(30);
572: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
573: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
574: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
575: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
576: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
577: l_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
578: l_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;

Line 575: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;

571: l_pricing_event VARCHAR2(30);
572: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
573: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
574: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
575: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
576: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
577: l_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
578: l_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
579: l_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;

Line 576: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;

572: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
573: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
574: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
575: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
576: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
577: l_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
578: l_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
579: l_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
580: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;

Line 577: l_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;

573: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
574: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
575: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
576: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
577: l_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
578: l_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
579: l_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
580: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
581: l_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;

Line 578: l_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;

574: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
575: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
576: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
577: l_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
578: l_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
579: l_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
580: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
581: l_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
582: lx_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;

Line 579: l_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;

575: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
576: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
577: l_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
578: l_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
579: l_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
580: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
581: l_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
582: lx_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
583: lx_req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;

Line 582: lx_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;

578: l_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
579: l_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
580: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
581: l_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
582: lx_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
583: lx_req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
584: lx_req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
585: lx_req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
586: lx_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;

Line 583: lx_req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;

579: l_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
580: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
581: l_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
582: lx_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
583: lx_req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
584: lx_req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
585: lx_req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
586: lx_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
587: lx_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;

Line 584: lx_req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;

580: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
581: l_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
582: lx_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
583: lx_req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
584: lx_req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
585: lx_req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
586: lx_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
587: lx_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
588: lx_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;

Line 585: lx_req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;

581: l_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
582: lx_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
583: lx_req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
584: lx_req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
585: lx_req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
586: lx_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
587: lx_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
588: lx_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
589: l_return_status VARCHAR2(1);

Line 586: lx_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;

582: lx_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
583: lx_req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
584: lx_req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
585: lx_req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
586: lx_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
587: lx_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
588: lx_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
589: l_return_status VARCHAR2(1);
590: l_return_status_text VARCHAR2(2000);

Line 587: lx_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;

583: lx_req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
584: lx_req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
585: lx_req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
586: lx_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
587: lx_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
588: lx_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
589: l_return_status VARCHAR2(1);
590: l_return_status_text VARCHAR2(2000);
591: l_message_text VARCHAR2(2000);

Line 588: lx_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;

584: lx_req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
585: lx_req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
586: lx_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
587: lx_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
588: lx_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
589: l_return_status VARCHAR2(1);
590: l_return_status_text VARCHAR2(2000);
591: l_message_text VARCHAR2(2000);
592: lx_req_line_rec QP_PREQ_GRP.LINE_REC_TYPE;

Line 592: lx_req_line_rec QP_PREQ_GRP.LINE_REC_TYPE;

588: lx_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
589: l_return_status VARCHAR2(1);
590: l_return_status_text VARCHAR2(2000);
591: l_message_text VARCHAR2(2000);
592: lx_req_line_rec QP_PREQ_GRP.LINE_REC_TYPE;
593: lv_return_status VARCHAR2(1);
594: i BINARY_INTEGER;
595: l_hd_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
596: l_hd_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;

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

771: aso_debug_pub.add('ASO_PRICING_INT:In Pricing Item: l_request_type'||l_request_type,1,'Y');
772: END IF;
773:
774:
775: /* Change for populating QP_PREQ_GRP.CONTROL_RECORD_TYPE.ORG_ID Yogeshwar (MOAC) */
776:
777: IF ((p_qte_header_rec.org_id IS NULL) OR (p_qte_header_rec.org_id = FND_API.G_MISS_NUM)) THEN
778: IF fnd_msg_pub.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
779: FND_MESSAGE.Set_Name('ASO', 'ASO_MISSING_OU');

Line 820: If lx_req_line_rec.status_code in(QP_PREQ_GRP.g_status_invalid_price_list,

816:
817: i := lx_req_line_tbl.FIRST;
818: WHILE i IS NOT NULL LOOP
819: lx_req_line_rec := lx_req_line_tbl(i);
820: If lx_req_line_rec.status_code in(QP_PREQ_GRP.g_status_invalid_price_list,
821: QP_PREQ_GRP.g_sts_lhs_not_found,
822: QP_PREQ_GRP.g_status_formula_error,QP_PREQ_GRP.g_status_other_errors,
823: fnd_api.g_ret_sts_unexp_error,fnd_api.g_ret_sts_error,
824: QP_PREQ_GRP.g_status_calc_error,QP_PREQ_GRP.g_status_uom_failure,

Line 821: QP_PREQ_GRP.g_sts_lhs_not_found,

817: i := lx_req_line_tbl.FIRST;
818: WHILE i IS NOT NULL LOOP
819: lx_req_line_rec := lx_req_line_tbl(i);
820: If lx_req_line_rec.status_code in(QP_PREQ_GRP.g_status_invalid_price_list,
821: QP_PREQ_GRP.g_sts_lhs_not_found,
822: QP_PREQ_GRP.g_status_formula_error,QP_PREQ_GRP.g_status_other_errors,
823: fnd_api.g_ret_sts_unexp_error,fnd_api.g_ret_sts_error,
824: QP_PREQ_GRP.g_status_calc_error,QP_PREQ_GRP.g_status_uom_failure,
825: QP_PREQ_GRP.g_status_invalid_uom,QP_PREQ_GRP.g_status_dup_price_list,

Line 822: QP_PREQ_GRP.g_status_formula_error,QP_PREQ_GRP.g_status_other_errors,

818: WHILE i IS NOT NULL LOOP
819: lx_req_line_rec := lx_req_line_tbl(i);
820: If lx_req_line_rec.status_code in(QP_PREQ_GRP.g_status_invalid_price_list,
821: QP_PREQ_GRP.g_sts_lhs_not_found,
822: QP_PREQ_GRP.g_status_formula_error,QP_PREQ_GRP.g_status_other_errors,
823: fnd_api.g_ret_sts_unexp_error,fnd_api.g_ret_sts_error,
824: QP_PREQ_GRP.g_status_calc_error,QP_PREQ_GRP.g_status_uom_failure,
825: QP_PREQ_GRP.g_status_invalid_uom,QP_PREQ_GRP.g_status_dup_price_list,
826: QP_PREQ_GRP.g_status_invalid_uom_conv,QP_PREQ_GRP.g_status_invalid_incomp,

Line 824: QP_PREQ_GRP.g_status_calc_error,QP_PREQ_GRP.g_status_uom_failure,

820: If lx_req_line_rec.status_code in(QP_PREQ_GRP.g_status_invalid_price_list,
821: QP_PREQ_GRP.g_sts_lhs_not_found,
822: QP_PREQ_GRP.g_status_formula_error,QP_PREQ_GRP.g_status_other_errors,
823: fnd_api.g_ret_sts_unexp_error,fnd_api.g_ret_sts_error,
824: QP_PREQ_GRP.g_status_calc_error,QP_PREQ_GRP.g_status_uom_failure,
825: QP_PREQ_GRP.g_status_invalid_uom,QP_PREQ_GRP.g_status_dup_price_list,
826: QP_PREQ_GRP.g_status_invalid_uom_conv,QP_PREQ_GRP.g_status_invalid_incomp,
827: QP_PREQ_GRP.g_status_best_price_eval_error,
828: QP_PREQ_PUB.g_back_calculation_sts) THEN

Line 825: QP_PREQ_GRP.g_status_invalid_uom,QP_PREQ_GRP.g_status_dup_price_list,

821: QP_PREQ_GRP.g_sts_lhs_not_found,
822: QP_PREQ_GRP.g_status_formula_error,QP_PREQ_GRP.g_status_other_errors,
823: fnd_api.g_ret_sts_unexp_error,fnd_api.g_ret_sts_error,
824: QP_PREQ_GRP.g_status_calc_error,QP_PREQ_GRP.g_status_uom_failure,
825: QP_PREQ_GRP.g_status_invalid_uom,QP_PREQ_GRP.g_status_dup_price_list,
826: QP_PREQ_GRP.g_status_invalid_uom_conv,QP_PREQ_GRP.g_status_invalid_incomp,
827: QP_PREQ_GRP.g_status_best_price_eval_error,
828: QP_PREQ_PUB.g_back_calculation_sts) THEN
829: x_return_status := FND_API.G_RET_STS_ERROR;

Line 826: QP_PREQ_GRP.g_status_invalid_uom_conv,QP_PREQ_GRP.g_status_invalid_incomp,

822: QP_PREQ_GRP.g_status_formula_error,QP_PREQ_GRP.g_status_other_errors,
823: fnd_api.g_ret_sts_unexp_error,fnd_api.g_ret_sts_error,
824: QP_PREQ_GRP.g_status_calc_error,QP_PREQ_GRP.g_status_uom_failure,
825: QP_PREQ_GRP.g_status_invalid_uom,QP_PREQ_GRP.g_status_dup_price_list,
826: QP_PREQ_GRP.g_status_invalid_uom_conv,QP_PREQ_GRP.g_status_invalid_incomp,
827: QP_PREQ_GRP.g_status_best_price_eval_error,
828: QP_PREQ_PUB.g_back_calculation_sts) THEN
829: x_return_status := FND_API.G_RET_STS_ERROR;
830: END IF;

Line 827: QP_PREQ_GRP.g_status_best_price_eval_error,

823: fnd_api.g_ret_sts_unexp_error,fnd_api.g_ret_sts_error,
824: QP_PREQ_GRP.g_status_calc_error,QP_PREQ_GRP.g_status_uom_failure,
825: QP_PREQ_GRP.g_status_invalid_uom,QP_PREQ_GRP.g_status_dup_price_list,
826: QP_PREQ_GRP.g_status_invalid_uom_conv,QP_PREQ_GRP.g_status_invalid_incomp,
827: QP_PREQ_GRP.g_status_best_price_eval_error,
828: QP_PREQ_PUB.g_back_calculation_sts) THEN
829: x_return_status := FND_API.G_RET_STS_ERROR;
830: END IF;
831:

Line 1437: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;

1433: IS
1434:
1435: l_api_name CONSTANT VARCHAR2(30) := 'Pricing_Order';
1436: l_api_version_number CONSTANT NUMBER := 1.0;
1437: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
1438: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
1439: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
1440: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
1441: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;

Line 1438: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;

1434:
1435: l_api_name CONSTANT VARCHAR2(30) := 'Pricing_Order';
1436: l_api_version_number CONSTANT NUMBER := 1.0;
1437: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
1438: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
1439: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
1440: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
1441: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
1442: l_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;

Line 1439: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;

1435: l_api_name CONSTANT VARCHAR2(30) := 'Pricing_Order';
1436: l_api_version_number CONSTANT NUMBER := 1.0;
1437: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
1438: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
1439: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
1440: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
1441: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
1442: l_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
1443: l_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;

Line 1440: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;

1436: l_api_version_number CONSTANT NUMBER := 1.0;
1437: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
1438: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
1439: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
1440: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
1441: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
1442: l_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
1443: l_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
1444: l_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;

Line 1441: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;

1437: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
1438: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
1439: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
1440: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
1441: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
1442: l_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
1443: l_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
1444: l_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
1445: l_hd_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;

Line 1442: l_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;

1438: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
1439: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
1440: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
1441: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
1442: l_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
1443: l_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
1444: l_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
1445: l_hd_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1446: l_hd_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;

Line 1443: l_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;

1439: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
1440: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
1441: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
1442: l_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
1443: l_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
1444: l_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
1445: l_hd_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1446: l_hd_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1447: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;

Line 1444: l_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;

1440: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
1441: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
1442: l_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
1443: l_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
1444: l_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
1445: l_hd_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1446: l_hd_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1447: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1448: l_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;

Line 1449: lx_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;

1445: l_hd_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1446: l_hd_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1447: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1448: l_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1449: lx_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
1450: lx_req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
1451: lx_req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
1452: lx_req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
1453: lx_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;

Line 1450: lx_req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;

1446: l_hd_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1447: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1448: l_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1449: lx_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
1450: lx_req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
1451: lx_req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
1452: lx_req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
1453: lx_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
1454: lx_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;

Line 1451: lx_req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;

1447: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1448: l_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1449: lx_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
1450: lx_req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
1451: lx_req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
1452: lx_req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
1453: lx_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
1454: lx_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
1455: lx_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;

Line 1452: lx_req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;

1448: l_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1449: lx_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
1450: lx_req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
1451: lx_req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
1452: lx_req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
1453: lx_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
1454: lx_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
1455: lx_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
1456: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;

Line 1453: lx_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;

1449: lx_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
1450: lx_req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
1451: lx_req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
1452: lx_req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
1453: lx_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
1454: lx_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
1455: lx_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
1456: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1457: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

Line 1454: lx_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;

1450: lx_req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
1451: lx_req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
1452: lx_req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
1453: lx_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
1454: lx_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
1455: lx_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
1456: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1457: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1458: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;

Line 1455: lx_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;

1451: lx_req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
1452: lx_req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
1453: lx_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
1454: lx_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
1455: lx_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
1456: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1457: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1458: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1459: l_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;