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_VALIDATION_PKG dependencies on STRINGARRAY

Line 7: TL_BASE_RATES CONSTANT STRINGARRAY := STRINGARRAY('ACTION','CARRIER_NAME',

3:
4:
5: /***********************************************************************************/
6:
7: TL_BASE_RATES CONSTANT STRINGARRAY := STRINGARRAY('ACTION','CARRIER_NAME',
8: 'RATE_CHART_NAME','CURRENCY','RATE_BASIS','RATE_BASIS_UOM','DISTANCE_TYPE',
9: 'SERVICE_LEVEL', 'VEHICLE_TYPE', 'RATE', 'MINIMUM_CHARGE', 'START_DATE', 'END_DATE');
10:
11: SERVICE CONSTANT STRINGARRAY := STRINGARRAY(

Line 11: SERVICE CONSTANT STRINGARRAY := STRINGARRAY(

7: TL_BASE_RATES CONSTANT STRINGARRAY := STRINGARRAY('ACTION','CARRIER_NAME',
8: 'RATE_CHART_NAME','CURRENCY','RATE_BASIS','RATE_BASIS_UOM','DISTANCE_TYPE',
9: 'SERVICE_LEVEL', 'VEHICLE_TYPE', 'RATE', 'MINIMUM_CHARGE', 'START_DATE', 'END_DATE');
10:
11: SERVICE CONSTANT STRINGARRAY := STRINGARRAY(
12: 'ACTION','TYPE','CARRIER_NAME',
13: 'SERVICE_NUMBER','MODE_OF_TRANSPORTATION','ORIGIN_COUNTRY','ORIGIN_STATE',
14: 'ORIGIN_CITY','ORIGIN_POSTAL_CODE_FROM','ORIGIN_POSTAL_CODE_TO',
15: 'ORIGIN_ZONE','DESTINATION_COUNTRY','DESTINATION_STATE',

Line 24: SERVICE_RATING_SETUP CONSTANT STRINGARRAY := STRINGARRAY(

20: 'PORT_OF_DISCHARGE','DISTANCE','DISTANCE_UOM','TRANSIT_TIME',
21: 'TRANSIT_TIME_UOM','SPECIAL_HANDLING','ADDITIONAL_INSTRUCTIONS',
22: 'START_DATE','END_DATE');
23:
24: SERVICE_RATING_SETUP CONSTANT STRINGARRAY := STRINGARRAY(
25: 'ACTION','CARRIER_NAME','SERVICE_NUMBER','TYPE','SUBTYPE','NAME',
26: 'VALUE_FROM','VALUE_TO','UOM','CURRENCY');
27:
28: SCHEDULE CONSTANT STRINGARRAY := STRINGARRAY(

Line 28: SCHEDULE CONSTANT STRINGARRAY := STRINGARRAY(

24: SERVICE_RATING_SETUP CONSTANT STRINGARRAY := STRINGARRAY(
25: 'ACTION','CARRIER_NAME','SERVICE_NUMBER','TYPE','SUBTYPE','NAME',
26: 'VALUE_FROM','VALUE_TO','UOM','CURRENCY');
27:
28: SCHEDULE CONSTANT STRINGARRAY := STRINGARRAY(
29: 'ACTION','CARRIER_NAME','SERVICE_NUMBER','VESSEL_TYPE','VESSEL_NAME',
30: 'VOYAGE_NUMBER','DEPARTURE_DATE','DEPARTURE_TIME','ARRIVAL_DATE',
31: 'ARRIVAL_TIME','ARRIVAL_DATE_INDICATOR','FREQUENCY_TYPE','FREQUENCY',
32: 'TRANSIT_TIME','TRANSIT_TIME_UOM','PORT_OF_LOADING','PORT_OF_DISCHARGE',

Line 35: RATE_CHART CONSTANT STRINGARRAY := STRINGARRAY(

31: 'ARRIVAL_TIME','ARRIVAL_DATE_INDICATOR','FREQUENCY_TYPE','FREQUENCY',
32: 'TRANSIT_TIME','TRANSIT_TIME_UOM','PORT_OF_LOADING','PORT_OF_DISCHARGE',
33: 'START_DATE','END_DATE');
34:
35: RATE_CHART CONSTANT STRINGARRAY := STRINGARRAY(
36: 'ACTION','CARRIER_NAME','RATE_CHART_NAME','CURRENCY','START_DATE',
37: 'END_DATE','DESCRIPTION','REPLACED_RATE_CHART');
38:
39: RATE_LINE CONSTANT STRINGARRAY := STRINGARRAY(

Line 39: RATE_LINE CONSTANT STRINGARRAY := STRINGARRAY(

35: RATE_CHART CONSTANT STRINGARRAY := STRINGARRAY(
36: 'ACTION','CARRIER_NAME','RATE_CHART_NAME','CURRENCY','START_DATE',
37: 'END_DATE','DESCRIPTION','REPLACED_RATE_CHART');
38:
39: RATE_LINE CONSTANT STRINGARRAY := STRINGARRAY(
40: 'ACTION','LINE_NUMBER','DESCRIPTION','RATE','UOM','RATE_BREAK_TYPE',
41: 'VOLUME_TYPE','RATE_TYPE');
42:
43: RATE_BREAK CONSTANT STRINGARRAY := STRINGARRAY(

Line 43: RATE_BREAK CONSTANT STRINGARRAY := STRINGARRAY(

39: RATE_LINE CONSTANT STRINGARRAY := STRINGARRAY(
40: 'ACTION','LINE_NUMBER','DESCRIPTION','RATE','UOM','RATE_BREAK_TYPE',
41: 'VOLUME_TYPE','RATE_TYPE');
42:
43: RATE_BREAK CONSTANT STRINGARRAY := STRINGARRAY(
44: 'ACTION','LINE_NUMBER','LOWER_LIMIT','UPPER_LIMIT','RATE', 'RATE_TYPE');
45:
46: RATING_ATTRIBUTE CONSTANT STRINGARRAY := STRINGARRAY(
47: 'ACTION','LINE_NUMBER','ATTRIBUTE','ATTRIBUTE_VALUE');

Line 46: RATING_ATTRIBUTE CONSTANT STRINGARRAY := STRINGARRAY(

42:
43: RATE_BREAK CONSTANT STRINGARRAY := STRINGARRAY(
44: 'ACTION','LINE_NUMBER','LOWER_LIMIT','UPPER_LIMIT','RATE', 'RATE_TYPE');
45:
46: RATING_ATTRIBUTE CONSTANT STRINGARRAY := STRINGARRAY(
47: 'ACTION','LINE_NUMBER','ATTRIBUTE','ATTRIBUTE_VALUE');
48:
49: CHARGES_DISCOUNTS CONSTANT STRINGARRAY := STRINGARRAY(
50: 'ACTION','CARRIER_NAME','CHARGES_DISCOUNTS_NAME','CURRENCY',

Line 49: CHARGES_DISCOUNTS CONSTANT STRINGARRAY := STRINGARRAY(

45:
46: RATING_ATTRIBUTE CONSTANT STRINGARRAY := STRINGARRAY(
47: 'ACTION','LINE_NUMBER','ATTRIBUTE','ATTRIBUTE_VALUE');
48:
49: CHARGES_DISCOUNTS CONSTANT STRINGARRAY := STRINGARRAY(
50: 'ACTION','CARRIER_NAME','CHARGES_DISCOUNTS_NAME','CURRENCY',
51: 'START_DATE','END_DATE','DESCRIPTION');
52:
53: ADJUSTED_RATE_CHART CONSTANT STRINGARRAY := STRINGARRAY(

Line 53: ADJUSTED_RATE_CHART CONSTANT STRINGARRAY := STRINGARRAY(

49: CHARGES_DISCOUNTS CONSTANT STRINGARRAY := STRINGARRAY(
50: 'ACTION','CARRIER_NAME','CHARGES_DISCOUNTS_NAME','CURRENCY',
51: 'START_DATE','END_DATE','DESCRIPTION');
52:
53: ADJUSTED_RATE_CHART CONSTANT STRINGARRAY := STRINGARRAY(
54: 'ACTION','RATE_CHART_NAME', 'TARIFF_NAME');
55:
56: CHARGES_DISCOUNTS_LINE CONSTANT STRINGARRAY := STRINGARRAY(
57: 'ACTION','LINE_NUMBER','DESCRIPTION','TYPE','SUBTYPE','UOM',

Line 56: CHARGES_DISCOUNTS_LINE CONSTANT STRINGARRAY := STRINGARRAY(

52:
53: ADJUSTED_RATE_CHART CONSTANT STRINGARRAY := STRINGARRAY(
54: 'ACTION','RATE_CHART_NAME', 'TARIFF_NAME');
55:
56: CHARGES_DISCOUNTS_LINE CONSTANT STRINGARRAY := STRINGARRAY(
57: 'ACTION','LINE_NUMBER','DESCRIPTION','TYPE','SUBTYPE','UOM',
58: 'RATE_PER_UOM','PERCENTAGE','FIXED_RATE');
59:
60: RATING_ZONE_CHART CONSTANT STRINGARRAY := STRINGARRAY (

Line 60: RATING_ZONE_CHART CONSTANT STRINGARRAY := STRINGARRAY (

56: CHARGES_DISCOUNTS_LINE CONSTANT STRINGARRAY := STRINGARRAY(
57: 'ACTION','LINE_NUMBER','DESCRIPTION','TYPE','SUBTYPE','UOM',
58: 'RATE_PER_UOM','PERCENTAGE','FIXED_RATE');
59:
60: RATING_ZONE_CHART CONSTANT STRINGARRAY := STRINGARRAY (
61: 'NAME_PREFIX','MODE_OF_TRANSPORTATION','CARRIER_NAME',
62: 'RATE_CHART_PREFIX', 'RATE_CHART_VIEW_FLAG', 'START_DATE', 'END_DATE');
63:
64: RATING_SETUP CONSTANT STRINGARRAY := STRINGARRAY(

Line 64: RATING_SETUP CONSTANT STRINGARRAY := STRINGARRAY(

60: RATING_ZONE_CHART CONSTANT STRINGARRAY := STRINGARRAY (
61: 'NAME_PREFIX','MODE_OF_TRANSPORTATION','CARRIER_NAME',
62: 'RATE_CHART_PREFIX', 'RATE_CHART_VIEW_FLAG', 'START_DATE', 'END_DATE');
63:
64: RATING_SETUP CONSTANT STRINGARRAY := STRINGARRAY(
65: 'SERVICE_LEVEL','TYPE','SUBTYPE','NAME','VALUE_FROM','VALUE_TO','UOM',
66: 'CURRENCY');
67:
68: ORIGIN CONSTANT STRINGARRAY := STRINGARRAY(

Line 68: ORIGIN CONSTANT STRINGARRAY := STRINGARRAY(

64: RATING_SETUP CONSTANT STRINGARRAY := STRINGARRAY(
65: 'SERVICE_LEVEL','TYPE','SUBTYPE','NAME','VALUE_FROM','VALUE_TO','UOM',
66: 'CURRENCY');
67:
68: ORIGIN CONSTANT STRINGARRAY := STRINGARRAY(
69: 'POSTAL_CODE_RANGE','COUNTRY','STATE','CITY');
70:
71: REGION CONSTANT STRINGARRAY := STRINGARRAY (
72: 'ACTION','COUNTRY','COUNTRY_CODE','STATE','STATE_CODE','CITY',

Line 71: REGION CONSTANT STRINGARRAY := STRINGARRAY (

67:
68: ORIGIN CONSTANT STRINGARRAY := STRINGARRAY(
69: 'POSTAL_CODE_RANGE','COUNTRY','STATE','CITY');
70:
71: REGION CONSTANT STRINGARRAY := STRINGARRAY (
72: 'ACTION','COUNTRY','COUNTRY_CODE','STATE','STATE_CODE','CITY',
73: 'CITY_CODE','POSTAL_CODE_FROM','POSTAL_CODE_TO');
74:
75: ZONE CONSTANT STRINGARRAY := STRINGARRAY(

Line 75: ZONE CONSTANT STRINGARRAY := STRINGARRAY(

71: REGION CONSTANT STRINGARRAY := STRINGARRAY (
72: 'ACTION','COUNTRY','COUNTRY_CODE','STATE','STATE_CODE','CITY',
73: 'CITY_CODE','POSTAL_CODE_FROM','POSTAL_CODE_TO');
74:
75: ZONE CONSTANT STRINGARRAY := STRINGARRAY(
76: 'ACTION','ZONE_NAME','COUNTRY','STATE','CITY','POSTAL_CODE_FROM',
77: 'POSTAL_CODE_TO');
78:
79: TL_SERVICES CONSTANT STRINGARRAY := STRINGARRAY(

Line 79: TL_SERVICES CONSTANT STRINGARRAY := STRINGARRAY(

75: ZONE CONSTANT STRINGARRAY := STRINGARRAY(
76: 'ACTION','ZONE_NAME','COUNTRY','STATE','CITY','POSTAL_CODE_FROM',
77: 'POSTAL_CODE_TO');
78:
79: TL_SERVICES CONSTANT STRINGARRAY := STRINGARRAY(
80: 'ACTION','CARRIER_NAME','SERVICE_NUMBER', 'ORIGIN_COUNTRY','ORIGIN_STATE',
81: 'ORIGIN_CITY','ORIGIN_POSTAL_CODE_FROM','ORIGIN_POSTAL_CODE_TO',
82: 'ORIGIN_ZONE','DESTINATION_COUNTRY','DESTINATION_STATE',
83: 'DESTINATION_CITY','DESTINATION_POSTAL_CODE_FROM',

Line 87: TL_SURCHARGES CONSTANT STRINGARRAY := STRINGARRAY(

83: 'DESTINATION_CITY','DESTINATION_POSTAL_CODE_FROM',
84: 'DESTINATION_POSTAL_CODE_TO','DESTINATION_ZONE','SERVICE_START_DATE',
85: 'SERVICE_END_DATE','RATE_CHART_NAME','SERVICE_LEVEL');
86:
87: TL_SURCHARGES CONSTANT STRINGARRAY := STRINGARRAY(
88: 'ACTION','TYPE','CARRIER_NAME','SERVICE_LEVEL','CURRENCY','START_DATE','END_DATE',
89: 'NUMBER_OF_FREE_STOPS','FIRST_ADD_STOP_OFF_CHARGES','SECOND_ADD_STOP_OFF_CHARGES',
90: 'THIRD_ADD_STOP_OFF_CHARGES','FOURTH_ADD_STOP_OFF_CHARGES','FIFTH_ADD_STOP_OFF_CHARGES',
91: 'ADDITIONAL_STOP_CHARGES','OUT_OF_ROUTE_CHARGES','OUT_OF_ROUTE_CHARGE_BASIS_UOM',

Line 100: FACILITY_CHARGES CONSTANT STRINGARRAY := STRINGARRAY(

96: 'WEEKDAY_LAYOVER_CHARGES','DISTANCE_UOM_FOR_WEEKEND_LAYOVER_CHARGES',
97: 'WEEKEND_LAYOVER_DISTANCE_BREAK', 'CHARGES','CONTINUOUS_MOVE_DISCOUNT_PERCENTAGE',
98: 'COUNTRY','STATE','CITY','POSTAL_CODE_FROM','POSTAL_CODE_TO','SURCHARGES');
99:
100: FACILITY_CHARGES CONSTANT STRINGARRAY := STRINGARRAY(
101: 'ACTION','FACILITY_RATE_CHART_NAME','START_DATE','END_DATE','CURRENCY',
102: 'BASIS_FOR_HANDLING_LOADING_UNLOADING_CHARGES','UOM_FOR_HANDLING_LOADING_UNLOADING_CHARGE_BASIS',
103: 'HANDLING_CHARGES', 'MINIMUM_HANDLING_CHARGES','LOADING_CHARGES','MINIMUM_LOADING_CHARGES',
104: 'UNLOADING_CHARGES', 'MINIMUM_UNLOADING_CHARGES','ASSISTED_LOADING_CHARGES',

Line 117: -- 1. p_keys: columns STRINGARRAY

113: --
114: -- Purpose: check if the columns read is valid
115: --
116: -- IN parameters:
117: -- 1. p_keys: columns STRINGARRAY
118: -- 2. p_type: type of the block
119: -- 3. p_line_number: line number
120: --
121: -- OUT parameters:

Line 141: -- 1. p_chart_info: a STRINGARRAY that contains name_prefix, mode_of_trans, carrier_name,

137: -- 1. p_values: pl/sql table of the rating zone chart line
138: -- 2. p_line_number: line number of current line
139: --
140: -- OUT parameters:
141: -- 1. p_chart_info: a STRINGARRAY that contains name_prefix, mode_of_trans, carrier_name,
142: -- carrier_id, price_prefix, view_flag, start_date, and end_date
143: -- 2. x_status: status of the processing, -1 means no error
144: -- 3. x_error_msg: error message if any.
145: ----------------------------------------------------------------------------

Line 148: p_chart_info OUT NOCOPY STRINGARRAY,

144: -- 3. x_error_msg: error message if any.
145: ----------------------------------------------------------------------------
146: PROCEDURE VALIDATE_RATING_ZONE_CHART(p_values IN FTE_BULKLOAD_PKG.data_values_tbl,
147: p_line_number IN NUMBER,
148: p_chart_info OUT NOCOPY STRINGARRAY,
149: x_status OUT NOCOPY NUMBER,
150: x_error_msg OUT NOCOPY VARCHAR2);
151:
152: ----------------------------------------------------------------------------

Line 184: -- 1. p_origin: STRINGARRAY of origin_postal, origin_country, origin_state, and origin_city

180: -- 1. p_values: pl/sql table of origin line
181: -- 2. p_line_number: line number of current line
182: --
183: -- OUT parameters:
184: -- 1. p_origin: STRINGARRAY of origin_postal, origin_country, origin_state, and origin_city
185: -- 2. x_status: status of the processing, -1 means no error
186: -- 3. x_error_msg: error message if any.
187: ----------------------------------------------------------------------------
188: PROCEDURE VALIDATE_ORIGIN(p_values IN FTE_BULKLOAD_PKG.data_values_tbl,

Line 190: p_origin OUT NOCOPY STRINGARRAY,

186: -- 3. x_error_msg: error message if any.
187: ----------------------------------------------------------------------------
188: PROCEDURE VALIDATE_ORIGIN(p_values IN FTE_BULKLOAD_PKG.data_values_tbl,
189: p_line_number IN NUMBER,
190: p_origin OUT NOCOPY STRINGARRAY,
191: x_status OUT NOCOPY NUMBER,
192: x_error_msg OUT NOCOPY VARCHAR2);
193:
194: ----------------------------------------------------------------------------

Line 209: -- 1. p_dest: STRINGARRAY of dest_postal, dest_country, dest_state, and dest_city

205: -- 6. p_service_count: number of service columns
206: -- 7. p_services: service column names
207: --
208: -- OUT parameters:
209: -- 1. p_dest: STRINGARRAY of dest_postal, dest_country, dest_state, and dest_city
210: -- 2. x_status: status of the processing, -1 means no error
211: -- 3. x_error_msg: error message if any.
212: ----------------------------------------------------------------------------
213: PROCEDURE VALIDATE_DESTINATION(p_values IN OUT NOCOPY FTE_BULKLOAD_PKG.data_values_tbl,

Line 220: p_dest OUT NOCOPY STRINGARRAY,

216: p_carrier_id IN NUMBER,
217: p_origin_zone IN FTE_BULKLOAD_PKG.data_values_tbl,
218: p_service_count IN OUT NOCOPY NUMBER,
219: p_services IN OUT NOCOPY FTE_PARCEL_LOADER.service_array,
220: p_dest OUT NOCOPY STRINGARRAY,
221: x_status OUT NOCOPY NUMBER,
222: x_error_msg OUT NOCOPY VARCHAR2);
223:
224: ----------------------------------------------------------------------------

Line 586: -- 1. p_columns: STRINGARRAY of the column names

582: --
583: -- Purpose: does validation for one line in zone block
584: --
585: -- IN parameters:
586: -- 1. p_columns: STRINGARRAY of the column names
587: -- 2. p_values: STRINGARRAY of the line values
588: -- 3. p_line_number: line number of current line
589: -- 4. p_region_type: region type for the zone (10, 11 etc)
590: --

Line 587: -- 2. p_values: STRINGARRAY of the line values

583: -- Purpose: does validation for one line in zone block
584: --
585: -- IN parameters:
586: -- 1. p_columns: STRINGARRAY of the column names
587: -- 2. p_values: STRINGARRAY of the line values
588: -- 3. p_line_number: line number of current line
589: -- 4. p_region_type: region type for the zone (10, 11 etc)
590: --
591: -- OUT parameters: