1 PACKAGE Ozf_Threshold_Pvt AUTHID CURRENT_USER AS
2 /* $Header: ozfvtres.pls 115.0 2003/06/26 05:11:05 mchang noship $*/
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- ozf_threshold_pvt
7 -- Purpose
8 --
9 -- History
10 -- Created By - Siddharha Dutta
11 -- 29/04/2001 Feliu updated
12 -- 29/11/2001 Changed signature for validate_threshold.
13
14 -- NOTE
15 -- -- To validate the Thresholds corresponding to Budgets
16 -- and write into ozf_act_log table for notification purpose.
17 -- Arguments
18 -- End of Comments
19 -- ===============================================================
20
21 -- ==============================================================================
22 -- Start of Comments
23 -- ==============================================================================
24 -- API Name
25 -- validate_threshold
26 -- Type
27 -- Private
28 -- Pre-Req
29 --
30 -- Parameters
31 --
32 -- IN
33 -- p_api_version_number IN NUMBER Required
34 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
35 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
36 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
37 -- p_threshold_rec IN threshold_rec_type Required
38 --
39 -- OUT
40 -- x_msg_count OUT NUMBER
41 -- x_msg_data OUT VARCHAR2
42 -- x_return_status OUT VARCHAR2
43 -- Version : Current version 1.0
44 -- Note: This is main procedure called by workflow. it validates the the threshold rules on budgets
45 --
46 -- End of Comments
47 -- ==============================================================================
48 PROCEDURE validate_threshold
49 ( /*p_api_version_number IN NUMBER,
50 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
51 p_commit IN VARCHAR2 := FND_API.G_FALSE,
52 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
53 x_msg_count OUT NOCOPY NUMBER,
54 x_msg_data OUT NOCOPY VARCHAR2,
55 x_msg_buffer OUT NOCOPY VARCHAR2,
56 x_return_status OUT NOCOPY VARCHAR2
57 */
58 x_errbuf OUT NOCOPY VARCHAR2
59 ,x_retcode OUT NOCOPY NUMBER
60 );
61
62 -- ==============================================================================
63 -- Start of Comments
64 -- ==============================================================================
65 -- API Name
66 -- value_limit
67 -- Type
68 -- Private
69 -- Pre-Req
70 --
71 -- Parameters
72 --
73 -- IN
74 -- p_api_version_number IN NUMBER Required
75 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
76 -- p_budget_id IN NUMBER Required
77 -- p_value_limit_type IN VARCHAR2 Required
78 -- p_off_on_line IN VARCHAR2 Required
79
80 -- OUT
81 -- x_msg_count OUT NUMBER
82 -- x_msg_data OUT VARCHAR2
83 -- x_return_status OUT VARCHAR2
84 -- x_result OUT NUMBER
85 -- Version : Current version 1.0
86 -- Note: it gets value limit for threshold rule validation.
87 --
88 -- End of Comments
89 -- ==============================================================================
90
91 PROCEDURE value_limit
92 ( p_api_version_number IN NUMBER,
93 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
94 X_Msg_Count OUT NOCOPY NUMBER,
95 X_Msg_Data OUT NOCOPY VARCHAR2,
96 x_return_status OUT NOCOPY VARCHAR2,
97 p_budget_id IN NUMBER,
98 p_value_limit_type IN VARCHAR2,
99 p_off_on_line IN VARCHAR2,
100 x_result OUT NOCOPY NUMBER);
101
102 -- ==============================================================================
103 -- Start of Comments
104 -- ==============================================================================
105 -- API Name
106 -- base_line_amt
107 -- Type
108 -- Private
109 -- Pre-Req
110 --
111 -- Parameters
112 --
113 -- IN
114 -- p_api_version_number IN NUMBER Required
115 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
116 -- p_budget_id IN Required
117 -- p_percent IN NUMBER Required
118 -- p_base_line_type IN VARCHAR2 Required
119 --
120 -- OUT
121 -- x_msg_count OUT NUMBER
122 -- x_msg_data OUT VARCHAR2
123 -- x_return_status OUT VARCHAR2
124 -- x_result OUT NUMBER
125 -- Version : Current version 1.0
126 -- Note: it gets base line amount for threshold rule validation.
127 --
128 -- End of Comments
129 -- ==============================================================================
130 PROCEDURE base_line_amt(
131 p_api_version_number IN NUMBER,
132 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
133 X_Msg_Count OUT NOCOPY NUMBER,
134 X_Msg_Data OUT NOCOPY VARCHAR2,
135 x_return_status OUT NOCOPY VARCHAR2,
136 p_budget_id IN NUMBER,
137 p_percent IN NUMBER,
138 p_base_line_type IN VARCHAR2,
139 x_result OUT NOCOPY NUMBER);
140
141 -- ==============================================================================
142 -- Start of Comments
143 -- ==============================================================================
144 -- API Name
145 -- operation_result
146 -- Type
147 -- Private
148 -- Pre-Req
149 --
150 -- Parameters
151 --
152 -- IN
153 -- p_api_version_number IN NUMBER Required
154 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
155 -- p_lhs IN NUMBER Required
156 -- p_rhs IN NUMBER Optional Required
157 -- p_operator_code IN VARCHAR2 Required
158 --
159 -- OUT
160 -- x_msg_count OUT NUMBER
161 -- x_msg_data OUT VARCHAR2
162 -- x_return_status OUT VARCHAR2
163 -- x_result OUT VARCHAR2
164 -- Version : Current version 1.0
165 -- Note: It compares value limit amout and base line limit amount to decide validate status.
166 --
167 -- End of Comments
168 -- ==============================================================================
169 PROCEDURE operation_result(
170 p_api_version_number IN NUMBER,
171 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
172 X_Msg_Count OUT NOCOPY NUMBER,
173 X_Msg_Data OUT NOCOPY VARCHAR2,
174 x_return_status OUT NOCOPY VARCHAR2,
175 p_lhs IN NUMBER,
176 p_rhs IN NUMBER,
177 p_operator_code IN VARCHAR2,
178 x_result OUT NOCOPY VARCHAR2);
179 -- ==============================================================================
180 -- Start of Comments
181 -- ==============================================================================
182 -- API Name
183 -- verify_notification
184 -- Type
185 -- Private
186 -- Pre-Req
187 --
188 -- Parameters
189 --
190 -- IN
191 -- p_api_version_number IN NUMBER Required
192 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
193 -- p_budget_id IN NUMBER Required
194 -- p_threshold_id IN NUMBER Required
195 -- p_threshold_rule_id IN NUMBER Required
196 -- p_frequency_period IN VARCHAR2 Required
197 -- p_repeat_frequency IN NUMBER Required
198 -- p_rule_start_date IN DATE Required
199
200 --
201 -- OUT
202 -- x_msg_count OUT NUMBER
203 -- x_msg_data OUT VARCHAR2
204 -- x_return_status OUT VARCHAR2
205 -- x_result OUT VARCHAR2
206 -- Version : Current version 1.0
207 -- Note: it checks ams_act_logs table to see if notification existed or not.
208 --
209 -- End of Comments
210 -- ==============================================================================
211
212 PROCEDURE verify_notification(
213 p_api_version_number IN NUMBER,
214 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
215 X_Msg_Count OUT NOCOPY NUMBER,
216 X_Msg_Data OUT NOCOPY VARCHAR2,
217 x_return_status OUT NOCOPY VARCHAR2,
218 p_budget_id IN NUMBER,
219 p_threshold_id IN NUMBER,
220 p_threshold_rule_id IN NUMBER,
221 p_frequency_period IN VARCHAR2,
222 p_repeat_frequency IN NUMBER,
223 p_rule_start_date IN DATE,
224 x_result OUT NOCOPY VARCHAR2);
225
226
227 END Ozf_Threshold_Pvt;
228