DBA Data[Home] [Help]

APPS.OKL_TBO_PVT dependencies on OKL_TRX_TYPES_B

Line 427: FROM Okl_Trx_Types_B

423: l_dummy_var VARCHAR2(1) := '?' ;
424:
425: CURSOR okl_tbov_try_id_fk_csr (p_id IN NUMBER) IS
426: SELECT 'x'
427: FROM Okl_Trx_Types_B
428: WHERE okl_trx_types_b.id = p_id;
429: BEGIN
430:
431: IF (p_tbov_rec.try_id = OKL_API.G_MISS_NUM OR p_tbov_rec.try_id IS NULL)

Line 428: WHERE okl_trx_types_b.id = p_id;

424:
425: CURSOR okl_tbov_try_id_fk_csr (p_id IN NUMBER) IS
426: SELECT 'x'
427: FROM Okl_Trx_Types_B
428: WHERE okl_trx_types_b.id = p_id;
429: BEGIN
430:
431: IF (p_tbov_rec.try_id = OKL_API.G_MISS_NUM OR p_tbov_rec.try_id IS NULL)
432: THEN

Line 448: 'OKL_TRX_TYPES_B');

444: 'try_id',
445: g_child_table_token ,
446: 'OKL_TAX_BASIS_OVERRIDE',
447: g_parent_table_token ,
448: 'OKL_TRX_TYPES_B');
449: l_return_status := OKC_API.G_RET_STS_ERROR;
450:
451: END IF;
452: END IF;

Line 638: FROM Okl_Trx_Types_B

634: l_okl_tbov_fma_id_fk okl_tbov_fma_id_fk_csr%ROWTYPE;
635:
636: CURSOR okl_tbov_try_id_fk_csr (p_id IN NUMBER) IS
637: SELECT 'x'
638: FROM Okl_Trx_Types_B
639: WHERE okl_trx_types_b.id = p_id;
640: l_okl_tbov_try_id_fk okl_tbov_try_id_fk_csr%ROWTYPE;
641:
642: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 639: WHERE okl_trx_types_b.id = p_id;

635:
636: CURSOR okl_tbov_try_id_fk_csr (p_id IN NUMBER) IS
637: SELECT 'x'
638: FROM Okl_Trx_Types_B
639: WHERE okl_trx_types_b.id = p_id;
640: l_okl_tbov_try_id_fk okl_tbov_try_id_fk_csr%ROWTYPE;
641:
642: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
643: l_row_notfound BOOLEAN := TRUE;