5: Index by Binary_Integer;
6: G_PASS_LINE_TBL Index_Tbl_Type;
7:
8: -- AG change
9: G_LINE_INDEX_tbl QP_PREQ_GRP.pls_integer_type;
10: G_LINE_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
11: G_PRICING_EFFECTIVE_DATE_TBL QP_PREQ_GRP.DATE_TYPE ;
12: G_ACTIVE_DATE_FIRST_TBL QP_PREQ_GRP.DATE_TYPE ;
13: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
6: G_PASS_LINE_TBL Index_Tbl_Type;
7:
8: -- AG change
9: G_LINE_INDEX_tbl QP_PREQ_GRP.pls_integer_type;
10: G_LINE_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
11: G_PRICING_EFFECTIVE_DATE_TBL QP_PREQ_GRP.DATE_TYPE ;
12: G_ACTIVE_DATE_FIRST_TBL QP_PREQ_GRP.DATE_TYPE ;
13: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
14: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
7:
8: -- AG change
9: G_LINE_INDEX_tbl QP_PREQ_GRP.pls_integer_type;
10: G_LINE_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
11: G_PRICING_EFFECTIVE_DATE_TBL QP_PREQ_GRP.DATE_TYPE ;
12: G_ACTIVE_DATE_FIRST_TBL QP_PREQ_GRP.DATE_TYPE ;
13: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
14: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
15: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
8: -- AG change
9: G_LINE_INDEX_tbl QP_PREQ_GRP.pls_integer_type;
10: G_LINE_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
11: G_PRICING_EFFECTIVE_DATE_TBL QP_PREQ_GRP.DATE_TYPE ;
12: G_ACTIVE_DATE_FIRST_TBL QP_PREQ_GRP.DATE_TYPE ;
13: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
14: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
15: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
16: G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
9: G_LINE_INDEX_tbl QP_PREQ_GRP.pls_integer_type;
10: G_LINE_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
11: G_PRICING_EFFECTIVE_DATE_TBL QP_PREQ_GRP.DATE_TYPE ;
12: G_ACTIVE_DATE_FIRST_TBL QP_PREQ_GRP.DATE_TYPE ;
13: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
14: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
15: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
16: G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
17: G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
10: G_LINE_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
11: G_PRICING_EFFECTIVE_DATE_TBL QP_PREQ_GRP.DATE_TYPE ;
12: G_ACTIVE_DATE_FIRST_TBL QP_PREQ_GRP.DATE_TYPE ;
13: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
14: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
15: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
16: G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
17: G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
18: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
11: G_PRICING_EFFECTIVE_DATE_TBL QP_PREQ_GRP.DATE_TYPE ;
12: G_ACTIVE_DATE_FIRST_TBL QP_PREQ_GRP.DATE_TYPE ;
13: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
14: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
15: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
16: G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
17: G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
18: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
19: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
12: G_ACTIVE_DATE_FIRST_TBL QP_PREQ_GRP.DATE_TYPE ;
13: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
14: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
15: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
16: G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
17: G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
18: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
19: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
20: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
13: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
14: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
15: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
16: G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
17: G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
18: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
19: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
20: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
21: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
14: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
15: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
16: G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
17: G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
18: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
19: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
20: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
21: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
22: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
15: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
16: G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
17: G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
18: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
19: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
20: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
21: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
22: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
23: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
16: G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
17: G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
18: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
19: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
20: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
21: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
22: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
23: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
24: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
17: G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
18: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
19: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
20: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
21: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
22: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
23: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
24: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
25: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
18: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
19: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
20: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
21: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
22: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
23: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
24: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
25: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
26: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
19: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
20: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
21: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
22: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
23: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
24: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
25: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
26: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
27: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
20: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
21: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
22: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
23: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
24: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
25: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
26: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
27: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
28: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
21: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
22: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
23: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
24: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
25: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
26: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
27: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
28: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
29: G_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
22: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
23: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
24: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
25: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
26: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
27: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
28: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
29: G_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
30: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
23: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
24: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
25: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
26: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
27: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
28: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
29: G_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
30: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
31: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
24: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
25: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
26: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
27: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
28: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
29: G_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
30: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
31: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
32: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
25: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
26: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
27: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
28: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
29: G_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
30: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
31: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
32: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
33: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
26: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
27: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
28: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
29: G_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
30: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
31: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
32: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
33: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
34: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
27: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
28: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
29: G_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
30: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
31: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
32: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
33: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
34: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
35: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
28: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
29: G_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
30: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
31: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
32: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
33: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
34: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
35: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
36: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
29: G_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
30: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
31: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
32: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
33: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
34: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
35: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
36: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
37: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
30: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
31: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
32: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
33: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
34: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
35: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
36: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
37: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
38: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
31: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
32: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
33: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
34: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
35: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
36: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
37: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
38: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
39: G_LINE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
32: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
33: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
34: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
35: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
36: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
37: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
38: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
39: G_LINE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
40: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
33: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
34: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
35: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
36: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
37: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
38: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
39: G_LINE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
40: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
41: G_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
34: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
35: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
36: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
37: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
38: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
39: G_LINE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
40: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
41: G_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
42: G_ATTR_LINE_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
35: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
36: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
37: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
38: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
39: G_LINE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
40: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
41: G_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
42: G_ATTR_LINE_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
43: G_ATTR_LINE_DETAIL_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
36: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
37: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
38: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
39: G_LINE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
40: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
41: G_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
42: G_ATTR_LINE_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
43: G_ATTR_LINE_DETAIL_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
44: G_ATTR_VALIDATED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
37: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
38: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
39: G_LINE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
40: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
41: G_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
42: G_ATTR_LINE_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
43: G_ATTR_LINE_DETAIL_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
44: G_ATTR_VALIDATED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
45: G_ATTR_PRICING_CONTEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
38: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
39: G_LINE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
40: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
41: G_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
42: G_ATTR_LINE_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
43: G_ATTR_LINE_DETAIL_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
44: G_ATTR_VALIDATED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
45: G_ATTR_PRICING_CONTEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
46: G_ATTR_PRICING_ATTRIBUTE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
39: G_LINE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
40: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
41: G_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
42: G_ATTR_LINE_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
43: G_ATTR_LINE_DETAIL_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
44: G_ATTR_VALIDATED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
45: G_ATTR_PRICING_CONTEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
46: G_ATTR_PRICING_ATTRIBUTE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
47: G_ATTR_ATTRIBUTE_LEVEL_tbl QP_PREQ_GRP.VARCHAR_TYPE;
40: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
41: G_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
42: G_ATTR_LINE_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
43: G_ATTR_LINE_DETAIL_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
44: G_ATTR_VALIDATED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
45: G_ATTR_PRICING_CONTEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
46: G_ATTR_PRICING_ATTRIBUTE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
47: G_ATTR_ATTRIBUTE_LEVEL_tbl QP_PREQ_GRP.VARCHAR_TYPE;
48: G_ATTR_ATTRIBUTE_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
41: G_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
42: G_ATTR_LINE_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
43: G_ATTR_LINE_DETAIL_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
44: G_ATTR_VALIDATED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
45: G_ATTR_PRICING_CONTEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
46: G_ATTR_PRICING_ATTRIBUTE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
47: G_ATTR_ATTRIBUTE_LEVEL_tbl QP_PREQ_GRP.VARCHAR_TYPE;
48: G_ATTR_ATTRIBUTE_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
49: G_ATTR_APPLIED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
42: G_ATTR_LINE_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
43: G_ATTR_LINE_DETAIL_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
44: G_ATTR_VALIDATED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
45: G_ATTR_PRICING_CONTEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
46: G_ATTR_PRICING_ATTRIBUTE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
47: G_ATTR_ATTRIBUTE_LEVEL_tbl QP_PREQ_GRP.VARCHAR_TYPE;
48: G_ATTR_ATTRIBUTE_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
49: G_ATTR_APPLIED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
50: G_ATTR_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
43: G_ATTR_LINE_DETAIL_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
44: G_ATTR_VALIDATED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
45: G_ATTR_PRICING_CONTEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
46: G_ATTR_PRICING_ATTRIBUTE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
47: G_ATTR_ATTRIBUTE_LEVEL_tbl QP_PREQ_GRP.VARCHAR_TYPE;
48: G_ATTR_ATTRIBUTE_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
49: G_ATTR_APPLIED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
50: G_ATTR_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
51: G_ATTR_PRICING_ATTR_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
44: G_ATTR_VALIDATED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
45: G_ATTR_PRICING_CONTEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
46: G_ATTR_PRICING_ATTRIBUTE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
47: G_ATTR_ATTRIBUTE_LEVEL_tbl QP_PREQ_GRP.VARCHAR_TYPE;
48: G_ATTR_ATTRIBUTE_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
49: G_ATTR_APPLIED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
50: G_ATTR_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
51: G_ATTR_PRICING_ATTR_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
52: G_ATTR_LIST_HEADER_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
45: G_ATTR_PRICING_CONTEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
46: G_ATTR_PRICING_ATTRIBUTE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
47: G_ATTR_ATTRIBUTE_LEVEL_tbl QP_PREQ_GRP.VARCHAR_TYPE;
48: G_ATTR_ATTRIBUTE_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
49: G_ATTR_APPLIED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
50: G_ATTR_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
51: G_ATTR_PRICING_ATTR_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
52: G_ATTR_LIST_HEADER_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
53: G_ATTR_LIST_LINE_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
46: G_ATTR_PRICING_ATTRIBUTE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
47: G_ATTR_ATTRIBUTE_LEVEL_tbl QP_PREQ_GRP.VARCHAR_TYPE;
48: G_ATTR_ATTRIBUTE_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
49: G_ATTR_APPLIED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
50: G_ATTR_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
51: G_ATTR_PRICING_ATTR_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
52: G_ATTR_LIST_HEADER_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
53: G_ATTR_LIST_LINE_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
54: G_ATTR_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
47: G_ATTR_ATTRIBUTE_LEVEL_tbl QP_PREQ_GRP.VARCHAR_TYPE;
48: G_ATTR_ATTRIBUTE_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
49: G_ATTR_APPLIED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
50: G_ATTR_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
51: G_ATTR_PRICING_ATTR_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
52: G_ATTR_LIST_HEADER_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
53: G_ATTR_LIST_LINE_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
54: G_ATTR_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
55: G_ATTR_SETUP_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
48: G_ATTR_ATTRIBUTE_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
49: G_ATTR_APPLIED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
50: G_ATTR_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
51: G_ATTR_PRICING_ATTR_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
52: G_ATTR_LIST_HEADER_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
53: G_ATTR_LIST_LINE_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
54: G_ATTR_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
55: G_ATTR_SETUP_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
56: G_ATTR_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
49: G_ATTR_APPLIED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
50: G_ATTR_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
51: G_ATTR_PRICING_ATTR_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
52: G_ATTR_LIST_HEADER_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
53: G_ATTR_LIST_LINE_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
54: G_ATTR_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
55: G_ATTR_SETUP_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
56: G_ATTR_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
57: G_ATTR_SETUP_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
50: G_ATTR_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
51: G_ATTR_PRICING_ATTR_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
52: G_ATTR_LIST_HEADER_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
53: G_ATTR_LIST_LINE_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
54: G_ATTR_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
55: G_ATTR_SETUP_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
56: G_ATTR_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
57: G_ATTR_SETUP_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
58: G_ATTR_GROUPING_NUMBER_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
51: G_ATTR_PRICING_ATTR_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
52: G_ATTR_LIST_HEADER_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
53: G_ATTR_LIST_LINE_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
54: G_ATTR_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
55: G_ATTR_SETUP_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
56: G_ATTR_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
57: G_ATTR_SETUP_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
58: G_ATTR_GROUPING_NUMBER_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
59: G_ATTR_NO_QUAL_IN_GRP_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
52: G_ATTR_LIST_HEADER_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
53: G_ATTR_LIST_LINE_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
54: G_ATTR_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
55: G_ATTR_SETUP_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
56: G_ATTR_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
57: G_ATTR_SETUP_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
58: G_ATTR_GROUPING_NUMBER_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
59: G_ATTR_NO_QUAL_IN_GRP_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
60: G_ATTR_COMP_OPERATOR_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
53: G_ATTR_LIST_LINE_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
54: G_ATTR_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
55: G_ATTR_SETUP_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
56: G_ATTR_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
57: G_ATTR_SETUP_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
58: G_ATTR_GROUPING_NUMBER_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
59: G_ATTR_NO_QUAL_IN_GRP_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
60: G_ATTR_COMP_OPERATOR_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
61: G_ATTR_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
54: G_ATTR_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
55: G_ATTR_SETUP_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
56: G_ATTR_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
57: G_ATTR_SETUP_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
58: G_ATTR_GROUPING_NUMBER_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
59: G_ATTR_NO_QUAL_IN_GRP_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
60: G_ATTR_COMP_OPERATOR_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
61: G_ATTR_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
62: G_ATTR_QUAL_PRECEDENCE_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
55: G_ATTR_SETUP_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
56: G_ATTR_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
57: G_ATTR_SETUP_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
58: G_ATTR_GROUPING_NUMBER_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
59: G_ATTR_NO_QUAL_IN_GRP_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
60: G_ATTR_COMP_OPERATOR_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
61: G_ATTR_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
62: G_ATTR_QUAL_PRECEDENCE_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
63: G_ATTR_DATATYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
56: G_ATTR_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
57: G_ATTR_SETUP_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
58: G_ATTR_GROUPING_NUMBER_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
59: G_ATTR_NO_QUAL_IN_GRP_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
60: G_ATTR_COMP_OPERATOR_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
61: G_ATTR_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
62: G_ATTR_QUAL_PRECEDENCE_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
63: G_ATTR_DATATYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
64: G_ATTR_QUALIFIER_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
57: G_ATTR_SETUP_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
58: G_ATTR_GROUPING_NUMBER_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
59: G_ATTR_NO_QUAL_IN_GRP_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
60: G_ATTR_COMP_OPERATOR_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
61: G_ATTR_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
62: G_ATTR_QUAL_PRECEDENCE_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
63: G_ATTR_DATATYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
64: G_ATTR_QUALIFIER_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
65: G_ATTR_PRODUCT_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
58: G_ATTR_GROUPING_NUMBER_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
59: G_ATTR_NO_QUAL_IN_GRP_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
60: G_ATTR_COMP_OPERATOR_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
61: G_ATTR_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
62: G_ATTR_QUAL_PRECEDENCE_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
63: G_ATTR_DATATYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
64: G_ATTR_QUALIFIER_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
65: G_ATTR_PRODUCT_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
66: G_ATTR_EXCLUDER_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
59: G_ATTR_NO_QUAL_IN_GRP_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
60: G_ATTR_COMP_OPERATOR_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
61: G_ATTR_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
62: G_ATTR_QUAL_PRECEDENCE_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
63: G_ATTR_DATATYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
64: G_ATTR_QUALIFIER_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
65: G_ATTR_PRODUCT_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
66: G_ATTR_EXCLUDER_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
67: G_ATTR_PRICING_PHASE_ID_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
60: G_ATTR_COMP_OPERATOR_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
61: G_ATTR_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
62: G_ATTR_QUAL_PRECEDENCE_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
63: G_ATTR_DATATYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
64: G_ATTR_QUALIFIER_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
65: G_ATTR_PRODUCT_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
66: G_ATTR_EXCLUDER_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
67: G_ATTR_PRICING_PHASE_ID_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
68: G_ATTR_INCOM_GRP_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
61: G_ATTR_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
62: G_ATTR_QUAL_PRECEDENCE_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
63: G_ATTR_DATATYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
64: G_ATTR_QUALIFIER_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
65: G_ATTR_PRODUCT_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
66: G_ATTR_EXCLUDER_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
67: G_ATTR_PRICING_PHASE_ID_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
68: G_ATTR_INCOM_GRP_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
69: G_ATTR_LDET_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
62: G_ATTR_QUAL_PRECEDENCE_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
63: G_ATTR_DATATYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
64: G_ATTR_QUALIFIER_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
65: G_ATTR_PRODUCT_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
66: G_ATTR_EXCLUDER_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
67: G_ATTR_PRICING_PHASE_ID_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
68: G_ATTR_INCOM_GRP_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
69: G_ATTR_LDET_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
70: G_ATTR_MODIFIER_LEVEL_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
63: G_ATTR_DATATYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
64: G_ATTR_QUALIFIER_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
65: G_ATTR_PRODUCT_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
66: G_ATTR_EXCLUDER_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
67: G_ATTR_PRICING_PHASE_ID_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
68: G_ATTR_INCOM_GRP_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
69: G_ATTR_LDET_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
70: G_ATTR_MODIFIER_LEVEL_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
71: G_ATTR_PRIMARY_UOM_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
64: G_ATTR_QUALIFIER_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
65: G_ATTR_PRODUCT_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
66: G_ATTR_EXCLUDER_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
67: G_ATTR_PRICING_PHASE_ID_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
68: G_ATTR_INCOM_GRP_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
69: G_ATTR_LDET_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
70: G_ATTR_MODIFIER_LEVEL_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
71: G_ATTR_PRIMARY_UOM_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
72: G_CATCHWEIGHT_QTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
65: G_ATTR_PRODUCT_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
66: G_ATTR_EXCLUDER_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
67: G_ATTR_PRICING_PHASE_ID_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
68: G_ATTR_INCOM_GRP_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
69: G_ATTR_LDET_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
70: G_ATTR_MODIFIER_LEVEL_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
71: G_ATTR_PRIMARY_UOM_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
72: G_CATCHWEIGHT_QTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
73: G_ACTUAL_ORDER_QTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
66: G_ATTR_EXCLUDER_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
67: G_ATTR_PRICING_PHASE_ID_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
68: G_ATTR_INCOM_GRP_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
69: G_ATTR_LDET_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
70: G_ATTR_MODIFIER_LEVEL_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
71: G_ATTR_PRIMARY_UOM_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
72: G_CATCHWEIGHT_QTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
73: G_ACTUAL_ORDER_QTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
74: G_LDET_LINE_DETAIL_INDEX QP_PREQ_GRP.PLS_INTEGER_TYPE;
67: G_ATTR_PRICING_PHASE_ID_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
68: G_ATTR_INCOM_GRP_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
69: G_ATTR_LDET_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
70: G_ATTR_MODIFIER_LEVEL_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
71: G_ATTR_PRIMARY_UOM_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
72: G_CATCHWEIGHT_QTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
73: G_ACTUAL_ORDER_QTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
74: G_LDET_LINE_DETAIL_INDEX QP_PREQ_GRP.PLS_INTEGER_TYPE;
75: G_LDET_LINE_DETAIL_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
68: G_ATTR_INCOM_GRP_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
69: G_ATTR_LDET_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
70: G_ATTR_MODIFIER_LEVEL_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
71: G_ATTR_PRIMARY_UOM_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
72: G_CATCHWEIGHT_QTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
73: G_ACTUAL_ORDER_QTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
74: G_LDET_LINE_DETAIL_INDEX QP_PREQ_GRP.PLS_INTEGER_TYPE;
75: G_LDET_LINE_DETAIL_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
76: G_LDET_PRICE_BREAK_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
69: G_ATTR_LDET_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
70: G_ATTR_MODIFIER_LEVEL_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
71: G_ATTR_PRIMARY_UOM_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
72: G_CATCHWEIGHT_QTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
73: G_ACTUAL_ORDER_QTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
74: G_LDET_LINE_DETAIL_INDEX QP_PREQ_GRP.PLS_INTEGER_TYPE;
75: G_LDET_LINE_DETAIL_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
76: G_LDET_PRICE_BREAK_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
77: G_LDET_LINE_INDEX QP_PREQ_GRP.NUMBER_TYPE;
70: G_ATTR_MODIFIER_LEVEL_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
71: G_ATTR_PRIMARY_UOM_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
72: G_CATCHWEIGHT_QTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
73: G_ACTUAL_ORDER_QTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
74: G_LDET_LINE_DETAIL_INDEX QP_PREQ_GRP.PLS_INTEGER_TYPE;
75: G_LDET_LINE_DETAIL_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
76: G_LDET_PRICE_BREAK_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
77: G_LDET_LINE_INDEX QP_PREQ_GRP.NUMBER_TYPE;
78: G_LDET_LIST_HEADER_ID QP_PREQ_GRP.NUMBER_TYPE;
71: G_ATTR_PRIMARY_UOM_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
72: G_CATCHWEIGHT_QTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
73: G_ACTUAL_ORDER_QTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
74: G_LDET_LINE_DETAIL_INDEX QP_PREQ_GRP.PLS_INTEGER_TYPE;
75: G_LDET_LINE_DETAIL_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
76: G_LDET_PRICE_BREAK_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
77: G_LDET_LINE_INDEX QP_PREQ_GRP.NUMBER_TYPE;
78: G_LDET_LIST_HEADER_ID QP_PREQ_GRP.NUMBER_TYPE;
79: G_LDET_LIST_LINE_ID QP_PREQ_GRP.NUMBER_TYPE;
72: G_CATCHWEIGHT_QTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
73: G_ACTUAL_ORDER_QTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
74: G_LDET_LINE_DETAIL_INDEX QP_PREQ_GRP.PLS_INTEGER_TYPE;
75: G_LDET_LINE_DETAIL_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
76: G_LDET_PRICE_BREAK_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
77: G_LDET_LINE_INDEX QP_PREQ_GRP.NUMBER_TYPE;
78: G_LDET_LIST_HEADER_ID QP_PREQ_GRP.NUMBER_TYPE;
79: G_LDET_LIST_LINE_ID QP_PREQ_GRP.NUMBER_TYPE;
80: G_LDET_LIST_LINE_TYPE QP_PREQ_GRP.VARCHAR_TYPE;
73: G_ACTUAL_ORDER_QTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
74: G_LDET_LINE_DETAIL_INDEX QP_PREQ_GRP.PLS_INTEGER_TYPE;
75: G_LDET_LINE_DETAIL_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
76: G_LDET_PRICE_BREAK_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
77: G_LDET_LINE_INDEX QP_PREQ_GRP.NUMBER_TYPE;
78: G_LDET_LIST_HEADER_ID QP_PREQ_GRP.NUMBER_TYPE;
79: G_LDET_LIST_LINE_ID QP_PREQ_GRP.NUMBER_TYPE;
80: G_LDET_LIST_LINE_TYPE QP_PREQ_GRP.VARCHAR_TYPE;
81: G_LDET_LIST_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
74: G_LDET_LINE_DETAIL_INDEX QP_PREQ_GRP.PLS_INTEGER_TYPE;
75: G_LDET_LINE_DETAIL_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
76: G_LDET_PRICE_BREAK_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
77: G_LDET_LINE_INDEX QP_PREQ_GRP.NUMBER_TYPE;
78: G_LDET_LIST_HEADER_ID QP_PREQ_GRP.NUMBER_TYPE;
79: G_LDET_LIST_LINE_ID QP_PREQ_GRP.NUMBER_TYPE;
80: G_LDET_LIST_LINE_TYPE QP_PREQ_GRP.VARCHAR_TYPE;
81: G_LDET_LIST_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
82: G_LDET_PRICING_GROUP_SEQUENCE QP_PREQ_GRP.PLS_INTEGER_TYPE;
75: G_LDET_LINE_DETAIL_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
76: G_LDET_PRICE_BREAK_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
77: G_LDET_LINE_INDEX QP_PREQ_GRP.NUMBER_TYPE;
78: G_LDET_LIST_HEADER_ID QP_PREQ_GRP.NUMBER_TYPE;
79: G_LDET_LIST_LINE_ID QP_PREQ_GRP.NUMBER_TYPE;
80: G_LDET_LIST_LINE_TYPE QP_PREQ_GRP.VARCHAR_TYPE;
81: G_LDET_LIST_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
82: G_LDET_PRICING_GROUP_SEQUENCE QP_PREQ_GRP.PLS_INTEGER_TYPE;
83: G_LDET_PRICING_PHASE_ID QP_PREQ_GRP.PLS_INTEGER_TYPE;
76: G_LDET_PRICE_BREAK_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
77: G_LDET_LINE_INDEX QP_PREQ_GRP.NUMBER_TYPE;
78: G_LDET_LIST_HEADER_ID QP_PREQ_GRP.NUMBER_TYPE;
79: G_LDET_LIST_LINE_ID QP_PREQ_GRP.NUMBER_TYPE;
80: G_LDET_LIST_LINE_TYPE QP_PREQ_GRP.VARCHAR_TYPE;
81: G_LDET_LIST_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
82: G_LDET_PRICING_GROUP_SEQUENCE QP_PREQ_GRP.PLS_INTEGER_TYPE;
83: G_LDET_PRICING_PHASE_ID QP_PREQ_GRP.PLS_INTEGER_TYPE;
84: G_LDET_OPERATOR QP_PREQ_GRP.VARCHAR_TYPE;
77: G_LDET_LINE_INDEX QP_PREQ_GRP.NUMBER_TYPE;
78: G_LDET_LIST_HEADER_ID QP_PREQ_GRP.NUMBER_TYPE;
79: G_LDET_LIST_LINE_ID QP_PREQ_GRP.NUMBER_TYPE;
80: G_LDET_LIST_LINE_TYPE QP_PREQ_GRP.VARCHAR_TYPE;
81: G_LDET_LIST_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
82: G_LDET_PRICING_GROUP_SEQUENCE QP_PREQ_GRP.PLS_INTEGER_TYPE;
83: G_LDET_PRICING_PHASE_ID QP_PREQ_GRP.PLS_INTEGER_TYPE;
84: G_LDET_OPERATOR QP_PREQ_GRP.VARCHAR_TYPE;
85: G_LDET_OPERAND_VALUE QP_PREQ_GRP.VARCHAR_TYPE;
78: G_LDET_LIST_HEADER_ID QP_PREQ_GRP.NUMBER_TYPE;
79: G_LDET_LIST_LINE_ID QP_PREQ_GRP.NUMBER_TYPE;
80: G_LDET_LIST_LINE_TYPE QP_PREQ_GRP.VARCHAR_TYPE;
81: G_LDET_LIST_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
82: G_LDET_PRICING_GROUP_SEQUENCE QP_PREQ_GRP.PLS_INTEGER_TYPE;
83: G_LDET_PRICING_PHASE_ID QP_PREQ_GRP.PLS_INTEGER_TYPE;
84: G_LDET_OPERATOR QP_PREQ_GRP.VARCHAR_TYPE;
85: G_LDET_OPERAND_VALUE QP_PREQ_GRP.VARCHAR_TYPE;
86: G_LDET_SUBSTITUTION_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
79: G_LDET_LIST_LINE_ID QP_PREQ_GRP.NUMBER_TYPE;
80: G_LDET_LIST_LINE_TYPE QP_PREQ_GRP.VARCHAR_TYPE;
81: G_LDET_LIST_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
82: G_LDET_PRICING_GROUP_SEQUENCE QP_PREQ_GRP.PLS_INTEGER_TYPE;
83: G_LDET_PRICING_PHASE_ID QP_PREQ_GRP.PLS_INTEGER_TYPE;
84: G_LDET_OPERATOR QP_PREQ_GRP.VARCHAR_TYPE;
85: G_LDET_OPERAND_VALUE QP_PREQ_GRP.VARCHAR_TYPE;
86: G_LDET_SUBSTITUTION_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
87: G_LDET_SUBSTITUTION_VALUE_FROM QP_PREQ_GRP.VARCHAR_TYPE;
80: G_LDET_LIST_LINE_TYPE QP_PREQ_GRP.VARCHAR_TYPE;
81: G_LDET_LIST_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
82: G_LDET_PRICING_GROUP_SEQUENCE QP_PREQ_GRP.PLS_INTEGER_TYPE;
83: G_LDET_PRICING_PHASE_ID QP_PREQ_GRP.PLS_INTEGER_TYPE;
84: G_LDET_OPERATOR QP_PREQ_GRP.VARCHAR_TYPE;
85: G_LDET_OPERAND_VALUE QP_PREQ_GRP.VARCHAR_TYPE;
86: G_LDET_SUBSTITUTION_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
87: G_LDET_SUBSTITUTION_VALUE_FROM QP_PREQ_GRP.VARCHAR_TYPE;
88: G_LDET_SUBSTITUTION_VALUE_TO QP_PREQ_GRP.VARCHAR_TYPE;
81: G_LDET_LIST_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
82: G_LDET_PRICING_GROUP_SEQUENCE QP_PREQ_GRP.PLS_INTEGER_TYPE;
83: G_LDET_PRICING_PHASE_ID QP_PREQ_GRP.PLS_INTEGER_TYPE;
84: G_LDET_OPERATOR QP_PREQ_GRP.VARCHAR_TYPE;
85: G_LDET_OPERAND_VALUE QP_PREQ_GRP.VARCHAR_TYPE;
86: G_LDET_SUBSTITUTION_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
87: G_LDET_SUBSTITUTION_VALUE_FROM QP_PREQ_GRP.VARCHAR_TYPE;
88: G_LDET_SUBSTITUTION_VALUE_TO QP_PREQ_GRP.VARCHAR_TYPE;
89: G_LDET_PRICE_FORMULA_ID QP_PREQ_GRP.NUMBER_TYPE;
82: G_LDET_PRICING_GROUP_SEQUENCE QP_PREQ_GRP.PLS_INTEGER_TYPE;
83: G_LDET_PRICING_PHASE_ID QP_PREQ_GRP.PLS_INTEGER_TYPE;
84: G_LDET_OPERATOR QP_PREQ_GRP.VARCHAR_TYPE;
85: G_LDET_OPERAND_VALUE QP_PREQ_GRP.VARCHAR_TYPE;
86: G_LDET_SUBSTITUTION_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
87: G_LDET_SUBSTITUTION_VALUE_FROM QP_PREQ_GRP.VARCHAR_TYPE;
88: G_LDET_SUBSTITUTION_VALUE_TO QP_PREQ_GRP.VARCHAR_TYPE;
89: G_LDET_PRICE_FORMULA_ID QP_PREQ_GRP.NUMBER_TYPE;
90: G_LDET_PRODUCT_PRECEDENCE QP_PREQ_GRP.PLS_INTEGER_TYPE;
83: G_LDET_PRICING_PHASE_ID QP_PREQ_GRP.PLS_INTEGER_TYPE;
84: G_LDET_OPERATOR QP_PREQ_GRP.VARCHAR_TYPE;
85: G_LDET_OPERAND_VALUE QP_PREQ_GRP.VARCHAR_TYPE;
86: G_LDET_SUBSTITUTION_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
87: G_LDET_SUBSTITUTION_VALUE_FROM QP_PREQ_GRP.VARCHAR_TYPE;
88: G_LDET_SUBSTITUTION_VALUE_TO QP_PREQ_GRP.VARCHAR_TYPE;
89: G_LDET_PRICE_FORMULA_ID QP_PREQ_GRP.NUMBER_TYPE;
90: G_LDET_PRODUCT_PRECEDENCE QP_PREQ_GRP.PLS_INTEGER_TYPE;
91: G_LDET_INCOM_GRP_CODE QP_PREQ_GRP.VARCHAR_TYPE;
84: G_LDET_OPERATOR QP_PREQ_GRP.VARCHAR_TYPE;
85: G_LDET_OPERAND_VALUE QP_PREQ_GRP.VARCHAR_TYPE;
86: G_LDET_SUBSTITUTION_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
87: G_LDET_SUBSTITUTION_VALUE_FROM QP_PREQ_GRP.VARCHAR_TYPE;
88: G_LDET_SUBSTITUTION_VALUE_TO QP_PREQ_GRP.VARCHAR_TYPE;
89: G_LDET_PRICE_FORMULA_ID QP_PREQ_GRP.NUMBER_TYPE;
90: G_LDET_PRODUCT_PRECEDENCE QP_PREQ_GRP.PLS_INTEGER_TYPE;
91: G_LDET_INCOM_GRP_CODE QP_PREQ_GRP.VARCHAR_TYPE;
92: G_LDET_APPLIED_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
85: G_LDET_OPERAND_VALUE QP_PREQ_GRP.VARCHAR_TYPE;
86: G_LDET_SUBSTITUTION_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
87: G_LDET_SUBSTITUTION_VALUE_FROM QP_PREQ_GRP.VARCHAR_TYPE;
88: G_LDET_SUBSTITUTION_VALUE_TO QP_PREQ_GRP.VARCHAR_TYPE;
89: G_LDET_PRICE_FORMULA_ID QP_PREQ_GRP.NUMBER_TYPE;
90: G_LDET_PRODUCT_PRECEDENCE QP_PREQ_GRP.PLS_INTEGER_TYPE;
91: G_LDET_INCOM_GRP_CODE QP_PREQ_GRP.VARCHAR_TYPE;
92: G_LDET_APPLIED_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
93: G_LDET_AUTOMATIC_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
86: G_LDET_SUBSTITUTION_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
87: G_LDET_SUBSTITUTION_VALUE_FROM QP_PREQ_GRP.VARCHAR_TYPE;
88: G_LDET_SUBSTITUTION_VALUE_TO QP_PREQ_GRP.VARCHAR_TYPE;
89: G_LDET_PRICE_FORMULA_ID QP_PREQ_GRP.NUMBER_TYPE;
90: G_LDET_PRODUCT_PRECEDENCE QP_PREQ_GRP.PLS_INTEGER_TYPE;
91: G_LDET_INCOM_GRP_CODE QP_PREQ_GRP.VARCHAR_TYPE;
92: G_LDET_APPLIED_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
93: G_LDET_AUTOMATIC_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
94: G_LDET_OVERRIDE_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
87: G_LDET_SUBSTITUTION_VALUE_FROM QP_PREQ_GRP.VARCHAR_TYPE;
88: G_LDET_SUBSTITUTION_VALUE_TO QP_PREQ_GRP.VARCHAR_TYPE;
89: G_LDET_PRICE_FORMULA_ID QP_PREQ_GRP.NUMBER_TYPE;
90: G_LDET_PRODUCT_PRECEDENCE QP_PREQ_GRP.PLS_INTEGER_TYPE;
91: G_LDET_INCOM_GRP_CODE QP_PREQ_GRP.VARCHAR_TYPE;
92: G_LDET_APPLIED_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
93: G_LDET_AUTOMATIC_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
94: G_LDET_OVERRIDE_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
95: G_LDET_MODIFIER_LEVEL_CODE QP_PREQ_GRP.VARCHAR_TYPE;
88: G_LDET_SUBSTITUTION_VALUE_TO QP_PREQ_GRP.VARCHAR_TYPE;
89: G_LDET_PRICE_FORMULA_ID QP_PREQ_GRP.NUMBER_TYPE;
90: G_LDET_PRODUCT_PRECEDENCE QP_PREQ_GRP.PLS_INTEGER_TYPE;
91: G_LDET_INCOM_GRP_CODE QP_PREQ_GRP.VARCHAR_TYPE;
92: G_LDET_APPLIED_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
93: G_LDET_AUTOMATIC_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
94: G_LDET_OVERRIDE_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
95: G_LDET_MODIFIER_LEVEL_CODE QP_PREQ_GRP.VARCHAR_TYPE;
96: G_LDET_BENEFIT_QTY QP_PREQ_GRP.NUMBER_TYPE;
89: G_LDET_PRICE_FORMULA_ID QP_PREQ_GRP.NUMBER_TYPE;
90: G_LDET_PRODUCT_PRECEDENCE QP_PREQ_GRP.PLS_INTEGER_TYPE;
91: G_LDET_INCOM_GRP_CODE QP_PREQ_GRP.VARCHAR_TYPE;
92: G_LDET_APPLIED_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
93: G_LDET_AUTOMATIC_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
94: G_LDET_OVERRIDE_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
95: G_LDET_MODIFIER_LEVEL_CODE QP_PREQ_GRP.VARCHAR_TYPE;
96: G_LDET_BENEFIT_QTY QP_PREQ_GRP.NUMBER_TYPE;
97: G_LDET_BENEFIT_UOM_CODE QP_PREQ_GRP.VARCHAR_TYPE;
90: G_LDET_PRODUCT_PRECEDENCE QP_PREQ_GRP.PLS_INTEGER_TYPE;
91: G_LDET_INCOM_GRP_CODE QP_PREQ_GRP.VARCHAR_TYPE;
92: G_LDET_APPLIED_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
93: G_LDET_AUTOMATIC_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
94: G_LDET_OVERRIDE_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
95: G_LDET_MODIFIER_LEVEL_CODE QP_PREQ_GRP.VARCHAR_TYPE;
96: G_LDET_BENEFIT_QTY QP_PREQ_GRP.NUMBER_TYPE;
97: G_LDET_BENEFIT_UOM_CODE QP_PREQ_GRP.VARCHAR_TYPE;
98: G_LDET_LIST_LINE_NO QP_PREQ_GRP.VARCHAR_TYPE;
91: G_LDET_INCOM_GRP_CODE QP_PREQ_GRP.VARCHAR_TYPE;
92: G_LDET_APPLIED_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
93: G_LDET_AUTOMATIC_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
94: G_LDET_OVERRIDE_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
95: G_LDET_MODIFIER_LEVEL_CODE QP_PREQ_GRP.VARCHAR_TYPE;
96: G_LDET_BENEFIT_QTY QP_PREQ_GRP.NUMBER_TYPE;
97: G_LDET_BENEFIT_UOM_CODE QP_PREQ_GRP.VARCHAR_TYPE;
98: G_LDET_LIST_LINE_NO QP_PREQ_GRP.VARCHAR_TYPE;
99: G_LDET_ACCRUAL_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
92: G_LDET_APPLIED_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
93: G_LDET_AUTOMATIC_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
94: G_LDET_OVERRIDE_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
95: G_LDET_MODIFIER_LEVEL_CODE QP_PREQ_GRP.VARCHAR_TYPE;
96: G_LDET_BENEFIT_QTY QP_PREQ_GRP.NUMBER_TYPE;
97: G_LDET_BENEFIT_UOM_CODE QP_PREQ_GRP.VARCHAR_TYPE;
98: G_LDET_LIST_LINE_NO QP_PREQ_GRP.VARCHAR_TYPE;
99: G_LDET_ACCRUAL_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
100: G_LDET_ACCRUAL_CONVERSION_RATE QP_PREQ_GRP.NUMBER_TYPE;
93: G_LDET_AUTOMATIC_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
94: G_LDET_OVERRIDE_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
95: G_LDET_MODIFIER_LEVEL_CODE QP_PREQ_GRP.VARCHAR_TYPE;
96: G_LDET_BENEFIT_QTY QP_PREQ_GRP.NUMBER_TYPE;
97: G_LDET_BENEFIT_UOM_CODE QP_PREQ_GRP.VARCHAR_TYPE;
98: G_LDET_LIST_LINE_NO QP_PREQ_GRP.VARCHAR_TYPE;
99: G_LDET_ACCRUAL_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
100: G_LDET_ACCRUAL_CONVERSION_RATE QP_PREQ_GRP.NUMBER_TYPE;
101: G_LDET_ESTIM_ACCRUAL_RATE QP_PREQ_GRP.NUMBER_TYPE;
94: G_LDET_OVERRIDE_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
95: G_LDET_MODIFIER_LEVEL_CODE QP_PREQ_GRP.VARCHAR_TYPE;
96: G_LDET_BENEFIT_QTY QP_PREQ_GRP.NUMBER_TYPE;
97: G_LDET_BENEFIT_UOM_CODE QP_PREQ_GRP.VARCHAR_TYPE;
98: G_LDET_LIST_LINE_NO QP_PREQ_GRP.VARCHAR_TYPE;
99: G_LDET_ACCRUAL_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
100: G_LDET_ACCRUAL_CONVERSION_RATE QP_PREQ_GRP.NUMBER_TYPE;
101: G_LDET_ESTIM_ACCRUAL_RATE QP_PREQ_GRP.NUMBER_TYPE;
102: G_LDET_CHARGE_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
95: G_LDET_MODIFIER_LEVEL_CODE QP_PREQ_GRP.VARCHAR_TYPE;
96: G_LDET_BENEFIT_QTY QP_PREQ_GRP.NUMBER_TYPE;
97: G_LDET_BENEFIT_UOM_CODE QP_PREQ_GRP.VARCHAR_TYPE;
98: G_LDET_LIST_LINE_NO QP_PREQ_GRP.VARCHAR_TYPE;
99: G_LDET_ACCRUAL_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
100: G_LDET_ACCRUAL_CONVERSION_RATE QP_PREQ_GRP.NUMBER_TYPE;
101: G_LDET_ESTIM_ACCRUAL_RATE QP_PREQ_GRP.NUMBER_TYPE;
102: G_LDET_CHARGE_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
103: G_LDET_CHARGE_SUBTYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
96: G_LDET_BENEFIT_QTY QP_PREQ_GRP.NUMBER_TYPE;
97: G_LDET_BENEFIT_UOM_CODE QP_PREQ_GRP.VARCHAR_TYPE;
98: G_LDET_LIST_LINE_NO QP_PREQ_GRP.VARCHAR_TYPE;
99: G_LDET_ACCRUAL_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
100: G_LDET_ACCRUAL_CONVERSION_RATE QP_PREQ_GRP.NUMBER_TYPE;
101: G_LDET_ESTIM_ACCRUAL_RATE QP_PREQ_GRP.NUMBER_TYPE;
102: G_LDET_CHARGE_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
103: G_LDET_CHARGE_SUBTYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
104: G_LDET_LINE_QUANTITY QP_PREQ_GRP.NUMBER_TYPE;
97: G_LDET_BENEFIT_UOM_CODE QP_PREQ_GRP.VARCHAR_TYPE;
98: G_LDET_LIST_LINE_NO QP_PREQ_GRP.VARCHAR_TYPE;
99: G_LDET_ACCRUAL_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
100: G_LDET_ACCRUAL_CONVERSION_RATE QP_PREQ_GRP.NUMBER_TYPE;
101: G_LDET_ESTIM_ACCRUAL_RATE QP_PREQ_GRP.NUMBER_TYPE;
102: G_LDET_CHARGE_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
103: G_LDET_CHARGE_SUBTYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
104: G_LDET_LINE_QUANTITY QP_PREQ_GRP.NUMBER_TYPE;
105: G_LDET_UPDATED_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
98: G_LDET_LIST_LINE_NO QP_PREQ_GRP.VARCHAR_TYPE;
99: G_LDET_ACCRUAL_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
100: G_LDET_ACCRUAL_CONVERSION_RATE QP_PREQ_GRP.NUMBER_TYPE;
101: G_LDET_ESTIM_ACCRUAL_RATE QP_PREQ_GRP.NUMBER_TYPE;
102: G_LDET_CHARGE_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
103: G_LDET_CHARGE_SUBTYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
104: G_LDET_LINE_QUANTITY QP_PREQ_GRP.NUMBER_TYPE;
105: G_LDET_UPDATED_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
106: G_LDET_CALCULATION_CODE QP_PREQ_GRP.VARCHAR_TYPE;
99: G_LDET_ACCRUAL_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
100: G_LDET_ACCRUAL_CONVERSION_RATE QP_PREQ_GRP.NUMBER_TYPE;
101: G_LDET_ESTIM_ACCRUAL_RATE QP_PREQ_GRP.NUMBER_TYPE;
102: G_LDET_CHARGE_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
103: G_LDET_CHARGE_SUBTYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
104: G_LDET_LINE_QUANTITY QP_PREQ_GRP.NUMBER_TYPE;
105: G_LDET_UPDATED_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
106: G_LDET_CALCULATION_CODE QP_PREQ_GRP.VARCHAR_TYPE;
107: G_LDET_CHANGE_REASON_CODE QP_PREQ_GRP.VARCHAR_TYPE;
100: G_LDET_ACCRUAL_CONVERSION_RATE QP_PREQ_GRP.NUMBER_TYPE;
101: G_LDET_ESTIM_ACCRUAL_RATE QP_PREQ_GRP.NUMBER_TYPE;
102: G_LDET_CHARGE_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
103: G_LDET_CHARGE_SUBTYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
104: G_LDET_LINE_QUANTITY QP_PREQ_GRP.NUMBER_TYPE;
105: G_LDET_UPDATED_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
106: G_LDET_CALCULATION_CODE QP_PREQ_GRP.VARCHAR_TYPE;
107: G_LDET_CHANGE_REASON_CODE QP_PREQ_GRP.VARCHAR_TYPE;
108: G_LDET_CHANGE_REASON_TEXT QP_PREQ_GRP.VARCHAR_TYPE;
101: G_LDET_ESTIM_ACCRUAL_RATE QP_PREQ_GRP.NUMBER_TYPE;
102: G_LDET_CHARGE_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
103: G_LDET_CHARGE_SUBTYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
104: G_LDET_LINE_QUANTITY QP_PREQ_GRP.NUMBER_TYPE;
105: G_LDET_UPDATED_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
106: G_LDET_CALCULATION_CODE QP_PREQ_GRP.VARCHAR_TYPE;
107: G_LDET_CHANGE_REASON_CODE QP_PREQ_GRP.VARCHAR_TYPE;
108: G_LDET_CHANGE_REASON_TEXT QP_PREQ_GRP.VARCHAR_TYPE;
109: G_LDET_ACCUM_CONTEXT QP_PREQ_GRP.VARCHAR_TYPE; -- accum range break
102: G_LDET_CHARGE_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
103: G_LDET_CHARGE_SUBTYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
104: G_LDET_LINE_QUANTITY QP_PREQ_GRP.NUMBER_TYPE;
105: G_LDET_UPDATED_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
106: G_LDET_CALCULATION_CODE QP_PREQ_GRP.VARCHAR_TYPE;
107: G_LDET_CHANGE_REASON_CODE QP_PREQ_GRP.VARCHAR_TYPE;
108: G_LDET_CHANGE_REASON_TEXT QP_PREQ_GRP.VARCHAR_TYPE;
109: G_LDET_ACCUM_CONTEXT QP_PREQ_GRP.VARCHAR_TYPE; -- accum range break
110: G_LDET_ACCUM_ATTRIBUTE QP_PREQ_GRP.VARCHAR_TYPE; -- accum range break
103: G_LDET_CHARGE_SUBTYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;
104: G_LDET_LINE_QUANTITY QP_PREQ_GRP.NUMBER_TYPE;
105: G_LDET_UPDATED_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
106: G_LDET_CALCULATION_CODE QP_PREQ_GRP.VARCHAR_TYPE;
107: G_LDET_CHANGE_REASON_CODE QP_PREQ_GRP.VARCHAR_TYPE;
108: G_LDET_CHANGE_REASON_TEXT QP_PREQ_GRP.VARCHAR_TYPE;
109: G_LDET_ACCUM_CONTEXT QP_PREQ_GRP.VARCHAR_TYPE; -- accum range break
110: G_LDET_ACCUM_ATTRIBUTE QP_PREQ_GRP.VARCHAR_TYPE; -- accum range break
111: G_LDET_ACCUM_FLAG QP_PREQ_GRP.VARCHAR_TYPE; -- accum range break
104: G_LDET_LINE_QUANTITY QP_PREQ_GRP.NUMBER_TYPE;
105: G_LDET_UPDATED_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
106: G_LDET_CALCULATION_CODE QP_PREQ_GRP.VARCHAR_TYPE;
107: G_LDET_CHANGE_REASON_CODE QP_PREQ_GRP.VARCHAR_TYPE;
108: G_LDET_CHANGE_REASON_TEXT QP_PREQ_GRP.VARCHAR_TYPE;
109: G_LDET_ACCUM_CONTEXT QP_PREQ_GRP.VARCHAR_TYPE; -- accum range break
110: G_LDET_ACCUM_ATTRIBUTE QP_PREQ_GRP.VARCHAR_TYPE; -- accum range break
111: G_LDET_ACCUM_FLAG QP_PREQ_GRP.VARCHAR_TYPE; -- accum range break
112: G_LDET_BREAK_UOM_CODE QP_PREQ_GRP.VARCHAR_TYPE; /* Proration*/
105: G_LDET_UPDATED_FLAG QP_PREQ_GRP.VARCHAR_TYPE;
106: G_LDET_CALCULATION_CODE QP_PREQ_GRP.VARCHAR_TYPE;
107: G_LDET_CHANGE_REASON_CODE QP_PREQ_GRP.VARCHAR_TYPE;
108: G_LDET_CHANGE_REASON_TEXT QP_PREQ_GRP.VARCHAR_TYPE;
109: G_LDET_ACCUM_CONTEXT QP_PREQ_GRP.VARCHAR_TYPE; -- accum range break
110: G_LDET_ACCUM_ATTRIBUTE QP_PREQ_GRP.VARCHAR_TYPE; -- accum range break
111: G_LDET_ACCUM_FLAG QP_PREQ_GRP.VARCHAR_TYPE; -- accum range break
112: G_LDET_BREAK_UOM_CODE QP_PREQ_GRP.VARCHAR_TYPE; /* Proration*/
113: G_LDET_BREAK_UOM_CONTEXT QP_PREQ_GRP.VARCHAR_TYPE; /* Proration*/
106: G_LDET_CALCULATION_CODE QP_PREQ_GRP.VARCHAR_TYPE;
107: G_LDET_CHANGE_REASON_CODE QP_PREQ_GRP.VARCHAR_TYPE;
108: G_LDET_CHANGE_REASON_TEXT QP_PREQ_GRP.VARCHAR_TYPE;
109: G_LDET_ACCUM_CONTEXT QP_PREQ_GRP.VARCHAR_TYPE; -- accum range break
110: G_LDET_ACCUM_ATTRIBUTE QP_PREQ_GRP.VARCHAR_TYPE; -- accum range break
111: G_LDET_ACCUM_FLAG QP_PREQ_GRP.VARCHAR_TYPE; -- accum range break
112: G_LDET_BREAK_UOM_CODE QP_PREQ_GRP.VARCHAR_TYPE; /* Proration*/
113: G_LDET_BREAK_UOM_CONTEXT QP_PREQ_GRP.VARCHAR_TYPE; /* Proration*/
114: G_LDET_BREAK_UOM_ATTRIBUTE QP_PREQ_GRP.VARCHAR_TYPE;
107: G_LDET_CHANGE_REASON_CODE QP_PREQ_GRP.VARCHAR_TYPE;
108: G_LDET_CHANGE_REASON_TEXT QP_PREQ_GRP.VARCHAR_TYPE;
109: G_LDET_ACCUM_CONTEXT QP_PREQ_GRP.VARCHAR_TYPE; -- accum range break
110: G_LDET_ACCUM_ATTRIBUTE QP_PREQ_GRP.VARCHAR_TYPE; -- accum range break
111: G_LDET_ACCUM_FLAG QP_PREQ_GRP.VARCHAR_TYPE; -- accum range break
112: G_LDET_BREAK_UOM_CODE QP_PREQ_GRP.VARCHAR_TYPE; /* Proration*/
113: G_LDET_BREAK_UOM_CONTEXT QP_PREQ_GRP.VARCHAR_TYPE; /* Proration*/
114: G_LDET_BREAK_UOM_ATTRIBUTE QP_PREQ_GRP.VARCHAR_TYPE;
115: G_LDET_ADJUSTMENT_AMOUNT QP_PREQ_GRP.NUMBER_TYPE;
108: G_LDET_CHANGE_REASON_TEXT QP_PREQ_GRP.VARCHAR_TYPE;
109: G_LDET_ACCUM_CONTEXT QP_PREQ_GRP.VARCHAR_TYPE; -- accum range break
110: G_LDET_ACCUM_ATTRIBUTE QP_PREQ_GRP.VARCHAR_TYPE; -- accum range break
111: G_LDET_ACCUM_FLAG QP_PREQ_GRP.VARCHAR_TYPE; -- accum range break
112: G_LDET_BREAK_UOM_CODE QP_PREQ_GRP.VARCHAR_TYPE; /* Proration*/
113: G_LDET_BREAK_UOM_CONTEXT QP_PREQ_GRP.VARCHAR_TYPE; /* Proration*/
114: G_LDET_BREAK_UOM_ATTRIBUTE QP_PREQ_GRP.VARCHAR_TYPE;
115: G_LDET_ADJUSTMENT_AMOUNT QP_PREQ_GRP.NUMBER_TYPE;
116:
109: G_LDET_ACCUM_CONTEXT QP_PREQ_GRP.VARCHAR_TYPE; -- accum range break
110: G_LDET_ACCUM_ATTRIBUTE QP_PREQ_GRP.VARCHAR_TYPE; -- accum range break
111: G_LDET_ACCUM_FLAG QP_PREQ_GRP.VARCHAR_TYPE; -- accum range break
112: G_LDET_BREAK_UOM_CODE QP_PREQ_GRP.VARCHAR_TYPE; /* Proration*/
113: G_LDET_BREAK_UOM_CONTEXT QP_PREQ_GRP.VARCHAR_TYPE; /* Proration*/
114: G_LDET_BREAK_UOM_ATTRIBUTE QP_PREQ_GRP.VARCHAR_TYPE;
115: G_LDET_ADJUSTMENT_AMOUNT QP_PREQ_GRP.NUMBER_TYPE;
116:
117: Procedure Preprocessing(
110: G_LDET_ACCUM_ATTRIBUTE QP_PREQ_GRP.VARCHAR_TYPE; -- accum range break
111: G_LDET_ACCUM_FLAG QP_PREQ_GRP.VARCHAR_TYPE; -- accum range break
112: G_LDET_BREAK_UOM_CODE QP_PREQ_GRP.VARCHAR_TYPE; /* Proration*/
113: G_LDET_BREAK_UOM_CONTEXT QP_PREQ_GRP.VARCHAR_TYPE; /* Proration*/
114: G_LDET_BREAK_UOM_ATTRIBUTE QP_PREQ_GRP.VARCHAR_TYPE;
115: G_LDET_ADJUSTMENT_AMOUNT QP_PREQ_GRP.NUMBER_TYPE;
116:
117: Procedure Preprocessing(
118: px_Header_Rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type
111: G_LDET_ACCUM_FLAG QP_PREQ_GRP.VARCHAR_TYPE; -- accum range break
112: G_LDET_BREAK_UOM_CODE QP_PREQ_GRP.VARCHAR_TYPE; /* Proration*/
113: G_LDET_BREAK_UOM_CONTEXT QP_PREQ_GRP.VARCHAR_TYPE; /* Proration*/
114: G_LDET_BREAK_UOM_ATTRIBUTE QP_PREQ_GRP.VARCHAR_TYPE;
115: G_LDET_ADJUSTMENT_AMOUNT QP_PREQ_GRP.NUMBER_TYPE;
116:
117: Procedure Preprocessing(
118: px_Header_Rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type
119: ,px_Line_Rec IN OUT NOCOPY OE_ORDER_PUB.Line_Rec_Type
145: G_PASS_LINE_TBL.delete;
146: qp_price_request_context.set_request_id;
147:
148: IF l_debug_level > 0 THEN
149: oe_debug_pub.add( ' REQUEST ID IS : ' || QP_PREQ_GRP.G_REQUEST_ID , 1 ) ;
150: END IF;
151:
152: -- Use the given header to price
153: OE_ORDER_PUB.g_hdr := px_header_rec;
210: WHEN OTHERS THEN
211: RAISE FND_API.G_EXC_ERROR;
212: END;
213:
214: G_LDET_LINE_DETAIL_INDEX(j) := QP_PREQ_GRP.GET_LINE_DETAIL_INDEX;
215: G_LDET_LINE_DETAIL_TYPE_CODE(j) := NULL;
216: G_LDET_PRICE_BREAK_TYPE_CODE(j) := NULL;
217: G_LDET_LINE_INDEX(j) := px_line_adj_tbl(i).header_id + nvl(px_line_adj_tbl(i).line_id, 0);
218: G_LDET_LIST_HEADER_ID(j) := px_line_adj_tbl(i).list_header_id;
268: ,p_calculate_price_flag varchar2
269: ,px_line_index in out NOCOPY NUMBER
270: )
271: is
272: l_req_line_rec QP_PREQ_GRP.LINE_REC_TYPE;
273: --l_line_index pls_integer := px_req_line_tbl.count;
274: --
275: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
276: --
284: px_line_index := px_line_index+1;
285:
286:
287: l_req_line_rec.CURRENCY_CODE := p_Header_rec.transactional_curr_code;
288: QP_PREQ_GRP.G_CURRENCY_CODE := l_req_line_rec.currency_code;
289: l_req_line_rec.PRICE_FLAG := p_calculate_price_flag;
290: l_req_line_rec.Active_date_first_type := 'ORD';
291: l_req_line_rec.Active_date_first := p_Header_rec.Ordered_date;
292:
321: G_CURRENCY_CODE_TBL(px_line_index) := p_header_rec.transactional_CURR_CODE;
322: G_UNIT_PRICE_TBL(px_line_index) := NULL;
323: G_PERCENT_PRICE_TBL(px_line_index) := NULL;
324: G_ADJUSTED_UNIT_PRICE_TBL(px_line_index) := NULL;
325: G_PROCESSED_FLAG_TBL(px_line_index) := QP_PREQ_GRP.G_NOT_PROCESSED;
326: G_PRICE_FLAG_TBL(px_line_index) := p_calculate_price_flag;
327: G_LINE_ID_TBL(px_line_index) := p_header_rec.header_id;
328: G_ROUNDING_FLAG_TBL(px_line_index)
329: := 'Q';
328: G_ROUNDING_FLAG_TBL(px_line_index)
329: := 'Q';
330: G_ROUNDING_FACTOR_TBL(px_line_index) := NULL;
331: G_PROCESSING_ORDER_TBL(px_line_index) := NULL;
332: G_PRICING_STATUS_CODE_tbl(px_line_index) := QP_PREQ_GRP.G_STATUS_UNCHANGED;
333: G_PRICING_STATUS_TEXT_tbl(px_line_index) := NULL;
334:
335: G_QUALIFIERS_EXIST_FLAG_TBL(px_line_index) :='N';
336: G_PRICING_ATTRS_EXIST_FLAG_TBL(px_line_index) :='N';
354: end copy_Header_to_request;
355:
356: procedure copy_Line_to_request(
357: p_Line_rec OE_Order_PUB.Line_Rec_Type
358: --,px_req_line_tbl in out nocopy QP_PREQ_GRP.LINE_TBL_TYPE
359: ,p_pricing_events varchar2
360: ,p_request_type_code varchar2
361: ,p_honor_price_flag varchar2
362: ,px_line_index in out NOCOPY NUMBER
424: G_CURRENCY_CODE_TBL(px_line_index) := oe_order_pub.g_hdr.TRANSACTIONAL_CURR_CODE;
425: G_UNIT_PRICE_TBL(px_line_index) := p_line_Rec.UNIT_LIST_PRICE_PER_PQTY;
426: G_PERCENT_PRICE_TBL(px_line_index) := NULL;
427: G_ADJUSTED_UNIT_PRICE_TBL(px_line_index) := p_line_rec.UNIT_SELLING_PRICE_PER_PQTY;
428: G_PROCESSED_FLAG_TBL(px_line_index) := QP_PREQ_GRP.G_NOT_PROCESSED;
429: G_PRICE_FLAG_TBL(px_line_index) := nvl(p_line_rec.CALCULATE_PRICE_FLAG,'Y');
430: G_LINE_ID_TBL(px_line_index) := p_line_rec.LINE_ID;
431: IF l_debug_level > 0 THEN
432: oe_debug_pub.add( 'LINE ID IN G_LINE_ID_TBL:'|| G_LINE_ID_TBL ( PX_LINE_INDEX ) ) ;
433: END IF;
434: G_ROUNDING_FLAG_TBL(px_line_index) := 'Q';
435: G_ROUNDING_FACTOR_TBL(px_line_index) := NULL;
436: G_PROCESSING_ORDER_TBL(px_line_index) := NULL;
437: G_PRICING_STATUS_CODE_tbl(px_line_index) := QP_PREQ_GRP.G_STATUS_UNCHANGED; -- AG
438: G_PRICING_STATUS_TEXT_tbl(px_line_index) := NULL;
439: G_QUALIFIERS_EXIST_FLAG_TBL(px_line_index) :='N';
440: G_PRICING_ATTRS_EXIST_FLAG_TBL(px_line_index) :='N';
441: G_PRICE_LIST_ID_TBL(px_line_index) :=p_line_rec.price_list_id;
572: l_return_status := FND_API.G_RET_STS_SUCCESS;
573: IF l_debug_level > 0 THEN
574: oe_debug_pub.add( 'BEFORE DIRECT INSERT INTO TEMP TABLE: BULK INSERT'||G_LINE_INDEX_TBL.COUNT , 1 ) ;
575: END IF;
576: QP_PREQ_GRP.INSERT_LINES2
577: (p_LINE_INDEX => G_LINE_INDEX_TBL,
578: p_LINE_TYPE_CODE => G_LINE_TYPE_CODE_TBL,
579: p_PRICING_EFFECTIVE_DATE =>G_PRICING_EFFECTIVE_DATE_TBL,
580: p_ACTIVE_DATE_FIRST =>G_ACTIVE_DATE_FIRST_TBL,
670: oe_debug_pub.add('41:'||G_LDET_BREAK_UOM_ATTRIBUTE(i));
671: END LOOP;
672: END IF;
673:
674: QP_PREQ_GRP.INSERT_LDETS2
675: (p_LINE_DETAIL_INDEX => G_LDET_LINE_DETAIL_INDEX,
676: p_LINE_DETAIL_TYPE_CODE => G_LDET_LINE_DETAIL_TYPE_CODE,
677: p_PRICE_BREAK_TYPE_CODE => G_LDET_PRICE_BREAK_TYPE_CODE,
678: p_LINE_INDEX => G_LDET_LINE_INDEX,
726: END IF;
727: END IF;
728:
729: IF G_ATTR_LINE_INDEX_tbl.count > 0 THEN
730: QP_PREQ_GRP.INSERT_LINE_ATTRS2
731: ( G_ATTR_LINE_INDEX_tbl,
732: G_ATTR_LINE_DETAIL_INDEX_tbl ,
733: G_ATTR_ATTRIBUTE_LEVEL_tbl ,
734: G_ATTR_ATTRIBUTE_TYPE_tbl ,
929: , priced_uom_code
930: from qp_preq_lines_tmp
931: where process_status <> 'NOT_VALID' and
932: (pricing_status_code not in
933: (QP_PREQ_GRP.G_STATUS_UNCHANGED,
934: QP_PREQ_GRP.G_STATUS_UPDATED,
935: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION,
936: 'NOT_VALID')
937: OR (l_allow_negative_price = 'N' AND (unit_price<0 OR adjusted_unit_price<0)));
930: from qp_preq_lines_tmp
931: where process_status <> 'NOT_VALID' and
932: (pricing_status_code not in
933: (QP_PREQ_GRP.G_STATUS_UNCHANGED,
934: QP_PREQ_GRP.G_STATUS_UPDATED,
935: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION,
936: 'NOT_VALID')
937: OR (l_allow_negative_price = 'N' AND (unit_price<0 OR adjusted_unit_price<0)));
938: cursor wrong_book_lines is
931: where process_status <> 'NOT_VALID' and
932: (pricing_status_code not in
933: (QP_PREQ_GRP.G_STATUS_UNCHANGED,
934: QP_PREQ_GRP.G_STATUS_UPDATED,
935: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION,
936: 'NOT_VALID')
937: OR (l_allow_negative_price = 'N' AND (unit_price<0 OR adjusted_unit_price<0)));
938: cursor wrong_book_lines is
939: select lines.line_id
955: or lines.price_list_header_id is NULL)
956: and lines.process_status <> 'NOT_VALID'
957: ;
958: -- Bug 2079138: booked lines should always have price
959: --and lines.pricing_status_code in (QP_PREQ_GRP.G_STATUS_UPDATED
960: -- , QP_PREQ_GRP.G_STATUS_GSA_VIOLATION
961: -- );
962: --
963: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
956: and lines.process_status <> 'NOT_VALID'
957: ;
958: -- Bug 2079138: booked lines should always have price
959: --and lines.pricing_status_code in (QP_PREQ_GRP.G_STATUS_UPDATED
960: -- , QP_PREQ_GRP.G_STATUS_GSA_VIOLATION
961: -- );
962: --
963: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
964: --
1011: END IF;
1012: l_invalid_line := 'N';
1013: -- add message when the price list is found to be inactive
1014: IF wrong_line.line_Type_code ='LINE' and
1015: wrong_line.processed_code = QP_PREQ_GRP.G_STS_LHS_NOT_FOUND Then
1016: IF l_debug_level > 0 THEN
1017: oe_debug_pub.add( 'PRICE LIST NOT FOUND' ) ;
1018: END IF;
1019: IF l_debug_level > 0 THEN
1035: l_invalid_line := 'Y';
1036: END IF;
1037:
1038: if wrong_line.line_Type_code ='LINE' and
1039: wrong_line.pricing_status_code in ( QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST,
1040: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND,
1041: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,
1042: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
1043: FND_API.G_RET_STS_UNEXP_ERROR,
1036: END IF;
1037:
1038: if wrong_line.line_Type_code ='LINE' and
1039: wrong_line.pricing_status_code in ( QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST,
1040: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND,
1041: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,
1042: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
1043: FND_API.G_RET_STS_UNEXP_ERROR,
1044: FND_API.G_RET_STS_ERROR,
1037:
1038: if wrong_line.line_Type_code ='LINE' and
1039: wrong_line.pricing_status_code in ( QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST,
1040: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND,
1041: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,
1042: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
1043: FND_API.G_RET_STS_UNEXP_ERROR,
1044: FND_API.G_RET_STS_ERROR,
1045: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
1038: if wrong_line.line_Type_code ='LINE' and
1039: wrong_line.pricing_status_code in ( QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST,
1040: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND,
1041: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,
1042: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
1043: FND_API.G_RET_STS_UNEXP_ERROR,
1044: FND_API.G_RET_STS_ERROR,
1045: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
1046: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
1041: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,
1042: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
1043: FND_API.G_RET_STS_UNEXP_ERROR,
1044: FND_API.G_RET_STS_ERROR,
1045: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
1046: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
1047: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
1048: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
1049: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,
1042: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
1043: FND_API.G_RET_STS_UNEXP_ERROR,
1044: FND_API.G_RET_STS_ERROR,
1045: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
1046: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
1047: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
1048: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
1049: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,
1050: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP,
1043: FND_API.G_RET_STS_UNEXP_ERROR,
1044: FND_API.G_RET_STS_ERROR,
1045: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
1046: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
1047: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
1048: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
1049: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,
1050: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP,
1051: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR)
1044: FND_API.G_RET_STS_ERROR,
1045: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
1046: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
1047: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
1048: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
1049: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,
1050: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP,
1051: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR)
1052: then
1045: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
1046: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
1047: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
1048: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
1049: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,
1050: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP,
1051: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR)
1052: then
1053:
1046: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
1047: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
1048: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
1049: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,
1050: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP,
1051: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR)
1052: then
1053:
1054: l_invalid_line := 'Y';
1047: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
1048: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
1049: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,
1050: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP,
1051: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR)
1052: then
1053:
1054: l_invalid_line := 'Y';
1055: Begin
1059: Exception When No_data_found then
1060: l_price_list := l_line_rec.price_list_id;
1061: End;
1062:
1063: If wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST then
1064: IF l_debug_level > 0 THEN
1065: oe_debug_pub.add( 'INVALID ITEM/PRICE LIST COMBINATION'||L_LINE_REC.ORDERED_ITEM||L_LINE_REC.ORDER_QUANTITY_UOM||L_PRICE_LIST ) ;
1066: END IF;
1067: FND_MESSAGE.SET_NAME('ONT','OE_PRC_NO_LIST_PRICE');
1105: l_line_rec.unit_list_price_per_pqty := NULL;
1106: END IF;
1107:
1108:
1109: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STS_LHS_NOT_FOUND Then
1110: IF l_debug_level > 0 THEN
1111: oe_debug_pub.add( 'PRICE LIST NOT FOUND' ) ;
1112: END IF;
1113: FND_MESSAGE.SET_NAME('ONT','ONT_NO_PRICE_LIST_FOUND');
1121: end if;
1122: else
1123: OE_MSG_PUB.Add;
1124: end if;
1125: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_FORMULA_ERROR then
1126: IF l_debug_level > 0 THEN
1127: oe_debug_pub.add( 'ERROR IN FORMULA PROCESSING' ) ;
1128: END IF;
1129: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_ERROR_IN_FORMULA');
1137: else
1138: OE_MSG_PUB.Add;
1139: end if;
1140: Elsif wrong_line.pricing_status_code in
1141: ( QP_PREQ_GRP.G_STATUS_OTHER_ERRORS , FND_API.G_RET_STS_UNEXP_ERROR,
1142: FND_API.G_RET_STS_ERROR)
1143: then
1144: IF l_debug_level > 0 THEN
1145: oe_debug_pub.add( 'OTHER ERRORS PROCESSING' ) ;
1154: end if;
1155: else
1156: OE_MSG_PUB.Add;
1157: end if;
1158: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM then
1159: IF l_debug_level > 0 THEN
1160: oe_debug_pub.add( 'INVALID UOM' ) ;
1161: END IF;
1162: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM');
1170: end if;
1171: else
1172: OE_MSG_PUB.Add;
1173: end if;
1174: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST then
1175: IF l_debug_level > 0 THEN
1176: oe_debug_pub.add( 'DUPLICATE PRICE LIST' ) ;
1177: END IF;
1178: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_DUPLICATE_PRICE_LIST');
1218: end if;
1219: else
1220: OE_MSG_PUB.Add;
1221: end if;
1222: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV then
1223: IF l_debug_level > 0 THEN
1224: oe_debug_pub.add( 'INVALID UOM CONVERSION' ) ;
1225: END IF;
1226: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM_CONVERSION');
1234: end if;
1235: else
1236: OE_MSG_PUB.Add;
1237: end if;
1238: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_INVALID_INCOMP then
1239: IF l_debug_level > 0 THEN
1240: oe_debug_pub.add( 'UNABLE TO RESOLVE INCOMPATIBILITY' ) ;
1241: END IF;
1242: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_INCOMP');
1250: end if;
1251: else
1252: OE_MSG_PUB.Add;
1253: end if;
1254: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR then
1255: IF l_debug_level > 0 THEN
1256: oe_debug_pub.add( 'ERROR WHILE EVALUATING THE BEST PRICE' ) ;
1257: END IF;
1258: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_BEST_PRICE_ERROR');
1304: --btea end
1305:
1306: elsif
1307: wrong_line.line_Type_code ='LINE' and
1308: wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS
1309: Then
1310:
1311: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
1312: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '
1480: , QP_PREQ_LINES_TMP lines
1481: , QP_LIST_HEADERS_B QH
1482: WHERE
1483: ldets.list_header_id=qh.list_header_id
1484: AND ldets.process_code in (QP_PREQ_GRP.G_STATUS_NEW, QP_PREQ_GRP.G_STATUS_UPDATED, QP_PREQ_GRP.G_STATUS_UNCHANGED)
1485: AND lines.pricing_status_code in (QP_PREQ_GRP.G_STATUS_NEW,QP_PREQ_GRP.G_STATUS_UPDATED,QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)
1486: AND lines.process_status <> 'NOT_VALID'
1487: AND ldets.line_index=lines.line_index
1488: --AND ldets.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW
1481: , QP_LIST_HEADERS_B QH
1482: WHERE
1483: ldets.list_header_id=qh.list_header_id
1484: AND ldets.process_code in (QP_PREQ_GRP.G_STATUS_NEW, QP_PREQ_GRP.G_STATUS_UPDATED, QP_PREQ_GRP.G_STATUS_UNCHANGED)
1485: AND lines.pricing_status_code in (QP_PREQ_GRP.G_STATUS_NEW,QP_PREQ_GRP.G_STATUS_UPDATED,QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)
1486: AND lines.process_status <> 'NOT_VALID'
1487: AND ldets.line_index=lines.line_index
1488: --AND ldets.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW
1489: --AND nvl(ldets.automatic_flag,'N') = 'Y'
1484: AND ldets.process_code in (QP_PREQ_GRP.G_STATUS_NEW, QP_PREQ_GRP.G_STATUS_UPDATED, QP_PREQ_GRP.G_STATUS_UNCHANGED)
1485: AND lines.pricing_status_code in (QP_PREQ_GRP.G_STATUS_NEW,QP_PREQ_GRP.G_STATUS_UPDATED,QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)
1486: AND lines.process_status <> 'NOT_VALID'
1487: AND ldets.line_index=lines.line_index
1488: --AND ldets.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW
1489: --AND nvl(ldets.automatic_flag,'N') = 'Y'
1490: -- or
1491: -- (ldets.list_line_type_code = 'FREIGHT_CHARGE'))
1492: AND ldets.created_from_list_type_code not in ('PRL','AGR')
1665:
1666: )
1667: IS
1668: l_return_status_text varchar(2000);
1669: l_control_rec QP_PREQ_GRP.control_record_type;
1670: l_set_of_books Oe_Order_Cache.Set_Of_Books_Rec_Type;
1671: --
1672: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1673: --
1788: where lines.line_id=l_line_rec.line_id
1789: and lines.line_type_code='LINE'
1790: and l_line_rec.ordered_quantity <> 0
1791: and lines.process_status <> 'NOT_VALID'
1792: and lines.pricing_status_code in (QP_PREQ_GRP.G_STATUS_GSA_VIOLATION,
1793: QP_PREQ_GRP.G_STATUS_UPDATED)
1794: ;
1795: EXCEPTION
1796: WHEN OTHERS THEN
1789: and lines.line_type_code='LINE'
1790: and l_line_rec.ordered_quantity <> 0
1791: and lines.process_status <> 'NOT_VALID'
1792: and lines.pricing_status_code in (QP_PREQ_GRP.G_STATUS_GSA_VIOLATION,
1793: QP_PREQ_GRP.G_STATUS_UPDATED)
1794: ;
1795: EXCEPTION
1796: WHEN OTHERS THEN
1797: