1 PACKAGE BODY ASG_LOGGING_PUB as
2 /* $Header: asgplogb.pls 120.1 2005/08/12 02:52:23 saradhak noship $ */
3
4 --
5 -- NAME
6 -- ASG_LOGGING_PUB
7 --
8 -- PURPOSE
9 -- Public API to ADD/DELETE/UPDATE/RETRIEVE error and notification logs
10
11 --
12 -- Add a log entry to the log table
13 --
14 -- HISTORY
15 -- 02-JAN-2002 ytian Removed the reference to security_group_id
16 -- 28-jun-2001 vekrishn New Api's to Log Error for Sales
17 -- 11-apr-2000 wechin Created.
18 --
19
20 PROCEDURE Create_Log_Entry
21 ( p_api_version IN NUMBER ,
22 p_init_msg_list IN VARCHAR2 ,
23 p_commit IN VARCHAR2 ,
24 p_validation_level IN NUMBER ,
25 p_log_entry_rec IN LOG_ENTRY_REC_TYPE ,
26 x_return_status OUT nocopy VARCHAR2,
27 x_msg_count OUT nocopy NUMBER,
28 x_msg_data OUT nocopy VARCHAR2,
29 x_mobile_error_id OUT nocopy NUMBER
30 ) IS
31
32 BEGIN
33 null;
34 END Create_Log_Entry;
35
36 PROCEDURE Update_Log_Entry
37 ( p_api_version IN NUMBER ,
38 p_init_msg_list IN VARCHAR2 ,
39 p_commit IN VARCHAR2 ,
40 p_validation_level IN NUMBER ,
41 p_log_entry_rec IN LOG_ENTRY_REC_TYPE ,
42 x_return_status OUT nocopy VARCHAR2,
43 x_msg_count OUT nocopy NUMBER,
44 x_msg_data OUT nocopy VARCHAR2
45 ) IS
46
47 BEGIN
48 null;
49 END Update_Log_Entry;
50
51
52 PROCEDURE Delete_Log_Entry
53 ( p_api_version IN NUMBER ,
54 p_init_msg_list IN VARCHAR2,
55 p_commit IN VARCHAR2 ,
56 p_validation_level IN NUMBER ,
57 p_log_entry_rec IN LOG_ENTRY_REC_TYPE ,
58 x_return_status OUT nocopy VARCHAR2,
59 x_msg_count OUT nocopy NUMBER,
60 x_msg_data OUT nocopy VARCHAR2
61 ) IS
62 BEGIN
63 null;
64 END Delete_Log_Entry;
65
66
67 PROCEDURE Get_Log_Entry
68 ( p_api_version IN NUMBER ,
69 p_init_msg_list IN VARCHAR2 ,
70 p_commit IN VARCHAR2 ,
71 p_validation_level IN NUMBER ,
72 p_user_name IN VARCHAR2 ,
73 p_mobile_application_id IN NUMBER ,
74 p_server_id IN NUMBER ,
75 p_log_entry_rec IN LOG_ENTRY_REC_TYPE ,
76 x_return_status OUT nocopy VARCHAR2,
77 x_msg_count OUT nocopy NUMBER,
78 x_msg_data OUT nocopy VARCHAR2,
79 x_rec_count OUT nocopy NUMBER,
80 x_log_entry_tbl OUT nocopy LOG_ENTRY_TBL_TYPE,
81 x_log_entry_desc_tbl OUT nocopy LOG_ENTRY_DESC_TBL_TYPE
82 ) IS
83 BEGIN
84 null;
85 END Get_Log_Entry;
86
87 PROCEDURE Make_Null_Synch_Entry
88 ( p_api_version IN NUMBER ,
89 p_init_msg_list IN VARCHAR2 ,
90 p_commit IN VARCHAR2 ,
91 p_validation_level IN NUMBER ,
92 p_client_rec IN CLIENT_REC_TYPE ,
93 x_return_status OUT nocopy VARCHAR2,
94 x_msg_count OUT nocopy NUMBER,
95 x_msg_data OUT nocopy VARCHAR2
96 ) IS
97
98 BEGIN
99 null;
100 END Make_Null_Synch_Entry;
101
102 PROCEDURE Create_Master_Log_Entry (
103 p_log_entry_rec IN LOG_ENTRY_REC_TYPE,
104 x_mobile_error_id OUT nocopy NUMBER,
105 x_return_status OUT nocopy NUMBER
106 ) IS
107 BEGIN
108 null;
109 END Create_Master_Log_Entry;
110
111 PROCEDURE Create_Detail_Log_Entry (
112 p_detail_log_entry_rec IN DETAIL_LOG_ENTRY_REC_TYPE,
113 x_return_status OUT nocopy NUMBER
114 ) IS
115 BEGIN
116 null;
117 END Create_Detail_Log_Entry;
118
119 END ASG_LOGGING_PUB;