DBA Data[Home] [Help]

APPS.OKL_COPY_ASSET_PVT dependencies on OKL_TRX_TYPES_V

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

62: G_FEE_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FEE';
63: G_SER_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'SOLD_SERVICE';
64: G_UBB_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'USAGE';
65: G_ID2 CONSTANT VARCHAR2(200) := '#';
66: G_TRY_TYPE OKL_TRX_TYPES_V.TRY_TYPE%TYPE := 'TIE';
67: G_TLS_TYPE OKC_LINE_STYLES_V.LSE_TYPE%TYPE := 'TLS';
68: G_SLS_TYPE OKC_LINE_STYLES_V.LSE_TYPE%TYPE := 'SLS';
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';

Line 71: -- G_FA_TRY_NAME OKL_TRX_TYPES_V.NAME%TYPE := 'CREATE ASSET LINES';

67: G_TLS_TYPE OKC_LINE_STYLES_V.LSE_TYPE%TYPE := 'TLS';
68: G_SLS_TYPE OKC_LINE_STYLES_V.LSE_TYPE%TYPE := 'SLS';
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';

Line 72: -- G_IB_TRY_NAME OKL_TRX_TYPES_V.NAME%TYPE := 'CREATE_IB_LINES';

68: G_SLS_TYPE OKC_LINE_STYLES_V.LSE_TYPE%TYPE := 'SLS';
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';

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

1716: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1717: RETURN(x_return_status);
1718: END get_itiv_rec;
1719: --------------------------------------------------------------------------
1720: FUNCTION get_try_id(p_try_name IN OKL_TRX_TYPES_V.NAME%TYPE,
1721: x_try_id OUT NOCOPY OKC_LINE_STYLES_V.ID%TYPE)
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

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

1720: FUNCTION get_try_id(p_try_name IN OKL_TRX_TYPES_V.NAME%TYPE,
1721: x_try_id OUT NOCOPY OKC_LINE_STYLES_V.ID%TYPE)
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;

Line 3099: CURSOR try_id_csr(p_try_name OKL_TRX_TYPES_V.NAME%TYPE) IS

3095: and fa_cle.dnz_chr_id = p_chr_id;
3096:
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';

Line 3155: p_token1_value => 'OKL_TRX_TYPES_V.ID');

3151: If try_id_csr%NOTFOUND then
3152: OKL_API.set_message(p_app_name => G_APP_NAME,
3153: p_msg_name => G_NO_MATCHING_RECORD,
3154: p_token1 => G_COL_NAME_TOKEN,
3155: p_token1_value => 'OKL_TRX_TYPES_V.ID');
3156: RAISE OKL_API.G_EXCEPTION_ERROR;
3157: End If;
3158: Close try_id_csr;
3159: