DBA Data[Home] [Help]

APPS.FTE_LTL_LOADER dependencies on FTE_PRC_PARAMETERS

Line 91: TYPE PRC_VALUE_FROM_TAB IS TABLE OF FTE_PRC_PARAMETERS.VALUE_FROM%TYPE INDEX BY BINARY_INTEGER;

87: LN_TARIFF_NAME LN_TARIFF_NAME_TAB;
88: LN_START_DATE var_arr40_index;
89: LN_END_DATE var_arr40_index;
90:
91: TYPE PRC_VALUE_FROM_TAB IS TABLE OF FTE_PRC_PARAMETERS.VALUE_FROM%TYPE INDEX BY BINARY_INTEGER;
92: TYPE PRC_PARAMETER_ID_TAB IS TABLE OF FTE_PRC_PARAMETERS.PARAMETER_ID%TYPE INDEX BY BINARY_INTEGER;
93:
94: PRC_VALUE_FROM PRC_VALUE_FROM_TAB;
95: PRC_PARAMETER_ID PRC_PARAMETER_ID_TAB;

Line 92: TYPE PRC_PARAMETER_ID_TAB IS TABLE OF FTE_PRC_PARAMETERS.PARAMETER_ID%TYPE INDEX BY BINARY_INTEGER;

88: LN_START_DATE var_arr40_index;
89: LN_END_DATE var_arr40_index;
90:
91: TYPE PRC_VALUE_FROM_TAB IS TABLE OF FTE_PRC_PARAMETERS.VALUE_FROM%TYPE INDEX BY BINARY_INTEGER;
92: TYPE PRC_PARAMETER_ID_TAB IS TABLE OF FTE_PRC_PARAMETERS.PARAMETER_ID%TYPE INDEX BY BINARY_INTEGER;
93:
94: PRC_VALUE_FROM PRC_VALUE_FROM_TAB;
95: PRC_PARAMETER_ID PRC_PARAMETER_ID_TAB;
96: PRC_LANE_ID NUMBER_TAB;

Line 116: TYPE min_charge_tab IS TABLE OF fte_prc_parameters.value_from%TYPE INDEX BY BINARY_INTEGER;

112:
113: TYPE lane_number_tab IS TABLE OF fte_lanes.lane_number%TYPE INDEX BY BINARY_INTEGER;
114: TYPE zone_tab IS TABLE OF wsh_regions_tl.zone%TYPE INDEX BY BINARY_INTEGER;
115: TYPE carrier_name_tab IS TABLE OF hz_parties.party_name%TYPE INDEX BY BINARY_INTEGER;
116: TYPE min_charge_tab IS TABLE OF fte_prc_parameters.value_from%TYPE INDEX BY BINARY_INTEGER;
117: TYPE ZoneNamesTab IS TABLE OF fte_interface_zones.zone_name%TYPE INDEX BY BINARY_INTEGER;
118: TYPE RateChartNamesTab IS TABLE OF qp_list_headers_tl.name%TYPE INDEX BY BINARY_INTEGER;
119:
120: TYPE LTL_REPORT_HEADER IS RECORD(StartDate VARCHAR2(100),