1 PACKAGE BODY OKC_OC_INT_QTK_PVT AS
2 -- $Header: OKCRQTKB.pls 120.3 2005/10/04 19:36:17 smallya noship $
3
4 PROCEDURE print_error(pos IN NUMBER) IS
5 BEGIN
6 null;
7 END print_error;
8
9 PROCEDURE cleanup(x_return_status OUT NOCOPY varchar2 ) IS
10 BEGIN
11 NULL;
12 END cleanup;
13
14 PROCEDURE create_rule_group (p_level IN VARCHAR2
15 ,p_rgd_type IN VARCHAR2
16 ,p_chrv_rec IN okc_contract_pub.chrv_rec_type
17 ,p_clev_rec IN okc_contract_pub.clev_rec_type
18 ,x_return_status OUT NOCOPY VARCHAR2
19 ,x_rgpv_rec OUT NOCOPY okc_rule_pub.rgpv_rec_type
20 ) IS
21
22 BEGIN
23 NULL;
24 END create_rule_group;
25
26 PROCEDURE update_rule_group (p_level IN VARCHAR2
27 ,p_rgd_type IN VARCHAR2
28 ,p_chrv_rec IN okc_contract_pub.chrv_rec_type
29 ,p_rgpv_rec IN okc_rule_pub.rgpv_rec_type
30 ,x_return_status OUT NOCOPY VARCHAR2
31 ,x_rgpv_rec OUT NOCOPY okc_rule_pub.rgpv_rec_type
32 ) IS
33
34 BEGIN
35 NULL;
36 END update_rule_group;
37
38 PROCEDURE delete_rule_group (p_rgpv_rec IN okc_rule_pub.rgpv_rec_type
39 ,x_return_status OUT NOCOPY VARCHAR2
40 ) IS
41
42 BEGIN
43 NULL;
44 END delete_rule_group;
45
46 PROCEDURE create_rg_party_roles (p_chrv_rec IN okc_contract_pub.chrv_rec_type
47 ,x_return_status OUT NOCOPY VARCHAR2
48 ) IS
49
50 BEGIN
51 NULL;
52 END create_rg_party_roles;
53
54 PROCEDURE create_rule (p_rgpv_rec IN okc_rule_pub.rgpv_rec_type
55 ,p_chrv_rec IN okc_contract_pub.chrv_rec_type
56 ,p_rulv_rec IN okc_rule_pub.rulv_rec_type
57 ,x_return_status OUT NOCOPY VARCHAR2
58 ,x_rulv_rec OUT NOCOPY okc_rule_pub.rulv_rec_type
59 ) IS
60 BEGIN
61 NULL;
62 END create_rule;
63
64 PROCEDURE update_rule (p_rgpv_rec IN okc_rule_pub.rgpv_rec_type
65 ,p_chrv_rec IN okc_contract_pub.chrv_rec_type
66 ,p_rulv_rec IN okc_rule_pub.rulv_rec_type
67 ,x_return_status OUT NOCOPY VARCHAR2
68 ,x_rulv_rec OUT NOCOPY okc_rule_pub.rulv_rec_type
69 ) IS
70 BEGIN
71 NULL;
72 END update_rule;
73
74 Procedure Line_level_rule_groups(x_return_status OUT NOCOPY VARCHAR2
75 ,x_rgpv_rec OUT NOCOPY okc_rule_pub.rgpv_rec_type
76 ,p_rgd_type IN VARCHAR2
77 ,p_chrv_rec IN okc_contract_pub.chrv_rec_type
78 ,p_clev_rec IN okc_contract_pub.clev_rec_type) IS
79 BEGIN
80 NULL;
81 END; -- line level rule groups
82
83 Procedure Line_level_rules(x_return_status OUT NOCOPY VARCHAR2
84 ,x_rulv_rec OUT NOCOPY okc_rule_pub.rulv_rec_type
85 ,p_rgpv_rec IN okc_rule_pub.rgpv_rec_type
86 ,p_chrv_rec IN okc_contract_pub.chrv_rec_type
87 ,p_rulv_rec IN okc_rule_pub.rulv_rec_type) IS
88
89
90 -- Get description for rule type
91
92 BEGIN
93 NULL;
94 END; -- line level rules
95
96 PROCEDURE update_kpr (p_scs_code IN VARCHAR2
97 ,p_chr_id IN NUMBER
98 ,p_org_id IN NUMBER
99 ,p_party_id IN NUMBER
100 ,x_return_status OUT NOCOPY VARCHAR2
101 ,x_cplv_rec OUT NOCOPY okc_contract_party_pub.cplv_rec_type
102 ,x_ctcv_rec OUT NOCOPY okc_contract_party_pub.ctcv_rec_type
103 ) IS
104 BEGIN
105 NULL;
106 END update_kpr;
107
108 PROCEDURE get_line_style(p_item_id IN VARCHAR2
109 ,p_organization_id IN VARCHAR2
110 ,p_line_style_tab IN line_style_tab_type
111 ,x_return_status OUT NOCOPY VARCHAR2
112 ,x_tab_idx OUT NOCOPY BINARY_INTEGER
113 ) IS
114
115 BEGIN
116 NULL;
117 END get_line_style;
118
119 PROCEDURE get_sub_line_style(p_org_id IN NUMBER,
120 p_item_id IN VARCHAR2
121 ,p_sub_line_style_tab IN sub_line_style_tab_type
122 ,x_return_status OUT NOCOPY VARCHAR2
123 ,x_tab_idx OUT NOCOPY NUMBER -- BINARY_INTEGER
124 ) IS
125 BEGIN
126 NULL;
127 END get_sub_line_style;
128
129 PROCEDURE instantiate_counters_events (x_return_status OUT NOCOPY VARCHAR2
130 ,p_start_date IN DATE
131 ,p_END_date IN DATE
132 ,p_inv_org_id IN NUMBER
133 ,p_cle_id IN NUMBER) IS
134 BEGIN
135 null;
136 END instantiate_counters_events;
137
138 PROCEDURE create_k_rel_objs ( x_return_status OUT NOCOPY VARCHAR2
139 ,x_crj_rel_hdr_rec OUT NOCOPY OKC_K_REL_OBJS_PUB.CRJ_REL_HDR_REC_TYPE
140 ,x_crj_rel_line_tbl OUT NOCOPY OKC_K_REL_OBJS_PUB.CRJ_REL_LINE_TBL_TYPE
141 ,p_rel_type IN OKC_K_REL_OBJS.RTY_CODE%TYPE
142 ,p_rel_hdr IN OKC_K_REL_OBJS_PUB.CRJ_REL_HDR_REC_TYPE
143 ,p_rel_line_tab IN OKC_K_REL_OBJS_PUB.CRJ_REL_LINE_TBL_TYPE
144 ) IS
145
146 BEGIN
147 NULL;
148 END create_k_rel_objs;
149
150 PROCEDURE validate_quote_ktemplate_rel (p_k_template_id IN NUMBER
151 ,p_k_template_version IN NUMBER
152 ,p_quote_id IN NUMBER
153 ,p_rel_type IN VARCHAR2
154 ,x_k_template_scs_code OUT NOCOPY VARCHAR2
155 ,x_k_template_number OUT NOCOPY VARCHAR2
156 ,x_k_template_currency_code OUT NOCOPY VARCHAR2
157 ,x_quote_number OUT NOCOPY NUMBER
158 ,x_quote_version OUT NOCOPY NUMBER
159 ,x_quote_currency_code OUT NOCOPY VARCHAR2
160 ,x_return_status OUT NOCOPY VARCHAR2
161 ) IS
162 BEGIN
163 NULL;
164 END validate_quote_ktemplate_rel;
165
166 PROCEDURE update_k_header(x_return_status OUT NOCOPY VARCHAR2
167 ,p_context IN VARCHAR2
168 ,p_chr_id IN NUMBER
169 ,p_qte_id IN NUMBER) IS
170 BEGIN
171 null;
172 END update_k_header;
173
174 PROCEDURE create_new_line(x_return_status OUT NOCOPY VARCHAR2
175 ,x_cle_id OUT NOCOPY NUMBER
176 ,p_context IN VARCHAR2
177 ,p_line_style_tab IN line_style_tab_type) IS
178 BEGIN
179 null;
180 END create_new_line;
181
182 PROCEDURE renew_line(x_return_status OUT NOCOPY VARCHAR2
183 ,x_cle_id OUT NOCOPY NUMBER
184 ,p_cle_id IN NUMBER -- line being renewed
185 ,p_context IN VARCHAR2
186 ,p_line_style_tab IN OKC_OC_INT_QTK_PVT.line_style_tab_type) IS
187
188 BEGIN
189 null;
190 END; -- Renew_line;
191
192 PROCEDURE create_k_lines(x_return_status OUT NOCOPY VARCHAR2
193 ,p_context IN VARCHAR2
194 ,p_chr_id IN NUMBER
195 ,p_qte_id IN NUMBER
196 ,p_k_template_id IN NUMBER) IS
197 BEGIN
198 NULL;
199 END create_k_lines;
200
201 PROCEDURE create_k_from_q(x_return_status OUT NOCOPY VARCHAR2
202 ,p_context IN VARCHAR2
203 ,p_chr_id IN NUMBER ) IS
204 BEGIN
205 NULL;
206 END; -- create_k_from_q;
207
208 PROCEDURE create_new_k( x_return_status OUT NOCOPY VARCHAR2
209 ,x_chr_id OUT NOCOPY NUMBER
210 ,p_rel_type IN OKC_K_REL_OBJS.RTY_CODE%TYPE
211 ,p_k_template_id IN NUMBER
212 ,p_k_template_version IN NUMBER
213 ,p_qte_id IN NUMBER ) IS
214 BEGIN
215 NULL;
216 END create_new_k;
217
218 PROCEDURE renew_k( x_return_status OUT NOCOPY VARCHAR2
219 ,x_chr_id OUT NOCOPY NUMBER
220 ,p_rel_type IN OKC_K_REL_OBJS.RTY_CODE%TYPE
221 ,p_k_template_id IN NUMBER
222 ,p_qte_id IN NUMBER ) IS
223 BEGIN
224 NULL;
225 END renew_k;
226
227 PROCEDURE create_k_from_quote(p_api_version IN NUMBER
228 ,p_init_msg_list IN VARCHAR2
229 ,p_quote_id IN OKX_QUOTE_HEADERS_V.id1%TYPE
230 ,p_template_id IN OKC_K_HEADERS_B.ID%TYPE
231 ,p_template_version IN NUMBER
232 ,p_rel_type IN OKC_K_REL_OBJS.RTY_CODE%TYPE
233 ,p_terms_agreed_flag IN VARCHAR2
234 ,x_contract_id OUT NOCOPY OKC_K_HEADERS_B.ID%TYPE
235 ,x_contract_number OUT NOCOPY OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
236 ,x_return_status OUT NOCOPY VARCHAR2
237 ,x_msg_count OUT NOCOPY NUMBER
238 ,x_msg_data OUT NOCOPY VARCHAR2
239 ) IS
240 BEGIN
241 null;
242 END create_k_from_quote;
243
244 PROCEDURE get_k_number (p_api_version IN NUMBER
245 ,p_init_msg_list IN VARCHAR2
246 ,p_contract_id IN NUMBER
247 ,x_contract_number OUT NOCOPY OKC_K_HEADERS_B.contract_number%TYPE
248 ,x_contract_number_modifier OUT NOCOPY OKC_K_HEADERS_B.contract_number_modifier%TYPE
249 ,x_return_status OUT NOCOPY VARCHAR2
250 ,x_msg_count OUT NOCOPY NUMBER
251 ,x_msg_data OUT NOCOPY VARCHAR2) IS
252
253 BEGIN
254 NULL;
255 END get_k_number;
256
257 PROCEDURE set_notification_msg (p_api_version IN NUMBER
258 ,p_init_msg_list IN VARCHAR2
259 ,p_application_name IN VARCHAR2
260 ,p_message_subject IN FND_NEW_MESSAGES.MESSAGE_NAME%TYPE
261 ,p_message_body IN FND_NEW_MESSAGES.MESSAGE_NAME%TYPE
262 ,p_message_body_token1 IN VARCHAR2
263 ,p_message_body_token1_value IN VARCHAR2
264 ,p_message_body_token2 IN VARCHAR2
265 ,p_message_body_token2_value IN VARCHAR2
266 ,p_message_body_token3 IN VARCHAR2
267 ,p_message_body_token3_value IN VARCHAR2
268 ,x_return_status OUT NOCOPY VARCHAR2) IS
269
270 BEGIN
271 NULL;
272 END set_notification_msg;
273
274 PROCEDURE notify_k_adm(
275 p_api_version IN NUMBER
276 ,p_init_msg_list IN VARCHAR2
277 ,p_application_name IN VARCHAR2
278 ,p_message_subject IN FND_NEW_MESSAGES.MESSAGE_NAME%TYPE
279 ,p_message_body IN FND_NEW_MESSAGES.MESSAGE_NAME%TYPE
280 ,p_message_body_token1 IN VARCHAR2
281 ,p_message_body_token1_value IN VARCHAR2
282 ,p_message_body_token2 IN VARCHAR2
283 ,p_message_body_token2_value IN VARCHAR2
284 ,p_message_body_token3 IN VARCHAR2
285 ,p_message_body_token3_value IN VARCHAR2
286 ,p_contract_id IN OKC_K_HEADERS_B.ID%TYPE
287 ,x_k_admin_user_name OUT NOCOPY VARCHAR2
288 ,x_return_status OUT NOCOPY VARCHAR2
289 ,x_msg_count OUT NOCOPY NUMBER
290 ,x_msg_data OUT NOCOPY VARCHAR2) IS
291
292 BEGIN
293 NULL;
294 END notify_k_adm;
295
296 PROCEDURE create_interaction_history(p_api_version IN NUMBER
297 ,p_init_msg_list IN VARCHAR2
298 ,p_contract_id IN NUMBER
299 ,p_party_id IN NUMBER
300 ,p_interaction_subject IN VARCHAR2
301 ,p_interaction_body IN VARCHAR2
302 ,x_return_status OUT NOCOPY VARCHAR2
303 ,x_msg_count OUT NOCOPY NUMBER
304 ,x_msg_data OUT NOCOPY VARCHAR2) IS
305 BEGIN
306 NULL;
307 END create_interaction_history;
308
309 PROCEDURE get_articles (p_api_version IN NUMBER
310 ,p_init_msg_list IN VARCHAR2
311 ,p_contract_id IN NUMBER
312 ,p_release_id IN NUMBER
313 ,x_articles OUT NOCOPY OKC_K_ARTICLES_TL.TEXT%TYPE
314 ,x_return_status OUT NOCOPY VARCHAR2
315 ,x_msg_count OUT NOCOPY NUMBER
316 ,x_msg_data OUT NOCOPY VARCHAR2) IS
317 BEGIN
318 NULL;
319 END get_articles;
320
321 PROCEDURE notify_sales_rep (p_api_version IN NUMBER
322 ,p_init_msg_list IN VARCHAR2
323 ,p_contract_id IN NUMBER
324 ,p_contract_status IN VARCHAR2
325 ,x_return_status OUT NOCOPY VARCHAR2
326 ,x_msg_count OUT NOCOPY NUMBER
327 ,x_msg_data OUT NOCOPY VARCHAR2) IS
328
329 BEGIN
330 NULL;
331 END notify_sales_rep;
332
333 END OKC_OC_INT_QTK_PVT;