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

Line 9: G_LINE_INDEX_tbl QP_PREQ_GRP.pls_integer_type;

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;

Line 10: G_LINE_TYPE_CODE_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 ;

Line 11: G_PRICING_EFFECTIVE_DATE_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 ;

Line 12: G_ACTIVE_DATE_FIRST_TBL QP_PREQ_GRP.DATE_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 ;

Line 13: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_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;

Line 14: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_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;

Line 15: G_ACTIVE_DATE_SECOND_TYPE_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;

Line 16: G_LINE_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;

Line 17: G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_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;

Line 18: G_REQUEST_TYPE_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;

Line 19: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_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;

Line 20: G_UOM_QUANTITY_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;

Line 21: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_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;

Line 22: G_CURRENCY_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;
26: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;

Line 23: G_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;

Line 24: G_PERCENT_PRICE_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;
28: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 25: G_ADJUSTED_UNIT_PRICE_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;
29: G_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;

Line 26: G_UPD_ADJUSTED_UNIT_PRICE_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;

Line 27: G_PROCESSED_FLAG_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;
31: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;

Line 28: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_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;

Line 29: G_LINE_ID_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;
33: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 30: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_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;

Line 31: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_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;

Line 32: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_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;

Line 33: G_QUALIFIERS_EXIST_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;

Line 34: G_PRICING_ATTRS_EXIST_FLAG_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;

Line 35: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_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;

Line 36: G_PL_VALIDATED_FLAG_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;

Line 37: G_PRICE_REQUEST_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;

Line 38: G_USAGE_PRICING_TYPE_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;

Line 39: G_LINE_CATEGORY_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;
43: G_ATTR_LINE_DETAIL_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;

Line 40: G_PRICING_STATUS_CODE_tbl QP_PREQ_GRP.VARCHAR_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;

Line 41: G_PRICING_STATUS_TEXT_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;

Line 42: G_ATTR_LINE_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_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;

Line 43: G_ATTR_LINE_DETAIL_INDEX_tbl QP_PREQ_GRP.PLS_INTEGER_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;

Line 44: G_ATTR_VALIDATED_FLAG_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;

Line 45: G_ATTR_PRICING_CONTEXT_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;

Line 46: G_ATTR_PRICING_ATTRIBUTE_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;

Line 47: G_ATTR_ATTRIBUTE_LEVEL_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;

Line 48: G_ATTR_ATTRIBUTE_TYPE_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;

Line 49: G_ATTR_APPLIED_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;
53: G_ATTR_LIST_LINE_ID_tbl QP_PREQ_GRP.NUMBER_TYPE;

Line 50: G_ATTR_PRICING_STATUS_CODE_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;
54: G_ATTR_VALUE_FROM_tbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 51: G_ATTR_PRICING_ATTR_FLAG_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;

Line 52: G_ATTR_LIST_HEADER_ID_tbl QP_PREQ_GRP.NUMBER_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;

Line 53: G_ATTR_LIST_LINE_ID_tbl QP_PREQ_GRP.NUMBER_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;

Line 54: G_ATTR_VALUE_FROM_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;

Line 55: G_ATTR_SETUP_VALUE_FROM_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;
59: G_ATTR_NO_QUAL_IN_GRP_tbl QP_PREQ_GRP.PLS_INTEGER_TYPE;

Line 56: G_ATTR_VALUE_TO_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;
60: G_ATTR_COMP_OPERATOR_TYPE_tbl QP_PREQ_GRP.VARCHAR_TYPE;

Line 57: G_ATTR_SETUP_VALUE_TO_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;

Line 58: G_ATTR_GROUPING_NUMBER_tbl QP_PREQ_GRP.PLS_INTEGER_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;

Line 59: G_ATTR_NO_QUAL_IN_GRP_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;

Line 60: G_ATTR_COMP_OPERATOR_TYPE_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;

Line 61: G_ATTR_PRICING_STATUS_TEXT_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;

Line 62: G_ATTR_QUAL_PRECEDENCE_tbl QP_PREQ_GRP.PLS_INTEGER_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;

Line 63: G_ATTR_DATATYPE_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;

Line 64: G_ATTR_QUALIFIER_TYPE_tbl QP_PREQ_GRP.VARCHAR_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;

Line 65: G_ATTR_PRODUCT_UOM_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;

Line 66: G_ATTR_EXCLUDER_FLAG_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;

Line 67: G_ATTR_PRICING_PHASE_ID_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;
71: G_ATTR_PRIMARY_UOM_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 68: G_ATTR_INCOM_GRP_CODE_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;

Line 69: G_ATTR_LDET_TYPE_CODE_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;
73: G_ACTUAL_ORDER_QTY_TBL QP_PREQ_GRP.NUMBER_TYPE;

Line 70: G_ATTR_MODIFIER_LEVEL_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;
74: G_LDET_LINE_DETAIL_INDEX QP_PREQ_GRP.PLS_INTEGER_TYPE;

Line 71: G_ATTR_PRIMARY_UOM_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;
75: G_LDET_LINE_DETAIL_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;

Line 72: G_CATCHWEIGHT_QTY_TBL QP_PREQ_GRP.NUMBER_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;

Line 73: G_ACTUAL_ORDER_QTY_TBL QP_PREQ_GRP.NUMBER_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;

Line 74: G_LDET_LINE_DETAIL_INDEX QP_PREQ_GRP.PLS_INTEGER_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;

Line 75: G_LDET_LINE_DETAIL_TYPE_CODE 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;
79: G_LDET_LIST_LINE_ID QP_PREQ_GRP.NUMBER_TYPE;

Line 76: G_LDET_PRICE_BREAK_TYPE_CODE 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;
80: G_LDET_LIST_LINE_TYPE QP_PREQ_GRP.VARCHAR_TYPE;

Line 77: G_LDET_LINE_INDEX 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;
81: G_LDET_LIST_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;

Line 78: G_LDET_LIST_HEADER_ID 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;
82: G_LDET_PRICING_GROUP_SEQUENCE QP_PREQ_GRP.PLS_INTEGER_TYPE;

Line 79: G_LDET_LIST_LINE_ID QP_PREQ_GRP.NUMBER_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;

Line 80: G_LDET_LIST_LINE_TYPE 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;
84: G_LDET_OPERATOR QP_PREQ_GRP.VARCHAR_TYPE;

Line 81: G_LDET_LIST_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;
85: G_LDET_OPERAND_VALUE QP_PREQ_GRP.VARCHAR_TYPE;

Line 82: G_LDET_PRICING_GROUP_SEQUENCE QP_PREQ_GRP.PLS_INTEGER_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;

Line 83: G_LDET_PRICING_PHASE_ID QP_PREQ_GRP.PLS_INTEGER_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;

Line 84: G_LDET_OPERATOR 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;

Line 85: G_LDET_OPERAND_VALUE 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;

Line 86: G_LDET_SUBSTITUTION_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;
90: G_LDET_PRODUCT_PRECEDENCE QP_PREQ_GRP.PLS_INTEGER_TYPE;

Line 87: G_LDET_SUBSTITUTION_VALUE_FROM QP_PREQ_GRP.VARCHAR_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;

Line 88: G_LDET_SUBSTITUTION_VALUE_TO 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;

Line 89: G_LDET_PRICE_FORMULA_ID QP_PREQ_GRP.NUMBER_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;

Line 90: G_LDET_PRODUCT_PRECEDENCE QP_PREQ_GRP.PLS_INTEGER_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;

Line 91: G_LDET_INCOM_GRP_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;
95: G_LDET_MODIFIER_LEVEL_CODE QP_PREQ_GRP.VARCHAR_TYPE;

Line 92: G_LDET_APPLIED_FLAG 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;

Line 93: G_LDET_AUTOMATIC_FLAG 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;
97: G_LDET_BENEFIT_UOM_CODE QP_PREQ_GRP.VARCHAR_TYPE;

Line 94: G_LDET_OVERRIDE_FLAG 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;

Line 95: G_LDET_MODIFIER_LEVEL_CODE 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;

Line 96: G_LDET_BENEFIT_QTY QP_PREQ_GRP.NUMBER_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;

Line 97: G_LDET_BENEFIT_UOM_CODE 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;
101: G_LDET_ESTIM_ACCRUAL_RATE QP_PREQ_GRP.NUMBER_TYPE;

Line 98: G_LDET_LIST_LINE_NO 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;
102: G_LDET_CHARGE_TYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;

Line 99: G_LDET_ACCRUAL_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;
103: G_LDET_CHARGE_SUBTYPE_CODE QP_PREQ_GRP.VARCHAR_TYPE;

Line 100: G_LDET_ACCRUAL_CONVERSION_RATE QP_PREQ_GRP.NUMBER_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;

Line 101: G_LDET_ESTIM_ACCRUAL_RATE 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;

Line 102: G_LDET_CHARGE_TYPE_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;
106: G_LDET_CALCULATION_CODE QP_PREQ_GRP.VARCHAR_TYPE;

Line 103: G_LDET_CHARGE_SUBTYPE_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;

Line 104: G_LDET_LINE_QUANTITY QP_PREQ_GRP.NUMBER_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;

Line 105: G_LDET_UPDATED_FLAG 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

Line 106: G_LDET_CALCULATION_CODE QP_PREQ_GRP.VARCHAR_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
110: G_LDET_ACCUM_ATTRIBUTE QP_PREQ_GRP.VARCHAR_TYPE; -- accum range break

Line 107: G_LDET_CHANGE_REASON_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
111: G_LDET_ACCUM_FLAG QP_PREQ_GRP.VARCHAR_TYPE; -- accum range break

Line 108: G_LDET_CHANGE_REASON_TEXT 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
112: G_LDET_BREAK_UOM_CODE QP_PREQ_GRP.VARCHAR_TYPE; /* Proration*/

Line 109: G_LDET_ACCUM_CONTEXT QP_PREQ_GRP.VARCHAR_TYPE; -- accum range break

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*/

Line 110: G_LDET_ACCUM_ATTRIBUTE QP_PREQ_GRP.VARCHAR_TYPE; -- accum range break

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;

Line 111: G_LDET_ACCUM_FLAG QP_PREQ_GRP.VARCHAR_TYPE; -- accum range break

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;

Line 112: G_LDET_BREAK_UOM_CODE QP_PREQ_GRP.VARCHAR_TYPE; /* Proration*/

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:

Line 113: G_LDET_BREAK_UOM_CONTEXT QP_PREQ_GRP.VARCHAR_TYPE; /* Proration*/

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(

Line 114: G_LDET_BREAK_UOM_ATTRIBUTE QP_PREQ_GRP.VARCHAR_TYPE;

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

Line 115: G_LDET_ADJUSTMENT_AMOUNT QP_PREQ_GRP.NUMBER_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

Line 149: oe_debug_pub.add( ' REQUEST ID IS : ' || QP_PREQ_GRP.G_REQUEST_ID , 1 ) ;

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;

Line 214: G_LDET_LINE_DETAIL_INDEX(j) := QP_PREQ_GRP.GET_LINE_DETAIL_INDEX;

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;

Line 272: l_req_line_rec QP_PREQ_GRP.LINE_REC_TYPE;

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: --

Line 288: QP_PREQ_GRP.G_CURRENCY_CODE := l_req_line_rec.currency_code;

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:

Line 325: G_PROCESSED_FLAG_TBL(px_line_index) := QP_PREQ_GRP.G_NOT_PROCESSED;

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';

Line 332: G_PRICING_STATUS_CODE_tbl(px_line_index) := QP_PREQ_GRP.G_STATUS_UNCHANGED;

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';

Line 358: --,px_req_line_tbl in out nocopy QP_PREQ_GRP.LINE_TBL_TYPE

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

Line 428: G_PROCESSED_FLAG_TBL(px_line_index) := QP_PREQ_GRP.G_NOT_PROCESSED;

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 ) ) ;

Line 437: G_PRICING_STATUS_CODE_tbl(px_line_index) := QP_PREQ_GRP.G_STATUS_UNCHANGED; -- AG

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;

Line 576: QP_PREQ_GRP.INSERT_LINES2

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,

Line 674: QP_PREQ_GRP.INSERT_LDETS2

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,

Line 730: QP_PREQ_GRP.INSERT_LINE_ATTRS2

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 ,

Line 933: (QP_PREQ_GRP.G_STATUS_UNCHANGED,

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)));

Line 934: QP_PREQ_GRP.G_STATUS_UPDATED,

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

Line 935: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION,

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

Line 959: --and lines.pricing_status_code in (QP_PREQ_GRP.G_STATUS_UPDATED

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;

Line 960: -- , QP_PREQ_GRP.G_STATUS_GSA_VIOLATION

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: --

Line 1015: wrong_line.processed_code = QP_PREQ_GRP.G_STS_LHS_NOT_FOUND Then

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

Line 1039: wrong_line.pricing_status_code in ( QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST,

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,

Line 1040: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND,

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,

Line 1041: QP_PREQ_GRP.G_STATUS_FORMULA_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,

Line 1042: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,

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,

Line 1045: QP_PREQ_GRP.G_STATUS_CALC_ERROR,

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,

Line 1046: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,

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,

Line 1047: QP_PREQ_GRP.G_STATUS_INVALID_UOM,

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)

Line 1048: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,

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

Line 1049: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,

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:

Line 1050: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP,

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';

Line 1051: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR)

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

Line 1063: If wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST then

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');

Line 1109: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STS_LHS_NOT_FOUND Then

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');

Line 1125: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_FORMULA_ERROR then

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');

Line 1141: ( QP_PREQ_GRP.G_STATUS_OTHER_ERRORS , FND_API.G_RET_STS_UNEXP_ERROR,

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' ) ;

Line 1158: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM then

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');

Line 1174: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST then

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');

Line 1222: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV then

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');

Line 1238: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_INVALID_INCOMP then

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');

Line 1254: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR then

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');

Line 1308: wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS

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','( '

Line 1484: AND ldets.process_code in (QP_PREQ_GRP.G_STATUS_NEW, QP_PREQ_GRP.G_STATUS_UPDATED, QP_PREQ_GRP.G_STATUS_UNCHANGED)

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

Line 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)

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'

Line 1488: --AND ldets.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW

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')

Line 1669: l_control_rec QP_PREQ_GRP.control_record_type;

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: --

Line 1792: and lines.pricing_status_code in (QP_PREQ_GRP.G_STATUS_GSA_VIOLATION,

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

Line 1793: QP_PREQ_GRP.G_STATUS_UPDATED)

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: