APPS.OKC_FOLDERS_PVT dependencies on OKC_FOLDERS_ALL_TL

Line 93: INSERT INTO OKC_FOLDERS_ALL_TL (

89: X_LAST_UPDATED_BY,
90: X_LAST_UPDATE_LOGIN
91: );
92:
93: INSERT INTO OKC_FOLDERS_ALL_TL (
94: FOLDER_NAME,
95: DESCRIPTION,
96: CREATED_BY,
97: CREATION_DATE,

Line 119: FROM OKC_FOLDERS_ALL_TL T

115: FROM FND_LANGUAGES L
116: WHERE L.INSTALLED_FLAG IN ('I', 'B')
117: AND NOT EXISTS
118: (SELECT NULL
119: FROM OKC_FOLDERS_ALL_TL T
120: WHERE T.FOLDER_ID = X_FOLDER_ID
121: AND T.LANGUAGE = L.LANGUAGE_CODE);
122:
123: OPEN c;

Line 186: FROM OKC_FOLDERS_ALL_TL

182: CURSOR c1 IS SELECT
183: FOLDER_NAME,
184: DESCRIPTION,
185: DECODE(LANGUAGE, USERENV('LANG'), 'Y', 'N') BASELANG
186: FROM OKC_FOLDERS_ALL_TL
187: WHERE FOLDER_ID = X_FOLDER_ID
188: AND USERENV('LANG') IN (LANGUAGE, SOURCE_LANG)
189: FOR UPDATE OF FOLDER_ID NOWAIT;
190: BEGIN

Line 314: UPDATE OKC_FOLDERS_ALL_TL SET

310: IF (SQL%NOTFOUND) THEN
311: RAISE NO_DATA_FOUND;
312: END IF;
313:
314: UPDATE OKC_FOLDERS_ALL_TL SET
315: FOLDER_NAME = X_FOLDER_NAME,
316: DESCRIPTION = X_DESCRIPTION,
317: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
318: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 333: DELETE FROM OKC_FOLDERS_ALL_TL

329: PROCEDURE DELETE_ROW (
330: X_FOLDER_ID IN NUMBER
331: ) IS
332: BEGIN
333: DELETE FROM OKC_FOLDERS_ALL_TL
334: WHERE FOLDER_ID = X_FOLDER_ID;
335:
336: IF (SQL%NOTFOUND) THEN
337: RAISE NO_DATA_FOUND;

Line 351: DELETE FROM OKC_FOLDERS_ALL_TL T

347:
348: PROCEDURE ADD_LANGUAGE
349: IS
350: BEGIN
351: DELETE FROM OKC_FOLDERS_ALL_TL T
352: WHERE NOT EXISTS
353: (SELECT NULL
354: FROM OKC_FOLDERS_ALL_B B
355: WHERE B.FOLDER_ID = T.FOLDER_ID

Line 358: UPDATE OKC_FOLDERS_ALL_TL T SET (

354: FROM OKC_FOLDERS_ALL_B B
355: WHERE B.FOLDER_ID = T.FOLDER_ID
356: );
357:
358: UPDATE OKC_FOLDERS_ALL_TL T SET (
359: FOLDER_NAME,
360: DESCRIPTION
361: ) = (SELECT
362: B.FOLDER_NAME,

Line 364: FROM OKC_FOLDERS_ALL_TL B

360: DESCRIPTION
361: ) = (SELECT
362: B.FOLDER_NAME,
363: B.DESCRIPTION
364: FROM OKC_FOLDERS_ALL_TL B
365: WHERE B.FOLDER_ID = T.FOLDER_ID
366: AND B.LANGUAGE = T.SOURCE_LANG)
367: WHERE (
368: T.FOLDER_ID,

Line 373: FROM OKC_FOLDERS_ALL_TL SUBB, OKC_FOLDERS_ALL_TL SUBT

369: T.LANGUAGE
370: ) IN (SELECT
371: SUBT.FOLDER_ID,
372: SUBT.LANGUAGE
373: FROM OKC_FOLDERS_ALL_TL SUBB, OKC_FOLDERS_ALL_TL SUBT
374: WHERE SUBB.FOLDER_ID = SUBT.FOLDER_ID
375: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
376: AND (SUBB.FOLDER_NAME <> SUBT.FOLDER_NAME
377: OR SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 382: INSERT INTO OKC_FOLDERS_ALL_TL (

378: OR (SUBB.DESCRIPTION IS NULL AND SUBT.DESCRIPTION IS NOT NULL)
379: OR (SUBB.DESCRIPTION IS NOT NULL AND SUBT.DESCRIPTION IS NULL)
380: ));
381:
382: INSERT INTO OKC_FOLDERS_ALL_TL (
383: FOLDER_NAME,
384: DESCRIPTION,
385: CREATED_BY,
386: CREATION_DATE,

Line 404: FROM OKC_FOLDERS_ALL_TL B, FND_LANGUAGES L

400: B.LAST_UPDATE_LOGIN,
401: B.FOLDER_ID,
402: L.LANGUAGE_CODE,
403: B.SOURCE_LANG
404: FROM OKC_FOLDERS_ALL_TL B, FND_LANGUAGES L
405: WHERE L.INSTALLED_FLAG IN ('I', 'B')
406: AND B.LANGUAGE = USERENV('LANG')
407: AND NOT EXISTS
408: (SELECT NULL

Line 409: FROM OKC_FOLDERS_ALL_TL T

405: WHERE L.INSTALLED_FLAG IN ('I', 'B')
406: AND B.LANGUAGE = USERENV('LANG')
407: AND NOT EXISTS
408: (SELECT NULL
409: FROM OKC_FOLDERS_ALL_TL T
410: WHERE T.FOLDER_ID = B.FOLDER_ID
411: AND T.LANGUAGE = L.LANGUAGE_CODE);
412: END ADD_LANGUAGE;
413: