1 PACKAGE FTE_LANE_LOADER AS
2 /* $Header: FTELNLDS.pls 120.0 2005/06/28 02:23:45 pkaliyam noship $ */
3
4 ----------------------------------------------------------------------------
5 -- PROCEDURE PROCESS_DATA
6 --
7 -- Purpose: Call appropriate process function according to the type.
8 --
9 -- IN parameters:
10 -- 1. p_type: type of the block (Service, Schedule, Service_rating_setup)
11 -- 2. p_table: pl/sql table of STRINGARRAY containing the block information
12 -- 3. p_line_number: line number for the beginning of the block
13 --
14 -- OUT parameters:
15 -- 1. x_status: status of the processing, -1 means no error
16 -- 2. x_error_msg: error message if any.
17 ----------------------------------------------------------------------------
18 PROCEDURE PROCESS_DATA (p_type IN VARCHAR2,
19 p_block_header IN FTE_BULKLOAD_PKG.block_header_tbl,
20 p_block_data IN FTE_BULKLOAD_PKG.block_data_tbl,
21 p_line_number IN NUMBER,
22 x_status OUT NOCOPY NUMBER,
23 x_error_msg OUT NOCOPY VARCHAR2);
24
25 ----------------------------------------------------------------------------
26 -- PROCEDURE PROCESS_SERVICE
27 --
28 -- Purpose: process the lines in p_table for service
29 --
30 -- IN parameters:
31 -- 1. p_table: pl/sql table of STRINGARRAY containing the block information
32 -- 2. p_line_number: line number for the beginning of the block
33 --
34 -- OUT parameters:
35 -- 1. x_status: status of the processing, -1 means no error
36 -- 2. x_error_msg: error message if any.
37 ----------------------------------------------------------------------------
38 PROCEDURE PROCESS_SERVICE (p_block_header IN FTE_BULKLOAD_PKG.block_header_tbl,
39 p_block_data IN FTE_BULKLOAD_PKG.block_data_tbl,
40 p_line_number IN NUMBER,
41 x_status OUT NOCOPY NUMBER,
42 x_error_msg OUT NOCOPY VARCHAR2);
43
44 ----------------------------------------------------------------------------
45 -- PROCEDURE PROCESS_SERVICE_RATING_SETUP
46 --
47 -- Purpose: process the lines in p_table for service_rating_setup
48 --
49 -- IN parameters:
50 -- 1. p_table: pl/sql table of STRINGARRAY containing the block information
51 -- 2. p_line_number: line number for the beginning of the block
52 --
53 -- OUT parameters:
54 -- 1. x_status: status of the processing, -1 means no error
55 -- 2. x_error_msg: error message if any.
56 ----------------------------------------------------------------------------
57 PROCEDURE PROCESS_SERVICE_RATING_SETUP (p_block_header IN FTE_BULKLOAD_PKG.block_header_tbl,
58 p_block_data IN FTE_BULKLOAD_PKG.block_data_tbl,
59 p_line_number IN NUMBER,
60 x_status OUT NOCOPY NUMBER,
61 x_error_msg OUT NOCOPY VARCHAR2);
62
63 ----------------------------------------------------------------------------
64 -- PROCEDURE PROCESS_SCHEDULE
65 --
66 -- Purpose: process the lines in p_table for schedule
67 --
68 -- IN parameters:
69 -- 1. p_table: pl/sql table of STRINGARRAY containing the block information
70 -- 2. p_line_number: line number for the beginning of the block
71 --
72 -- OUT parameters:
73 -- 1. x_status: status of the processing, -1 means no error
74 -- 2. x_error_msg: error message if any.
75 ----------------------------------------------------------------------------
76 PROCEDURE PROCESS_SCHEDULE (p_block_header IN FTE_BULKLOAD_PKG.block_header_tbl,
77 p_block_data IN FTE_BULKLOAD_PKG.block_data_tbl,
78 p_line_number IN NUMBER,
79 x_status OUT NOCOPY NUMBER,
80 x_error_msg OUT NOCOPY VARCHAR2);
81
82 ----------------------------------------------------------------------
83 -- PROCEDURE SUBMIT_LANE
84 --
85 -- Purpose: insert all pl/sql tables into fte_lane_* tables
86 ----------------------------------------------------------------------
87 PROCEDURE SUBMIT_LANE(x_status OUT NOCOPY NUMBER,
88 x_error_msg OUT NOCOPY VARCHAR2);
89
90
91 END FTE_LANE_LOADER;