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 386: l_control_rec.calculate_flag := qp_preq_grp.g_search_n_calculate;

382: print_debug('MTL_QP_PRICE.get_transfer_price: Initializing control record...');
383: END IF;
384:
385: l_control_rec.pricing_event := l_pricing_event;
386: l_control_rec.calculate_flag := qp_preq_grp.g_search_n_calculate;
387: l_control_rec.temp_table_insert_flag := 'N';
388: l_control_rec.request_type_code := l_request_type_code;
389: l_control_rec.rounding_flag := 'Y';
390: -- Bug 3070474 (porting from bug 3027452) : added the following statement

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

1852: g_active_date_first_type_tbl(px_line_index) := NULL;
1853: g_active_date_first_tbl(px_line_index) := NULL;
1854: g_active_date_second_tbl(px_line_index) := NULL;
1855: g_active_date_second_type_tbl(px_line_index) := NULL;
1856: g_processed_flag_tbl(px_line_index) := qp_preq_grp.g_not_processed;
1857: g_rounding_flag_tbl(px_line_index) := 'Y';
1858: g_rounding_factor_tbl(px_line_index) := NULL;
1859: g_processing_order_tbl(px_line_index) := NULL;
1860: g_pricing_status_code_tbl(px_line_index) := qp_preq_grp.g_status_unchanged;

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

1856: g_processed_flag_tbl(px_line_index) := qp_preq_grp.g_not_processed;
1857: g_rounding_flag_tbl(px_line_index) := 'Y';
1858: g_rounding_factor_tbl(px_line_index) := NULL;
1859: g_processing_order_tbl(px_line_index) := NULL;
1860: g_pricing_status_code_tbl(px_line_index) := qp_preq_grp.g_status_unchanged;
1861: g_pricing_status_text_tbl(px_line_index) := NULL;
1862: g_qualifiers_exist_flag_tbl(px_line_index) := 'N';
1863: g_pricing_attrs_exist_flag_tbl(px_line_index) := 'N';
1864: g_price_list_id_tbl(px_line_index) := NULL;

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

1901: g_active_date_first_tbl(px_line_index) := NULL;
1902: g_active_date_second_tbl(px_line_index) := NULL;
1903: g_active_date_second_type_tbl(px_line_index) := NULL;
1904: g_price_flag_tbl(px_line_index) := 'Y';
1905: g_processed_flag_tbl(px_line_index) := qp_preq_grp.g_not_processed;
1906: g_rounding_flag_tbl(px_line_index) := 'Y';
1907: g_rounding_factor_tbl(px_line_index) := NULL;
1908: g_processing_order_tbl(px_line_index) := NULL;
1909: g_pricing_status_code_tbl(px_line_index) := qp_preq_grp.g_status_unchanged;

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

1905: g_processed_flag_tbl(px_line_index) := qp_preq_grp.g_not_processed;
1906: g_rounding_flag_tbl(px_line_index) := 'Y';
1907: g_rounding_factor_tbl(px_line_index) := NULL;
1908: g_processing_order_tbl(px_line_index) := NULL;
1909: g_pricing_status_code_tbl(px_line_index) := qp_preq_grp.g_status_unchanged;
1910: g_pricing_status_text_tbl(px_line_index) := NULL;
1911: g_qualifiers_exist_flag_tbl(px_line_index) := 'N';
1912: g_pricing_attrs_exist_flag_tbl(px_line_index) := 'N';
1913: g_pl_validated_flag_tbl(px_line_index) := 'N';

Line 2005: qp_preq_grp.insert_lines2(

2001: IF (l_debug = 1) THEN
2002: print_debug('MTL_QP_PRICE.Populate_Temp_Table: Calling QP:Bulk insert routine...');
2003: END IF;
2004:
2005: qp_preq_grp.insert_lines2(
2006: p_line_index => g_line_index_tbl
2007: , p_line_type_code => g_line_type_code_tbl
2008: , p_pricing_effective_date => g_pricing_effective_date_tbl
2009: , p_active_date_first => g_active_date_first_tbl

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

2041: );
2042:
2043: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
2044: IF (l_debug = 1) THEN
2045: print_debug('MTL_QP_PRICE.Populate_Temp_Table: QP_PREQ_GRP.INSERT_LINES2 error ');
2046: print_debug('MTL_QP_PRICE.Populate_Temp_Table: x_return_status_text=' || l_return_status_text);
2047: END IF;
2048:
2049: x_return_status := l_return_status;

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

2047: END IF;
2048:
2049: x_return_status := l_return_status;
2050: fnd_message.set_name('INV', 'INV_UNHANDLED_ERR');
2051: fnd_message.set_token('ENTITY1', 'QP_PREQ_GRP.INSERT_LINES2');
2052: fnd_message.set_token('ENTITY2', SUBSTR(l_return_status_text, 1, 150));
2053: RAISE fnd_api.g_exc_error;
2054: END IF;
2055:

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

2165: END IF;
2166: END;
2167:
2168: IF g_line_type_code_tbl(i) = 'LINE' THEN
2169: IF g_pricing_status_code_tbl(i) = qp_preq_grp.g_status_updated THEN
2170: IF (l_debug = 1) THEN
2171: print_debug('MTL_QP_PRICE.Populate_Results: Unit_Price=' || g_unit_selling_price_tbl(i));
2172: END IF;
2173: ELSE

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

2251: g_active_date_first_type_tbl(px_line_index) := NULL;
2252: g_active_date_first_tbl(px_line_index) := NULL;
2253: g_active_date_second_tbl(px_line_index) := NULL;
2254: g_active_date_second_type_tbl(px_line_index) := NULL;
2255: g_processed_flag_tbl(px_line_index) := qp_preq_grp.g_not_processed;
2256: g_rounding_flag_tbl(px_line_index) := 'Y';
2257: g_rounding_factor_tbl(px_line_index) := NULL;
2258: g_processing_order_tbl(px_line_index) := NULL;
2259: g_pricing_status_code_tbl(px_line_index) := qp_preq_grp.g_status_unchanged;

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

2255: g_processed_flag_tbl(px_line_index) := qp_preq_grp.g_not_processed;
2256: g_rounding_flag_tbl(px_line_index) := 'Y';
2257: g_rounding_factor_tbl(px_line_index) := NULL;
2258: g_processing_order_tbl(px_line_index) := NULL;
2259: g_pricing_status_code_tbl(px_line_index) := qp_preq_grp.g_status_unchanged;
2260: g_pricing_status_text_tbl(px_line_index) := NULL;
2261: g_qualifiers_exist_flag_tbl(px_line_index) := 'N';
2262: g_pricing_attrs_exist_flag_tbl(px_line_index) := 'N';
2263: g_price_list_id_tbl(px_line_index) := NULL;

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

2313: g_active_date_first_tbl(px_line_index) := NULL;
2314: g_active_date_second_tbl(px_line_index) := NULL;
2315: g_active_date_second_type_tbl(px_line_index) := NULL;
2316: g_price_flag_tbl(px_line_index) := 'Y';
2317: g_processed_flag_tbl(px_line_index) := qp_preq_grp.g_not_processed;
2318: g_rounding_flag_tbl(px_line_index) := 'Y';
2319: g_rounding_factor_tbl(px_line_index) := NULL;
2320: g_processing_order_tbl(px_line_index) := NULL;
2321: g_pricing_status_code_tbl(px_line_index) := qp_preq_grp.g_status_unchanged;

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

2317: g_processed_flag_tbl(px_line_index) := qp_preq_grp.g_not_processed;
2318: g_rounding_flag_tbl(px_line_index) := 'Y';
2319: g_rounding_factor_tbl(px_line_index) := NULL;
2320: g_processing_order_tbl(px_line_index) := NULL;
2321: g_pricing_status_code_tbl(px_line_index) := qp_preq_grp.g_status_unchanged;
2322: g_pricing_status_text_tbl(px_line_index) := NULL;
2323: g_qualifiers_exist_flag_tbl(px_line_index) := 'N';
2324: g_pricing_attrs_exist_flag_tbl(px_line_index) := 'N';
2325: g_pl_validated_flag_tbl(px_line_index) := 'N';

Line 2377: l_control_rec qp_preq_grp.control_record_type;

2373: l_inventory_item_id NUMBER;
2374: l_organization_id NUMBER;
2375: l_transaction_uom VARCHAR2(3);
2376: l_primary_uom VARCHAR2(3);
2377: l_control_rec qp_preq_grp.control_record_type;
2378: l_pricing_event VARCHAR2(30) DEFAULT 'ICBATCH';
2379: l_request_type_code VARCHAR2(30) DEFAULT 'IC';
2380: l_line_index NUMBER := 0;
2381: l_return_status_text VARCHAR2(2000);

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

2499: print_debug('MTL_QP_PRICE.get_transfer_price: Initializing control record...');
2500: END IF;
2501:
2502: l_control_rec.pricing_event := l_pricing_event;
2503: l_control_rec.calculate_flag := qp_preq_grp.g_search_n_calculate;
2504: l_control_rec.temp_table_insert_flag := 'N';
2505: l_control_rec.request_type_code := l_request_type_code;
2506: l_control_rec.rounding_flag := 'Y';
2507: -- Bug 3070474 (Porting from Bug 3027452 ): added the following statement