DBA Data[Home] [Help]

APPS.FTE_FREIGHT_PRICING_SPECIAL dependencies on FTE_PRC_PARAMETERS

Line 10: parameter_instance_id fte_prc_parameters.parameter_instance_id%TYPE,

6: g_package_name CONSTANT VARCHAR2(100) := 'FTE_FREIGHT_PRICING_SPECIAL';
7:
8: -- parameters rec
9: TYPE lane_parameter_rec_type IS RECORD (
10: parameter_instance_id fte_prc_parameters.parameter_instance_id%TYPE,
11: lane_id fte_prc_parameters.parameter_instance_id%TYPE,
12: lane_function fte_prc_parameter_defaults.lane_function%TYPE,
13: parameter_sub_type fte_prc_parameter_defaults.parameter_sub_type%TYPE,
14: parameter_name fte_prc_parameter_defaults.parameter_name%TYPE,

Line 11: lane_id fte_prc_parameters.parameter_instance_id%TYPE,

7:
8: -- parameters rec
9: TYPE lane_parameter_rec_type IS RECORD (
10: parameter_instance_id fte_prc_parameters.parameter_instance_id%TYPE,
11: lane_id fte_prc_parameters.parameter_instance_id%TYPE,
12: lane_function fte_prc_parameter_defaults.lane_function%TYPE,
13: parameter_sub_type fte_prc_parameter_defaults.parameter_sub_type%TYPE,
14: parameter_name fte_prc_parameter_defaults.parameter_name%TYPE,
15: value_from fte_prc_parameters.value_from%TYPE,

Line 15: value_from fte_prc_parameters.value_from%TYPE,

11: lane_id fte_prc_parameters.parameter_instance_id%TYPE,
12: lane_function fte_prc_parameter_defaults.lane_function%TYPE,
13: parameter_sub_type fte_prc_parameter_defaults.parameter_sub_type%TYPE,
14: parameter_name fte_prc_parameter_defaults.parameter_name%TYPE,
15: value_from fte_prc_parameters.value_from%TYPE,
16: value_to fte_prc_parameters.value_to%TYPE,
17: uom_class fte_prc_parameters.uom_class%TYPE, --- do we need this?
18: uom_code fte_prc_parameters.uom_code%TYPE,
19: currency_code fte_prc_parameters.currency_code%TYPE

Line 16: value_to fte_prc_parameters.value_to%TYPE,

12: lane_function fte_prc_parameter_defaults.lane_function%TYPE,
13: parameter_sub_type fte_prc_parameter_defaults.parameter_sub_type%TYPE,
14: parameter_name fte_prc_parameter_defaults.parameter_name%TYPE,
15: value_from fte_prc_parameters.value_from%TYPE,
16: value_to fte_prc_parameters.value_to%TYPE,
17: uom_class fte_prc_parameters.uom_class%TYPE, --- do we need this?
18: uom_code fte_prc_parameters.uom_code%TYPE,
19: currency_code fte_prc_parameters.currency_code%TYPE
20: );

Line 17: uom_class fte_prc_parameters.uom_class%TYPE, --- do we need this?

13: parameter_sub_type fte_prc_parameter_defaults.parameter_sub_type%TYPE,
14: parameter_name fte_prc_parameter_defaults.parameter_name%TYPE,
15: value_from fte_prc_parameters.value_from%TYPE,
16: value_to fte_prc_parameters.value_to%TYPE,
17: uom_class fte_prc_parameters.uom_class%TYPE, --- do we need this?
18: uom_code fte_prc_parameters.uom_code%TYPE,
19: currency_code fte_prc_parameters.currency_code%TYPE
20: );
21:

Line 18: uom_code fte_prc_parameters.uom_code%TYPE,

14: parameter_name fte_prc_parameter_defaults.parameter_name%TYPE,
15: value_from fte_prc_parameters.value_from%TYPE,
16: value_to fte_prc_parameters.value_to%TYPE,
17: uom_class fte_prc_parameters.uom_class%TYPE, --- do we need this?
18: uom_code fte_prc_parameters.uom_code%TYPE,
19: currency_code fte_prc_parameters.currency_code%TYPE
20: );
21:
22: -- use this table to cache parameters for a lane

Line 19: currency_code fte_prc_parameters.currency_code%TYPE

15: value_from fte_prc_parameters.value_from%TYPE,
16: value_to fte_prc_parameters.value_to%TYPE,
17: uom_class fte_prc_parameters.uom_class%TYPE, --- do we need this?
18: uom_code fte_prc_parameters.uom_code%TYPE,
19: currency_code fte_prc_parameters.currency_code%TYPE
20: );
21:
22: -- use this table to cache parameters for a lane
23: TYPE lane_parameter_tab_type IS TABLE OF lane_parameter_rec_type INDEX BY BINARY_INTEGER;