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

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

Line 2866: from okc_k_party_roles_b cplv

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

Line 2871: from okc_k_party_roles_b s_cpl

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

Line 3889: , okc_k_party_roles_b prl

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

Line 4175: , okc_k_party_roles_b prl

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

Line 4626: , okc_k_party_roles_b prl

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

Line 4643: , okc_k_party_roles_b prl

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

Line 4661: , okc_k_party_roles_b prl

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

Line 4681: , okc_k_party_roles_b prl

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

Line 6118: -- okc_k_party_roles_b and okl_k_party_roles

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

Line 6991: -- okc_k_party_roles_b and okl_k_party_roles

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

Line 7034: -- okc_k_party_roles_b and okl_k_party_roles

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

Line 7074: -- okc_k_party_roles_b and okl_k_party_roles

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

Line 8115: FROM okc_k_party_roles_B cpl

8111:
8112: CURSOR l_party_csr(p_rle_code VARCHAR2) IS
8113: --Start modified abhsaxen for performance SQLID 20563248
8114: SELECT cpl.id,cpl.object1_id1,cpl.object1_id2,cpl.jtot_object1_code
8115: FROM okc_k_party_roles_B cpl
8116: WHERE cpl.rle_code = p_rle_code
8117: AND cpl.chr_id = p_durv_rec.chr_id
8118: AND cpl.dnz_chr_id = p_durv_rec.chr_id
8119: --end modified abhsaxen for performance SQLID 20563248

Line 8155: from okc_k_party_roles_b cpl, okc_contacts ctc

8151:
8152: CURSOR l_contact_csr IS
8153: --Start modified abhsaxen for performance SQLID 20563327
8154: select ctc.id,ctc.object1_id1,ctc.object1_id2,ctc.jtot_object1_code
8155: from okc_k_party_roles_b cpl, okc_contacts ctc
8156: where cpl.id = ctc.cpl_id
8157: and cpl.rle_code = 'LESSOR'
8158: and ctc.cro_code = 'SALESPERSON'
8159: and cpl.chr_id = p_durv_rec.chr_id