APPS.OKC_PRM_PVT dependencies on OKC_REPORT_PRM_V

Line 213: from OKC_REPORT_PRM_V

209: p_prmv_rec IN prmv_rec_TYPE) is
210: l_dummy varchar2(1) := '?';
211: cursor c1(n1 number, n2 number, n3 number) is
212: select '!'
213: from OKC_REPORT_PRM_V
214: where sql_id = n1 and sequence_num = n2
215: and id <> n3;
216: begin
217: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 265: from OKC_REPORT_PRM_V

261: p_prmv_rec IN prmv_rec_TYPE) is
262: l_dummy varchar2(1) := '?';
263: cursor c1(n1 number, c2 varchar2, n3 number) is
264: select '!'
265: from OKC_REPORT_PRM_V
266: where sql_id = n1 and code = c2
267: and id <> n3;
268: begin
269: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 581: FROM OKC_REPORT_PRM_V

577: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
578:
579: CURSOR lock_csr (p_prmv_rec IN prmv_rec_type) IS
580: SELECT OBJECT_VERSION_NUMBER
581: FROM OKC_REPORT_PRM_V
582: WHERE ID = p_prmv_rec.id
583: AND OBJECT_VERSION_NUMBER =
584: decode(p_prmv_rec.object_version_number,NULL,OBJECT_VERSION_NUMBER,
585: OKC_API.G_MISS_NUM,OBJECT_VERSION_NUMBER,p_prmv_rec.object_version_number)

Line 742: from OKC_REPORT_PRM_V

738: ,l_prmv_rec.LOV_QUERY
739: ,l_prmv_rec.OBJECT_VERSION_NUMBER
740: ,l_prmv_rec.created_by
741: ,l_prmv_rec.creation_date
742: from OKC_REPORT_PRM_V
743: where ID = l_prmv_rec.ID;
744:
745: l_prmv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
746: l_prmv_rec.LAST_UPDATE_DATE := SYSDATE;

Line 856: from okc_report_prm_v PRM, okc_report_sql_v S

852: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
853:
854: cursor sql_csr(p NUMBER) is
855: select S.id
856: from okc_report_prm_v PRM, okc_report_sql_v S
857: where PRM.id = p and S.id = PRM.sql_id;
858:
859: l_sql_id NUMBER;
860: