DBA Data[Home] [Help]

APPS.OKL_TAP_PVT dependencies on OKC_K_PARTY_ROLES_V

Line 828: FROM OKC_K_PARTY_ROLES_V

824: l_return_status varchar2(1) := OKL_Api.G_RET_STS_SUCCESS;
825: l_dummy_var VARCHAR2(1) := '?';
826: CURSOR l_cplv_csr IS
827: SELECT 'x'
828: FROM OKC_K_PARTY_ROLES_V
829: WHERE id = p_tapv_rec.cplv_id;
830: BEGIN
831: x_return_status := OKL_Api.G_RET_STS_SUCCESS;
832: IF(p_tapv_rec.cplv_id IS NOT NULL) THEN

Line 858: p_token3_value => 'OKC_K_PARTY_ROLES_V');

854: p_token1_value => 'cplv_id',
855: p_token2 => g_child_table_token,
856: p_token2_value => g_view,
857: p_token3 => g_parent_table_token,
858: p_token3_value => 'OKC_K_PARTY_ROLES_V');
859: x_return_status := OKL_Api.G_RET_STS_ERROR;
860: RAISE G_EXCEPTION_HALT_VALIDATION;
861: END IF;
862: EXCEPTION

Line 2739: FROM OKC_K_PARTY_ROLES_V

2735: ALIAS,ROLE,ATTRIBUTE_CATEGORY,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,
2736: ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,
2737: ATTRIBUTE11,ATTRIBUTE12,ATTRIBUTE13,ATTRIBUTE14,ATTRIBUTE15,CREATED_BY,
2738: CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN
2739: FROM OKC_K_PARTY_ROLES_V
2740: WHERE OKC_K_PARTY_ROLES_V.id = p_id;
2741: l_OKL_cplv_pk OKL_cplv_pk_csr%ROWTYPE;
2742: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2743: l_row_notfound BOOLEAN := TRUE;

Line 2740: WHERE OKC_K_PARTY_ROLES_V.id = p_id;

2736: ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,
2737: ATTRIBUTE11,ATTRIBUTE12,ATTRIBUTE13,ATTRIBUTE14,ATTRIBUTE15,CREATED_BY,
2738: CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN
2739: FROM OKC_K_PARTY_ROLES_V
2740: WHERE OKC_K_PARTY_ROLES_V.id = p_id;
2741: l_OKL_cplv_pk OKL_cplv_pk_csr%ROWTYPE;
2742: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2743: l_row_notfound BOOLEAN := TRUE;
2744: item_not_found_error EXCEPTION;