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 2462: -- okc_k_party_roles_b and okl_k_party_roles

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

Line 2846: from okc_k_party_roles_b cplv

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

Line 2851: from okc_k_party_roles_b s_cpl

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

Line 3869: , okc_k_party_roles_b prl

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

Line 4155: , okc_k_party_roles_b prl

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

Line 4607: , okc_k_party_roles_b prl

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

Line 4624: , okc_k_party_roles_b prl

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

Line 4642: , okc_k_party_roles_b prl

4638: CURSOR l_source_chr_prog_id_crs(p_scs_code VARCHAR2, p_temp_yn VARCHAR2, p_object1_id1 VARCHAR2, p_object1_id2 VARCHAR2, p_customer_code VARCHAR2, l_prog_id NUMBER) IS
4639: SELECT CHR.id
4640: FROM okc_k_headers_b CHR,
4641: okl_k_headers khr
4642: , okc_k_party_roles_b prl
4643: WHERE chr.id = khr.id
4644: AND prl.dnz_chr_id = CHR.id
4645: AND prl.chr_id = CHR.id
4646: AND CHR.scs_code = p_scs_code

Line 4662: , okc_k_party_roles_b prl

4658: CURSOR l_leaseAppTmpl2_crs(p_object1_id1 VARCHAR2, p_object1_id2 VARCHAR2, p_customer_code VARCHAR2, l_prog_id NUMBER) IS
4659: SELECT CHR.id
4660: FROM okc_k_headers_b CHR,
4661: okl_k_headers khr
4662: , okc_k_party_roles_b prl
4663: WHERE chr.id = khr.id
4664: AND prl.dnz_chr_id = CHR.id
4665: AND prl.chr_id = CHR.id
4666: AND CHR.scs_code = 'LEASE'

Line 6238: -- okc_k_party_roles_b and okl_k_party_roles

6234: lp_lessee_cplv_rec.jtot_object1_code := 'OKX_PARTY';
6235:
6236: --Bug# 4558486: Changed call to okl_k_party_roles_pvt api
6237: -- to update records in tables
6238: -- okc_k_party_roles_b and okl_k_party_roles
6239: /*
6240: OKL_OKC_MIGRATION_PVT.update_k_party_role(
6241: p_api_version => p_api_version,
6242: p_init_msg_list => p_init_msg_list,

Line 6763: FROM okc_k_party_roles_b

6759: AND qcl.LANGUAGE = 'US';
6760:
6761: CURSOR c_lessor(p_chr_id NUMBER) IS
6762: SELECT id
6763: FROM okc_k_party_roles_b
6764: WHERE dnz_chr_id = p_chr_id
6765: AND rle_code ='LESSOR';
6766:
6767: l_template_type_code okl_k_headers.template_type_code%type;

Line 7192: -- okc_k_party_roles_b and okl_k_party_roles

7188:
7189:
7190: --Bug# 4558486: Changed call to okl_k_party_roles_pvt api
7191: -- to create records in tables
7192: -- okc_k_party_roles_b and okl_k_party_roles
7193: /*
7194: OKL_OKC_MIGRATION_PVT.create_k_party_role(
7195: p_api_version => p_api_version,
7196: p_init_msg_list => p_init_msg_list,

Line 7235: -- okc_k_party_roles_b and okl_k_party_roles

7231: lp_lessee_cplv_rec.jtot_object1_code := p_durv_rec.cust_jtot_object1_code;
7232:
7233: --Bug# 4558486: Changed call to okl_k_party_roles_pvt api
7234: -- to update records in tables
7235: -- okc_k_party_roles_b and okl_k_party_roles
7236: /*
7237: OKL_OKC_MIGRATION_PVT.update_k_party_role(
7238: p_api_version => p_api_version,
7239: p_init_msg_list => p_init_msg_list,

Line 7275: -- okc_k_party_roles_b and okl_k_party_roles

7271: lp_lessee_cplv_rec.chr_id := p_durv_rec.chr_id;
7272:
7273: --Bug# 4558486: Changed call to okl_k_party_roles_pvt api
7274: -- to delete records in tables
7275: -- okc_k_party_roles_b and okl_k_party_roles
7276: /*
7277: OKL_OKC_MIGRATION_PVT.delete_k_party_role(
7278: p_api_version => p_api_version,
7279: p_init_msg_list => p_init_msg_list,

Line 8319: FROM okc_k_party_roles_B cpl

8315:
8316: CURSOR l_party_csr(p_rle_code VARCHAR2) IS
8317: --Start modified abhsaxen for performance SQLID 20563248
8318: SELECT cpl.id,cpl.object1_id1,cpl.object1_id2,cpl.jtot_object1_code
8319: FROM okc_k_party_roles_B cpl
8320: WHERE cpl.rle_code = p_rle_code
8321: AND cpl.chr_id = p_durv_rec.chr_id
8322: AND cpl.dnz_chr_id = p_durv_rec.chr_id
8323: --end modified abhsaxen for performance SQLID 20563248

Line 8359: from okc_k_party_roles_b cpl, okc_contacts ctc

8355:
8356: CURSOR l_contact_csr IS
8357: --Start modified abhsaxen for performance SQLID 20563327
8358: select ctc.id,ctc.object1_id1,ctc.object1_id2,ctc.jtot_object1_code
8359: from okc_k_party_roles_b cpl, okc_contacts ctc
8360: where cpl.id = ctc.cpl_id
8361: and cpl.rle_code = 'LESSOR'
8362: and ctc.cro_code = 'SALESPERSON'
8363: and cpl.chr_id = p_durv_rec.chr_id