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

Line 22: g_chart_info STRINGARRAY; -- rating zone chart info STRINGARRAY

18: -----------------------------------------------------------------------------
19:
20: G_PKG_NAME CONSTANT VARCHAR2(50) := 'FTE_PARCEL_LOADER';
21:
22: g_chart_info STRINGARRAY; -- rating zone chart info STRINGARRAY
23: g_origin_zone FTE_BULKLOAD_PKG.data_values_tbl; -- origin zone info STRINGARRAY
24: g_dest_zones FTE_BULKLOAD_PKG.block_data_tbl; -- table of STRINGARRAY of destination zone info
25: g_last_service_type VARCHAR2(200) := NULL;
26:

Line 23: g_origin_zone FTE_BULKLOAD_PKG.data_values_tbl; -- origin zone info STRINGARRAY

19:
20: G_PKG_NAME CONSTANT VARCHAR2(50) := 'FTE_PARCEL_LOADER';
21:
22: g_chart_info STRINGARRAY; -- rating zone chart info STRINGARRAY
23: g_origin_zone FTE_BULKLOAD_PKG.data_values_tbl; -- origin zone info STRINGARRAY
24: g_dest_zones FTE_BULKLOAD_PKG.block_data_tbl; -- table of STRINGARRAY of destination zone info
25: g_last_service_type VARCHAR2(200) := NULL;
26:
27: -- table of STRINGARRAY with first item on string array being the service level,

Line 24: g_dest_zones FTE_BULKLOAD_PKG.block_data_tbl; -- table of STRINGARRAY of destination zone info

20: G_PKG_NAME CONSTANT VARCHAR2(50) := 'FTE_PARCEL_LOADER';
21:
22: g_chart_info STRINGARRAY; -- rating zone chart info STRINGARRAY
23: g_origin_zone FTE_BULKLOAD_PKG.data_values_tbl; -- origin zone info STRINGARRAY
24: g_dest_zones FTE_BULKLOAD_PKG.block_data_tbl; -- table of STRINGARRAY of destination zone info
25: g_last_service_type VARCHAR2(200) := NULL;
26:
27: -- table of STRINGARRAY with first item on string array being the service level,
28: -- if null, then that STRINGARRAY follows the last STRINGARRAY with first item not null.

Line 27: -- table of STRINGARRAY with first item on string array being the service level,

23: g_origin_zone FTE_BULKLOAD_PKG.data_values_tbl; -- origin zone info STRINGARRAY
24: g_dest_zones FTE_BULKLOAD_PKG.block_data_tbl; -- table of STRINGARRAY of destination zone info
25: g_last_service_type VARCHAR2(200) := NULL;
26:
27: -- table of STRINGARRAY with first item on string array being the service level,
28: -- if null, then that STRINGARRAY follows the last STRINGARRAY with first item not null.
29: g_setup_info FTE_BULKLOAD_PKG.array_tbl;
30: g_dest_indexes FTE_BULKLOAD_PKG.array_tbl;
31: g_dest_id NUMBER := 1;

Line 28: -- if null, then that STRINGARRAY follows the last STRINGARRAY with first item not null.

24: g_dest_zones FTE_BULKLOAD_PKG.block_data_tbl; -- table of STRINGARRAY of destination zone info
25: g_last_service_type VARCHAR2(200) := NULL;
26:
27: -- table of STRINGARRAY with first item on string array being the service level,
28: -- if null, then that STRINGARRAY follows the last STRINGARRAY with first item not null.
29: g_setup_info FTE_BULKLOAD_PKG.array_tbl;
30: g_dest_indexes FTE_BULKLOAD_PKG.array_tbl;
31: g_dest_id NUMBER := 1;
32:

Line 33: -- table of STRINGARRAY with first item being destination name and the rest being the values

29: g_setup_info FTE_BULKLOAD_PKG.array_tbl;
30: g_dest_indexes FTE_BULKLOAD_PKG.array_tbl;
31: g_dest_id NUMBER := 1;
32:
33: -- table of STRINGARRAY with first item being destination name and the rest being the values
34: -- of a row of service columns in destination block
35: g_dest_info FTE_BULKLOAD_PKG.array_tbl;
36: g_service_columns STRINGARRAY := STRINGARRAY(); -- STRINGARRAY of the column names of the service columns in destination block
37:

Line 36: g_service_columns STRINGARRAY := STRINGARRAY(); -- STRINGARRAY of the column names of the service columns in destination block

32:
33: -- table of STRINGARRAY with first item being destination name and the rest being the values
34: -- of a row of service columns in destination block
35: g_dest_info FTE_BULKLOAD_PKG.array_tbl;
36: g_service_columns STRINGARRAY := STRINGARRAY(); -- STRINGARRAY of the column names of the service columns in destination block
37:
38: g_postal_from VARCHAR2(100);
39: g_postal_to VARCHAR2(100);
40:

Line 121: p_tokens => STRINGARRAY('DATE'),

117: l_expiry_date := TO_CHAR(l_expiry_date);
118: EXCEPTION
119: WHEN OTHERS THEN
120: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_INCORRECT_DATE',
121: p_tokens => STRINGARRAY('DATE'),
122: p_values => STRINGARRAY(l_expiry_date));
123:
124: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
125: p_msg => x_error_msg,

Line 122: p_values => STRINGARRAY(l_expiry_date));

118: EXCEPTION
119: WHEN OTHERS THEN
120: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_INCORRECT_DATE',
121: p_tokens => STRINGARRAY('DATE'),
122: p_values => STRINGARRAY(l_expiry_date));
123:
124: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
125: p_msg => x_error_msg,
126: p_category => 'D',

Line 227: l_dest_values STRINGARRAY;

223: ----------------------------------------------------------------------------
224: PROCEDURE PROCESS_ZONES_AND_LANES(x_status OUT NOCOPY NUMBER,
225: x_error_msg OUT NOCOPY VARCHAR2) IS
226:
227: l_dest_values STRINGARRAY;
228: l_basis VARCHAR2(10) := 'WEIGHT';
229: l_lane_table FTE_BULKLOAD_PKG.block_data_tbl;
230: l_rate_table FTE_BULKLOAD_PKG.block_data_tbl;
231: l_lane_data FTE_BULKLOAD_PKG.data_values_tbl;

Line 401: -- 2. p_table: pl/sql table of STRINGARRAY containing the block information

397: -- Purpose: Call appropriate process function according to the type.
398: --
399: -- IN parameters:
400: -- 1. p_type: type of the block (Rating zone chart, rating setup, orign, destination)
401: -- 2. p_table: pl/sql table of STRINGARRAY containing the block information
402: -- 3. p_line_number: line number for the beginning of the block
403: --
404: -- OUT parameters:
405: -- 1. x_status: status of the processing, -1 means no error

Line 461: -- 1. p_table: pl/sql table of STRINGARRAY containing the block information

457: --
458: -- Purpose: process the lines in p_table for rating zone chart
459: --
460: -- IN parameters:
461: -- 1. p_table: pl/sql table of STRINGARRAY containing the block information
462: -- 2. p_line_number: line number for the beginning of the block
463: --
464: -- OUT parameters:
465: -- 1. x_status: status of the processing, -1 means no error

Line 526: -- 1. p_table: pl/sql table of STRINGARRAY containing the block information

522: --
523: -- Purpose: process the lines in p_table for rating setup
524: --
525: -- IN parameters:
526: -- 1. p_table: pl/sql table of STRINGARRAY containing the block information
527: -- 2. p_line_number: line number for the beginning of the block
528: --
529: -- OUT parameters:
530: -- 1. x_status: status of the processing, -1 means no error

Line 591: -- 1. p_table: pl/sql table of STRINGARRAY containing the block information

587: --
588: -- Purpose: process the lines in p_table for origin
589: --
590: -- IN parameters:
591: -- 1. p_table: pl/sql table of STRINGARRAY containing the block information
592: -- 2. p_line_number: line number for the beginning of the block
593: --
594: -- OUT parameters:
595: -- 1. x_status: status of the processing, -1 means no error

Line 612: l_origin STRINGARRAY;

608: l_origin_city VARCHAR2(200);
609: l_origin_postal_from VARCHAR2(100);
610: l_origin_postal_to VARCHAR2(100);
611: l_values FTE_BULKLOAD_PKG.data_values_tbl;
612: l_origin STRINGARRAY;
613:
614: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.PROCESS_ORIGIN';
615: BEGIN
616: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);

Line 694: -- 1. p_table: pl/sql table of STRINGARRAY containing the block information

690: --
691: -- Purpose: process the lines in p_table for destination
692: --
693: -- IN parameters:
694: -- 1. p_table: pl/sql table of STRINGARRAY containing the block information
695: -- 2. p_line_number: line number for the beginning of the block
696: --
697: -- OUT parameters:
698: -- 1. x_status: status of the processing, -1 means no error

Line 718: l_dest_values STRINGARRAY := STRINGARRAY();

714: l_dest_zone_name VARCHAR2(200);
715: l_services service_array := service_array(); -- name of the services
716: l_service_count NUMBER := 0; -- number of services
717: l_name_value VARCHAR2(2000);
718: l_dest_values STRINGARRAY := STRINGARRAY();
719: l_exists BOOLEAN := FALSE;
720: l_dest STRINGARRAY := STRINGARRAY();
721: l_count NUMBER;
722:

Line 720: l_dest STRINGARRAY := STRINGARRAY();

716: l_service_count NUMBER := 0; -- number of services
717: l_name_value VARCHAR2(2000);
718: l_dest_values STRINGARRAY := STRINGARRAY();
719: l_exists BOOLEAN := FALSE;
720: l_dest STRINGARRAY := STRINGARRAY();
721: l_count NUMBER;
722:
723: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.PROCESS_DESTINATION';
724: BEGIN

Line 809: g_dest_indexes(g_dest_indexes.COUNT+1) := STRINGARRAY(l_name_value, g_dest_id);

805: --+
806: -- l_name_value was not found in the g_dest_indexes table
807: --+
808: IF (l_dest_zone_name = g_origin_zone(FTE_VALIDATION_PKG.ZONE(2))) THEN
809: g_dest_indexes(g_dest_indexes.COUNT+1) := STRINGARRAY(l_name_value, g_dest_id);
810: l_dest_zone_name := l_dest_zone_name || '-' || g_dest_id;
811: g_dest_id := g_dest_id + 1;
812: END IF;
813:

Line 824: l_dest_values := STRINGARRAY();

820: END IF;
821: END LOOP;
822:
823: IF (NOT l_exists) THEN
824: l_dest_values := STRINGARRAY();
825: l_dest_values.EXTEND;
826: l_dest_values(l_dest_values.COUNT) := l_dest_zone_name;
827:
828: FOR i IN 1..l_service_count LOOP