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

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

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

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

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

Line 2712: l_start_date okc_k_headers_b.start_date%TYPE;

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

Line 2815: FROM okc_k_headers_b

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

Line 2845: FROM okc_k_headers_b CHR,

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

Line 3421: FROM okc_k_headers_b

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

Line 3424: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;

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

Line 3425: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;

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

Line 3557: FROM okc_k_headers_b

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

Line 3700: FROM okc_k_headers_b

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

Line 3705: FROM okc_k_headers_b

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

Line 3708: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;

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

Line 3709: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;

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

Line 3710: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;

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

Line 3881: FROM okc_k_headers_b

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

Line 3886: FROM okc_k_headers_b

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

Line 3891: FROM okc_k_headers_b CHR

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

Line 3904: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;

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

Line 3905: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;

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

Line 3906: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;

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

Line 4167: FROM okc_k_headers_b

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

Line 4172: FROM okc_k_headers_b

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

Line 4177: FROM okc_k_headers_b CHR

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

Line 4192: FROM okc_k_headers_b CHR

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

Line 4198: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;

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

Line 4199: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;

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

Line 4200: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;

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

Line 4202: l_chr_id OKC_K_HEADERS_B.ID%TYPE;

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

Line 4617: FROM okc_k_headers_b

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

Line 4622: FROM okc_k_headers_b

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

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

Line 4662: FROM okc_k_headers_b CHR,

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

Line 4682: FROM okc_k_headers_b CHR,

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

Line 4702: FROM okc_k_headers_b CHR,

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

Line 4715: FROM okc_k_headers_b CHR,

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

Line 4727: FROM okc_k_headers_b CHR

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

Line 4833: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;

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

Line 4834: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;

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

Line 4835: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;

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

Line 4837: l_chr_id OKC_K_HEADERS_B.ID%TYPE;

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

Line 5437: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;

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

Line 5438: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;

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

Line 5439: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;

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

Line 5711: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;

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

Line 5712: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;

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

Line 5713: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;

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

Line 5773: from okc_k_headers_b chr

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

Line 5789: from okc_k_headers_b

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

Line 5807: l_auth_org_id okc_k_headers_b.authoring_org_id%type;

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

Line 5808: l_inv_org_id okc_k_headers_b.inv_organization_id%type;

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

Line 6452: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;

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

Line 6453: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;

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

Line 6454: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;

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

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

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

Line 6563: FROM okc_k_headers_b CHR

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

Line 6615: from okc_k_headers_b chr

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

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

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

Line 6624: FROM okc_k_headers_b chrb,

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

Line 6646: l_ptemplate_yn okc_k_headers_b.template_yn%type;

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

Line 8055: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;

8051:
8052: l_api_name VARCHAR2(30) := 'load_deal';
8053: l_api_version CONSTANT NUMBER := 1.0;
8054:
8055: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
8056: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
8057: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
8058: l_object_code VARCHAR2(30) DEFAULT NULL;
8059:

Line 8056: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;

8052: l_api_name VARCHAR2(30) := 'load_deal';
8053: l_api_version CONSTANT NUMBER := 1.0;
8054:
8055: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
8056: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
8057: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
8058: l_object_code VARCHAR2(30) DEFAULT NULL;
8059:
8060: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;

Line 8057: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;

8053: l_api_version CONSTANT NUMBER := 1.0;
8054:
8055: l_template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE;
8056: l_chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE;
8057: l_contract_number OKC_K_HEADERS_B.CHR_TYPE%TYPE;
8058: l_object_code VARCHAR2(30) DEFAULT NULL;
8059:
8060: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%TYPE;
8061: l_chr_id NUMBER;