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 FTE_BULKLOAD_PKG

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 29: g_setup_info FTE_BULKLOAD_PKG.array_tbl;

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:
33: -- table of STRINGARRAY with first item being destination name and the rest being the values

Line 30: g_dest_indexes FTE_BULKLOAD_PKG.array_tbl;

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:
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

Line 35: g_dest_info 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:
38: g_postal_from VARCHAR2(100);
39: g_postal_to VARCHAR2(100);

Line 104: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

100: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
101:
102: x_status := -1;
103:
104: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
105: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Zone Name', p_zone_name);
106: END IF;
107:
108: IF (l_start_date IS NULL) THEN

Line 112: l_expiry_date := TO_DATE(l_start_date, FTE_BULKLOAD_PKG.G_DATE_FORMAT3) - 1;

108: IF (l_start_date IS NULL) THEN
109: l_expiry_date := SYSDATE - 1;
110: ELSE
111: BEGIN
112: l_expiry_date := TO_DATE(l_start_date, FTE_BULKLOAD_PKG.G_DATE_FORMAT3) - 1;
113: EXCEPTION
114: WHEN OTHERS THEN
115: BEGIN
116: l_expiry_date := TO_DATE(l_expiry_date,'MM/DD/YYYY') - 1;

Line 229: l_lane_table FTE_BULKLOAD_PKG.block_data_tbl;

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;
232: l_service_data FTE_BULKLOAD_PKG.data_values_tbl;
233: l_rate_data FTE_BULKLOAD_PKG.data_values_tbl;

Line 230: l_rate_table FTE_BULKLOAD_PKG.block_data_tbl;

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;
232: l_service_data FTE_BULKLOAD_PKG.data_values_tbl;
233: l_rate_data FTE_BULKLOAD_PKG.data_values_tbl;
234: l_setup_data FTE_BULKLOAD_PKG.data_values_tbl;

Line 231: l_lane_data FTE_BULKLOAD_PKG.data_values_tbl;

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;
232: l_service_data FTE_BULKLOAD_PKG.data_values_tbl;
233: l_rate_data FTE_BULKLOAD_PKG.data_values_tbl;
234: l_setup_data FTE_BULKLOAD_PKG.data_values_tbl;
235: l_lane_header FTE_BULKLOAD_PKG.block_header_tbl;

Line 232: l_service_data FTE_BULKLOAD_PKG.data_values_tbl;

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;
232: l_service_data FTE_BULKLOAD_PKG.data_values_tbl;
233: l_rate_data FTE_BULKLOAD_PKG.data_values_tbl;
234: l_setup_data FTE_BULKLOAD_PKG.data_values_tbl;
235: l_lane_header FTE_BULKLOAD_PKG.block_header_tbl;
236: l_rate_header FTE_BULKLOAD_PKG.block_header_tbl;

Line 233: l_rate_data FTE_BULKLOAD_PKG.data_values_tbl;

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;
232: l_service_data FTE_BULKLOAD_PKG.data_values_tbl;
233: l_rate_data FTE_BULKLOAD_PKG.data_values_tbl;
234: l_setup_data FTE_BULKLOAD_PKG.data_values_tbl;
235: l_lane_header FTE_BULKLOAD_PKG.block_header_tbl;
236: l_rate_header FTE_BULKLOAD_PKG.block_header_tbl;
237: l_zone_header FTE_BULKLOAD_PKG.block_header_tbl;

Line 234: l_setup_data FTE_BULKLOAD_PKG.data_values_tbl;

230: l_rate_table FTE_BULKLOAD_PKG.block_data_tbl;
231: l_lane_data FTE_BULKLOAD_PKG.data_values_tbl;
232: l_service_data FTE_BULKLOAD_PKG.data_values_tbl;
233: l_rate_data FTE_BULKLOAD_PKG.data_values_tbl;
234: l_setup_data FTE_BULKLOAD_PKG.data_values_tbl;
235: l_lane_header FTE_BULKLOAD_PKG.block_header_tbl;
236: l_rate_header FTE_BULKLOAD_PKG.block_header_tbl;
237: l_zone_header FTE_BULKLOAD_PKG.block_header_tbl;
238: l_index NUMBER;

Line 235: l_lane_header FTE_BULKLOAD_PKG.block_header_tbl;

231: l_lane_data FTE_BULKLOAD_PKG.data_values_tbl;
232: l_service_data FTE_BULKLOAD_PKG.data_values_tbl;
233: l_rate_data FTE_BULKLOAD_PKG.data_values_tbl;
234: l_setup_data FTE_BULKLOAD_PKG.data_values_tbl;
235: l_lane_header FTE_BULKLOAD_PKG.block_header_tbl;
236: l_rate_header FTE_BULKLOAD_PKG.block_header_tbl;
237: l_zone_header FTE_BULKLOAD_PKG.block_header_tbl;
238: l_index NUMBER;
239:

Line 236: l_rate_header FTE_BULKLOAD_PKG.block_header_tbl;

232: l_service_data FTE_BULKLOAD_PKG.data_values_tbl;
233: l_rate_data FTE_BULKLOAD_PKG.data_values_tbl;
234: l_setup_data FTE_BULKLOAD_PKG.data_values_tbl;
235: l_lane_header FTE_BULKLOAD_PKG.block_header_tbl;
236: l_rate_header FTE_BULKLOAD_PKG.block_header_tbl;
237: l_zone_header FTE_BULKLOAD_PKG.block_header_tbl;
238: l_index NUMBER;
239:
240: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.PROCESS_ZONES_AND_LANES';

Line 237: l_zone_header FTE_BULKLOAD_PKG.block_header_tbl;

233: l_rate_data FTE_BULKLOAD_PKG.data_values_tbl;
234: l_setup_data FTE_BULKLOAD_PKG.data_values_tbl;
235: l_lane_header FTE_BULKLOAD_PKG.block_header_tbl;
236: l_rate_header FTE_BULKLOAD_PKG.block_header_tbl;
237: l_zone_header FTE_BULKLOAD_PKG.block_header_tbl;
238: l_index NUMBER;
239:
240: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.PROCESS_ZONES_AND_LANES';
241: BEGIN

Line 318: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

314: l_lane_table(l_lane_table.COUNT+1) := l_rate_data;
315:
316: FOR k IN 1..g_setup_info.COUNT LOOP
317:
318: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
319: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'service', g_setup_info(k)(1));
320: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'service columns', g_service_columns(j));
321: END IF;
322:

Line 409: p_block_header IN FTE_BULKLOAD_PKG.block_header_tbl,

405: -- 1. x_status: status of the processing, -1 means no error
406: -- 2. x_error_msg: error message if any.
407: ----------------------------------------------------------------------------
408: PROCEDURE PROCESS_DATA (p_type IN VARCHAR2,
409: p_block_header IN FTE_BULKLOAD_PKG.block_header_tbl,
410: p_block_data IN FTE_BULKLOAD_PKG.block_data_tbl,
411: p_line_number IN NUMBER,
412: x_status OUT NOCOPY NUMBER,
413: x_error_msg OUT NOCOPY VARCHAR2) IS

Line 410: p_block_data IN FTE_BULKLOAD_PKG.block_data_tbl,

406: -- 2. x_error_msg: error message if any.
407: ----------------------------------------------------------------------------
408: PROCEDURE PROCESS_DATA (p_type IN VARCHAR2,
409: p_block_header IN FTE_BULKLOAD_PKG.block_header_tbl,
410: p_block_data IN FTE_BULKLOAD_PKG.block_data_tbl,
411: p_line_number IN NUMBER,
412: x_status OUT NOCOPY NUMBER,
413: x_error_msg OUT NOCOPY VARCHAR2) IS
414: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.PROCESS_DATA';

Line 469: PROCEDURE PROCESS_RATING_ZONE_CHART(p_block_header IN FTE_BULKLOAD_PKG.block_header_tbl,

465: -- 1. x_status: status of the processing, -1 means no error
466: -- 2. x_error_msg: error message if any.
467: ----------------------------------------------------------------------------
468:
469: PROCEDURE PROCESS_RATING_ZONE_CHART(p_block_header IN FTE_BULKLOAD_PKG.block_header_tbl,
470: p_block_data IN FTE_BULKLOAD_PKG.block_data_tbl,
471: p_line_number IN NUMBER,
472: x_status OUT NOCOPY NUMBER,
473: x_error_msg OUT NOCOPY VARCHAR2) IS

Line 470: p_block_data IN FTE_BULKLOAD_PKG.block_data_tbl,

466: -- 2. x_error_msg: error message if any.
467: ----------------------------------------------------------------------------
468:
469: PROCEDURE PROCESS_RATING_ZONE_CHART(p_block_header IN FTE_BULKLOAD_PKG.block_header_tbl,
470: p_block_data IN FTE_BULKLOAD_PKG.block_data_tbl,
471: p_line_number IN NUMBER,
472: x_status OUT NOCOPY NUMBER,
473: x_error_msg OUT NOCOPY VARCHAR2) IS
474:

Line 475: l_values FTE_BULKLOAD_PKG.data_values_tbl;

471: p_line_number IN NUMBER,
472: x_status OUT NOCOPY NUMBER,
473: x_error_msg OUT NOCOPY VARCHAR2) IS
474:
475: l_values FTE_BULKLOAD_PKG.data_values_tbl;
476: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.PROCESS_RATING_ZONE_CHART';
477: BEGIN
478: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
479:

Line 534: PROCEDURE PROCESS_RATING_SETUP(p_block_header IN FTE_BULKLOAD_PKG.block_header_tbl,

530: -- 1. x_status: status of the processing, -1 means no error
531: -- 2. x_error_msg: error message if any.
532: ----------------------------------------------------------------------------
533:
534: PROCEDURE PROCESS_RATING_SETUP(p_block_header IN FTE_BULKLOAD_PKG.block_header_tbl,
535: p_block_data IN FTE_BULKLOAD_PKG.block_data_tbl,
536: p_line_number IN NUMBER,
537: x_status OUT NOCOPY NUMBER,
538: x_error_msg OUT NOCOPY VARCHAR2) IS

Line 535: p_block_data IN FTE_BULKLOAD_PKG.block_data_tbl,

531: -- 2. x_error_msg: error message if any.
532: ----------------------------------------------------------------------------
533:
534: PROCEDURE PROCESS_RATING_SETUP(p_block_header IN FTE_BULKLOAD_PKG.block_header_tbl,
535: p_block_data IN FTE_BULKLOAD_PKG.block_data_tbl,
536: p_line_number IN NUMBER,
537: x_status OUT NOCOPY NUMBER,
538: x_error_msg OUT NOCOPY VARCHAR2) IS
539:

Line 540: l_values FTE_BULKLOAD_PKG.data_values_tbl;

536: p_line_number IN NUMBER,
537: x_status OUT NOCOPY NUMBER,
538: x_error_msg OUT NOCOPY VARCHAR2) IS
539:
540: l_values FTE_BULKLOAD_PKG.data_values_tbl;
541: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.PROCESS_RATING_SETUP';
542: BEGIN
543: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
544:

Line 599: PROCEDURE PROCESS_ORIGIN(p_block_header IN FTE_BULKLOAD_PKG.block_header_tbl,

595: -- 1. x_status: status of the processing, -1 means no error
596: -- 2. x_error_msg: error message if any.
597: ----------------------------------------------------------------------------
598:
599: PROCEDURE PROCESS_ORIGIN(p_block_header IN FTE_BULKLOAD_PKG.block_header_tbl,
600: p_block_data IN FTE_BULKLOAD_PKG.block_data_tbl,
601: p_line_number IN NUMBER,
602: x_status OUT NOCOPY NUMBER,
603: x_error_msg OUT NOCOPY VARCHAR2) IS

Line 600: p_block_data IN FTE_BULKLOAD_PKG.block_data_tbl,

596: -- 2. x_error_msg: error message if any.
597: ----------------------------------------------------------------------------
598:
599: PROCEDURE PROCESS_ORIGIN(p_block_header IN FTE_BULKLOAD_PKG.block_header_tbl,
600: p_block_data IN FTE_BULKLOAD_PKG.block_data_tbl,
601: p_line_number IN NUMBER,
602: x_status OUT NOCOPY NUMBER,
603: x_error_msg OUT NOCOPY VARCHAR2) IS
604:

Line 611: l_values FTE_BULKLOAD_PKG.data_values_tbl;

607: l_origin_state VARCHAR2(200);
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

Line 702: PROCEDURE PROCESS_DESTINATION(p_block_data IN FTE_BULKLOAD_PKG.block_data_tbl,

698: -- 1. x_status: status of the processing, -1 means no error
699: -- 2. x_error_msg: error message if any.
700: ----------------------------------------------------------------------------
701:
702: PROCEDURE PROCESS_DESTINATION(p_block_data IN FTE_BULKLOAD_PKG.block_data_tbl,
703: p_line_number IN NUMBER,
704: x_status OUT NOCOPY NUMBER,
705: x_error_msg OUT NOCOPY VARCHAR2) IS
706:

Line 713: l_values FTE_BULKLOAD_PKG.data_values_tbl;

709: l_dest_state VARCHAR2(200);
710: l_dest_city VARCHAR2(200);
711: l_dest_postal_from VARCHAR2(100);
712: l_dest_postal_to VARCHAR2(100);
713: l_values FTE_BULKLOAD_PKG.data_values_tbl;
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);

Line 733: FOR i IN 1..FTE_BULKLOAD_PKG.g_block_header_index.COUNT LOOP

729: --+
730: -- Do not verify the column name for destination since it's dynamic
731: -- find out the mapping for column number to service columns
732: --+
733: FOR i IN 1..FTE_BULKLOAD_PKG.g_block_header_index.COUNT LOOP
734:
735: IF (FTE_BULKLOAD_PKG.g_block_header_index(i) NOT IN ('POSTAL_CODE_RANGE', 'COUNTRY', 'STATE', 'CITY')) THEN
736: --+
737: -- If not those column names, then it's a service. Map it

Line 735: IF (FTE_BULKLOAD_PKG.g_block_header_index(i) NOT IN ('POSTAL_CODE_RANGE', 'COUNTRY', 'STATE', 'CITY')) THEN

731: -- find out the mapping for column number to service columns
732: --+
733: FOR i IN 1..FTE_BULKLOAD_PKG.g_block_header_index.COUNT LOOP
734:
735: IF (FTE_BULKLOAD_PKG.g_block_header_index(i) NOT IN ('POSTAL_CODE_RANGE', 'COUNTRY', 'STATE', 'CITY')) THEN
736: --+
737: -- If not those column names, then it's a service. Map it
738: --+
739: l_service_count := l_service_count + 1;

Line 743: g_service_columns(g_service_columns.COUNT) := FTE_BULKLOAD_PKG.g_block_header_index(i);

739: l_service_count := l_service_count + 1;
740: l_services.EXTEND;
741: l_services(l_service_count) := i;
742: g_service_columns.EXTEND;
743: g_service_columns(g_service_columns.COUNT) := FTE_BULKLOAD_PKG.g_block_header_index(i);
744:
745: END IF;
746:
747: END LOOP;

Line 784: IF(FTE_BULKLOAD_PKG.g_debug_on) THEN

780: l_dest_postal_to := g_postal_to;
781:
782: l_dest_zone_name := g_origin_zone(FTE_VALIDATION_PKG.ZONE(2));
783:
784: IF(FTE_BULKLOAD_PKG.g_debug_on) THEN
785: FTE_UTIL_PKG.WRITE_LogFile(l_module_name,'l_dest_zone_name',l_dest_zone_name);
786: END IF;
787:
788: l_name_value := null;

Line 791: l_name_value := l_name_value || '-' || l_values(FTE_BULKLOAD_PKG.g_block_header_index(l_services(i)));

787:
788: l_name_value := null;
789:
790: FOR i IN 1..l_service_count LOOP
791: l_name_value := l_name_value || '-' || l_values(FTE_BULKLOAD_PKG.g_block_header_index(l_services(i)));
792: END LOOP;
793:
794: FOR i in 1..g_dest_indexes.COUNT LOOP
795: IF (g_dest_indexes(i)(1) = l_name_value) THEN

Line 800: IF(FTE_BULKLOAD_PKG.g_debug_on) THEN

796: l_dest_zone_name := l_dest_zone_name || '-' || g_dest_indexes(i)(2);
797: END IF;
798: END LOOP;
799:
800: IF(FTE_BULKLOAD_PKG.g_debug_on) THEN
801: FTE_UTIL_PKG.WRITE_LogFile(l_module_name,'l_name_value',l_name_value);
802: FTE_UTIL_PKG.WRITE_LogFile(l_module_name,'l_dest_zone_name',l_dest_zone_name);
803: END IF;
804:

Line 830: l_dest_values(l_dest_values.COUNT) := l_values(FTE_BULKLOAD_PKG.g_block_header_index(l_services(i)));

826: l_dest_values(l_dest_values.COUNT) := l_dest_zone_name;
827:
828: FOR i IN 1..l_service_count LOOP
829: l_dest_values.EXTEND;
830: l_dest_values(l_dest_values.COUNT) := l_values(FTE_BULKLOAD_PKG.g_block_header_index(l_services(i)));
831: END LOOP;
832: g_dest_info(g_dest_info.COUNT+1) := l_dest_values;
833:
834: END IF;