DBA Data[Home] [Help]

APPS.OKL_UBB_INTEGRATION_PVT dependencies on OKC_K_PARTY_ROLES_V

Line 390: p_rle_code IN OKC_K_PARTY_ROLES_V.RLE_CODE%TYPE,

386: x_return_status OUT NOCOPY VARCHAR2,
387: x_msg_count OUT NOCOPY NUMBER,
388: x_msg_data OUT NOCOPY VARCHAR2,
389: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
390: p_rle_code IN OKC_K_PARTY_ROLES_V.RLE_CODE%TYPE,
391: p_jtot_object1_code IN OKC_K_PARTY_ROLES_V.JTOT_OBJECT1_CODE%TYPE,
392: x_party_id OUT NOCOPY OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE
393: ) IS
394: --Fixed Bug # 5484903

Line 391: p_jtot_object1_code IN OKC_K_PARTY_ROLES_V.JTOT_OBJECT1_CODE%TYPE,

387: x_msg_count OUT NOCOPY NUMBER,
388: x_msg_data OUT NOCOPY VARCHAR2,
389: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
390: p_rle_code IN OKC_K_PARTY_ROLES_V.RLE_CODE%TYPE,
391: p_jtot_object1_code IN OKC_K_PARTY_ROLES_V.JTOT_OBJECT1_CODE%TYPE,
392: x_party_id OUT NOCOPY OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE
393: ) IS
394: --Fixed Bug # 5484903
395: CURSOR party_csr(p_chr_id OKC_K_HEADERS_V.ID%TYPE,

Line 392: x_party_id OUT NOCOPY OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE

388: x_msg_data OUT NOCOPY VARCHAR2,
389: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
390: p_rle_code IN OKC_K_PARTY_ROLES_V.RLE_CODE%TYPE,
391: p_jtot_object1_code IN OKC_K_PARTY_ROLES_V.JTOT_OBJECT1_CODE%TYPE,
392: x_party_id OUT NOCOPY OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE
393: ) IS
394: --Fixed Bug # 5484903
395: CURSOR party_csr(p_chr_id OKC_K_HEADERS_V.ID%TYPE,
396: p_rle_code OKC_K_PARTY_ROLES_V.RLE_CODE%TYPE,

Line 396: p_rle_code OKC_K_PARTY_ROLES_V.RLE_CODE%TYPE,

392: x_party_id OUT NOCOPY OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE
393: ) IS
394: --Fixed Bug # 5484903
395: CURSOR party_csr(p_chr_id OKC_K_HEADERS_V.ID%TYPE,
396: p_rle_code OKC_K_PARTY_ROLES_V.RLE_CODE%TYPE,
397: p_jtot_object1_code OKC_K_PARTY_ROLES_V.JTOT_OBJECT1_CODE%TYPE) IS
398: SELECT object1_id1
399: FROM okc_k_party_roles_b
400: WHERE rle_code = p_rle_code

Line 397: p_jtot_object1_code OKC_K_PARTY_ROLES_V.JTOT_OBJECT1_CODE%TYPE) IS

393: ) IS
394: --Fixed Bug # 5484903
395: CURSOR party_csr(p_chr_id OKC_K_HEADERS_V.ID%TYPE,
396: p_rle_code OKC_K_PARTY_ROLES_V.RLE_CODE%TYPE,
397: p_jtot_object1_code OKC_K_PARTY_ROLES_V.JTOT_OBJECT1_CODE%TYPE) IS
398: SELECT object1_id1
399: FROM okc_k_party_roles_b
400: WHERE rle_code = p_rle_code
401: AND dnz_chr_id = p_chr_id

Line 407: l_object1_id1 OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE;

403: AND jtot_object1_code = p_jtot_object1_code;
404:
405: l_proc_name VARCHAR2(35) := 'GET_PARTY_ID';
406: party_failed EXCEPTION;
407: l_object1_id1 OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE;
408:
409: BEGIN
410: IF (G_DEBUG_ENABLED = 'Y') THEN
411: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);