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

Line 20: g_line_index_tbl qp_preq_grp.pls_integer_type;

16:
17: TYPE date_type IS TABLE OF DATE
18: INDEX BY BINARY_INTEGER;
19:
20: g_line_index_tbl qp_preq_grp.pls_integer_type;
21: g_line_type_code_tbl qp_preq_grp.varchar_type;
22: g_pricing_effective_date_tbl qp_preq_grp.date_type;
23: g_active_date_first_tbl qp_preq_grp.date_type;
24: g_active_date_first_type_tbl qp_preq_grp.varchar_type;

Line 21: g_line_type_code_tbl qp_preq_grp.varchar_type;

17: TYPE date_type IS TABLE OF DATE
18: INDEX BY BINARY_INTEGER;
19:
20: g_line_index_tbl qp_preq_grp.pls_integer_type;
21: g_line_type_code_tbl qp_preq_grp.varchar_type;
22: g_pricing_effective_date_tbl qp_preq_grp.date_type;
23: g_active_date_first_tbl qp_preq_grp.date_type;
24: g_active_date_first_type_tbl qp_preq_grp.varchar_type;
25: g_active_date_second_tbl qp_preq_grp.date_type;

Line 22: g_pricing_effective_date_tbl qp_preq_grp.date_type;

18: INDEX BY BINARY_INTEGER;
19:
20: g_line_index_tbl qp_preq_grp.pls_integer_type;
21: g_line_type_code_tbl qp_preq_grp.varchar_type;
22: g_pricing_effective_date_tbl qp_preq_grp.date_type;
23: g_active_date_first_tbl qp_preq_grp.date_type;
24: g_active_date_first_type_tbl qp_preq_grp.varchar_type;
25: g_active_date_second_tbl qp_preq_grp.date_type;
26: g_active_date_second_type_tbl qp_preq_grp.varchar_type;

Line 23: g_active_date_first_tbl qp_preq_grp.date_type;

19:
20: g_line_index_tbl qp_preq_grp.pls_integer_type;
21: g_line_type_code_tbl qp_preq_grp.varchar_type;
22: g_pricing_effective_date_tbl qp_preq_grp.date_type;
23: g_active_date_first_tbl qp_preq_grp.date_type;
24: g_active_date_first_type_tbl qp_preq_grp.varchar_type;
25: g_active_date_second_tbl qp_preq_grp.date_type;
26: g_active_date_second_type_tbl qp_preq_grp.varchar_type;
27: g_line_quantity_tbl qp_preq_grp.number_type;

Line 24: g_active_date_first_type_tbl qp_preq_grp.varchar_type;

20: g_line_index_tbl qp_preq_grp.pls_integer_type;
21: g_line_type_code_tbl qp_preq_grp.varchar_type;
22: g_pricing_effective_date_tbl qp_preq_grp.date_type;
23: g_active_date_first_tbl qp_preq_grp.date_type;
24: g_active_date_first_type_tbl qp_preq_grp.varchar_type;
25: g_active_date_second_tbl qp_preq_grp.date_type;
26: g_active_date_second_type_tbl qp_preq_grp.varchar_type;
27: g_line_quantity_tbl qp_preq_grp.number_type;
28: g_line_uom_code_tbl qp_preq_grp.varchar_type;

Line 25: g_active_date_second_tbl qp_preq_grp.date_type;

21: g_line_type_code_tbl qp_preq_grp.varchar_type;
22: g_pricing_effective_date_tbl qp_preq_grp.date_type;
23: g_active_date_first_tbl qp_preq_grp.date_type;
24: g_active_date_first_type_tbl qp_preq_grp.varchar_type;
25: g_active_date_second_tbl qp_preq_grp.date_type;
26: g_active_date_second_type_tbl qp_preq_grp.varchar_type;
27: g_line_quantity_tbl qp_preq_grp.number_type;
28: g_line_uom_code_tbl qp_preq_grp.varchar_type;
29: g_request_type_code_tbl qp_preq_grp.varchar_type;

Line 26: g_active_date_second_type_tbl qp_preq_grp.varchar_type;

22: g_pricing_effective_date_tbl qp_preq_grp.date_type;
23: g_active_date_first_tbl qp_preq_grp.date_type;
24: g_active_date_first_type_tbl qp_preq_grp.varchar_type;
25: g_active_date_second_tbl qp_preq_grp.date_type;
26: g_active_date_second_type_tbl qp_preq_grp.varchar_type;
27: g_line_quantity_tbl qp_preq_grp.number_type;
28: g_line_uom_code_tbl qp_preq_grp.varchar_type;
29: g_request_type_code_tbl qp_preq_grp.varchar_type;
30: g_priced_quantity_tbl qp_preq_grp.number_type;

Line 27: g_line_quantity_tbl qp_preq_grp.number_type;

23: g_active_date_first_tbl qp_preq_grp.date_type;
24: g_active_date_first_type_tbl qp_preq_grp.varchar_type;
25: g_active_date_second_tbl qp_preq_grp.date_type;
26: g_active_date_second_type_tbl qp_preq_grp.varchar_type;
27: g_line_quantity_tbl qp_preq_grp.number_type;
28: g_line_uom_code_tbl qp_preq_grp.varchar_type;
29: g_request_type_code_tbl qp_preq_grp.varchar_type;
30: g_priced_quantity_tbl qp_preq_grp.number_type;
31: g_uom_quantity_tbl qp_preq_grp.number_type;

Line 28: g_line_uom_code_tbl qp_preq_grp.varchar_type;

24: g_active_date_first_type_tbl qp_preq_grp.varchar_type;
25: g_active_date_second_tbl qp_preq_grp.date_type;
26: g_active_date_second_type_tbl qp_preq_grp.varchar_type;
27: g_line_quantity_tbl qp_preq_grp.number_type;
28: g_line_uom_code_tbl qp_preq_grp.varchar_type;
29: g_request_type_code_tbl qp_preq_grp.varchar_type;
30: g_priced_quantity_tbl qp_preq_grp.number_type;
31: g_uom_quantity_tbl qp_preq_grp.number_type;
32: g_priced_uom_code_tbl qp_preq_grp.varchar_type;

Line 29: g_request_type_code_tbl qp_preq_grp.varchar_type;

25: g_active_date_second_tbl qp_preq_grp.date_type;
26: g_active_date_second_type_tbl qp_preq_grp.varchar_type;
27: g_line_quantity_tbl qp_preq_grp.number_type;
28: g_line_uom_code_tbl qp_preq_grp.varchar_type;
29: g_request_type_code_tbl qp_preq_grp.varchar_type;
30: g_priced_quantity_tbl qp_preq_grp.number_type;
31: g_uom_quantity_tbl qp_preq_grp.number_type;
32: g_priced_uom_code_tbl qp_preq_grp.varchar_type;
33: g_currency_code_tbl qp_preq_grp.varchar_type;

Line 30: g_priced_quantity_tbl qp_preq_grp.number_type;

26: g_active_date_second_type_tbl qp_preq_grp.varchar_type;
27: g_line_quantity_tbl qp_preq_grp.number_type;
28: g_line_uom_code_tbl qp_preq_grp.varchar_type;
29: g_request_type_code_tbl qp_preq_grp.varchar_type;
30: g_priced_quantity_tbl qp_preq_grp.number_type;
31: g_uom_quantity_tbl qp_preq_grp.number_type;
32: g_priced_uom_code_tbl qp_preq_grp.varchar_type;
33: g_currency_code_tbl qp_preq_grp.varchar_type;
34: g_unit_price_tbl qp_preq_grp.number_type;

Line 31: g_uom_quantity_tbl qp_preq_grp.number_type;

27: g_line_quantity_tbl qp_preq_grp.number_type;
28: g_line_uom_code_tbl qp_preq_grp.varchar_type;
29: g_request_type_code_tbl qp_preq_grp.varchar_type;
30: g_priced_quantity_tbl qp_preq_grp.number_type;
31: g_uom_quantity_tbl qp_preq_grp.number_type;
32: g_priced_uom_code_tbl qp_preq_grp.varchar_type;
33: g_currency_code_tbl qp_preq_grp.varchar_type;
34: g_unit_price_tbl qp_preq_grp.number_type;
35: g_percent_price_tbl qp_preq_grp.number_type;

Line 32: g_priced_uom_code_tbl qp_preq_grp.varchar_type;

28: g_line_uom_code_tbl qp_preq_grp.varchar_type;
29: g_request_type_code_tbl qp_preq_grp.varchar_type;
30: g_priced_quantity_tbl qp_preq_grp.number_type;
31: g_uom_quantity_tbl qp_preq_grp.number_type;
32: g_priced_uom_code_tbl qp_preq_grp.varchar_type;
33: g_currency_code_tbl qp_preq_grp.varchar_type;
34: g_unit_price_tbl qp_preq_grp.number_type;
35: g_percent_price_tbl qp_preq_grp.number_type;
36: g_adjusted_unit_price_tbl qp_preq_grp.number_type;

Line 33: g_currency_code_tbl qp_preq_grp.varchar_type;

29: g_request_type_code_tbl qp_preq_grp.varchar_type;
30: g_priced_quantity_tbl qp_preq_grp.number_type;
31: g_uom_quantity_tbl qp_preq_grp.number_type;
32: g_priced_uom_code_tbl qp_preq_grp.varchar_type;
33: g_currency_code_tbl qp_preq_grp.varchar_type;
34: g_unit_price_tbl qp_preq_grp.number_type;
35: g_percent_price_tbl qp_preq_grp.number_type;
36: g_adjusted_unit_price_tbl qp_preq_grp.number_type;
37: g_upd_adjusted_unit_price_tbl qp_preq_grp.number_type;

Line 34: g_unit_price_tbl qp_preq_grp.number_type;

30: g_priced_quantity_tbl qp_preq_grp.number_type;
31: g_uom_quantity_tbl qp_preq_grp.number_type;
32: g_priced_uom_code_tbl qp_preq_grp.varchar_type;
33: g_currency_code_tbl qp_preq_grp.varchar_type;
34: g_unit_price_tbl qp_preq_grp.number_type;
35: g_percent_price_tbl qp_preq_grp.number_type;
36: g_adjusted_unit_price_tbl qp_preq_grp.number_type;
37: g_upd_adjusted_unit_price_tbl qp_preq_grp.number_type;
38: g_processed_flag_tbl qp_preq_grp.varchar_type;

Line 35: g_percent_price_tbl qp_preq_grp.number_type;

31: g_uom_quantity_tbl qp_preq_grp.number_type;
32: g_priced_uom_code_tbl qp_preq_grp.varchar_type;
33: g_currency_code_tbl qp_preq_grp.varchar_type;
34: g_unit_price_tbl qp_preq_grp.number_type;
35: g_percent_price_tbl qp_preq_grp.number_type;
36: g_adjusted_unit_price_tbl qp_preq_grp.number_type;
37: g_upd_adjusted_unit_price_tbl qp_preq_grp.number_type;
38: g_processed_flag_tbl qp_preq_grp.varchar_type;
39: g_price_flag_tbl qp_preq_grp.varchar_type;

Line 36: g_adjusted_unit_price_tbl qp_preq_grp.number_type;

32: g_priced_uom_code_tbl qp_preq_grp.varchar_type;
33: g_currency_code_tbl qp_preq_grp.varchar_type;
34: g_unit_price_tbl qp_preq_grp.number_type;
35: g_percent_price_tbl qp_preq_grp.number_type;
36: g_adjusted_unit_price_tbl qp_preq_grp.number_type;
37: g_upd_adjusted_unit_price_tbl qp_preq_grp.number_type;
38: g_processed_flag_tbl qp_preq_grp.varchar_type;
39: g_price_flag_tbl qp_preq_grp.varchar_type;
40: g_line_id_tbl qp_preq_grp.number_type;

Line 37: g_upd_adjusted_unit_price_tbl qp_preq_grp.number_type;

33: g_currency_code_tbl qp_preq_grp.varchar_type;
34: g_unit_price_tbl qp_preq_grp.number_type;
35: g_percent_price_tbl qp_preq_grp.number_type;
36: g_adjusted_unit_price_tbl qp_preq_grp.number_type;
37: g_upd_adjusted_unit_price_tbl qp_preq_grp.number_type;
38: g_processed_flag_tbl qp_preq_grp.varchar_type;
39: g_price_flag_tbl qp_preq_grp.varchar_type;
40: g_line_id_tbl qp_preq_grp.number_type;
41: g_processing_order_tbl qp_preq_grp.pls_integer_type;

Line 38: g_processed_flag_tbl qp_preq_grp.varchar_type;

34: g_unit_price_tbl qp_preq_grp.number_type;
35: g_percent_price_tbl qp_preq_grp.number_type;
36: g_adjusted_unit_price_tbl qp_preq_grp.number_type;
37: g_upd_adjusted_unit_price_tbl qp_preq_grp.number_type;
38: g_processed_flag_tbl qp_preq_grp.varchar_type;
39: g_price_flag_tbl qp_preq_grp.varchar_type;
40: g_line_id_tbl qp_preq_grp.number_type;
41: g_processing_order_tbl qp_preq_grp.pls_integer_type;
42: g_rounding_factor_tbl qp_preq_grp.pls_integer_type;

Line 39: g_price_flag_tbl qp_preq_grp.varchar_type;

35: g_percent_price_tbl qp_preq_grp.number_type;
36: g_adjusted_unit_price_tbl qp_preq_grp.number_type;
37: g_upd_adjusted_unit_price_tbl qp_preq_grp.number_type;
38: g_processed_flag_tbl qp_preq_grp.varchar_type;
39: g_price_flag_tbl qp_preq_grp.varchar_type;
40: g_line_id_tbl qp_preq_grp.number_type;
41: g_processing_order_tbl qp_preq_grp.pls_integer_type;
42: g_rounding_factor_tbl qp_preq_grp.pls_integer_type;
43: g_rounding_flag_tbl qp_preq_grp.flag_type;

Line 40: g_line_id_tbl qp_preq_grp.number_type;

36: g_adjusted_unit_price_tbl qp_preq_grp.number_type;
37: g_upd_adjusted_unit_price_tbl qp_preq_grp.number_type;
38: g_processed_flag_tbl qp_preq_grp.varchar_type;
39: g_price_flag_tbl qp_preq_grp.varchar_type;
40: g_line_id_tbl qp_preq_grp.number_type;
41: g_processing_order_tbl qp_preq_grp.pls_integer_type;
42: g_rounding_factor_tbl qp_preq_grp.pls_integer_type;
43: g_rounding_flag_tbl qp_preq_grp.flag_type;
44: g_qualifiers_exist_flag_tbl qp_preq_grp.varchar_type;

Line 41: g_processing_order_tbl qp_preq_grp.pls_integer_type;

37: g_upd_adjusted_unit_price_tbl qp_preq_grp.number_type;
38: g_processed_flag_tbl qp_preq_grp.varchar_type;
39: g_price_flag_tbl qp_preq_grp.varchar_type;
40: g_line_id_tbl qp_preq_grp.number_type;
41: g_processing_order_tbl qp_preq_grp.pls_integer_type;
42: g_rounding_factor_tbl qp_preq_grp.pls_integer_type;
43: g_rounding_flag_tbl qp_preq_grp.flag_type;
44: g_qualifiers_exist_flag_tbl qp_preq_grp.varchar_type;
45: g_pricing_attrs_exist_flag_tbl qp_preq_grp.varchar_type;

Line 42: g_rounding_factor_tbl qp_preq_grp.pls_integer_type;

38: g_processed_flag_tbl qp_preq_grp.varchar_type;
39: g_price_flag_tbl qp_preq_grp.varchar_type;
40: g_line_id_tbl qp_preq_grp.number_type;
41: g_processing_order_tbl qp_preq_grp.pls_integer_type;
42: g_rounding_factor_tbl qp_preq_grp.pls_integer_type;
43: g_rounding_flag_tbl qp_preq_grp.flag_type;
44: g_qualifiers_exist_flag_tbl qp_preq_grp.varchar_type;
45: g_pricing_attrs_exist_flag_tbl qp_preq_grp.varchar_type;
46: g_price_list_id_tbl qp_preq_grp.number_type;

Line 43: g_rounding_flag_tbl qp_preq_grp.flag_type;

39: g_price_flag_tbl qp_preq_grp.varchar_type;
40: g_line_id_tbl qp_preq_grp.number_type;
41: g_processing_order_tbl qp_preq_grp.pls_integer_type;
42: g_rounding_factor_tbl qp_preq_grp.pls_integer_type;
43: g_rounding_flag_tbl qp_preq_grp.flag_type;
44: g_qualifiers_exist_flag_tbl qp_preq_grp.varchar_type;
45: g_pricing_attrs_exist_flag_tbl qp_preq_grp.varchar_type;
46: g_price_list_id_tbl qp_preq_grp.number_type;
47: g_pl_validated_flag_tbl qp_preq_grp.varchar_type;

Line 44: g_qualifiers_exist_flag_tbl qp_preq_grp.varchar_type;

40: g_line_id_tbl qp_preq_grp.number_type;
41: g_processing_order_tbl qp_preq_grp.pls_integer_type;
42: g_rounding_factor_tbl qp_preq_grp.pls_integer_type;
43: g_rounding_flag_tbl qp_preq_grp.flag_type;
44: g_qualifiers_exist_flag_tbl qp_preq_grp.varchar_type;
45: g_pricing_attrs_exist_flag_tbl qp_preq_grp.varchar_type;
46: g_price_list_id_tbl qp_preq_grp.number_type;
47: g_pl_validated_flag_tbl qp_preq_grp.varchar_type;
48: g_price_request_code_tbl qp_preq_grp.varchar_type;

Line 45: g_pricing_attrs_exist_flag_tbl qp_preq_grp.varchar_type;

41: g_processing_order_tbl qp_preq_grp.pls_integer_type;
42: g_rounding_factor_tbl qp_preq_grp.pls_integer_type;
43: g_rounding_flag_tbl qp_preq_grp.flag_type;
44: g_qualifiers_exist_flag_tbl qp_preq_grp.varchar_type;
45: g_pricing_attrs_exist_flag_tbl qp_preq_grp.varchar_type;
46: g_price_list_id_tbl qp_preq_grp.number_type;
47: g_pl_validated_flag_tbl qp_preq_grp.varchar_type;
48: g_price_request_code_tbl qp_preq_grp.varchar_type;
49: g_usage_pricing_type_tbl qp_preq_grp.varchar_type;

Line 46: g_price_list_id_tbl qp_preq_grp.number_type;

42: g_rounding_factor_tbl qp_preq_grp.pls_integer_type;
43: g_rounding_flag_tbl qp_preq_grp.flag_type;
44: g_qualifiers_exist_flag_tbl qp_preq_grp.varchar_type;
45: g_pricing_attrs_exist_flag_tbl qp_preq_grp.varchar_type;
46: g_price_list_id_tbl qp_preq_grp.number_type;
47: g_pl_validated_flag_tbl qp_preq_grp.varchar_type;
48: g_price_request_code_tbl qp_preq_grp.varchar_type;
49: g_usage_pricing_type_tbl qp_preq_grp.varchar_type;
50: g_pricing_status_code_tbl qp_preq_grp.varchar_type;

Line 47: g_pl_validated_flag_tbl qp_preq_grp.varchar_type;

43: g_rounding_flag_tbl qp_preq_grp.flag_type;
44: g_qualifiers_exist_flag_tbl qp_preq_grp.varchar_type;
45: g_pricing_attrs_exist_flag_tbl qp_preq_grp.varchar_type;
46: g_price_list_id_tbl qp_preq_grp.number_type;
47: g_pl_validated_flag_tbl qp_preq_grp.varchar_type;
48: g_price_request_code_tbl qp_preq_grp.varchar_type;
49: g_usage_pricing_type_tbl qp_preq_grp.varchar_type;
50: g_pricing_status_code_tbl qp_preq_grp.varchar_type;
51: g_pricing_status_text_tbl qp_preq_grp.varchar_type;

Line 48: g_price_request_code_tbl qp_preq_grp.varchar_type;

44: g_qualifiers_exist_flag_tbl qp_preq_grp.varchar_type;
45: g_pricing_attrs_exist_flag_tbl qp_preq_grp.varchar_type;
46: g_price_list_id_tbl qp_preq_grp.number_type;
47: g_pl_validated_flag_tbl qp_preq_grp.varchar_type;
48: g_price_request_code_tbl qp_preq_grp.varchar_type;
49: g_usage_pricing_type_tbl qp_preq_grp.varchar_type;
50: g_pricing_status_code_tbl qp_preq_grp.varchar_type;
51: g_pricing_status_text_tbl qp_preq_grp.varchar_type;
52: g_line_category_tbl qp_preq_grp.varchar_type;

Line 49: g_usage_pricing_type_tbl qp_preq_grp.varchar_type;

45: g_pricing_attrs_exist_flag_tbl qp_preq_grp.varchar_type;
46: g_price_list_id_tbl qp_preq_grp.number_type;
47: g_pl_validated_flag_tbl qp_preq_grp.varchar_type;
48: g_price_request_code_tbl qp_preq_grp.varchar_type;
49: g_usage_pricing_type_tbl qp_preq_grp.varchar_type;
50: g_pricing_status_code_tbl qp_preq_grp.varchar_type;
51: g_pricing_status_text_tbl qp_preq_grp.varchar_type;
52: g_line_category_tbl qp_preq_grp.varchar_type;
53: g_unit_selling_price_tbl qp_preq_grp.number_type;

Line 50: g_pricing_status_code_tbl qp_preq_grp.varchar_type;

46: g_price_list_id_tbl qp_preq_grp.number_type;
47: g_pl_validated_flag_tbl qp_preq_grp.varchar_type;
48: g_price_request_code_tbl qp_preq_grp.varchar_type;
49: g_usage_pricing_type_tbl qp_preq_grp.varchar_type;
50: g_pricing_status_code_tbl qp_preq_grp.varchar_type;
51: g_pricing_status_text_tbl qp_preq_grp.varchar_type;
52: g_line_category_tbl qp_preq_grp.varchar_type;
53: g_unit_selling_price_tbl qp_preq_grp.number_type;
54: g_unit_list_price_tbl qp_preq_grp.number_type;

Line 51: g_pricing_status_text_tbl qp_preq_grp.varchar_type;

47: g_pl_validated_flag_tbl qp_preq_grp.varchar_type;
48: g_price_request_code_tbl qp_preq_grp.varchar_type;
49: g_usage_pricing_type_tbl qp_preq_grp.varchar_type;
50: g_pricing_status_code_tbl qp_preq_grp.varchar_type;
51: g_pricing_status_text_tbl qp_preq_grp.varchar_type;
52: g_line_category_tbl qp_preq_grp.varchar_type;
53: g_unit_selling_price_tbl qp_preq_grp.number_type;
54: g_unit_list_price_tbl qp_preq_grp.number_type;
55: g_unit_sell_price_per_pqty_tbl qp_preq_grp.number_type;

Line 52: g_line_category_tbl qp_preq_grp.varchar_type;

48: g_price_request_code_tbl qp_preq_grp.varchar_type;
49: g_usage_pricing_type_tbl qp_preq_grp.varchar_type;
50: g_pricing_status_code_tbl qp_preq_grp.varchar_type;
51: g_pricing_status_text_tbl qp_preq_grp.varchar_type;
52: g_line_category_tbl qp_preq_grp.varchar_type;
53: g_unit_selling_price_tbl qp_preq_grp.number_type;
54: g_unit_list_price_tbl qp_preq_grp.number_type;
55: g_unit_sell_price_per_pqty_tbl qp_preq_grp.number_type;
56: g_unit_list_price_per_pqty_tbl qp_preq_grp.number_type;

Line 53: g_unit_selling_price_tbl qp_preq_grp.number_type;

49: g_usage_pricing_type_tbl qp_preq_grp.varchar_type;
50: g_pricing_status_code_tbl qp_preq_grp.varchar_type;
51: g_pricing_status_text_tbl qp_preq_grp.varchar_type;
52: g_line_category_tbl qp_preq_grp.varchar_type;
53: g_unit_selling_price_tbl qp_preq_grp.number_type;
54: g_unit_list_price_tbl qp_preq_grp.number_type;
55: g_unit_sell_price_per_pqty_tbl qp_preq_grp.number_type;
56: g_unit_list_price_per_pqty_tbl qp_preq_grp.number_type;
57: g_pricing_quantity_tbl qp_preq_grp.number_type;

Line 54: g_unit_list_price_tbl qp_preq_grp.number_type;

50: g_pricing_status_code_tbl qp_preq_grp.varchar_type;
51: g_pricing_status_text_tbl qp_preq_grp.varchar_type;
52: g_line_category_tbl qp_preq_grp.varchar_type;
53: g_unit_selling_price_tbl qp_preq_grp.number_type;
54: g_unit_list_price_tbl qp_preq_grp.number_type;
55: g_unit_sell_price_per_pqty_tbl qp_preq_grp.number_type;
56: g_unit_list_price_per_pqty_tbl qp_preq_grp.number_type;
57: g_pricing_quantity_tbl qp_preq_grp.number_type;
58: g_unit_list_percent_tbl qp_preq_grp.number_type;

Line 55: g_unit_sell_price_per_pqty_tbl qp_preq_grp.number_type;

51: g_pricing_status_text_tbl qp_preq_grp.varchar_type;
52: g_line_category_tbl qp_preq_grp.varchar_type;
53: g_unit_selling_price_tbl qp_preq_grp.number_type;
54: g_unit_list_price_tbl qp_preq_grp.number_type;
55: g_unit_sell_price_per_pqty_tbl qp_preq_grp.number_type;
56: g_unit_list_price_per_pqty_tbl qp_preq_grp.number_type;
57: g_pricing_quantity_tbl qp_preq_grp.number_type;
58: g_unit_list_percent_tbl qp_preq_grp.number_type;
59: g_unit_percent_base_price_tbl qp_preq_grp.number_type;

Line 56: g_unit_list_price_per_pqty_tbl qp_preq_grp.number_type;

52: g_line_category_tbl qp_preq_grp.varchar_type;
53: g_unit_selling_price_tbl qp_preq_grp.number_type;
54: g_unit_list_price_tbl qp_preq_grp.number_type;
55: g_unit_sell_price_per_pqty_tbl qp_preq_grp.number_type;
56: g_unit_list_price_per_pqty_tbl qp_preq_grp.number_type;
57: g_pricing_quantity_tbl qp_preq_grp.number_type;
58: g_unit_list_percent_tbl qp_preq_grp.number_type;
59: g_unit_percent_base_price_tbl qp_preq_grp.number_type;
60: g_unit_selling_percent_tbl qp_preq_grp.number_type;

Line 57: g_pricing_quantity_tbl qp_preq_grp.number_type;

53: g_unit_selling_price_tbl qp_preq_grp.number_type;
54: g_unit_list_price_tbl qp_preq_grp.number_type;
55: g_unit_sell_price_per_pqty_tbl qp_preq_grp.number_type;
56: g_unit_list_price_per_pqty_tbl qp_preq_grp.number_type;
57: g_pricing_quantity_tbl qp_preq_grp.number_type;
58: g_unit_list_percent_tbl qp_preq_grp.number_type;
59: g_unit_percent_base_price_tbl qp_preq_grp.number_type;
60: g_unit_selling_percent_tbl qp_preq_grp.number_type;
61:

Line 58: g_unit_list_percent_tbl qp_preq_grp.number_type;

54: g_unit_list_price_tbl qp_preq_grp.number_type;
55: g_unit_sell_price_per_pqty_tbl qp_preq_grp.number_type;
56: g_unit_list_price_per_pqty_tbl qp_preq_grp.number_type;
57: g_pricing_quantity_tbl qp_preq_grp.number_type;
58: g_unit_list_percent_tbl qp_preq_grp.number_type;
59: g_unit_percent_base_price_tbl qp_preq_grp.number_type;
60: g_unit_selling_percent_tbl qp_preq_grp.number_type;
61:
62: FUNCTION get_transfer_price(

Line 59: g_unit_percent_base_price_tbl qp_preq_grp.number_type;

55: g_unit_sell_price_per_pqty_tbl qp_preq_grp.number_type;
56: g_unit_list_price_per_pqty_tbl qp_preq_grp.number_type;
57: g_pricing_quantity_tbl qp_preq_grp.number_type;
58: g_unit_list_percent_tbl qp_preq_grp.number_type;
59: g_unit_percent_base_price_tbl qp_preq_grp.number_type;
60: g_unit_selling_percent_tbl qp_preq_grp.number_type;
61:
62: FUNCTION get_transfer_price(
63: p_transaction_id IN NUMBER

Line 60: g_unit_selling_percent_tbl qp_preq_grp.number_type;

56: g_unit_list_price_per_pqty_tbl qp_preq_grp.number_type;
57: g_pricing_quantity_tbl qp_preq_grp.number_type;
58: g_unit_list_percent_tbl qp_preq_grp.number_type;
59: g_unit_percent_base_price_tbl qp_preq_grp.number_type;
60: g_unit_selling_percent_tbl qp_preq_grp.number_type;
61:
62: FUNCTION get_transfer_price(
63: p_transaction_id IN NUMBER
64: , p_sell_ou_id IN NUMBER

Line 88: l_control_rec qp_preq_grp.control_record_type;

84: l_inventory_item_id NUMBER;
85: l_organization_id NUMBER;
86: l_transaction_uom VARCHAR2(3);
87: l_primary_uom VARCHAR2(3);
88: l_control_rec qp_preq_grp.control_record_type;
89: l_pricing_event VARCHAR2(30) DEFAULT 'ICBATCH';
90: l_request_type_code VARCHAR2(30) DEFAULT 'IC';
91: l_line_index NUMBER := 0;
92: l_return_status_text VARCHAR2(2000);

Line 128: l_version := qp_preq_grp.get_version;

124: IF (l_debug = 1) THEN
125: print_debug('QP trace file is ' || oe_debug_pub.set_debug_mode('FILE'));
126: END IF;
127:
128: l_version := qp_preq_grp.get_version;
129:
130: IF (l_debug = 1) THEN
131: print_debug('QP Version : ' || l_version);
132: END IF;

Line 417: l_control_rec.calculate_flag := qp_preq_grp.g_search_n_calculate;

413: print_debug('MTL_QP_PRICE.get_transfer_price: Initializing control record...');
414: END IF;
415:
416: l_control_rec.pricing_event := l_pricing_event;
417: l_control_rec.calculate_flag := qp_preq_grp.g_search_n_calculate;
418: l_control_rec.temp_table_insert_flag := 'N';
419: l_control_rec.request_type_code := l_request_type_code;
420: l_control_rec.rounding_flag := 'Y';
421: -- Bug 3070474 (porting from bug 3027452) : added the following statement

Line 1898: g_processed_flag_tbl(px_line_index) := qp_preq_grp.g_not_processed;

1894: g_active_date_first_type_tbl(px_line_index) := NULL;
1895: g_active_date_first_tbl(px_line_index) := NULL;
1896: g_active_date_second_tbl(px_line_index) := NULL;
1897: g_active_date_second_type_tbl(px_line_index) := NULL;
1898: g_processed_flag_tbl(px_line_index) := qp_preq_grp.g_not_processed;
1899: g_rounding_flag_tbl(px_line_index) := 'Y';
1900: g_rounding_factor_tbl(px_line_index) := NULL;
1901: g_processing_order_tbl(px_line_index) := NULL;
1902: g_pricing_status_code_tbl(px_line_index) := qp_preq_grp.g_status_unchanged;

Line 1902: g_pricing_status_code_tbl(px_line_index) := qp_preq_grp.g_status_unchanged;

1898: g_processed_flag_tbl(px_line_index) := qp_preq_grp.g_not_processed;
1899: g_rounding_flag_tbl(px_line_index) := 'Y';
1900: g_rounding_factor_tbl(px_line_index) := NULL;
1901: g_processing_order_tbl(px_line_index) := NULL;
1902: g_pricing_status_code_tbl(px_line_index) := qp_preq_grp.g_status_unchanged;
1903: g_pricing_status_text_tbl(px_line_index) := NULL;
1904: g_qualifiers_exist_flag_tbl(px_line_index) := 'N';
1905: g_pricing_attrs_exist_flag_tbl(px_line_index) := 'N';
1906: g_price_list_id_tbl(px_line_index) := NULL;

Line 1952: g_processed_flag_tbl(px_line_index) := qp_preq_grp.g_not_processed;

1948: g_active_date_first_tbl(px_line_index) := NULL;
1949: g_active_date_second_tbl(px_line_index) := NULL;
1950: g_active_date_second_type_tbl(px_line_index) := NULL;
1951: g_price_flag_tbl(px_line_index) := 'Y';
1952: g_processed_flag_tbl(px_line_index) := qp_preq_grp.g_not_processed;
1953: g_rounding_flag_tbl(px_line_index) := 'Y';
1954: g_rounding_factor_tbl(px_line_index) := NULL;
1955: g_processing_order_tbl(px_line_index) := NULL;
1956: g_pricing_status_code_tbl(px_line_index) := qp_preq_grp.g_status_unchanged;

Line 1956: g_pricing_status_code_tbl(px_line_index) := qp_preq_grp.g_status_unchanged;

1952: g_processed_flag_tbl(px_line_index) := qp_preq_grp.g_not_processed;
1953: g_rounding_flag_tbl(px_line_index) := 'Y';
1954: g_rounding_factor_tbl(px_line_index) := NULL;
1955: g_processing_order_tbl(px_line_index) := NULL;
1956: g_pricing_status_code_tbl(px_line_index) := qp_preq_grp.g_status_unchanged;
1957: g_pricing_status_text_tbl(px_line_index) := NULL;
1958: g_qualifiers_exist_flag_tbl(px_line_index) := 'N';
1959: g_pricing_attrs_exist_flag_tbl(px_line_index) := 'N';
1960: g_pl_validated_flag_tbl(px_line_index) := 'N';

Line 2072: qp_preq_grp.insert_lines2(

2068: IF (l_debug = 1) THEN
2069: print_debug('MTL_QP_PRICE.Populate_Temp_Table: Calling QP:Bulk insert routine...');
2070: END IF;
2071:
2072: qp_preq_grp.insert_lines2(
2073: p_line_index => g_line_index_tbl
2074: , p_line_type_code => g_line_type_code_tbl
2075: , p_pricing_effective_date => g_pricing_effective_date_tbl
2076: , p_active_date_first => g_active_date_first_tbl

Line 2112: print_debug('MTL_QP_PRICE.Populate_Temp_Table: QP_PREQ_GRP.INSERT_LINES2 error ');

2108: );
2109:
2110: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
2111: IF (l_debug = 1) THEN
2112: print_debug('MTL_QP_PRICE.Populate_Temp_Table: QP_PREQ_GRP.INSERT_LINES2 error ');
2113: print_debug('MTL_QP_PRICE.Populate_Temp_Table: x_return_status_text=' || l_return_status_text);
2114: END IF;
2115:
2116: x_return_status := l_return_status;

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

2114: END IF;
2115:
2116: x_return_status := l_return_status;
2117: fnd_message.set_name('INV', 'INV_UNHANDLED_ERR');
2118: fnd_message.set_token('ENTITY1', 'QP_PREQ_GRP.INSERT_LINES2');
2119: fnd_message.set_token('ENTITY2', SUBSTR(l_return_status_text, 1, 150));
2120: RAISE fnd_api.g_exc_error;
2121: END IF;
2122:

Line 2236: IF g_pricing_status_code_tbl(i) = qp_preq_grp.g_status_updated THEN

2232: END IF;
2233: END;
2234:
2235: IF g_line_type_code_tbl(i) = 'LINE' THEN
2236: IF g_pricing_status_code_tbl(i) = qp_preq_grp.g_status_updated THEN
2237: IF (l_debug = 1) THEN
2238: print_debug('MTL_QP_PRICE.Populate_Results: Unit_Price=' || g_unit_selling_price_tbl(i));
2239: END IF;
2240: ELSE

Line 2322: g_processed_flag_tbl(px_line_index) := qp_preq_grp.g_not_processed;

2318: g_active_date_first_type_tbl(px_line_index) := NULL;
2319: g_active_date_first_tbl(px_line_index) := NULL;
2320: g_active_date_second_tbl(px_line_index) := NULL;
2321: g_active_date_second_type_tbl(px_line_index) := NULL;
2322: g_processed_flag_tbl(px_line_index) := qp_preq_grp.g_not_processed;
2323: g_rounding_flag_tbl(px_line_index) := 'Y';
2324: g_rounding_factor_tbl(px_line_index) := NULL;
2325: g_processing_order_tbl(px_line_index) := NULL;
2326: g_pricing_status_code_tbl(px_line_index) := qp_preq_grp.g_status_unchanged;

Line 2326: g_pricing_status_code_tbl(px_line_index) := qp_preq_grp.g_status_unchanged;

2322: g_processed_flag_tbl(px_line_index) := qp_preq_grp.g_not_processed;
2323: g_rounding_flag_tbl(px_line_index) := 'Y';
2324: g_rounding_factor_tbl(px_line_index) := NULL;
2325: g_processing_order_tbl(px_line_index) := NULL;
2326: g_pricing_status_code_tbl(px_line_index) := qp_preq_grp.g_status_unchanged;
2327: g_pricing_status_text_tbl(px_line_index) := NULL;
2328: g_qualifiers_exist_flag_tbl(px_line_index) := 'N';
2329: g_pricing_attrs_exist_flag_tbl(px_line_index) := 'N';
2330: g_price_list_id_tbl(px_line_index) := NULL;

Line 2388: g_processed_flag_tbl(px_line_index) := qp_preq_grp.g_not_processed;

2384: g_active_date_first_tbl(px_line_index) := NULL;
2385: g_active_date_second_tbl(px_line_index) := NULL;
2386: g_active_date_second_type_tbl(px_line_index) := NULL;
2387: g_price_flag_tbl(px_line_index) := 'Y';
2388: g_processed_flag_tbl(px_line_index) := qp_preq_grp.g_not_processed;
2389: g_rounding_flag_tbl(px_line_index) := 'Y';
2390: g_rounding_factor_tbl(px_line_index) := NULL;
2391: g_processing_order_tbl(px_line_index) := NULL;
2392: g_pricing_status_code_tbl(px_line_index) := qp_preq_grp.g_status_unchanged;

Line 2392: g_pricing_status_code_tbl(px_line_index) := qp_preq_grp.g_status_unchanged;

2388: g_processed_flag_tbl(px_line_index) := qp_preq_grp.g_not_processed;
2389: g_rounding_flag_tbl(px_line_index) := 'Y';
2390: g_rounding_factor_tbl(px_line_index) := NULL;
2391: g_processing_order_tbl(px_line_index) := NULL;
2392: g_pricing_status_code_tbl(px_line_index) := qp_preq_grp.g_status_unchanged;
2393: g_pricing_status_text_tbl(px_line_index) := NULL;
2394: g_qualifiers_exist_flag_tbl(px_line_index) := 'N';
2395: g_pricing_attrs_exist_flag_tbl(px_line_index) := 'N';
2396: g_pl_validated_flag_tbl(px_line_index) := 'N';

Line 2469: l_control_rec qp_preq_grp.control_record_type;

2465: l_inventory_item_id NUMBER;
2466: l_organization_id NUMBER;
2467: l_transaction_uom VARCHAR2(3);
2468: l_primary_uom VARCHAR2(3);
2469: l_control_rec qp_preq_grp.control_record_type;
2470: l_pricing_event VARCHAR2(30) DEFAULT 'ICBATCH';
2471: l_request_type_code VARCHAR2(30) DEFAULT 'IC';
2472: l_line_index NUMBER := 0;
2473: l_return_status_text VARCHAR2(2000);

Line 2604: l_control_rec.calculate_flag := qp_preq_grp.g_search_n_calculate;

2600: print_debug('MTL_QP_PRICE.get_transfer_price: Initializing control record...');
2601: END IF;
2602:
2603: l_control_rec.pricing_event := l_pricing_event;
2604: l_control_rec.calculate_flag := qp_preq_grp.g_search_n_calculate;
2605: l_control_rec.temp_table_insert_flag := 'N';
2606: l_control_rec.request_type_code := l_request_type_code;
2607: l_control_rec.rounding_flag := 'Y';
2608: -- Bug 3070474 (Porting from Bug 3027452 ): added the following statement