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 847: 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)

843: x_msg_data,
844: '_PVT');
845: END Update_asset_header;
846:
847: 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)
848: RETURN VARCHAR2 IS
849: x_return_status VARCHAR2(3) := OKC_API.G_RET_STS_SUCCESS;
850: CURSOR c_get_try_id(p_try_name OKL_TRX_TYPES_V.NAME%TYPE) IS
851: SELECT id

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

846:
847: 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)
848: RETURN VARCHAR2 IS
849: x_return_status VARCHAR2(3) := OKC_API.G_RET_STS_SUCCESS;
850: CURSOR c_get_try_id(p_try_name OKL_TRX_TYPES_V.NAME%TYPE) IS
851: SELECT id
852: FROM OKL_TRX_TYPES_TL
853: WHERE upper(name) = upper(p_try_name)
854: AND language = 'US';

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

1304: where language = 'US'
1305: AND lookup_type = lkp_type
1306: AND meaning = mng;
1307:
1308: CURSOR Transaction_Type_csr (p_transaction_type IN okl_trx_types_v.name%TYPE ) IS
1309: SELECT id
1310: FROM okl_trx_types_tl
1311: WHERE name = p_transaction_type
1312: AND language = 'US';