APPS.OKC_TAG_PVT dependencies on OKC_REPORT_TAG_V

Line 111: from OKC_REPORT_TAG_V

107: p_tagv_rec IN tagv_rec_TYPE) is
108: l_dummy varchar2(1) := '?';
109: cursor c1(n1 number, c2 varchar2, n3 number) is
110: select '!'
111: from OKC_REPORT_TAG_V
112: where xsl_id = n1 and code = c2
113: and id <> n3;
114: begin
115: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 163: from OKC_REPORT_TAG_V

159: p_tagv_rec IN tagv_rec_TYPE) is
160: l_dummy varchar2(1) := '?';
161: cursor c1(n1 number, c2 varchar2, n3 number) is
162: select '!'
163: from OKC_REPORT_TAG_V
164: where xsl_id = n1 and meaning = c2
165: and id <> n3;
166: begin
167: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 428: FROM OKC_REPORT_TAG_V

424: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
425:
426: CURSOR lock_csr (p_tagv_rec IN tagv_rec_type) IS
427: SELECT OBJECT_VERSION_NUMBER
428: FROM OKC_REPORT_TAG_V
429: WHERE ID = p_tagv_rec.id
430: AND OBJECT_VERSION_NUMBER =
431: decode(p_tagv_rec.object_version_number,NULL,OBJECT_VERSION_NUMBER,
432: OKC_API.G_MISS_NUM,OBJECT_VERSION_NUMBER,p_tagv_rec.object_version_number)

Line 583: from OKC_REPORT_TAG_V

579: ,l_tagv_rec.ENABLED_FLAG
580: ,l_tagv_rec.OBJECT_VERSION_NUMBER
581: ,l_tagv_rec.created_by
582: ,l_tagv_rec.creation_date
583: from OKC_REPORT_TAG_V
584: where ID = l_tagv_rec.ID;
585:
586: l_tagv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
587: l_tagv_rec.LAST_UPDATE_DATE := SYSDATE;

Line 685: from okc_report_tag_v TAG, okc_report_xsl_v S

681: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
682:
683: cursor xsl_csr(p NUMBER) is
684: select S.id
685: from okc_report_tag_v TAG, okc_report_xsl_v S
686: where TAG.id = p and S.id = TAG.xsl_id;
687:
688: l_xsl_id NUMBER;
689: