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

Line 10: G_LINE_INDEX_TBL QP_PREQ_GRP.pls_integer_type;

6: --
7: -- Following G_ global variables will be used for Advanced Pricing
8: --
9: --===================================================================
10: G_LINE_INDEX_TBL QP_PREQ_GRP.pls_integer_type;
11: G_LINE_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
12: G_PRICING_EFFECTIVE_DATE_TBL QP_PREQ_GRP.DATE_TYPE;
13: G_ACTIVE_DATE_FIRST_TBL QP_PREQ_GRP.DATE_TYPE;
14: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 11: G_LINE_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

7: -- Following G_ global variables will be used for Advanced Pricing
8: --
9: --===================================================================
10: G_LINE_INDEX_TBL QP_PREQ_GRP.pls_integer_type;
11: G_LINE_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
12: G_PRICING_EFFECTIVE_DATE_TBL QP_PREQ_GRP.DATE_TYPE;
13: G_ACTIVE_DATE_FIRST_TBL QP_PREQ_GRP.DATE_TYPE;
14: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
15: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE;

Line 12: G_PRICING_EFFECTIVE_DATE_TBL QP_PREQ_GRP.DATE_TYPE;

8: --
9: --===================================================================
10: G_LINE_INDEX_TBL QP_PREQ_GRP.pls_integer_type;
11: G_LINE_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
12: G_PRICING_EFFECTIVE_DATE_TBL QP_PREQ_GRP.DATE_TYPE;
13: G_ACTIVE_DATE_FIRST_TBL QP_PREQ_GRP.DATE_TYPE;
14: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
15: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE;
16: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

Line 13: G_ACTIVE_DATE_FIRST_TBL QP_PREQ_GRP.DATE_TYPE;

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

Line 14: G_ACTIVE_DATE_FIRST_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

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

Line 15: G_ACTIVE_DATE_SECOND_TBL QP_PREQ_GRP.DATE_TYPE;

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

Line 16: G_ACTIVE_DATE_SECOND_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

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

Line 17: G_LINE_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;

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

Line 18: G_LINE_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

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

Line 19: G_REQUEST_TYPE_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

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

Line 20: G_PRICED_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;

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

Line 21: G_UOM_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;

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

Line 22: G_PRICED_UOM_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

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

Line 23: G_CURRENCY_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

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

Line 24: G_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;

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

Line 25: G_PERCENT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;

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

Line 26: G_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;

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

Line 27: G_UPD_ADJUSTED_UNIT_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;

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

Line 28: G_PROCESSED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

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

Line 29: G_PRICE_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

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

Line 30: G_LINE_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;

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

Line 31: G_PROCESSING_ORDER_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;

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

Line 32: G_ROUNDING_FACTOR_TBL QP_PREQ_GRP.PLS_INTEGER_TYPE;

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

Line 33: G_ROUNDING_FLAG_TBL QP_PREQ_GRP.FLAG_TYPE;

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

Line 34: G_QUALIFIERS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

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

Line 35: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

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

Line 36: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;

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

Line 37: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;

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

Line 38: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

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

Line 39: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

35: G_PRICING_ATTRS_EXIST_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
36: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
37: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
38: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
39: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
40: G_PRICING_STATUS_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
41: G_PRICING_STATUS_TEXT_TBL QP_PREQ_GRP.VARCHAR_TYPE;
42: G_LINE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
43:

Line 40: G_PRICING_STATUS_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;

36: G_PRICE_LIST_ID_TBL QP_PREQ_GRP.NUMBER_TYPE;
37: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
38: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
39: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
40: G_PRICING_STATUS_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
41: G_PRICING_STATUS_TEXT_TBL QP_PREQ_GRP.VARCHAR_TYPE;
42: G_LINE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
43:
44: G_UNIT_SELLING_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;

Line 41: G_PRICING_STATUS_TEXT_TBL QP_PREQ_GRP.VARCHAR_TYPE;

37: G_PL_VALIDATED_FLAG_TBL QP_PREQ_GRP.VARCHAR_TYPE;
38: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
39: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
40: G_PRICING_STATUS_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
41: G_PRICING_STATUS_TEXT_TBL QP_PREQ_GRP.VARCHAR_TYPE;
42: G_LINE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
43:
44: G_UNIT_SELLING_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
45: G_UNIT_LIST_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;

Line 42: G_LINE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;

38: G_PRICE_REQUEST_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
39: G_USAGE_PRICING_TYPE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
40: G_PRICING_STATUS_CODE_TBL QP_PREQ_GRP.VARCHAR_TYPE;
41: G_PRICING_STATUS_TEXT_TBL QP_PREQ_GRP.VARCHAR_TYPE;
42: G_LINE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
43:
44: G_UNIT_SELLING_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
45: G_UNIT_LIST_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
46: G_UNIT_SELL_PRICE_PER_PQTY_TBL QP_PREQ_GRP.NUMBER_TYPE;

Line 44: G_UNIT_SELLING_PRICE_TBL QP_PREQ_GRP.NUMBER_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_LINE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
43:
44: G_UNIT_SELLING_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
45: G_UNIT_LIST_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
46: G_UNIT_SELL_PRICE_PER_PQTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
47: G_UNIT_LIST_PRICE_PER_PQTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
48: G_PRICING_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;

Line 45: G_UNIT_LIST_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;

41: G_PRICING_STATUS_TEXT_TBL QP_PREQ_GRP.VARCHAR_TYPE;
42: G_LINE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
43:
44: G_UNIT_SELLING_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
45: G_UNIT_LIST_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
46: G_UNIT_SELL_PRICE_PER_PQTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
47: G_UNIT_LIST_PRICE_PER_PQTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
48: G_PRICING_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
49: G_UNIT_LIST_PERCENT_TBL QP_PREQ_GRP.NUMBER_TYPE;

Line 46: G_UNIT_SELL_PRICE_PER_PQTY_TBL QP_PREQ_GRP.NUMBER_TYPE;

42: G_LINE_CATEGORY_TBL QP_PREQ_GRP.VARCHAR_TYPE;
43:
44: G_UNIT_SELLING_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
45: G_UNIT_LIST_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
46: G_UNIT_SELL_PRICE_PER_PQTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
47: G_UNIT_LIST_PRICE_PER_PQTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
48: G_PRICING_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
49: G_UNIT_LIST_PERCENT_TBL QP_PREQ_GRP.NUMBER_TYPE;
50: G_UNIT_PERCENT_BASE_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;

Line 47: G_UNIT_LIST_PRICE_PER_PQTY_TBL QP_PREQ_GRP.NUMBER_TYPE;

43:
44: G_UNIT_SELLING_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
45: G_UNIT_LIST_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
46: G_UNIT_SELL_PRICE_PER_PQTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
47: G_UNIT_LIST_PRICE_PER_PQTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
48: G_PRICING_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
49: G_UNIT_LIST_PERCENT_TBL QP_PREQ_GRP.NUMBER_TYPE;
50: G_UNIT_PERCENT_BASE_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
51: G_UNIT_SELLING_PERCENT_TBL QP_PREQ_GRP.NUMBER_TYPE;

Line 48: G_PRICING_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;

44: G_UNIT_SELLING_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
45: G_UNIT_LIST_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
46: G_UNIT_SELL_PRICE_PER_PQTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
47: G_UNIT_LIST_PRICE_PER_PQTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
48: G_PRICING_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
49: G_UNIT_LIST_PERCENT_TBL QP_PREQ_GRP.NUMBER_TYPE;
50: G_UNIT_PERCENT_BASE_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
51: G_UNIT_SELLING_PERCENT_TBL QP_PREQ_GRP.NUMBER_TYPE;
52:

Line 49: G_UNIT_LIST_PERCENT_TBL QP_PREQ_GRP.NUMBER_TYPE;

45: G_UNIT_LIST_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
46: G_UNIT_SELL_PRICE_PER_PQTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
47: G_UNIT_LIST_PRICE_PER_PQTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
48: G_PRICING_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
49: G_UNIT_LIST_PERCENT_TBL QP_PREQ_GRP.NUMBER_TYPE;
50: G_UNIT_PERCENT_BASE_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
51: G_UNIT_SELLING_PERCENT_TBL QP_PREQ_GRP.NUMBER_TYPE;
52:
53: -- Package body level globals to store input values

Line 50: G_UNIT_PERCENT_BASE_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;

46: G_UNIT_SELL_PRICE_PER_PQTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
47: G_UNIT_LIST_PRICE_PER_PQTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
48: G_PRICING_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
49: G_UNIT_LIST_PERCENT_TBL QP_PREQ_GRP.NUMBER_TYPE;
50: G_UNIT_PERCENT_BASE_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
51: G_UNIT_SELLING_PERCENT_TBL QP_PREQ_GRP.NUMBER_TYPE;
52:
53: -- Package body level globals to store input values
54: g_transfer_type VARCHAR2(6); /* INTCOM or INTORG */

Line 51: G_UNIT_SELLING_PERCENT_TBL QP_PREQ_GRP.NUMBER_TYPE;

47: G_UNIT_LIST_PRICE_PER_PQTY_TBL QP_PREQ_GRP.NUMBER_TYPE;
48: G_PRICING_QUANTITY_TBL QP_PREQ_GRP.NUMBER_TYPE;
49: G_UNIT_LIST_PERCENT_TBL QP_PREQ_GRP.NUMBER_TYPE;
50: G_UNIT_PERCENT_BASE_PRICE_TBL QP_PREQ_GRP.NUMBER_TYPE;
51: G_UNIT_SELLING_PERCENT_TBL QP_PREQ_GRP.NUMBER_TYPE;
52:
53: -- Package body level globals to store input values
54: g_transfer_type VARCHAR2(6); /* INTCOM or INTORG */
55:

Line 1015: l_Control_Rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;

1011: l_line_id NUMBER;
1012: l_inventory_item_id NUMBER;
1013: l_organization_id NUMBER;
1014: l_transaction_uom VARCHAR2(3);
1015: l_Control_Rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
1016: l_pricing_event VARCHAR2(30); -- DEFAULT 'ICBATCH';
1017: l_request_type_code VARCHAR2(30); -- DEFAULT 'INTORG'; -- 'INVXFR';
1018: l_line_index NUMBER := 0;
1019: l_return_status_Text VARCHAR2(2000);

Line 1185: l_control_rec.calculate_flag := qp_preq_grp.G_SEARCH_N_CALCULATE;

1181: Print_debug('GMF_get_transfer_price_PUB.get_xfer_price_qp: Initializing control record...');
1182: END IF;
1183:
1184: l_control_rec.pricing_event := l_pricing_event;
1185: l_control_rec.calculate_flag := qp_preq_grp.G_SEARCH_N_CALCULATE;
1186: l_control_rec.temp_table_insert_flag := 'N';
1187: l_control_rec.request_type_code := l_request_type_code;
1188: l_control_rec.rounding_flag := 'Y';
1189: l_control_rec.USE_MULTI_CURRENCY := 'Y';

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

1375:
1376: G_PRICING_EFFECTIVE_DATE_TBL(px_line_index) := trunc(SYSDATE);
1377:
1378: G_CURRENCY_CODE_TBL(px_line_index) := NULL;
1379: G_PROCESSED_FLAG_TBL(px_line_index) := QP_PREQ_GRP.G_NOT_PROCESSED;
1380: G_PRICING_STATUS_CODE_tbl(px_line_index) := QP_PREQ_GRP.G_STATUS_UNCHANGED;
1381: G_USAGE_PRICING_TYPE_TBL(px_line_index) := 'REGULAR';
1382:
1383: G_PRICE_FLAG_TBL(px_line_index) := 'Y';

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

1376: G_PRICING_EFFECTIVE_DATE_TBL(px_line_index) := trunc(SYSDATE);
1377:
1378: G_CURRENCY_CODE_TBL(px_line_index) := NULL;
1379: G_PROCESSED_FLAG_TBL(px_line_index) := QP_PREQ_GRP.G_NOT_PROCESSED;
1380: G_PRICING_STATUS_CODE_tbl(px_line_index) := QP_PREQ_GRP.G_STATUS_UNCHANGED;
1381: G_USAGE_PRICING_TYPE_TBL(px_line_index) := 'REGULAR';
1382:
1383: G_PRICE_FLAG_TBL(px_line_index) := 'Y';
1384: G_QUALIFIERS_EXIST_FLAG_TBL(px_line_index) :='N';

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

1433:
1434: G_PRICED_QUANTITY_TBL(px_line_index) := g_transaction_qty;
1435: G_PRICED_UOM_CODE_TBL(px_line_index) := g_transaction_uom;
1436:
1437: G_PROCESSED_FLAG_TBL(px_line_index) := QP_PREQ_GRP.G_NOT_PROCESSED;
1438: G_PRICING_STATUS_CODE_TBL(px_line_index) := QP_PREQ_GRP.G_STATUS_UNCHANGED;
1439:
1440: G_PRICE_FLAG_TBL(px_line_index) := 'Y';
1441: G_ROUNDING_FLAG_TBL(px_line_index) := 'Y';

Line 1438: G_PRICING_STATUS_CODE_TBL(px_line_index) := QP_PREQ_GRP.G_STATUS_UNCHANGED;

1434: G_PRICED_QUANTITY_TBL(px_line_index) := g_transaction_qty;
1435: G_PRICED_UOM_CODE_TBL(px_line_index) := g_transaction_uom;
1436:
1437: G_PROCESSED_FLAG_TBL(px_line_index) := QP_PREQ_GRP.G_NOT_PROCESSED;
1438: G_PRICING_STATUS_CODE_TBL(px_line_index) := QP_PREQ_GRP.G_STATUS_UNCHANGED;
1439:
1440: G_PRICE_FLAG_TBL(px_line_index) := 'Y';
1441: G_ROUNDING_FLAG_TBL(px_line_index) := 'Y';
1442: G_QUALIFIERS_EXIST_FLAG_TBL(px_line_index) := 'N';

Line 1528: QP_PREQ_GRP.INSERT_LINES2 (

1524: IF (l_debug = 1) THEN
1525: print_debug('GMF_get_transfer_price_PUB.Populate_Temp_Table: Calling QP:Bulk insert routine...' );
1526: END IF;
1527:
1528: QP_PREQ_GRP.INSERT_LINES2 (
1529: p_LINE_INDEX => G_LINE_INDEX_TBL,
1530: p_LINE_TYPE_CODE => G_LINE_TYPE_CODE_TBL,
1531: p_PRICING_EFFECTIVE_DATE => G_PRICING_EFFECTIVE_DATE_TBL,
1532: p_ACTIVE_DATE_FIRST => G_ACTIVE_DATE_FIRST_TBL,

Line 1569: print_debug('GMF_get_transfer_price_PUB.Populate_Temp_Table: QP_PREQ_GRP.INSERT_LINES2 error ' );

1565: print_debug('GMF_get_transfer_price_PUB.Populate_Temp_Table: after QP:Bulk insert routine...' );
1566:
1567: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1568: IF (l_debug = 1) THEN
1569: print_debug('GMF_get_transfer_price_PUB.Populate_Temp_Table: QP_PREQ_GRP.INSERT_LINES2 error ' );
1570: print_debug('GMF_get_transfer_price_PUB.Populate_Temp_Table: x_return_status_text='|| l_return_status_text );
1571: END IF;
1572: x_return_status := l_return_status;
1573: fnd_message.set_name('INV', 'INV_UNHANDLED_ERR');

Line 1574: fnd_message.set_token('ENTITY1', 'QP_PREQ_GRP.INSERT_LINES2');

1570: print_debug('GMF_get_transfer_price_PUB.Populate_Temp_Table: x_return_status_text='|| l_return_status_text );
1571: END IF;
1572: x_return_status := l_return_status;
1573: fnd_message.set_name('INV', 'INV_UNHANDLED_ERR');
1574: fnd_message.set_token('ENTITY1', 'QP_PREQ_GRP.INSERT_LINES2');
1575: fnd_message.set_token('ENTITY2', substr(l_return_status_text, 1, 150) );
1576: RAISE FND_API.G_EXC_ERROR;
1577: END IF;
1578:

Line 1664: IF G_PRICING_STATUS_CODE_TBL(i) = QP_PREQ_GRP.G_STATUS_UPDATED THEN

1660: RAISE;
1661: END;
1662:
1663: IF G_LINE_TYPE_CODE_TBL(i) = 'LINE' THEN
1664: IF G_PRICING_STATUS_CODE_TBL(i) = QP_PREQ_GRP.G_STATUS_UPDATED THEN
1665: IF (l_debug = 1) THEN
1666: print_debug('GMF_get_transfer_price_PUB.Populate_Results: Unit_Price=' || G_UNIT_SELLING_PRICE_TBL(i));
1667: END IF;
1668: ELSE