APPS.OKC_LINE_STYLES_PVT dependencies on OKC_VAL_LINE_OPERATIONS

Line 405: select OKC_API.G_RET_STS_ERROR from okc_val_line_operations where lse_id=p_id;

401: l_excp_error EXCEPTION;
402: CURSOR c1 (p_id IN NUMBER) is
403: select OKC_API.G_RET_STS_ERROR from okc_line_style_sources where lse_id=p_id;
404: CURSOR c2 (p_id IN NUMBER) is
405: select OKC_API.G_RET_STS_ERROR from okc_val_line_operations where lse_id=p_id;
406:
407: BEGIN
408: Open c1(p_id);
409: fetch c1 into l_return_status;

Line 530: select lse_id from okc_val_line_operations where lse_id=p_id;

526:
527: l_return_status VARCHAR2(1):=OKC_API.G_RET_STS_SUCCESS;
528: l_vlov_rec OKC_LINE_STYLES_PUB.vlov_rec_type;
529: CURSOR c1(p_id IN NUMBER) is
530: select lse_id from okc_val_line_operations where lse_id=p_id;
531:
532: BEGIN
533: for l_rec in c1(p_lsev_rec.id) loop
534: l_vlov_rec.lse_id:=l_rec.lse_id;