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 OKC_K_HEADERS_B

Line 452: okc_k_headers_b chr

448: -- START: cklee/mvasudev,6/2/2005, Bug#4392051/okl.h 4437938
449: --SELECT ADD_MONTHS(start_date,term_duration)-1
450: SELECT chr.start_date, khr.term_duration
451: FROM okl_k_headers khr,
452: okc_k_headers_b chr
453: WHERE khr.id = chr.id
454: AND chr.id = l_chr_id;
455: -- START: cklee/mvasudev,6/2/2005, Bug#4392051/okl.h 4437938
456: --WHERE id = l_chr_id;

Line 463: From okc_k_headers_b

459: l_scs_code VARCHAR2(30);
460:
461: Cursor l_scs_csr is
462: Select scs_code
463: From okc_k_headers_b
464: where id = p_source_chr_id;
465: --Bug 4654486 : end
466:
467: BEGIN

Line 561: From okc_k_headers_b

557: l_scs_code VARCHAR2(30);
558:
559: Cursor l_scs_csr is
560: Select scs_code
561: From okc_k_headers_b
562: where id = p_source_chr_id;
563: --Bug 4654486 : end
564:
565: BEGIN

Line 1169: okc_k_headers_b CHR,

1165:
1166: CURSOR c_governances IS
1167: SELECT gvr.chr_id_referred
1168: FROM okc_governances gvr,
1169: okc_k_headers_b CHR,
1170: okc_k_headers_b mla
1171: WHERE gvr.dnz_chr_id = p_source_chr_id
1172: AND gvr.chr_id = p_source_chr_id
1173: AND gvr.cle_id IS NULL

Line 1170: okc_k_headers_b mla

1166: CURSOR c_governances IS
1167: SELECT gvr.chr_id_referred
1168: FROM okc_governances gvr,
1169: okc_k_headers_b CHR,
1170: okc_k_headers_b mla
1171: WHERE gvr.dnz_chr_id = p_source_chr_id
1172: AND gvr.chr_id = p_source_chr_id
1173: AND gvr.cle_id IS NULL
1174: AND CHR.id = gvr.dnz_chr_id

Line 1217: l_cust_acct_id okc_k_headers_b.cust_acct_id%type;

1213: AND lse.id = stl.lse_id
1214: AND lse.lse_type = 'TLS'
1215: AND lse.lse_parent_id IS NULL;
1216:
1217: l_cust_acct_id okc_k_headers_b.cust_acct_id%type;
1218: l_khr_id okl_k_headers.khr_id%type;
1219:
1220: l_chr_id NUMBER;
1221: l_rgp_id NUMBER;

Line 1235: l_currency_code okc_k_headers_b.currency_code%TYPE := NULL;

1231:
1232: l_line_tab okl_copy_asset_pub.klev_tbl_type;
1233: x_cle_id_tbl okl_copy_asset_pub.klev_tbl_type;
1234:
1235: l_currency_code okc_k_headers_b.currency_code%TYPE := NULL;
1236: l_currency_conversion_type okl_k_headers.currency_conversion_type%TYPE := NULL;
1237: l_currency_conversion_date okl_k_headers.currency_conversion_date%TYPE := NULL;
1238: l_currency_conversion_rate okl_k_headers.currency_conversion_rate%TYPE := NULL;
1239:

Line 2248: l_chr_id okc_k_headers_b.id%type := NULL;

2244:
2245: --Bug#5116278 start
2246: l_vp_cpl_id okc_k_party_roles_v.id%TYPE := NULL;
2247: x_cpl_id okc_k_party_roles_v.id%TYPE := NULL;
2248: l_chr_id okc_k_headers_b.id%type := NULL;
2249:
2250: CURSOR c_vp_cpl_csr(p_source_id NUMBER) IS
2251: SELECT id, object_version_number, sfwt_flag,
2252: cpl_id, chr_id, cle_id,

Line 2696: l_func_curr_code okc_k_headers_b.currency_code%TYPE := NULL;

2692: l_chr_id okc_rule_groups_v.chr_id%TYPE := p_dest_id;
2693: l_to_template_yn VARCHAR2(5) :='N';
2694: x_rgp_id okc_rule_groups_v.id%TYPE;
2695:
2696: l_func_curr_code okc_k_headers_b.currency_code%TYPE := NULL;
2697: l_k_curr_code okc_k_headers_b.currency_code%TYPE := NULL;
2698: l_start_date okc_k_headers_b.start_date%TYPE;
2699: l_rule_amt NUMBER;
2700: x_contract_currency okl_k_headers_full_v.currency_code%TYPE := NULL;

Line 2697: l_k_curr_code okc_k_headers_b.currency_code%TYPE := NULL;

2693: l_to_template_yn VARCHAR2(5) :='N';
2694: x_rgp_id okc_rule_groups_v.id%TYPE;
2695:
2696: l_func_curr_code okc_k_headers_b.currency_code%TYPE := NULL;
2697: l_k_curr_code okc_k_headers_b.currency_code%TYPE := NULL;
2698: l_start_date okc_k_headers_b.start_date%TYPE;
2699: l_rule_amt NUMBER;
2700: x_contract_currency okl_k_headers_full_v.currency_code%TYPE := NULL;
2701: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE := NULL;

Line 2698: l_start_date okc_k_headers_b.start_date%TYPE;

2694: x_rgp_id okc_rule_groups_v.id%TYPE;
2695:
2696: l_func_curr_code okc_k_headers_b.currency_code%TYPE := NULL;
2697: l_k_curr_code okc_k_headers_b.currency_code%TYPE := NULL;
2698: l_start_date okc_k_headers_b.start_date%TYPE;
2699: l_rule_amt NUMBER;
2700: x_contract_currency okl_k_headers_full_v.currency_code%TYPE := NULL;
2701: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE := NULL;
2702: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE := NULL;

Line 2792: FROM okc_k_headers_b

2788: --end modified abhsaxen for performance SQLID 20562755
2789:
2790: CURSOR c_k_curr_csr IS
2791: SELECT currency_code, start_date
2792: FROM okc_k_headers_b
2793: WHERE id = p_dest_id;
2794:
2795: CURSOR c_rule_segmnts_csr(p_rule_id IN NUMBER) IS
2796: SELECT RULE_INFORMATION1,RULE_INFORMATION2,RULE_INFORMATION3,RULE_INFORMATION4,RULE_INFORMATION5,

Line 2822: FROM okc_k_headers_b CHR,

2818: --end modifying abhsaxen Cursor not in use
2819:
2820: CURSOR c_rrdid_csr IS
2821: SELECT rgrdfs.id
2822: FROM okc_k_headers_b CHR,
2823: okc_subclass_roles sre,
2824: okc_role_sources rse,
2825: okc_subclass_rg_defs rgdfs,
2826: okc_rg_role_defs rgrdfs

Line 3398: FROM okc_k_headers_b

3394: l_api_version CONSTANT NUMBER := 1.0;
3395:
3396: CURSOR l_source_crs IS
3397: SELECT template_yn, chr_type
3398: FROM okc_k_headers_b
3399: WHERE id = p_source_chr_id;
3400:
3401: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
3402: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;

Line 3401: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;

3397: SELECT template_yn, chr_type
3398: FROM okc_k_headers_b
3399: WHERE id = p_source_chr_id;
3400:
3401: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
3402: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
3403: BEGIN
3404:
3405: OKC_CONTEXT.SET_OKC_ORG_CONTEXT(

Line 3402: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;

3398: FROM okc_k_headers_b
3399: WHERE id = p_source_chr_id;
3400:
3401: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
3402: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
3403: BEGIN
3404:
3405: OKC_CONTEXT.SET_OKC_ORG_CONTEXT(
3406: p_org_id => p_org_id,

Line 3534: FROM okc_k_headers_b

3530: l_value VARCHAR2(1) := OKL_API.G_FALSE;
3531:
3532: CURSOR l_source_k_num_crs IS
3533: SELECT contract_number
3534: FROM okc_k_headers_b
3535: WHERE id = p_source_chr_id;
3536:
3537: l_inv_agmt_chr_id_tbl_type Okl_Securitization_Pvt.inv_agmt_chr_id_tbl_type;
3538:

Line 3677: FROM okc_k_headers_b

3673: l_api_version CONSTANT NUMBER := 1.0;
3674:
3675: CURSOR l_source_crs IS
3676: SELECT template_yn, chr_type
3677: FROM okc_k_headers_b
3678: WHERE id = p_source_chr_id;
3679:
3680: CURSOR l_source_k_num_crs IS
3681: SELECT contract_number

Line 3682: FROM okc_k_headers_b

3678: WHERE id = p_source_chr_id;
3679:
3680: CURSOR l_source_k_num_crs IS
3681: SELECT contract_number
3682: FROM okc_k_headers_b
3683: WHERE id = p_source_chr_id;
3684:
3685: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
3686: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;

Line 3685: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;

3681: SELECT contract_number
3682: FROM okc_k_headers_b
3683: WHERE id = p_source_chr_id;
3684:
3685: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
3686: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
3687: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
3688:
3689: BEGIN

Line 3686: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;

3682: FROM okc_k_headers_b
3683: WHERE id = p_source_chr_id;
3684:
3685: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
3686: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
3687: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
3688:
3689: BEGIN
3690:

Line 3687: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;

3683: WHERE id = p_source_chr_id;
3684:
3685: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
3686: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
3687: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
3688:
3689: BEGIN
3690:
3691: OKC_CONTEXT.SET_OKC_ORG_CONTEXT(

Line 3858: FROM okc_k_headers_b

3854: l_api_version CONSTANT NUMBER := 1.0;
3855:
3856: CURSOR l_source_crs IS
3857: SELECT template_yn, chr_type
3858: FROM okc_k_headers_b
3859: WHERE id = p_source_chr_id;
3860:
3861: CURSOR l_source_k_num_crs IS
3862: SELECT contract_number

Line 3863: FROM okc_k_headers_b

3859: WHERE id = p_source_chr_id;
3860:
3861: CURSOR l_source_k_num_crs IS
3862: SELECT contract_number
3863: FROM okc_k_headers_b
3864: WHERE id = p_source_chr_id;
3865:
3866: CURSOR l_source_chr_id_crs(p_scs_code VARCHAR2, p_temp_yn VARCHAR2, p_object1_id1 VARCHAR2, p_object1_id2 VARCHAR2, p_customer_code VARCHAR2) IS
3867: SELECT CHR.id

Line 3868: FROM okc_k_headers_b CHR

3864: WHERE id = p_source_chr_id;
3865:
3866: CURSOR l_source_chr_id_crs(p_scs_code VARCHAR2, p_temp_yn VARCHAR2, p_object1_id1 VARCHAR2, p_object1_id2 VARCHAR2, p_customer_code VARCHAR2) IS
3867: SELECT CHR.id
3868: FROM okc_k_headers_b CHR
3869: , okc_k_party_roles_b prl
3870: WHERE prl.dnz_chr_id = CHR.id
3871: AND prl.chr_id = CHR.id
3872: AND CHR.scs_code = p_scs_code

Line 3881: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;

3877: AND prl.object1_id2 = p_object1_id2
3878: AND prl.jtot_object1_code = p_customer_code
3879: AND CHR.contract_number = p_source_contract_number;
3880:
3881: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
3882: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
3883: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
3884: l_object_code VARCHAR2(30) DEFAULT NULL;
3885:

Line 3882: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;

3878: AND prl.jtot_object1_code = p_customer_code
3879: AND CHR.contract_number = p_source_contract_number;
3880:
3881: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
3882: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
3883: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
3884: l_object_code VARCHAR2(30) DEFAULT NULL;
3885:
3886: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;

Line 3883: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;

3879: AND CHR.contract_number = p_source_contract_number;
3880:
3881: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
3882: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
3883: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
3884: l_object_code VARCHAR2(30) DEFAULT NULL;
3885:
3886: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
3887:

Line 4144: FROM okc_k_headers_b

4140: l_api_version CONSTANT NUMBER := 1.0;
4141:
4142: CURSOR l_source_crs IS
4143: SELECT template_yn, chr_type
4144: FROM okc_k_headers_b
4145: WHERE id = p_source_chr_id;
4146:
4147: CURSOR l_source_k_num_crs IS
4148: SELECT contract_number

Line 4149: FROM okc_k_headers_b

4145: WHERE id = p_source_chr_id;
4146:
4147: CURSOR l_source_k_num_crs IS
4148: SELECT contract_number
4149: FROM okc_k_headers_b
4150: WHERE id = p_source_chr_id;
4151:
4152: CURSOR l_source_chr_id_crs(p_scs_code VARCHAR2, p_temp_yn VARCHAR2, p_object1_id1 VARCHAR2, p_object1_id2 VARCHAR2, p_customer_code VARCHAR2) IS
4153: SELECT CHR.id

Line 4154: FROM okc_k_headers_b CHR

4150: WHERE id = p_source_chr_id;
4151:
4152: CURSOR l_source_chr_id_crs(p_scs_code VARCHAR2, p_temp_yn VARCHAR2, p_object1_id1 VARCHAR2, p_object1_id2 VARCHAR2, p_customer_code VARCHAR2) IS
4153: SELECT CHR.id
4154: FROM okc_k_headers_b CHR
4155: , okc_k_party_roles_b prl
4156: WHERE prl.dnz_chr_id = CHR.id
4157: AND prl.chr_id = CHR.id
4158: AND CHR.scs_code = p_scs_code

Line 4169: FROM okc_k_headers_b CHR

4165: AND CHR.contract_number = p_source_contract_number;
4166:
4167: CURSOR l_src_chr_id_crs(p_scs_code VARCHAR2, p_temp_yn VARCHAR2) IS
4168: SELECT CHR.id
4169: FROM okc_k_headers_b CHR
4170: WHERE CHR.scs_code = p_scs_code
4171: AND CHR.chr_type = 'CYA'
4172: AND CHR.template_yn = p_temp_yn
4173: AND CHR.contract_number = p_source_contract_number;

Line 4175: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;

4171: AND CHR.chr_type = 'CYA'
4172: AND CHR.template_yn = p_temp_yn
4173: AND CHR.contract_number = p_source_contract_number;
4174:
4175: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
4176: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
4177: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
4178: l_object_code VARCHAR2(30) DEFAULT NULL;
4179: l_chr_id OKC_K_HEADERS_B.ID%TYPE;

Line 4176: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;

4172: AND CHR.template_yn = p_temp_yn
4173: AND CHR.contract_number = p_source_contract_number;
4174:
4175: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
4176: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
4177: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
4178: l_object_code VARCHAR2(30) DEFAULT NULL;
4179: l_chr_id OKC_K_HEADERS_B.ID%TYPE;
4180:

Line 4177: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;

4173: AND CHR.contract_number = p_source_contract_number;
4174:
4175: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
4176: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
4177: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
4178: l_object_code VARCHAR2(30) DEFAULT NULL;
4179: l_chr_id OKC_K_HEADERS_B.ID%TYPE;
4180:
4181: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;

Line 4179: l_chr_id OKC_K_HEADERS_B.ID%TYPE;

4175: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
4176: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
4177: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
4178: l_object_code VARCHAR2(30) DEFAULT NULL;
4179: l_chr_id OKC_K_HEADERS_B.ID%TYPE;
4180:
4181: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
4182:
4183: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

Line 4595: FROM okc_k_headers_b

4591: l_program_id NUMBER;
4592:
4593: CURSOR l_source_crs IS
4594: SELECT template_yn, chr_type
4595: FROM okc_k_headers_b
4596: WHERE id = p_source_chr_id;
4597:
4598: CURSOR l_source_k_num_crs IS
4599: SELECT contract_number

Line 4600: FROM okc_k_headers_b

4596: WHERE id = p_source_chr_id;
4597:
4598: CURSOR l_source_k_num_crs IS
4599: SELECT contract_number
4600: FROM okc_k_headers_b
4601: WHERE id = p_source_chr_id;
4602:
4603: -- cursor when only customer is selected
4604: CURSOR l_source_chr_id_crs(p_scs_code VARCHAR2, p_temp_yn VARCHAR2, p_object1_id1 VARCHAR2, p_object1_id2 VARCHAR2, p_customer_code VARCHAR2) IS

Line 4606: FROM okc_k_headers_b CHR

4602:
4603: -- cursor when only customer is selected
4604: CURSOR l_source_chr_id_crs(p_scs_code VARCHAR2, p_temp_yn VARCHAR2, p_object1_id1 VARCHAR2, p_object1_id2 VARCHAR2, p_customer_code VARCHAR2) IS
4605: SELECT CHR.id
4606: FROM okc_k_headers_b CHR
4607: , okc_k_party_roles_b prl
4608: WHERE prl.dnz_chr_id = CHR.id
4609: AND prl.chr_id = CHR.id
4610: AND CHR.scs_code = p_scs_code

Line 4640: FROM okc_k_headers_b CHR,

4636:
4637: -- cursor when only customer and program is selected
4638: CURSOR l_source_chr_prog_id_crs(p_scs_code VARCHAR2, p_temp_yn VARCHAR2, p_object1_id1 VARCHAR2, p_object1_id2 VARCHAR2, p_customer_code VARCHAR2, l_prog_id NUMBER) IS
4639: SELECT CHR.id
4640: FROM okc_k_headers_b CHR,
4641: okl_k_headers khr
4642: , okc_k_party_roles_b prl
4643: WHERE chr.id = khr.id
4644: AND prl.dnz_chr_id = CHR.id

Line 4660: FROM okc_k_headers_b CHR,

4656:
4657: -- cursor when only customer and program is selected
4658: CURSOR l_leaseAppTmpl2_crs(p_object1_id1 VARCHAR2, p_object1_id2 VARCHAR2, p_customer_code VARCHAR2, l_prog_id NUMBER) IS
4659: SELECT CHR.id
4660: FROM okc_k_headers_b CHR,
4661: okl_k_headers khr
4662: , okc_k_party_roles_b prl
4663: WHERE chr.id = khr.id
4664: AND prl.dnz_chr_id = CHR.id

Line 4680: FROM okc_k_headers_b CHR,

4676:
4677: -- cursor when only program is selected
4678: CURSOR l_source_prog_crs(p_scs_code VARCHAR2, p_temp_yn VARCHAR2, l_prog_id NUMBER) IS
4679: SELECT CHR.id
4680: FROM okc_k_headers_b CHR,
4681: okl_k_headers khr
4682: WHERE chr.id = khr.id
4683: AND CHR.scs_code = p_scs_code
4684: AND CHR.chr_type = 'CYA'

Line 4693: FROM okc_k_headers_b CHR,

4689:
4690: -- cursor when only program is selected
4691: CURSOR l_leaseAppTmpl3_crs(l_prog_id NUMBER) IS
4692: SELECT CHR.id
4693: FROM okc_k_headers_b CHR,
4694: okl_k_headers khr
4695: WHERE chr.id = khr.id
4696: AND CHR.scs_code = 'LEASE'
4697: AND CHR.chr_type = 'CYA'

Line 4705: FROM okc_k_headers_b CHR

4701: AND khr_id = l_prog_id;
4702:
4703: CURSOR l_src_chr_id_crs(p_scs_code VARCHAR2, p_temp_yn VARCHAR2) IS
4704: SELECT CHR.id
4705: FROM okc_k_headers_b CHR
4706: WHERE CHR.scs_code = p_scs_code
4707: AND CHR.chr_type = 'CYA'
4708: AND CHR.template_yn = p_temp_yn
4709: AND CHR.contract_number = p_source_contract_number;

Line 4779: FROM OKC_K_HEADERS_B

4775: FROM OKL_LEASE_APPLICATIONS_B
4776: WHERE LEASE_OPPORTUNITY_ID = LOP.ID
4777: AND APPLICATION_STATUS <> 'WITHDRAWN')
4778: AND NOT EXISTS (SELECT 1
4779: FROM OKC_K_HEADERS_B
4780: WHERE ORIG_SYSTEM_SOURCE_CODE = 'OKL_QUOTE'
4781: AND ORIG_SYSTEM_ID1 = LSQ.ID
4782: AND STS_CODE <> 'ABANDONED');
4783:

Line 4801: FROM OKC_K_HEADERS_B

4797: AND LAPT.LANGUAGE = USERENV('LANG')
4798: AND LAP.APPLICATION_STATUS = 'CR-APPROVED'
4799: AND LAP.REFERENCE_NUMBER = p_leaseapp_number
4800: AND NOT EXISTS (SELECT 1
4801: FROM OKC_K_HEADERS_B
4802: WHERE ORIG_SYSTEM_SOURCE_CODE = 'OKL_LEASE_APP'
4803: AND ORIG_SYSTEM_ID1 = LAP.ID
4804: AND STS_CODE <> 'ABANDONED')
4805: AND NOT EXISTS (SELECT 1

Line 4811: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;

4807: WHERE PARENT_LEASEAPP_ID = LAP.ID
4808: AND APPLICATION_STATUS NOT IN ('WITHDRAWN' , 'CR-REJECTED'));
4809:
4810: l_template_type OKL_K_HEADERS.TEMPLATE_TYPE_CODE%TYPE;
4811: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
4812: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
4813: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
4814: l_object_code VARCHAR2(30) DEFAULT NULL;
4815: l_chr_id OKC_K_HEADERS_B.ID%TYPE;

Line 4812: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;

4808: AND APPLICATION_STATUS NOT IN ('WITHDRAWN' , 'CR-REJECTED'));
4809:
4810: l_template_type OKL_K_HEADERS.TEMPLATE_TYPE_CODE%TYPE;
4811: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
4812: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
4813: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
4814: l_object_code VARCHAR2(30) DEFAULT NULL;
4815: l_chr_id OKC_K_HEADERS_B.ID%TYPE;
4816:

Line 4813: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;

4809:
4810: l_template_type OKL_K_HEADERS.TEMPLATE_TYPE_CODE%TYPE;
4811: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
4812: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
4813: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
4814: l_object_code VARCHAR2(30) DEFAULT NULL;
4815: l_chr_id OKC_K_HEADERS_B.ID%TYPE;
4816:
4817: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;

Line 4815: l_chr_id OKC_K_HEADERS_B.ID%TYPE;

4811: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
4812: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
4813: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
4814: l_object_code VARCHAR2(30) DEFAULT NULL;
4815: l_chr_id OKC_K_HEADERS_B.ID%TYPE;
4816:
4817: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
4818:
4819: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

Line 5534: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;

5530:
5531: l_api_name VARCHAR2(30) := 'validate_deal';
5532: l_api_version CONSTANT NUMBER := 1.0;
5533:
5534: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
5535: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
5536: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
5537: l_object_code VARCHAR2(30) DEFAULT NULL;
5538:

Line 5535: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;

5531: l_api_name VARCHAR2(30) := 'validate_deal';
5532: l_api_version CONSTANT NUMBER := 1.0;
5533:
5534: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
5535: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
5536: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
5537: l_object_code VARCHAR2(30) DEFAULT NULL;
5538:
5539: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;

Line 5536: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;

5532: l_api_version CONSTANT NUMBER := 1.0;
5533:
5534: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
5535: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
5536: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
5537: l_object_code VARCHAR2(30) DEFAULT NULL;
5538:
5539: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
5540: l_chr_id NUMBER;

Line 5809: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;

5805:
5806: l_api_name VARCHAR2(30) := 'update_release_contract';
5807: l_api_version CONSTANT NUMBER := 1.0;
5808:
5809: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
5810: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
5811: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
5812: l_object_code VARCHAR2(30) DEFAULT NULL;
5813:

Line 5810: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;

5806: l_api_name VARCHAR2(30) := 'update_release_contract';
5807: l_api_version CONSTANT NUMBER := 1.0;
5808:
5809: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
5810: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
5811: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
5812: l_object_code VARCHAR2(30) DEFAULT NULL;
5813:
5814: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;

Line 5811: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;

5807: l_api_version CONSTANT NUMBER := 1.0;
5808:
5809: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
5810: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
5811: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
5812: l_object_code VARCHAR2(30) DEFAULT NULL;
5813:
5814: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
5815: l_chr_id NUMBER;

Line 5871: from okc_k_headers_b chr

5867: select cl.id
5868: from okl_k_hdr_crdtln_uv cl
5869: where cl.contract_number = p_cl_no
5870: and exists ( select 1
5871: from okc_k_headers_b chr
5872: where chr.currency_code = cl.currency_code
5873: and cl.end_date >= chr.start_date
5874: and cl.cust_name = p_customer_name
5875: and cl.cust_acc_number = p_customer_acc_name);

Line 5887: from okc_k_headers_b

5883: and scs_code = 'PROGRAM'
5884: and nvl(TEMPLATE_YN, 'N') = 'N'
5885: and sts_code = 'ACTIVE'
5886: and exists (select 1
5887: from okc_k_headers_b
5888: where id = p_chr_id
5889: and authoring_org_id = prg_hdr.authoring_org_id);
5890:
5891: l_program_id number;

Line 5905: l_auth_org_id okc_k_headers_b.authoring_org_id%type;

5901: SELECT authoring_org_id, inv_organization_id
5902: FROM okl_k_headers_full_V
5903: WHERE id = p_chr_id;
5904:
5905: l_auth_org_id okc_k_headers_b.authoring_org_id%type;
5906: l_inv_org_id okc_k_headers_b.inv_organization_id%type;
5907:
5908: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
5909: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

Line 5906: l_inv_org_id okc_k_headers_b.inv_organization_id%type;

5902: FROM okl_k_headers_full_V
5903: WHERE id = p_chr_id;
5904:
5905: l_auth_org_id okc_k_headers_b.authoring_org_id%type;
5906: l_inv_org_id okc_k_headers_b.inv_organization_id%type;
5907:
5908: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
5909: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
5910:

Line 6569: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;

6565:
6566: l_api_name VARCHAR2(30) := 'update_deal';
6567: l_api_version CONSTANT NUMBER := 1.0;
6568:
6569: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
6570: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
6571: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
6572: l_object_code VARCHAR2(30) DEFAULT NULL;
6573: l_temp_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE := p_durv_rec.chr_template_yn;

Line 6570: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;

6566: l_api_name VARCHAR2(30) := 'update_deal';
6567: l_api_version CONSTANT NUMBER := 1.0;
6568:
6569: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
6570: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
6571: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
6572: l_object_code VARCHAR2(30) DEFAULT NULL;
6573: l_temp_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE := p_durv_rec.chr_template_yn;
6574:

Line 6571: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;

6567: l_api_version CONSTANT NUMBER := 1.0;
6568:
6569: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
6570: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
6571: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
6572: l_object_code VARCHAR2(30) DEFAULT NULL;
6573: l_temp_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE := p_durv_rec.chr_template_yn;
6574:
6575: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;

Line 6573: l_temp_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE := p_durv_rec.chr_template_yn;

6569: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
6570: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
6571: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
6572: l_object_code VARCHAR2(30) DEFAULT NULL;
6573: l_temp_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE := p_durv_rec.chr_template_yn;
6574:
6575: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
6576: l_chr_id NUMBER;
6577: row_cnt NUMBER;

Line 6680: FROM okc_k_headers_b CHR

6676: l_lrls_yn VARCHAR2(1) := 'X';
6677:
6678: CURSOR chk_fin_ast_csr IS
6679: SELECT 'Y'
6680: FROM okc_k_headers_b CHR
6681: WHERE EXISTS (SELECT 1
6682: FROM okc_line_styles_b lse,
6683: okc_k_lines_b cle,
6684: okl_k_lines kle

Line 6731: from okc_k_headers_b chr

6727: AND rgp.chr_id = p_durv_rec.chr_id;
6728:
6729: CURSOR is_re_lease_csr IS
6730: select chr.orig_system_source_code
6731: from okc_k_headers_b chr
6732: where chr.id = p_durv_rec.chr_id;
6733:
6734: l_orig_sys_src_code okc_k_headers_b.orig_system_source_code%type := null;
6735:

Line 6734: l_orig_sys_src_code okc_k_headers_b.orig_system_source_code%type := null;

6730: select chr.orig_system_source_code
6731: from okc_k_headers_b chr
6732: where chr.id = p_durv_rec.chr_id;
6733:
6734: l_orig_sys_src_code okc_k_headers_b.orig_system_source_code%type := null;
6735:
6736: --Bug# 4619575
6737: CURSOR l_ptmpl_csr (p_chr_id IN NUMBER) IS
6738: SELECT chrb.template_yn,

Line 6740: FROM okc_k_headers_b chrb,

6736: --Bug# 4619575
6737: CURSOR l_ptmpl_csr (p_chr_id IN NUMBER) IS
6738: SELECT chrb.template_yn,
6739: khr.template_type_code
6740: FROM okc_k_headers_b chrb,
6741: okl_k_headers khr
6742: WHERE chrb.id = khr.id
6743: AND chrb.id = p_chr_id;
6744:

Line 6768: l_ptemplate_yn okc_k_headers_b.template_yn%type;

6764: WHERE dnz_chr_id = p_chr_id
6765: AND rle_code ='LESSOR';
6766:
6767: l_template_type_code okl_k_headers.template_type_code%type;
6768: l_ptemplate_yn okc_k_headers_b.template_yn%type;
6769:
6770: CURSOR c_orig_pdt_csr(p_chr_id IN NUMBER) IS
6771: SELECT pdt_id
6772: FROM okl_k_headers

Line 8250: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;

8246:
8247: l_api_name VARCHAR2(30) := 'load_deal';
8248: l_api_version CONSTANT NUMBER := 1.0;
8249:
8250: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
8251: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
8252: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
8253: l_object_code VARCHAR2(30) DEFAULT NULL;
8254:

Line 8251: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;

8247: l_api_name VARCHAR2(30) := 'load_deal';
8248: l_api_version CONSTANT NUMBER := 1.0;
8249:
8250: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
8251: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
8252: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
8253: l_object_code VARCHAR2(30) DEFAULT NULL;
8254:
8255: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;

Line 8252: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;

8248: l_api_version CONSTANT NUMBER := 1.0;
8249:
8250: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
8251: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
8252: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
8253: l_object_code VARCHAR2(30) DEFAULT NULL;
8254:
8255: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
8256: l_chr_id NUMBER;

Line 8978: okc_k_headers_b chr

8974: -- end:| 21-Nov-2008 cklee Bug 7569200 -- Fixed display LEDGER NAME issue |
8975:
8976: FROM gl_ledgers_public_v bks,
8977: hr_operating_units ou,
8978: okc_k_headers_b chr
8979: WHERE bks.ledger_id = ou.set_of_books_id
8980: AND ou.organization_id = chr.authoring_org_id
8981: AND chr.authoring_org_id = p_organization_id
8982: AND chr.id = p_chr_id;

Line 9345: FROM OKC_K_HEADERS_B

9341: l_api_version CONSTANT NUMBER := 1.0;
9342:
9343: CURSOR c_khr_currency(p_chr_id IN NUMBER) IS
9344: SELECT CURRENCY_CODE
9345: FROM OKC_K_HEADERS_B
9346: WHERE ID = p_chr_id;
9347:
9348: CURSOR c_residual_amt(p_chr_id NUMBER) IS
9349: SELECT SUM(kle.residual_value) total_residual_amount

Line 9387: l_currency_code okc_k_headers_b.currency_code%TYPE;

9383: AND lseb.lty_code = 'FEE'
9384: AND kle.fee_purpose_code = 'RVI';
9385:
9386: l_eot_option_code okc_rules_b.rule_information1%TYPE;
9387: l_currency_code okc_k_headers_b.currency_code%TYPE;
9388: l_total_financed_amount NUMBER;
9389: l_total_funded NUMBER;
9390: l_total_subsidies NUMBER;
9391: l_eot_amount NUMBER;