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_CREATE_PUB dependencies on OKC_K_HEADERS_B

Line 453: okc_k_headers_b chr

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

Line 464: From okc_k_headers_b

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

Line 562: From okc_k_headers_b

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

Line 1170: okc_k_headers_b CHR,

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

Line 1171: okc_k_headers_b mla

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

Line 1218: l_cust_acct_id okc_k_headers_b.cust_acct_id%type;

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

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

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

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

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

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

2703: l_chr_id okc_rule_groups_v.chr_id%TYPE := p_dest_id;
2704: l_to_template_yn VARCHAR2(5) :='N';
2705: x_rgp_id okc_rule_groups_v.id%TYPE;
2706:
2707: l_func_curr_code okc_k_headers_b.currency_code%TYPE := NULL;
2708: l_k_curr_code okc_k_headers_b.currency_code%TYPE := NULL;
2709: l_start_date okc_k_headers_b.start_date%TYPE;
2710: l_rule_amt NUMBER;
2711: x_contract_currency okl_k_headers_full_v.currency_code%TYPE := NULL;

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

2704: l_to_template_yn VARCHAR2(5) :='N';
2705: x_rgp_id okc_rule_groups_v.id%TYPE;
2706:
2707: l_func_curr_code okc_k_headers_b.currency_code%TYPE := NULL;
2708: l_k_curr_code okc_k_headers_b.currency_code%TYPE := NULL;
2709: l_start_date okc_k_headers_b.start_date%TYPE;
2710: l_rule_amt NUMBER;
2711: x_contract_currency okl_k_headers_full_v.currency_code%TYPE := NULL;
2712: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE := NULL;

Line 2709: l_start_date okc_k_headers_b.start_date%TYPE;

2705: x_rgp_id okc_rule_groups_v.id%TYPE;
2706:
2707: l_func_curr_code okc_k_headers_b.currency_code%TYPE := NULL;
2708: l_k_curr_code okc_k_headers_b.currency_code%TYPE := NULL;
2709: l_start_date okc_k_headers_b.start_date%TYPE;
2710: l_rule_amt NUMBER;
2711: x_contract_currency okl_k_headers_full_v.currency_code%TYPE := NULL;
2712: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE := NULL;
2713: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE := NULL;

Line 2812: FROM okc_k_headers_b

2808: --end modified abhsaxen for performance SQLID 20562755
2809:
2810: CURSOR c_k_curr_csr IS
2811: SELECT currency_code, start_date
2812: FROM okc_k_headers_b
2813: WHERE id = p_dest_id;
2814:
2815: CURSOR c_rule_segmnts_csr(p_rule_id IN NUMBER) IS
2816: SELECT RULE_INFORMATION1,RULE_INFORMATION2,RULE_INFORMATION3,RULE_INFORMATION4,RULE_INFORMATION5,

Line 2842: FROM okc_k_headers_b CHR,

2838: --end modifying abhsaxen Cursor not in use
2839:
2840: CURSOR c_rrdid_csr IS
2841: SELECT rgrdfs.id
2842: FROM okc_k_headers_b CHR,
2843: okc_subclass_roles sre,
2844: okc_role_sources rse,
2845: okc_subclass_rg_defs rgdfs,
2846: okc_rg_role_defs rgrdfs

Line 3418: FROM okc_k_headers_b

3414: l_api_version CONSTANT NUMBER := 1.0;
3415:
3416: CURSOR l_source_crs IS
3417: SELECT template_yn, chr_type
3418: FROM okc_k_headers_b
3419: WHERE id = p_source_chr_id;
3420:
3421: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
3422: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;

Line 3421: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;

3417: SELECT template_yn, chr_type
3418: FROM okc_k_headers_b
3419: WHERE id = p_source_chr_id;
3420:
3421: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
3422: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
3423: BEGIN
3424:
3425: OKC_CONTEXT.SET_OKC_ORG_CONTEXT(

Line 3422: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;

3418: FROM okc_k_headers_b
3419: WHERE id = p_source_chr_id;
3420:
3421: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
3422: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
3423: BEGIN
3424:
3425: OKC_CONTEXT.SET_OKC_ORG_CONTEXT(
3426: p_org_id => p_org_id,

Line 3554: FROM okc_k_headers_b

3550: l_value VARCHAR2(1) := OKL_API.G_FALSE;
3551:
3552: CURSOR l_source_k_num_crs IS
3553: SELECT contract_number
3554: FROM okc_k_headers_b
3555: WHERE id = p_source_chr_id;
3556:
3557: l_inv_agmt_chr_id_tbl_type Okl_Securitization_Pvt.inv_agmt_chr_id_tbl_type;
3558:

Line 3697: FROM okc_k_headers_b

3693: l_api_version CONSTANT NUMBER := 1.0;
3694:
3695: CURSOR l_source_crs IS
3696: SELECT template_yn, chr_type
3697: FROM okc_k_headers_b
3698: WHERE id = p_source_chr_id;
3699:
3700: CURSOR l_source_k_num_crs IS
3701: SELECT contract_number

Line 3702: FROM okc_k_headers_b

3698: WHERE id = p_source_chr_id;
3699:
3700: CURSOR l_source_k_num_crs IS
3701: SELECT contract_number
3702: FROM okc_k_headers_b
3703: WHERE id = p_source_chr_id;
3704:
3705: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
3706: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;

Line 3705: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;

3701: SELECT contract_number
3702: FROM okc_k_headers_b
3703: WHERE id = p_source_chr_id;
3704:
3705: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
3706: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
3707: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
3708:
3709: BEGIN

Line 3706: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;

3702: FROM okc_k_headers_b
3703: WHERE id = p_source_chr_id;
3704:
3705: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
3706: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
3707: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
3708:
3709: BEGIN
3710:

Line 3707: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;

3703: WHERE id = p_source_chr_id;
3704:
3705: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
3706: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
3707: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
3708:
3709: BEGIN
3710:
3711: OKC_CONTEXT.SET_OKC_ORG_CONTEXT(

Line 3878: FROM okc_k_headers_b

3874: l_api_version CONSTANT NUMBER := 1.0;
3875:
3876: CURSOR l_source_crs IS
3877: SELECT template_yn, chr_type
3878: FROM okc_k_headers_b
3879: WHERE id = p_source_chr_id;
3880:
3881: CURSOR l_source_k_num_crs IS
3882: SELECT contract_number

Line 3883: FROM okc_k_headers_b

3879: WHERE id = p_source_chr_id;
3880:
3881: CURSOR l_source_k_num_crs IS
3882: SELECT contract_number
3883: FROM okc_k_headers_b
3884: WHERE id = p_source_chr_id;
3885:
3886: 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
3887: SELECT CHR.id

Line 3888: FROM okc_k_headers_b CHR

3884: WHERE id = p_source_chr_id;
3885:
3886: 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
3887: SELECT CHR.id
3888: FROM okc_k_headers_b CHR
3889: , okc_k_party_roles_b prl
3890: WHERE prl.dnz_chr_id = CHR.id
3891: AND prl.chr_id = CHR.id
3892: AND CHR.scs_code = p_scs_code

Line 3901: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;

3897: AND prl.object1_id2 = p_object1_id2
3898: AND prl.jtot_object1_code = p_customer_code
3899: AND CHR.contract_number = p_source_contract_number;
3900:
3901: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
3902: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
3903: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
3904: l_object_code VARCHAR2(30) DEFAULT NULL;
3905:

Line 3902: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;

3898: AND prl.jtot_object1_code = p_customer_code
3899: AND CHR.contract_number = p_source_contract_number;
3900:
3901: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
3902: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
3903: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
3904: l_object_code VARCHAR2(30) DEFAULT NULL;
3905:
3906: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;

Line 3903: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;

3899: AND CHR.contract_number = p_source_contract_number;
3900:
3901: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
3902: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
3903: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
3904: l_object_code VARCHAR2(30) DEFAULT NULL;
3905:
3906: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
3907:

Line 4164: FROM okc_k_headers_b

4160: l_api_version CONSTANT NUMBER := 1.0;
4161:
4162: CURSOR l_source_crs IS
4163: SELECT template_yn, chr_type
4164: FROM okc_k_headers_b
4165: WHERE id = p_source_chr_id;
4166:
4167: CURSOR l_source_k_num_crs IS
4168: SELECT contract_number

Line 4169: FROM okc_k_headers_b

4165: WHERE id = p_source_chr_id;
4166:
4167: CURSOR l_source_k_num_crs IS
4168: SELECT contract_number
4169: FROM okc_k_headers_b
4170: WHERE id = p_source_chr_id;
4171:
4172: 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
4173: SELECT CHR.id

Line 4174: FROM okc_k_headers_b CHR

4170: WHERE id = p_source_chr_id;
4171:
4172: 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
4173: SELECT CHR.id
4174: FROM okc_k_headers_b CHR
4175: , okc_k_party_roles_b prl
4176: WHERE prl.dnz_chr_id = CHR.id
4177: AND prl.chr_id = CHR.id
4178: AND CHR.scs_code = p_scs_code

Line 4189: FROM okc_k_headers_b CHR

4185: AND CHR.contract_number = p_source_contract_number;
4186:
4187: CURSOR l_src_chr_id_crs(p_scs_code VARCHAR2, p_temp_yn VARCHAR2) IS
4188: SELECT CHR.id
4189: FROM okc_k_headers_b CHR
4190: WHERE CHR.scs_code = p_scs_code
4191: AND CHR.chr_type = 'CYA'
4192: AND CHR.template_yn = p_temp_yn
4193: AND CHR.contract_number = p_source_contract_number;

Line 4195: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;

4191: AND CHR.chr_type = 'CYA'
4192: AND CHR.template_yn = p_temp_yn
4193: AND CHR.contract_number = p_source_contract_number;
4194:
4195: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
4196: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
4197: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
4198: l_object_code VARCHAR2(30) DEFAULT NULL;
4199: l_chr_id OKC_K_HEADERS_B.ID%TYPE;

Line 4196: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;

4192: AND CHR.template_yn = p_temp_yn
4193: AND CHR.contract_number = p_source_contract_number;
4194:
4195: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
4196: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
4197: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
4198: l_object_code VARCHAR2(30) DEFAULT NULL;
4199: l_chr_id OKC_K_HEADERS_B.ID%TYPE;
4200:

Line 4197: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;

4193: AND CHR.contract_number = p_source_contract_number;
4194:
4195: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
4196: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
4197: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
4198: l_object_code VARCHAR2(30) DEFAULT NULL;
4199: l_chr_id OKC_K_HEADERS_B.ID%TYPE;
4200:
4201: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;

Line 4199: l_chr_id OKC_K_HEADERS_B.ID%TYPE;

4195: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
4196: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
4197: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
4198: l_object_code VARCHAR2(30) DEFAULT NULL;
4199: l_chr_id OKC_K_HEADERS_B.ID%TYPE;
4200:
4201: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
4202:
4203: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

Line 4614: FROM okc_k_headers_b

4610: l_program_id NUMBER;
4611:
4612: CURSOR l_source_crs IS
4613: SELECT template_yn, chr_type
4614: FROM okc_k_headers_b
4615: WHERE id = p_source_chr_id;
4616:
4617: CURSOR l_source_k_num_crs IS
4618: SELECT contract_number

Line 4619: FROM okc_k_headers_b

4615: WHERE id = p_source_chr_id;
4616:
4617: CURSOR l_source_k_num_crs IS
4618: SELECT contract_number
4619: FROM okc_k_headers_b
4620: WHERE id = p_source_chr_id;
4621:
4622: -- cursor when only customer is selected
4623: 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 4625: FROM okc_k_headers_b CHR

4621:
4622: -- cursor when only customer is selected
4623: 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
4624: SELECT CHR.id
4625: FROM okc_k_headers_b CHR
4626: , okc_k_party_roles_b prl
4627: WHERE prl.dnz_chr_id = CHR.id
4628: AND prl.chr_id = CHR.id
4629: AND CHR.scs_code = p_scs_code

Line 4659: FROM okc_k_headers_b CHR,

4655:
4656: -- cursor when only customer and program is selected
4657: 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
4658: SELECT CHR.id
4659: FROM okc_k_headers_b CHR,
4660: okl_k_headers khr
4661: , okc_k_party_roles_b prl
4662: WHERE chr.id = khr.id
4663: AND prl.dnz_chr_id = CHR.id

Line 4679: FROM okc_k_headers_b CHR,

4675:
4676: -- cursor when only customer and program is selected
4677: CURSOR l_leaseAppTmpl2_crs(p_object1_id1 VARCHAR2, p_object1_id2 VARCHAR2, p_customer_code VARCHAR2, l_prog_id NUMBER) IS
4678: SELECT CHR.id
4679: FROM okc_k_headers_b CHR,
4680: okl_k_headers khr
4681: , okc_k_party_roles_b prl
4682: WHERE chr.id = khr.id
4683: AND prl.dnz_chr_id = CHR.id

Line 4699: FROM okc_k_headers_b CHR,

4695:
4696: -- cursor when only program is selected
4697: CURSOR l_source_prog_crs(p_scs_code VARCHAR2, p_temp_yn VARCHAR2, l_prog_id NUMBER) IS
4698: SELECT CHR.id
4699: FROM okc_k_headers_b CHR,
4700: okl_k_headers khr
4701: WHERE chr.id = khr.id
4702: AND CHR.scs_code = p_scs_code
4703: AND CHR.chr_type = 'CYA'

Line 4712: FROM okc_k_headers_b CHR,

4708:
4709: -- cursor when only program is selected
4710: CURSOR l_leaseAppTmpl3_crs(l_prog_id NUMBER) IS
4711: SELECT CHR.id
4712: FROM okc_k_headers_b CHR,
4713: okl_k_headers khr
4714: WHERE chr.id = khr.id
4715: AND CHR.scs_code = 'LEASE'
4716: AND CHR.chr_type = 'CYA'

Line 4724: FROM okc_k_headers_b CHR

4720: AND khr_id = l_prog_id;
4721:
4722: CURSOR l_src_chr_id_crs(p_scs_code VARCHAR2, p_temp_yn VARCHAR2) IS
4723: SELECT CHR.id
4724: FROM okc_k_headers_b CHR
4725: WHERE CHR.scs_code = p_scs_code
4726: AND CHR.chr_type = 'CYA'
4727: AND CHR.template_yn = p_temp_yn
4728: AND CHR.contract_number = p_source_contract_number;

Line 4830: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;

4826: ;
4827: --end changed by abhsaxen for Bug#6174484
4828:
4829: l_template_type OKL_K_HEADERS.TEMPLATE_TYPE_CODE%TYPE;
4830: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
4831: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
4832: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
4833: l_object_code VARCHAR2(30) DEFAULT NULL;
4834: l_chr_id OKC_K_HEADERS_B.ID%TYPE;

Line 4831: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;

4827: --end changed by abhsaxen for Bug#6174484
4828:
4829: l_template_type OKL_K_HEADERS.TEMPLATE_TYPE_CODE%TYPE;
4830: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
4831: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
4832: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
4833: l_object_code VARCHAR2(30) DEFAULT NULL;
4834: l_chr_id OKC_K_HEADERS_B.ID%TYPE;
4835:

Line 4832: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;

4828:
4829: l_template_type OKL_K_HEADERS.TEMPLATE_TYPE_CODE%TYPE;
4830: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
4831: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
4832: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
4833: l_object_code VARCHAR2(30) DEFAULT NULL;
4834: l_chr_id OKC_K_HEADERS_B.ID%TYPE;
4835:
4836: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;

Line 4834: l_chr_id OKC_K_HEADERS_B.ID%TYPE;

4830: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
4831: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
4832: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
4833: l_object_code VARCHAR2(30) DEFAULT NULL;
4834: l_chr_id OKC_K_HEADERS_B.ID%TYPE;
4835:
4836: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
4837:
4838: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

Line 5434: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;

5430:
5431: l_api_name VARCHAR2(30) := 'validate_deal';
5432: l_api_version CONSTANT NUMBER := 1.0;
5433:
5434: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
5435: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
5436: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
5437: l_object_code VARCHAR2(30) DEFAULT NULL;
5438:

Line 5435: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;

5431: l_api_name VARCHAR2(30) := 'validate_deal';
5432: l_api_version CONSTANT NUMBER := 1.0;
5433:
5434: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
5435: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
5436: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
5437: l_object_code VARCHAR2(30) DEFAULT NULL;
5438:
5439: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;

Line 5436: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;

5432: l_api_version CONSTANT NUMBER := 1.0;
5433:
5434: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
5435: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
5436: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
5437: l_object_code VARCHAR2(30) DEFAULT NULL;
5438:
5439: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
5440: l_chr_id NUMBER;

Line 5708: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;

5704:
5705: l_api_name VARCHAR2(30) := 'update_release_contract';
5706: l_api_version CONSTANT NUMBER := 1.0;
5707:
5708: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
5709: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
5710: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
5711: l_object_code VARCHAR2(30) DEFAULT NULL;
5712:

Line 5709: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;

5705: l_api_name VARCHAR2(30) := 'update_release_contract';
5706: l_api_version CONSTANT NUMBER := 1.0;
5707:
5708: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
5709: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
5710: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
5711: l_object_code VARCHAR2(30) DEFAULT NULL;
5712:
5713: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;

Line 5710: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;

5706: l_api_version CONSTANT NUMBER := 1.0;
5707:
5708: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
5709: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
5710: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
5711: l_object_code VARCHAR2(30) DEFAULT NULL;
5712:
5713: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
5714: l_chr_id NUMBER;

Line 5770: from okc_k_headers_b chr

5766: select cl.id
5767: from okl_k_hdr_crdtln_uv cl
5768: where cl.contract_number = p_cl_no
5769: and exists ( select 1
5770: from okc_k_headers_b chr
5771: where chr.currency_code = cl.currency_code
5772: and cl.end_date >= chr.start_date
5773: and cl.cust_name = p_customer_name
5774: and cl.cust_acc_number = p_customer_acc_name);

Line 5786: from okc_k_headers_b

5782: and scs_code = 'PROGRAM'
5783: and nvl(TEMPLATE_YN, 'N') = 'N'
5784: and sts_code = 'ACTIVE'
5785: and exists (select 1
5786: from okc_k_headers_b
5787: where id = p_chr_id
5788: and authoring_org_id = prg_hdr.authoring_org_id);
5789:
5790: l_program_id number;

Line 5804: l_auth_org_id okc_k_headers_b.authoring_org_id%type;

5800: SELECT authoring_org_id, inv_organization_id
5801: FROM okl_k_headers_full_V
5802: WHERE id = p_chr_id;
5803:
5804: l_auth_org_id okc_k_headers_b.authoring_org_id%type;
5805: l_inv_org_id okc_k_headers_b.inv_organization_id%type;
5806:
5807: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
5808: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;

Line 5805: l_inv_org_id okc_k_headers_b.inv_organization_id%type;

5801: FROM okl_k_headers_full_V
5802: WHERE id = p_chr_id;
5803:
5804: l_auth_org_id okc_k_headers_b.authoring_org_id%type;
5805: l_inv_org_id okc_k_headers_b.inv_organization_id%type;
5806:
5807: lp_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
5808: lx_chrv_rec OKL_OKC_MIGRATION_PVT.chrv_rec_type;
5809:

Line 6449: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;

6445:
6446: l_api_name VARCHAR2(30) := 'update_deal';
6447: l_api_version CONSTANT NUMBER := 1.0;
6448:
6449: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
6450: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
6451: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
6452: l_object_code VARCHAR2(30) DEFAULT NULL;
6453: l_temp_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE := p_durv_rec.chr_template_yn;

Line 6450: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;

6446: l_api_name VARCHAR2(30) := 'update_deal';
6447: l_api_version CONSTANT NUMBER := 1.0;
6448:
6449: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
6450: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
6451: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
6452: l_object_code VARCHAR2(30) DEFAULT NULL;
6453: l_temp_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE := p_durv_rec.chr_template_yn;
6454:

Line 6451: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;

6447: l_api_version CONSTANT NUMBER := 1.0;
6448:
6449: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
6450: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
6451: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
6452: l_object_code VARCHAR2(30) DEFAULT NULL;
6453: l_temp_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE := p_durv_rec.chr_template_yn;
6454:
6455: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;

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

6449: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
6450: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
6451: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
6452: l_object_code VARCHAR2(30) DEFAULT NULL;
6453: l_temp_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE := p_durv_rec.chr_template_yn;
6454:
6455: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
6456: l_chr_id NUMBER;
6457: row_cnt NUMBER;

Line 6560: FROM okc_k_headers_b CHR

6556: l_lrls_yn VARCHAR2(1) := 'X';
6557:
6558: CURSOR chk_fin_ast_csr IS
6559: SELECT 'Y'
6560: FROM okc_k_headers_b CHR
6561: WHERE EXISTS (SELECT 1
6562: FROM okc_line_styles_b lse,
6563: okc_k_lines_b cle,
6564: okl_k_lines kle

Line 6612: from okc_k_headers_b chr

6608: AND rgp.chr_id = p_durv_rec.chr_id;
6609:
6610: CURSOR is_re_lease_csr IS
6611: select chr.orig_system_source_code
6612: from okc_k_headers_b chr
6613: where chr.id = p_durv_rec.chr_id;
6614:
6615: l_orig_sys_src_code okc_k_headers_b.orig_system_source_code%type := null;
6616:

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

6611: select chr.orig_system_source_code
6612: from okc_k_headers_b chr
6613: where chr.id = p_durv_rec.chr_id;
6614:
6615: l_orig_sys_src_code okc_k_headers_b.orig_system_source_code%type := null;
6616:
6617: --Bug# 4619575
6618: CURSOR l_ptmpl_csr (p_chr_id IN NUMBER) IS
6619: SELECT chrb.template_yn,

Line 6621: FROM okc_k_headers_b chrb,

6617: --Bug# 4619575
6618: CURSOR l_ptmpl_csr (p_chr_id IN NUMBER) IS
6619: SELECT chrb.template_yn,
6620: khr.template_type_code
6621: FROM okc_k_headers_b chrb,
6622: okl_k_headers khr
6623: WHERE chrb.id = khr.id
6624: AND chrb.id = p_chr_id;
6625:

Line 6643: l_ptemplate_yn okc_k_headers_b.template_yn%type;

6639: AND UPPER(qcl.name) = 'OKL KT FOR LA QA CHECKLIST'
6640: AND qcl.LANGUAGE = 'US';
6641:
6642: l_template_type_code okl_k_headers.template_type_code%type;
6643: l_ptemplate_yn okc_k_headers_b.template_yn%type;
6644:
6645: /*
6646: -- mvasudev, 08/18/2004
6647: -- Added PROCEDURE to enable Business Event

Line 8046: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;

8042:
8043: l_api_name VARCHAR2(30) := 'load_deal';
8044: l_api_version CONSTANT NUMBER := 1.0;
8045:
8046: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
8047: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
8048: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
8049: l_object_code VARCHAR2(30) DEFAULT NULL;
8050:

Line 8047: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;

8043: l_api_name VARCHAR2(30) := 'load_deal';
8044: l_api_version CONSTANT NUMBER := 1.0;
8045:
8046: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
8047: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
8048: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
8049: l_object_code VARCHAR2(30) DEFAULT NULL;
8050:
8051: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;

Line 8048: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;

8044: l_api_version CONSTANT NUMBER := 1.0;
8045:
8046: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
8047: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
8048: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
8049: l_object_code VARCHAR2(30) DEFAULT NULL;
8050:
8051: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
8052: l_chr_id NUMBER;