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_PARTY_ROLES_B

Line 1186: FROM okc_k_party_roles_b cpl, okc_subclass_roles ROLES

1182: AND cle_id IS NULL;
1183:
1184: CURSOR c_cplv IS
1185: SELECT cpl.id
1186: FROM okc_k_party_roles_b cpl, okc_subclass_roles ROLES
1187: WHERE dnz_chr_id = p_source_chr_id
1188: AND cpl.rle_code = ROLES.rle_code
1189: AND ROLES.scs_code = 'LEASE'
1190: AND cpl.cle_id IS NULL;

Line 1828: -- okc_k_party_roles_b and okl_k_party_roles

1824: ---- Changes End
1825:
1826: --Bug# 4558486: Changed call to okl_k_party_roles_pvt api
1827: -- to create records in tables
1828: -- okc_k_party_roles_b and okl_k_party_roles
1829: /*
1830: OKC_CONTRACT_PARTY_PUB.create_k_party_role(
1831: p_api_version => p_api_version,
1832: p_init_msg_list => p_init_msg_list,

Line 1940: FROM okc_k_party_roles_B

1936:
1937: CURSOR check_party_csr(p_chr_id NUMBER) IS
1938: --start modified abhsaxen for performance SQLID 20562707
1939: SELECT COUNT(1)
1940: FROM okc_k_party_roles_B
1941: WHERE dnz_chr_id = p_chr_id
1942: AND chr_id = p_chr_id
1943: AND rle_code = G_RLE_CODE
1944: AND object1_id1 = p_customer_id1

Line 2107: -- okc_k_party_roles_b and okl_k_party_roles

2103: ---- Changes End
2104:
2105: --Bug# 4558486: Changed call to okl_k_party_roles_pvt api
2106: -- to create records in tables
2107: -- okc_k_party_roles_b and okl_k_party_roles
2108: /*
2109: OKC_CONTRACT_PARTY_PUB.create_k_party_role(
2110: p_api_version => p_api_version,
2111: p_init_msg_list => p_init_msg_list,

Line 2224: FROM okc_k_party_roles_B

2220:
2221: CURSOR check_party_csr(p_chr_id NUMBER) IS
2222: --start modified abhsaxen for performance SQLID 20562694
2223: SELECT COUNT(1)
2224: FROM okc_k_party_roles_B
2225: WHERE dnz_chr_id = p_chr_id
2226: AND chr_id = p_chr_id
2227: AND rle_code = G_RLE_CODE
2228: AND object1_id1 = p_customer_id1

Line 2465: -- okc_k_party_roles_b and okl_k_party_roles

2461: ---- Changes End
2462:
2463: --Bug# 4558486: Changed call to okl_k_party_roles_pvt api
2464: -- to create records in tables
2465: -- okc_k_party_roles_b and okl_k_party_roles
2466: /*
2467: OKC_CONTRACT_PARTY_PUB.create_k_party_role(
2468: p_api_version => p_api_version,
2469: p_init_msg_list => p_init_msg_list,

Line 2849: from okc_k_party_roles_b cplv

2845:
2846: CURSOR c_vp_cpl_csr IS
2847: --Start modified abhsaxen for performance SQLID 20562566
2848: select cplv.id
2849: from okc_k_party_roles_b cplv
2850: where cplv.rle_code = g_lease_vendor
2851: and cplv.chr_id = p_source_id
2852: and cplv.dnz_chr_id = cplv.chr_id
2853: and not exists (select 1

Line 2854: from okc_k_party_roles_b s_cpl

2850: where cplv.rle_code = g_lease_vendor
2851: and cplv.chr_id = p_source_id
2852: and cplv.dnz_chr_id = cplv.chr_id
2853: and not exists (select 1
2854: from okc_k_party_roles_b s_cpl
2855: where s_cpl.chr_id = p_dest_id
2856: and s_cpl.dnz_chr_id = s_cpl.chr_id
2857: and s_cpl.rle_code = g_lease_vendor
2858: and cplv.object1_id1 = s_cpl.object1_id1

Line 3872: , okc_k_party_roles_b prl

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
3876: AND CHR.chr_type = 'CYA'

Line 4158: , okc_k_party_roles_b prl

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
4162: AND CHR.chr_type = 'CYA'

Line 4610: , okc_k_party_roles_b prl

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
4614: AND CHR.chr_type = 'CYA'

Line 4627: , okc_k_party_roles_b prl

4623:
4624: CURSOR l_leaseAppTmpl1_crs(p_object1_id1 VARCHAR2, p_object1_id2 VARCHAR2, p_customer_code VARCHAR2) IS
4625: SELECT CHR.id
4626: FROM okl_k_headers_full_v CHR
4627: , okc_k_party_roles_b prl
4628: WHERE prl.dnz_chr_id = CHR.id
4629: AND prl.chr_id = CHR.id
4630: AND CHR.scs_code = 'LEASE'
4631: AND CHR.chr_type = 'CYA'

Line 4645: , okc_k_party_roles_b prl

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
4648: AND prl.chr_id = CHR.id
4649: AND CHR.scs_code = p_scs_code

Line 4665: , okc_k_party_roles_b prl

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
4668: AND prl.chr_id = CHR.id
4669: AND CHR.scs_code = 'LEASE'

Line 6283: -- okc_k_party_roles_b and okl_k_party_roles

6279: lp_lessee_cplv_rec.jtot_object1_code := 'OKX_PARTY';
6280:
6281: --Bug# 4558486: Changed call to okl_k_party_roles_pvt api
6282: -- to update records in tables
6283: -- okc_k_party_roles_b and okl_k_party_roles
6284: /*
6285: OKL_OKC_MIGRATION_PVT.update_k_party_role(
6286: p_api_version => p_api_version,
6287: p_init_msg_list => p_init_msg_list,

Line 6808: FROM okc_k_party_roles_b

6804: AND qcl.LANGUAGE = 'US';
6805:
6806: CURSOR c_lessor(p_chr_id NUMBER) IS
6807: SELECT id
6808: FROM okc_k_party_roles_b
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;

Line 7259: -- okc_k_party_roles_b and okl_k_party_roles

7255:
7256:
7257: --Bug# 4558486: Changed call to okl_k_party_roles_pvt api
7258: -- to create records in tables
7259: -- okc_k_party_roles_b and okl_k_party_roles
7260: /*
7261: OKL_OKC_MIGRATION_PVT.create_k_party_role(
7262: p_api_version => p_api_version,
7263: p_init_msg_list => p_init_msg_list,

Line 7302: -- okc_k_party_roles_b and okl_k_party_roles

7298: lp_lessee_cplv_rec.jtot_object1_code := p_durv_rec.cust_jtot_object1_code;
7299:
7300: --Bug# 4558486: Changed call to okl_k_party_roles_pvt api
7301: -- to update records in tables
7302: -- okc_k_party_roles_b and okl_k_party_roles
7303: /*
7304: OKL_OKC_MIGRATION_PVT.update_k_party_role(
7305: p_api_version => p_api_version,
7306: p_init_msg_list => p_init_msg_list,

Line 7342: -- okc_k_party_roles_b and okl_k_party_roles

7338: lp_lessee_cplv_rec.chr_id := p_durv_rec.chr_id;
7339:
7340: --Bug# 4558486: Changed call to okl_k_party_roles_pvt api
7341: -- to delete records in tables
7342: -- okc_k_party_roles_b and okl_k_party_roles
7343: /*
7344: OKL_OKC_MIGRATION_PVT.delete_k_party_role(
7345: p_api_version => p_api_version,
7346: p_init_msg_list => p_init_msg_list,

Line 8393: FROM okc_k_party_roles_B cpl

8389:
8390: CURSOR l_party_csr(p_rle_code VARCHAR2) IS
8391: --Start modified abhsaxen for performance SQLID 20563248
8392: SELECT cpl.id,cpl.object1_id1,cpl.object1_id2,cpl.jtot_object1_code
8393: FROM okc_k_party_roles_B cpl
8394: WHERE cpl.rle_code = p_rle_code
8395: AND cpl.chr_id = p_durv_rec.chr_id
8396: AND cpl.dnz_chr_id = p_durv_rec.chr_id
8397: --end modified abhsaxen for performance SQLID 20563248

Line 8435: from okc_k_party_roles_b cpl, okc_contacts ctc

8431:
8432: CURSOR l_contact_csr IS
8433: --Start modified abhsaxen for performance SQLID 20563327
8434: select ctc.id,ctc.object1_id1,ctc.object1_id2,ctc.jtot_object1_code
8435: from okc_k_party_roles_b cpl, okc_contacts ctc
8436: where cpl.id = ctc.cpl_id
8437: and cpl.rle_code = 'LESSOR'
8438: and ctc.cro_code = 'SALESPERSON'
8439: and cpl.chr_id = p_durv_rec.chr_id