1 PACKAGE ASG_DEVICE_USER_PUB as
2 /* $Header: asgpusrs.pls 120.1 2005/08/12 02:55:51 saradhak noship $ */
3
4 --
5 -- NAME
6 -- ASG_DEVICE_USER_PUB
7 --
8 -- PURPOSE
9 -- Public API to ADD/DELETE/UPDATE/FIND Mobile Device User
10
11 G_Device_User_Id NUMBER ;
12 G_Last_Sync_Date DATE ;
13
14
15 TYPE device_user_rec_type IS RECORD
16 (DEVICE_USER_ID NUMBER ,
17 RESOURCE_ID NUMBER,
18 MOBILE_APPLICATION_ID NUMBER ,
19 CLIENT_NUMBER NUMBER ,
20 CLIENT_NAME VARCHAR2(30) ,
21 LAST_UPDATE_DATE DATE ,
22 LAST_UPDATED_BY NUMBER ,
23 CREATION_DATE DATE ,
24 CREATED_BY NUMBER ,
25 ORG_ID NUMBER ,
26 DEVICE_TAG VARCHAR2(30),
27 USER_ID NUMBER ,
28 SERVER_ID NUMBER ,
29 LAST_SYNCH_MODE NUMBER ,
30 ENABLED VARCHAR2(1),
31 UPGRADE NUMBER ,
32 REMOTE_DEVICE_NAME VARCHAR2(60),
33 ADDRESS_DEVICE_TYPE VARCHAR2(30),
34 ADDRESS_DEVICE_NAME VARCHAR2(240),
35 ONAIR_FLAG VARCHAR2(1) ,
36 LAST_SYNC_DATE DATE ,
37 LAST_WIRELESS_CONTACT_DATE DATE ,
38 RETRY_DATE DATE ,
39 BYTES_SENT_WIRELESS NUMBER ,
40 BYTES_RECEIVED_WIRELESS NUMBER ,
41 DEVICE_LOCKED VARCHAR2(1),
42 ACCESS_CODE VARCHAR2(240),
43 LANGUAGE VARCHAR2(4) ,
44 FLASH_MESSAGE_FLAG VARCHAR2(1)
45 );
46
47 TYPE DEVICE_USER_TBL_TYPE IS TABLE OF DEVICE_USER_REC_TYPE INDEX BY BINARY_INTEGER;
48
49 G_MISS_DEVICE_USER_REC device_user_rec_type ;
50
51 TYPE server_resource_rec_type IS RECORD
52 (SERVER_ID NUMBER ,
53 RESOURCE_ID NUMBER ,
54 LAST_UPDATE_DATE DATE ,
55 LAST_UPDATED_BY NUMBER ,
56 CREATION_DATE DATE ,
57 CREATED_BY NUMBER
58 );
59
60 TYPE SERVER_RESOURCE_TBL_TYPE IS TABLE OF SERVER_RESOURCE_REC_TYPE INDEX BY BINARY_INTEGER;
61
62 G_MISS_SERVER_RESOURCE_REC server_resource_rec_type;
63
64
65 TYPE device_user_desc_rec_type IS RECORD
66 (DEVICE_USER_ID NUMBER ,
67 MOBILE_APPLICATION_NAME VARCHAR2(240) ,
68 GATEWAY_SERVER_NAME VARCHAR2(240) ,
69 USER_NAME VARCHAR2(240) ,
70 FULL_NAME VARCHAR2(240) ,
71 LANGUAGE_DESC VARCHAR2(255)
72 );
73
74
75 G_MISS_DEVICE_USER_DESC_REC device_user_desc_rec_type;
76
77
78 TYPE DEVICE_USER_DESC_TBL_TYPE IS TABLE OF DEVICE_USER_DESC_REC_TYPE INDEX BY BINARY_INTEGER;
79
80 PROCEDURE Create_Device_User
81 ( p_api_version IN NUMBER ,
82 p_init_msg_list IN VARCHAR2 ,
83 p_commit IN VARCHAR2 ,
84 p_validation_level IN NUMBER ,
85 p_device_user_rec IN DEVICE_USER_REC_TYPE ,
86 x_return_status OUT nocopy VARCHAR2,
87 x_msg_count OUT nocopy NUMBER,
88 x_msg_data OUT nocopy VARCHAR2,
89 x_device_user_id OUT nocopy NUMBER
90 );
91
92 PROCEDURE Update_Device_User
93 ( p_api_version IN NUMBER ,
94 p_init_msg_list IN VARCHAR2 ,
95 p_commit IN VARCHAR2 ,
96 p_validation_level IN NUMBER ,
97 p_device_user_rec IN DEVICE_USER_REC_TYPE ,
98 x_return_status OUT nocopy VARCHAR2,
99 x_msg_count OUT nocopy NUMBER,
100 x_msg_data OUT nocopy VARCHAR2
101 );
102
103 PROCEDURE Delete_Device_User
104 ( p_api_version IN NUMBER ,
105 p_init_msg_list IN VARCHAR2 ,
106 p_commit IN VARCHAR2 ,
107 p_validation_level IN NUMBER ,
108 p_device_user_rec IN DEVICE_USER_REC_TYPE ,
109 x_return_status OUT nocopy VARCHAR2,
110 x_msg_count OUT nocopy NUMBER,
111 x_msg_data OUT nocopy VARCHAR2
112 );
113
114 PROCEDURE Delete_Mobile_User
115 ( p_api_version IN NUMBER ,
116 p_init_msg_list IN VARCHAR2 ,
117 p_commit IN VARCHAR2 ,
118 p_validation_level IN NUMBER ,
119 p_device_user_rec IN DEVICE_USER_REC_TYPE ,
120 x_return_status OUT nocopy VARCHAR2,
121 x_msg_count OUT nocopy NUMBER,
122 x_msg_data OUT nocopy VARCHAR2
123 );
124
125 -- Find all device users for p_synch_server_id
126 -- p_device_user_rec may be used in the future
127
128 PROCEDURE Get_Device_User
129 ( p_api_version IN NUMBER ,
130 p_init_msg_list IN VARCHAR2 ,
131 p_commit IN VARCHAR2 ,
132 p_user_name IN VARCHAR2 ,
133 p_device_user_rec IN DEVICE_USER_REC_TYPE ,
134 x_return_status OUT nocopy VARCHAR2,
135 x_msg_count OUT nocopy NUMBER,
136 x_msg_data OUT nocopy VARCHAR2,
137 x_rec_count OUT nocopy NUMBER,
138 x_device_user_tbl OUT nocopy DEVICE_USER_TBL_TYPE,
139 x_device_user_desc_tbl OUT nocopy DEVICE_USER_DESC_TBL_TYPE
140 );
141
142 FUNCTION Get_Last_Sync_Date
143 ( p_device_user_id IN NUMBER
144 ) RETURN DATE;
145
146 PROCEDURE Set_Last_Sync_Date
147 ( p_device_user_id IN NUMBER ,
148 p_last_sync_date IN DATE
149 );
150
151 FUNCTION Get_Device_User_Id
152 ( p_mobile_user_name IN VARCHAR2
153 ) RETURN NUMBER;
154
155 FUNCTION Get_User_Id
156 ( p_device_user_id IN NUMBER
157 ) RETURN NUMBER;
158
159 FUNCTION Get_User_Name
160 ( p_device_user_id IN NUMBER
161 ) RETURN VARCHAR2;
162
163 FUNCTION Get_Language
164 ( p_device_user_id IN NUMBER
165 ) RETURN VARCHAR2;
166
167
168 END ASG_DEVICE_USER_PUB;