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.OZF_ADJUSTMENT_EXT_PVT dependencies on QP_PREQ_GRP

Line 2803: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;

2799: l_ignore NUMBER;
2800: l_product_stmt VARCHAR2(32000) := NULL;
2801: l_count_temp NUMBER;
2802: l_stmt_order VARCHAR2(32000) := NULL;
2803: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
2804: l_org_match VARCHAR2(1);
2805: l_currency_match VARCHAR2(1);
2806: l_uom_match VARCHAR2(1);
2807: l_additional_qualifier_match VARCHAR2(1);

Line 2826: G_LINE_INDEX_tbl QP_PREQ_GRP.pls_integer_type;

2822: l_request_id NUMBER;
2823:
2824:
2825:
2826: G_LINE_INDEX_tbl QP_PREQ_GRP.pls_integer_type;
2827: G_LINE_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2828: G_PRICING_EFFECTIVE_DATE_TBL QP_PREQ_GRP.DATE_TYPE ;
2829: G_ACTIVE_DATE_FIRST_TBL QP_PREQ_GRP.DATE_TYPE ;
2830: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 2827: G_LINE_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

2823:
2824:
2825:
2826: G_LINE_INDEX_tbl QP_PREQ_GRP.pls_integer_type;
2827: G_LINE_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2828: G_PRICING_EFFECTIVE_DATE_TBL QP_PREQ_GRP.DATE_TYPE ;
2829: G_ACTIVE_DATE_FIRST_TBL QP_PREQ_GRP.DATE_TYPE ;
2830: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2831: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;

Line 2828: G_PRICING_EFFECTIVE_DATE_TBL QP_PREQ_GRP.DATE_TYPE ;

2824:
2825:
2826: G_LINE_INDEX_tbl QP_PREQ_GRP.pls_integer_type;
2827: G_LINE_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2828: G_PRICING_EFFECTIVE_DATE_TBL QP_PREQ_GRP.DATE_TYPE ;
2829: G_ACTIVE_DATE_FIRST_TBL QP_PREQ_GRP.DATE_TYPE ;
2830: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2831: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
2832: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;

Line 2829: G_ACTIVE_DATE_FIRST_TBL QP_PREQ_GRP.DATE_TYPE ;

2825:
2826: G_LINE_INDEX_tbl QP_PREQ_GRP.pls_integer_type;
2827: G_LINE_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2828: G_PRICING_EFFECTIVE_DATE_TBL QP_PREQ_GRP.DATE_TYPE ;
2829: G_ACTIVE_DATE_FIRST_TBL QP_PREQ_GRP.DATE_TYPE ;
2830: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2831: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
2832: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
2833: G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;

Line 2830: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

2826: G_LINE_INDEX_tbl QP_PREQ_GRP.pls_integer_type;
2827: G_LINE_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2828: G_PRICING_EFFECTIVE_DATE_TBL QP_PREQ_GRP.DATE_TYPE ;
2829: G_ACTIVE_DATE_FIRST_TBL QP_PREQ_GRP.DATE_TYPE ;
2830: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2831: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
2832: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
2833: G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
2834: G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 2831: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;

2827: G_LINE_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2828: G_PRICING_EFFECTIVE_DATE_TBL QP_PREQ_GRP.DATE_TYPE ;
2829: G_ACTIVE_DATE_FIRST_TBL QP_PREQ_GRP.DATE_TYPE ;
2830: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2831: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
2832: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
2833: G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
2834: G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2835: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 2832: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;

2828: G_PRICING_EFFECTIVE_DATE_TBL QP_PREQ_GRP.DATE_TYPE ;
2829: G_ACTIVE_DATE_FIRST_TBL QP_PREQ_GRP.DATE_TYPE ;
2830: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2831: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
2832: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
2833: G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
2834: G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2835: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2836: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;

Line 2833: G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;

2829: G_ACTIVE_DATE_FIRST_TBL QP_PREQ_GRP.DATE_TYPE ;
2830: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2831: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
2832: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
2833: G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
2834: G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2835: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2836: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
2837: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 2834: G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

2830: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2831: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
2832: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
2833: G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
2834: G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2835: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2836: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
2837: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2838: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 2835: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

2831: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
2832: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
2833: G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
2834: G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2835: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2836: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
2837: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2838: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2839: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;

Line 2836: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;

2832: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
2833: G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
2834: G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2835: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2836: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
2837: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2838: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2839: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
2840: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;

Line 2837: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

2833: G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
2834: G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2835: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2836: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
2837: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2838: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2839: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
2840: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
2841: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;

Line 2838: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

2834: G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2835: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2836: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
2837: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2838: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2839: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
2840: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
2841: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
2842: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;

Line 2839: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;

2835: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2836: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
2837: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2838: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2839: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
2840: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
2841: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
2842: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
2843: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;

Line 2840: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;

2836: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
2837: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2838: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2839: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
2840: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
2841: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
2842: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
2843: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
2844: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 2841: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;

2837: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2838: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2839: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
2840: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
2841: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
2842: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
2843: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
2844: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2845: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 2842: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;

2838: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2839: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
2840: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
2841: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
2842: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
2843: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
2844: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2845: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2846:

Line 2843: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;

2839: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
2840: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
2841: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
2842: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
2843: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
2844: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2845: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2846:
2847: --mkothari 13-dec-2006

Line 2844: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

2840: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
2841: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
2842: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
2843: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
2844: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2845: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2846:
2847: --mkothari 13-dec-2006
2848: G_LIST_PRICE_OVERRIDE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 2845: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

2841: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
2842: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
2843: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
2844: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2845: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2846:
2847: --mkothari 13-dec-2006
2848: G_LIST_PRICE_OVERRIDE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2849:

Line 2848: G_LIST_PRICE_OVERRIDE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

2844: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2845: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2846:
2847: --mkothari 13-dec-2006
2848: G_LIST_PRICE_OVERRIDE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2849:
2850: G_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
2851: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
2852: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 2850: G_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;

2846:
2847: --mkothari 13-dec-2006
2848: G_LIST_PRICE_OVERRIDE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2849:
2850: G_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
2851: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
2852: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
2853: G_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
2854: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;

Line 2851: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;

2847: --mkothari 13-dec-2006
2848: G_LIST_PRICE_OVERRIDE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2849:
2850: G_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
2851: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
2852: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
2853: G_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
2854: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
2855: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;

Line 2852: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;

2848: G_LIST_PRICE_OVERRIDE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2849:
2850: G_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
2851: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
2852: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
2853: G_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
2854: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
2855: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
2856: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 2853: G_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;

2849:
2850: G_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
2851: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
2852: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
2853: G_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
2854: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
2855: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
2856: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2857: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 2854: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;

2850: G_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
2851: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
2852: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
2853: G_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
2854: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
2855: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
2856: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2857: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2858: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;

Line 2855: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;

2851: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
2852: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
2853: G_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
2854: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
2855: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
2856: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2857: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2858: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
2859: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 2856: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

2852: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
2853: G_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
2854: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
2855: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
2856: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2857: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2858: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
2859: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2860: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 2857: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

2853: G_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
2854: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
2855: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
2856: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2857: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2858: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
2859: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2860: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2861: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 2858: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;

2854: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
2855: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
2856: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2857: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2858: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
2859: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2860: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2861: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2862:

Line 2859: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

2855: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
2856: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2857: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2858: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
2859: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2860: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2861: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2862:
2863: l_failedAjustmentIdTbl numberTbl;

Line 2860: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

2856: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2857: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2858: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
2859: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2860: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2861: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2862:
2863: l_failedAjustmentIdTbl numberTbl;
2864: l_header_rec order_header_csr%rowtype;

Line 2861: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

2857: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2858: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
2859: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2860: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2861: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
2862:
2863: l_failedAjustmentIdTbl numberTbl;
2864: l_header_rec order_header_csr%rowtype;
2865:

Line 3559: G_PRICING_STATUS_CODE_tbl(l_tbl_index):= QP_PREQ_GRP.G_STATUS_UNCHANGED;

3555: G_PRICE_FLAG_TBL(l_tbl_index):= 'Y';
3556: G_LIST_PRICE_OVERRIDE_TBL(l_tbl_index):= 'Y';
3557: G_LINE_ID_TBL(l_tbl_index):= null;
3558: G_PROCESSING_ORDER_TBL(l_tbl_index):= null; -- l_line_tbl(l_tbl_index).PROCESSING_ORDER;
3559: G_PRICING_STATUS_CODE_tbl(l_tbl_index):= QP_PREQ_GRP.G_STATUS_UNCHANGED;
3560: G_PRICE_LIST_ID_TBL(l_tbl_index):= l_hdrPriceListIdTbl(P);
3561: G_PRICING_STATUS_TEXT_tbl(l_tbl_index):= null; -- l_line_tbl(l_tbl_index).PRICING_STATUS_TEXT;
3562: G_ROUNDING_FLAG_TBL(l_tbl_index):= null; --l_line_tbl(l_tbl_index).ROUNDING_FLAG;
3563: G_ROUNDING_FACTOR_TBL(l_tbl_index):= null; --l_line_tbl(l_tbl_index).ROUNDING_FACTOR;

Line 3590: l_line_tbl(l_tbl_index).pricing_status_code := QP_PREQ_GRP.G_STATUS_UNCHANGED;

3586: l_line_tbl(l_tbl_index).org_id := l_hdrOrgIdTbl(P);
3587:
3588: --Not needed for this flow
3589: --l_line_tbl(k).list_price_override_flag := l_list_price_override_flag;
3590: l_line_tbl(l_tbl_index).pricing_status_code := QP_PREQ_GRP.G_STATUS_UNCHANGED;
3591:
3592:
3593: QP_Attr_Mapping_PUB.Build_Contexts(
3594: p_request_type_code => 'ONT',

Line 3700: G_PRICING_STATUS_CODE_tbl(l_tbl_index):= QP_PREQ_GRP.G_STATUS_UNCHANGED;

3696: G_PRICE_FLAG_TBL(l_tbl_index):= 'Y';
3697: G_LIST_PRICE_OVERRIDE_TBL(l_tbl_index):= 'Y';
3698: G_LINE_ID_TBL(l_tbl_index):= l_lineIdTbl(l_lineCounter);
3699: G_PROCESSING_ORDER_TBL(l_tbl_index):= null; -- l_line_tbl(l_tbl_index).PROCESSING_ORDER;
3700: G_PRICING_STATUS_CODE_tbl(l_tbl_index):= QP_PREQ_GRP.G_STATUS_UNCHANGED;
3701: G_PRICE_LIST_ID_TBL(l_tbl_index):= l_priceListIdTbl(l_lineCounter);
3702: G_PRICING_STATUS_TEXT_tbl(l_tbl_index):= null; -- l_line_tbl(l_tbl_index).PRICING_STATUS_TEXT;
3703: G_ROUNDING_FLAG_TBL(l_tbl_index):= null; --l_line_tbl(l_tbl_index).ROUNDING_FLAG;
3704: G_ROUNDING_FACTOR_TBL(l_tbl_index):= null; --l_line_tbl(l_tbl_index).ROUNDING_FACTOR;

Line 3733: l_line_tbl(l_tbl_index).pricing_status_code := QP_PREQ_GRP.G_STATUS_UNCHANGED;

3729: l_line_tbl(l_tbl_index).price_list_id := l_priceListIdTbl(l_lineCounter);
3730: END IF;
3731: l_line_tbl(l_tbl_index).price_flag := 'Y';
3732: --l_line_tbl(l_tbl_index).list_price_override_flag := l_list_price_override_flag;
3733: l_line_tbl(l_tbl_index).pricing_status_code := QP_PREQ_GRP.G_STATUS_UNCHANGED;
3734: l_line_tbl(l_tbl_index).header_id := l_uniqueHeaderIdtbl(P);
3735: l_line_tbl(l_tbl_index).org_id := l_hdrOrgIdTbl(P);
3736: l_line_tbl(l_tbl_index).inventory_item_id := l_inventoryItemIdTbl(l_lineCounter);
3737: l_line_tbl(l_tbl_index).line_category_code := l_lineCatCodeTbl(l_lineCounter);

Line 3783: QP_PREQ_GRP.INSERT_LINES2

3779: --l_tbl_index := l_tbl_index + 1;
3780:
3781:
3782:
3783: QP_PREQ_GRP.INSERT_LINES2
3784: (p_LINE_INDEX => G_LINE_INDEX_TBL,
3785: p_LINE_TYPE_CODE => G_LINE_TYPE_CODE_TBL,
3786: p_PRICING_EFFECTIVE_DATE =>G_PRICING_EFFECTIVE_DATE_TBL,
3787: p_ACTIVE_DATE_FIRST =>G_ACTIVE_DATE_FIRST_TBL,