[Home] [Help]
PACKAGE: APPS.FTE_SERVICES_UI_WRAPPER
Source
1 PACKAGE FTE_SERVICES_UI_WRAPPER AS
2 /* $Header: FTEUIWPS.pls 120.0 2005/06/29 19:02:07 jishen noship $ */
3
4 c_precedence_low CONSTANT NUMBER := 180;
5 c_precedence_mid CONSTANT NUMBER := 200;
6 c_precedence_high CONSTANT NUMBER := 220;
7
8
9 TYPE LANE_REC IS RECORD (
10 LANE_ID NUMBER,
11 SERVICE_NUMBER VARCHAR2(100),
12 RATE_CHART_TYPE VARCHAR2(100),
13 TRANSPORT_MODE VARCHAR2(100),
14 START_DATE_ACTIVE DATE,
15 END_DATE_ACTIVE DATE,
16 CARRIER_ID NUMBER,
17 SERVICE_TYPE_CODE VARCHAR2(100),
18 ORIGIN_ID NUMBER,
19 DESTINATION_ID NUMBER,
20 LANE_TYPE VARCHAR2(100)
21 );
22
23 TYPE LANE_TABLE IS TABLE OF
24 LANE_REC
25 INDEX BY BINARY_INTEGER;
26
27 TYPE rate_chart_header_rec IS RECORD (
28 CHART_NAME VARCHAR2(100),
29 CURRENCY_CODE VARCHAR2(100),
30 CARRIER_ID NUMBER,
31 SERVICE_LEVEL VARCHAR2(100),
32 LIST_HEADER_ID NUMBER,
33 START_DATE_ACTIVE DATE,
34 END_DATE_ACTIVE DATE,
35 DESCRIPTION VARCHAR2(2000)
36 );
37
38 TYPE rate_chart_header_table IS TABLE OF
39 rate_chart_header_rec
40 INDEX BY BINARY_INTEGER;
41
42 g_list_header_id NUMBER;
43
44 TYPE rate_chart_line_rec IS RECORD (
45 LINE_NUM NUMBER,
46 TYPE VARCHAR2(100),
47 SUBTYPE VARCHAR2(100),
48 RATE_TYPE VARCHAR2(30),
49 BREAK_TYPE VARCHAR2(30),
50 ORIGIN_ID NUMBER,
51 DEST_ID NUMBER,
52 CATG_ID NUMBER,
53 SERVICE_CODE VARCHAR2(100),
54 MULTI_FLAG VARCHAR2(10),
55 RATE_BASIS VARCHAR2(30),
56 RATE_BASIS_UOM VARCHAR2(30),
57 DIST_TYPE VARCHAR2(100),
58 VEHICLE_TYPE NUMBER,
59 RATE NUMBER,
60 MIN_CHARGE NUMBER,
61 START_DATE DATE,
62 END_DATE DATE,
63 DESCRIPTION VARCHAR2(200)
64 );
65
66 TYPE rate_chart_line_table IS TABLE OF
67 rate_chart_line_rec
68 INDEX BY BINARY_INTEGER;
69
70 TYPE rate_chart_break_rec IS RECORD (
71 BREAK_HEADER_INDEX NUMBER,
72 LOWER NUMBER,
73 UPPER NUMBER,
74 RATE_TYPE VARCHAR2(30),
75 RATE NUMBER
76 );
77
78 TYPE rate_chart_break_table IS TABLE OF
79 rate_chart_break_rec
80 INDEX BY BINARY_INTEGER;
81
82 TYPE tl_line_rec IS RECORD (
83 LINE_NUM NUMBER,
84 TYPE VARCHAR2(100),
85 REGION_CODE NUMBER,
86 BASIS VARCHAR2(30),
87 BASIS_UOM_CODE VARCHAR2(30),
88 CHARGE NUMBER,
89 MIN_CHARGE NUMBER,
90 START_DATE DATE,
91 END_DATE DATE,
92 FREE_STOPS NUMBER,
93 FIRST_STOP NUMBER,
94 SECOND_STOP NUMBER,
95 THIRD_STOP NUMBER,
96 FOURTH_STOP NUMBER,
97 FIFTH_STOP NUMBER,
98 ADD_STOPS NUMBER
99 );
100
101 TYPE tl_line_table IS TABLE OF
102 tl_line_rec
103 INDEX BY BINARY_INTEGER;
104
105
106
107 --------------------------------------------------------
108 -- PROCEDURE EDIT_TL_SERVICES
109 --
110 -- Purpose: convert UI data into pl/sql tables and insert into the database
111 --
112 -- IN parameters:
113 -- 1. p_init_msg_list:
114 -- 2. p_transaction_type:
115 -- 3. p_lane_table: lane table info
116 -- 4. p_rate_chart_header_table: rate chart header info
117 -- 5. p_rate_chart_line_table: rate chart line info
118 --
119 -- OUT parameters:
120 -- 1. x_status:
121 -- 2. x_error_msg:
122 --------------------------------------------------------
123 PROCEDURE Edit_TL_Services(
124 P_INIT_MSG_LIST IN VARCHAR2,
125 P_TRANSACTION_TYPE IN VARCHAR2,
126 P_LANE_TABLE IN LANE_TABLE,
127 P_RATE_CHART_HEADER_TABLE IN rate_chart_header_table,
128 P_RATE_CHART_LINE_TABLE IN rate_chart_line_table,
129 X_STATUS OUT NOCOPY NUMBER,
130 X_ERROR_MSG OUT NOCOPY VARCHAR2
131 );
132
133 --------------------------------------------------------
134 -- PROCEDURE RATE_CHART_WRAPPER
135 --
136 -- Purpose: convert UI data into pl/sql tables and insert into the database
137 --
138 -- IN parameters:
139 -- 1. p_header_table: header info table
140 -- 2. p_line_table: line info table
141 -- 3. p_break_table: break info table
142 -- 4. p_chart_type: the chart type (RC or MOD)
143 --
144 -- OUT parameters:
145 -- 1. x_status: status, -1 means no error
146 -- 2. x_error_msg: error message if any
147 --------------------------------------------------------
148 PROCEDURE RATE_CHART_WRAPPER( p_header_table IN rate_chart_header_table,
149 p_line_table IN rate_chart_line_table,
150 p_break_table IN rate_chart_break_table,
151 p_chart_type IN VARCHAR2,
152 x_status OUT NOCOPY NUMBER,
153 x_error_msg OUT NOCOPY VARCHAR2);
154
155 --------------------------------------------------------
156 -- PROCEDURE TL_SURCHARGE_WRAPPER
157 --
158 -- Purpose: convert UI data into pl/sql tables and insert into the database
159 --
160 -- IN parameters:
161 -- 1. p_header_table: header info table
162 -- 2. p_tl_line_table: line info table
163 -- 3. p_break_table: break info table
164 --
165 -- OUT parameters:
166 -- 1. x_status: status, -1 means no error
167 -- 2. x_error_msg: error message if any
168 --------------------------------------------------------
169 PROCEDURE TL_SURCHARGE_WRAPPER( p_header_table IN rate_chart_header_table,
170 p_tl_line_table IN tl_line_table,
171 p_break_table IN rate_chart_break_table,
172 p_action IN VARCHAR2,
173 x_status OUT NOCOPY NUMBER,
174 x_error_msg OUT NOCOPY VARCHAR2);
175
176 END FTE_SERVICES_UI_WRAPPER;