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_PARTY_ROLES_B

Line 1187: FROM okc_k_party_roles_b cpl, okc_subclass_roles ROLES

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

Line 1829: -- okc_k_party_roles_b and okl_k_party_roles

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

Line 1941: FROM okc_k_party_roles_B

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

Line 2108: -- okc_k_party_roles_b and okl_k_party_roles

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

Line 2225: FROM okc_k_party_roles_B

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

Line 2467: -- okc_k_party_roles_b and okl_k_party_roles

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

Line 2869: from okc_k_party_roles_b cplv

2865:
2866: CURSOR c_vp_cpl_csr IS
2867: --Start modified abhsaxen for performance SQLID 20562566
2868: select cplv.id
2869: from okc_k_party_roles_b cplv
2870: where cplv.rle_code = g_lease_vendor
2871: and cplv.chr_id = p_source_id
2872: and cplv.dnz_chr_id = cplv.chr_id
2873: and not exists (select 1

Line 2874: from okc_k_party_roles_b s_cpl

2870: where cplv.rle_code = g_lease_vendor
2871: and cplv.chr_id = p_source_id
2872: and cplv.dnz_chr_id = cplv.chr_id
2873: and not exists (select 1
2874: from okc_k_party_roles_b s_cpl
2875: where s_cpl.chr_id = p_dest_id
2876: and s_cpl.dnz_chr_id = s_cpl.chr_id
2877: and s_cpl.rle_code = g_lease_vendor
2878: and cplv.object1_id1 = s_cpl.object1_id1

Line 3892: , okc_k_party_roles_b prl

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

Line 4178: , okc_k_party_roles_b prl

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

Line 4629: , okc_k_party_roles_b prl

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

Line 4646: , okc_k_party_roles_b prl

4642:
4643: CURSOR l_leaseAppTmpl1_crs(p_object1_id1 VARCHAR2, p_object1_id2 VARCHAR2, p_customer_code VARCHAR2) IS
4644: SELECT CHR.id
4645: FROM okl_k_headers_full_v CHR
4646: , okc_k_party_roles_b prl
4647: WHERE prl.dnz_chr_id = CHR.id
4648: AND prl.chr_id = CHR.id
4649: AND CHR.scs_code = 'LEASE'
4650: AND CHR.chr_type = 'CYA'

Line 4664: , okc_k_party_roles_b prl

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

Line 4684: , okc_k_party_roles_b prl

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

Line 6121: -- okc_k_party_roles_b and okl_k_party_roles

6117: lp_lessee_cplv_rec.jtot_object1_code := 'OKX_PARTY';
6118:
6119: --Bug# 4558486: Changed call to okl_k_party_roles_pvt api
6120: -- to update records in tables
6121: -- okc_k_party_roles_b and okl_k_party_roles
6122: /*
6123: OKL_OKC_MIGRATION_PVT.update_k_party_role(
6124: p_api_version => p_api_version,
6125: p_init_msg_list => p_init_msg_list,

Line 6994: -- okc_k_party_roles_b and okl_k_party_roles

6990:
6991:
6992: --Bug# 4558486: Changed call to okl_k_party_roles_pvt api
6993: -- to create records in tables
6994: -- okc_k_party_roles_b and okl_k_party_roles
6995: /*
6996: OKL_OKC_MIGRATION_PVT.create_k_party_role(
6997: p_api_version => p_api_version,
6998: p_init_msg_list => p_init_msg_list,

Line 7037: -- okc_k_party_roles_b and okl_k_party_roles

7033: lp_lessee_cplv_rec.jtot_object1_code := p_durv_rec.cust_jtot_object1_code;
7034:
7035: --Bug# 4558486: Changed call to okl_k_party_roles_pvt api
7036: -- to update records in tables
7037: -- okc_k_party_roles_b and okl_k_party_roles
7038: /*
7039: OKL_OKC_MIGRATION_PVT.update_k_party_role(
7040: p_api_version => p_api_version,
7041: p_init_msg_list => p_init_msg_list,

Line 7077: -- okc_k_party_roles_b and okl_k_party_roles

7073: lp_lessee_cplv_rec.chr_id := p_durv_rec.chr_id;
7074:
7075: --Bug# 4558486: Changed call to okl_k_party_roles_pvt api
7076: -- to delete records in tables
7077: -- okc_k_party_roles_b and okl_k_party_roles
7078: /*
7079: OKL_OKC_MIGRATION_PVT.delete_k_party_role(
7080: p_api_version => p_api_version,
7081: p_init_msg_list => p_init_msg_list,

Line 8124: FROM okc_k_party_roles_B cpl

8120:
8121: CURSOR l_party_csr(p_rle_code VARCHAR2) IS
8122: --Start modified abhsaxen for performance SQLID 20563248
8123: SELECT cpl.id,cpl.object1_id1,cpl.object1_id2,cpl.jtot_object1_code
8124: FROM okc_k_party_roles_B cpl
8125: WHERE cpl.rle_code = p_rle_code
8126: AND cpl.chr_id = p_durv_rec.chr_id
8127: AND cpl.dnz_chr_id = p_durv_rec.chr_id
8128: --end modified abhsaxen for performance SQLID 20563248

Line 8164: from okc_k_party_roles_b cpl, okc_contacts ctc

8160:
8161: CURSOR l_contact_csr IS
8162: --Start modified abhsaxen for performance SQLID 20563327
8163: select ctc.id,ctc.object1_id1,ctc.object1_id2,ctc.jtot_object1_code
8164: from okc_k_party_roles_b cpl, okc_contacts ctc
8165: where cpl.id = ctc.cpl_id
8166: and cpl.rle_code = 'LESSOR'
8167: and ctc.cro_code = 'SALESPERSON'
8168: and cpl.chr_id = p_durv_rec.chr_id