DBA Data[Home] [Help]

APPS.OKL_CAT_PVT dependencies on OKL_CSH_ALLCTN_RL_HDR

Line 457: CURSOR c1( p_CAU_ID OKL_CSH_ALLCTN_RL_HDR.ID%TYPE) IS

453: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
454: l_dummy NUMBER;
455: l_row_found BOOLEAN := FALSE;
456:
457: CURSOR c1( p_CAU_ID OKL_CSH_ALLCTN_RL_HDR.ID%TYPE) IS
458: SELECT 1
459: FROM OKL_CSH_ALLCTN_RL_HDR
460: WHERE id = p_CAU_ID;
461:

Line 459: FROM OKL_CSH_ALLCTN_RL_HDR

455: l_row_found BOOLEAN := FALSE;
456:
457: CURSOR c1( p_CAU_ID OKL_CSH_ALLCTN_RL_HDR.ID%TYPE) IS
458: SELECT 1
459: FROM OKL_CSH_ALLCTN_RL_HDR
460: WHERE id = p_CAU_ID;
461:
462: BEGIN
463: IF (p_catv_rec.CAU_ID = OKL_API.G_MISS_NUM OR

Line 481: p_token3_value => 'OKL_CSH_ALLCTN_RL_HDR');

477: p_token1_value => 'CAU_ID',
478: p_token2 => G_CHILD_TABLE_TOKEN,
479: p_token2_value => 'OKL_CASH_ALLCTN_RLS',
480: p_token3 => G_PARENT_TABLE_TOKEN,
481: p_token3_value => 'OKL_CSH_ALLCTN_RL_HDR');
482: l_return_status := OKL_API.G_RET_STS_ERROR;
483: END IF;
484: CLOSE c1;
485: END IF;