DBA Data[Home] [Help]

APPS.OKL_CREATE_KLE_PVT dependencies on OKL_TRX_TYPES_TL

Line 83: G_TRY_NAME OKL_TRX_TYPES_TL.NAME%TYPE := 'Internal Asset Creation';

79: -- GLOBAL VARIABLES
80: -----------------------------------------------------------------------------------
81: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_CREATE_ASSET_PVT';
82: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
83: G_TRY_NAME OKL_TRX_TYPES_TL.NAME%TYPE := 'Internal Asset Creation';
84: G_LANGUAGE OKL_TRX_TYPES_TL.LANGUAGE%TYPE := 'US';
85: -- G_FA_TRY_NAME OKL_TRX_TYPES_V.NAME%TYPE := 'CREATE ASSET LINES';
86: -- G_IB_TRY_NAME OKL_TRX_TYPES_V.NAME%TYPE := 'CREATE_IB_LINES';
87: -- G_TRY_TYPE OKL_TRX_TYPES_V.TRY_TYPE%TYPE := 'TIE';

Line 84: G_LANGUAGE OKL_TRX_TYPES_TL.LANGUAGE%TYPE := 'US';

80: -----------------------------------------------------------------------------------
81: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_CREATE_ASSET_PVT';
82: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
83: G_TRY_NAME OKL_TRX_TYPES_TL.NAME%TYPE := 'Internal Asset Creation';
84: G_LANGUAGE OKL_TRX_TYPES_TL.LANGUAGE%TYPE := 'US';
85: -- G_FA_TRY_NAME OKL_TRX_TYPES_V.NAME%TYPE := 'CREATE ASSET LINES';
86: -- G_IB_TRY_NAME OKL_TRX_TYPES_V.NAME%TYPE := 'CREATE_IB_LINES';
87: -- G_TRY_TYPE OKL_TRX_TYPES_V.TRY_TYPE%TYPE := 'TIE';
88: G_FORMULA_OEC OKL_FORMULAE_V.NAME%TYPE := 'LINE_OEC';

Line 1930: FROM OKL_TRX_TYPES_tl

1926: RETURN VARCHAR2 IS
1927: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
1928: CURSOR c_get_try_id(p_try_name OKL_TRX_TYPES_V.NAME%TYPE) IS
1929: SELECT id
1930: FROM OKL_TRX_TYPES_tl
1931: WHERE upper(name) = upper(p_try_name)
1932: AND language = G_LANGUAGE;
1933: BEGIN
1934: IF (p_try_name = OKL_API.G_MISS_CHAR) OR