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 261: okc_line_styles_v lse

257:
258: CURSOR c_get_ast_instances(p_parent_line_id IN NUMBER) IS
259: SELECT count(*)
260: FROM okc_k_lines_v okcl,
261: okc_line_styles_v lse
262: WHERE okcl.cle_id = p_parent_line_id
263: AND okcl.lse_id = lse.id
264: AND lse.lty_code = 'FREE_FORM2';
265:

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