[Home] [Help]
PACKAGE: APPS.OKS_AUTO_REMINDER
Source
1 PACKAGE OKS_AUTO_REMINDER AS
2 /* $Header: OKSARNWS.pls 120.3.12000000.2 2007/02/28 23:45:23 skkoppul ship $ */
3
4 --------------------------------------------------------------------------
5 -- GLOBAL MESSAGE CONSTANTS
6 ---------------------------------------------------------------------------
7
8 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
9 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
10 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
11 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_AUTO_REM_UNEXPECTED_ERR';
12 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
13 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
14
15 ---------------------------------------------------------------------------
16 -- GLOBAL EXCEPTIONS
17 ---------------------------------------------------------------------------
18 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
19 G_EXCEPTION_ERROR EXCEPTION;
20 G_EXCEPTION_ROLLBACK EXCEPTION;
21 G_EXCEPTION_UNEXPECTED_ERROR EXCEPTION;
22 G_EXC_WARNING EXCEPTION;
23 G_ERROR EXCEPTION;
24 G_HALT_AUTO_RENEWAL EXCEPTION;
25 G_EXCEPTION_LOG_VALIDATION EXCEPTION;
26
27 -------------------------------------------------------------------------
28 -- GLOBAL VARIABLES
29 -------------------------------------------------------------------------
30 G_APP_NAME CONSTANT VARCHAR2(3) := 'OKS';
31 G_AUTO_RENEWAL_RULE CONSTANT VARCHAR2(3) := 'ERN';
32 G_EVER_GREEN CONSTANT VARCHAR2(3) := 'EVN';
33 G_NOTIFY_S_REP CONSTANT VARCHAR2(3) := 'NSR';
34
35 G_ERN_WEB_RESPONSIBILITY CONSTANT VARCHAR2(20) := 'OKS_ERN_WEB';
36
37 TYPE contract_rec_type IS RECORD
38 (
39 contract_id NUMBER,
40 contract_number VARCHAR2(120),
41 contract_modifier VARCHAR2(120),
42 start_date DATE,
43 end_date DATE,
44 QTO_email VARCHAR2(2000),
45 contract_status VARCHAR2(50),
46 renewal_status VARCHAR2(40)
47 );
48
49 TYPE contract_rec_tbl IS TABLE OF contract_rec_type INDEX BY BINARY_INTEGER;
50
51 TYPE contract_details_rec_type IS RECORD
52 (
53 id NUMBER,
54 contract_number VARCHAR2(120),
55 start_date DATE,
56 end_date DATE,
57 contract_number_modifier VARCHAR2(240),
58 sts_code VARCHAR2(50),
59 ste_code VARCHAR2(200)
60 );
61
62 TYPE contract_details_tbl_type IS TABLE OF contract_details_rec_type INDEX BY BINARY_INTEGER;
63 TYPE contact_rec_type IS RECORD
64 (
65 name VARCHAR2(240),
66 phone VARCHAR2(240),
67 fax VARCHAR2(240),
68 email_address VARCHAR2(2000),
69 address1 VARCHAR2(240),
70 address2 VARCHAR2(240),
71 address3 VARCHAR2(240),
72 address4 VARCHAR2(240),
73 city VARCHAR2(240),
74 postal_code VARCHAR2(240),
75 state VARCHAR2(240),
76 party_name VARCHAR2(360)
77 );
78
79 TYPE contact_rec_tbl IS TABLE OF contact_rec_type INDEX BY BINARY_INTEGER;
80
81 TYPE message_rec_type IS RECORD
82 (
83 name VARCHAR2(120),
84 description VARCHAR2(4000)
85 );
86
87 TYPE message_rec_tbl IS TABLE OF message_rec_type INDEX BY BINARY_INTEGER;
88
89 TYPE userinfo_rec_type IS RECORD
90 (
91 id NUMBER,
92 name VARCHAR2(100),
93 resource_id NUMBER
94 );
95
96 TYPE userinfo_tbl IS TABLE OF userinfo_rec_type INDEX BY BINARY_INTEGER;
97
98
99
100
101 PROCEDURE update_contract_status (
102 p_chr_id IN VARCHAR2,
103 p_status IN VARCHAR2,
104 x_return_status OUT NOCOPY VARCHAR2
105 );
106
107 PROCEDURE update_contract_status (
108 p_chr_id IN NUMBER,
109 p_status IN VARCHAR2,
110 x_return_status OUT NOCOPY VARCHAR2
111 );
112
113 PROCEDURE get_time_stats (
114 p_start_date IN DATE,
115 p_end_date IN DATE,
116 x_duration OUT NOCOPY NUMBER,
117 x_period OUT NOCOPY VARCHAR2,
118 x_return_status OUT NOCOPY VARCHAR2
119 );
120
121 PROCEDURE get_duration (
122 p_start_date IN DATE,
123 p_end_date IN DATE,
124 p_source_uom IN VARCHAR2,
125 x_duration OUT NOCOPY NUMBER
126 );
127
128 FUNCTION get_org_context RETURN NUMBER;
129
130 FUNCTION get_org_id RETURN VARCHAR2;
131
132 FUNCTION get_org_context(p_org_id NUMBER) RETURN NUMBER;
133
134
135 PROCEDURE validate_autoreminder_k (
136 p_chr_id IN VARCHAR2,
137 x_is_eligible OUT NOCOPY VARCHAR2,
138 x_quote_id OUT NOCOPY VARCHAR2,
139 x_cover_id OUT NOCOPY VARCHAR2,
140 x_sender OUT NOCOPY VARCHAR2,
141 x_QTO_email OUT NOCOPY VARCHAR2,
142 x_subject OUT NOCOPY VARCHAR2,
143 x_status OUT NOCOPY VARCHAR2,
144 x_attachment_name OUT NOCOPY VARCHAR2,
145 x_return_status OUT NOCOPY VARCHAR2,
146 x_msg_count OUT NOCOPY VARCHAR2,
147 x_msg_data OUT NOCOPY VARCHAR2
148 );
149
150
151 PROCEDURE create_user (
152 p_user_name IN VARCHAR2,
153 p_contract_id IN NUMBER,
154 x_password OUT NOCOPY VARCHAR2,
155 x_return_status OUT NOCOPY VARCHAR2,
156 x_err_msg OUT NOCOPY OKS_AUTO_REMINDER.message_rec_tbl
157 );
158
159 PROCEDURE get_QTO_email ( p_chr_id IN NUMBER,
160 x_QTO_email OUT NOCOPY VARCHAR2
161 );
162
163
164 PROCEDURE get_party_id (p_chr_id IN NUMBER,
165 x_party_id OUT NOCOPY NUMBER
166 );
167
168 PROCEDURE get_qtoparty_id (
169 p_chr_id IN NUMBER,
170 x_party_id OUT NOCOPY NUMBER
171 );
172
173
174
175 PROCEDURE update_renewal_status (
176 p_chr_id IN NUMBER,
177 p_renewal_status IN VARCHAR2,
178 x_return_status OUT NOCOPY VARCHAR2
179 );
180
181
182 FUNCTION GET_BILLTO_CONTACT
183 ( p_org_id IN NUMBER,
184 p_inv_org_id IN NUMBER,
185 p_contract_id IN NUMBER )
186 RETURN VARCHAR2;
187
188 FUNCTION GET_BILLTO_EMAIL (
189 p_contract_id IN NUMBER
190 ) RETURN VARCHAR2;
191
192 FUNCTION GET_BILLTO_FAX (
193 p_contract_id IN NUMBER
194 ) RETURN VARCHAR2;
195
196 FUNCTION GET_BILLTO_PHONE (
197 p_contract_id IN NUMBER
198 ) RETURN VARCHAR2;
199
200 FUNCTION GET_LICENSE_LEVEL
201 ( p_lse_id IN NUMBER,
202 p_object_id IN NUMBER)
203 RETURN VARCHAR2;
204
205 FUNCTION GET_NO_OF_USERS
206 ( p_lse_id IN NUMBER,
207 p_object_id IN NUMBER)
208 RETURN VARCHAR2;
209
210 FUNCTION GET_PRICING_TYPE
211 ( p_lse_id IN NUMBER,
212 p_object_id IN NUMBER)
213 RETURN VARCHAR2;
214
215 FUNCTION GET_PRODUCT_NAME
216 ( p_lse_id IN NUMBER,
217 p_object_id IN NUMBER,
218 p_inv_org_id IN NUMBER DEFAULT NULL
219 ) RETURN VARCHAR2;
220
221 FUNCTION GET_SERVICE_NAME
222 ( p_line_id IN NUMBER,
223 p_contract_id IN NUMBER)
224 RETURN VARCHAR2;
225
226 PROCEDURE log_interaction (
227 x_return_status OUT NOCOPY VARCHAR2,
228 x_msg_count OUT NOCOPY NUMBER,
229 x_msg_data OUT NOCOPY VARCHAR2,
230 p_chr_id IN VARCHAR2,
231 p_subject IN VARCHAR2 DEFAULT NULL,
232 p_msg_body IN VARCHAR2 DEFAULT NULL,
233 p_sent2_email IN VARCHAR2 DEFAULT NULL
234 );
235
236 PROCEDURE log_interaction (
237 p_api_version IN NUMBER,
238 p_init_msg_list IN VARCHAR2,
239 x_return_status OUT NOCOPY VARCHAR2,
240 x_msg_count OUT NOCOPY NUMBER,
241 x_msg_data OUT NOCOPY VARCHAR2,
242 p_chr_id IN NUMBER,
243 p_subject IN VARCHAR2 DEFAULT NULL,
244 p_msg_body IN VARCHAR2 DEFAULT NULL,
245 p_sent2_email IN VARCHAR2 DEFAULT NULL,
246 p_media_type IN VARCHAR2 DEFAULT 'EMAIL'
247 );
248
249 PROCEDURE create_sso_user
250 (
251 p_user_name IN VARCHAR2,
252 p_contract_id IN NUMBER,
253 x_user_name OUT NOCOPY VARCHAR2,
254 x_password OUT NOCOPY VARCHAR2,
255 x_return_status OUT NOCOPY VARCHAR2,
256 x_msg_data OUT NOCOPY VARCHAR2,
257 x_msg_count OUT NOCOPY NUMBER
258
259 );
260
261 END OKS_AUTO_REMINDER;