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

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:
75: Procedure Preprocessing(

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:
75: Procedure Preprocessing(
76: px_Header_Rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_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:
75: Procedure Preprocessing(
76: px_Header_Rec IN OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type
77: ,px_Line_Rec IN OUT NOCOPY OE_ORDER_PUB.Line_Rec_Type

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

92: G_PASS_LINE_TBL.delete;
93: qp_price_request_context.set_request_id;
94:
95: IF l_debug_level > 0 THEN
96: oe_debug_pub.add( ' REQUEST ID IS : ' || QP_PREQ_GRP.G_REQUEST_ID , 1 ) ;
97: END IF;
98:
99: -- Use the given header to price
100: OE_ORDER_PUB.g_hdr := px_header_rec;

Line 155: (select QP_PREQ_GRP.G_REQUEST_ID,

151: CALCULATION_CODE,
152: CHANGE_REASON_CODE,
153: CHANGE_REASON_TEXT,
154: ADJUSTMENT_AMOUNT)
155: (select QP_PREQ_GRP.G_REQUEST_ID,
156: i,
157: 'NULL',
158: 'NULL', --ll.PRICE_BREAK_TYPE_CODE,
159: px_line_adj_tbl(i).header_id + nvl(px_line_adj_tbl(i).line_id, 0), --line.LINE_INDEX,

Line 212: l_req_line_rec QP_PREQ_GRP.LINE_REC_TYPE;

208: ,p_calculate_price_flag varchar2
209: ,px_line_index in out NOCOPY NUMBER
210: )
211: is
212: l_req_line_rec QP_PREQ_GRP.LINE_REC_TYPE;
213: --l_line_index pls_integer := px_req_line_tbl.count;
214: --
215: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
216: --

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

224: px_line_index := px_line_index+1;
225:
226:
227: l_req_line_rec.CURRENCY_CODE := p_Header_rec.transactional_curr_code;
228: QP_PREQ_GRP.G_CURRENCY_CODE := l_req_line_rec.currency_code;
229: l_req_line_rec.PRICE_FLAG := p_calculate_price_flag;
230: l_req_line_rec.Active_date_first_type := 'ORD';
231: l_req_line_rec.Active_date_first := p_Header_rec.Ordered_date;
232:

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

261: G_CURRENCY_CODE_TBL(px_line_index) := p_header_rec.transactional_CURR_CODE;
262: G_UNIT_PRICE_TBL(px_line_index) := NULL;
263: G_PERCENT_PRICE_TBL(px_line_index) := NULL;
264: G_ADJUSTED_UNIT_PRICE_TBL(px_line_index) := NULL;
265: G_PROCESSED_FLAG_TBL(px_line_index) := QP_PREQ_GRP.G_NOT_PROCESSED;
266: G_PRICE_FLAG_TBL(px_line_index) := p_calculate_price_flag;
267: G_LINE_ID_TBL(px_line_index) := p_header_rec.header_id;
268: G_ROUNDING_FLAG_TBL(px_line_index)
269: := 'Q';

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

268: G_ROUNDING_FLAG_TBL(px_line_index)
269: := 'Q';
270: G_ROUNDING_FACTOR_TBL(px_line_index) := NULL;
271: G_PROCESSING_ORDER_TBL(px_line_index) := NULL;
272: G_PRICING_STATUS_CODE_tbl(px_line_index) := QP_PREQ_GRP.G_STATUS_UNCHANGED;
273: G_PRICING_STATUS_TEXT_tbl(px_line_index) := NULL;
274:
275: G_QUALIFIERS_EXIST_FLAG_TBL(px_line_index) :='N';
276: G_PRICING_ATTRS_EXIST_FLAG_TBL(px_line_index) :='N';

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

294: end copy_Header_to_request;
295:
296: procedure copy_Line_to_request(
297: p_Line_rec OE_Order_PUB.Line_Rec_Type
298: --,px_req_line_tbl in out nocopy QP_PREQ_GRP.LINE_TBL_TYPE
299: ,p_pricing_events varchar2
300: ,p_request_type_code varchar2
301: ,p_honor_price_flag varchar2
302: ,px_line_index in out NOCOPY NUMBER

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

364: G_CURRENCY_CODE_TBL(px_line_index) := oe_order_pub.g_hdr.TRANSACTIONAL_CURR_CODE;
365: G_UNIT_PRICE_TBL(px_line_index) := p_line_Rec.UNIT_LIST_PRICE_PER_PQTY;
366: G_PERCENT_PRICE_TBL(px_line_index) := NULL;
367: G_ADJUSTED_UNIT_PRICE_TBL(px_line_index) := p_line_rec.UNIT_SELLING_PRICE_PER_PQTY;
368: G_PROCESSED_FLAG_TBL(px_line_index) := QP_PREQ_GRP.G_NOT_PROCESSED;
369: G_PRICE_FLAG_TBL(px_line_index) := nvl(p_line_rec.CALCULATE_PRICE_FLAG,'Y');
370: G_LINE_ID_TBL(px_line_index) := p_line_rec.LINE_ID;
371: IF l_debug_level > 0 THEN
372: oe_debug_pub.add( 'LINE ID IN G_LINE_ID_TBL:'|| G_LINE_ID_TBL ( PX_LINE_INDEX ) ) ;

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

373: END IF;
374: G_ROUNDING_FLAG_TBL(px_line_index) := 'Q';
375: G_ROUNDING_FACTOR_TBL(px_line_index) := NULL;
376: G_PROCESSING_ORDER_TBL(px_line_index) := NULL;
377: G_PRICING_STATUS_CODE_tbl(px_line_index) := QP_PREQ_GRP.G_STATUS_UNCHANGED; -- AG
378: G_PRICING_STATUS_TEXT_tbl(px_line_index) := NULL;
379: G_QUALIFIERS_EXIST_FLAG_TBL(px_line_index) :='N';
380: G_PRICING_ATTRS_EXIST_FLAG_TBL(px_line_index) :='N';
381: G_PRICE_LIST_ID_TBL(px_line_index) :=p_line_rec.price_list_id;

Line 514: QP_PREQ_GRP.INSERT_LINES2

510: BEGIN
511: IF l_debug_level > 0 THEN
512: oe_debug_pub.add( 'BEFORE DIRECT INSERT INTO TEMP TABLE: BULK INSERT'||G_LINE_INDEX_TBL.COUNT , 1 ) ;
513: END IF;
514: QP_PREQ_GRP.INSERT_LINES2
515: (p_LINE_INDEX => G_LINE_INDEX_TBL,
516: p_LINE_TYPE_CODE => G_LINE_TYPE_CODE_TBL,
517: p_PRICING_EFFECTIVE_DATE =>G_PRICING_EFFECTIVE_DATE_TBL,
518: p_ACTIVE_DATE_FIRST =>G_ACTIVE_DATE_FIRST_TBL,

Line 564: QP_PREQ_GRP.INSERT_LINE_ATTRS2

560: RAISE FND_API.G_EXC_ERROR;
561: END IF;
562:
563: IF G_ATTR_LINE_INDEX_tbl.count > 0 THEN
564: QP_PREQ_GRP.INSERT_LINE_ATTRS2
565: ( G_ATTR_LINE_INDEX_tbl,
566: G_ATTR_LINE_DETAIL_INDEX_tbl ,
567: G_ATTR_ATTRIBUTE_LEVEL_tbl ,
568: G_ATTR_ATTRIBUTE_TYPE_tbl ,

Line 626: l_routine VARCHAR2(240):='QP_PREQ_GRP.Reset_All_Tbls';

622: +--------------------------------------------------------------------
623: */
624: PROCEDURE Reset_All_Tbls
625: AS
626: l_routine VARCHAR2(240):='QP_PREQ_GRP.Reset_All_Tbls';
627: --
628: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
629: --
630: BEGIN

Line 729: (QP_PREQ_GRP.G_STATUS_UNCHANGED,

725: , priced_uom_code
726: from qp_preq_lines_tmp
727: where process_status <> 'NOT_VALID' and
728: (pricing_status_code not in
729: (QP_PREQ_GRP.G_STATUS_UNCHANGED,
730: QP_PREQ_GRP.G_STATUS_UPDATED,
731: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION,
732: 'NOT_VALID')
733: OR (l_allow_negative_price = 'N' AND (unit_price<0 OR adjusted_unit_price<0)));

Line 730: QP_PREQ_GRP.G_STATUS_UPDATED,

726: from qp_preq_lines_tmp
727: where process_status <> 'NOT_VALID' and
728: (pricing_status_code not in
729: (QP_PREQ_GRP.G_STATUS_UNCHANGED,
730: QP_PREQ_GRP.G_STATUS_UPDATED,
731: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION,
732: 'NOT_VALID')
733: OR (l_allow_negative_price = 'N' AND (unit_price<0 OR adjusted_unit_price<0)));
734: cursor wrong_book_lines is

Line 731: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION,

727: where process_status <> 'NOT_VALID' and
728: (pricing_status_code not in
729: (QP_PREQ_GRP.G_STATUS_UNCHANGED,
730: QP_PREQ_GRP.G_STATUS_UPDATED,
731: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION,
732: 'NOT_VALID')
733: OR (l_allow_negative_price = 'N' AND (unit_price<0 OR adjusted_unit_price<0)));
734: cursor wrong_book_lines is
735: select lines.line_id

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

751: or lines.price_list_header_id is NULL)
752: and lines.process_status <> 'NOT_VALID'
753: ;
754: -- Bug 2079138: booked lines should always have price
755: --and lines.pricing_status_code in (QP_PREQ_GRP.G_STATUS_UPDATED
756: -- , QP_PREQ_GRP.G_STATUS_GSA_VIOLATION
757: -- );
758: --
759: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 756: -- , QP_PREQ_GRP.G_STATUS_GSA_VIOLATION

752: and lines.process_status <> 'NOT_VALID'
753: ;
754: -- Bug 2079138: booked lines should always have price
755: --and lines.pricing_status_code in (QP_PREQ_GRP.G_STATUS_UPDATED
756: -- , QP_PREQ_GRP.G_STATUS_GSA_VIOLATION
757: -- );
758: --
759: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
760: --

Line 809: wrong_line.processed_code = QP_PREQ_GRP.G_STS_LHS_NOT_FOUND Then

805: END IF;
806: l_invalid_line := 'N';
807: -- add message when the price list is found to be inactive
808: IF wrong_line.line_Type_code ='LINE' and
809: wrong_line.processed_code = QP_PREQ_GRP.G_STS_LHS_NOT_FOUND Then
810: IF l_debug_level > 0 THEN
811: oe_debug_pub.add( 'PRICE LIST NOT FOUND' ) ;
812: END IF;
813: IF l_debug_level > 0 THEN

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

829: l_invalid_line := 'Y';
830: END IF;
831:
832: if wrong_line.line_Type_code ='LINE' and
833: wrong_line.pricing_status_code in ( QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST,
834: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND,
835: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,
836: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
837: FND_API.G_RET_STS_UNEXP_ERROR,

Line 834: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND,

830: END IF;
831:
832: if wrong_line.line_Type_code ='LINE' and
833: wrong_line.pricing_status_code in ( QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST,
834: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND,
835: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,
836: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
837: FND_API.G_RET_STS_UNEXP_ERROR,
838: FND_API.G_RET_STS_ERROR,

Line 835: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,

831:
832: if wrong_line.line_Type_code ='LINE' and
833: wrong_line.pricing_status_code in ( QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST,
834: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND,
835: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,
836: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
837: FND_API.G_RET_STS_UNEXP_ERROR,
838: FND_API.G_RET_STS_ERROR,
839: QP_PREQ_GRP.G_STATUS_CALC_ERROR,

Line 836: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,

832: if wrong_line.line_Type_code ='LINE' and
833: wrong_line.pricing_status_code in ( QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST,
834: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND,
835: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,
836: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
837: FND_API.G_RET_STS_UNEXP_ERROR,
838: FND_API.G_RET_STS_ERROR,
839: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
840: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,

Line 839: QP_PREQ_GRP.G_STATUS_CALC_ERROR,

835: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,
836: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
837: FND_API.G_RET_STS_UNEXP_ERROR,
838: FND_API.G_RET_STS_ERROR,
839: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
840: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
841: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
842: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
843: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,

Line 840: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,

836: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
837: FND_API.G_RET_STS_UNEXP_ERROR,
838: FND_API.G_RET_STS_ERROR,
839: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
840: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
841: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
842: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
843: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,
844: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP,

Line 841: QP_PREQ_GRP.G_STATUS_INVALID_UOM,

837: FND_API.G_RET_STS_UNEXP_ERROR,
838: FND_API.G_RET_STS_ERROR,
839: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
840: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
841: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
842: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
843: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,
844: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP,
845: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR)

Line 842: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,

838: FND_API.G_RET_STS_ERROR,
839: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
840: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
841: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
842: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
843: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,
844: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP,
845: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR)
846: then

Line 843: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,

839: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
840: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
841: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
842: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
843: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,
844: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP,
845: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR)
846: then
847:

Line 844: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP,

840: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
841: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
842: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
843: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,
844: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP,
845: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR)
846: then
847:
848: l_invalid_line := 'Y';

Line 845: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR)

841: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
842: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
843: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,
844: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP,
845: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR)
846: then
847:
848: l_invalid_line := 'Y';
849: Begin

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

853: Exception When No_data_found then
854: l_price_list := l_line_rec.price_list_id;
855: End;
856:
857: If wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST then
858: IF l_debug_level > 0 THEN
859: oe_debug_pub.add( 'INVALID ITEM/PRICE LIST COMBINATION'||L_LINE_REC.ORDERED_ITEM||L_LINE_REC.ORDER_QUANTITY_UOM||L_PRICE_LIST ) ;
860: END IF;
861: FND_MESSAGE.SET_NAME('ONT','OE_PRC_NO_LIST_PRICE');

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

899: l_line_rec.unit_list_price_per_pqty := NULL;
900: END IF;
901:
902:
903: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STS_LHS_NOT_FOUND Then
904: IF l_debug_level > 0 THEN
905: oe_debug_pub.add( 'PRICE LIST NOT FOUND' ) ;
906: END IF;
907: FND_MESSAGE.SET_NAME('ONT','ONT_NO_PRICE_LIST_FOUND');

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

915: end if;
916: else
917: OE_MSG_PUB.Add;
918: end if;
919: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_FORMULA_ERROR then
920: IF l_debug_level > 0 THEN
921: oe_debug_pub.add( 'ERROR IN FORMULA PROCESSING' ) ;
922: END IF;
923: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_ERROR_IN_FORMULA');

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

931: else
932: OE_MSG_PUB.Add;
933: end if;
934: Elsif wrong_line.pricing_status_code in
935: ( QP_PREQ_GRP.G_STATUS_OTHER_ERRORS , FND_API.G_RET_STS_UNEXP_ERROR,
936: FND_API.G_RET_STS_ERROR)
937: then
938: IF l_debug_level > 0 THEN
939: oe_debug_pub.add( 'OTHER ERRORS PROCESSING' ) ;

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

948: end if;
949: else
950: OE_MSG_PUB.Add;
951: end if;
952: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM then
953: IF l_debug_level > 0 THEN
954: oe_debug_pub.add( 'INVALID UOM' ) ;
955: END IF;
956: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM');

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

964: end if;
965: else
966: OE_MSG_PUB.Add;
967: end if;
968: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST then
969: IF l_debug_level > 0 THEN
970: oe_debug_pub.add( 'DUPLICATE PRICE LIST' ) ;
971: END IF;
972: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_DUPLICATE_PRICE_LIST');

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

1012: end if;
1013: else
1014: OE_MSG_PUB.Add;
1015: end if;
1016: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV then
1017: IF l_debug_level > 0 THEN
1018: oe_debug_pub.add( 'INVALID UOM CONVERSION' ) ;
1019: END IF;
1020: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM_CONVERSION');

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

1028: end if;
1029: else
1030: OE_MSG_PUB.Add;
1031: end if;
1032: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_INVALID_INCOMP then
1033: IF l_debug_level > 0 THEN
1034: oe_debug_pub.add( 'UNABLE TO RESOLVE INCOMPATIBILITY' ) ;
1035: END IF;
1036: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_INCOMP');

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

1044: end if;
1045: else
1046: OE_MSG_PUB.Add;
1047: end if;
1048: Elsif wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR then
1049: IF l_debug_level > 0 THEN
1050: oe_debug_pub.add( 'ERROR WHILE EVALUATING THE BEST PRICE' ) ;
1051: END IF;
1052: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_BEST_PRICE_ERROR');

Line 1102: wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS

1098: --btea end
1099:
1100: elsif
1101: wrong_line.line_Type_code ='LINE' and
1102: wrong_line.pricing_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS
1103: Then
1104:
1105: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_ERROR');
1106: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '

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

1271: , QP_PREQ_LINES_TMP lines
1272: , QP_LIST_HEADERS_B QH
1273: WHERE
1274: ldets.list_header_id=qh.list_header_id
1275: AND ldets.process_code in (QP_PREQ_GRP.G_STATUS_NEW, QP_PREQ_GRP.G_STATUS_UPDATED, QP_PREQ_GRP.G_STATUS_UNCHANGED)
1276: 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)
1277: AND lines.process_status <> 'NOT_VALID'
1278: AND ldets.line_index=lines.line_index
1279: --AND ldets.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW

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

1272: , QP_LIST_HEADERS_B QH
1273: WHERE
1274: ldets.list_header_id=qh.list_header_id
1275: AND ldets.process_code in (QP_PREQ_GRP.G_STATUS_NEW, QP_PREQ_GRP.G_STATUS_UPDATED, QP_PREQ_GRP.G_STATUS_UNCHANGED)
1276: 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)
1277: AND lines.process_status <> 'NOT_VALID'
1278: AND ldets.line_index=lines.line_index
1279: --AND ldets.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW
1280: --AND nvl(ldets.automatic_flag,'N') = 'Y'

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

1275: AND ldets.process_code in (QP_PREQ_GRP.G_STATUS_NEW, QP_PREQ_GRP.G_STATUS_UPDATED, QP_PREQ_GRP.G_STATUS_UNCHANGED)
1276: 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)
1277: AND lines.process_status <> 'NOT_VALID'
1278: AND ldets.line_index=lines.line_index
1279: --AND ldets.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW
1280: --AND nvl(ldets.automatic_flag,'N') = 'Y'
1281: -- or
1282: -- (ldets.list_line_type_code = 'FREIGHT_CHARGE'))
1283: AND ldets.created_from_list_type_code not in ('PRL','AGR')

Line 1446: l_control_rec QP_PREQ_GRP.control_record_type;

1442:
1443: )
1444: IS
1445: l_return_status_text varchar(2000);
1446: l_control_rec QP_PREQ_GRP.control_record_type;
1447: l_set_of_books Oe_Order_Cache.Set_Of_Books_Rec_Type;
1448: --
1449: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1450: --

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

1562: where lines.line_id=l_line_rec.line_id
1563: and lines.line_type_code='LINE'
1564: and l_line_rec.ordered_quantity <> 0
1565: and lines.process_status <> 'NOT_VALID'
1566: and lines.pricing_status_code in (QP_PREQ_GRP.G_STATUS_GSA_VIOLATION,
1567: QP_PREQ_GRP.G_STATUS_UPDATED)
1568: ;
1569: EXCEPTION
1570: WHEN OTHERS THEN

Line 1567: QP_PREQ_GRP.G_STATUS_UPDATED)

1563: and lines.line_type_code='LINE'
1564: and l_line_rec.ordered_quantity <> 0
1565: and lines.process_status <> 'NOT_VALID'
1566: and lines.pricing_status_code in (QP_PREQ_GRP.G_STATUS_GSA_VIOLATION,
1567: QP_PREQ_GRP.G_STATUS_UPDATED)
1568: ;
1569: EXCEPTION
1570: WHEN OTHERS THEN
1571: