DBA Data[Home] [Help]

APPS.OKL_SPLIT_ASSET_PVT dependencies on OKL_TRX_TYPES_V

Line 61: G_TRY_NAME OKL_TRX_TYPES_V.NAME%TYPE := 'Split Asset';

57:
58: -- GLOBAL VARIABLES
59: --------------------------------------------------------------------------------
60: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_SPLIT_ASSET_PVT';
61: G_TRY_NAME OKL_TRX_TYPES_V.NAME%TYPE := 'Split Asset';
62: G_TRY_TYPE OKL_TRX_TYPES_V.TRY_TYPE%TYPE := 'TIE';
63: --------------------------------------------------------------------------------
64: --Globals for csi item instance
65: --------------------------------------------------------------------------------

Line 62: G_TRY_TYPE OKL_TRX_TYPES_V.TRY_TYPE%TYPE := 'TIE';

58: -- GLOBAL VARIABLES
59: --------------------------------------------------------------------------------
60: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_SPLIT_ASSET_PVT';
61: G_TRY_NAME OKL_TRX_TYPES_V.NAME%TYPE := 'Split Asset';
62: G_TRY_TYPE OKL_TRX_TYPES_V.TRY_TYPE%TYPE := 'TIE';
63: --------------------------------------------------------------------------------
64: --Globals for csi item instance
65: --------------------------------------------------------------------------------
66: G_IB_TXN_TYPE_NOT_FOUND CONSTANT VARCHAR2(200) := 'OKL_LLA_IB_TXN_TYPE_NOT_FOUND';

Line 3650: FUNCTION get_try_id(p_try_name IN OKL_TRX_TYPES_V.NAME%TYPE,

3646: END Validate_Attributes;
3647: -------------------------------------------------------------------------------
3648: --Function to verify TRY_ID for the transaction try_id
3649: -------------------------------------------------------------------------------
3650: FUNCTION get_try_id(p_try_name IN OKL_TRX_TYPES_V.NAME%TYPE,
3651: x_try_id OUT NOCOPY OKC_LINE_STYLES_V.ID%TYPE)
3652: RETURN VARCHAR2 IS
3653: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
3654: CURSOR c_get_try_id(p_try_name OKL_TRX_TYPES_V.NAME%TYPE) IS

Line 3654: CURSOR c_get_try_id(p_try_name OKL_TRX_TYPES_V.NAME%TYPE) IS

3650: FUNCTION get_try_id(p_try_name IN OKL_TRX_TYPES_V.NAME%TYPE,
3651: x_try_id OUT NOCOPY OKC_LINE_STYLES_V.ID%TYPE)
3652: RETURN VARCHAR2 IS
3653: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
3654: CURSOR c_get_try_id(p_try_name OKL_TRX_TYPES_V.NAME%TYPE) IS
3655: SELECT id
3656: FROM OKL_TRX_TYPES_TL
3657: WHERE UPPER(name) = UPPER(p_try_name)
3658: AND LANGUAGE = 'US';