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.

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 4203: --l_check := Okl_Lla_Util_Pvt.check_new_contract(p_chr_id);

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

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

4862: BEGIN
4863:
4864: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
4865: -- Raise the event if it is a new Contract
4866: --l_check := Okl_Lla_Util_Pvt.check_new_contract(p_chr_id);
4867: --IF (l_check= OKL_API.G_TRUE) THEN
4868: IF (upper(p_source_code) = 'NEW') THEN
4869: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID,p_chr_id,l_parameter_list);
4870:

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

6798: BEGIN
6799:
6800: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
6801: -- Raise the event if it is a new Contract
6802: l_check := Okl_Lla_Util_Pvt.check_new_contract(p_chr_id);
6803: IF (l_check= OKL_API.G_TRUE) THEN
6804: wf_event.AddParameterToList(G_WF_ITM_CONTRACT_ID,p_chr_id,l_parameter_list);
6805: OKL_WF_PVT.raise_event (p_api_version => p_api_version,
6806: p_init_msg_list => p_init_msg_list,

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

7081: OPEN l_end_date_csr;
7082: FETCH l_end_date_csr INTO lp_chrv_rec.end_date;
7083: CLOSE l_end_date_csr;
7084: */
7085: lp_chrv_rec.end_date := OKL_LLA_UTIL_PVT.calculate_end_date(p_durv_rec.chr_start_date,p_durv_rec.khr_term_duration);
7086: -- END: cklee/mvasudev,6/2/2005, Bug#4392051/okl.h 4437938
7087:
7088: x_durv_rec.chr_end_date := lp_chrv_rec.end_date;
7089:

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

9077:
9078: OPEN c_hdr_full_v(p_chr_id);
9079: FETCH c_hdr_full_v INTO l_hdr_rec;
9080:
9081: X_DEAL_VALUES_REC.ACCEPTANCE_METHOD_MEANING := OKL_LLA_UTIL_PVT.GET_LOOKUP_MEANING('OKL_ACCEPTANCE_METHOD',L_HDR_UV_REC.KHR_AMD_CODE);
9082: X_DEAL_VALUES_REC.ASSIGNABLE_MEANING := OKL_LLA_UTIL_PVT.GET_LOOKUP_MEANING('OKL_YES_NO',l_HDR_UV_REC.KHR_ASSIGNABLE_YN);
9083: X_DEAL_VALUES_REC.BILL_TO_SITE_USE_ID := L_HDR_REC.BILL_TO_SITE_USE_ID;
9084:
9085: OPEN c_bill_to_site(l_HDR_REC.BILL_TO_SITE_USE_ID);

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

9078: OPEN c_hdr_full_v(p_chr_id);
9079: FETCH c_hdr_full_v INTO l_hdr_rec;
9080:
9081: X_DEAL_VALUES_REC.ACCEPTANCE_METHOD_MEANING := OKL_LLA_UTIL_PVT.GET_LOOKUP_MEANING('OKL_ACCEPTANCE_METHOD',L_HDR_UV_REC.KHR_AMD_CODE);
9082: X_DEAL_VALUES_REC.ASSIGNABLE_MEANING := OKL_LLA_UTIL_PVT.GET_LOOKUP_MEANING('OKL_YES_NO',l_HDR_UV_REC.KHR_ASSIGNABLE_YN);
9083: X_DEAL_VALUES_REC.BILL_TO_SITE_USE_ID := L_HDR_REC.BILL_TO_SITE_USE_ID;
9084:
9085: OPEN c_bill_to_site(l_HDR_REC.BILL_TO_SITE_USE_ID);
9086: FETCH c_bill_to_site INTO X_DEAL_VALUES_REC.BILL_TO_ADDRESS_DESC;

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

9085: OPEN c_bill_to_site(l_HDR_REC.BILL_TO_SITE_USE_ID);
9086: FETCH c_bill_to_site INTO X_DEAL_VALUES_REC.BILL_TO_ADDRESS_DESC;
9087: CLOSE c_bill_to_site;
9088:
9089: X_DEAL_VALUES_REC.BOOK_CLASS_MEANING := OKL_LLA_UTIL_PVT.GET_LOOKUP_MEANING('OKL_BOOK_CLASS',L_HDR_UV_REC.KHR_DEAL_TYPE);
9090: 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);
9091: X_DEAL_VALUES_REC.CAP_INTERIM_INT_RGD_CODE := 'LACPLN';
9092: X_DEAL_VALUES_REC.CAP_INTERIM_INT_RGP_ID := L_HDR_UV_REC.RG_LACPLN_ID;
9093: X_DEAL_VALUES_REC.CAP_INTERIM_INT_RUL_ID := L_HDR_UV_REC.R_LACPLN_ID;

Line 9090: 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);

9086: FETCH c_bill_to_site INTO X_DEAL_VALUES_REC.BILL_TO_ADDRESS_DESC;
9087: CLOSE c_bill_to_site;
9088:
9089: X_DEAL_VALUES_REC.BOOK_CLASS_MEANING := OKL_LLA_UTIL_PVT.GET_LOOKUP_MEANING('OKL_BOOK_CLASS',L_HDR_UV_REC.KHR_DEAL_TYPE);
9090: 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);
9091: X_DEAL_VALUES_REC.CAP_INTERIM_INT_RGD_CODE := 'LACPLN';
9092: X_DEAL_VALUES_REC.CAP_INTERIM_INT_RGP_ID := L_HDR_UV_REC.RG_LACPLN_ID;
9093: X_DEAL_VALUES_REC.CAP_INTERIM_INT_RUL_ID := L_HDR_UV_REC.R_LACPLN_ID;
9094: X_DEAL_VALUES_REC.CAP_INTERIM_INT_RUL_INF1 := L_HDR_UV_REC.R_LACPLN_RULE_INFORMATION1;

Line 9096: 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);

9092: X_DEAL_VALUES_REC.CAP_INTERIM_INT_RGP_ID := L_HDR_UV_REC.RG_LACPLN_ID;
9093: X_DEAL_VALUES_REC.CAP_INTERIM_INT_RUL_ID := L_HDR_UV_REC.R_LACPLN_ID;
9094: X_DEAL_VALUES_REC.CAP_INTERIM_INT_RUL_INF1 := L_HDR_UV_REC.R_LACPLN_RULE_INFORMATION1;
9095: X_DEAL_VALUES_REC.CAP_INTERIM_INT_RUL_INF_CAT := 'LACPLN';
9096: 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);
9097: 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);
9098:
9099: OPEN c_gvr_data('CREDITLINE_CONTRACT',L_HDR_UV_REC.CHR_ID,L_HDR_UV_REC.CHR_ID);
9100: 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 9097: 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);

9093: X_DEAL_VALUES_REC.CAP_INTERIM_INT_RUL_ID := L_HDR_UV_REC.R_LACPLN_ID;
9094: X_DEAL_VALUES_REC.CAP_INTERIM_INT_RUL_INF1 := L_HDR_UV_REC.R_LACPLN_RULE_INFORMATION1;
9095: X_DEAL_VALUES_REC.CAP_INTERIM_INT_RUL_INF_CAT := 'LACPLN';
9096: 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);
9097: 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);
9098:
9099: OPEN c_gvr_data('CREDITLINE_CONTRACT',L_HDR_UV_REC.CHR_ID,L_HDR_UV_REC.CHR_ID);
9100: 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;
9101: CLOSE c_gvr_data;

Line 9103: 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);

9099: OPEN c_gvr_data('CREDITLINE_CONTRACT',L_HDR_UV_REC.CHR_ID,L_HDR_UV_REC.CHR_ID);
9100: 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;
9101: CLOSE c_gvr_data;
9102:
9103: 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);
9104:
9105: -- splitting the customer name and customer account number cursors to support
9106: -- ui query to show customer name without customer account.
9107: OPEN c_cust_name(L_HDR_UV_REC.CUST_OBJECT1_ID1);

Line 9129: 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);

9125: X_DEAL_VALUES_REC.CUST_PO_NUMBER := L_HDR_UV_REC.CHR_CUST_PO_NUMBER;
9126: X_DEAL_VALUES_REC.DEAL_TYPE := L_HDR_UV_REC.KHR_DEAL_TYPE;
9127:
9128: X_DEAL_VALUES_REC.DESCRIPTION := L_HDR_UV_REC.CHR_DESCRIPTION;
9129: 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);
9130: X_DEAL_VALUES_REC.ID := L_HDR_UV_REC.CHR_ID;
9131: X_DEAL_VALUES_REC.INTEREST_CALC_MEANING := L_HDR_UV_REC.INTEREST_CALCULATION_MEANING;
9132:
9133: OPEN c_ledger(l_hdr_rec.id,l_hdr_rec.authoring_org_id);

Line 9168: 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);

9164: X_DEAL_VALUES_REC.NNTF_RGP_ID := L_HDR_UV_REC.RG_LANNTF_ID;
9165: X_DEAL_VALUES_REC.NNTF_RUL_ID := L_HDR_UV_REC.R_LANNTF_ID;
9166: X_DEAL_VALUES_REC.NNTF_RUL_INF1 := L_HDR_UV_REC.R_LANNTF_RULE_INFORMATION1;
9167: X_DEAL_VALUES_REC.NNTF_RUL_INF_CAT := 'LANNTF';
9168: 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);
9169:
9170: FOR c_prompt_rec in c_prompt_name
9171: LOOP
9172: IF (c_prompt_rec.rule_code = 'LACPLN') THEN

Line 9206: 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);

9202: X_DEAL_VALUES_REC.LEASE_APPLICATION_NAME := X_DEAL_VALUES_REC.ORIGINATION_LEASE_APPLICATION;
9203: CLOSE c_orig_lease_application;
9204: END IF;
9205:
9206: 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);
9207: X_DEAL_VALUES_REC.PRODUCT_DESCRIPTION := L_HDR_UV_REC.PRODUCT_DESCRIPTION;
9208: X_DEAL_VALUES_REC.PRODUCT_NAME := L_HDR_UV_REC.PRODUCT_NAME;
9209:
9210: 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 9253: 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);

9249: X_DEAL_VALUES_REC.RLES_RGP_ID := L_HDR_UV_REC.RG_LARLES_ID;
9250: X_DEAL_VALUES_REC.RLES_RUL_ID := L_HDR_UV_REC.R_LARLES_ID;
9251: X_DEAL_VALUES_REC.RLES_RUL_INF1 := L_HDR_UV_REC.R_LARLES_RULE_INFORMATION1;
9252: X_DEAL_VALUES_REC.RLES_RUL_INF_CAT := 'LARLES';
9253: 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);
9254:
9255: OPEN c_salesrep(L_HDR_UV_REC.contact_object1_id1);
9256: FETCH c_salesrep INTO X_DEAL_VALUES_REC.SALES_REPRESENTATIVE_NAME;
9257: CLOSE c_salesrep;

Line 9265: 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);

9261: X_DEAL_VALUES_REC.SPLIT_FROM_CONTRACT_NUMBER := NULL;
9262: X_DEAL_VALUES_REC.STS_CODE_MEANING := L_HDR_UV_REC.CHR_STS_MEANING;
9263:
9264: X_DEAL_VALUES_REC.TAX_OWNER_CODE := L_HDR_UV_REC.R_LATOWN_RULE_INFORMATION1;
9265: 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);
9266: X_DEAL_VALUES_REC.TAX_OWNER_RGD_CODE := 'LATOWN';
9267: X_DEAL_VALUES_REC.TAX_OWNER_RGP_ID := L_HDR_UV_REC.RG_LATOWN_ID;
9268: X_DEAL_VALUES_REC.TAX_OWNER_RUL_ID := L_HDR_UV_REC.R_LATOWN_ID;
9269: X_DEAL_VALUES_REC.TAX_OWNER_RUL_INF1 := L_HDR_UV_REC.R_LATOWN_RULE_INFORMATION1;

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

9504: x_booking_summary_rec.eot_amount := OKL_ACCOUNTING_UTIL.format_amount(
9505: l_eot_amount,
9506: l_currency_code);
9507:
9508: x_booking_summary_rec.eot_option := OKL_LLA_UTIL_PVT.GET_LOOKUP_MEANING('OKL_QUOTE_RULE_OPTION_TYPE',l_eot_option_code);
9509:
9510: OPEN c_upfront_tax(p_chr_id => p_chr_id);
9511: FETCH c_upfront_tax INTO l_upfront_sales_tax;
9512: CLOSE c_upfront_tax;