[Home] [Help]
PACKAGE: APPS.OKL_DEAL_CREAT_PVT
Source
1 PACKAGE okl_deal_creat_pvt AUTHID CURRENT_USER AS
2 /* $Header: OKLRDCRS.pls 120.3 2011/05/09 03:32:03 rpillay ship $ */
3
4 -------------------------------------------------------------------------------
5 -- GLOBAL EXCEPTION
6 ---------------------------------------------------------------------------
7 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
8
9 -- GLOBAL VARIABLES
10 ---------------------------------------------------------------------------
11 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_DEAL_CREAT_PVT';
12 G_APP_NAME CONSTANT VARCHAR2(3) := 'OKL';
13 OKL_TEMP_TYPE_PROGRAM CONSTANT VARCHAR2(30) := 'PROGRAM';
14 OKL_TEMP_TYPE_LEASEAPP CONSTANT VARCHAR2(30) := 'LEASEAPP';
15 OKL_TEMP_TYPE_CONTRACT CONSTANT VARCHAR2(30) := 'CONTRACT';
16 ---------------------------------------------------------------------------
17
18 -- SUBTYPE chrv_rec_type IS OKL_OKC_MIGRATION_PVT.chrv_rec_type;
19 -- SUBTYPE khrv_rec_type IS OKL_CONTRACT_PUB.khrv_rec_type;
20
21 TYPE deal_rec_type is record (
22 chr_id okl_k_headers_full_v.id%type
23 ,chr_contract_number okl_k_headers_full_v.contract_number%type
24 ,chr_description okl_k_headers_full_v.description%type
25 ,vers_version VARCHAR2(30)
26 ,chr_sts_code okl_k_headers_full_v.sts_code%type
27 ,chr_start_date okl_k_headers_full_v.start_date%type
28 ,chr_end_date okl_k_headers_full_v.end_date%type
29 ,khr_term_duration okl_k_headers_full_v.term_duration%type
30 ,chr_CUST_PO_NUMBER okl_k_headers_full_v.CUST_PO_NUMBER%type
31 ,chr_INV_ORGANIZATION_ID okl_k_headers_full_v.INV_ORGANIZATION_ID%type
32 ,chr_AUTHORING_ORG_ID okl_k_headers_full_v.AUTHORING_ORG_ID%type
33 ,khr_GENERATE_ACCRUAL_YN okl_k_headers_full_v.GENERATE_ACCRUAL_YN%type
34 ,khr_SYNDICATABLE_YN okl_k_headers_full_v.SYNDICATABLE_YN%type
35 ,khr_PREFUNDING_ELIGIBLE_YN okl_k_headers_full_v.PREFUNDING_ELIGIBLE_YN%type
36 ,khr_REVOLVING_CREDIT_YN okl_k_headers_full_v.REVOLVING_CREDIT_YN%type
37 ,khr_CONVERTED_ACCOUNT_YN okl_k_headers_full_v.CONVERTED_ACCOUNT_YN%type
38 ,khr_CREDIT_ACT_YN okl_k_headers_full_v.CREDIT_ACT_YN%type
39 ,chr_TEMPLATE_YN okl_k_headers_full_v.TEMPLATE_YN%type
40 ,chr_DATE_SIGNED okl_k_headers_full_v.DATE_SIGNED%type
41 ,khr_DATE_DEAL_TRANSFERRED okl_k_headers_full_v.DATE_DEAL_TRANSFERRED%type
42 ,khr_ACCEPTED_DATE okl_k_headers_full_v.ACCEPTED_DATE%type
43 ,khr_EXPECTED_DELIVERY_DATE okl_k_headers_full_v.EXPECTED_DELIVERY_DATE%type
44 ,khr_AMD_CODE okl_k_headers_full_v.AMD_CODE%type
45 ,khr_DEAL_TYPE okl_k_headers_full_v.DEAL_TYPE%type
46 ,mla_contract_number okl_k_headers_full_v.contract_number%type
47 ,mla_gvr_chr_id_referred okc_governances_v.chr_id_referred%type
48 ,mla_gvr_id okl_k_headers_full_v.id%type
49 ,cust_id okc_k_party_roles_v.id%type
50 ,cust_object1_id1 okc_k_party_roles_v.object1_id1%type
51 ,cust_object1_id2 okc_k_party_roles_v.object1_id2%type
52 ,cust_jtot_object1_code okc_k_party_roles_v.jtot_object1_code%type
53 ,cust_name varchar2(250)
54 ,lessor_id okc_k_party_roles_v.id%type
55 ,lessor_object1_id1 okc_k_party_roles_v.object1_id1%type
56 ,lessor_object1_id2 okc_k_party_roles_v.object1_id2%type
57 ,lessor_jtot_object1_code okc_k_party_roles_v.jtot_object1_code%type
58 ,lessor_name varchar2(250)
59 ,chr_currency_code okl_k_headers_full_v.currency_code%type
60 ,currency_name varchar2(250)
61 ,khr_pdt_id okl_k_headers_full_v.pdt_id%type
62 ,product_name okl_products_v.name%type
63 ,product_description okl_products_v.description%type
64 ,khr_khr_id okl_k_headers_full_v.khr_id%type
65 ,program_contract_number okl_k_headers_full_v.contract_number%type
66 ,cl_contract_number okl_k_headers_full_v.contract_number%type
67 ,cl_gvr_chr_id_referred okl_k_headers_full_v.id%type
68 ,cl_gvr_id okl_k_headers_full_v.id%type
69 ,rg_larles_id okc_rule_groups_v.id%type
70 ,r_larles_id okc_rule_groups_v.id%type
71 ,r_larles_rule_information1 okc_rules_v.rule_information1%type
72 ,col_larles_form_left_prompt varchar2(250)
73 ,rg_LAREBL_id okc_rule_groups_v.id%type
74 ,r_LAREBL_id okc_rule_groups_v.id%type
75 ,r_LAREBL_rule_information1 okc_rules_v.rule_information1%type
76 ,col_larebl_form_left_prompt varchar2(250)
77 ,chr_cust_acct_id okc_k_headers_b.cust_acct_id%type
78 ,customer_account varchar2(250)
79 ,cust_site_description varchar2(250)
80 ,contact_id okc_contacts_v.id%type
81 ,contact_object1_id1 okc_contacts_v.object1_id1%type
82 ,contact_object1_id2 okc_contacts_v.object1_id2%type
83 ,contact_jtot_object1_code okc_contacts_v.jtot_object1_code%type
84 ,contact_name varchar2(250)
85 ,rg_LATOWN_id okc_rule_groups_v.id%type
86 ,r_LATOWN_id okc_rule_groups_v.id%type
87 ,r_LATOWN_rule_information1 okc_rules_v.rule_information1%type
88 ,col_latown_form_left_prompt varchar2(250)
89 ,rg_LANNTF_id okc_rule_groups_v.id%type
90 ,r_LANNTF_id okc_rule_groups_v.id%type
91 ,r_LANNTF_rule_information1 okc_rules_v.rule_information1%type
92 ,col_lanntf_form_left_prompt varchar2(250)
93 ,rg_LACPLN_id okc_rule_groups_v.id%type
94 ,r_LACPLN_id okc_rule_groups_v.id%type
95 ,r_LACPLN_rule_information1 okc_rules_v.rule_information1%type
96 ,col_lacpln_form_left_prompt varchar2(250)
97 ,rg_LAPACT_id okc_rule_groups_v.id%type
98 ,r_LAPACT_id okc_rule_groups_v.id%type
99 ,r_LAPACT_rule_information1 okc_rules_v.rule_information1%type
100 ,col_lapact_form_left_prompt varchar2(250)
101 ,khr_CURRENCY_CONV_TYPE okl_k_headers_full_v.CURRENCY_CONVERSION_TYPE%type
102 ,khr_CURRENCY_CONV_RATE okl_k_headers_full_v.CURRENCY_CONVERSION_RATE%type
103 ,khr_CURRENCY_CONV_DATE okl_k_headers_full_v.CURRENCY_CONVERSION_DATE%type
104 ,khr_ASSIGNABLE_YN okl_k_headers_full_v.ASSIGNABLE_YN%type
105 --Added by dpsingh for LE Uptake
106 ,legal_entity_id NUMBER
107 -- sjalasut, added attribute columns below for okl_k_headers. START code changes
108 ,attribute_category okl_k_headers.attribute_category%TYPE
109 ,attribute1 okl_k_headers.attribute1%TYPE
110 ,attribute2 okl_k_headers.attribute2%TYPE
111 ,attribute3 okl_k_headers.attribute3%TYPE
112 ,attribute4 okl_k_headers.attribute4%TYPE
113 ,attribute5 okl_k_headers.attribute5%TYPE
114 ,attribute6 okl_k_headers.attribute6%TYPE
115 ,attribute7 okl_k_headers.attribute7%TYPE
116 ,attribute8 okl_k_headers.attribute8%TYPE
117 ,attribute9 okl_k_headers.attribute9%TYPE
118 ,attribute10 okl_k_headers.attribute10%TYPE
119 ,attribute11 okl_k_headers.attribute11%TYPE
120 ,attribute12 okl_k_headers.attribute12%TYPE
121 ,attribute13 okl_k_headers.attribute13%TYPE
122 ,attribute14 okl_k_headers.attribute14%TYPE
123 ,attribute15 okl_k_headers.attribute15%TYPE
124 -- sjalasut, added attribute columns below for okl_k_headers. END code changes
125 -- ,labill_labacc_billto varchar2(200)
126 -- sjalasut, modified the record structure to have labill_labacc_billto data type of as number
127 ,labill_labacc_billto number
128 ,labill_labacc_rgp_id okc_rule_groups_b.id%TYPE
129 ,labill_labacc_rgd_code okc_rule_groups_b.rgd_code%TYPE
130 ,labill_labacc_rul_id okc_rules_b.id%TYPE
131 ,labill_labacc_rul_info_cat okc_rules_b.rule_information_category%TYPE
132 );
133
134 TYPE deal_tab_type is table of deal_rec_type INDEX BY BINARY_INTEGER;
135
136 TYPE party_rec_type is record (
137 id NUMBER := OKL_API.G_MISS_NUM
138 ,attribute_category OKL_K_PARTY_ROLES.ATTRIBUTE_CATEGORY%TYPE := OKL_API.G_MISS_CHAR
139 ,attribute1 OKL_K_PARTY_ROLES.ATTRIBUTE1%TYPE := OKL_API.G_MISS_CHAR
140 ,attribute2 OKL_K_PARTY_ROLES.ATTRIBUTE2%TYPE := OKL_API.G_MISS_CHAR
141 ,attribute3 OKL_K_PARTY_ROLES.ATTRIBUTE3%TYPE := OKL_API.G_MISS_CHAR
142 ,attribute4 OKL_K_PARTY_ROLES.ATTRIBUTE4%TYPE := OKL_API.G_MISS_CHAR
143 ,attribute5 OKL_K_PARTY_ROLES.ATTRIBUTE5%TYPE := OKL_API.G_MISS_CHAR
144 ,attribute6 OKL_K_PARTY_ROLES.ATTRIBUTE6%TYPE := OKL_API.G_MISS_CHAR
145 ,attribute7 OKL_K_PARTY_ROLES.ATTRIBUTE7%TYPE := OKL_API.G_MISS_CHAR
146 ,attribute8 OKL_K_PARTY_ROLES.ATTRIBUTE8%TYPE := OKL_API.G_MISS_CHAR
147 ,attribute9 OKL_K_PARTY_ROLES.ATTRIBUTE9%TYPE := OKL_API.G_MISS_CHAR
148 ,attribute10 OKL_K_PARTY_ROLES.ATTRIBUTE10%TYPE := OKL_API.G_MISS_CHAR
149 ,attribute11 OKL_K_PARTY_ROLES.ATTRIBUTE11%TYPE := OKL_API.G_MISS_CHAR
150 ,attribute12 OKL_K_PARTY_ROLES.ATTRIBUTE12%TYPE := OKL_API.G_MISS_CHAR
151 ,attribute13 OKL_K_PARTY_ROLES.ATTRIBUTE13%TYPE := OKL_API.G_MISS_CHAR
152 ,attribute14 OKL_K_PARTY_ROLES.ATTRIBUTE14%TYPE := OKL_API.G_MISS_CHAR
153 ,attribute15 OKL_K_PARTY_ROLES.ATTRIBUTE15%TYPE := OKL_API.G_MISS_CHAR
154 ,object1_id1 OKC_K_PARTY_ROLES_B.object1_id1%type := OKL_API.G_MISS_CHAR
155 ,object1_id2 OKC_K_PARTY_ROLES_B.object1_id2%type := OKL_API.G_MISS_CHAR
156 ,jtot_object1_code OKC_K_PARTY_ROLES_B.jtot_object1_code%type := OKL_API.G_MISS_CHAR
157 ,rle_code OKC_K_PARTY_ROLES_B.rle_code%type := OKL_API.G_MISS_CHAR
158 ,chr_id OKC_K_PARTY_ROLES_B.chr_id%type := OKL_API.G_MISS_NUM
159 ,dnz_chr_id OKC_K_PARTY_ROLES_B.dnz_chr_id%type := OKL_API.G_MISS_NUM
160 ,cle_id OKC_K_PARTY_ROLES_B.cle_id%type := OKL_API.G_MISS_NUM
161 ,cognomen OKC_K_PARTY_ROLES_TL.cognomen%type := OKL_API.G_MISS_CHAR
162 ,alias OKC_K_PARTY_ROLES_TL.alias%type := OKL_API.G_MISS_CHAR
163 );
164
165 TYPE party_tab_type is table of party_rec_type INDEX BY BINARY_INTEGER;
166
167 TYPE deal_values_rec IS RECORD(
168 ACCEPTANCE_METHOD_MEANING VARCHAR2(200)
169 , ASSIGNABLE_MEANING VARCHAR2(200)
170 , BILL_TO_ADDRESS_DESC VARCHAR2(2000)
171 , BILL_TO_SITE_USE_ID NUMBER
172 , BOOK_CLASS_MEANING VARCHAR2(200)
173 , CAP_INTERIM_INTERST_MEANING VARCHAR2(200)
174 , CAP_INTERIM_INT_RGD_CODE VARCHAR2(200)
175 , CAP_INTERIM_INT_RGP_ID VARCHAR2(200)
176 , CAP_INTERIM_INT_RUL_ID VARCHAR2(200)
177 , CAP_INTERIM_INT_RUL_INF1 VARCHAR2(200)
178 , CAP_INTERIM_INT_RUL_INF_CAT VARCHAR2(200)
179 , COL_LACPLN_FORM_LEFT_PROMPT VARCHAR2(200)
180 , COL_LANNTF_FORM_LEFT_PROMPT VARCHAR2(200)
181 , COL_LAPACT_FORM_LEFT_PROMPT VARCHAR2(200)
182 , COL_LAREBL_FORM_LEFT_PROMPT VARCHAR2(200)
183 , COL_LARLES_FORM_LEFT_PROMPT VARCHAR2(200)
184 , COL_LATOWN_FORM_LEFT_PROMPT VARCHAR2(200)
185 , CONSUMER_CREDIT_ACT_MEANING VARCHAR2(200)
186 , CONVERTED_ACCT_MEANING VARCHAR2(200)
187 , CREDIT_GVR_ID VARCHAR2(200)
188 , CREDIT_LINE_CHR_ID VARCHAR2(200)
189 , CREDIT_LINE_CONTRACT_NUMBER VARCHAR2(200)
190 , CURRENCY_CONV_TYPE_MEANING VARCHAR2(200)
191 , CUSTOMER_ACCOUNT VARCHAR2(200)
192 , CUSTOMER_CPL_ID VARCHAR2(200)
193 , CUSTOMER_JTOT_OBJECT1_CODE VARCHAR2(200)
194 , CUSTOMER_NAME VARCHAR2(200)
195 , CUSTOMER_OBJECT1_ID1 VARCHAR2(200)
196 , CUSTOMER_OBJECT1_ID2 VARCHAR2(200)
197 , CUST_ACCT_ID NUMBER
198 , CUST_PO_NUMBER VARCHAR2(150)
199 , DEAL_TYPE VARCHAR2(30)
200 , DESCRIPTION VARCHAR2(1995)
201 , ELIG_FOR_PREFUNDING_MEANING VARCHAR2(200)
202 , ID VARCHAR2(40)
203 , INTEREST_CALC_MEANING VARCHAR2(200)
204 , LEASE_APPLICATION_ID VARCHAR2(200)
205 , LEASE_APPLICATION_NAME VARCHAR2(200)
206 , LEDGER_ID NUMBER
207 , LEDGER_NAME VARCHAR2(200)
208 , LEGACY_NUMBER VARCHAR2(200)
209 , LEGAL_ADDRESS VARCHAR2(2000)
210 , LEGAL_ADDRESS_ID VARCHAR2(200)
211 , LEGAL_ENTITY_NAME VARCHAR2(200)
212 , LESSOR_INSURED_MEANING VARCHAR2(200)
213 , LESSOR_PAYEE_MEANING VARCHAR2(200)
214 , LESSOR_SERV_ORG_CODE VARCHAR2(30)
215 , MLA_CHR_ID VARCHAR2(200)
216 , MLA_CONTRACT_NUMBER VARCHAR2(200)
217 , MLA_GVR_ID VARCHAR2(200)
218 , NNTF_RGD_CODE VARCHAR2(200)
219 , NNTF_RGP_ID VARCHAR2(200)
220 , NNTF_RUL_ID VARCHAR2(200)
221 , NNTF_RUL_INF1 VARCHAR2(200)
222 , NNTF_RUL_INF_CAT VARCHAR2(200)
223 , NON_NOTIFICATION_MEANING VARCHAR2(200)
224 , OPERATING_UNIT_NAME VARCHAR2(200)
225 , ORIGINATION_LEASE_APPLICATION VARCHAR2(200)
226 , ORIGINATION_QUOTE_ID VARCHAR2(200)
227 , ORIGINATION_QUOTE_NAME VARCHAR2(200)
228 , ORIG_SYSTEM_ID1 NUMBER
229 , ORIG_SYSTEM_REFERENCE1 VARCHAR2(30)
230 , ORIG_SYSTEM_SOURCE_CODE VARCHAR2(30)
231 , PRIVATE_ACT_BOND_MEANING VARCHAR2(200)
232 , PRODUCT_DESCRIPTION VARCHAR2(200)
233 , PRODUCT_NAME VARCHAR2(200)
234 , PROGRAM_TEMPLATE_CHR_ID VARCHAR2(200)
235 , PROGRAM_TEMPLATE_NAME VARCHAR2(200)
236 , PRV_ACT_BOND_RGD_CODE VARCHAR2(200)
237 , PRV_ACT_BOND_RGP_ID VARCHAR2(200)
238 , PRV_ACT_BOND_RUL_ID VARCHAR2(200)
239 , PRV_ACT_BOND_RUL_INF1 VARCHAR2(200)
240 , PRV_ACT_BOND_RUL_INF_CAT VARCHAR2(200)
241 , REBOOK_LIMIT_DATE DATE
242 , REBOOK_LIMIT_DATE_RGD_CODE VARCHAR2(200)
243 , REBOOK_LIMIT_DATE_RGP_ID VARCHAR2(200)
244 , REBOOK_LIMIT_DATE_RUL_ID VARCHAR2(200)
245 , REBOOK_LIMIT_RUL_INF1 VARCHAR2(200)
246 , REBOOK_LIMIT_RUL_INF_CAT VARCHAR2(200)
247 , REPLACES_CHR_ID VARCHAR2(200)
248 , REPLACES_CONTRACT_NUMBER VARCHAR2(200)
249 , REP_CONTACT_ID NUMBER
250 , REP_CONTACT_JTOT_OBJECT1_CODE VARCHAR2(200)
251 , REP_CONTACT_OBJECT1_ID1 NUMBER
252 , REP_CONTACT_OBJECT1_ID2 NUMBER
253 , REVENUE_RECOGNITION_MEANING VARCHAR2(200)
254 , REVOLVING_CREDIT_YN VARCHAR2(3)
255 , RLES_RGD_CODE VARCHAR2(200)
256 , RLES_RGP_ID VARCHAR2(200)
257 , RLES_RUL_ID VARCHAR2(200)
258 , RLES_RUL_INF1 VARCHAR2(200)
259 , RLES_RUL_INF_CAT VARCHAR2(200)
260 , RELEASED_ASSET_MEANING VARCHAR2(200)
261 , SALES_REPRESENTATIVE_NAME VARCHAR2(200)
262 , SCS_CODE_MEANING VARCHAR2(200)
263 , SPLIT_FROM_CHR_ID VARCHAR2(200)
264 , SPLIT_FROM_CONTRACT_NUMBER VARCHAR2(200)
265 , STS_CODE_MEANING VARCHAR2(200)
266 , TAX_OWNER_CODE VARCHAR2(200)
267 , TAX_OWNER_MEANING VARCHAR2(200)
268 , TAX_OWNER_RGD_CODE VARCHAR2(200)
269 , TAX_OWNER_RGP_ID VARCHAR2(200)
270 , TAX_OWNER_RUL_ID VARCHAR2(200)
271 , TAX_OWNER_RUL_INF1 VARCHAR2(200)
272 , TAX_OWNER_RUL_INF_CAT VARCHAR2(200)
273 , UPG_ORIG_SYSTEM_REF VARCHAR2(60)
274 , UPG_ORIG_SYSTEM_REF_ID NUMBER
275 , VPA_CONTRACT_NUMBER VARCHAR2(200)
276 , VPA_KHR_ID VARCHAR2(40)
277 , VERS_VERSION VARCHAR2(200)
278 , PRODUCT_SUBCLASS_CODE VARCHAR2(200)
279 , BILL_TO_RGP_ID VARCHAR2(40)
280 , BILL_TO_RUL_ID VARCHAR2(40)
281 , BILL_TO_RGD_CODE VARCHAR2(40)
282 , BILL_TO_RUL_INF_CAT VARCHAR2(40)
283 , BILL_TO_RUL_INF1 NUMBER
284 , LAST_ACTIVATION_DATE DATE
285 );
286
287 TYPE deal_values_tbl is table of deal_rec_type INDEX BY BINARY_INTEGER;
288
289 TYPE booking_summary_rec IS RECORD(
290 DNZ_CHR_ID NUMBER
291 , TOTAL_FINANCED_AMOUNT VARCHAR2(200)
292 , TOTAL_RESIDUAL_AMOUNT VARCHAR2(200)
293 , TOTAL_FUNDED VARCHAR2(200)
294 , TOTAL_SUBSIDIES VARCHAR2(200)
295 , EOT_OPTION VARCHAR2(200)
296 , EOT_AMOUNT VARCHAR2(200)
297 , TOTAL_UPFRONT_SALES_TAX VARCHAR2(200)
298 , RVI_PREMIUM VARCHAR2(200));
299
300 PROCEDURE create_deal(
301 p_api_version IN NUMBER,
302 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
303 x_return_status OUT NOCOPY VARCHAR2,
304 x_msg_count OUT NOCOPY NUMBER,
305 x_msg_data OUT NOCOPY VARCHAR2,
306 p_contract_number IN VARCHAR2,
307 p_scs_code IN VARCHAR2,
308 p_customer_id1 IN VARCHAR2,
309 p_customer_id2 IN VARCHAR2,
310 p_customer_code IN VARCHAR2,
311 p_org_id IN NUMBER,
312 p_organization_id IN NUMBER,
313 p_source_chr_id IN NUMBER,
314 x_chr_id OUT NOCOPY NUMBER,
315 --Added by dpsingh for LE Uptake
316 p_legal_entity_id IN NUMBER);
317
318 PROCEDURE create_deal(
319 p_api_version IN NUMBER,
320 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
321 x_return_status OUT NOCOPY VARCHAR2,
322 x_msg_count OUT NOCOPY NUMBER,
323 x_msg_data OUT NOCOPY VARCHAR2,
324 p_source_code IN VARCHAR2,
325 p_contract_number IN VARCHAR2,
326 p_scs_code IN VARCHAR2,
327 p_customer_id1 IN VARCHAR2,
328 p_customer_id2 IN VARCHAR2,
329 p_customer_code IN VARCHAR2,
330 p_org_id IN NUMBER,
331 p_organization_id IN NUMBER,
332 p_source_chr_id IN NUMBER,
333 x_chr_id OUT NOCOPY NUMBER,
334 --Added by dpsingh for LE Uptake
335 p_legal_entity_id IN NUMBER);
336
337 PROCEDURE update_deal(
338 p_api_version IN NUMBER,
339 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
340 x_return_status OUT NOCOPY VARCHAR2,
341 x_msg_count OUT NOCOPY NUMBER,
342 x_msg_data OUT NOCOPY VARCHAR2,
343 p_durv_rec IN deal_rec_type,
344 x_durv_rec OUT NOCOPY deal_rec_type
345 );
346
347 PROCEDURE load_deal(
348 p_api_version IN NUMBER,
349 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
350 x_return_status OUT NOCOPY VARCHAR2,
351 x_msg_count OUT NOCOPY NUMBER,
352 x_msg_data OUT NOCOPY VARCHAR2,
353 p_durv_rec IN deal_rec_type,
354 x_durv_rec OUT NOCOPY deal_rec_type
355 );
356
357
358 PROCEDURE create_deal(
359 p_api_version IN NUMBER,
360 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
361 x_return_status OUT NOCOPY VARCHAR2,
362 x_msg_count OUT NOCOPY NUMBER,
363 x_msg_data OUT NOCOPY VARCHAR2,
364 p_source_code IN VARCHAR2,
365 p_contract_number IN VARCHAR2,
366 p_scs_code IN VARCHAR2,
367 p_customer_id1 IN OUT NOCOPY VARCHAR2,
368 p_customer_id2 IN OUT NOCOPY VARCHAR2,
369 p_customer_code IN VARCHAR2,
370 p_customer_name IN VARCHAR2,
371 p_org_id IN NUMBER,
372 p_organization_id IN NUMBER,
373 p_source_chr_id IN OUT NOCOPY NUMBER,
374 p_source_contract_number IN VARCHAR2,
375 x_chr_id OUT NOCOPY NUMBER,
376 --Added by dpsingh for LE Uptake
377 p_legal_entity_id IN NUMBER);
378
379 PROCEDURE create_deal(
380 p_api_version IN NUMBER,
381 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
382 x_return_status OUT NOCOPY VARCHAR2,
383 x_msg_count OUT NOCOPY NUMBER,
384 x_msg_data OUT NOCOPY VARCHAR2,
385 p_source_code IN VARCHAR2,
386 p_template_yn IN VARCHAR2,
387 p_contract_number IN VARCHAR2,
388 p_scs_code IN VARCHAR2,
389 p_customer_id1 IN OUT NOCOPY VARCHAR2,
390 p_customer_id2 IN OUT NOCOPY VARCHAR2,
391 p_customer_code IN VARCHAR2,
392 p_customer_name IN VARCHAR2,
393 p_org_id IN NUMBER,
394 p_organization_id IN NUMBER,
395 p_source_chr_id IN OUT NOCOPY NUMBER,
396 p_source_contract_number IN VARCHAR2,
397 x_chr_id OUT NOCOPY NUMBER,
398 --Added by dpsingh for LE Uptake
399 p_legal_entity_id IN NUMBER);
400
401 PROCEDURE create_deal(
402 p_api_version IN NUMBER,
403 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
404 x_return_status OUT NOCOPY VARCHAR2,
405 x_msg_count OUT NOCOPY NUMBER,
406 x_msg_data OUT NOCOPY VARCHAR2,
407 p_source_code IN VARCHAR2,
408 p_template_type IN VARCHAR2,
409 p_contract_number IN VARCHAR2,
410 p_scs_code IN VARCHAR2,
411 p_customer_id1 IN OUT NOCOPY VARCHAR2,
412 p_customer_id2 IN OUT NOCOPY VARCHAR2,
413 p_customer_code IN VARCHAR2,
414 p_customer_name IN VARCHAR2,
415 p_effective_from IN DATE,
416 p_program_name IN VARCHAR2,
417 p_program_id IN NUMBER,
418 p_org_id IN NUMBER,
419 p_organization_id IN NUMBER,
420 p_source_chr_id IN OUT NOCOPY NUMBER,
421 p_source_contract_number IN VARCHAR2,
422 x_chr_id OUT NOCOPY NUMBER,
423 --Added by dpsingh for LE Uptake
424 p_legal_entity_id IN NUMBER);
425
426
427 PROCEDURE copy_rules(
428 p_api_version IN NUMBER,
429 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
430 x_return_status OUT NOCOPY VARCHAR2,
431 x_msg_count OUT NOCOPY NUMBER,
432 x_msg_data OUT NOCOPY VARCHAR2,
433 p_source_id IN NUMBER,
434 p_dest_id IN NUMBER,
435 p_org_id IN NUMBER,
436 p_organization_id IN NUMBER);
437
438 Procedure confirm_cancel_contract
439 (p_api_version IN NUMBER,
440 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
441 x_return_status OUT NOCOPY VARCHAR2,
442 x_msg_count OUT NOCOPY NUMBER,
443 x_msg_data OUT NOCOPY VARCHAR2,
444 p_contract_id IN NUMBER,
445 p_contract_number IN VARCHAR2);
446
447 PROCEDURE create_party(
448 p_api_version IN NUMBER,
449 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
450 x_return_status OUT NOCOPY VARCHAR2,
451 x_msg_count OUT NOCOPY NUMBER,
452 x_msg_data OUT NOCOPY VARCHAR2,
453 p_kpl_rec IN party_rec_type,
454 x_kpl_rec OUT NOCOPY party_rec_type
455 );
456
457 PROCEDURE update_party(
458 p_api_version IN NUMBER,
459 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
460 x_return_status OUT NOCOPY VARCHAR2,
461 x_msg_count OUT NOCOPY NUMBER,
462 x_msg_data OUT NOCOPY VARCHAR2,
463 p_kpl_rec IN party_rec_type,
464 x_kpl_rec OUT NOCOPY party_rec_type
465 );
466
467 PROCEDURE copy_lease_contract(
468 p_api_version IN NUMBER,
469 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
470 x_return_status OUT NOCOPY VARCHAR2,
471 x_msg_count OUT NOCOPY NUMBER,
472 x_msg_data OUT NOCOPY VARCHAR2,
473 p_contract_number IN VARCHAR2,
474 p_source_chr_id IN NUMBER,
475 x_chr_id OUT NOCOPY NUMBER);
476
477 PROCEDURE load_deal(
478 p_api_version IN NUMBER,
479 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
480 x_return_status OUT NOCOPY VARCHAR2,
481 x_msg_count OUT NOCOPY NUMBER,
482 x_msg_data OUT NOCOPY VARCHAR2,
483 p_chr_id IN NUMBER,
484 x_deal_values_rec OUT NOCOPY deal_values_rec
485 );
486
487 -- Start of comments
488 -- API name : load_booking_summary
489 -- Pre-reqs : None
490 -- Function : This procedure loads booking summary record
491 -- Parameters :
492 -- IN : p_api_version - Standard input parameter
493 -- p_init_msg_list - Standard input parameter
494 -- p_chr_id - Contract ID
495 -- Version : 1.0
496 -- History : asahoo created.
497 -- End of comments
498
499 PROCEDURE load_booking_summary(
500 p_api_version IN NUMBER,
501 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
502 x_return_status OUT NOCOPY VARCHAR2,
503 x_msg_count OUT NOCOPY NUMBER,
504 x_msg_data OUT NOCOPY VARCHAR2,
505 p_chr_id IN NUMBER,
506 x_booking_summary_rec OUT NOCOPY booking_summary_rec);
507
508 END OKL_DEAL_CREAT_PVT;