1 PACKAGE FTE_PARCEL_LOADER AS
2 /* $Header: FTEPCLDS.pls 120.0 2005/06/28 02:25:50 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 (Rating zone chart, rating setup, orign, destination)
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_RATING_ZONE_CHART
27 --
28 -- Purpose: process the lines in p_table for rating zone chart
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_RATING_ZONE_CHART(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_RATING_SETUP
46 --
47 -- Purpose: process the lines in p_table for 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_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_ORIGIN
65 --
66 -- Purpose: process the lines in p_table for origin
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_ORIGIN(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 PROCESS_DESTINATION
84 --
85 -- Purpose: process the lines in p_table for destination
86 --
87 -- IN parameters:
88 -- 1. p_table: pl/sql table of STRINGARRAY containing the block information
89 -- 2. p_line_number: line number for the beginning of the block
90 --
91 -- OUT parameters:
92 -- 1. x_status: status of the processing, -1 means no error
93 -- 2. x_error_msg: error message if any.
94 ----------------------------------------------------------------------------
95 PROCEDURE PROCESS_DESTINATION(p_block_data IN FTE_BULKLOAD_PKG.block_data_tbl,
96 p_line_number IN NUMBER,
97 x_status OUT NOCOPY NUMBER,
98 x_error_msg OUT NOCOPY VARCHAR2);
99
100 TYPE service_array IS VARRAY (10) OF NUMBER;
101
102 ----------------------------------------------------------------------------
103 -- PROCEDURE PROCESS_ZONES_AND_LANES
104 --
105 -- Purpose: make the zones and lanes
106 --
107 -- OUT parameters:
108 -- 1. x_status: status of the processing, -1 means no error
109 -- 2. x_error_msg: error message if any.
110 --
111 ----------------------------------------------------------------------------
112 PROCEDURE PROCESS_ZONES_AND_LANES(x_status OUT NOCOPY NUMBER,
113 x_error_msg OUT NOCOPY VARCHAR2);
114
115 END FTE_PARCEL_LOADER;