DBA Data[Home] [Help]

APPS.OKL_BLK_AST_UPD_PVT dependencies on OKC_LINE_STYLES_V

Line 61: x_try_id OUT NOCOPY OKC_LINE_STYLES_V.ID%TYPE)

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: -----------------------------------------------------------------------------
65: --Start of comments

Line 293: okc_line_styles_v lse

289:
290: CURSOR c_get_ast_instances(p_parent_line_id IN NUMBER) IS
291: SELECT count(*)
292: FROM okc_k_lines_v okcl,
293: okc_line_styles_v lse
294: WHERE okcl.cle_id = p_parent_line_id
295: AND okcl.lse_id = lse.id
296: AND lse.lty_code = 'FREE_FORM2';
297:

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