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_CONTRACT_PARTY_PVT dependencies on OKC_K_PARTY_ROLES_B

Line 404: CURSOR C1(p_chr_id okc_k_party_roles_b.chr_id%TYPE,

400: l_api_name CONSTANT VARCHAR2(30) := 'create_k_party_role';
401: l_api_version CONSTANT NUMBER := 1;
402: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
403:
404: CURSOR C1(p_chr_id okc_k_party_roles_b.chr_id%TYPE,
405: p_rle_code okc_k_party_roles_b.rle_code%TYPE,
406: p_jtot_object1_code okc_k_party_roles_b.jtot_object1_code%TYPE,
407: p_object1_id1 okc_k_party_roles_b.object1_id1%TYPE,
408: p_object1_id2 okc_k_party_roles_b.object1_id2%TYPE) is

Line 405: p_rle_code okc_k_party_roles_b.rle_code%TYPE,

401: l_api_version CONSTANT NUMBER := 1;
402: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
403:
404: CURSOR C1(p_chr_id okc_k_party_roles_b.chr_id%TYPE,
405: p_rle_code okc_k_party_roles_b.rle_code%TYPE,
406: p_jtot_object1_code okc_k_party_roles_b.jtot_object1_code%TYPE,
407: p_object1_id1 okc_k_party_roles_b.object1_id1%TYPE,
408: p_object1_id2 okc_k_party_roles_b.object1_id2%TYPE) is
409: SELECT id

Line 406: p_jtot_object1_code okc_k_party_roles_b.jtot_object1_code%TYPE,

402: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
403:
404: CURSOR C1(p_chr_id okc_k_party_roles_b.chr_id%TYPE,
405: p_rle_code okc_k_party_roles_b.rle_code%TYPE,
406: p_jtot_object1_code okc_k_party_roles_b.jtot_object1_code%TYPE,
407: p_object1_id1 okc_k_party_roles_b.object1_id1%TYPE,
408: p_object1_id2 okc_k_party_roles_b.object1_id2%TYPE) is
409: SELECT id
410: FROM okc_k_party_roles_b

Line 407: p_object1_id1 okc_k_party_roles_b.object1_id1%TYPE,

403:
404: CURSOR C1(p_chr_id okc_k_party_roles_b.chr_id%TYPE,
405: p_rle_code okc_k_party_roles_b.rle_code%TYPE,
406: p_jtot_object1_code okc_k_party_roles_b.jtot_object1_code%TYPE,
407: p_object1_id1 okc_k_party_roles_b.object1_id1%TYPE,
408: p_object1_id2 okc_k_party_roles_b.object1_id2%TYPE) is
409: SELECT id
410: FROM okc_k_party_roles_b
411: WHERE chr_id = p_chr_id

Line 408: p_object1_id2 okc_k_party_roles_b.object1_id2%TYPE) is

404: CURSOR C1(p_chr_id okc_k_party_roles_b.chr_id%TYPE,
405: p_rle_code okc_k_party_roles_b.rle_code%TYPE,
406: p_jtot_object1_code okc_k_party_roles_b.jtot_object1_code%TYPE,
407: p_object1_id1 okc_k_party_roles_b.object1_id1%TYPE,
408: p_object1_id2 okc_k_party_roles_b.object1_id2%TYPE) is
409: SELECT id
410: FROM okc_k_party_roles_b
411: WHERE chr_id = p_chr_id
412: AND rle_code = p_rle_code

Line 410: FROM okc_k_party_roles_b

406: p_jtot_object1_code okc_k_party_roles_b.jtot_object1_code%TYPE,
407: p_object1_id1 okc_k_party_roles_b.object1_id1%TYPE,
408: p_object1_id2 okc_k_party_roles_b.object1_id2%TYPE) is
409: SELECT id
410: FROM okc_k_party_roles_b
411: WHERE chr_id = p_chr_id
412: AND rle_code = p_rle_code
413: AND jtot_object1_code = p_jtot_object1_code
414: AND object1_id1 = p_object1_id1

Line 699: FROM OKC_K_PARTY_ROLES_B

695: WHERE CPL_ID = p_cplv_rec.id;
696:
697: CURSOR l_rle_code_csr IS
698: SELECT rle_code
699: FROM OKC_K_PARTY_ROLES_B
700: WHERE ID = p_cplv_rec.id;
701:
702: CURSOR cur_get_dnz_chr_id IS
703: SELECT dnz_chr_id

Line 707: CURSOR c_party_share_exist_csr(cp_chr_id okc_k_headers_b.id%TYPE, cp_cpl_id okc_k_party_roles_b.id%TYPE)IS

703: SELECT dnz_chr_id
704: FROM okc_k_party_roles_v
705: WHERE id = p_cplv_rec.id;
706:
707: CURSOR c_party_share_exist_csr(cp_chr_id okc_k_headers_b.id%TYPE, cp_cpl_id okc_k_party_roles_b.id%TYPE)IS
708: SELECT okl_vp_jtf_party_name_pub.get_party_name(pr.rle_code,chr.buy_or_sell,pr.object1_id1,pr.object1_id2) party_name
709: FROM okc_k_party_roles_b pr
710: ,okc_k_headers_b chr
711: ,okc_rules_b rule

Line 709: FROM okc_k_party_roles_b pr

705: WHERE id = p_cplv_rec.id;
706:
707: CURSOR c_party_share_exist_csr(cp_chr_id okc_k_headers_b.id%TYPE, cp_cpl_id okc_k_party_roles_b.id%TYPE)IS
708: SELECT okl_vp_jtf_party_name_pub.get_party_name(pr.rle_code,chr.buy_or_sell,pr.object1_id1,pr.object1_id2) party_name
709: FROM okc_k_party_roles_b pr
710: ,okc_k_headers_b chr
711: ,okc_rules_b rule
712: WHERE pr.id = cp_cpl_id
713: AND rule.rule_information1 = pr.id