[Home] [Help]
PACKAGE: APPS.AML_MONITOR_LOG_PVT
Source
1 PACKAGE AML_Monitor_Log_PVT AUTHID CURRENT_USER AS
2 /* $Header: amlvlmls.pls 115.1 2003/01/20 18:37:54 swkhanna ship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- AML_Monitor_Log_PVT
7 -- Purpose
8 --
9 -- History
10 -- 11-27-2002 sujrama created
11 -- ===============================================================
12 -- Default number of records fetch per call
13 -- G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
14 --===================================================================
15 -- Start of Comments
16 -- -------------------------------------------------------
17 -- Record name
18 -- monitor_log_rec_type
19 -- -------------------------------------------------------
20 -- Parameters:
21 -- monitor_log_id
22 -- last_update_date
23 -- last_updated_by
24 -- creation_date
25 -- created_by
26 -- last_update_login
27 -- object_version_number
28 -- request_id
29 -- program_application_id
30 -- program_id
31 -- program_update_date
32 -- monitor_condition_id
33 -- recipient_role
34 -- monitor_action
35 -- recipient_resource_id
36 -- sales_lead_id
37 -- attribute_category
38 -- attribute1
39 -- attribute2
40 -- attribute3
41 -- attribute4
42 -- attribute5
43 -- attribute6
44 -- attribute7
45 -- attribute8
46 -- attribute9
47 -- attribute10
48 -- attribute11
49 -- attribute12
50 -- attribute13
51 -- attribute14
52 -- attribute15
53 --
54 -- Required
55 --
56 -- Defaults
57 --
58 -- End of Comments
59 --===================================================================
60 TYPE monitor_log_rec_type IS RECORD
61 (
62 monitor_log_id NUMBER -- := FND_API.G_MISS_NUM
63 ,last_update_date DATE -- := FND_API.G_MISS_DATE
64 ,last_updated_by NUMBER -- := FND_API.G_MISS_NUM
65 ,creation_date DATE -- := FND_API.G_MISS_DATE
66 ,created_by NUMBER -- := FND_API.G_MISS_NUM
67 ,last_update_login NUMBER -- := FND_API.G_MISS_NUM
68 ,object_version_number NUMBER -- := FND_API.G_MISS_NUM
69 ,request_id NUMBER -- := FND_API.G_MISS_NUM
70 ,program_application_id NUMBER -- := FND_API.G_MISS_NUM
71 ,program_id NUMBER -- := FND_API.G_MISS_NUM
72 ,program_update_date DATE -- := FND_API.G_MISS_DATE
73 ,monitor_condition_id NUMBER -- := FND_API.G_MISS_NUM
74 ,recipient_role VARCHAR2(30) -- := FND_API.G_MISS_CHAR
75 ,monitor_action VARCHAR2(30) -- := FND_API.G_MISS_CHAR
76 ,recipient_resource_id NUMBER -- := FND_API.G_MISS_NUM
77 ,sales_lead_id NUMBER -- := FND_API.G_MISS_NUM
78 ,attribute_category VARCHAR2(30)-- := FND_API.G_MISS_CHAR
79 ,attribute1 VARCHAR2(150)-- := FND_API.G_MISS_CHAR
80 ,attribute2 VARCHAR2(150)-- := FND_API.G_MISS_CHAR
81 ,attribute3 VARCHAR2(150)-- := FND_API.G_MISS_CHAR
82 ,attribute4 VARCHAR2(150)-- := FND_API.G_MISS_CHAR
83 ,attribute5 VARCHAR2(150)-- := FND_API.G_MISS_CHAR
84 ,attribute6 VARCHAR2(150)-- := FND_API.G_MISS_CHAR
85 ,attribute7 VARCHAR2(150)-- := FND_API.G_MISS_CHAR
86 ,attribute8 VARCHAR2(150)-- := FND_API.G_MISS_CHAR
87 ,attribute9 VARCHAR2(150)-- := FND_API.G_MISS_CHAR
88 ,attribute10 VARCHAR2(150)-- := FND_API.G_MISS_CHAR
89 ,attribute11 VARCHAR2(150)-- := FND_API.G_MISS_CHAR
90 ,attribute12 VARCHAR2(150)-- := FND_API.G_MISS_CHAR
91 ,attribute13 VARCHAR2(150)-- := FND_API.G_MISS_CHAR
92 ,attribute14 VARCHAR2(150)-- := FND_API.G_MISS_CHAR
93 ,attribute15 VARCHAR2(150)-- := FND_API.G_MISS_CHAR
94 );
95 g_miss_monitor_log_rec monitor_log_rec_type ;
96 TYPE monitor_log_tbl_type IS TABLE OF monitor_log_rec_type INDEX BY BINARY_INTEGER;
97 g_miss_monitor_log_tbl monitor_log_tbl_type;
98 -- ==============================================================================
99 -- Start of Comments
100 -- ==============================================================================
101 -- API Name
102 -- Create_Monitor_Log
103 -- Type
104 -- Private
105 -- Pre-Req
106 --
107 -- Parameters
108 --
109 -- IN
110 -- p_api_version_number IN NUMBER Required
111 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
112 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
113 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
114 -- p_monitor_log_rec IN MONITOR_LOG_REC_TYPE Required
115 --
116 -- OUT
117 -- x_return_status OUT VARCHAR2
118 -- x_msg_count OUT NUMBER
119 -- x_msg_data OUT VARCHAR2
120 --
121 -- History
122 --
123 -- NOTE
124 --
125 -- End of Comments
126 -- ==============================================================================
127 PROCEDURE Create_Monitor_Log(
128 p_api_version_number IN NUMBER
129 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
130 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
131 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
132 ,p_monitor_log_rec IN monitor_log_rec_type := g_miss_monitor_log_rec
133 ,x_monitor_log_id OUT NOCOPY NUMBER
134 ,x_return_status OUT NOCOPY VARCHAR2
135 ,x_msg_count OUT NOCOPY NUMBER
136 ,x_msg_data OUT NOCOPY VARCHAR2
137 );
138 -- ==============================================================================
139 -- Start of Comments
140 -- ==============================================================================
141 -- API Name
142 -- Update_Monitor_Log
143 -- Type
144 -- Private
145 -- Pre-Req
146 --
147 -- Parameters
148 --
149 -- IN
150 -- p_api_version_number IN NUMBER Required
151 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
152 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
153 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
154 -- p_monitor_log_rec IN monitor_log_rec_type Required
155 --
156 -- OUT
157 -- x_return_status OUT VARCHAR2
158 -- x_msg_count OUT NUMBER
159 -- x_msg_data OUT VARCHAR2
160 --
161 -- End of Comments
162 -- ==============================================================================
163 PROCEDURE Update_Monitor_Log(
164 p_api_version_number IN NUMBER
165 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
166 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
167 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
168 ,p_monitor_log_rec IN monitor_log_rec_type
169 ,x_return_status OUT NOCOPY VARCHAR2
170 ,x_msg_count OUT NOCOPY NUMBER
171 ,x_msg_data OUT NOCOPY VARCHAR2
172 );
173 -- ==============================================================================
174 -- Start of Comments
175 -- ==============================================================================
176 -- API Name
177 -- Delete_Monitor_Log
178 -- Type
179 -- Private
180 -- Pre-Req
181 --
182 -- Parameters
183 --
184 -- IN
185 -- p_api_version_number IN NUMBER Required
186 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
187 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
188 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
189 -- p_monitor_log_id IN NUMBER Required
190 -- p_object_version_number IN NUMBER Optional Default = NULL
191 --
192 -- OUT
193 -- x_return_status OUT VARCHAR2
194 -- x_msg_count OUT NUMBER
195 -- x_msg_data OUT VARCHAR2
196 -- History
197 --
198 -- NOTE
199 --
200 -- End of Comments
201 -- ==============================================================================
202 PROCEDURE Delete_Monitor_Log(
203 p_api_version_number IN NUMBER
204 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
205 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
206 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
207 ,p_monitor_log_id IN NUMBER
208 ,x_return_status OUT NOCOPY VARCHAR2
209 ,x_msg_count OUT NOCOPY NUMBER
210 ,x_msg_data OUT NOCOPY VARCHAR2
211 );
212 -- ==============================================================================
213 END AML_Monitor_Log_PVT;