APPS.OKC_TAG_PVT dependencies on OKC_REPORT_TAG_B

Line 325: insert into OKC_REPORT_TAG_B

321: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
322: RAISE OKC_API.G_EXCEPTION_ERROR;
323: END IF;
324:
325: insert into OKC_REPORT_TAG_B
326: (
327: ID
328: ,XSL_ID
329: ,CODE

Line 437: FROM OKC_REPORT_TAG_B

433: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
434:
435: CURSOR lchk_csr (p_tagv_rec IN tagv_rec_type) IS
436: SELECT OBJECT_VERSION_NUMBER
437: FROM OKC_REPORT_TAG_B
438: WHERE ID = p_tagv_rec.id;
439:
440: l_api_version CONSTANT NUMBER := 1;
441: l_api_name CONSTANT VARCHAR2(30) := 'lock_row';

Line 611: UPDATE OKC_REPORT_TAG_B set

607: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
608: RAISE OKC_API.G_EXCEPTION_ERROR;
609: END IF;
610:
611: UPDATE OKC_REPORT_TAG_B set
612: XSL_ID = l_tagv_rec.XSL_ID
613: ,CODE = l_tagv_rec.CODE
614: ,ENABLED_FLAG = l_tagv_rec.ENABLED_FLAG
615: ,OBJECT_VERSION_NUMBER = l_tagv_rec.OBJECT_VERSION_NUMBER

Line 717: from OKC_REPORT_TAG_B

713: RAISE OKC_API.G_EXCEPTION_ERROR;
714: END IF;
715:
716: delete
717: from OKC_REPORT_TAG_B
718: where ID = p_tagv_rec.ID;
719:
720: delete
721: from OKC_REPORT_TAG_TL