APPS.OKC_TAG_PVT dependencies on OKC_REPORT_TAG_TL

Line 26: INSERT INTO OKC_REPORT_TAG_TL (

22: -- PROCEDURE add_language
23: ---------------------------------------------------------------------------
24: PROCEDURE add_language IS
25: BEGIN
26: INSERT INTO OKC_REPORT_TAG_TL (
27: ID,
28: LANGUAGE,
29: SOURCE_LANG,
30: SFWT_FLAG,

Line 48: FROM OKC_REPORT_TAG_TL B, FND_LANGUAGES L

44: B.CREATION_DATE,
45: B.LAST_UPDATED_BY,
46: B.LAST_UPDATE_DATE,
47: B.LAST_UPDATE_LOGIN
48: FROM OKC_REPORT_TAG_TL B, FND_LANGUAGES L
49: WHERE L.INSTALLED_FLAG IN ('I', 'B')
50: AND B.LANGUAGE = USERENV('LANG')
51: AND NOT EXISTS(
52: SELECT NULL

Line 53: FROM OKC_REPORT_TAG_TL T

49: WHERE L.INSTALLED_FLAG IN ('I', 'B')
50: AND B.LANGUAGE = USERENV('LANG')
51: AND NOT EXISTS(
52: SELECT NULL
53: FROM OKC_REPORT_TAG_TL T
54: WHERE T.ID = B.ID
55: AND T.LANGUAGE = L.LANGUAGE_CODE
56: );
57:

Line 351: INSERT INTO OKC_REPORT_TAG_TL (

347: ,l_tagv_rec.LAST_UPDATE_DATE
348: ,l_tagv_rec.LAST_UPDATE_LOGIN
349: );
350:
351: INSERT INTO OKC_REPORT_TAG_TL (
352: ID,
353: LANGUAGE,
354: SOURCE_LANG,
355: SFWT_FLAG,

Line 621: UPDATE OKC_REPORT_TAG_TL set

617: ,LAST_UPDATE_DATE = l_tagv_rec.LAST_UPDATE_DATE
618: ,LAST_UPDATE_LOGIN = l_tagv_rec.LAST_UPDATE_LOGIN
619: where ID = l_tagv_rec.ID;
620:
621: UPDATE OKC_REPORT_TAG_TL set
622: SOURCE_LANG = USERENV('LANG')
623: ,SFWT_FLAG = decode(LANGUAGE,USERENV('LANG'),'N','Y')
624: ,MEANING = l_tagv_rec.MEANING
625: ,LAST_UPDATED_BY = l_tagv_rec.LAST_UPDATED_BY

Line 721: from OKC_REPORT_TAG_TL

717: from OKC_REPORT_TAG_B
718: where ID = p_tagv_rec.ID;
719:
720: delete
721: from OKC_REPORT_TAG_TL
722: where ID = p_tagv_rec.ID;
723:
724: open xsl_csr(p_tagv_rec.ID);
725: fetch xsl_csr into l_xsl_id;