APPS.OKC_LINE_STYLES_PVT dependencies on OKC_LINE_STYLE_SOURCES

Line 403: select OKC_API.G_RET_STS_ERROR from okc_line_style_sources where lse_id=p_id;

399: RETURN VARCHAR2 IS
400: l_return_status VARCHAR2(1):=OKC_API.G_RET_STS_SUCCESS;
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

Line 489: select lse_id,jtot_object_code from okc_line_style_sources where lse_id=p_id;

485:
486: l_return_status VARCHAR2(1):=OKC_API.G_RET_STS_SUCCESS;
487: l_lssv_rec OKC_LINE_STYLES_PUB.lssv_rec_type;
488: CURSOR c1(p_id IN NUMBER) is
489: select lse_id,jtot_object_code from okc_line_style_sources where lse_id=p_id;
490:
491: BEGIN
492: for l_rec in c1(p_lsev_rec.id) loop
493: l_lssv_rec.lse_id:=l_rec.lse_id;

Line 850: ---The following procedures cater to handling of OKC_LINE_STYLE_SOURCES

846: p_lsev_rec);
847: END VALID_LINE_STYLES;
848:
849: --------------------------------------------------------------------------
850: ---The following procedures cater to handling of OKC_LINE_STYLE_SOURCES
851: --------------------------------------------------------------------------
852:
853: PROCEDURE CREATE_LINE_STYLE_SOURCES(
854: p_api_version IN NUMBER,