APPS.OKL_AM_UTIL_PVT dependencies on OKC_K_PARTY_ROLES_B

Line 1900: okc_k_party_roles_b kpr

1896: kpr.object1_id1,
1897: kpr.object1_id2
1898: FROM okl_k_headers khr,
1899: okc_k_headers_b par,
1900: okc_k_party_roles_b kpr
1901: WHERE khr.id = cp_chr_id
1902: AND par.id = khr.khr_id
1903: AND par.scs_code = 'PROGRAM'
1904: AND kpr.chr_id = par.id

Line 3965: p_rle_code IN OKC_K_PARTY_ROLES_B.RLE_CODE%TYPE,

3961: -- End of Commnets
3962:
3963: FUNCTION get_party_name(
3964: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
3965: p_rle_code IN OKC_K_PARTY_ROLES_B.RLE_CODE%TYPE,
3966: p_kle_id IN OKL_K_HEADERS.ID%TYPE)
3967: RETURN VARCHAR2 IS
3968: lv_object1_id1 OKC_K_PARTY_ROLES_B.OBJECT1_ID1%TYPE;
3969: lv_object1_id2 OKC_K_PARTY_ROLES_B.OBJECT1_ID2%TYPE;

Line 3968: lv_object1_id1 OKC_K_PARTY_ROLES_B.OBJECT1_ID1%TYPE;

3964: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
3965: p_rle_code IN OKC_K_PARTY_ROLES_B.RLE_CODE%TYPE,
3966: p_kle_id IN OKL_K_HEADERS.ID%TYPE)
3967: RETURN VARCHAR2 IS
3968: lv_object1_id1 OKC_K_PARTY_ROLES_B.OBJECT1_ID1%TYPE;
3969: lv_object1_id2 OKC_K_PARTY_ROLES_B.OBJECT1_ID2%TYPE;
3970: lv_object1_code OKC_K_PARTY_ROLES_B.JTOT_OBJECT1_CODE%TYPE;
3971: lv_name VARCHAR2(2000) := NULL;
3972: excp_party_error EXCEPTION;

Line 3969: lv_object1_id2 OKC_K_PARTY_ROLES_B.OBJECT1_ID2%TYPE;

3965: p_rle_code IN OKC_K_PARTY_ROLES_B.RLE_CODE%TYPE,
3966: p_kle_id IN OKL_K_HEADERS.ID%TYPE)
3967: RETURN VARCHAR2 IS
3968: lv_object1_id1 OKC_K_PARTY_ROLES_B.OBJECT1_ID1%TYPE;
3969: lv_object1_id2 OKC_K_PARTY_ROLES_B.OBJECT1_ID2%TYPE;
3970: lv_object1_code OKC_K_PARTY_ROLES_B.JTOT_OBJECT1_CODE%TYPE;
3971: lv_name VARCHAR2(2000) := NULL;
3972: excp_party_error EXCEPTION;
3973:

Line 3970: lv_object1_code OKC_K_PARTY_ROLES_B.JTOT_OBJECT1_CODE%TYPE;

3966: p_kle_id IN OKL_K_HEADERS.ID%TYPE)
3967: RETURN VARCHAR2 IS
3968: lv_object1_id1 OKC_K_PARTY_ROLES_B.OBJECT1_ID1%TYPE;
3969: lv_object1_id2 OKC_K_PARTY_ROLES_B.OBJECT1_ID2%TYPE;
3970: lv_object1_code OKC_K_PARTY_ROLES_B.JTOT_OBJECT1_CODE%TYPE;
3971: lv_name VARCHAR2(2000) := NULL;
3972: excp_party_error EXCEPTION;
3973:
3974: -- Get the Party role details

Line 3977: p_rle_code OKC_K_PARTY_ROLES_B.RLE_CODE%TYPE)

3973:
3974: -- Get the Party role details
3975: CURSOR c_party_csr(p_chr_id OKC_K_HEADERS_B.ID%TYPE,
3976: p_kle_id OKL_K_LINES.ID%TYPE,
3977: p_rle_code OKC_K_PARTY_ROLES_B.RLE_CODE%TYPE)
3978: IS
3979: SELECT object1_id1,
3980: object1_id2,
3981: jtot_object1_code

Line 3982: FROM okc_k_party_roles_b

3978: IS
3979: SELECT object1_id1,
3980: object1_id2,
3981: jtot_object1_code
3982: FROM okc_k_party_roles_b
3983: WHERE dnz_chr_id = p_chr_id
3984: AND rle_code = p_rle_code
3985: AND nvl(cle_id,1) = nvl(p_Kle_id,nvl(cle_id,1));
3986: