DBA Data[Home] [Help]

APPS.FTE_LANE_LOADER dependencies on STRINGARRAY

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

34: -- Purpose: Call appropriate process function according to the type.
35: --
36: -- IN parameters:
37: -- 1. p_type: type of the block (Service, Schedule, Service_rating_setup)
38: -- 2. p_table: pl/sql table of STRINGARRAY containing the block information
39: -- 3. p_line_number: line number for the beginning of the block
40: --
41: -- OUT parameters:
42: -- 1. x_status: status of the processing, -1 means no error

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

88: --
89: -- Purpose: process the lines in p_table for service
90: --
91: -- IN parameters:
92: -- 1. p_table: pl/sql table of STRINGARRAY containing the block information
93: -- 2. p_line_number: line number for the beginning of the block
94: --
95: -- OUT parameters:
96: -- 1. x_status: status of the processing, -1 means no error

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

292: --
293: -- Purpose: process the lines in p_table for service_rating_setup
294: --
295: -- IN parameters:
296: -- 1. p_table: pl/sql table of STRINGARRAY containing the block information
297: -- 2. p_line_number: line number for the beginning of the block
298: --
299: -- OUT parameters:
300: -- 1. x_status: status of the processing, -1 means no error

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

428: --
429: -- Purpose: process the lines in p_table for schedule
430: --
431: -- IN parameters:
432: -- 1. p_table: pl/sql table of STRINGARRAY containing the block information
433: -- 2. p_line_number: line number for the beginning of the block
434: --
435: -- OUT parameters:
436: -- 1. x_status: status of the processing, -1 means no error

Line 450: l_data_keys STRINGARRAY := STRINGARRAY();

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();
452: l_lane_id NUMBER;
453:
454: l_header_printed BOOLEAN := false;

Line 451: l_data_values STRINGARRAY := STRINGARRAY();

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();
452: l_lane_id NUMBER;
453:
454: l_header_printed BOOLEAN := false;
455: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.PROCESS_SCHEDULE';