1 PACKAGE BODY JTM_HANDHELD_WRAPPER_PKG
2 /* $Header: jtmhwrpb.pls 120.1 2006/01/13 01:17:37 utekumal noship $*/
3 AS
4 --
5 -- To modify this template, edit file PKGBODY.TXT in TEMPLATE
6 -- directory of SQL Navigator
7 --
8 -- Purpose: Briefly explain the functionality of the package body
9 --
10 -- MODIFICATION HISTORY
11 -- Person Date Comments
12 -- --------- ------ ------------------------------------------
13 -- Enter procedure, function bodies as shown below
14 /*** Globals ***/
15 g_debug_level NUMBER; -- debug level
16 g_object_name CONSTANT VARCHAR2(30) := 'CSM_SERVICEP_WRAPPER_PKG';
17
18
19 /***
20 This procedure is called by ASG_APPLY.PROCESS_UPLOAD when a publication item for publication SERVICEL
21 is dirty. This happens when a mobile field service device executed DML on an updatable table and did
22 a fast sync. This procedure will detect which publication items got dirty and will execute the wrapper
23 procedures which will insert the data that came from mobile into the backend tables using public APIs.
24 ***/
25 PROCEDURE APPLY_CLIENT_CHANGES
26 (
27 p_user_name IN VARCHAR2,
28 p_tranid IN NUMBER
29 ) IS
30 BEGIN
31
32 null ;
33 END APPLY_CLIENT_CHANGES;
34
35
36
37
38 /**
39 * POPULATE_ACCESS_RECORDS
40 * is the bootstrap procedure called by MDG upon CSM user creation
41 * we need to iterate over the responsibilities assigned to this CSM user
42 * and call the CSM_WF_PKG.User_Resp_Post_Ins(user_id, resp_id)
43 */
44 PROCEDURE POPULATE_ACCESS_RECORDS ( p_userid IN NUMBER)
45 IS
46 BEGIN
47 null ;
48 END POPULATE_ACCESS_RECORDS; -- end POPULATE_ACCESS_RECORDS
49
50 /**
51 * DELETE_ACCESS_RECORDS
52 * is the bootstrap procedure called by MDG upon CSM user deletion
53 * we need to iterate over the responsibilities assigned to this CSM user
54 * and call the CSM_WF_PKG.User_Resp_Post_Ins(user_id, resp_id)
55 */
56 PROCEDURE DELETE_ACCESS_RECORDS ( p_userid in number)
57 IS
58 BEGIN
59 null ;
60 END DELETE_ACCESS_RECORDS; -- end DELETE_ACCESS_RECORDS
61
62 /*
63 Call back function for ASG. used for create synonyms / grant accesses in mobileadmin schema
64 before running installation manager
65 */
66 FUNCTION CHECK_OLITE_SCHEMA RETURN VARCHAR2 IS
67 l_count NUMBER;
68 BEGIN
69 SELECT count(1) INTO l_count
70 FROM all_synonyms
71 WHERE SYNONYM_NAME = 'FND_GLOBAL' and owner = 'MOBILEADMIN';
72 IF l_count = 0 THEN
73 -- csm_util_pkg.log(' synonym mobileadmin.FND_GLOBAL does not exist');
74 EXECUTE IMMEDIATE 'create synonym mobileadmin.FND_GLOBAL for FND_GLOBAL';
75 END IF;
76
77 RETURN 'Y';
78
79 EXCEPTION
80 WHEN OTHERS THEN
81 RETURN 'N';
82 END CHECK_OLITE_SCHEMA;
83
84 -- Enter further code below as specified in the Package spec.
85 END JTM_HANDHELD_WRAPPER_PKG;
[Home] [Help]