1 PACKAGE OZF_QUOTA_THRESHOLD_PVT AUTHID CURRENT_USER AS
2 /* $Header: ozfvqtrs.pls 115.1 2003/12/04 12:04:56 pkarthik noship $*/
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- OZF_QUOTA_THRESHOLD_PVT
7 -- Purpose
8 --
9 -- History
10 -- Created By - Padmavathi Karthikeyan
11
12 -- NOTE
13 -- -- To validate the Quota Thresholds corresponding to Budgets
14 -- and write into ozf_act_log table for notification purpose.
15 -- Arguments
16 -- End of Comments
17 -- ===============================================================
18
19 -- ==============================================================================
20 -- Start of Comments
21 -- ==============================================================================
22 -- API Name
23 -- validate_quota_threshold
24 -- Type
25 -- Private
26 -- Pre-Req
27 --
28 -- Parameters
29 --
30 -- IN
31 --
32 -- OUT
33 -- x_retcode OUT NUMBER
34 -- x_errbuf OUT VARCHAR2
35 -- Version : Current version 1.0
36 -- Note: This is the main procedure called while executing concurrent program.
37 -- For all enabled quota threshold rules, it will check for violation
38 -- and sent notification accordingly.
39 -- It also set alert flages for dashboard use.
40 -- End of Comments
41 -- ==============================================================================
42 PROCEDURE validate_quota_threshold
43 (
44 x_errbuf OUT NOCOPY VARCHAR2,
45 x_retcode OUT NOCOPY NUMBER
46 );
47
48 -- ==============================================================================
49 -- Start of Comments
50 -- ==============================================================================
51 -- API Name
52 -- operation_result
53 -- Type
54 -- Private
55 -- Pre-Req
56 --
57 -- Parameters
58 --
59 -- IN
60 -- p_api_version_number IN NUMBER Required
61 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
62 -- p_lhs IN NUMBER Required
63 -- p_rhs IN NUMBER Optional Required
64 -- p_operator_code IN VARCHAR2 Required
65 --
66 -- OUT
67 -- x_msg_count OUT NUMBER
68 -- x_msg_data OUT VARCHAR2
69 -- x_return_status OUT VARCHAR2
70 -- x_result OUT VARCHAR2
71 -- Version : Current version 1.0
72 -- Note: It compares value limit amout and base line limit amount to decide validate status.
73 --
74 -- End of Comments
75 -- ==============================================================================
76 PROCEDURE operation_result(
77 p_api_version_number IN NUMBER,
78 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
79 X_Msg_Count OUT NOCOPY NUMBER,
80 X_Msg_Data OUT NOCOPY VARCHAR2,
81 x_return_status OUT NOCOPY VARCHAR2,
82 p_lhs IN NUMBER,
83 p_rhs IN NUMBER,
84 p_operator_code IN VARCHAR2,
85 x_result OUT NOCOPY VARCHAR2);
86 -- ==============================================================================
87 -- Start of Comments
88 -- ==============================================================================
89 -- API Name
90 -- verify_notification
91 -- Type
92 -- Private
93 -- Pre-Req
94 --
95 -- Parameters
96 --
97 -- IN
98 -- p_api_version_number IN NUMBER Required
99 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
100 -- p_budget_id IN NUMBER Required
101 -- p_threshold_id IN NUMBER Required
102 -- p_threshold_rule_id IN NUMBER Required
103 -- p_frequency_period IN VARCHAR2 Required
104 -- p_repeat_frequency IN NUMBER Required
105 -- p_rule_start_date IN DATE Required
106
107 --
108 -- OUT
109 -- x_msg_count OUT NUMBER
110 -- x_msg_data OUT VARCHAR2
111 -- x_return_status OUT VARCHAR2
112 -- x_result OUT VARCHAR2
113 -- Version : Current version 1.0
114 -- Note: it checks ams_act_logs table to see if notification existed or not.
115 --
116 -- End of Comments
117 -- ==============================================================================
118
119 PROCEDURE verify_notification(
120 p_api_version_number IN NUMBER,
121 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
122 X_Msg_Count OUT NOCOPY NUMBER,
123 X_Msg_Data OUT NOCOPY VARCHAR2,
124 x_return_status OUT NOCOPY VARCHAR2,
125 p_budget_id IN NUMBER,
126 p_threshold_id IN NUMBER,
127 p_threshold_rule_id IN NUMBER,
128 p_frequency_period IN VARCHAR2,
129 p_repeat_frequency IN NUMBER,
130 p_rule_start_date IN DATE,
131 x_result OUT NOCOPY VARCHAR2);
132
133 -- ==============================================================================
134 -- Start of Comments
135 -- ==============================================================================
136 -- API Name
137 -- update_alerts
138 -- Type
139 -- Private
140 -- Pre-Req
141 --
142 -- Parameters
143 --
144 -- IN
145 -- p_api_version_number IN NUMBER Required
146 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
147 -- p_resource_id IN NUMBER Required
148 -- p_alert_for IN VARCHAR2 Required
149 -- p_product_attribute IN VARCHAR2 Required
150 -- p_attribute2 IN NUMBER Required
151 -- p_alert_type IN VARCHAR2 Required
152 -- p_select_attribute IN VARCHAR2 Required
153 -- p_cust_account_id IN NUMBER Required
154 --
155 -- OUT
156 -- x_msg_count OUT NUMBER
157 -- x_msg_data OUT VARCHAR2
158 -- x_return_status OUT VARCHAR2
159 -- Version : Current version 1.0
160 -- Note: It updates/inserts either ozf_quota_alerts/ozf_dashb_daily_kpi as per
161 -- the value of p_alert_for.
162 --
163 -- End of Comments
164 -- ==============================================================================
165
166 PROCEDURE update_alerts(
167 p_api_version_number IN NUMBER,
168 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
169 x_Msg_Count OUT NOCOPY NUMBER,
170 x_Msg_Data OUT NOCOPY VARCHAR2,
171 x_return_status OUT NOCOPY VARCHAR2,
172 p_resource_id IN NUMBER,
173 p_alert_for IN VARCHAR2,
174 p_product_attribute IN VARCHAR2,
175 p_attribute2 IN NUMBER, -- product_attr_value/ship_to_site_use_id/sequence_number
176 p_alert_type IN VARCHAR2,
177 p_select_attribute IN VARCHAR2,
178 p_cust_account_id IN NUMBER
179 );
180
181 END OZF_QUOTA_THRESHOLD_PVT; -- Package spec