eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.OKL_DEAL_CREAT_PVT dependencies on OKL_LLA_UTIL_PVT

Line 511: l_end_date := OKL_LLA_UTIL_PVT.calculate_end_date(get_k_start_date_and_term_rec.start_date,get_k_start_date_and_term_rec.term_duration);

507: CLOSE get_k_start_date_and_term_csr;
508: */
509: FOR get_k_start_date_and_term_rec IN get_k_start_date_and_term_csr(x_chr_id)
510: LOOP
511: l_end_date := OKL_LLA_UTIL_PVT.calculate_end_date(get_k_start_date_and_term_rec.start_date,get_k_start_date_and_term_rec.term_duration);
512: END LOOP;
513: -- END: cklee/mvasudev,6/2/2005, Bug#4392051/okl.h 4437938
514:
515: lp_chrv_rec.id := x_chr_id;

Line 4206: --l_check := Okl_Lla_Util_Pvt.check_new_contract(p_chr_id);

4202: BEGIN
4203:
4204: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
4205: -- Raise the event if it is a new Contract
4206: --l_check := Okl_Lla_Util_Pvt.check_new_contract(p_chr_id);
4207: --IF (l_check= OKL_API.G_TRUE) THEN
4208: IF (upper(p_source_code) = 'NEW') THEN
4209: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID,p_chr_id,l_parameter_list);
4210:

Line 4882: --l_check := Okl_Lla_Util_Pvt.check_new_contract(p_chr_id);

4878: BEGIN
4879:
4880: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
4881: -- Raise the event if it is a new Contract
4882: --l_check := Okl_Lla_Util_Pvt.check_new_contract(p_chr_id);
4883: --IF (l_check= OKL_API.G_TRUE) THEN
4884: IF (upper(p_source_code) = 'NEW') THEN
4885: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID,p_chr_id,l_parameter_list);
4886:

Line 6857: l_check := Okl_Lla_Util_Pvt.check_new_contract(p_chr_id);

6853: BEGIN
6854:
6855: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
6856: -- Raise the event if it is a new Contract
6857: l_check := Okl_Lla_Util_Pvt.check_new_contract(p_chr_id);
6858: IF (l_check= OKL_API.G_TRUE) THEN
6859: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID,p_chr_id,l_parameter_list);
6860: OKL_WF_PVT.raise_event (p_api_version => p_api_version,
6861: p_init_msg_list => p_init_msg_list,

Line 7152: lp_chrv_rec.end_date := OKL_LLA_UTIL_PVT.calculate_end_date(p_durv_rec.chr_start_date,p_durv_rec.khr_term_duration);

7148: OPEN l_end_date_csr;
7149: FETCH l_end_date_csr INTO lp_chrv_rec.end_date;
7150: CLOSE l_end_date_csr;
7151: */
7152: lp_chrv_rec.end_date := OKL_LLA_UTIL_PVT.calculate_end_date(p_durv_rec.chr_start_date,p_durv_rec.khr_term_duration);
7153: -- END: cklee/mvasudev,6/2/2005, Bug#4392051/okl.h 4437938
7154:
7155: x_durv_rec.chr_end_date := lp_chrv_rec.end_date;
7156:

Line 9176: X_DEAL_VALUES_REC.ACCEPTANCE_METHOD_MEANING := OKL_LLA_UTIL_PVT.GET_LOOKUP_MEANING('OKL_ACCEPTANCE_METHOD',L_HDR_UV_REC.KHR_AMD_CODE);

9172:
9173: OPEN c_hdr_full_v(p_chr_id);
9174: FETCH c_hdr_full_v INTO l_hdr_rec;
9175:
9176: X_DEAL_VALUES_REC.ACCEPTANCE_METHOD_MEANING := OKL_LLA_UTIL_PVT.GET_LOOKUP_MEANING('OKL_ACCEPTANCE_METHOD',L_HDR_UV_REC.KHR_AMD_CODE);
9177: X_DEAL_VALUES_REC.ASSIGNABLE_MEANING := OKL_LLA_UTIL_PVT.GET_LOOKUP_MEANING('OKL_YES_NO',l_HDR_UV_REC.KHR_ASSIGNABLE_YN);
9178: X_DEAL_VALUES_REC.BILL_TO_SITE_USE_ID := L_HDR_REC.BILL_TO_SITE_USE_ID;
9179:
9180: OPEN c_bill_to_site(l_HDR_REC.BILL_TO_SITE_USE_ID);

Line 9177: X_DEAL_VALUES_REC.ASSIGNABLE_MEANING := OKL_LLA_UTIL_PVT.GET_LOOKUP_MEANING('OKL_YES_NO',l_HDR_UV_REC.KHR_ASSIGNABLE_YN);

9173: OPEN c_hdr_full_v(p_chr_id);
9174: FETCH c_hdr_full_v INTO l_hdr_rec;
9175:
9176: X_DEAL_VALUES_REC.ACCEPTANCE_METHOD_MEANING := OKL_LLA_UTIL_PVT.GET_LOOKUP_MEANING('OKL_ACCEPTANCE_METHOD',L_HDR_UV_REC.KHR_AMD_CODE);
9177: X_DEAL_VALUES_REC.ASSIGNABLE_MEANING := OKL_LLA_UTIL_PVT.GET_LOOKUP_MEANING('OKL_YES_NO',l_HDR_UV_REC.KHR_ASSIGNABLE_YN);
9178: X_DEAL_VALUES_REC.BILL_TO_SITE_USE_ID := L_HDR_REC.BILL_TO_SITE_USE_ID;
9179:
9180: OPEN c_bill_to_site(l_HDR_REC.BILL_TO_SITE_USE_ID);
9181: FETCH c_bill_to_site INTO X_DEAL_VALUES_REC.BILL_TO_ADDRESS_DESC;

Line 9184: X_DEAL_VALUES_REC.BOOK_CLASS_MEANING := OKL_LLA_UTIL_PVT.GET_LOOKUP_MEANING('OKL_BOOK_CLASS',L_HDR_UV_REC.KHR_DEAL_TYPE);

9180: OPEN c_bill_to_site(l_HDR_REC.BILL_TO_SITE_USE_ID);
9181: FETCH c_bill_to_site INTO X_DEAL_VALUES_REC.BILL_TO_ADDRESS_DESC;
9182: CLOSE c_bill_to_site;
9183:
9184: X_DEAL_VALUES_REC.BOOK_CLASS_MEANING := OKL_LLA_UTIL_PVT.GET_LOOKUP_MEANING('OKL_BOOK_CLASS',L_HDR_UV_REC.KHR_DEAL_TYPE);
9185: X_DEAL_VALUES_REC.CAP_INTERIM_INTERST_MEANING := OKL_LLA_UTIL_PVT.GET_LOOKUP_MEANING('OKL_YES_NO',l_HDR_UV_REC.R_LACPLN_RULE_INFORMATION1);
9186: X_DEAL_VALUES_REC.CAP_INTERIM_INT_RGD_CODE := 'LACPLN';
9187: X_DEAL_VALUES_REC.CAP_INTERIM_INT_RGP_ID := L_HDR_UV_REC.RG_LACPLN_ID;
9188: X_DEAL_VALUES_REC.CAP_INTERIM_INT_RUL_ID := L_HDR_UV_REC.R_LACPLN_ID;

Line 9185: X_DEAL_VALUES_REC.CAP_INTERIM_INTERST_MEANING := OKL_LLA_UTIL_PVT.GET_LOOKUP_MEANING('OKL_YES_NO',l_HDR_UV_REC.R_LACPLN_RULE_INFORMATION1);

9181: FETCH c_bill_to_site INTO X_DEAL_VALUES_REC.BILL_TO_ADDRESS_DESC;
9182: CLOSE c_bill_to_site;
9183:
9184: X_DEAL_VALUES_REC.BOOK_CLASS_MEANING := OKL_LLA_UTIL_PVT.GET_LOOKUP_MEANING('OKL_BOOK_CLASS',L_HDR_UV_REC.KHR_DEAL_TYPE);
9185: X_DEAL_VALUES_REC.CAP_INTERIM_INTERST_MEANING := OKL_LLA_UTIL_PVT.GET_LOOKUP_MEANING('OKL_YES_NO',l_HDR_UV_REC.R_LACPLN_RULE_INFORMATION1);
9186: X_DEAL_VALUES_REC.CAP_INTERIM_INT_RGD_CODE := 'LACPLN';
9187: X_DEAL_VALUES_REC.CAP_INTERIM_INT_RGP_ID := L_HDR_UV_REC.RG_LACPLN_ID;
9188: X_DEAL_VALUES_REC.CAP_INTERIM_INT_RUL_ID := L_HDR_UV_REC.R_LACPLN_ID;
9189: X_DEAL_VALUES_REC.CAP_INTERIM_INT_RUL_INF1 := L_HDR_UV_REC.R_LACPLN_RULE_INFORMATION1;

Line 9191: X_DEAL_VALUES_REC.CONSUMER_CREDIT_ACT_MEANING := OKL_LLA_UTIL_PVT.GET_LOOKUP_MEANING('OKL_YES_NO',L_HDR_UV_REC.KHR_CREDIT_ACT_YN);

9187: X_DEAL_VALUES_REC.CAP_INTERIM_INT_RGP_ID := L_HDR_UV_REC.RG_LACPLN_ID;
9188: X_DEAL_VALUES_REC.CAP_INTERIM_INT_RUL_ID := L_HDR_UV_REC.R_LACPLN_ID;
9189: X_DEAL_VALUES_REC.CAP_INTERIM_INT_RUL_INF1 := L_HDR_UV_REC.R_LACPLN_RULE_INFORMATION1;
9190: X_DEAL_VALUES_REC.CAP_INTERIM_INT_RUL_INF_CAT := 'LACPLN';
9191: X_DEAL_VALUES_REC.CONSUMER_CREDIT_ACT_MEANING := OKL_LLA_UTIL_PVT.GET_LOOKUP_MEANING('OKL_YES_NO',L_HDR_UV_REC.KHR_CREDIT_ACT_YN);
9192: X_DEAL_VALUES_REC.CONVERTED_ACCT_MEANING := OKL_LLA_UTIL_PVT.GET_LOOKUP_MEANING('OKL_YES_NO',L_HDR_UV_REC.KHR_CONVERTED_ACCOUNT_YN);
9193:
9194: OPEN c_gvr_data('CREDITLINE_CONTRACT',L_HDR_UV_REC.CHR_ID,L_HDR_UV_REC.CHR_ID);
9195: FETCH c_gvr_data INTO X_DEAL_VALUES_REC.CREDIT_LINE_CONTRACT_NUMBER,X_DEAL_VALUES_REC.CREDIT_LINE_CHR_ID,X_DEAL_VALUES_REC.CREDIT_GVR_ID;

Line 9192: X_DEAL_VALUES_REC.CONVERTED_ACCT_MEANING := OKL_LLA_UTIL_PVT.GET_LOOKUP_MEANING('OKL_YES_NO',L_HDR_UV_REC.KHR_CONVERTED_ACCOUNT_YN);

9188: X_DEAL_VALUES_REC.CAP_INTERIM_INT_RUL_ID := L_HDR_UV_REC.R_LACPLN_ID;
9189: X_DEAL_VALUES_REC.CAP_INTERIM_INT_RUL_INF1 := L_HDR_UV_REC.R_LACPLN_RULE_INFORMATION1;
9190: X_DEAL_VALUES_REC.CAP_INTERIM_INT_RUL_INF_CAT := 'LACPLN';
9191: X_DEAL_VALUES_REC.CONSUMER_CREDIT_ACT_MEANING := OKL_LLA_UTIL_PVT.GET_LOOKUP_MEANING('OKL_YES_NO',L_HDR_UV_REC.KHR_CREDIT_ACT_YN);
9192: X_DEAL_VALUES_REC.CONVERTED_ACCT_MEANING := OKL_LLA_UTIL_PVT.GET_LOOKUP_MEANING('OKL_YES_NO',L_HDR_UV_REC.KHR_CONVERTED_ACCOUNT_YN);
9193:
9194: OPEN c_gvr_data('CREDITLINE_CONTRACT',L_HDR_UV_REC.CHR_ID,L_HDR_UV_REC.CHR_ID);
9195: FETCH c_gvr_data INTO X_DEAL_VALUES_REC.CREDIT_LINE_CONTRACT_NUMBER,X_DEAL_VALUES_REC.CREDIT_LINE_CHR_ID,X_DEAL_VALUES_REC.CREDIT_GVR_ID;
9196: CLOSE c_gvr_data;

Line 9198: X_DEAL_VALUES_REC.CURRENCY_CONV_TYPE_MEANING := OKL_LLA_UTIL_PVT.GET_LOOKUP_MEANING('OKL_CONVERSION_TYPE_CODE',L_HDR_UV_REC.KHR_CURRENCY_CONVERSION_TYPE);

9194: OPEN c_gvr_data('CREDITLINE_CONTRACT',L_HDR_UV_REC.CHR_ID,L_HDR_UV_REC.CHR_ID);
9195: FETCH c_gvr_data INTO X_DEAL_VALUES_REC.CREDIT_LINE_CONTRACT_NUMBER,X_DEAL_VALUES_REC.CREDIT_LINE_CHR_ID,X_DEAL_VALUES_REC.CREDIT_GVR_ID;
9196: CLOSE c_gvr_data;
9197:
9198: X_DEAL_VALUES_REC.CURRENCY_CONV_TYPE_MEANING := OKL_LLA_UTIL_PVT.GET_LOOKUP_MEANING('OKL_CONVERSION_TYPE_CODE',L_HDR_UV_REC.KHR_CURRENCY_CONVERSION_TYPE);
9199:
9200: -- splitting the customer name and customer account number cursors to support
9201: -- ui query to show customer name without customer account.
9202: OPEN c_cust_name(L_HDR_UV_REC.CUST_OBJECT1_ID1);

Line 9224: X_DEAL_VALUES_REC.ELIG_FOR_PREFUNDING_MEANING := OKL_LLA_UTIL_PVT.GET_LOOKUP_MEANING('OKL_YES_NO',L_HDR_UV_REC.KHR_PREFUNDING_ELIGIBLE_YN);

9220: X_DEAL_VALUES_REC.CUST_PO_NUMBER := L_HDR_UV_REC.CHR_CUST_PO_NUMBER;
9221: X_DEAL_VALUES_REC.DEAL_TYPE := L_HDR_UV_REC.KHR_DEAL_TYPE;
9222:
9223: X_DEAL_VALUES_REC.DESCRIPTION := L_HDR_UV_REC.CHR_DESCRIPTION;
9224: X_DEAL_VALUES_REC.ELIG_FOR_PREFUNDING_MEANING := OKL_LLA_UTIL_PVT.GET_LOOKUP_MEANING('OKL_YES_NO',L_HDR_UV_REC.KHR_PREFUNDING_ELIGIBLE_YN);
9225: X_DEAL_VALUES_REC.ID := L_HDR_UV_REC.CHR_ID;
9226: X_DEAL_VALUES_REC.INTEREST_CALC_MEANING := L_HDR_UV_REC.INTEREST_CALCULATION_MEANING;
9227:
9228: OPEN c_ledger(l_hdr_rec.id,l_hdr_rec.authoring_org_id);

Line 9263: X_DEAL_VALUES_REC.NON_NOTIFICATION_MEANING := OKL_LLA_UTIL_PVT.GET_LOOKUP_MEANING('OKL_YES_NO',L_HDR_UV_REC.R_LANNTF_RULE_INFORMATION1);

9259: X_DEAL_VALUES_REC.NNTF_RGP_ID := L_HDR_UV_REC.RG_LANNTF_ID;
9260: X_DEAL_VALUES_REC.NNTF_RUL_ID := L_HDR_UV_REC.R_LANNTF_ID;
9261: X_DEAL_VALUES_REC.NNTF_RUL_INF1 := L_HDR_UV_REC.R_LANNTF_RULE_INFORMATION1;
9262: X_DEAL_VALUES_REC.NNTF_RUL_INF_CAT := 'LANNTF';
9263: X_DEAL_VALUES_REC.NON_NOTIFICATION_MEANING := OKL_LLA_UTIL_PVT.GET_LOOKUP_MEANING('OKL_YES_NO',L_HDR_UV_REC.R_LANNTF_RULE_INFORMATION1);
9264:
9265: FOR c_prompt_rec in c_prompt_name
9266: LOOP
9267: IF (c_prompt_rec.rule_code = 'LACPLN') THEN

Line 9301: X_DEAL_VALUES_REC.PRIVATE_ACT_BOND_MEANING := OKL_LLA_UTIL_PVT.GET_LOOKUP_MEANING('OKL_YES_NO',L_HDR_UV_REC.R_LAPACT_RULE_INFORMATION1);

9297: X_DEAL_VALUES_REC.LEASE_APPLICATION_NAME := X_DEAL_VALUES_REC.ORIGINATION_LEASE_APPLICATION;
9298: CLOSE c_orig_lease_application;
9299: END IF;
9300:
9301: X_DEAL_VALUES_REC.PRIVATE_ACT_BOND_MEANING := OKL_LLA_UTIL_PVT.GET_LOOKUP_MEANING('OKL_YES_NO',L_HDR_UV_REC.R_LAPACT_RULE_INFORMATION1);
9302: X_DEAL_VALUES_REC.PRODUCT_DESCRIPTION := L_HDR_UV_REC.PRODUCT_DESCRIPTION;
9303: X_DEAL_VALUES_REC.PRODUCT_NAME := L_HDR_UV_REC.PRODUCT_NAME;
9304:
9305: IF ((L_HDR_UV_REC.CHR_ORIG_SYSTEM_SOURCE_CODE = 'OKC_HDR') AND (L_HDR_UV_REC.KHR_KHR_ID IS NOT NULL))THEN

Line 9348: X_DEAL_VALUES_REC.RELEASED_ASSET_MEANING := OKL_LLA_UTIL_PVT.GET_LOOKUP_MEANING('OKL_YES_NO',L_HDR_UV_REC.R_LARLES_RULE_INFORMATION1);

9344: X_DEAL_VALUES_REC.RLES_RGP_ID := L_HDR_UV_REC.RG_LARLES_ID;
9345: X_DEAL_VALUES_REC.RLES_RUL_ID := L_HDR_UV_REC.R_LARLES_ID;
9346: X_DEAL_VALUES_REC.RLES_RUL_INF1 := L_HDR_UV_REC.R_LARLES_RULE_INFORMATION1;
9347: X_DEAL_VALUES_REC.RLES_RUL_INF_CAT := 'LARLES';
9348: X_DEAL_VALUES_REC.RELEASED_ASSET_MEANING := OKL_LLA_UTIL_PVT.GET_LOOKUP_MEANING('OKL_YES_NO',L_HDR_UV_REC.R_LARLES_RULE_INFORMATION1);
9349:
9350: OPEN c_salesrep(L_HDR_UV_REC.contact_object1_id1);
9351: FETCH c_salesrep INTO X_DEAL_VALUES_REC.SALES_REPRESENTATIVE_NAME;
9352: CLOSE c_salesrep;

Line 9360: X_DEAL_VALUES_REC.TAX_OWNER_MEANING := OKL_LLA_UTIL_PVT.GET_LOOKUP_MEANING('OKL_TAX_OWNER',l_HDR_UV_REC.R_LATOWN_RULE_INFORMATION1);

9356: X_DEAL_VALUES_REC.SPLIT_FROM_CONTRACT_NUMBER := NULL;
9357: X_DEAL_VALUES_REC.STS_CODE_MEANING := L_HDR_UV_REC.CHR_STS_MEANING;
9358:
9359: X_DEAL_VALUES_REC.TAX_OWNER_CODE := L_HDR_UV_REC.R_LATOWN_RULE_INFORMATION1;
9360: X_DEAL_VALUES_REC.TAX_OWNER_MEANING := OKL_LLA_UTIL_PVT.GET_LOOKUP_MEANING('OKL_TAX_OWNER',l_HDR_UV_REC.R_LATOWN_RULE_INFORMATION1);
9361: X_DEAL_VALUES_REC.TAX_OWNER_RGD_CODE := 'LATOWN';
9362: X_DEAL_VALUES_REC.TAX_OWNER_RGP_ID := L_HDR_UV_REC.RG_LATOWN_ID;
9363: X_DEAL_VALUES_REC.TAX_OWNER_RUL_ID := L_HDR_UV_REC.R_LATOWN_ID;
9364: X_DEAL_VALUES_REC.TAX_OWNER_RUL_INF1 := L_HDR_UV_REC.R_LATOWN_RULE_INFORMATION1;

Line 9377: X_DEAL_VALUES_REC.LAST_ACTIVATION_DATE := OKL_LLA_UTIL_PVT.GET_LAST_ACTIVATION_DATE(p_chr_id => p_chr_id);

9373: -- sjalasut, added product subclass code which will serve as a criteria to the Product List of values page
9374: X_DEAL_VALUES_REC.PRODUCT_SUBCLASS_CODE := 'LEASE';
9375:
9376: --Bug# 8370699
9377: X_DEAL_VALUES_REC.LAST_ACTIVATION_DATE := OKL_LLA_UTIL_PVT.GET_LAST_ACTIVATION_DATE(p_chr_id => p_chr_id);
9378:
9379: CLOSE c_hdr_full_v;
9380: CLOSE c_hdr_full_uv;
9381:

Line 9607: x_booking_summary_rec.eot_option := OKL_LLA_UTIL_PVT.GET_LOOKUP_MEANING('OKL_QUOTE_RULE_OPTION_TYPE',l_eot_option_code);

9603: x_booking_summary_rec.eot_amount := OKL_ACCOUNTING_UTIL.format_amount(
9604: l_eot_amount,
9605: l_currency_code);
9606:
9607: x_booking_summary_rec.eot_option := OKL_LLA_UTIL_PVT.GET_LOOKUP_MEANING('OKL_QUOTE_RULE_OPTION_TYPE',l_eot_option_code);
9608:
9609: OPEN c_upfront_tax(p_chr_id => p_chr_id);
9610: FETCH c_upfront_tax INTO l_upfront_sales_tax;
9611: CLOSE c_upfront_tax;