1 PACKAGE BODY ASG_MOBTRAN AS
2 /* $Header: asgmotb.pls 120.1 2005/08/12 02:47:42 saradhak noship $*/
3
4 -- DESCRIPTION
5 -- This package allows MDG machines to send mobile changes
6 -- to the enteprise for processiong.
7 -- In order to mantain data integrity this package works under the
8 -- boundaries of mobile transactions.
9 --
10 -- A mobile transaction, contains all changes made by a mobile
11 -- device during a replication session. The transaction is logicaly
12 -- devided in objects, Rows, and Columns. Objects map to publications,
13 -- rows map to the mobile changed record, and columns map to the
14 -- columns of the record.
15 --
16 --
17 --
18 -- HISTORY
19 -- 09-nov-01 vekrishn Set MAX_TRANSACTIONS to 150
20 -- 09-nov-01 vekrishn Fix for Queue data loss
21 -- 10-sep-01 vekrishn Pass session_id/device_userid in Begin/End txn
22 -- 01-jun-01 vekrishn Support for Begin/End Transactions
23 -- 01-may-01 vekrishn Set MAX_TRANSACTIONS to 50
24 -- 22-apr-01 vekrishn Support for Deferred transactions
25 -- 25-jul-00 W Chin Modified Get_Handler_for_Object function.
26 -- 10-mar-00 D Cassinera Started adding support for full duplex
27 -- mode and RPC payload type
28 -- 15-dec-99 D Cassinera Created.
29 --
30
31
32 -- Java Stored Procedures Used by this package.
33 Function Call_Object_Processor(wrapper IN varchar2,func in varchar2,session_id in number, mobile_user_id in number ) RETURN number is
34 begin
35 return null;
36 end;
37
38 Function beginTransactionJ (trans_id IN number, user IN number, source in varchar2) return number is
39 begin
40 return null;
41 end;
42
43 Function commitTransactionJ (trans_id IN number) return number is
44 begin
45 return null;
46 end;
47
48 Function rollbackTransactionJ (trans_id IN number) return number is
49 begin
50 return null;
51 end;
52
53 Function setObjectJ (trans_id IN number,name in varchar2, metadata in varchar2) return number is
54 begin
55 return null;
56 end;
57
58 Function unsetObjectJ (trans_id IN number) return number is
59 begin
60 return null;
61 end;
62
63 Function addRowJ (trans_id IN number,row_id in number,dml in varchar2) return number is
64 begin
65 return null;
66 end;
67
68 Function pushRowJ (trans_id IN number) return number is
69 begin
70 return null;
71 end;
72
73 Function popRowJ (trans_id IN number) return number is
74 begin
75 return null;
76 end;
77
78
79 Function putStringJ (trans_id IN number,data in varchar2) return number is
80 begin
81 return null;
82 end;
83
84 Function putNumberJ (trans_id IN number,data in number) return number is
85 begin
86 return null;
87 end;
88
89 Function putDateJ (trans_id IN number,data in DATE) return number is
90 begin
91 return null;
92 end;
93
94 Function getEnterpriseGlobalName return varchar2 is
95 begin
96 return null;
97 end;
98
99 Function openReader (data in BLOB) return number is
100 begin
101 return null;
102 end;
103
104 Function closeReader (dequeue_session IN number) return number is
105 begin
106 return null;
107 end;
108
109 Function parse (dequeue_session IN number) return number is
110 begin
111 return null;
112 end;
113
114 Function getTransactionId (dequeue_session IN number) return number is
115 begin
116 return null;
117 end;
118
119 Function getSourceGlobalName (dequeue_session IN number) return VARCHAR2 is
120 begin
121 return null;
122 end;
123
124 Function getTimeStamp (dequeue_session IN number) return date is
125 begin
126 return null;
127 end;
128
129 Function getNextObject (dequeue_session IN number) return VARCHAR2 is
130 begin
131 return null;
132 end;
133
134 Function getObjectName (dequeue_session IN number) return VARCHAR2 is
135 begin
136 return null;
137 end;
138
139 Function getObjectMetadata (dequeue_session IN number) return VARCHAR2 is
140 begin
141 return null;
142 end;
143
144 Function getNextDML (dequeue_session IN number) return VARCHAR2 is
145 begin
146 return null;
147 end;
148
149 Function getDML (dequeue_session IN number) return VARCHAR2 is
150 begin
151 return null;
152 end;
153
154 Function getRecID (dequeue_session IN number) return number is
155 begin
156 return null;
157 end;
158
159 Function getColumns (dequeue_session IN number) return number is
160 begin
161 return null;
162 end;
163
164 Function NextColumn (dequeue_session IN number) return number is
165 begin
166 return null;
167 end;
168
169 Function getString (dequeue_session IN number) return VARCHAR2 is
170 begin
171 return null;
172 end;
173
174 Function getCHAR (dequeue_session IN number) return VARCHAR2 is
175 begin
176 return null;
177 end;
178
179 Function getNUMBER (dequeue_session IN number) return number is
180 begin
181 return null;
182 end;
183
184 Function getDATE (dequeue_session IN number) return DATE is
185 begin
186 return null;
187 end;
188
189 Function getConnectedUserId (mobile_user_id IN number) return number is
190 begin
191 return null;
192 end;
193
194 Function getMobileUserId (mobile_user_id IN varchar2) return number is
195 begin
196 return null;
197 end;
198
199 Function setFndProfile (user_id IN number) return number is
200 begin
201 return null;
202 end;
203
204 Function enableWrapperDebug (PlsqlPackage IN varchar2) return number is
205 begin
206 return null;
207 end;
208
209 Function disableWrapperDebug (PlsqlPackage IN varchar2) return number is
210 begin
211 return null;
212 end;
213
214
215 Function getExecLocation (holer in number) return number is
216 begin
217 return null;
218 end;
219
220 Function getQueueHomeSchema return varchar2 is
221 begin
222 return null;
223 end;
224
225 PROCEDURE set_last_sync_date (mobile_user_id in number) is
226 begin
227 null;
228 end;
229
230 PROCEDURE enableDebug is
231 begin
232 null;
233 end;
234
235 Function getTransHandler (mobile_user_id in number) return varchar2 is
236 begin
237 return null;
238 end;
239
240 PROCEDURE disableDebug is
241 begin
242 null;
243 end;
244
245
246 /*
247 The following function its used to check if a mobile update can be applied
248 to the database. In order for a mobile update to be applied, the record
249 which is beeing updated MUST have a lower value for its last_update column
250 that the user last_sync_date.
251 */
252 Function check_TimeStamp (ObjectName in varchar2, user in number,
253 pk_col1 in varchar2, pk_val1 in number,
254 pk_col2 in varchar2, pk_val2 in number,
255 pk_col3 in varchar2, pk_val3 in number,
256 pk_col4 in varchar2, pk_val4 in number,
257 pk_col5 in varchar2, pk_val5 in number,
258 pk_col6 in varchar2, pk_val6 in number
259 ) return number is
260 begin
261 return null;
262 end;
263
264
265
266
267 Function Get_Handler_for_Object (name in varchar2) return varchar2 is
268 begin
269 return null;
270 end;
271
272 Function run_command( p_command in varchar2 ) return number Is
273 begin
274 return null;
275 END run_command;
276
277 /*--------------------------------------------------------------------------------------
278 FUNCTIONS TO CHECK AND SUBMIT REPLY HANDLER JOB
279 -------------------------------------------------------------------------------------- */
280 PROCEDURE SUBMIT_REPLY_PROCESSOR is
281 begin
282 null;
283 END Submit_REPLY_PROCESSOR;
284
285
286 PROCEDURE ENABLE_REPLY_PROCESSING is
287 BEGIN
288 null;
289 END ENABLE_REPLY_PROCESSING;
290
291 PROCEDURE QUEUE_MESSAGE (transaction in NUMBER, local_copy in number )is
292 BEGIN
293 null;
294 END QUEUE_MESSAGE;
295
296 PROCEDURE QUEUE_REPLY (destination in sys.aq$_agent, reply in NUMBER) is
297 BEGIN
298 null;
299 END QUEUE_REPLY;
300
301 FUNCTION dequeue_transaction RETURN NUMBER is
302 BEGIN
303 return null;
304 END dequeue_transaction;
305
306 FUNCTION rmqueue_transaction RETURN NUMBER IS
307 BEGIN
308 return null;
309 END rmqueue_transaction;
310
311
312 PROCEDURE purge_queue_transactions (p_que_cnt IN NUMBER) IS
313 BEGIN
314 null;
315 END purge_queue_transactions;
316
317
318 Function DEQUEUE_REPLY return NUMBER is
319 BEGIN
320 return null;
321 end;
322
323 PROCEDURE setServerAgent is
324 begin
325 null;
326 end;
327
328
329 PROCEDURE setExecMode is
330 begin
331 null;
332 end;
333
334 Function Generate_Reply_Address (SourceAddress in varchar2) return varchar2 is
335 begin
336 return null;
337 end Generate_Reply_Address;
338
339
340 PROCEDURE CREATE_TRANSACTION_BUFFER is
341 BEGIN
342 null;
343 END CREATE_TRANSACTION_BUFFER;
344
345 PROCEDURE CHECK_TRANSACTION IS
346 BEGIN
347 null;
348 END CHECK_TRANSACTION;
349
350
351 PROCEDURE FREE_TRANSACTION IS
352 BEGIN
353 null;
354 END FREE_TRANSACTION;
355
356
357 PROCEDURE CHECK_OBJECT IS
358 BEGIN
359 null;
360 END CHECK_OBJECT;
361
362 PROCEDURE CHECK_ROW IS
363 BEGIN
364 null;
365 END CHECK_ROW;
366
367 PROCEDURE CHECK_NO_ROW IS
368 BEGIN
369 null;
370 END CHECK_NO_ROW;
371
372 Procedure Set_Short_Error_message (dequeue_session IN number, message in varchar2) is
373 begin
374 null;
375 end;
376
377 Procedure Set_Longer_Error_message (dequeue_session IN number, message in varchar2) is
378 begin
379 null;
380 end;
381
382 PROCEDURE BeginTransaction (trans_id IN number, transaction_owner in varchar2) IS
383 BEGIN
384 null;
385 end BeginTransaction;
386
387 PROCEDURE CommitTransaction is
388 BEGIN
389 null;
390 END CommitTransaction;
391
392 PROCEDURE RollBackTransaction IS
393 BEGIN
394 null;
395 END RollBackTransaction;
396
397 Procedure SetObject (object_name in varchar2, metadata in varchar2) is
398 begin
399 null;
400 end SetObject;
401
402 PROCEDURE UnsetObject is
403 begin
404 null;
405 end UnsetObject;
406
407 Procedure AddRow (row_id number,dml in varchar2) is
408 begin
409 null;
410 end AddRow;
411
412 Procedure PushRow is
413 begin
414 null;
415 end PushRow;
416
417 Procedure PopRow is
418 begin
419 null;
420 end PopRow;
421
422 Procedure putString (data in varchar2) is
423 begin
424 null;
425 end putString;
426
427 Procedure putNumber (data in NUMBER) is
428 begin
429 null;
430 end putNumber;
431
432 Procedure putDate (data in DATE) is
433 begin
434 null;
435 end putDate;
436
437 Function putLob (data in BLOB) return number is
438 begin
439 return null;
440 end;
441
442
443 Function Get_Incoming_BLOB return BLOB is
444 begin
445 return null;
446 end Get_Incoming_BLOB;
447
448 Function Get_Incoming_BLOB_LENGTH return number is
449 begin
450 return null;
451 end Get_Incoming_BLOB_LENGTH;
452
453 Function GetBLOB return BLOB is
454 begin
455 return null;
456 end GetBLOB;
457
458 Function GetBLOBl return number is
459 begin
460 return null;
461 end;
462
463
464
465 FUNCTION Exec_handler (MObject IN VARCHAR2, Session_id IN NUMBER,
466 mobile_user_id IN NUMBER) RETURN NUMBER
467 IS
468 BEGIN
469 return null;
470 END Exec_handler;
471
472
473
474 PROCEDURE DML_MESSAGE_PROCESSOR (incomming_message in NUMBER )
475 IS
476 BEGIN
477 null;
478 END DML_MESSAGE_PROCESSOR;
479
480
481 PROCEDURE RPC_PROCESSOR_REQUEST (rpc in NUMBER) is
482 BEGIN
483 null;
484 end RPC_PROCESSOR_REQUEST;
485
486 PROCEDURE RPC_PROCESSOR_REPLY (reply in NUMBER) is
487 BEGIN
488 null;
489 end RPC_PROCESSOR_REPLY;
490
491 PROCEDURE RPC_PROCESSOR (rpc in NUMBER) is
492 begin
493 null;
494 end RPC_PROCESSOR;
495
496
497 PROCEDURE DML_REPLY_PROCESSOR (incoming_reply in NUMBER) is
498 begin
499 null;
500 end DML_REPLY_PROCESSOR;
501
502 PROCEDURE PROCESS_QUEUE_TRANSACTION IS
503 BEGIN
504 null;
505 end PROCESS_QUEUE_TRANSACTION;
506
507 PROCEDURE process_queue_transaction (debug_flag IN CHAR) IS
508 BEGIN
509 null;
510 END process_queue_transaction;
511
512 PROCEDURE REPLY_PROCESSOR
513 is
514 begin
515 null;
516 end REPLY_PROCESSOR;
517
518
519 Function DoRpc (destination_global_name in varchar2, /* global name where to execute */
520 Remote_PROCEDURE in varchar2, /* PROCEDURE to call */
521 Call_back_PROCEDURE in varchar2, /* PROCEDURE to call with the result */
522 who in varchar2 /* who requested the rpc */
523 ) return number
524 is
525 begin
526 return null;
527 end DoRpc;
528
529 PROCEDURE Enable_Debug is
530 begin
531 null;
532 end Enable_Debug;
533
534 PROCEDURE Disable_Debug is
535 begin
536 null;
537 end Disable_Debug;
538
539 Procedure Purge_Queue (queue in number) is
540 begin
541 null;
542 end Purge_Queue;
543
544 begin
545 null;
546 END ASG_MOBTRAN;