APPS.IEX_CHECKLIST_ITEMS_PKG dependencies on IEX_CHECKLIST_ITEMS_TL

Line 8: DELETE FROM IEX_CHECKLIST_ITEMS_TL T

4:
5: PROCEDURE ADD_LANGUAGE
6: IS
7: BEGIN
8: DELETE FROM IEX_CHECKLIST_ITEMS_TL T
9: WHERE NOT EXISTS
10: (SELECT NULL
11: FROM IEX_CHECKLIST_ITEMS_B B
12: WHERE B.CHECKLIST_ITEM_ID = T.CHECKLIST_ITEM_ID

Line 15: UPDATE IEX_CHECKLIST_ITEMS_TL T SET

11: FROM IEX_CHECKLIST_ITEMS_B B
12: WHERE B.CHECKLIST_ITEM_ID = T.CHECKLIST_ITEM_ID
13: );
14:
15: UPDATE IEX_CHECKLIST_ITEMS_TL T SET
16: (CHECKLIST_ITEM_TEXT ) =
17: (SELECT
18: B.CHECKLIST_ITEM_TEXT
19: FROM IEX_CHECKLIST_ITEMS_TL B

Line 19: FROM IEX_CHECKLIST_ITEMS_TL B

15: UPDATE IEX_CHECKLIST_ITEMS_TL T SET
16: (CHECKLIST_ITEM_TEXT ) =
17: (SELECT
18: B.CHECKLIST_ITEM_TEXT
19: FROM IEX_CHECKLIST_ITEMS_TL B
20: WHERE B.CHECKLIST_ITEM_ID = T.CHECKLIST_ITEM_ID
21: AND B.LANGUAGE = T.SOURCE_LANG)
22: WHERE (T.CHECKLIST_ITEM_ID,
23: T.LANGUAGE) IN

Line 27: FROM IEX_CHECKLIST_ITEMS_TL SUBB, IEX_CHECKLIST_ITEMS_TL SUBT

23: T.LANGUAGE) IN
24: (SELECT
25: SUBT.CHECKLIST_ITEM_ID,
26: SUBT.LANGUAGE
27: FROM IEX_CHECKLIST_ITEMS_TL SUBB, IEX_CHECKLIST_ITEMS_TL SUBT
28: WHERE SUBB.CHECKLIST_ITEM_ID = SUBT.CHECKLIST_ITEM_ID
29: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
30: AND (SUBB.CHECKLIST_ITEM_TEXT <> SUBT.CHECKLIST_ITEM_TEXT)
31: OR (SUBB.CHECKLIST_ITEM_TEXT IS NULL AND SUBT.CHECKLIST_ITEM_TEXT IS NOT NULL)

Line 35: INSERT INTO IEX_CHECKLIST_ITEMS_TL (

31: OR (SUBB.CHECKLIST_ITEM_TEXT IS NULL AND SUBT.CHECKLIST_ITEM_TEXT IS NOT NULL)
32: OR (SUBB.CHECKLIST_ITEM_TEXT IS NOT NULL AND SUBT.CHECKLIST_ITEM_TEXT IS NULL)
33: );
34:
35: INSERT INTO IEX_CHECKLIST_ITEMS_TL (
36: CHECKLIST_ITEM_ID,
37: LAST_UPDATE_DATE,
38: LAST_UPDATED_BY,
39: LAST_UPDATE_LOGIN,

Line 57: FROM IEX_CHECKLIST_ITEMS_TL B, FND_LANGUAGES L

53: B.CHECKLIST_ITEM_TEXT,
54: B.DESCRIPTION,
55: L.LANGUAGE_CODE,
56: B.SOURCE_LANG
57: FROM IEX_CHECKLIST_ITEMS_TL B, FND_LANGUAGES L
58: WHERE L.INSTALLED_FLAG IN ('I', 'B')
59: AND B.LANGUAGE = userenv('LANG')
60: AND NOT EXISTS
61: (SELECT NULL

Line 62: FROM IEX_CHECKLIST_ITEMS_TL T

58: WHERE L.INSTALLED_FLAG IN ('I', 'B')
59: AND B.LANGUAGE = userenv('LANG')
60: AND NOT EXISTS
61: (SELECT NULL
62: FROM IEX_CHECKLIST_ITEMS_TL T
63: WHERE T.CHECKLIST_ITEM_ID = B.CHECKLIST_ITEM_ID
64: AND T.LANGUAGE = L.LANGUAGE_CODE);
65: END ADD_LANGUAGE;
66: