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.FTE_LTL_LOADER dependencies on STRINGARRAY

Line 206: l_effective_dates STRINGARRAY;

202: FUNCTION VERIFY_TARIFF_CARRIER(p_tariff_name IN VARCHAR2,
203: p_carrier_id IN NUMBER,
204: x_error_msg OUT NOCOPY VARCHAR2) RETURN BOOLEAN IS
205: l_carrier_ids NUMBER_TAB;
206: l_effective_dates STRINGARRAY;
207: l_expiry_dates STRINGARRAY;
208:
209: l_module_name CONSTANT VARCHAR2(100) := 'FTE.PLSQL.' || G_PKG_NAME || '.VERIFY_TARIFF_CARRIER';
210:

Line 207: l_expiry_dates STRINGARRAY;

203: p_carrier_id IN NUMBER,
204: x_error_msg OUT NOCOPY VARCHAR2) RETURN BOOLEAN IS
205: l_carrier_ids NUMBER_TAB;
206: l_effective_dates STRINGARRAY;
207: l_expiry_dates STRINGARRAY;
208:
209: l_module_name CONSTANT VARCHAR2(100) := 'FTE.PLSQL.' || G_PKG_NAME || '.VERIFY_TARIFF_CARRIER';
210:
211: BEGIN

Line 922: l_effective_dates STRINGARRAY;

918: x_status OUT NOCOPY NUMBER,
919: x_error_msg OUT NOCOPY VARCHAR2) IS
920:
921: l_lane_ids NUMBER_TAB;
922: l_effective_dates STRINGARRAY;
923: l_expiry_dates STRINGARRAY;
924:
925: l_module_name CONSTANT VARCHAR2(100) := 'FTE.PLSQL.' || G_PKG_NAME || '.OBSOLETE_PREVIOUS_LOAD';
926:

Line 923: l_expiry_dates STRINGARRAY;

919: x_error_msg OUT NOCOPY VARCHAR2) IS
920:
921: l_lane_ids NUMBER_TAB;
922: l_effective_dates STRINGARRAY;
923: l_expiry_dates STRINGARRAY;
924:
925: l_module_name CONSTANT VARCHAR2(100) := 'FTE.PLSQL.' || G_PKG_NAME || '.OBSOLETE_PREVIOUS_LOAD';
926:
927: BEGIN

Line 1059: l_effective_dates STRINGARRAY;

1055: p_load_id IN NUMBER,
1056: x_status OUT NOCOPY NUMBER,
1057: x_error_msg OUT NOCOPY VARCHAR2) IS
1058:
1059: l_effective_dates STRINGARRAY;
1060: l_start_dates STRINGARRAY;
1061:
1062: l_list_header_ids NUMBER_TAB;
1063: l_rate_names STRINGARRAY;

Line 1060: l_start_dates STRINGARRAY;

1056: x_status OUT NOCOPY NUMBER,
1057: x_error_msg OUT NOCOPY VARCHAR2) IS
1058:
1059: l_effective_dates STRINGARRAY;
1060: l_start_dates STRINGARRAY;
1061:
1062: l_list_header_ids NUMBER_TAB;
1063: l_rate_names STRINGARRAY;
1064: l_descriptions VAR_ARR4000;

Line 1063: l_rate_names STRINGARRAY;

1059: l_effective_dates STRINGARRAY;
1060: l_start_dates STRINGARRAY;
1061:
1062: l_list_header_ids NUMBER_TAB;
1063: l_rate_names STRINGARRAY;
1064: l_descriptions VAR_ARR4000;
1065:
1066: l_currency_codes STRINGARRAY;
1067: l_existing_carriers NUMBER_TAB;

Line 1066: l_currency_codes STRINGARRAY;

1062: l_list_header_ids NUMBER_TAB;
1063: l_rate_names STRINGARRAY;
1064: l_descriptions VAR_ARR4000;
1065:
1066: l_currency_codes STRINGARRAY;
1067: l_existing_carriers NUMBER_TAB;
1068: l_max_groups NUMBER_TAB;
1069:
1070: l_process_id NUMBER;

Line 1614: v_classes STRINGARRAY;

1610: v_description VARCHAR2(200) := 'LTL RATE CHART ' || p_chart_name;
1611: v_status NUMBER;
1612:
1613: v_class_value VARCHAR2(20);
1614: v_classes STRINGARRAY;
1615:
1616: v_break_numchars CONSTANT NUMBER := 6;
1617: v_break_charge VARCHAR2(10);
1618:

Line 1622: v_validate_keys STRINGARRAY;

1618:
1619: v_break_charges t_breakList := t_breakList(); -- collection holding the list of prices
1620: v_price_charge_count NUMBER := 0;
1621:
1622: v_validate_keys STRINGARRAY;
1623: v_validate_data STRINGARRAY;
1624:
1625: v_break_max_vals t_break_max_vals := t_break_max_vals(Fnd_Number.Canonical_To_Number('499.999999999999999'), --15dp
1626: Fnd_Number.Canonical_To_Number('999.999999999999999'),

Line 1623: v_validate_data STRINGARRAY;

1619: v_break_charges t_breakList := t_breakList(); -- collection holding the list of prices
1620: v_price_charge_count NUMBER := 0;
1621:
1622: v_validate_keys STRINGARRAY;
1623: v_validate_data STRINGARRAY;
1624:
1625: v_break_max_vals t_break_max_vals := t_break_max_vals(Fnd_Number.Canonical_To_Number('499.999999999999999'), --15dp
1626: Fnd_Number.Canonical_To_Number('999.999999999999999'),
1627: Fnd_Number.Canonical_To_Number('1999.999999999999999'),

Line 2010: p_effective_dates IN STRINGARRAY,

2006:
2007: PROCEDURE CREATE_LANE_DATA (p_origin_id IN NUMBER,
2008: p_destination_id IN NUMBER,
2009: p_carrier_ids IN NUMBER_TAB,
2010: p_effective_dates IN STRINGARRAY,
2011: p_expiry_dates IN STRINGARRAY,
2012: p_tariff_name IN VARCHAR2,
2013: p_lane_type IN VARCHAR2,
2014: p_category_ids IN NUMBER_TAB,

Line 2011: p_expiry_dates IN STRINGARRAY,

2007: PROCEDURE CREATE_LANE_DATA (p_origin_id IN NUMBER,
2008: p_destination_id IN NUMBER,
2009: p_carrier_ids IN NUMBER_TAB,
2010: p_effective_dates IN STRINGARRAY,
2011: p_expiry_dates IN STRINGARRAY,
2012: p_tariff_name IN VARCHAR2,
2013: p_lane_type IN VARCHAR2,
2014: p_category_ids IN NUMBER_TAB,
2015: p_list_header_id IN NUMBER,

Line 2024: l_deficit_wt_breaks STRINGARRAY;

2020: l_fc_value VARCHAR2(10);
2021: l_category_ids NUMBER_TAB;
2022: l_catg_id NUMBER;
2023: l_lane_id NUMBER;
2024: l_deficit_wt_breaks STRINGARRAY;
2025: l_num_lanes NUMBER;
2026:
2027: l_module_name CONSTANT VARCHAR2(100) := 'FTE.PLSQL.' || G_PKG_NAME || '.CREATE_LANE_DATA';
2028:

Line 2096: l_deficit_wt_breaks := STRINGARRAY('0', '500', '1000', '2000', '5000', '10000', '20000', '30000', '40000');

2092:
2093: -- FTE_PRC_PARAMETERS
2094:
2095: -- Deficit Weight Breaks
2096: l_deficit_wt_breaks := STRINGARRAY('0', '500', '1000', '2000', '5000', '10000', '20000', '30000', '40000');
2097:
2098: FOR n IN 1..l_deficit_wt_breaks.COUNT LOOP
2099: PRC_VALUE_FROM(prc_value_from.COUNT+1) := l_deficit_wt_breaks(n);
2100: PRC_PARAMETER_ID(prc_parameter_id.COUNT+1) := G_DEF_WT_BREAK_ID;

Line 2174: p_effective_dates IN STRINGARRAY,

2170:
2171: PROCEDURE CREATE_LANES (p_load_id IN NUMBER,
2172: p_tariff_name IN VARCHAR2,
2173: p_carrier_ids IN NUMBER_TAB,
2174: p_effective_dates IN STRINGARRAY,
2175: p_expiry_dates IN STRINGARRAY,
2176: x_status OUT NOCOPY VARCHAR2,
2177: x_error_msg OUT NOCOPY VARCHAR2) IS
2178:

Line 2175: p_expiry_dates IN STRINGARRAY,

2171: PROCEDURE CREATE_LANES (p_load_id IN NUMBER,
2172: p_tariff_name IN VARCHAR2,
2173: p_carrier_ids IN NUMBER_TAB,
2174: p_effective_dates IN STRINGARRAY,
2175: p_expiry_dates IN STRINGARRAY,
2176: x_status OUT NOCOPY VARCHAR2,
2177: x_error_msg OUT NOCOPY VARCHAR2) IS
2178:
2179:

Line 2181: l_lane_commodities STRINGARRAY;

2177: x_error_msg OUT NOCOPY VARCHAR2) IS
2178:
2179:
2180: l_fc_class_code VARCHAR2(2);
2181: l_lane_commodities STRINGARRAY;
2182: l_lanes_temp lanes_temp_record;
2183: l_zones_temp zones_temp_record;
2184: l_list_header_id NUMBER;
2185: c_current_fetch NUMBER;

Line 2363: p_matching_zones IN STRINGARRAY,

2359: -- x_error_msg, the error message indicating the cause and detailing the error occured.
2360: --____________________________________________________________________________________--
2361:
2362: PROCEDURE FIND_IDENTICAL_ZONE(p_zone_name IN VARCHAR2,
2363: p_matching_zones IN STRINGARRAY,
2364: p_origin_flag IN BOOLEAN,
2365: x_identical_zone OUT NOCOPY VARCHAR2,
2366: x_zone_id OUT NOCOPY NUMBER,
2367: x_status OUT NOCOPY VARCHAR2,

Line 2373: l_zone_names STRINGARRAY;

2369:
2370: j NUMBER;
2371: l_row_numbers NUMBER_TAB;
2372: l_zone_ids NUMBER_TAB;
2373: l_zone_names STRINGARRAY;
2374: l_postal_strings var_arr4000;
2375: l_mismatch BOOLEAN;
2376: l_country_codes STRINGARRAY;
2377: l_new_country_code VARCHAR2(10);

Line 2376: l_country_codes STRINGARRAY;

2372: l_zone_ids NUMBER_TAB;
2373: l_zone_names STRINGARRAY;
2374: l_postal_strings var_arr4000;
2375: l_mismatch BOOLEAN;
2376: l_country_codes STRINGARRAY;
2377: l_new_country_code VARCHAR2(10);
2378:
2379: CURSOR GET_ZONE_DETAILS( p_zone1 IN VARCHAR2, p_zone2 IN VARCHAR2) IS
2380: SELECT

Line 2685: l_dest_names STRINGARRAY;

2681: l_zone_name VARCHAR2(125);
2682: l_rate_name VARCHAR2(125);
2683: l_dest_low VARCHAR2(15);
2684: l_dest_high VARCHAR2(15);
2685: l_dest_names STRINGARRAY;
2686: l_rate_names STRINGARRAY;
2687: l_min_charges STRINGARRAY;
2688: l_hash_value NUMBER;
2689: l_min_charge_match BOOLEAN := FALSE;

Line 2686: l_rate_names STRINGARRAY;

2682: l_rate_name VARCHAR2(125);
2683: l_dest_low VARCHAR2(15);
2684: l_dest_high VARCHAR2(15);
2685: l_dest_names STRINGARRAY;
2686: l_rate_names STRINGARRAY;
2687: l_min_charges STRINGARRAY;
2688: l_hash_value NUMBER;
2689: l_min_charge_match BOOLEAN := FALSE;
2690: l_rate_chart_match VARCHAR2(1) := 'N';

Line 2687: l_min_charges STRINGARRAY;

2683: l_dest_low VARCHAR2(15);
2684: l_dest_high VARCHAR2(15);
2685: l_dest_names STRINGARRAY;
2686: l_rate_names STRINGARRAY;
2687: l_min_charges STRINGARRAY;
2688: l_hash_value NUMBER;
2689: l_min_charge_match BOOLEAN := FALSE;
2690: l_rate_chart_match VARCHAR2(1) := 'N';
2691: l_counter NUMBER;

Line 3194: l_matching_zones STRINGARRAY;

3190: x_error_msg OUT NOCOPY VARCHAR2) IS
3191:
3192: l_identical_zone VARCHAR2(40);
3193: l_zone_id NUMBER;
3194: l_matching_zones STRINGARRAY;
3195: l_sum_row_number NUMBER;
3196: l_max_row_number NUMBER;
3197: l_sum_hash_value NUMBER;
3198: l_num_zone_matches NUMBER;

Line 3823: p_effective_dates IN STRINGARRAY,

3819:
3820: PROCEDURE LOAD_TEMP_TABLES (p_load_id IN NUMBER,
3821: p_tariff_name IN VARCHAR2,
3822: p_carrier_ids IN NUMBER_TAB,
3823: p_effective_dates IN STRINGARRAY,
3824: p_expiry_dates IN STRINGARRAY,
3825: x_status OUT NOCOPY VARCHAR2,
3826: x_error_msg OUT NOCOPY VARCHAR2) IS
3827:

Line 3824: p_expiry_dates IN STRINGARRAY,

3820: PROCEDURE LOAD_TEMP_TABLES (p_load_id IN NUMBER,
3821: p_tariff_name IN VARCHAR2,
3822: p_carrier_ids IN NUMBER_TAB,
3823: p_effective_dates IN STRINGARRAY,
3824: p_expiry_dates IN STRINGARRAY,
3825: x_status OUT NOCOPY VARCHAR2,
3826: x_error_msg OUT NOCOPY VARCHAR2) IS
3827:
3828: l_phase NUMBER := 1;

Line 3839: t_varchar2_tab STRINGARRAY;

3835: l_number_of_loads NUMBER;
3836: l_origin_name VARCHAR2(125);
3837: l_counter NUMBER;
3838: l_debug_on NUMBER;
3839: t_varchar2_tab STRINGARRAY;
3840:
3841: l_module_name CONSTANT VARCHAR2(100) := 'FTE.PLSQL.' || G_PKG_NAME || '.LOAD_TEMP_TABLES';
3842:
3843: BEGIN

Line 4194: l_table STRINGARRAY;

4190: x_status OUT NOCOPY VARCHAR2,
4191: x_error_msg OUT NOCOPY VARCHAR2) IS
4192:
4193: l_num NUMBER;
4194: l_table STRINGARRAY;
4195:
4196: l_module_name CONSTANT VARCHAR2(100) := 'FTE.PLSQL.' || G_PKG_NAME || '.PROCESS_LTL_LINE';
4197:
4198: BEGIN

Line 4381: l_lines STRINGARRAY;

4377: l_amount BINARY_INTEGER := 12000;
4378: l_position INTEGER := 1;
4379: data_buffer VARCHAR2(32000);
4380: temp_buffer VARCHAR2(32000);
4381: l_lines STRINGARRAY;
4382:
4383: l_module_name CONSTANT VARCHAR2(100) := 'FTE.PLSQL.' || G_PKG_NAME || '.READ_LTL_FILE_FROM_TABLE';
4384:
4385: BEGIN

Line 4694: l_rc_start_dates STRINGARRAY;

4690: l_scac VARCHAR2(30);
4691: l_origin VARCHAR2(10);
4692: l_origin_low VARCHAR2(10);
4693: l_dest_low VARCHAR2(10);
4694: l_rc_start_dates STRINGARRAY;
4695:
4696: -- New carriers being added
4697: l_add_carriers NUMBER_TAB;
4698: l_add_start_dates STRINGARRAY;

Line 4698: l_add_start_dates STRINGARRAY;

4694: l_rc_start_dates STRINGARRAY;
4695:
4696: -- New carriers being added
4697: l_add_carriers NUMBER_TAB;
4698: l_add_start_dates STRINGARRAY;
4699: l_add_end_dates STRINGARRAY;
4700:
4701: -- Carriers being modified
4702: l_modified_carriers NUMBER_TAB;

Line 4699: l_add_end_dates STRINGARRAY;

4695:
4696: -- New carriers being added
4697: l_add_carriers NUMBER_TAB;
4698: l_add_start_dates STRINGARRAY;
4699: l_add_end_dates STRINGARRAY;
4700:
4701: -- Carriers being modified
4702: l_modified_carriers NUMBER_TAB;
4703: l_mod_start_dates STRINGARRAY;

Line 4703: l_mod_start_dates STRINGARRAY;

4699: l_add_end_dates STRINGARRAY;
4700:
4701: -- Carriers being modified
4702: l_modified_carriers NUMBER_TAB;
4703: l_mod_start_dates STRINGARRAY;
4704: l_mod_end_dates STRINGARRAY;
4705: l_current_fetch NUMBER;
4706: l_fetch_total NUMBER;
4707:

Line 4704: l_mod_end_dates STRINGARRAY;

4700:
4701: -- Carriers being modified
4702: l_modified_carriers NUMBER_TAB;
4703: l_mod_start_dates STRINGARRAY;
4704: l_mod_end_dates STRINGARRAY;
4705: l_current_fetch NUMBER;
4706: l_fetch_total NUMBER;
4707:
4708: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.UPDATE_TARIFF_LANES';

Line 5057: l_effective_dates STRINGARRAY;

5053:
5054: l_source VARCHAR2(30);
5055: l_load_number NUMBER;
5056: l_carrier_ids Number_Tab;
5057: l_effective_dates STRINGARRAY;
5058: l_expiry_dates STRINGARRAY;
5059:
5060: l_module_name CONSTANT VARCHAR2(100) := 'FTE.PLSQL.' || G_PKG_NAME || '.UPLOAD_LTL_RATES';
5061:

Line 5058: l_expiry_dates STRINGARRAY;

5054: l_source VARCHAR2(30);
5055: l_load_number NUMBER;
5056: l_carrier_ids Number_Tab;
5057: l_effective_dates STRINGARRAY;
5058: l_expiry_dates STRINGARRAY;
5059:
5060: l_module_name CONSTANT VARCHAR2(100) := 'FTE.PLSQL.' || G_PKG_NAME || '.UPLOAD_LTL_RATES';
5061:
5062: BEGIN