[Home] [Help]
PACKAGE: APPS.JTF_TAE_ASSIGN_PUB
Source
1 Package JTF_TAE_ASSIGN_PUB AUTHID CURRENT_USER AS
2 /* $Header: jtftaeas.pls 120.0 2005/06/02 18:21:09 appldev ship $ */
3 ---------------------------------------------------------------------
4 -- Start of Comments
5 -- ---------------------------------------------------
6 -- PACKAGE NAME: JTF_TAE_ASSIGN_PUB
7 -- ---------------------------------------------------
8 -- PURPOSE
9 -- Joint task force applications territory manager public api's.
10 -- This package is a public API for getting winning territories
11 -- or territory resources using an input objects table as an assignment
12 -- target.
13 --
14 -- Procedures:
15 -- (see below for specification)
16 --
17 -- NOTES
18 -- This package is publicly available for use
19 --
20 -- HISTORY
21 -- 03/22/2002 EIHSU CREATED
22 --
23
24 -- ***************************************************
25 -- GLOBAL VARIABLES and RECORD TYPE DEFINITIONS
26 -- ***************************************************
27
28
29 -- ***************************************************
30 -- API Specifications
31 -- ***************************************************
32 -- api name : Get_Winners
33 -- type : public.
34 -- function : For all Territory Assignment request purposes.
35 -- pre-reqs : Territories needs to be setup first
36 -- notes: Generic public API for retreving any of the following
37 -- * Winning Resource Id's
38 -- * Winning Resource Names + Details
39 -- * Winning terr_id's
40 --
41 PROCEDURE get_winners
42 ( p_api_version_number IN NUMBER,
43 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
44 p_SQL_Trace IN VARCHAR2,
45 p_Debug_Flag IN VARCHAR2,
46 x_return_status OUT NOCOPY VARCHAR2,
47 x_msg_count OUT NOCOPY NUMBER,
48 x_msg_data OUT NOCOPY VARCHAR2,
49 p_request_id IN NUMBER,
50 p_source_id IN NUMBER,
51 p_trans_object_type_id IN NUMBER,
52 p_target_type IN VARCHAR2 := 'TAP',
53 ERRBUF OUT NOCOPY VARCHAR2,
54 RETCODE OUT NOCOPY VARCHAR2
55 );
56
57
58 -- ***************************************************
59 -- API Specifications
60 -- ***************************************************
61 -- api name : Drop_TAE_TRANS_Indexes
62 -- type : public.
63 -- function : Drop_TAE_TRANS_Indexes
64 -- pre-reqs :
65 -- notes:
66 --
67 PROCEDURE Drop_TAE_TRANS_Indexes
68 ( p_api_version_number IN NUMBER,
69 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
70 p_SQL_Trace IN VARCHAR2,
71 p_Debug_Flag IN VARCHAR2,
72 x_return_status OUT NOCOPY VARCHAR2,
73 p_source_id IN NUMBER,
74 p_trans_object_type_id IN NUMBER,
75 x_msg_count OUT NOCOPY NUMBER,
76 x_msg_data OUT NOCOPY VARCHAR2,
77 ERRBUF OUT NOCOPY VARCHAR2,
78 RETCODE OUT NOCOPY VARCHAR2
79 );
80
81 -- ***************************************************
82 -- API Specifications
83 -- ***************************************************
84 -- api name : NM_TABLE_TRUNCATE_DROP_INDEX
85 -- type : public.
86 -- function : NM_TABLE_TRUNCATE_DROP_INDEX
87 -- pre-reqs :
88 -- notes: BELOW API for NEW MODE TAP
89 --
90
91 PROCEDURE NM_TABLE_TRUNCATE_DROP_INDEX
92 ( p_api_version_number IN NUMBER,
93 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
94 p_SQL_Trace IN VARCHAR2,
95 p_Debug_Flag IN VARCHAR2,
96 p_table_name IN VARCHAR2,
97 x_return_status OUT NOCOPY VARCHAR2,
98 x_msg_count OUT NOCOPY NUMBER,
99 x_msg_data OUT NOCOPY VARCHAR2,
100 ERRBUF OUT NOCOPY VARCHAR2,
101 RETCODE OUT NOCOPY VARCHAR2
102 );
103
104
105 -- ***************************************************
106 -- API Specifications
107 -- ***************************************************
108 -- api name : FETCH_NM_REASSIGN_TRANS
109 -- type : public.
110 -- function : FETCH_NM_REASSIGN_TRANS
111 -- pre-reqs :
112 -- notes :
113 --
114
115 PROCEDURE FETCH_NM_REASSIGN_TRANS (
116 p_api_version_number IN NUMBER,
117 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
118 p_SQL_Trace IN VARCHAR2,
119 p_Debug_Flag IN VARCHAR2,
120 p_destination_table IN VARCHAR2,
121 p_source_id IN NUMBER,
122 p_qual_type_id IN NUMBER,
123 p_request_id IN NUMBER,
124 x_return_status OUT NOCOPY VARCHAR2,
125 x_msg_count OUT NOCOPY NUMBER,
126 x_msg_data OUT NOCOPY VARCHAR2,
127 ERRBUF OUT NOCOPY VARCHAR2,
128 RETCODE OUT NOCOPY VARCHAR2
129 );
130
131 -- ***************************************************
132 -- API Specifications
133 -- ***************************************************
134 -- api name : DELETE_CHANGED_TERR_RECS
135 -- type : public.
136 -- function : DELETE_CHANGED_TERR_RECS
137 -- pre-reqs :
138 -- notes :
139 --
140
141 PROCEDURE DELETE_CHANGED_TERR_RECS (
142 p_api_version_number IN NUMBER,
143 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
144 p_SQL_Trace IN VARCHAR2,
145 p_Debug_Flag IN VARCHAR2,
146 p_request_id IN VARCHAR2,
147 x_return_status OUT NOCOPY VARCHAR2,
148 x_msg_count OUT NOCOPY NUMBER,
149 x_msg_data OUT NOCOPY VARCHAR2,
150 ERRBUF OUT NOCOPY VARCHAR2,
151 RETCODE OUT NOCOPY VARCHAR2
152 );
153
154 -- ***************************************************
155 -- API Specifications
156 -- ***************************************************
157 -- api name : --
158 -- type : public.
159 -- function : --
160 -- pre-reqs :
161 -- notes: BELOW API for MULTI-NUM MULTI-LEVEL PROCESSING
162 --
163 PROCEDURE Process_Level_Winners (
164 p_terr_LEVEL_target_tbl IN VARCHAR2,
165 p_terr_PARENT_LEVEL_tbl IN VARCHAR2,
166 p_UPPER_LEVEL_FROM_ROOT IN NUMBER,
167 p_LOWER_LEVEL_FROM_ROOT IN NUMBER,
168 p_matches_target IN VARCHAR2,
169 p_source_id IN NUMBER,
170 p_qual_type_id IN NUMBER,
171 x_return_status OUT NOCOPY VARCHAR2,
172 p_worker_id IN NUMBER := 1
173 );
174
175 PROCEDURE Process_Final_Level_Winners (
176 p_terr_LEVEL_target_tbl IN VARCHAR2,
177 p_terr_L5_target_tbl IN VARCHAR2,
178 p_matches_target IN VARCHAR2,
179 p_source_id IN NUMBER,
180 p_qual_type_id IN NUMBER,
181 x_return_status OUT NOCOPY VARCHAR2,
182 p_worker_id IN NUMBER := 1
183 );
184
185 -- ***************************************************
186 -- API Specifications
187 -- ***************************************************
188 -- api name : Get_SQL_For_Changes
189 -- type : public.
190 -- function : Get_SQL_For_Changes
191 -- pre-reqs :
192 -- notes:
193 --
194 PROCEDURE Get_SQL_For_Changes (
195 p_source_id IN NUMBER,
196 p_trans_object_type_id IN NUMBER,
197 p_view_name IN VARCHAR2,
198 x_return_status OUT NOCOPY VARCHAR2,
199 p_sql OUT NOCOPY JTF_TAE_GEN_PVT.terrsql_tbl_type,
200 x_msg_count OUT NOCOPY NUMBER,
201 x_msg_data OUT NOCOPY VARCHAR2,
202 ERRBUF OUT NOCOPY VARCHAR2,
203 RETCODE OUT NOCOPY VARCHAR2
204 );
205
206
207 -- ***************************************************
208 -- API Specifications
209 -- ***************************************************
210 -- api name : Clear_trans_data
211 -- type : public.
212 -- function : Truncate Trans Table, and Drop_TAE_TRANS_Indexes
213 -- pre-reqs :
214 -- notes:
215 PROCEDURE Clear_Trans_Data
216 ( p_api_version_number IN NUMBER,
217 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
218 p_SQL_Trace IN VARCHAR2,
219 p_Debug_Flag IN VARCHAR2,
220 x_return_status OUT NOCOPY VARCHAR2,
221 p_source_id IN NUMBER,
222 p_trans_object_type_id IN NUMBER,
223 --ARPATEL 09/12/2003
224 p_target_type IN VARCHAR2 := 'TAP',
225 x_msg_count OUT NOCOPY NUMBER,
226 x_msg_data OUT NOCOPY VARCHAR2,
227 ERRBUF OUT NOCOPY VARCHAR2,
228 RETCODE OUT NOCOPY VARCHAR2
232 -- API Specifications
229 );
230
231 -- ***************************************************
233 -- ***************************************************
234 -- api name : GET_WINNERS_PARALLEL_SETUP
235 -- type : public.
236 -- function :
237 -- pre-reqs :
238 -- notes:
239 --
240 PROCEDURE get_winners_parallel_setup
241 ( p_api_version_number IN NUMBER,
242 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
243 p_SQL_Trace IN VARCHAR2,
244 p_Debug_Flag IN VARCHAR2,
245 x_return_status OUT NOCOPY VARCHAR2,
246 x_msg_count OUT NOCOPY NUMBER,
247 x_msg_data OUT NOCOPY VARCHAR2,
248 p_request_id IN NUMBER,
249 p_source_id IN NUMBER,
250 p_trans_object_type_id IN NUMBER,
251 p_target_type IN VARCHAR2 := 'TAP',
252 ERRBUF OUT NOCOPY VARCHAR2,
253 RETCODE OUT NOCOPY VARCHAR2
254 );
255
256
257 -- ***************************************************
258 -- API Specifications
259 -- ***************************************************
260 -- api name : GET_WINNERS_PARALLEL
261 -- type : public.
262 -- function :
263 -- pre-reqs :
264 -- notes: API designed to be called from multiple sessions
265 -- to parallel process assignment of transactions to territories
266 --
267 PROCEDURE GET_WINNERS_PARALLEL
268 ( p_api_version_number IN NUMBER,
269 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
270 p_SQL_Trace IN VARCHAR2,
271 p_Debug_Flag IN VARCHAR2,
272 x_return_status OUT NOCOPY VARCHAR2,
273 x_msg_count OUT NOCOPY NUMBER,
274 x_msg_data OUT NOCOPY VARCHAR2,
275 p_request_id IN NUMBER,
276 p_source_id IN NUMBER,
277 p_trans_object_type_id IN NUMBER,
278 p_target_type IN VARCHAR2 := 'TAP',
279 ERRBUF OUT NOCOPY VARCHAR2,
280 RETCODE OUT NOCOPY VARCHAR2,
281 p_worker_id IN NUMBER := 1,
282 p_total_workers IN NUMBER
283 );
284
285 END JTF_TAE_ASSIGN_PUB;
286