1 Package OKC_COPY_CONTRACT_PVT AS
2 /*$Header: OKCRCPYS.pls 120.2.12010000.3 2008/10/31 10:22:40 harchand ship $*/
3
4
5 SUBTYPE chrv_rec_type IS OKC_CONTRACT_PUB.chrv_rec_type;
6 SUBTYPE chrv_tbl_type IS OKC_CONTRACT_PUB.chrv_tbl_type;
7 SUBTYPE clev_rec_type IS OKC_CONTRACT_PUB.clev_rec_type;
8 SUBTYPE clev_tbl_type IS OKC_CONTRACT_PUB.clev_tbl_type;
9 SUBTYPE cacv_rec_type IS OKC_CONTRACT_PUB.cacv_rec_type;
10 SUBTYPE cacv_tbl_type IS OKC_CONTRACT_PUB.cacv_tbl_type;
11 SUBTYPE cpsv_rec_type IS OKC_CONTRACT_PUB.cpsv_rec_type;
12 SUBTYPE cpsv_tbl_type IS OKC_CONTRACT_PUB.cpsv_tbl_type;
13 SUBTYPE rulv_rec_type IS OKC_RULE_PUB.rulv_rec_type;
14 SUBTYPE rulv_tbl_type IS OKC_RULE_PUB.rulv_tbl_type;
15 SUBTYPE rgpv_rec_type IS OKC_RULE_PUB.rgpv_rec_type;
16 SUBTYPE rgpv_tbl_type IS OKC_RULE_PUB.rgpv_tbl_type;
17 SUBTYPE rmpv_rec_type IS OKC_RULE_PUB.rmpv_rec_type;
18 SUBTYPE rmpv_tbl_type IS OKC_RULE_PUB.rmpv_tbl_type;
19 SUBTYPE catv_rec_type IS OKC_K_ARTICLE_PUB.catv_rec_type;
20 SUBTYPE catv_tbl_type IS OKC_K_ARTICLE_PUB.catv_tbl_type;
21 SUBTYPE atnv_rec_type IS OKC_K_ARTICLE_PUB.atnv_rec_type;
22 SUBTYPE atnv_tbl_type IS OKC_K_ARTICLE_PUB.atnv_tbl_type;
23 SUBTYPE cnhv_rec_type IS OKC_CONDITIONS_PUB.cnhv_rec_type;
24 SUBTYPE cnhv_tbl_type IS OKC_CONDITIONS_PUB.cnhv_tbl_type;
25 SUBTYPE cnlv_rec_type IS OKC_CONDITIONS_PUB.cnlv_rec_type;
26 SUBTYPE cnlv_tbl_type IS OKC_CONDITIONS_PUB.cnlv_tbl_type;
27 SUBTYPE cimv_rec_type IS OKC_CONTRACT_ITEM_PUB.cimv_rec_type;
28 SUBTYPE cimv_tbl_type IS OKC_CONTRACT_ITEM_PUB.cimv_tbl_type;
29 SUBTYPE cplv_rec_type IS OKC_CONTRACT_PARTY_PUB.cplv_rec_type;
30 SUBTYPE cplv_tbl_type IS OKC_CONTRACT_PARTY_PUB.cplv_tbl_type;
31 SUBTYPE cgcv_rec_type IS OKC_CONTRACT_GROUP_PUB.cgcv_rec_type;
32 SUBTYPE cgcv_tbl_type IS OKC_CONTRACT_GROUP_PUB.cgcv_tbl_type;
33 SUBTYPE ctcv_rec_type IS OKC_CONTRACT_PARTY_PUB.ctcv_rec_type;
34 SUBTYPE ctcv_tbl_type IS OKC_CONTRACT_PARTY_PUB.ctcv_tbl_type;
35 SUBTYPE tvev_rec_type IS OKC_TIMEVALUES_V%ROWTYPE;
36
37 ---------------------------------------------------------------------------
38 -- GLOBAL MESSAGE CONSTANTS
39 ---------------------------------------------------------------------------
40 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
41 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
42 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
43 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
44 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
45 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
46 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
47 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
48 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
49 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
50 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
51 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
52 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
53 G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UPPERCASE_REQ';
54
55 ------------------------------------------------------------------------------------
56 -- GLOBAL EXCEPTION
57 ---------------------------------------------------------------------------
58 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
59
60 -- GLOBAL VARIABLES
61 ---------------------------------------------------------------------------
62 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_COPY_CONTRACT_PVT';
63 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
64 g_rulv_rec rulv_rec_type;
65 ---------------------------------------------------------------------------
66
67 TYPE api_components_rec IS RECORD(id NUMBER,
68 to_k NUMBER,
69 component_type VARCHAR2(30),
70 attribute1 VARCHAR2(100));
71 TYPE api_components_tbl IS TABLE OF api_components_rec
72 INDEX BY BINARY_INTEGER;
73
74 TYPE api_lines_rec IS RECORD(id NUMBER,
75 to_k NUMBER,
76 to_line NUMBER,
77 lse_id NUMBER,
78 line_exists_yn VARCHAR2(1),
79 line_exp_yn VARCHAR2(1)); --Bug 3990643
80 TYPE api_lines_tbl IS TABLE OF api_lines_rec
81 INDEX BY BINARY_INTEGER;
82
83 FUNCTION update_target_contract(p_chr_id IN NUMBER) RETURN BOOLEAN;
84 FUNCTION is_copy_allowed(p_chr_id IN NUMBER,p_sts_code IN VARCHAR2 DEFAULT NULL) RETURN BOOLEAN;
85 FUNCTION is_subcontract_allowed(p_chr_id IN NUMBER,p_sts_code IN VARCHAR2) RETURN BOOLEAN;
86
87 PROCEDURE derive_line_style(p_old_lse_id IN NUMBER,
88 p_old_jtot_code IN VARCHAR2,
89 p_new_subclass IN VARCHAR2,
90 p_new_parent_lse IN NUMBER,
91 x_new_lse_count OUT NOCOPY NUMBER,
92 x_new_lse_ids OUT NOCOPY VARCHAR2);
93
94 PROCEDURE copy_components(
95 p_api_version IN NUMBER,
96 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
97 x_return_status OUT NOCOPY VARCHAR2,
98 x_msg_count OUT NOCOPY NUMBER,
99 x_msg_data OUT NOCOPY VARCHAR2,
100 p_from_chr_id IN NUMBER,
101 p_to_chr_id IN NUMBER,
102 p_contract_number IN VARCHAR2,
103 p_contract_number_modifier IN VARCHAR2,
104 p_to_template_yn IN VARCHAR2 DEFAULT 'N',
105 p_copy_reference IN VARCHAR2 DEFAULT 'COPY',
106 p_copy_line_party_yn IN VARCHAR2,
107 p_scs_code IN VARCHAR2,
108 p_intent IN VARCHAR2,
109 p_prospect IN VARCHAR2,
110 p_components_tbl IN api_components_tbl,
111 p_lines_tbl IN api_lines_tbl,
112 x_chr_id OUT NOCOPY NUMBER,
113 p_concurrent_request IN VARCHAR2 DEFAULT 'N',
114 p_include_cancelled_lines IN VARCHAR2 DEFAULT 'Y',
115 p_include_terminated_lines IN VARCHAR2 DEFAULT 'Y');
116 -- Bug 2950549 - Added parameter p_concurrent_request in the above procedure
117
118
119 PROCEDURE copy_contract(
120 p_api_version IN NUMBER,
121 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
122 x_return_status OUT NOCOPY VARCHAR2,
123 x_msg_count OUT NOCOPY NUMBER,
124 x_msg_data OUT NOCOPY VARCHAR2,
125 p_commit IN VARCHAR2 DEFAULT 'F',
126 p_chr_id IN NUMBER,
127 p_contract_number IN VARCHAR2,
128 p_contract_number_modifier IN VARCHAR2,
129 p_to_template_yn IN VARCHAR2,
130 p_renew_ref_yn IN VARCHAR2,
131 p_copy_lines_yn IN VARCHAR2,
132 p_override_org IN VARCHAR2 DEFAULT 'N',
133 p_copy_from_history_yn IN VARCHAR2 DEFAULT 'N',
134 p_from_version_number IN NUMBER DEFAULT NULL,
135 p_copy_latest_articles IN VARCHAR2 DEFAULT 'Y',
136 p_calling_mode IN VARCHAR2 DEFAULT 'OKC',
137 x_chr_id OUT NOCOPY NUMBER);
138
139 PROCEDURE copy_contract_lines(
140 p_api_version IN NUMBER,
141 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
142 x_return_status OUT NOCOPY VARCHAR2,
143 x_msg_count OUT NOCOPY NUMBER,
144 x_msg_data OUT NOCOPY VARCHAR2,
145 p_from_cle_id IN NUMBER,
146 p_to_cle_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
147 p_to_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
148 p_to_template_yn IN VARCHAR2,
149 p_copy_reference IN VARCHAR2,
150 p_copy_line_party_yn IN VARCHAR2,
151 p_renew_ref_yn IN VARCHAR2,
152 p_generate_line_number IN VARCHAR2 DEFAULT 'Y', -- Added for Bug 2489856
153 x_cle_id OUT NOCOPY NUMBER,
154 p_change_status IN VARCHAR2 DEFAULT 'Y'); -- LLC Added additional flag parameter to the call
155 -- to not allow change of status of sublines of the
156 -- topline during update service
157
158 PROCEDURE copy_contract_header(
159 p_api_version IN NUMBER,
160 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
161 x_return_status OUT NOCOPY VARCHAR2,
162 x_msg_count OUT NOCOPY NUMBER,
163 x_msg_data OUT NOCOPY VARCHAR2,
164 p_from_chr_id IN NUMBER,
165 p_contract_number IN VARCHAR2,
166 p_contract_number_modifier IN VARCHAR2,
167 p_scs_code IN VARCHAR2,
168 p_intent IN VARCHAR2,
169 p_prospect IN VARCHAR2,
170 p_called_from IN VARCHAR2,
171 p_to_template_yn IN VARCHAR2,
172 p_renew_ref_yn IN VARCHAR2,
173 p_override_org IN VARCHAR2 DEFAULT 'N',
174 p_calling_mode IN VARCHAR2 DEFAULT 'OKC',
175 x_chr_id OUT NOCOPY NUMBER);
176
177 PROCEDURE copy_contract_line(
178 p_api_version IN NUMBER,
179 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
180 x_return_status OUT NOCOPY VARCHAR2,
181 x_msg_count OUT NOCOPY NUMBER,
182 x_msg_data OUT NOCOPY VARCHAR2,
183 p_from_cle_id IN NUMBER,
184 p_from_chr_id IN NUMBER,
185 p_to_cle_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
186 p_to_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
187 p_lse_id IN NUMBER,
188 p_to_template_yn IN VARCHAR2,
189 p_copy_reference IN VARCHAR2 DEFAULT 'COPY',
190 p_copy_line_party_yn IN VARCHAR2,
191 p_renew_ref_yn IN VARCHAR2,
192 p_generate_line_number IN VARCHAR2 DEFAULT 'Y', -- Added for Bug 2489856
193 x_cle_id OUT NOCOPY NUMBER,
194 p_change_status IN VARCHAR2 DEFAULT 'Y'); -- LLC Added additional flag parameter to the call
195 -- to not allow change of status of sublines of the
196 -- topline during update service
197
198 PROCEDURE copy_party_roles(
199 p_api_version IN NUMBER,
200 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
201 x_return_status OUT NOCOPY VARCHAR2,
202 x_msg_count OUT NOCOPY NUMBER,
203 x_msg_data OUT NOCOPY VARCHAR2,
204 p_cpl_id IN NUMBER,
205 p_cle_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
206 p_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
207 p_rle_code IN VARCHAR2,
208 x_cpl_id OUT NOCOPY NUMBER);
209
210 PROCEDURE copy_articles(
211 p_api_version IN NUMBER,
212 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
213 x_return_status OUT NOCOPY VARCHAR2,
214 x_msg_count OUT NOCOPY NUMBER,
215 x_msg_data OUT NOCOPY VARCHAR2,
216 p_cat_id IN NUMBER,
217 p_cle_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
218 p_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
219 p_sav_sav_release IN VARCHAR2 DEFAULT NULL,
220 x_cat_id OUT NOCOPY NUMBER);
221
222 PROCEDURE copy_latest_articles(
223 p_api_version IN NUMBER,
224 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
225 x_return_status OUT NOCOPY VARCHAR2,
226 x_msg_count OUT NOCOPY NUMBER,
227 x_msg_data OUT NOCOPY VARCHAR2,
228 p_cat_id IN NUMBER,
229 p_cle_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
230 p_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
231 x_cat_id OUT NOCOPY NUMBER);
232
233 PROCEDURE copy_events(
234 p_api_version IN NUMBER,
235 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
236 x_return_status OUT NOCOPY VARCHAR2,
237 x_msg_count OUT NOCOPY NUMBER,
238 x_msg_data OUT NOCOPY VARCHAR2,
239 p_cnh_id IN NUMBER,
240 p_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
241 p_to_template_yn IN VARCHAR2,
242 x_cnh_id OUT NOCOPY NUMBER);
243
244 PROCEDURE copy_rules(
245 p_api_version IN NUMBER,
246 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
247 x_return_status OUT NOCOPY VARCHAR2,
248 x_msg_count OUT NOCOPY NUMBER,
249 x_msg_data OUT NOCOPY VARCHAR2,
250 p_rgp_id IN NUMBER,
251 p_cle_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
252 p_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
253 p_to_template_yn IN VARCHAR2,
254 x_rgp_id OUT NOCOPY NUMBER);
255
256 -- Bug 2950549 Added following 2 procedures add_concurrent and
257 -- copy_concurrent
258
259 PROCEDURE add_concurrent(p_components_tbl IN api_components_tbl,
260 p_lines_tbl IN api_lines_tbl,
261 p_from_chr_id IN NUMBER,
262 p_to_chr_id IN NUMBER,
263 p_contract_number IN VARCHAR2,
264 p_contract_number_modifier IN VARCHAR2,
265 p_to_template_yn IN VARCHAR2 DEFAULT 'N',
266 p_copy_reference IN VARCHAR2 DEFAULT 'COPY',
267 p_copy_line_party_yn IN VARCHAR2,
268 p_scs_code IN VARCHAR2,
269 p_intent IN VARCHAR2,
270 p_prospect IN VARCHAR,
271 p_include_cancelled_lines IN VARCHAR2 DEFAULT 'Y', p_include_terminated_lines IN VARCHAR2 DEFAULT 'Y');
272
273 PROCEDURE copy_concurrent(errbuf out NOCOPY VARCHAR2,
274 retcode out NOCOPY NUMBER,
275 p_id in NUMBER,
276 p_from_chr_id IN NUMBER,
277 p_to_chr_id IN NUMBER,
278 p_contract_number IN VARCHAR2,
279 p_contract_number_modifier IN VARCHAR2,
280 p_to_template_yn IN VARCHAR2,
281 p_copy_reference IN VARCHAR2,
282 p_copy_line_party_yn IN VARCHAR2,
283 p_scs_code IN VARCHAR2,
284 p_intent IN VARCHAR2,
285 p_prospect IN VARCHAR2,
286 p_copy_entire_k_yn IN VARCHAR2, /*hkamdar added new parameter for R12 copy enhancements.*/ p_include_cancelled_lines IN VARCHAR2 DEFAULT 'Y',
287 p_include_terminated_lines IN VARCHAR2 DEFAULT 'Y');
288 -- Bug 2950549 End of the procedures added
289
290 -- IKON ER 3819893
291 PROCEDURE UPDATE_TEMPLATE_CONTRACT (p_api_version IN NUMBER,
292 p_chr_id IN NUMBER,
293 p_start_date IN DATE,
294 p_end_date IN DATE,
295 x_msg_count OUT NOCOPY NUMBER,
296 x_msg_data OUT NOCOPY VARCHAR2,
297 x_return_status OUT NOCOPY VARCHAR2) ;
298
299
300
301 END OKC_COPY_CONTRACT_PVT;