DBA Data[Home] [Help]

APPS.OKL_SPLIT_ASSET_PVT dependencies on OKL_TRX_TYPES_V

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

50:
51: -- GLOBAL VARIABLES
52: --------------------------------------------------------------------------------
53: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_SPLIT_ASSET_PVT';
54: G_TRY_NAME OKL_TRX_TYPES_V.NAME%TYPE := 'Split Asset';
55: G_TRY_TYPE OKL_TRX_TYPES_V.TRY_TYPE%TYPE := 'TIE';
56: --------------------------------------------------------------------------------
57: --Globals for csi item instance
58: --------------------------------------------------------------------------------

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

51: -- GLOBAL VARIABLES
52: --------------------------------------------------------------------------------
53: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_SPLIT_ASSET_PVT';
54: G_TRY_NAME OKL_TRX_TYPES_V.NAME%TYPE := 'Split Asset';
55: G_TRY_TYPE OKL_TRX_TYPES_V.TRY_TYPE%TYPE := 'TIE';
56: --------------------------------------------------------------------------------
57: --Globals for csi item instance
58: --------------------------------------------------------------------------------
59: G_IB_TXN_TYPE_NOT_FOUND CONSTANT VARCHAR2(200) := 'OKL_LLA_IB_TXN_TYPE_NOT_FOUND';

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

3618: END Validate_Attributes;
3619: -------------------------------------------------------------------------------
3620: --Function to verify TRY_ID for the transaction try_id
3621: -------------------------------------------------------------------------------
3622: FUNCTION get_try_id(p_try_name IN OKL_TRX_TYPES_V.NAME%TYPE,
3623: x_try_id OUT NOCOPY OKC_LINE_STYLES_V.ID%TYPE)
3624: RETURN VARCHAR2 IS
3625: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
3626: CURSOR c_get_try_id(p_try_name OKL_TRX_TYPES_V.NAME%TYPE) IS

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

3622: FUNCTION get_try_id(p_try_name IN OKL_TRX_TYPES_V.NAME%TYPE,
3623: x_try_id OUT NOCOPY OKC_LINE_STYLES_V.ID%TYPE)
3624: RETURN VARCHAR2 IS
3625: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
3626: CURSOR c_get_try_id(p_try_name OKL_TRX_TYPES_V.NAME%TYPE) IS
3627: SELECT id
3628: FROM OKL_TRX_TYPES_TL
3629: WHERE UPPER(name) = UPPER(p_try_name)
3630: AND LANGUAGE = 'US';