APPS.OKL_CREATE_KLE_PVT dependencies on OKL_TRX_TYPES_V

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

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';
89: G_FORMULA_CAP OKL_FORMULAE_V.NAME%TYPE := 'LINE_CAP_AMNT';

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

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';
89: G_FORMULA_CAP OKL_FORMULAE_V.NAME%TYPE := 'LINE_CAP_AMNT';
90: G_FORMULA_RES OKL_FORMULAE_V.NAME%TYPE := 'LINE_RESIDUAL_VALUE';

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

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';
89: G_FORMULA_CAP OKL_FORMULAE_V.NAME%TYPE := 'LINE_CAP_AMNT';
90: G_FORMULA_RES OKL_FORMULAE_V.NAME%TYPE := 'LINE_RESIDUAL_VALUE';
91: G_ID2 CONSTANT VARCHAR2(200) := '#';

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

1920: END IF;
1921: RETURN(x_return_status);
1922: END get_lse_id;
1923: --------------------------------------------------------------------------------------------------
1924: FUNCTION get_try_id(p_try_name IN OKL_TRX_TYPES_V.NAME%TYPE,
1925: x_try_id OUT NOCOPY OKC_LINE_STYLES_V.ID%TYPE)
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

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

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

Line 1940: p_token1_value => 'OKL_TRX_TYPES_V.NAME');

1936: -- store SQL error message on message stack
1937: OKL_API.set_message(p_app_name => G_APP_NAME,
1938: p_msg_name => G_REQUIRED_VALUE,
1939: p_token1 => G_COL_NAME_TOKEN,
1940: p_token1_value => 'OKL_TRX_TYPES_V.NAME');
1941: -- halt validation as it is a required field
1942: RAISE G_EXCEPTION_STOP_VALIDATION;
1943: END IF;
1944: OPEN c_get_try_id(p_try_name);

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

1946: IF c_get_try_id%NOTFOUND THEN
1947: OKL_API.set_message(p_app_name => G_APP_NAME,
1948: p_msg_name => G_NO_MATCHING_RECORD,
1949: p_token1 => G_COL_NAME_TOKEN,
1950: p_token1_value => 'OKL_TRX_TYPES_V.ID');
1951: RAISE G_EXCEPTION_HALT_VALIDATION;
1952: END IF;
1953: CLOSE c_get_try_id;
1954: RETURN x_return_status;