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

Line 10: G_LINE_INDEX_tbl QP_PREQ_GRP.pls_integer_type;

6: -- History :
7: -- NOTE :
8: -- End of Comments
9:
10: G_LINE_INDEX_tbl QP_PREQ_GRP.pls_integer_type;
11: G_LINE_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
12: G_PRICING_EFFECTIVE_DATE_TBL QP_PREQ_GRP.DATE_TYPE;
13: G_ACTIVE_DATE_FIRST_TBL QP_PREQ_GRP.DATE_TYPE;
14: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 11: G_LINE_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

7: -- NOTE :
8: -- End of Comments
9:
10: G_LINE_INDEX_tbl QP_PREQ_GRP.pls_integer_type;
11: G_LINE_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
12: G_PRICING_EFFECTIVE_DATE_TBL QP_PREQ_GRP.DATE_TYPE;
13: G_ACTIVE_DATE_FIRST_TBL QP_PREQ_GRP.DATE_TYPE;
14: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
15: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;

Line 12: G_PRICING_EFFECTIVE_DATE_TBL QP_PREQ_GRP.DATE_TYPE;

8: -- End of Comments
9:
10: G_LINE_INDEX_tbl QP_PREQ_GRP.pls_integer_type;
11: G_LINE_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
12: G_PRICING_EFFECTIVE_DATE_TBL QP_PREQ_GRP.DATE_TYPE;
13: G_ACTIVE_DATE_FIRST_TBL QP_PREQ_GRP.DATE_TYPE;
14: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
15: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
16: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;

Line 13: G_ACTIVE_DATE_FIRST_TBL QP_PREQ_GRP.DATE_TYPE;

9:
10: G_LINE_INDEX_tbl QP_PREQ_GRP.pls_integer_type;
11: G_LINE_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
12: G_PRICING_EFFECTIVE_DATE_TBL QP_PREQ_GRP.DATE_TYPE;
13: G_ACTIVE_DATE_FIRST_TBL QP_PREQ_GRP.DATE_TYPE;
14: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
15: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
16: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
17: G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;

Line 14: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

10: G_LINE_INDEX_tbl QP_PREQ_GRP.pls_integer_type;
11: G_LINE_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
12: G_PRICING_EFFECTIVE_DATE_TBL QP_PREQ_GRP.DATE_TYPE;
13: G_ACTIVE_DATE_FIRST_TBL QP_PREQ_GRP.DATE_TYPE;
14: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
15: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
16: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
17: G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
18: G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 15: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;

11: G_LINE_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
12: G_PRICING_EFFECTIVE_DATE_TBL QP_PREQ_GRP.DATE_TYPE;
13: G_ACTIVE_DATE_FIRST_TBL QP_PREQ_GRP.DATE_TYPE;
14: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
15: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
16: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
17: G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
18: G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
19: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 16: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;

12: G_PRICING_EFFECTIVE_DATE_TBL QP_PREQ_GRP.DATE_TYPE;
13: G_ACTIVE_DATE_FIRST_TBL QP_PREQ_GRP.DATE_TYPE;
14: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
15: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
16: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
17: G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
18: G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
19: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
20: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;

Line 17: G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;

13: G_ACTIVE_DATE_FIRST_TBL QP_PREQ_GRP.DATE_TYPE;
14: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
15: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
16: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
17: G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
18: G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
19: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
20: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
21: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;

Line 18: G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

14: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
15: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
16: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
17: G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
18: G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
19: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
20: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
21: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
22: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 19: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

15: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE ;
16: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
17: G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
18: G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
19: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
20: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
21: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
22: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
23: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 20: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;

16: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE ;
17: G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
18: G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
19: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
20: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
21: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
22: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
23: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
24: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;

Line 21: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;

17: G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE ;
18: G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
19: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
20: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
21: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
22: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
23: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
24: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
25: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;

Line 22: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

18: G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
19: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
20: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
21: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
22: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
23: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
24: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
25: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
26: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;

Line 23: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

19: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
20: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
21: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
22: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
23: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
24: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
25: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
26: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
27: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;

Line 24: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;

20: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
21: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
22: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
23: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
24: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
25: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
26: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
27: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
28: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 25: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;

21: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
22: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
23: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
24: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
25: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
26: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
27: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
28: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
29: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 26: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;

22: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
23: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
24: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
25: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
26: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
27: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
28: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
29: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
30: G_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;

Line 27: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;

23: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
24: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
25: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
26: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
27: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
28: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
29: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
30: G_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
31: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;

Line 28: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

24: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
25: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
26: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
27: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
28: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
29: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
30: G_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
31: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
32: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;

Line 29: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

25: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
26: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
27: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
28: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
29: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
30: G_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
31: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
32: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
33: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;

Line 30: G_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;

26: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
27: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
28: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
29: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
30: G_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
31: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
32: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
33: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
34: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 31: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;

27: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
28: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
29: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
30: G_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
31: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
32: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
33: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
34: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
35: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 32: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;

28: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
29: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
30: G_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
31: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
32: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
33: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
34: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
35: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
36: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;

Line 33: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;

29: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
30: G_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
31: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
32: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
33: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
34: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
35: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
36: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
37: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 34: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

30: G_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
31: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
32: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
33: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
34: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
35: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
36: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
37: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
38: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 35: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

31: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
32: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
33: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
34: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
35: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
36: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
37: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
38: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
39: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 36: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;

32: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
33: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
34: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
35: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
36: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
37: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
38: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
39: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
40: G_LINE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 37: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

33: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;
34: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
35: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
36: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
37: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
38: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
39: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
40: G_LINE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
41: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 38: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

34: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
35: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
36: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
37: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
38: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
39: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
40: G_LINE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
41: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
42: G_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 39: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

35: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
36: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
37: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
38: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
39: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
40: G_LINE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
41: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
42: G_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
43: G_CHRG_PERIODICITY_CODE_TBL QP_PREQ_GRP.VARCHAR_3_TYPE;

Line 40: G_LINE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;

36: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
37: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
38: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
39: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
40: G_LINE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
41: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
42: G_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
43: G_CHRG_PERIODICITY_CODE_TBL QP_PREQ_GRP.VARCHAR_3_TYPE;
44: /* Changes Made for OKS uptake bug 4900084 */

Line 41: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;

37: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
38: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
39: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
40: G_LINE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
41: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
42: G_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
43: G_CHRG_PERIODICITY_CODE_TBL QP_PREQ_GRP.VARCHAR_3_TYPE;
44: /* Changes Made for OKS uptake bug 4900084 */
45: G_CONTRACT_START_DATE_TBL QP_PREQ_GRP.DATE_TYPE;

Line 42: G_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;

38: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
39: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
40: G_LINE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
41: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
42: G_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
43: G_CHRG_PERIODICITY_CODE_TBL QP_PREQ_GRP.VARCHAR_3_TYPE;
44: /* Changes Made for OKS uptake bug 4900084 */
45: G_CONTRACT_START_DATE_TBL QP_PREQ_GRP.DATE_TYPE;
46: G_CONTRACT_END_DATE_TBL QP_PREQ_GRP.DATE_TYPE;

Line 43: G_CHRG_PERIODICITY_CODE_TBL QP_PREQ_GRP.VARCHAR_3_TYPE;

39: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
40: G_LINE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
41: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
42: G_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
43: G_CHRG_PERIODICITY_CODE_TBL QP_PREQ_GRP.VARCHAR_3_TYPE;
44: /* Changes Made for OKS uptake bug 4900084 */
45: G_CONTRACT_START_DATE_TBL QP_PREQ_GRP.DATE_TYPE;
46: G_CONTRACT_END_DATE_TBL QP_PREQ_GRP.DATE_TYPE;
47:

Line 45: G_CONTRACT_START_DATE_TBL QP_PREQ_GRP.DATE_TYPE;

41: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
42: G_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
43: G_CHRG_PERIODICITY_CODE_TBL QP_PREQ_GRP.VARCHAR_3_TYPE;
44: /* Changes Made for OKS uptake bug 4900084 */
45: G_CONTRACT_START_DATE_TBL QP_PREQ_GRP.DATE_TYPE;
46: G_CONTRACT_END_DATE_TBL QP_PREQ_GRP.DATE_TYPE;
47:
48: G_ATTR_LINE_INDEX_tbl QP_PREQ_GRP.pls_integer_type;
49: G_ATTR_LINE_DETAIL_INDEX_tbl QP_PREQ_GRP.pls_integer_type;

Line 46: G_CONTRACT_END_DATE_TBL QP_PREQ_GRP.DATE_TYPE;

42: G_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
43: G_CHRG_PERIODICITY_CODE_TBL QP_PREQ_GRP.VARCHAR_3_TYPE;
44: /* Changes Made for OKS uptake bug 4900084 */
45: G_CONTRACT_START_DATE_TBL QP_PREQ_GRP.DATE_TYPE;
46: G_CONTRACT_END_DATE_TBL QP_PREQ_GRP.DATE_TYPE;
47:
48: G_ATTR_LINE_INDEX_tbl QP_PREQ_GRP.pls_integer_type;
49: G_ATTR_LINE_DETAIL_INDEX_tbl QP_PREQ_GRP.pls_integer_type;
50: G_ATTR_VALIDATED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 48: G_ATTR_LINE_INDEX_tbl QP_PREQ_GRP.pls_integer_type;

44: /* Changes Made for OKS uptake bug 4900084 */
45: G_CONTRACT_START_DATE_TBL QP_PREQ_GRP.DATE_TYPE;
46: G_CONTRACT_END_DATE_TBL QP_PREQ_GRP.DATE_TYPE;
47:
48: G_ATTR_LINE_INDEX_tbl QP_PREQ_GRP.pls_integer_type;
49: G_ATTR_LINE_DETAIL_INDEX_tbl QP_PREQ_GRP.pls_integer_type;
50: G_ATTR_VALIDATED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
51: G_ATTR_PRICING_CONTEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
52: G_ATTR_PRICING_ATTRIBUTE_tbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 49: G_ATTR_LINE_DETAIL_INDEX_tbl QP_PREQ_GRP.pls_integer_type;

45: G_CONTRACT_START_DATE_TBL QP_PREQ_GRP.DATE_TYPE;
46: G_CONTRACT_END_DATE_TBL QP_PREQ_GRP.DATE_TYPE;
47:
48: G_ATTR_LINE_INDEX_tbl QP_PREQ_GRP.pls_integer_type;
49: G_ATTR_LINE_DETAIL_INDEX_tbl QP_PREQ_GRP.pls_integer_type;
50: G_ATTR_VALIDATED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
51: G_ATTR_PRICING_CONTEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
52: G_ATTR_PRICING_ATTRIBUTE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
53: G_ATTR_ATTRIBUTE_LEVEL_tbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 50: G_ATTR_VALIDATED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;

46: G_CONTRACT_END_DATE_TBL QP_PREQ_GRP.DATE_TYPE;
47:
48: G_ATTR_LINE_INDEX_tbl QP_PREQ_GRP.pls_integer_type;
49: G_ATTR_LINE_DETAIL_INDEX_tbl QP_PREQ_GRP.pls_integer_type;
50: G_ATTR_VALIDATED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
51: G_ATTR_PRICING_CONTEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
52: G_ATTR_PRICING_ATTRIBUTE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
53: G_ATTR_ATTRIBUTE_LEVEL_tbl QP_PREQ_GRP.VARCHAR_TYPE;
54: G_ATTR_ATTRIBUTE_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 51: G_ATTR_PRICING_CONTEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;

47:
48: G_ATTR_LINE_INDEX_tbl QP_PREQ_GRP.pls_integer_type;
49: G_ATTR_LINE_DETAIL_INDEX_tbl QP_PREQ_GRP.pls_integer_type;
50: G_ATTR_VALIDATED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
51: G_ATTR_PRICING_CONTEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
52: G_ATTR_PRICING_ATTRIBUTE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
53: G_ATTR_ATTRIBUTE_LEVEL_tbl QP_PREQ_GRP.VARCHAR_TYPE;
54: G_ATTR_ATTRIBUTE_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
55: G_ATTR_APPLIED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 52: G_ATTR_PRICING_ATTRIBUTE_tbl QP_PREQ_GRP.VARCHAR_TYPE;

48: G_ATTR_LINE_INDEX_tbl QP_PREQ_GRP.pls_integer_type;
49: G_ATTR_LINE_DETAIL_INDEX_tbl QP_PREQ_GRP.pls_integer_type;
50: G_ATTR_VALIDATED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
51: G_ATTR_PRICING_CONTEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
52: G_ATTR_PRICING_ATTRIBUTE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
53: G_ATTR_ATTRIBUTE_LEVEL_tbl QP_PREQ_GRP.VARCHAR_TYPE;
54: G_ATTR_ATTRIBUTE_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
55: G_ATTR_APPLIED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
56: G_ATTR_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 53: G_ATTR_ATTRIBUTE_LEVEL_tbl QP_PREQ_GRP.VARCHAR_TYPE;

49: G_ATTR_LINE_DETAIL_INDEX_tbl QP_PREQ_GRP.pls_integer_type;
50: G_ATTR_VALIDATED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
51: G_ATTR_PRICING_CONTEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
52: G_ATTR_PRICING_ATTRIBUTE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
53: G_ATTR_ATTRIBUTE_LEVEL_tbl QP_PREQ_GRP.VARCHAR_TYPE;
54: G_ATTR_ATTRIBUTE_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
55: G_ATTR_APPLIED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
56: G_ATTR_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
57: G_ATTR_PRICING_ATTR_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 54: G_ATTR_ATTRIBUTE_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;

50: G_ATTR_VALIDATED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
51: G_ATTR_PRICING_CONTEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
52: G_ATTR_PRICING_ATTRIBUTE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
53: G_ATTR_ATTRIBUTE_LEVEL_tbl QP_PREQ_GRP.VARCHAR_TYPE;
54: G_ATTR_ATTRIBUTE_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
55: G_ATTR_APPLIED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
56: G_ATTR_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
57: G_ATTR_PRICING_ATTR_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
58: G_ATTR_LIST_HEADER_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;

Line 55: G_ATTR_APPLIED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;

51: G_ATTR_PRICING_CONTEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
52: G_ATTR_PRICING_ATTRIBUTE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
53: G_ATTR_ATTRIBUTE_LEVEL_tbl QP_PREQ_GRP.VARCHAR_TYPE;
54: G_ATTR_ATTRIBUTE_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
55: G_ATTR_APPLIED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
56: G_ATTR_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
57: G_ATTR_PRICING_ATTR_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
58: G_ATTR_LIST_HEADER_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
59: G_ATTR_LIST_LINE_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;

Line 56: G_ATTR_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;

52: G_ATTR_PRICING_ATTRIBUTE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
53: G_ATTR_ATTRIBUTE_LEVEL_tbl QP_PREQ_GRP.VARCHAR_TYPE;
54: G_ATTR_ATTRIBUTE_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
55: G_ATTR_APPLIED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
56: G_ATTR_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
57: G_ATTR_PRICING_ATTR_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
58: G_ATTR_LIST_HEADER_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
59: G_ATTR_LIST_LINE_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
60: G_ATTR_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 57: G_ATTR_PRICING_ATTR_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;

53: G_ATTR_ATTRIBUTE_LEVEL_tbl QP_PREQ_GRP.VARCHAR_TYPE;
54: G_ATTR_ATTRIBUTE_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
55: G_ATTR_APPLIED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
56: G_ATTR_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
57: G_ATTR_PRICING_ATTR_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
58: G_ATTR_LIST_HEADER_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
59: G_ATTR_LIST_LINE_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
60: G_ATTR_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
61: G_ATTR_SETUP_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 58: G_ATTR_LIST_HEADER_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;

54: G_ATTR_ATTRIBUTE_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
55: G_ATTR_APPLIED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
56: G_ATTR_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
57: G_ATTR_PRICING_ATTR_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
58: G_ATTR_LIST_HEADER_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
59: G_ATTR_LIST_LINE_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
60: G_ATTR_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
61: G_ATTR_SETUP_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
62: G_ATTR_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 59: G_ATTR_LIST_LINE_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;

55: G_ATTR_APPLIED_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
56: G_ATTR_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
57: G_ATTR_PRICING_ATTR_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
58: G_ATTR_LIST_HEADER_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
59: G_ATTR_LIST_LINE_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
60: G_ATTR_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
61: G_ATTR_SETUP_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
62: G_ATTR_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
63: G_ATTR_SETUP_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 60: G_ATTR_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;

56: G_ATTR_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
57: G_ATTR_PRICING_ATTR_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
58: G_ATTR_LIST_HEADER_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
59: G_ATTR_LIST_LINE_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
60: G_ATTR_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
61: G_ATTR_SETUP_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
62: G_ATTR_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
63: G_ATTR_SETUP_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
64: G_ATTR_GROUPING_NUMBER_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;

Line 61: G_ATTR_SETUP_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;

57: G_ATTR_PRICING_ATTR_FLAG_tbl QP_PREQ_GRP.VARCHAR_TYPE;
58: G_ATTR_LIST_HEADER_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
59: G_ATTR_LIST_LINE_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
60: G_ATTR_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
61: G_ATTR_SETUP_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
62: G_ATTR_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
63: G_ATTR_SETUP_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
64: G_ATTR_GROUPING_NUMBER_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
65: G_ATTR_NO_QUAL_IN_GRP_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;

Line 62: G_ATTR_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;

58: G_ATTR_LIST_HEADER_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
59: G_ATTR_LIST_LINE_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
60: G_ATTR_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
61: G_ATTR_SETUP_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
62: G_ATTR_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
63: G_ATTR_SETUP_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
64: G_ATTR_GROUPING_NUMBER_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
65: G_ATTR_NO_QUAL_IN_GRP_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
66: G_ATTR_COMP_OPERATOR_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 63: G_ATTR_SETUP_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;

59: G_ATTR_LIST_LINE_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;
60: G_ATTR_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
61: G_ATTR_SETUP_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
62: G_ATTR_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
63: G_ATTR_SETUP_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
64: G_ATTR_GROUPING_NUMBER_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
65: G_ATTR_NO_QUAL_IN_GRP_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
66: G_ATTR_COMP_OPERATOR_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
67: G_ATTR_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 64: G_ATTR_GROUPING_NUMBER_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;

60: G_ATTR_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
61: G_ATTR_SETUP_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
62: G_ATTR_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
63: G_ATTR_SETUP_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
64: G_ATTR_GROUPING_NUMBER_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
65: G_ATTR_NO_QUAL_IN_GRP_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
66: G_ATTR_COMP_OPERATOR_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
67: G_ATTR_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
68: G_ATTR_QUAL_PRECEDENCE_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;

Line 65: G_ATTR_NO_QUAL_IN_GRP_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;

61: G_ATTR_SETUP_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;
62: G_ATTR_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
63: G_ATTR_SETUP_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
64: G_ATTR_GROUPING_NUMBER_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
65: G_ATTR_NO_QUAL_IN_GRP_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
66: G_ATTR_COMP_OPERATOR_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
67: G_ATTR_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
68: G_ATTR_QUAL_PRECEDENCE_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
69: G_ATTR_DATATYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 66: G_ATTR_COMP_OPERATOR_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;

62: G_ATTR_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
63: G_ATTR_SETUP_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
64: G_ATTR_GROUPING_NUMBER_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
65: G_ATTR_NO_QUAL_IN_GRP_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
66: G_ATTR_COMP_OPERATOR_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
67: G_ATTR_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
68: G_ATTR_QUAL_PRECEDENCE_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
69: G_ATTR_DATATYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
70: G_ATTR_QUALIFIER_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 67: G_ATTR_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;

63: G_ATTR_SETUP_VALUE_TO_tbl QP_PREQ_GRP.VARCHAR_TYPE;
64: G_ATTR_GROUPING_NUMBER_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
65: G_ATTR_NO_QUAL_IN_GRP_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
66: G_ATTR_COMP_OPERATOR_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
67: G_ATTR_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
68: G_ATTR_QUAL_PRECEDENCE_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
69: G_ATTR_DATATYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
70: G_ATTR_QUALIFIER_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
71: G_ATTR_PRODUCT_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 68: G_ATTR_QUAL_PRECEDENCE_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;

64: G_ATTR_GROUPING_NUMBER_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
65: G_ATTR_NO_QUAL_IN_GRP_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
66: G_ATTR_COMP_OPERATOR_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
67: G_ATTR_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
68: G_ATTR_QUAL_PRECEDENCE_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
69: G_ATTR_DATATYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
70: G_ATTR_QUALIFIER_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
71: G_ATTR_PRODUCT_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
72: G_ATTR_EXCLUDER_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 69: G_ATTR_DATATYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;

65: G_ATTR_NO_QUAL_IN_GRP_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
66: G_ATTR_COMP_OPERATOR_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
67: G_ATTR_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
68: G_ATTR_QUAL_PRECEDENCE_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
69: G_ATTR_DATATYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
70: G_ATTR_QUALIFIER_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
71: G_ATTR_PRODUCT_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
72: G_ATTR_EXCLUDER_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
73: G_ATTR_PRICING_PHASE_ID_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;

Line 70: G_ATTR_QUALIFIER_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;

66: G_ATTR_COMP_OPERATOR_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
67: G_ATTR_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
68: G_ATTR_QUAL_PRECEDENCE_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
69: G_ATTR_DATATYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
70: G_ATTR_QUALIFIER_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
71: G_ATTR_PRODUCT_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
72: G_ATTR_EXCLUDER_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
73: G_ATTR_PRICING_PHASE_ID_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
74: G_ATTR_INCOM_GRP_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 71: G_ATTR_PRODUCT_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

67: G_ATTR_PRICING_STATUS_TEXT_tbl QP_PREQ_GRP.VARCHAR_TYPE;
68: G_ATTR_QUAL_PRECEDENCE_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
69: G_ATTR_DATATYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
70: G_ATTR_QUALIFIER_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
71: G_ATTR_PRODUCT_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
72: G_ATTR_EXCLUDER_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
73: G_ATTR_PRICING_PHASE_ID_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
74: G_ATTR_INCOM_GRP_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
75: G_ATTR_LDET_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 72: G_ATTR_EXCLUDER_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

68: G_ATTR_QUAL_PRECEDENCE_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;
69: G_ATTR_DATATYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
70: G_ATTR_QUALIFIER_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
71: G_ATTR_PRODUCT_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
72: G_ATTR_EXCLUDER_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
73: G_ATTR_PRICING_PHASE_ID_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
74: G_ATTR_INCOM_GRP_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
75: G_ATTR_LDET_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
76: G_ATTR_MODIFIER_LEVEL_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 73: G_ATTR_PRICING_PHASE_ID_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;

69: G_ATTR_DATATYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
70: G_ATTR_QUALIFIER_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
71: G_ATTR_PRODUCT_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
72: G_ATTR_EXCLUDER_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
73: G_ATTR_PRICING_PHASE_ID_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
74: G_ATTR_INCOM_GRP_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
75: G_ATTR_LDET_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
76: G_ATTR_MODIFIER_LEVEL_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
77: G_ATTR_PRIMARY_UOM_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 74: G_ATTR_INCOM_GRP_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

70: G_ATTR_QUALIFIER_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;
71: G_ATTR_PRODUCT_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
72: G_ATTR_EXCLUDER_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
73: G_ATTR_PRICING_PHASE_ID_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
74: G_ATTR_INCOM_GRP_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
75: G_ATTR_LDET_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
76: G_ATTR_MODIFIER_LEVEL_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
77: G_ATTR_PRIMARY_UOM_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
78:

Line 75: G_ATTR_LDET_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

71: G_ATTR_PRODUCT_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
72: G_ATTR_EXCLUDER_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
73: G_ATTR_PRICING_PHASE_ID_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
74: G_ATTR_INCOM_GRP_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
75: G_ATTR_LDET_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
76: G_ATTR_MODIFIER_LEVEL_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
77: G_ATTR_PRIMARY_UOM_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
78:
79: G_LDET_LINE_DTL_INDEX_TBL QP_PREQ_GRP.pls_integer_type;

Line 76: G_ATTR_MODIFIER_LEVEL_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

72: G_ATTR_EXCLUDER_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
73: G_ATTR_PRICING_PHASE_ID_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
74: G_ATTR_INCOM_GRP_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
75: G_ATTR_LDET_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
76: G_ATTR_MODIFIER_LEVEL_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
77: G_ATTR_PRIMARY_UOM_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
78:
79: G_LDET_LINE_DTL_INDEX_TBL QP_PREQ_GRP.pls_integer_type;
80: G_LDET_PRICE_ADJ_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;

Line 77: G_ATTR_PRIMARY_UOM_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

73: G_ATTR_PRICING_PHASE_ID_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
74: G_ATTR_INCOM_GRP_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
75: G_ATTR_LDET_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
76: G_ATTR_MODIFIER_LEVEL_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
77: G_ATTR_PRIMARY_UOM_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
78:
79: G_LDET_LINE_DTL_INDEX_TBL QP_PREQ_GRP.pls_integer_type;
80: G_LDET_PRICE_ADJ_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
81: G_LDET_LINE_DTL_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 79: G_LDET_LINE_DTL_INDEX_TBL QP_PREQ_GRP.pls_integer_type;

75: G_ATTR_LDET_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
76: G_ATTR_MODIFIER_LEVEL_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
77: G_ATTR_PRIMARY_UOM_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
78:
79: G_LDET_LINE_DTL_INDEX_TBL QP_PREQ_GRP.pls_integer_type;
80: G_LDET_PRICE_ADJ_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
81: G_LDET_LINE_DTL_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
82: G_LDET_PRICE_BREAK_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
83: G_LDET_LIST_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;

Line 80: G_LDET_PRICE_ADJ_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;

76: G_ATTR_MODIFIER_LEVEL_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
77: G_ATTR_PRIMARY_UOM_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
78:
79: G_LDET_LINE_DTL_INDEX_TBL QP_PREQ_GRP.pls_integer_type;
80: G_LDET_PRICE_ADJ_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
81: G_LDET_LINE_DTL_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
82: G_LDET_PRICE_BREAK_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
83: G_LDET_LIST_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
84: G_LDET_LINE_INDEX_TBL QP_PREQ_GRP.pls_integer_type;

Line 81: G_LDET_LINE_DTL_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

77: G_ATTR_PRIMARY_UOM_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
78:
79: G_LDET_LINE_DTL_INDEX_TBL QP_PREQ_GRP.pls_integer_type;
80: G_LDET_PRICE_ADJ_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
81: G_LDET_LINE_DTL_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
82: G_LDET_PRICE_BREAK_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
83: G_LDET_LIST_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
84: G_LDET_LINE_INDEX_TBL QP_PREQ_GRP.pls_integer_type;
85: G_LDET_LIST_HEADER_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;

Line 82: G_LDET_PRICE_BREAK_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

78:
79: G_LDET_LINE_DTL_INDEX_TBL QP_PREQ_GRP.pls_integer_type;
80: G_LDET_PRICE_ADJ_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
81: G_LDET_LINE_DTL_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
82: G_LDET_PRICE_BREAK_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
83: G_LDET_LIST_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
84: G_LDET_LINE_INDEX_TBL QP_PREQ_GRP.pls_integer_type;
85: G_LDET_LIST_HEADER_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
86: G_LDET_LIST_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;

Line 83: G_LDET_LIST_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;

79: G_LDET_LINE_DTL_INDEX_TBL QP_PREQ_GRP.pls_integer_type;
80: G_LDET_PRICE_ADJ_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
81: G_LDET_LINE_DTL_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
82: G_LDET_PRICE_BREAK_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
83: G_LDET_LIST_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
84: G_LDET_LINE_INDEX_TBL QP_PREQ_GRP.pls_integer_type;
85: G_LDET_LIST_HEADER_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
86: G_LDET_LIST_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
87: G_LDET_LIST_LINE_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 84: G_LDET_LINE_INDEX_TBL QP_PREQ_GRP.pls_integer_type;

80: G_LDET_PRICE_ADJ_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
81: G_LDET_LINE_DTL_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
82: G_LDET_PRICE_BREAK_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
83: G_LDET_LIST_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
84: G_LDET_LINE_INDEX_TBL QP_PREQ_GRP.pls_integer_type;
85: G_LDET_LIST_HEADER_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
86: G_LDET_LIST_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
87: G_LDET_LIST_LINE_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
88: G_LDET_LIST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 85: G_LDET_LIST_HEADER_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;

81: G_LDET_LINE_DTL_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
82: G_LDET_PRICE_BREAK_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
83: G_LDET_LIST_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
84: G_LDET_LINE_INDEX_TBL QP_PREQ_GRP.pls_integer_type;
85: G_LDET_LIST_HEADER_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
86: G_LDET_LIST_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
87: G_LDET_LIST_LINE_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
88: G_LDET_LIST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
89: G_LDET_CREATED_FROM_SQL_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 86: G_LDET_LIST_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;

82: G_LDET_PRICE_BREAK_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
83: G_LDET_LIST_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
84: G_LDET_LINE_INDEX_TBL QP_PREQ_GRP.pls_integer_type;
85: G_LDET_LIST_HEADER_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
86: G_LDET_LIST_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
87: G_LDET_LIST_LINE_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
88: G_LDET_LIST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
89: G_LDET_CREATED_FROM_SQL_TBL QP_PREQ_GRP.VARCHAR_TYPE;
90: G_LDET_PRICING_GRP_SEQ_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;

Line 87: G_LDET_LIST_LINE_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

83: G_LDET_LIST_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
84: G_LDET_LINE_INDEX_TBL QP_PREQ_GRP.pls_integer_type;
85: G_LDET_LIST_HEADER_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
86: G_LDET_LIST_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
87: G_LDET_LIST_LINE_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
88: G_LDET_LIST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
89: G_LDET_CREATED_FROM_SQL_TBL QP_PREQ_GRP.VARCHAR_TYPE;
90: G_LDET_PRICING_GRP_SEQ_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
91: G_LDET_PRICING_PHASE_ID_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;

Line 88: G_LDET_LIST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

84: G_LDET_LINE_INDEX_TBL QP_PREQ_GRP.pls_integer_type;
85: G_LDET_LIST_HEADER_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
86: G_LDET_LIST_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
87: G_LDET_LIST_LINE_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
88: G_LDET_LIST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
89: G_LDET_CREATED_FROM_SQL_TBL QP_PREQ_GRP.VARCHAR_TYPE;
90: G_LDET_PRICING_GRP_SEQ_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
91: G_LDET_PRICING_PHASE_ID_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
92: G_LDET_OPERAND_CALC_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 89: G_LDET_CREATED_FROM_SQL_TBL QP_PREQ_GRP.VARCHAR_TYPE;

85: G_LDET_LIST_HEADER_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
86: G_LDET_LIST_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
87: G_LDET_LIST_LINE_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
88: G_LDET_LIST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
89: G_LDET_CREATED_FROM_SQL_TBL QP_PREQ_GRP.VARCHAR_TYPE;
90: G_LDET_PRICING_GRP_SEQ_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
91: G_LDET_PRICING_PHASE_ID_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
92: G_LDET_OPERAND_CALC_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
93: G_LDET_OPERAND_VALUE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 90: G_LDET_PRICING_GRP_SEQ_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;

86: G_LDET_LIST_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
87: G_LDET_LIST_LINE_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
88: G_LDET_LIST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
89: G_LDET_CREATED_FROM_SQL_TBL QP_PREQ_GRP.VARCHAR_TYPE;
90: G_LDET_PRICING_GRP_SEQ_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
91: G_LDET_PRICING_PHASE_ID_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
92: G_LDET_OPERAND_CALC_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
93: G_LDET_OPERAND_VALUE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
94: G_LDET_SUBSTN_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 91: G_LDET_PRICING_PHASE_ID_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;

87: G_LDET_LIST_LINE_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
88: G_LDET_LIST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
89: G_LDET_CREATED_FROM_SQL_TBL QP_PREQ_GRP.VARCHAR_TYPE;
90: G_LDET_PRICING_GRP_SEQ_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
91: G_LDET_PRICING_PHASE_ID_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
92: G_LDET_OPERAND_CALC_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
93: G_LDET_OPERAND_VALUE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
94: G_LDET_SUBSTN_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
95: G_LDET_SUBSTN_VALUE_FROM_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 92: G_LDET_OPERAND_CALC_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

88: G_LDET_LIST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
89: G_LDET_CREATED_FROM_SQL_TBL QP_PREQ_GRP.VARCHAR_TYPE;
90: G_LDET_PRICING_GRP_SEQ_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
91: G_LDET_PRICING_PHASE_ID_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
92: G_LDET_OPERAND_CALC_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
93: G_LDET_OPERAND_VALUE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
94: G_LDET_SUBSTN_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
95: G_LDET_SUBSTN_VALUE_FROM_TBL QP_PREQ_GRP.VARCHAR_TYPE;
96: G_LDET_SUBSTN_VALUE_TO_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 93: G_LDET_OPERAND_VALUE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

89: G_LDET_CREATED_FROM_SQL_TBL QP_PREQ_GRP.VARCHAR_TYPE;
90: G_LDET_PRICING_GRP_SEQ_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
91: G_LDET_PRICING_PHASE_ID_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
92: G_LDET_OPERAND_CALC_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
93: G_LDET_OPERAND_VALUE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
94: G_LDET_SUBSTN_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
95: G_LDET_SUBSTN_VALUE_FROM_TBL QP_PREQ_GRP.VARCHAR_TYPE;
96: G_LDET_SUBSTN_VALUE_TO_TBL QP_PREQ_GRP.VARCHAR_TYPE;
97: G_LDET_ASK_FOR_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 94: G_LDET_SUBSTN_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

90: G_LDET_PRICING_GRP_SEQ_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
91: G_LDET_PRICING_PHASE_ID_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
92: G_LDET_OPERAND_CALC_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
93: G_LDET_OPERAND_VALUE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
94: G_LDET_SUBSTN_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
95: G_LDET_SUBSTN_VALUE_FROM_TBL QP_PREQ_GRP.VARCHAR_TYPE;
96: G_LDET_SUBSTN_VALUE_TO_TBL QP_PREQ_GRP.VARCHAR_TYPE;
97: G_LDET_ASK_FOR_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
98: G_LDET_PRICE_FORMULA_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;

Line 95: G_LDET_SUBSTN_VALUE_FROM_TBL QP_PREQ_GRP.VARCHAR_TYPE;

91: G_LDET_PRICING_PHASE_ID_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
92: G_LDET_OPERAND_CALC_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
93: G_LDET_OPERAND_VALUE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
94: G_LDET_SUBSTN_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
95: G_LDET_SUBSTN_VALUE_FROM_TBL QP_PREQ_GRP.VARCHAR_TYPE;
96: G_LDET_SUBSTN_VALUE_TO_TBL QP_PREQ_GRP.VARCHAR_TYPE;
97: G_LDET_ASK_FOR_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
98: G_LDET_PRICE_FORMULA_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
99: G_LDET_PRICING_STATUS_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 96: G_LDET_SUBSTN_VALUE_TO_TBL QP_PREQ_GRP.VARCHAR_TYPE;

92: G_LDET_OPERAND_CALC_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
93: G_LDET_OPERAND_VALUE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
94: G_LDET_SUBSTN_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
95: G_LDET_SUBSTN_VALUE_FROM_TBL QP_PREQ_GRP.VARCHAR_TYPE;
96: G_LDET_SUBSTN_VALUE_TO_TBL QP_PREQ_GRP.VARCHAR_TYPE;
97: G_LDET_ASK_FOR_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
98: G_LDET_PRICE_FORMULA_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
99: G_LDET_PRICING_STATUS_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
100: G_LDET_PRICING_STATUS_TXT_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 97: G_LDET_ASK_FOR_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

93: G_LDET_OPERAND_VALUE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
94: G_LDET_SUBSTN_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
95: G_LDET_SUBSTN_VALUE_FROM_TBL QP_PREQ_GRP.VARCHAR_TYPE;
96: G_LDET_SUBSTN_VALUE_TO_TBL QP_PREQ_GRP.VARCHAR_TYPE;
97: G_LDET_ASK_FOR_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
98: G_LDET_PRICE_FORMULA_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
99: G_LDET_PRICING_STATUS_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
100: G_LDET_PRICING_STATUS_TXT_TBL QP_PREQ_GRP.VARCHAR_TYPE;
101: G_LDET_PRODUCT_PRECEDENCE_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;

Line 98: G_LDET_PRICE_FORMULA_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;

94: G_LDET_SUBSTN_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
95: G_LDET_SUBSTN_VALUE_FROM_TBL QP_PREQ_GRP.VARCHAR_TYPE;
96: G_LDET_SUBSTN_VALUE_TO_TBL QP_PREQ_GRP.VARCHAR_TYPE;
97: G_LDET_ASK_FOR_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
98: G_LDET_PRICE_FORMULA_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
99: G_LDET_PRICING_STATUS_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
100: G_LDET_PRICING_STATUS_TXT_TBL QP_PREQ_GRP.VARCHAR_TYPE;
101: G_LDET_PRODUCT_PRECEDENCE_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
102: G_LDET_INCOMPAT_GRP_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 99: G_LDET_PRICING_STATUS_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

95: G_LDET_SUBSTN_VALUE_FROM_TBL QP_PREQ_GRP.VARCHAR_TYPE;
96: G_LDET_SUBSTN_VALUE_TO_TBL QP_PREQ_GRP.VARCHAR_TYPE;
97: G_LDET_ASK_FOR_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
98: G_LDET_PRICE_FORMULA_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
99: G_LDET_PRICING_STATUS_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
100: G_LDET_PRICING_STATUS_TXT_TBL QP_PREQ_GRP.VARCHAR_TYPE;
101: G_LDET_PRODUCT_PRECEDENCE_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
102: G_LDET_INCOMPAT_GRP_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
103: G_LDET_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 100: G_LDET_PRICING_STATUS_TXT_TBL QP_PREQ_GRP.VARCHAR_TYPE;

96: G_LDET_SUBSTN_VALUE_TO_TBL QP_PREQ_GRP.VARCHAR_TYPE;
97: G_LDET_ASK_FOR_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
98: G_LDET_PRICE_FORMULA_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
99: G_LDET_PRICING_STATUS_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
100: G_LDET_PRICING_STATUS_TXT_TBL QP_PREQ_GRP.VARCHAR_TYPE;
101: G_LDET_PRODUCT_PRECEDENCE_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
102: G_LDET_INCOMPAT_GRP_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
103: G_LDET_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
104: G_LDET_APPLIED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 101: G_LDET_PRODUCT_PRECEDENCE_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;

97: G_LDET_ASK_FOR_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
98: G_LDET_PRICE_FORMULA_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
99: G_LDET_PRICING_STATUS_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
100: G_LDET_PRICING_STATUS_TXT_TBL QP_PREQ_GRP.VARCHAR_TYPE;
101: G_LDET_PRODUCT_PRECEDENCE_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
102: G_LDET_INCOMPAT_GRP_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
103: G_LDET_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
104: G_LDET_APPLIED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
105: G_LDET_AUTOMATIC_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 102: G_LDET_INCOMPAT_GRP_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

98: G_LDET_PRICE_FORMULA_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
99: G_LDET_PRICING_STATUS_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
100: G_LDET_PRICING_STATUS_TXT_TBL QP_PREQ_GRP.VARCHAR_TYPE;
101: G_LDET_PRODUCT_PRECEDENCE_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
102: G_LDET_INCOMPAT_GRP_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
103: G_LDET_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
104: G_LDET_APPLIED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
105: G_LDET_AUTOMATIC_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
106: G_LDET_OVERRIDE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 103: G_LDET_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

99: G_LDET_PRICING_STATUS_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
100: G_LDET_PRICING_STATUS_TXT_TBL QP_PREQ_GRP.VARCHAR_TYPE;
101: G_LDET_PRODUCT_PRECEDENCE_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
102: G_LDET_INCOMPAT_GRP_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
103: G_LDET_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
104: G_LDET_APPLIED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
105: G_LDET_AUTOMATIC_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
106: G_LDET_OVERRIDE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
107: G_LDET_PRIMARY_UOM_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 104: G_LDET_APPLIED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

100: G_LDET_PRICING_STATUS_TXT_TBL QP_PREQ_GRP.VARCHAR_TYPE;
101: G_LDET_PRODUCT_PRECEDENCE_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
102: G_LDET_INCOMPAT_GRP_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
103: G_LDET_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
104: G_LDET_APPLIED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
105: G_LDET_AUTOMATIC_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
106: G_LDET_OVERRIDE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
107: G_LDET_PRIMARY_UOM_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
108: G_LDET_PRINT_ON_INV_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 105: G_LDET_AUTOMATIC_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

101: G_LDET_PRODUCT_PRECEDENCE_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
102: G_LDET_INCOMPAT_GRP_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
103: G_LDET_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
104: G_LDET_APPLIED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
105: G_LDET_AUTOMATIC_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
106: G_LDET_OVERRIDE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
107: G_LDET_PRIMARY_UOM_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
108: G_LDET_PRINT_ON_INV_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
109: G_LDET_MODIFIER_LEVEL_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 106: G_LDET_OVERRIDE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

102: G_LDET_INCOMPAT_GRP_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
103: G_LDET_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
104: G_LDET_APPLIED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
105: G_LDET_AUTOMATIC_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
106: G_LDET_OVERRIDE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
107: G_LDET_PRIMARY_UOM_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
108: G_LDET_PRINT_ON_INV_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
109: G_LDET_MODIFIER_LEVEL_TBL QP_PREQ_GRP.VARCHAR_TYPE;
110: G_LDET_BENEFIT_QTY_TBL QP_PREQ_GRP.NUMBER_TYPE;

Line 107: G_LDET_PRIMARY_UOM_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

103: G_LDET_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
104: G_LDET_APPLIED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
105: G_LDET_AUTOMATIC_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
106: G_LDET_OVERRIDE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
107: G_LDET_PRIMARY_UOM_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
108: G_LDET_PRINT_ON_INV_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
109: G_LDET_MODIFIER_LEVEL_TBL QP_PREQ_GRP.VARCHAR_TYPE;
110: G_LDET_BENEFIT_QTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
111: G_LDET_BENEFIT_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 108: G_LDET_PRINT_ON_INV_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

104: G_LDET_APPLIED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
105: G_LDET_AUTOMATIC_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
106: G_LDET_OVERRIDE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
107: G_LDET_PRIMARY_UOM_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
108: G_LDET_PRINT_ON_INV_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
109: G_LDET_MODIFIER_LEVEL_TBL QP_PREQ_GRP.VARCHAR_TYPE;
110: G_LDET_BENEFIT_QTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
111: G_LDET_BENEFIT_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
112: G_LDET_LIST_LINE_NO_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 109: G_LDET_MODIFIER_LEVEL_TBL QP_PREQ_GRP.VARCHAR_TYPE;

105: G_LDET_AUTOMATIC_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
106: G_LDET_OVERRIDE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
107: G_LDET_PRIMARY_UOM_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
108: G_LDET_PRINT_ON_INV_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
109: G_LDET_MODIFIER_LEVEL_TBL QP_PREQ_GRP.VARCHAR_TYPE;
110: G_LDET_BENEFIT_QTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
111: G_LDET_BENEFIT_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
112: G_LDET_LIST_LINE_NO_TBL QP_PREQ_GRP.VARCHAR_TYPE;
113: G_LDET_ACCRUAL_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 110: G_LDET_BENEFIT_QTY_TBL QP_PREQ_GRP.NUMBER_TYPE;

106: G_LDET_OVERRIDE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
107: G_LDET_PRIMARY_UOM_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
108: G_LDET_PRINT_ON_INV_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
109: G_LDET_MODIFIER_LEVEL_TBL QP_PREQ_GRP.VARCHAR_TYPE;
110: G_LDET_BENEFIT_QTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
111: G_LDET_BENEFIT_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
112: G_LDET_LIST_LINE_NO_TBL QP_PREQ_GRP.VARCHAR_TYPE;
113: G_LDET_ACCRUAL_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
114: G_LDET_ACCR_CONV_RATE_TBL QP_PREQ_GRP.NUMBER_TYPE;

Line 111: G_LDET_BENEFIT_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

107: G_LDET_PRIMARY_UOM_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
108: G_LDET_PRINT_ON_INV_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
109: G_LDET_MODIFIER_LEVEL_TBL QP_PREQ_GRP.VARCHAR_TYPE;
110: G_LDET_BENEFIT_QTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
111: G_LDET_BENEFIT_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
112: G_LDET_LIST_LINE_NO_TBL QP_PREQ_GRP.VARCHAR_TYPE;
113: G_LDET_ACCRUAL_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
114: G_LDET_ACCR_CONV_RATE_TBL QP_PREQ_GRP.NUMBER_TYPE;
115: G_LDET_ESTIM_ACCR_RATE_TBL QP_PREQ_GRP.NUMBER_TYPE;

Line 112: G_LDET_LIST_LINE_NO_TBL QP_PREQ_GRP.VARCHAR_TYPE;

108: G_LDET_PRINT_ON_INV_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
109: G_LDET_MODIFIER_LEVEL_TBL QP_PREQ_GRP.VARCHAR_TYPE;
110: G_LDET_BENEFIT_QTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
111: G_LDET_BENEFIT_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
112: G_LDET_LIST_LINE_NO_TBL QP_PREQ_GRP.VARCHAR_TYPE;
113: G_LDET_ACCRUAL_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
114: G_LDET_ACCR_CONV_RATE_TBL QP_PREQ_GRP.NUMBER_TYPE;
115: G_LDET_ESTIM_ACCR_RATE_TBL QP_PREQ_GRP.NUMBER_TYPE;
116: G_LDET_RECURRING_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 113: G_LDET_ACCRUAL_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

109: G_LDET_MODIFIER_LEVEL_TBL QP_PREQ_GRP.VARCHAR_TYPE;
110: G_LDET_BENEFIT_QTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
111: G_LDET_BENEFIT_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
112: G_LDET_LIST_LINE_NO_TBL QP_PREQ_GRP.VARCHAR_TYPE;
113: G_LDET_ACCRUAL_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
114: G_LDET_ACCR_CONV_RATE_TBL QP_PREQ_GRP.NUMBER_TYPE;
115: G_LDET_ESTIM_ACCR_RATE_TBL QP_PREQ_GRP.NUMBER_TYPE;
116: G_LDET_RECURRING_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
117: G_LDET_SELECTED_VOL_ATTR_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 114: G_LDET_ACCR_CONV_RATE_TBL QP_PREQ_GRP.NUMBER_TYPE;

110: G_LDET_BENEFIT_QTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
111: G_LDET_BENEFIT_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
112: G_LDET_LIST_LINE_NO_TBL QP_PREQ_GRP.VARCHAR_TYPE;
113: G_LDET_ACCRUAL_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
114: G_LDET_ACCR_CONV_RATE_TBL QP_PREQ_GRP.NUMBER_TYPE;
115: G_LDET_ESTIM_ACCR_RATE_TBL QP_PREQ_GRP.NUMBER_TYPE;
116: G_LDET_RECURRING_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
117: G_LDET_SELECTED_VOL_ATTR_TBL QP_PREQ_GRP.VARCHAR_TYPE;
118: G_LDET_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;

Line 115: G_LDET_ESTIM_ACCR_RATE_TBL QP_PREQ_GRP.NUMBER_TYPE;

111: G_LDET_BENEFIT_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
112: G_LDET_LIST_LINE_NO_TBL QP_PREQ_GRP.VARCHAR_TYPE;
113: G_LDET_ACCRUAL_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
114: G_LDET_ACCR_CONV_RATE_TBL QP_PREQ_GRP.NUMBER_TYPE;
115: G_LDET_ESTIM_ACCR_RATE_TBL QP_PREQ_GRP.NUMBER_TYPE;
116: G_LDET_RECURRING_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
117: G_LDET_SELECTED_VOL_ATTR_TBL QP_PREQ_GRP.VARCHAR_TYPE;
118: G_LDET_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
119: G_LDET_HDR_LIMIT_EXISTS_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 116: G_LDET_RECURRING_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

112: G_LDET_LIST_LINE_NO_TBL QP_PREQ_GRP.VARCHAR_TYPE;
113: G_LDET_ACCRUAL_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
114: G_LDET_ACCR_CONV_RATE_TBL QP_PREQ_GRP.NUMBER_TYPE;
115: G_LDET_ESTIM_ACCR_RATE_TBL QP_PREQ_GRP.NUMBER_TYPE;
116: G_LDET_RECURRING_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
117: G_LDET_SELECTED_VOL_ATTR_TBL QP_PREQ_GRP.VARCHAR_TYPE;
118: G_LDET_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
119: G_LDET_HDR_LIMIT_EXISTS_TBL QP_PREQ_GRP.VARCHAR_TYPE;
120: G_LDET_LINE_LIMIT_EXISTS_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 117: G_LDET_SELECTED_VOL_ATTR_TBL QP_PREQ_GRP.VARCHAR_TYPE;

113: G_LDET_ACCRUAL_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
114: G_LDET_ACCR_CONV_RATE_TBL QP_PREQ_GRP.NUMBER_TYPE;
115: G_LDET_ESTIM_ACCR_RATE_TBL QP_PREQ_GRP.NUMBER_TYPE;
116: G_LDET_RECURRING_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
117: G_LDET_SELECTED_VOL_ATTR_TBL QP_PREQ_GRP.VARCHAR_TYPE;
118: G_LDET_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
119: G_LDET_HDR_LIMIT_EXISTS_TBL QP_PREQ_GRP.VARCHAR_TYPE;
120: G_LDET_LINE_LIMIT_EXISTS_TBL QP_PREQ_GRP.VARCHAR_TYPE;
121: G_LDET_CHARGE_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 118: G_LDET_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;

114: G_LDET_ACCR_CONV_RATE_TBL QP_PREQ_GRP.NUMBER_TYPE;
115: G_LDET_ESTIM_ACCR_RATE_TBL QP_PREQ_GRP.NUMBER_TYPE;
116: G_LDET_RECURRING_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
117: G_LDET_SELECTED_VOL_ATTR_TBL QP_PREQ_GRP.VARCHAR_TYPE;
118: G_LDET_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
119: G_LDET_HDR_LIMIT_EXISTS_TBL QP_PREQ_GRP.VARCHAR_TYPE;
120: G_LDET_LINE_LIMIT_EXISTS_TBL QP_PREQ_GRP.VARCHAR_TYPE;
121: G_LDET_CHARGE_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
122: G_LDET_CHARGE_SUBTYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 119: G_LDET_HDR_LIMIT_EXISTS_TBL QP_PREQ_GRP.VARCHAR_TYPE;

115: G_LDET_ESTIM_ACCR_RATE_TBL QP_PREQ_GRP.NUMBER_TYPE;
116: G_LDET_RECURRING_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
117: G_LDET_SELECTED_VOL_ATTR_TBL QP_PREQ_GRP.VARCHAR_TYPE;
118: G_LDET_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
119: G_LDET_HDR_LIMIT_EXISTS_TBL QP_PREQ_GRP.VARCHAR_TYPE;
120: G_LDET_LINE_LIMIT_EXISTS_TBL QP_PREQ_GRP.VARCHAR_TYPE;
121: G_LDET_CHARGE_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
122: G_LDET_CHARGE_SUBTYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
123: G_LDET_CURRENCY_DTL_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;

Line 120: G_LDET_LINE_LIMIT_EXISTS_TBL QP_PREQ_GRP.VARCHAR_TYPE;

116: G_LDET_RECURRING_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
117: G_LDET_SELECTED_VOL_ATTR_TBL QP_PREQ_GRP.VARCHAR_TYPE;
118: G_LDET_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
119: G_LDET_HDR_LIMIT_EXISTS_TBL QP_PREQ_GRP.VARCHAR_TYPE;
120: G_LDET_LINE_LIMIT_EXISTS_TBL QP_PREQ_GRP.VARCHAR_TYPE;
121: G_LDET_CHARGE_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
122: G_LDET_CHARGE_SUBTYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
123: G_LDET_CURRENCY_DTL_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
124: G_LDET_CURRENCY_HDR_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;

Line 121: G_LDET_CHARGE_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

117: G_LDET_SELECTED_VOL_ATTR_TBL QP_PREQ_GRP.VARCHAR_TYPE;
118: G_LDET_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
119: G_LDET_HDR_LIMIT_EXISTS_TBL QP_PREQ_GRP.VARCHAR_TYPE;
120: G_LDET_LINE_LIMIT_EXISTS_TBL QP_PREQ_GRP.VARCHAR_TYPE;
121: G_LDET_CHARGE_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
122: G_LDET_CHARGE_SUBTYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
123: G_LDET_CURRENCY_DTL_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
124: G_LDET_CURRENCY_HDR_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
125: G_LDET_SELLING_ROUND_TBL QP_PREQ_GRP.NUMBER_TYPE;

Line 122: G_LDET_CHARGE_SUBTYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

118: G_LDET_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;
119: G_LDET_HDR_LIMIT_EXISTS_TBL QP_PREQ_GRP.VARCHAR_TYPE;
120: G_LDET_LINE_LIMIT_EXISTS_TBL QP_PREQ_GRP.VARCHAR_TYPE;
121: G_LDET_CHARGE_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
122: G_LDET_CHARGE_SUBTYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
123: G_LDET_CURRENCY_DTL_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
124: G_LDET_CURRENCY_HDR_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
125: G_LDET_SELLING_ROUND_TBL QP_PREQ_GRP.NUMBER_TYPE;
126: G_LDET_ORDER_CURRENCY_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 123: G_LDET_CURRENCY_DTL_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;

119: G_LDET_HDR_LIMIT_EXISTS_TBL QP_PREQ_GRP.VARCHAR_TYPE;
120: G_LDET_LINE_LIMIT_EXISTS_TBL QP_PREQ_GRP.VARCHAR_TYPE;
121: G_LDET_CHARGE_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
122: G_LDET_CHARGE_SUBTYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
123: G_LDET_CURRENCY_DTL_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
124: G_LDET_CURRENCY_HDR_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
125: G_LDET_SELLING_ROUND_TBL QP_PREQ_GRP.NUMBER_TYPE;
126: G_LDET_ORDER_CURRENCY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
127: G_LDET_PRICING_EFF_DATE_TBL QP_PREQ_GRP.DATE_TYPE;

Line 124: G_LDET_CURRENCY_HDR_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;

120: G_LDET_LINE_LIMIT_EXISTS_TBL QP_PREQ_GRP.VARCHAR_TYPE;
121: G_LDET_CHARGE_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
122: G_LDET_CHARGE_SUBTYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
123: G_LDET_CURRENCY_DTL_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
124: G_LDET_CURRENCY_HDR_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
125: G_LDET_SELLING_ROUND_TBL QP_PREQ_GRP.NUMBER_TYPE;
126: G_LDET_ORDER_CURRENCY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
127: G_LDET_PRICING_EFF_DATE_TBL QP_PREQ_GRP.DATE_TYPE;
128: G_LDET_BASE_CURRENCY_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 125: G_LDET_SELLING_ROUND_TBL QP_PREQ_GRP.NUMBER_TYPE;

121: G_LDET_CHARGE_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
122: G_LDET_CHARGE_SUBTYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
123: G_LDET_CURRENCY_DTL_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
124: G_LDET_CURRENCY_HDR_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
125: G_LDET_SELLING_ROUND_TBL QP_PREQ_GRP.NUMBER_TYPE;
126: G_LDET_ORDER_CURRENCY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
127: G_LDET_PRICING_EFF_DATE_TBL QP_PREQ_GRP.DATE_TYPE;
128: G_LDET_BASE_CURRENCY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
129: G_LDET_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;

Line 126: G_LDET_ORDER_CURRENCY_TBL QP_PREQ_GRP.VARCHAR_TYPE;

122: G_LDET_CHARGE_SUBTYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
123: G_LDET_CURRENCY_DTL_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
124: G_LDET_CURRENCY_HDR_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
125: G_LDET_SELLING_ROUND_TBL QP_PREQ_GRP.NUMBER_TYPE;
126: G_LDET_ORDER_CURRENCY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
127: G_LDET_PRICING_EFF_DATE_TBL QP_PREQ_GRP.DATE_TYPE;
128: G_LDET_BASE_CURRENCY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
129: G_LDET_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
130: G_LDET_UPDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 127: G_LDET_PRICING_EFF_DATE_TBL QP_PREQ_GRP.DATE_TYPE;

123: G_LDET_CURRENCY_DTL_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
124: G_LDET_CURRENCY_HDR_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
125: G_LDET_SELLING_ROUND_TBL QP_PREQ_GRP.NUMBER_TYPE;
126: G_LDET_ORDER_CURRENCY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
127: G_LDET_PRICING_EFF_DATE_TBL QP_PREQ_GRP.DATE_TYPE;
128: G_LDET_BASE_CURRENCY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
129: G_LDET_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
130: G_LDET_UPDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
131: G_LDET_CALC_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 128: G_LDET_BASE_CURRENCY_TBL QP_PREQ_GRP.VARCHAR_TYPE;

124: G_LDET_CURRENCY_HDR_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
125: G_LDET_SELLING_ROUND_TBL QP_PREQ_GRP.NUMBER_TYPE;
126: G_LDET_ORDER_CURRENCY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
127: G_LDET_PRICING_EFF_DATE_TBL QP_PREQ_GRP.DATE_TYPE;
128: G_LDET_BASE_CURRENCY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
129: G_LDET_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
130: G_LDET_UPDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
131: G_LDET_CALC_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
132: G_LDET_CHG_REASON_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 129: G_LDET_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;

125: G_LDET_SELLING_ROUND_TBL QP_PREQ_GRP.NUMBER_TYPE;
126: G_LDET_ORDER_CURRENCY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
127: G_LDET_PRICING_EFF_DATE_TBL QP_PREQ_GRP.DATE_TYPE;
128: G_LDET_BASE_CURRENCY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
129: G_LDET_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
130: G_LDET_UPDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
131: G_LDET_CALC_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
132: G_LDET_CHG_REASON_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
133: G_LDET_CHG_REASON_TEXT_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 130: G_LDET_UPDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

126: G_LDET_ORDER_CURRENCY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
127: G_LDET_PRICING_EFF_DATE_TBL QP_PREQ_GRP.DATE_TYPE;
128: G_LDET_BASE_CURRENCY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
129: G_LDET_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
130: G_LDET_UPDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
131: G_LDET_CALC_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
132: G_LDET_CHG_REASON_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
133: G_LDET_CHG_REASON_TEXT_TBL QP_PREQ_GRP.VARCHAR_TYPE;
134:

Line 131: G_LDET_CALC_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

127: G_LDET_PRICING_EFF_DATE_TBL QP_PREQ_GRP.DATE_TYPE;
128: G_LDET_BASE_CURRENCY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
129: G_LDET_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
130: G_LDET_UPDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
131: G_LDET_CALC_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
132: G_LDET_CHG_REASON_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
133: G_LDET_CHG_REASON_TEXT_TBL QP_PREQ_GRP.VARCHAR_TYPE;
134:
135: G_RLTD_LINE_INDEX_TBL QP_PREQ_GRP.NUMBER_TYPE;

Line 132: G_LDET_CHG_REASON_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

128: G_LDET_BASE_CURRENCY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
129: G_LDET_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
130: G_LDET_UPDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
131: G_LDET_CALC_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
132: G_LDET_CHG_REASON_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
133: G_LDET_CHG_REASON_TEXT_TBL QP_PREQ_GRP.VARCHAR_TYPE;
134:
135: G_RLTD_LINE_INDEX_TBL QP_PREQ_GRP.NUMBER_TYPE;
136: G_RLTD_LINE_DTL_INDEX_TBL QP_PREQ_GRP.NUMBER_TYPE;

Line 133: G_LDET_CHG_REASON_TEXT_TBL QP_PREQ_GRP.VARCHAR_TYPE;

129: G_LDET_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
130: G_LDET_UPDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
131: G_LDET_CALC_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
132: G_LDET_CHG_REASON_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
133: G_LDET_CHG_REASON_TEXT_TBL QP_PREQ_GRP.VARCHAR_TYPE;
134:
135: G_RLTD_LINE_INDEX_TBL QP_PREQ_GRP.NUMBER_TYPE;
136: G_RLTD_LINE_DTL_INDEX_TBL QP_PREQ_GRP.NUMBER_TYPE;
137: G_RLTD_RELATION_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 135: G_RLTD_LINE_INDEX_TBL QP_PREQ_GRP.NUMBER_TYPE;

131: G_LDET_CALC_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
132: G_LDET_CHG_REASON_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
133: G_LDET_CHG_REASON_TEXT_TBL QP_PREQ_GRP.VARCHAR_TYPE;
134:
135: G_RLTD_LINE_INDEX_TBL QP_PREQ_GRP.NUMBER_TYPE;
136: G_RLTD_LINE_DTL_INDEX_TBL QP_PREQ_GRP.NUMBER_TYPE;
137: G_RLTD_RELATION_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
138: G_RLTD_RELATED_LINE_IND_TBL QP_PREQ_GRP.NUMBER_TYPE;
139: G_RLTD_RLTD_LINE_DTL_IND_TBL QP_PREQ_GRP.NUMBER_TYPE;

Line 136: G_RLTD_LINE_DTL_INDEX_TBL QP_PREQ_GRP.NUMBER_TYPE;

132: G_LDET_CHG_REASON_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
133: G_LDET_CHG_REASON_TEXT_TBL QP_PREQ_GRP.VARCHAR_TYPE;
134:
135: G_RLTD_LINE_INDEX_TBL QP_PREQ_GRP.NUMBER_TYPE;
136: G_RLTD_LINE_DTL_INDEX_TBL QP_PREQ_GRP.NUMBER_TYPE;
137: G_RLTD_RELATION_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
138: G_RLTD_RELATED_LINE_IND_TBL QP_PREQ_GRP.NUMBER_TYPE;
139: G_RLTD_RLTD_LINE_DTL_IND_TBL QP_PREQ_GRP.NUMBER_TYPE;
140: G_RLTD_LST_LN_ID_DEF_TBL QP_PREQ_GRP.NUMBER_TYPE;

Line 137: G_RLTD_RELATION_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

133: G_LDET_CHG_REASON_TEXT_TBL QP_PREQ_GRP.VARCHAR_TYPE;
134:
135: G_RLTD_LINE_INDEX_TBL QP_PREQ_GRP.NUMBER_TYPE;
136: G_RLTD_LINE_DTL_INDEX_TBL QP_PREQ_GRP.NUMBER_TYPE;
137: G_RLTD_RELATION_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
138: G_RLTD_RELATED_LINE_IND_TBL QP_PREQ_GRP.NUMBER_TYPE;
139: G_RLTD_RLTD_LINE_DTL_IND_TBL QP_PREQ_GRP.NUMBER_TYPE;
140: G_RLTD_LST_LN_ID_DEF_TBL QP_PREQ_GRP.NUMBER_TYPE;
141: G_RLTD_RLTD_LST_LN_ID_DEF_TBL QP_PREQ_GRP.NUMBER_TYPE;

Line 138: G_RLTD_RELATED_LINE_IND_TBL QP_PREQ_GRP.NUMBER_TYPE;

134:
135: G_RLTD_LINE_INDEX_TBL QP_PREQ_GRP.NUMBER_TYPE;
136: G_RLTD_LINE_DTL_INDEX_TBL QP_PREQ_GRP.NUMBER_TYPE;
137: G_RLTD_RELATION_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
138: G_RLTD_RELATED_LINE_IND_TBL QP_PREQ_GRP.NUMBER_TYPE;
139: G_RLTD_RLTD_LINE_DTL_IND_TBL QP_PREQ_GRP.NUMBER_TYPE;
140: G_RLTD_LST_LN_ID_DEF_TBL QP_PREQ_GRP.NUMBER_TYPE;
141: G_RLTD_RLTD_LST_LN_ID_DEF_TBL QP_PREQ_GRP.NUMBER_TYPE;
142:

Line 139: G_RLTD_RLTD_LINE_DTL_IND_TBL QP_PREQ_GRP.NUMBER_TYPE;

135: G_RLTD_LINE_INDEX_TBL QP_PREQ_GRP.NUMBER_TYPE;
136: G_RLTD_LINE_DTL_INDEX_TBL QP_PREQ_GRP.NUMBER_TYPE;
137: G_RLTD_RELATION_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
138: G_RLTD_RELATED_LINE_IND_TBL QP_PREQ_GRP.NUMBER_TYPE;
139: G_RLTD_RLTD_LINE_DTL_IND_TBL QP_PREQ_GRP.NUMBER_TYPE;
140: G_RLTD_LST_LN_ID_DEF_TBL QP_PREQ_GRP.NUMBER_TYPE;
141: G_RLTD_RLTD_LST_LN_ID_DEF_TBL QP_PREQ_GRP.NUMBER_TYPE;
142:
143: --Define Some Constants used in pricing integration

Line 140: G_RLTD_LST_LN_ID_DEF_TBL QP_PREQ_GRP.NUMBER_TYPE;

136: G_RLTD_LINE_DTL_INDEX_TBL QP_PREQ_GRP.NUMBER_TYPE;
137: G_RLTD_RELATION_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
138: G_RLTD_RELATED_LINE_IND_TBL QP_PREQ_GRP.NUMBER_TYPE;
139: G_RLTD_RLTD_LINE_DTL_IND_TBL QP_PREQ_GRP.NUMBER_TYPE;
140: G_RLTD_LST_LN_ID_DEF_TBL QP_PREQ_GRP.NUMBER_TYPE;
141: G_RLTD_RLTD_LST_LN_ID_DEF_TBL QP_PREQ_GRP.NUMBER_TYPE;
142:
143: --Define Some Constants used in pricing integration
144: G_TERMS_SUBSTITUTION CONSTANT VARCHAR2(30) := 'TSN';

Line 141: G_RLTD_RLTD_LST_LN_ID_DEF_TBL QP_PREQ_GRP.NUMBER_TYPE;

137: G_RLTD_RELATION_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
138: G_RLTD_RELATED_LINE_IND_TBL QP_PREQ_GRP.NUMBER_TYPE;
139: G_RLTD_RLTD_LINE_DTL_IND_TBL QP_PREQ_GRP.NUMBER_TYPE;
140: G_RLTD_LST_LN_ID_DEF_TBL QP_PREQ_GRP.NUMBER_TYPE;
141: G_RLTD_RLTD_LST_LN_ID_DEF_TBL QP_PREQ_GRP.NUMBER_TYPE;
142:
143: --Define Some Constants used in pricing integration
144: G_TERMS_SUBSTITUTION CONSTANT VARCHAR2(30) := 'TSN';
145: G_ORDER_LEVEL CONSTANT VARCHAR2(30) :='ORDER';

Line 244: p_global_tbl IN QP_PREQ_GRP.pls_integer_type,

240: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
241: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
242:
243: FUNCTION Modify_Global_PlsIndex_Table (
244: p_global_tbl IN QP_PREQ_GRP.pls_integer_type,
245: p_search_tbl IN Index_Link_Tbl_Type)
246: RETURN QP_PREQ_GRP.pls_integer_type;
247:
248: FUNCTION Modify_Global_NumIndex_Table (

Line 246: RETURN QP_PREQ_GRP.pls_integer_type;

242:
243: FUNCTION Modify_Global_PlsIndex_Table (
244: p_global_tbl IN QP_PREQ_GRP.pls_integer_type,
245: p_search_tbl IN Index_Link_Tbl_Type)
246: RETURN QP_PREQ_GRP.pls_integer_type;
247:
248: FUNCTION Modify_Global_NumIndex_Table (
249: p_global_tbl IN QP_PREQ_GRP.NUMBER_TYPE,
250: p_search_tbl IN Index_Link_Tbl_Type)

Line 249: p_global_tbl IN QP_PREQ_GRP.NUMBER_TYPE,

245: p_search_tbl IN Index_Link_Tbl_Type)
246: RETURN QP_PREQ_GRP.pls_integer_type;
247:
248: FUNCTION Modify_Global_NumIndex_Table (
249: p_global_tbl IN QP_PREQ_GRP.NUMBER_TYPE,
250: p_search_tbl IN Index_Link_Tbl_Type)
251: RETURN QP_PREQ_GRP.NUMBER_TYPE;
252:
253: PROCEDURE Process_Charges(

Line 251: RETURN QP_PREQ_GRP.NUMBER_TYPE;

247:
248: FUNCTION Modify_Global_NumIndex_Table (
249: p_global_tbl IN QP_PREQ_GRP.NUMBER_TYPE,
250: p_search_tbl IN Index_Link_Tbl_Type)
251: RETURN QP_PREQ_GRP.NUMBER_TYPE;
252:
253: PROCEDURE Process_Charges(
254: P_Api_Version_Number IN NUMBER,
255: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,