APPS.OKL_BLK_AST_UPD_PVT dependencies on OKL_TRX_TYPES_V

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

56: x_msg_data OUT NOCOPY VARCHAR2,
57: p_trxv_rec IN trxv_rec_type,
58: x_trxv_rec OUT NOCOPY trxv_rec_type);
59:
60: FUNCTION get_try_id(p_try_name IN OKL_TRX_TYPES_V.NAME%TYPE,
61: x_try_id OUT NOCOPY OKC_LINE_STYLES_V.ID%TYPE)
62: RETURN VARCHAR2 ;
63:
64: -----------------------------------------------------------------------------

Line 879: FUNCTION get_try_id(p_try_name IN OKL_TRX_TYPES_V.NAME%TYPE,x_try_id OUT NOCOPY OKC_LINE_STYLES_V.ID%TYPE)

875: x_msg_data,
876: '_PVT');
877: END Update_asset_header;
878:
879: FUNCTION get_try_id(p_try_name IN OKL_TRX_TYPES_V.NAME%TYPE,x_try_id OUT NOCOPY OKC_LINE_STYLES_V.ID%TYPE)
880: RETURN VARCHAR2 IS
881: x_return_status VARCHAR2(3) := OKC_API.G_RET_STS_SUCCESS;
882: CURSOR c_get_try_id(p_try_name OKL_TRX_TYPES_V.NAME%TYPE) IS
883: SELECT id

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

878:
879: FUNCTION get_try_id(p_try_name IN OKL_TRX_TYPES_V.NAME%TYPE,x_try_id OUT NOCOPY OKC_LINE_STYLES_V.ID%TYPE)
880: RETURN VARCHAR2 IS
881: x_return_status VARCHAR2(3) := OKC_API.G_RET_STS_SUCCESS;
882: CURSOR c_get_try_id(p_try_name OKL_TRX_TYPES_V.NAME%TYPE) IS
883: SELECT id
884: FROM OKL_TRX_TYPES_TL
885: WHERE upper(name) = upper(p_try_name)
886: AND language = 'US';

Line 1340: CURSOR Transaction_Type_csr (p_transaction_type IN okl_trx_types_v.name%TYPE ) IS

1336: where language = 'US'
1337: AND lookup_type = lkp_type
1338: AND meaning = mng;
1339:
1340: CURSOR Transaction_Type_csr (p_transaction_type IN okl_trx_types_v.name%TYPE ) IS
1341: SELECT id
1342: FROM okl_trx_types_tl
1343: WHERE name = p_transaction_type
1344: AND language = 'US';