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: --Bug# 12780638: Removed cust_acct_id and bill_to_site_use_id
2251: -- from this cursor as we are not copying
2252: -- vendor billing details from VPA to contract

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

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

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

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

Line 2701: l_start_date okc_k_headers_b.start_date%TYPE;

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

Line 2795: FROM okc_k_headers_b

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

Line 2825: FROM okc_k_headers_b CHR,

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

Line 3401: FROM okc_k_headers_b

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

Line 3404: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;

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

Line 3405: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;

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

Line 3537: FROM okc_k_headers_b

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

Line 3680: FROM okc_k_headers_b

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

Line 3685: FROM okc_k_headers_b

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

Line 3688: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;

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

Line 3689: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;

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

Line 3690: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;

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

Line 3861: FROM okc_k_headers_b

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

Line 3866: FROM okc_k_headers_b

3862: WHERE id = p_source_chr_id;
3863:
3864: CURSOR l_source_k_num_crs IS
3865: SELECT contract_number
3866: FROM okc_k_headers_b
3867: WHERE id = p_source_chr_id;
3868:
3869: 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
3870: SELECT CHR.id

Line 3871: FROM okc_k_headers_b CHR

3867: WHERE id = p_source_chr_id;
3868:
3869: 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
3870: SELECT CHR.id
3871: FROM okc_k_headers_b CHR
3872: , okc_k_party_roles_b prl
3873: WHERE prl.dnz_chr_id = CHR.id
3874: AND prl.chr_id = CHR.id
3875: AND CHR.scs_code = p_scs_code

Line 3884: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;

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

Line 3885: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;

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

Line 3886: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;

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

Line 4147: FROM okc_k_headers_b

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

Line 4152: FROM okc_k_headers_b

4148: WHERE id = p_source_chr_id;
4149:
4150: CURSOR l_source_k_num_crs IS
4151: SELECT contract_number
4152: FROM okc_k_headers_b
4153: WHERE id = p_source_chr_id;
4154:
4155: 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
4156: SELECT CHR.id

Line 4157: FROM okc_k_headers_b CHR

4153: WHERE id = p_source_chr_id;
4154:
4155: 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
4156: SELECT CHR.id
4157: FROM okc_k_headers_b CHR
4158: , okc_k_party_roles_b prl
4159: WHERE prl.dnz_chr_id = CHR.id
4160: AND prl.chr_id = CHR.id
4161: AND CHR.scs_code = p_scs_code

Line 4172: FROM okc_k_headers_b CHR

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

Line 4178: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;

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

Line 4179: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;

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

Line 4180: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;

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

Line 4182: l_chr_id OKC_K_HEADERS_B.ID%TYPE;

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

Line 4598: FROM okc_k_headers_b

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

Line 4603: FROM okc_k_headers_b

4599: WHERE id = p_source_chr_id;
4600:
4601: CURSOR l_source_k_num_crs IS
4602: SELECT contract_number
4603: FROM okc_k_headers_b
4604: WHERE id = p_source_chr_id;
4605:
4606: -- cursor when only customer is selected
4607: 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 4609: FROM okc_k_headers_b CHR

4605:
4606: -- cursor when only customer is selected
4607: 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
4608: SELECT CHR.id
4609: FROM okc_k_headers_b CHR
4610: , okc_k_party_roles_b prl
4611: WHERE prl.dnz_chr_id = CHR.id
4612: AND prl.chr_id = CHR.id
4613: AND CHR.scs_code = p_scs_code

Line 4643: FROM okc_k_headers_b CHR,

4639:
4640: -- cursor when only customer and program is selected
4641: 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
4642: SELECT CHR.id
4643: FROM okc_k_headers_b CHR,
4644: okl_k_headers khr
4645: , okc_k_party_roles_b prl
4646: WHERE chr.id = khr.id
4647: AND prl.dnz_chr_id = CHR.id

Line 4663: FROM okc_k_headers_b CHR,

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

Line 4683: FROM okc_k_headers_b CHR,

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

Line 4696: FROM okc_k_headers_b CHR,

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

Line 4708: FROM okc_k_headers_b CHR

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

Line 4782: FROM OKC_K_HEADERS_B

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

Line 4804: FROM OKC_K_HEADERS_B

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

Line 4814: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;

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

Line 4815: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;

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

Line 4816: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;

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

Line 4818: l_chr_id OKC_K_HEADERS_B.ID%TYPE;

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

Line 5559: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;

5555:
5556: l_api_name VARCHAR2(30) := 'validate_deal';
5557: l_api_version CONSTANT NUMBER := 1.0;
5558:
5559: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
5560: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
5561: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
5562: l_object_code VARCHAR2(30) DEFAULT NULL;
5563:

Line 5560: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;

5556: l_api_name VARCHAR2(30) := 'validate_deal';
5557: l_api_version CONSTANT NUMBER := 1.0;
5558:
5559: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
5560: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
5561: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
5562: l_object_code VARCHAR2(30) DEFAULT NULL;
5563:
5564: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;

Line 5561: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;

5557: l_api_version CONSTANT NUMBER := 1.0;
5558:
5559: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
5560: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
5561: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
5562: l_object_code VARCHAR2(30) DEFAULT NULL;
5563:
5564: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
5565: l_chr_id NUMBER;

Line 5835: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;

5831:
5832: l_api_name VARCHAR2(30) := 'update_release_contract';
5833: l_api_version CONSTANT NUMBER := 1.0;
5834:
5835: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
5836: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
5837: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
5838: l_object_code VARCHAR2(30) DEFAULT NULL;
5839:

Line 5836: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;

5832: l_api_name VARCHAR2(30) := 'update_release_contract';
5833: l_api_version CONSTANT NUMBER := 1.0;
5834:
5835: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
5836: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
5837: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
5838: l_object_code VARCHAR2(30) DEFAULT NULL;
5839:
5840: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;

Line 5837: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;

5833: l_api_version CONSTANT NUMBER := 1.0;
5834:
5835: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
5836: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
5837: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
5838: l_object_code VARCHAR2(30) DEFAULT NULL;
5839:
5840: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
5841: l_chr_id NUMBER;

Line 5897: from okc_k_headers_b chr

5893: select cl.id
5894: from okl_k_hdr_crdtln_uv cl
5895: where cl.contract_number = p_cl_no
5896: and exists ( select 1
5897: from okc_k_headers_b chr
5898: where chr.currency_code = cl.currency_code
5899: and cl.end_date >= chr.start_date
5900: and cl.cust_name = p_customer_name
5901: and cl.cust_acc_number = p_customer_acc_name);

Line 5913: from okc_k_headers_b

5909: and scs_code = 'PROGRAM'
5910: and nvl(TEMPLATE_YN, 'N') = 'N'
5911: and sts_code = 'ACTIVE'
5912: and exists (select 1
5913: from okc_k_headers_b
5914: where id = p_chr_id
5915: and authoring_org_id = prg_hdr.authoring_org_id);
5916:
5917: l_program_id number;

Line 5931: l_auth_org_id okc_k_headers_b.authoring_org_id%type;

5927: SELECT authoring_org_id, inv_organization_id
5928: FROM okl_k_headers_full_V
5929: WHERE id = p_chr_id;
5930:
5931: l_auth_org_id okc_k_headers_b.authoring_org_id%type;
5932: l_inv_org_id okc_k_headers_b.inv_organization_id%type;
5933:
5934: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
5935: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

Line 5932: l_inv_org_id okc_k_headers_b.inv_organization_id%type;

5928: FROM okl_k_headers_full_V
5929: WHERE id = p_chr_id;
5930:
5931: l_auth_org_id okc_k_headers_b.authoring_org_id%type;
5932: l_inv_org_id okc_k_headers_b.inv_organization_id%type;
5933:
5934: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
5935: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
5936:

Line 6614: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;

6610:
6611: l_api_name VARCHAR2(30) := 'update_deal';
6612: l_api_version CONSTANT NUMBER := 1.0;
6613:
6614: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
6615: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
6616: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
6617: l_object_code VARCHAR2(30) DEFAULT NULL;
6618: l_temp_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE := p_durv_rec.chr_template_yn;

Line 6615: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;

6611: l_api_name VARCHAR2(30) := 'update_deal';
6612: l_api_version CONSTANT NUMBER := 1.0;
6613:
6614: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
6615: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
6616: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
6617: l_object_code VARCHAR2(30) DEFAULT NULL;
6618: l_temp_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE := p_durv_rec.chr_template_yn;
6619:

Line 6616: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;

6612: l_api_version CONSTANT NUMBER := 1.0;
6613:
6614: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
6615: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
6616: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
6617: l_object_code VARCHAR2(30) DEFAULT NULL;
6618: l_temp_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE := p_durv_rec.chr_template_yn;
6619:
6620: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;

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

6614: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
6615: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
6616: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
6617: l_object_code VARCHAR2(30) DEFAULT NULL;
6618: l_temp_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE := p_durv_rec.chr_template_yn;
6619:
6620: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
6621: l_chr_id NUMBER;
6622: row_cnt NUMBER;

Line 6725: FROM okc_k_headers_b CHR

6721: l_lrls_yn VARCHAR2(1) := 'X';
6722:
6723: CURSOR chk_fin_ast_csr IS
6724: SELECT 'Y'
6725: FROM okc_k_headers_b CHR
6726: WHERE EXISTS (SELECT 1
6727: FROM okc_line_styles_b lse,
6728: okc_k_lines_b cle,
6729: okl_k_lines kle

Line 6776: from okc_k_headers_b chr

6772: AND rgp.chr_id = p_durv_rec.chr_id;
6773:
6774: CURSOR is_re_lease_csr IS
6775: select chr.orig_system_source_code
6776: from okc_k_headers_b chr
6777: where chr.id = p_durv_rec.chr_id;
6778:
6779: l_orig_sys_src_code okc_k_headers_b.orig_system_source_code%type := null;
6780:

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

6775: select chr.orig_system_source_code
6776: from okc_k_headers_b chr
6777: where chr.id = p_durv_rec.chr_id;
6778:
6779: l_orig_sys_src_code okc_k_headers_b.orig_system_source_code%type := null;
6780:
6781: --Bug# 4619575
6782: CURSOR l_ptmpl_csr (p_chr_id IN NUMBER) IS
6783: SELECT chrb.template_yn,

Line 6785: FROM okc_k_headers_b chrb,

6781: --Bug# 4619575
6782: CURSOR l_ptmpl_csr (p_chr_id IN NUMBER) IS
6783: SELECT chrb.template_yn,
6784: khr.template_type_code
6785: FROM okc_k_headers_b chrb,
6786: okl_k_headers khr
6787: WHERE chrb.id = khr.id
6788: AND chrb.id = p_chr_id;
6789:

Line 6813: l_ptemplate_yn okc_k_headers_b.template_yn%type;

6809: WHERE dnz_chr_id = p_chr_id
6810: AND rle_code ='LESSOR';
6811:
6812: l_template_type_code okl_k_headers.template_type_code%type;
6813: l_ptemplate_yn okc_k_headers_b.template_yn%type;
6814:
6815: CURSOR c_orig_pdt_csr(p_chr_id IN NUMBER) IS
6816: SELECT pdt_id
6817: FROM okl_k_headers

Line 8324: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;

8320:
8321: l_api_name VARCHAR2(30) := 'load_deal';
8322: l_api_version CONSTANT NUMBER := 1.0;
8323:
8324: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
8325: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
8326: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
8327: l_object_code VARCHAR2(30) DEFAULT NULL;
8328:

Line 8325: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;

8321: l_api_name VARCHAR2(30) := 'load_deal';
8322: l_api_version CONSTANT NUMBER := 1.0;
8323:
8324: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
8325: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
8326: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
8327: l_object_code VARCHAR2(30) DEFAULT NULL;
8328:
8329: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;

Line 8326: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;

8322: l_api_version CONSTANT NUMBER := 1.0;
8323:
8324: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
8325: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
8326: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
8327: l_object_code VARCHAR2(30) DEFAULT NULL;
8328:
8329: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
8330: l_chr_id NUMBER;

Line 8705: l_template_yn okc_k_headers_b.TEMPLATE_YN%TYPE;

8701: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;
8702: l_api_name CONSTANT varchar2(30) := 'copy_lease_contract';
8703: l_api_version CONSTANT NUMBER := 1.0;
8704: --Added by jjuneja
8705: l_template_yn okc_k_headers_b.TEMPLATE_YN%TYPE;
8706: CURSOR c1(p_chr_id NUMBER) IS
8707: SELECT * FROM okc_k_headers_b
8708: WHERE id=p_chr_id;
8709: --End of addition by jjuneja

Line 8707: SELECT * FROM okc_k_headers_b

8703: l_api_version CONSTANT NUMBER := 1.0;
8704: --Added by jjuneja
8705: l_template_yn okc_k_headers_b.TEMPLATE_YN%TYPE;
8706: CURSOR c1(p_chr_id NUMBER) IS
8707: SELECT * FROM okc_k_headers_b
8708: WHERE id=p_chr_id;
8709: --End of addition by jjuneja
8710:
8711: Begin

Line 9070: okc_k_headers_b chr

9066: -- end:| 21-Nov-2008 cklee Bug 7569200 -- Fixed display LEDGER NAME issue |
9067:
9068: FROM gl_ledgers_public_v bks,
9069: hr_operating_units ou,
9070: okc_k_headers_b chr
9071: WHERE bks.ledger_id = ou.set_of_books_id
9072: AND ou.organization_id = chr.authoring_org_id
9073: AND chr.authoring_org_id = p_organization_id
9074: AND chr.id = p_chr_id;

Line 9444: FROM OKC_K_HEADERS_B

9440: l_api_version CONSTANT NUMBER := 1.0;
9441:
9442: CURSOR c_khr_currency(p_chr_id IN NUMBER) IS
9443: SELECT CURRENCY_CODE
9444: FROM OKC_K_HEADERS_B
9445: WHERE ID = p_chr_id;
9446:
9447: CURSOR c_residual_amt(p_chr_id NUMBER) IS
9448: SELECT SUM(kle.residual_value) total_residual_amount

Line 9486: l_currency_code okc_k_headers_b.currency_code%TYPE;

9482: AND lseb.lty_code = 'FEE'
9483: AND kle.fee_purpose_code = 'RVI';
9484:
9485: l_eot_option_code okc_rules_b.rule_information1%TYPE;
9486: l_currency_code okc_k_headers_b.currency_code%TYPE;
9487: l_total_financed_amount NUMBER;
9488: l_total_funded NUMBER;
9489: l_total_subsidies NUMBER;
9490: l_eot_amount NUMBER;