APPS.IEX_STRY_TEMP_WORK_ITEMS_PKG dependencies on IEX_STRY_TEMP_WORK_ITEMS_TL

Line 8: delete from IEX_STRY_TEMP_WORK_ITEMS_TL T

4:
5: procedure ADD_LANGUAGE
6: is
7: begin
8: delete from IEX_STRY_TEMP_WORK_ITEMS_TL T
9: where not exists
10: (select NULL
11: from IEX_STRY_TEMP_WORK_ITEMS_B B
12: where B.WORK_ITEM_TEMP_ID = T.WORK_ITEM_TEMP_ID

Line 15: update IEX_STRY_TEMP_WORK_ITEMS_TL T

11: from IEX_STRY_TEMP_WORK_ITEMS_B B
12: where B.WORK_ITEM_TEMP_ID = T.WORK_ITEM_TEMP_ID
13: );
14:
15: update IEX_STRY_TEMP_WORK_ITEMS_TL T
16: set (NAME) =
17: (select B.NAME
18: from IEX_STRY_TEMP_WORK_ITEMS_TL B
19: where B.WORK_ITEM_TEMP_ID = T.WORK_ITEM_TEMP_ID

Line 18: from IEX_STRY_TEMP_WORK_ITEMS_TL B

14:
15: update IEX_STRY_TEMP_WORK_ITEMS_TL T
16: set (NAME) =
17: (select B.NAME
18: from IEX_STRY_TEMP_WORK_ITEMS_TL B
19: where B.WORK_ITEM_TEMP_ID = T.WORK_ITEM_TEMP_ID
20: and B.LANGUAGE = T.SOURCE_LANG)
21: where (
22: T.WORK_ITEM_TEMP_ID,T.LANGUAGE

Line 26: from IEX_STRY_TEMP_WORK_ITEMS_TL SUBB,

22: T.WORK_ITEM_TEMP_ID,T.LANGUAGE
23: ) in (select
24: SUBT.WORK_ITEM_TEMP_ID,
25: SUBT.LANGUAGE
26: from IEX_STRY_TEMP_WORK_ITEMS_TL SUBB,
27: IEX_STRY_TEMP_WORK_ITEMS_TL SUBT
28: where SUBB.WORK_ITEM_TEMP_ID = SUBT.WORK_ITEM_TEMP_ID
29: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
30: and SUBB.NAME<> SUBT.NAME

Line 27: IEX_STRY_TEMP_WORK_ITEMS_TL SUBT

23: ) in (select
24: SUBT.WORK_ITEM_TEMP_ID,
25: SUBT.LANGUAGE
26: from IEX_STRY_TEMP_WORK_ITEMS_TL SUBB,
27: IEX_STRY_TEMP_WORK_ITEMS_TL SUBT
28: where SUBB.WORK_ITEM_TEMP_ID = SUBT.WORK_ITEM_TEMP_ID
29: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
30: and SUBB.NAME<> SUBT.NAME
31: OR (SUBB.NAME IS NULL AND SUBT.NAME IS NOT NULL)

Line 35: insert into IEX_STRY_TEMP_WORK_ITEMS_TL (

31: OR (SUBB.NAME IS NULL AND SUBT.NAME IS NOT NULL)
32: OR (SUBB.NAME IS NOT NULL AND SUBT.NAME IS NULL)
33: );
34:
35: insert into IEX_STRY_TEMP_WORK_ITEMS_TL (
36: WORK_ITEM_TEMP_ID,
37: NAME,
38: DESCRIPTION,
39: LAST_UPDATE_DATE,

Line 57: from IEX_STRY_TEMP_WORK_ITEMS_TL B, FND_LANGUAGES L

53: B.CREATED_BY,
54: B.LAST_UPDATE_LOGIN,
55: L.LANGUAGE_CODE,
56: B.SOURCE_LANG
57: from IEX_STRY_TEMP_WORK_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_STRY_TEMP_WORK_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_STRY_TEMP_WORK_ITEMS_TL T
63: where T.WORK_ITEM_TEMP_ID = B.WORK_ITEM_TEMP_ID
64: and T.LANGUAGE = L.LANGUAGE_CODE);
65:
66: end ADD_LANGUAGE;

Line 77: UPDATE IEX_STRY_TEMP_WORK_ITEMS_TL SET

73: X_OWNER in VARCHAR2
74: ) IS
75:
76: begin
77: UPDATE IEX_STRY_TEMP_WORK_ITEMS_TL SET
78: NAME=X_NAME,
79: last_update_date = sysdate,
80: last_updated_by = decode(X_OWNER, 'SEED', 1, 0),
81: last_update_login = 0,