APPS.OKC_PRM_PVT dependencies on OKC_REPORT_PRM_B

Line 472: insert into OKC_REPORT_PRM_B

468: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
469: RAISE OKC_API.G_EXCEPTION_ERROR;
470: END IF;
471:
472: insert into OKC_REPORT_PRM_B
473: (
474: ID
475: ,SQL_ID
476: ,SEQUENCE_NUM

Line 590: FROM OKC_REPORT_PRM_B

586: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
587:
588: CURSOR lchk_csr (p_prmv_rec IN prmv_rec_type) IS
589: SELECT OBJECT_VERSION_NUMBER
590: FROM OKC_REPORT_PRM_B
591: WHERE ID = p_prmv_rec.id;
592:
593: l_api_version CONSTANT NUMBER := 1;
594: l_api_name CONSTANT VARCHAR2(30) := 'lock_row';

Line 779: UPDATE OKC_REPORT_PRM_B set

775: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
776: RAISE OKC_API.G_EXCEPTION_ERROR;
777: END IF;
778:
779: UPDATE OKC_REPORT_PRM_B set
780: SQL_ID = l_prmv_rec.SQL_ID
781: ,SEQUENCE_NUM = l_prmv_rec.SEQUENCE_NUM
782: ,CODE = l_prmv_rec.CODE
783: ,TYPE = l_prmv_rec.TYPE

Line 888: from OKC_REPORT_PRM_B

884: RAISE OKC_API.G_EXCEPTION_ERROR;
885: END IF;
886:
887: delete
888: from OKC_REPORT_PRM_B
889: where ID = p_prmv_rec.ID;
890:
891: delete
892: from OKC_REPORT_PRM_TL