APPS.IEX_REP_PVT dependencies on IEX_REPOSSESSIONS

Line 486: Cursor l_repossession_csr(cp_repossession_id IN IEX_REPOSSESSIONS.REPOSSESSION_ID%TYPE) IS

482: x_return_status OUT NOCOPY VARCHAR2,
483: p_repv_rec IN repv_rec_type) AS
484: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
485:
486: Cursor l_repossession_csr(cp_repossession_id IN IEX_REPOSSESSIONS.REPOSSESSION_ID%TYPE) IS
487: SELECT repossession_id
488: FROM iex_repossessions
489: WHERE repossession_id = cp_repossession_id;
490:

Line 488: FROM iex_repossessions

484: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
485:
486: Cursor l_repossession_csr(cp_repossession_id IN IEX_REPOSSESSIONS.REPOSSESSION_ID%TYPE) IS
487: SELECT repossession_id
488: FROM iex_repossessions
489: WHERE repossession_id = cp_repossession_id;
490:
491: l_repossession_id IEX_REPOSSESSIONS.REPOSSESSION_ID%TYPE;
492: BEGIN

Line 491: l_repossession_id IEX_REPOSSESSIONS.REPOSSESSION_ID%TYPE;

487: SELECT repossession_id
488: FROM iex_repossessions
489: WHERE repossession_id = cp_repossession_id;
490:
491: l_repossession_id IEX_REPOSSESSIONS.REPOSSESSION_ID%TYPE;
492: BEGIN
493: IF (p_repv_rec.repossession_id = OKL_API.G_MISS_NUM OR
494: p_repv_rec.repossession_id IS NULL)
495: THEN

Line 511: p_token3_value => 'IEX_REPOSSESSIONS');

507: p_token1_value => 'repossession_id',
508: p_token2 => G_CHILD_TABLE_TOKEN,
509: p_token2_value => 'IEX_REPOS_OBJECTS_V',
510: p_token3 => G_PARENT_TABLE_TOKEN,
511: p_token3_value => 'IEX_REPOSSESSIONS');
512: l_return_status := OKL_API.G_RET_STS_ERROR;
513: --dbms_output.put_line('Status after setting message : ' || l_return_status);
514: END IF;
515: CLOSE l_repossession_csr;