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 760: /* Change for populating QP_PREQ_GRP.CONTROL_RECORD_TYPE.ORG_ID Yogeshwar (MOAC) */

756: aso_debug_pub.add('ASO_PRICING_INT:In Pricing Item: l_request_type'||l_request_type,1,'Y');
757: END IF;
758:
759:
760: /* Change for populating QP_PREQ_GRP.CONTROL_RECORD_TYPE.ORG_ID Yogeshwar (MOAC) */
761:
762: IF ((p_qte_header_rec.org_id IS NULL) OR (p_qte_header_rec.org_id = FND_API.G_MISS_NUM)) THEN
763: IF fnd_msg_pub.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
764: FND_MESSAGE.Set_Name('ASO', 'ASO_MISSING_OU');

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

801:
802: i := lx_req_line_tbl.FIRST;
803: WHILE i IS NOT NULL LOOP
804: lx_req_line_rec := lx_req_line_tbl(i);
805: If lx_req_line_rec.status_code in(QP_PREQ_GRP.g_status_invalid_price_list,
806: QP_PREQ_GRP.g_sts_lhs_not_found,
807: QP_PREQ_GRP.g_status_formula_error,QP_PREQ_GRP.g_status_other_errors,
808: fnd_api.g_ret_sts_unexp_error,fnd_api.g_ret_sts_error,
809: QP_PREQ_GRP.g_status_calc_error,QP_PREQ_GRP.g_status_uom_failure,

Line 806: QP_PREQ_GRP.g_sts_lhs_not_found,

802: i := lx_req_line_tbl.FIRST;
803: WHILE i IS NOT NULL LOOP
804: lx_req_line_rec := lx_req_line_tbl(i);
805: If lx_req_line_rec.status_code in(QP_PREQ_GRP.g_status_invalid_price_list,
806: QP_PREQ_GRP.g_sts_lhs_not_found,
807: QP_PREQ_GRP.g_status_formula_error,QP_PREQ_GRP.g_status_other_errors,
808: fnd_api.g_ret_sts_unexp_error,fnd_api.g_ret_sts_error,
809: QP_PREQ_GRP.g_status_calc_error,QP_PREQ_GRP.g_status_uom_failure,
810: QP_PREQ_GRP.g_status_invalid_uom,QP_PREQ_GRP.g_status_dup_price_list,

Line 807: QP_PREQ_GRP.g_status_formula_error,QP_PREQ_GRP.g_status_other_errors,

803: WHILE i IS NOT NULL LOOP
804: lx_req_line_rec := lx_req_line_tbl(i);
805: If lx_req_line_rec.status_code in(QP_PREQ_GRP.g_status_invalid_price_list,
806: QP_PREQ_GRP.g_sts_lhs_not_found,
807: QP_PREQ_GRP.g_status_formula_error,QP_PREQ_GRP.g_status_other_errors,
808: fnd_api.g_ret_sts_unexp_error,fnd_api.g_ret_sts_error,
809: QP_PREQ_GRP.g_status_calc_error,QP_PREQ_GRP.g_status_uom_failure,
810: QP_PREQ_GRP.g_status_invalid_uom,QP_PREQ_GRP.g_status_dup_price_list,
811: QP_PREQ_GRP.g_status_invalid_uom_conv,QP_PREQ_GRP.g_status_invalid_incomp,

Line 809: QP_PREQ_GRP.g_status_calc_error,QP_PREQ_GRP.g_status_uom_failure,

805: If lx_req_line_rec.status_code in(QP_PREQ_GRP.g_status_invalid_price_list,
806: QP_PREQ_GRP.g_sts_lhs_not_found,
807: QP_PREQ_GRP.g_status_formula_error,QP_PREQ_GRP.g_status_other_errors,
808: fnd_api.g_ret_sts_unexp_error,fnd_api.g_ret_sts_error,
809: QP_PREQ_GRP.g_status_calc_error,QP_PREQ_GRP.g_status_uom_failure,
810: QP_PREQ_GRP.g_status_invalid_uom,QP_PREQ_GRP.g_status_dup_price_list,
811: QP_PREQ_GRP.g_status_invalid_uom_conv,QP_PREQ_GRP.g_status_invalid_incomp,
812: QP_PREQ_GRP.g_status_best_price_eval_error,
813: QP_PREQ_PUB.g_back_calculation_sts) THEN

Line 810: QP_PREQ_GRP.g_status_invalid_uom,QP_PREQ_GRP.g_status_dup_price_list,

806: QP_PREQ_GRP.g_sts_lhs_not_found,
807: QP_PREQ_GRP.g_status_formula_error,QP_PREQ_GRP.g_status_other_errors,
808: fnd_api.g_ret_sts_unexp_error,fnd_api.g_ret_sts_error,
809: QP_PREQ_GRP.g_status_calc_error,QP_PREQ_GRP.g_status_uom_failure,
810: QP_PREQ_GRP.g_status_invalid_uom,QP_PREQ_GRP.g_status_dup_price_list,
811: QP_PREQ_GRP.g_status_invalid_uom_conv,QP_PREQ_GRP.g_status_invalid_incomp,
812: QP_PREQ_GRP.g_status_best_price_eval_error,
813: QP_PREQ_PUB.g_back_calculation_sts) THEN
814: x_return_status := FND_API.G_RET_STS_ERROR;

Line 811: QP_PREQ_GRP.g_status_invalid_uom_conv,QP_PREQ_GRP.g_status_invalid_incomp,

807: QP_PREQ_GRP.g_status_formula_error,QP_PREQ_GRP.g_status_other_errors,
808: fnd_api.g_ret_sts_unexp_error,fnd_api.g_ret_sts_error,
809: QP_PREQ_GRP.g_status_calc_error,QP_PREQ_GRP.g_status_uom_failure,
810: QP_PREQ_GRP.g_status_invalid_uom,QP_PREQ_GRP.g_status_dup_price_list,
811: QP_PREQ_GRP.g_status_invalid_uom_conv,QP_PREQ_GRP.g_status_invalid_incomp,
812: QP_PREQ_GRP.g_status_best_price_eval_error,
813: QP_PREQ_PUB.g_back_calculation_sts) THEN
814: x_return_status := FND_API.G_RET_STS_ERROR;
815: END IF;

Line 812: QP_PREQ_GRP.g_status_best_price_eval_error,

808: fnd_api.g_ret_sts_unexp_error,fnd_api.g_ret_sts_error,
809: QP_PREQ_GRP.g_status_calc_error,QP_PREQ_GRP.g_status_uom_failure,
810: QP_PREQ_GRP.g_status_invalid_uom,QP_PREQ_GRP.g_status_dup_price_list,
811: QP_PREQ_GRP.g_status_invalid_uom_conv,QP_PREQ_GRP.g_status_invalid_incomp,
812: QP_PREQ_GRP.g_status_best_price_eval_error,
813: QP_PREQ_PUB.g_back_calculation_sts) THEN
814: x_return_status := FND_API.G_RET_STS_ERROR;
815: END IF;
816:

Line 1422: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;

1418: IS
1419:
1420: l_api_name CONSTANT VARCHAR2(30) := 'Pricing_Order';
1421: l_api_version_number CONSTANT NUMBER := 1.0;
1422: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
1423: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
1424: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
1425: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
1426: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;

Line 1423: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;

1419:
1420: l_api_name CONSTANT VARCHAR2(30) := 'Pricing_Order';
1421: l_api_version_number CONSTANT NUMBER := 1.0;
1422: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
1423: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
1424: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
1425: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
1426: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
1427: l_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;

Line 1424: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;

1420: l_api_name CONSTANT VARCHAR2(30) := 'Pricing_Order';
1421: l_api_version_number CONSTANT NUMBER := 1.0;
1422: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
1423: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
1424: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
1425: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
1426: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
1427: l_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
1428: l_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;

Line 1425: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;

1421: l_api_version_number CONSTANT NUMBER := 1.0;
1422: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
1423: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
1424: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
1425: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
1426: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
1427: l_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
1428: l_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
1429: l_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;

Line 1426: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;

1422: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
1423: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
1424: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
1425: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
1426: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
1427: l_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
1428: l_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
1429: l_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
1430: l_hd_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;

Line 1427: l_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;

1423: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
1424: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
1425: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
1426: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
1427: l_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
1428: l_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
1429: l_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
1430: l_hd_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1431: l_hd_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;

Line 1428: l_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;

1424: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
1425: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
1426: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
1427: l_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
1428: l_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
1429: l_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
1430: l_hd_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1431: l_hd_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1432: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;

Line 1429: l_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;

1425: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
1426: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
1427: l_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
1428: l_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
1429: l_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
1430: l_hd_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1431: l_hd_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1432: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1433: l_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;

Line 1434: lx_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;

1430: l_hd_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1431: l_hd_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1432: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1433: l_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1434: lx_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
1435: lx_req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
1436: lx_req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
1437: lx_req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
1438: lx_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;

Line 1435: lx_req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;

1431: l_hd_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1432: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1433: l_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1434: lx_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
1435: lx_req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
1436: lx_req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
1437: lx_req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
1438: lx_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
1439: lx_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;

Line 1436: lx_req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;

1432: l_pricing_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1433: l_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1434: lx_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
1435: lx_req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
1436: lx_req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
1437: lx_req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
1438: lx_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
1439: lx_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
1440: lx_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;

Line 1437: lx_req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;

1433: l_qual_contexts_Tbl QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type;
1434: lx_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
1435: lx_req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
1436: lx_req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
1437: lx_req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
1438: lx_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
1439: lx_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
1440: lx_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
1441: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;

Line 1438: lx_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;

1434: lx_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
1435: lx_req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
1436: lx_req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
1437: lx_req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
1438: lx_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
1439: lx_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
1440: lx_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
1441: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1442: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

Line 1439: lx_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;

1435: lx_req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
1436: lx_req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
1437: lx_req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
1438: lx_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
1439: lx_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
1440: lx_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
1441: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1442: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1443: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;

Line 1440: lx_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;

1436: lx_req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
1437: lx_req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
1438: lx_req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
1439: lx_req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
1440: lx_req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
1441: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1442: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1443: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1444: l_price_attr_tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;