APPS.OKL_COPY_ASSET_PVT dependencies on OKL_TRX_TYPES_TL

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

69: G_LEASE_SCS_CODE OKC_K_HEADERS_V.SCS_CODE%TYPE := 'LEASE';
70: G_LOAN_SCS_CODE OKC_K_HEADERS_V.SCS_CODE%TYPE := 'LOAN';
71: -- G_FA_TRY_NAME OKL_TRX_TYPES_V.NAME%TYPE := 'CREATE ASSET LINES';
72: -- G_IB_TRY_NAME OKL_TRX_TYPES_V.NAME%TYPE := 'CREATE_IB_LINES';
73: G_TRY_NAME OKL_TRX_TYPES_TL.NAME%TYPE := 'Internal Asset Creation';
74: G_LANGUAGE OKL_TRX_TYPES_TL.LANGUAGE%TYPE := 'US';
75: G_GEN_INST_NUM_IB CONSTANT VARCHAR2(200) := 'OKL_LLA_GEN_INST_NUM_IB';
76: G_GEN_ASSET_NUMBER CONSTANT VARCHAR2(200) := 'OKL_LLA_GEN_ASSET_NUMBER';
77: -------------------------------------------------------------------------------------------------

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

70: G_LOAN_SCS_CODE OKC_K_HEADERS_V.SCS_CODE%TYPE := 'LOAN';
71: -- G_FA_TRY_NAME OKL_TRX_TYPES_V.NAME%TYPE := 'CREATE ASSET LINES';
72: -- G_IB_TRY_NAME OKL_TRX_TYPES_V.NAME%TYPE := 'CREATE_IB_LINES';
73: G_TRY_NAME OKL_TRX_TYPES_TL.NAME%TYPE := 'Internal Asset Creation';
74: G_LANGUAGE OKL_TRX_TYPES_TL.LANGUAGE%TYPE := 'US';
75: G_GEN_INST_NUM_IB CONSTANT VARCHAR2(200) := 'OKL_LLA_GEN_INST_NUM_IB';
76: G_GEN_ASSET_NUMBER CONSTANT VARCHAR2(200) := 'OKL_LLA_GEN_ASSET_NUMBER';
77: -------------------------------------------------------------------------------------------------
78: -- COMPOSITE GLOBAL VARIABLES

Line 1726: FROM OKL_TRX_TYPES_tl

1722: RETURN VARCHAR2 IS
1723: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
1724: CURSOR c_get_try_id(p_try_name OKL_TRX_TYPES_V.NAME%TYPE) IS
1725: SELECT id
1726: FROM OKL_TRX_TYPES_tl
1727: WHERE upper(name) = upper(p_try_name)
1728: AND language = G_LANGUAGE;
1729: BEGIN
1730: IF (p_try_name = OKL_API.G_MISS_CHAR) OR

Line 3101: FROM OKL_TRX_TYPES_tl

3097: get_txl_rec get_txl_csr%ROWTYPE;
3098:
3099: CURSOR try_id_csr(p_try_name OKL_TRX_TYPES_V.NAME%TYPE) IS
3100: SELECT id
3101: FROM OKL_TRX_TYPES_tl
3102: WHERE upper(name) = upper(p_try_name)
3103: AND language = 'US';
3104:
3105: l_try_id NUMBER;