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_LANE_LOADER dependencies on FTE_BULKLOAD_PKG

Line 46: p_block_header IN FTE_BULKLOAD_PKG.block_header_tbl,

42: -- 1. x_status: status of the processing, -1 means no error
43: -- 2. x_error_msg: error message if any.
44: ----------------------------------------------------------------------------
45: PROCEDURE PROCESS_DATA (p_type IN VARCHAR2,
46: p_block_header IN FTE_BULKLOAD_PKG.block_header_tbl,
47: p_block_data IN FTE_BULKLOAD_PKG.block_data_tbl,
48: p_line_number IN NUMBER,
49: x_status OUT NOCOPY NUMBER,
50: x_error_msg OUT NOCOPY VARCHAR2) IS

Line 47: p_block_data IN FTE_BULKLOAD_PKG.block_data_tbl,

43: -- 2. x_error_msg: error message if any.
44: ----------------------------------------------------------------------------
45: PROCEDURE PROCESS_DATA (p_type IN VARCHAR2,
46: p_block_header IN FTE_BULKLOAD_PKG.block_header_tbl,
47: p_block_data IN FTE_BULKLOAD_PKG.block_data_tbl,
48: p_line_number IN NUMBER,
49: x_status OUT NOCOPY NUMBER,
50: x_error_msg OUT NOCOPY VARCHAR2) IS
51: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.PROCESS_DATA';

Line 99: PROCEDURE PROCESS_SERVICE (p_block_header IN FTE_BULKLOAD_PKG.block_header_tbl,

95: -- OUT parameters:
96: -- 1. x_status: status of the processing, -1 means no error
97: -- 2. x_error_msg: error message if any.
98: ----------------------------------------------------------------------------
99: PROCEDURE PROCESS_SERVICE (p_block_header IN FTE_BULKLOAD_PKG.block_header_tbl,
100: p_block_data IN FTE_BULKLOAD_PKG.block_data_tbl,
101: p_line_number IN NUMBER,
102: x_status OUT NOCOPY NUMBER,
103: x_error_msg OUT NOCOPY VARCHAR2) IS

Line 100: p_block_data IN FTE_BULKLOAD_PKG.block_data_tbl,

96: -- 1. x_status: status of the processing, -1 means no error
97: -- 2. x_error_msg: error message if any.
98: ----------------------------------------------------------------------------
99: PROCEDURE PROCESS_SERVICE (p_block_header IN FTE_BULKLOAD_PKG.block_header_tbl,
100: p_block_data IN FTE_BULKLOAD_PKG.block_data_tbl,
101: p_line_number IN NUMBER,
102: x_status OUT NOCOPY NUMBER,
103: x_error_msg OUT NOCOPY VARCHAR2) IS
104:

Line 105: l_values FTE_BULKLOAD_PKG.data_values_tbl;

101: p_line_number IN NUMBER,
102: x_status OUT NOCOPY NUMBER,
103: x_error_msg OUT NOCOPY VARCHAR2) IS
104:
105: l_values FTE_BULKLOAD_PKG.data_values_tbl;
106: l_action VARCHAR2(20);
107: l_type VARCHAR2(100);
108: l_find_lane BOOLEAN := false;
109: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.PROCESS_SERVICE';

Line 274: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

270: RETURN;
271: END IF;
272:
273: /* IF (x_status = -1) THEN
274: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
275: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Commiting for Service load');
276: END IF;
277: commit;
278: END IF;

Line 303: PROCEDURE PROCESS_SERVICE_RATING_SETUP (p_block_header IN FTE_BULKLOAD_PKG.block_header_tbl,

299: -- OUT parameters:
300: -- 1. x_status: status of the processing, -1 means no error
301: -- 2. x_error_msg: error message if any.
302: ----------------------------------------------------------------------------
303: PROCEDURE PROCESS_SERVICE_RATING_SETUP (p_block_header IN FTE_BULKLOAD_PKG.block_header_tbl,
304: p_block_data IN FTE_BULKLOAD_PKG.block_data_tbl,
305: p_line_number IN NUMBER,
306: x_status OUT NOCOPY NUMBER,
307: x_error_msg OUT NOCOPY VARCHAR2) IS

Line 304: p_block_data IN FTE_BULKLOAD_PKG.block_data_tbl,

300: -- 1. x_status: status of the processing, -1 means no error
301: -- 2. x_error_msg: error message if any.
302: ----------------------------------------------------------------------------
303: PROCEDURE PROCESS_SERVICE_RATING_SETUP (p_block_header IN FTE_BULKLOAD_PKG.block_header_tbl,
304: p_block_data IN FTE_BULKLOAD_PKG.block_data_tbl,
305: p_line_number IN NUMBER,
306: x_status OUT NOCOPY NUMBER,
307: x_error_msg OUT NOCOPY VARCHAR2) IS
308:

Line 309: l_values FTE_BULKLOAD_PKG.data_values_tbl;

305: p_line_number IN NUMBER,
306: x_status OUT NOCOPY NUMBER,
307: x_error_msg OUT NOCOPY VARCHAR2) IS
308:
309: l_values FTE_BULKLOAD_PKG.data_values_tbl;
310: l_action VARCHAR2(100);
311: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.PROCESS_SERVICE_RATING_SETUP';
312: l_lane_number VARCHAR2(200);
313:

Line 439: PROCEDURE PROCESS_SCHEDULE (p_block_header IN FTE_BULKLOAD_PKG.block_header_tbl,

435: -- OUT parameters:
436: -- 1. x_status: status of the processing, -1 means no error
437: -- 2. x_error_msg: error message if any.
438: ----------------------------------------------------------------------------
439: PROCEDURE PROCESS_SCHEDULE (p_block_header IN FTE_BULKLOAD_PKG.block_header_tbl,
440: p_block_data IN FTE_BULKLOAD_PKG.block_data_tbl,
441: p_line_number IN NUMBER,
442: x_status OUT NOCOPY NUMBER,
443: x_error_msg OUT NOCOPY VARCHAR2) IS

Line 440: p_block_data IN FTE_BULKLOAD_PKG.block_data_tbl,

436: -- 1. x_status: status of the processing, -1 means no error
437: -- 2. x_error_msg: error message if any.
438: ----------------------------------------------------------------------------
439: PROCEDURE PROCESS_SCHEDULE (p_block_header IN FTE_BULKLOAD_PKG.block_header_tbl,
440: p_block_data IN FTE_BULKLOAD_PKG.block_data_tbl,
441: p_line_number IN NUMBER,
442: x_status OUT NOCOPY NUMBER,
443: x_error_msg OUT NOCOPY VARCHAR2) IS
444:

Line 447: l_values FTE_BULKLOAD_PKG.data_values_tbl;

443: x_error_msg OUT NOCOPY VARCHAR2) IS
444:
445: l_rows NUMBER := -1;
446: l_old_schedule_id NUMBER := -1;
447: l_values FTE_BULKLOAD_PKG.data_values_tbl;
448: l_action VARCHAR2(100);
449: l_voyage VARCHAR2(200);
450: l_data_keys STRINGARRAY := STRINGARRAY();
451: l_data_values STRINGARRAY := STRINGARRAY();