1 PACKAGE ASG_LOGGING_PUB AUTHID CURRENT_USER as
2 /* $Header: asgplogs.pls 120.2 2011/01/10 11:21:36 saradhak ship $ */
3
4 --
5 -- NAME
6 -- ASG_LOGGING_PUB
7 --
8 -- PURPOSE
9 -- Public API to ADD/DELETE/UPDATE/GET error or notification logs
10 -- HISTORY
11 -- 02-JAN-2002 ytian Removed the reference to security_group_id
12 -- 28-jun-2001 vekrishn New Api's to Log Error for Sales,
13 -- added Security Group ID to RECORD TYPE.
14 -- 11-apr-2000 wechin Created.
15
16
17 TYPE LOG_ENTRY_REC_TYPE IS RECORD
18 ( MOBILE_ERROR_ID NUMBER,
19 LAST_UPDATE_DATE DATE ,
20 LAST_UPDATED_BY NUMBER ,
21 CREATION_DATE DATE ,
22 CREATED_BY NUMBER ,
23 DEVICE_USER_ID NUMBER ,
24 TYPE VARCHAR2(30) ,
25 PRIORITY NUMBER ,
26 STATUS VARCHAR2(1),
27 APPLICATION_ID NUMBER ,
28 RESPONSIBILITY_ID NUMBER ,
29 SYNCHRONOUS_EVENT VARCHAR2(1),
30 ERROR_DAYS_DEFAULT NUMBER ,
31 ERROR_TIME_DEFAULT VARCHAR2(6),
32 ERROR_DESCRIPTION VARCHAR2(2048)
33 );
34
35 TYPE LOG_ENTRY_TBL_TYPE IS TABLE OF LOG_ENTRY_REC_TYPE INDEX BY BINARY_INTEGER;
36
37 G_MISS_LOG_ENTRY_REC LOG_ENTRY_REC_TYPE;
38
39 TYPE LOG_ENTRY_DESC_REC_TYPE IS RECORD
40 ( MOBILE_ERROR_ID NUMBER,
41 MOBILE_USER_NAME VARCHAR2(240),
42 USER_NAME VARCHAR2(240),
43 GATEWAY_SERVER_NAME VARCHAR2(240),
44 MOBILE_APPLICATION_NAME VARCHAR2(240)
45 );
46
47 TYPE LOG_ENTRY_DESC_TBL_TYPE IS TABLE OF LOG_ENTRY_DESC_REC_TYPE INDEX BY BINARY_INTEGER;
48
49 G_MISS_LOG_ENTRY_DESC_REC LOG_ENTRY_DESC_REC_TYPE;
50
51 -- Detailed Error Record Type
52 TYPE DETAIL_LOG_ENTRY_REC_TYPE IS RECORD
53 ( MOBILE_ERROR_ID NUMBER ,
54 ERROR_DETAIL_ID NUMBER ,
55 LAST_UPDATE_DATE DATE ,
56 LAST_UPDATED_BY NUMBER ,
57 CREATION_DATE DATE ,
58 CREATED_BY NUMBER ,
59 TYPE VARCHAR2(1),
60 ERROR_DESCRIPTION VARCHAR2(2048)
61 );
62
63 PROCEDURE Create_Log_Entry
64 ( p_api_version IN NUMBER ,
65 p_init_msg_list IN VARCHAR2 ,
66 p_commit IN VARCHAR2 ,
67 p_validation_level IN NUMBER ,
68 p_log_entry_rec IN LOG_ENTRY_REC_TYPE ,
69 x_return_status OUT nocopy VARCHAR2,
70 x_msg_count OUT nocopy NUMBER,
71 x_msg_data OUT nocopy VARCHAR2,
72 x_mobile_error_id OUT nocopy NUMBER
73 );
74
75 PROCEDURE Update_Log_Entry
76 ( p_api_version IN NUMBER ,
77 p_init_msg_list IN VARCHAR2 ,
78 p_commit IN VARCHAR2 ,
79 p_validation_level IN NUMBER ,
80 p_log_entry_rec IN LOG_ENTRY_REC_TYPE ,
81 x_return_status OUT nocopy VARCHAR2,
82 x_msg_count OUT nocopy NUMBER,
83 x_msg_data OUT nocopy VARCHAR2
84 );
85
86 PROCEDURE Delete_Log_Entry
87 ( p_api_version IN NUMBER ,
88 p_init_msg_list IN VARCHAR2 ,
89 p_commit IN VARCHAR2 ,
90 p_validation_level IN NUMBER ,
91 p_log_entry_rec IN LOG_ENTRY_REC_TYPE ,
92 x_return_status OUT nocopy VARCHAR2,
93 x_msg_count OUT nocopy NUMBER,
94 x_msg_data OUT nocopy VARCHAR2
95 );
96
97 PROCEDURE Get_Log_Entry
98 ( p_api_version IN NUMBER ,
99 p_init_msg_list IN VARCHAR2 ,
100 p_commit IN VARCHAR2 ,
101 p_validation_level IN NUMBER ,
102 p_user_name IN VARCHAR2 ,
103 p_mobile_application_id IN NUMBER ,
104 p_server_id IN NUMBER ,
105 p_log_entry_rec IN LOG_ENTRY_REC_TYPE ,
106 x_return_status OUT nocopy VARCHAR2,
107 x_msg_count OUT nocopy NUMBER,
108 x_msg_data OUT nocopy VARCHAR2,
109 x_rec_count OUT nocopy NUMBER,
110 x_log_entry_tbl OUT nocopy LOG_ENTRY_TBL_TYPE,
111 x_log_entry_desc_tbl OUT nocopy LOG_ENTRY_DESC_TBL_TYPE
112 );
113
114
115 -- Additions for Null Synch
116
117 TYPE CLIENT_REC_TYPE IS RECORD
118 (
119 MOBILE_USER_NAME VARCHAR2(100) ,
120 LAST_UPDATE_DATE DATE ,
121 LAST_UPDATED_BY NUMBER ,
122 CREATION_DATE DATE ,
123 CREATED_BY NUMBER
124 );
125
126 TYPE CLIENT_TBL_TYPE IS TABLE OF CLIENT_REC_TYPE INDEX BY BINARY_INTEGER;
127
128 G_MISS_CLIENT_REC CLIENT_REC_TYPE;
129
130 PROCEDURE Make_Null_Synch_Entry
131 ( p_api_version IN NUMBER ,
132 p_init_msg_list IN VARCHAR2 ,
133 p_commit IN VARCHAR2 ,
134 p_validation_level IN NUMBER ,
135 p_client_rec IN CLIENT_REC_TYPE ,
136 x_return_status OUT nocopy VARCHAR2,
137 x_msg_count OUT nocopy NUMBER,
138 x_msg_data OUT nocopy VARCHAR2
139 );
140
141
142 PROCEDURE Create_Master_Log_Entry
143 (
144 p_log_entry_rec IN LOG_ENTRY_REC_TYPE,
145 x_mobile_error_id OUT nocopy NUMBER,
146 x_return_status OUT nocopy NUMBER
147 );
148
149 PROCEDURE Create_Detail_Log_Entry (
150 p_detail_log_entry_rec IN DETAIL_LOG_ENTRY_REC_TYPE,
151 x_return_status OUT nocopy NUMBER
152 );
153
154 END ASG_LOGGING_PUB;
[Home] [Help]