APPS.IEX_STRATEGY_TEMPLATES_PKG dependencies on IEX_STRATEGY_TEMPLATES_TL

Line 9: delete from IEX_STRATEGY_TEMPLATES_TL T

5:
6: procedure ADD_LANGUAGE
7: is
8: begin
9: delete from IEX_STRATEGY_TEMPLATES_TL T
10: where not exists
11: (select NULL
12: from IEX_STRATEGY_TEMPLATES_B B
13: where B.STRATEGY_TEMP_ID = T.STRATEGY_TEMP_ID

Line 16: update IEX_STRATEGY_TEMPLATES_TL T

12: from IEX_STRATEGY_TEMPLATES_B B
13: where B.STRATEGY_TEMP_ID = T.STRATEGY_TEMP_ID
14: );
15:
16: update IEX_STRATEGY_TEMPLATES_TL T
17: set (STRATEGY_NAME) =
18: (select B.STRATEGY_NAME
19: from IEX_STRATEGY_TEMPLATES_TL B
20: where B.STRATEGY_TEMP_ID = T.STRATEGY_TEMP_ID

Line 19: from IEX_STRATEGY_TEMPLATES_TL B

15:
16: update IEX_STRATEGY_TEMPLATES_TL T
17: set (STRATEGY_NAME) =
18: (select B.STRATEGY_NAME
19: from IEX_STRATEGY_TEMPLATES_TL B
20: where B.STRATEGY_TEMP_ID = T.STRATEGY_TEMP_ID
21: and B.LANGUAGE = T.SOURCE_LANG)
22: where (
23: T.STRATEGY_TEMP_ID,T.LANGUAGE

Line 27: from IEX_STRATEGY_TEMPLATES_TL SUBB,

23: T.STRATEGY_TEMP_ID,T.LANGUAGE
24: ) in (select
25: SUBT.STRATEGY_TEMP_ID,
26: SUBT.LANGUAGE
27: from IEX_STRATEGY_TEMPLATES_TL SUBB,
28: IEX_STRATEGY_TEMPLATES_TL SUBT
29: where SUBB.STRATEGY_TEMP_ID = SUBT.STRATEGY_TEMP_ID
30: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
31: and SUBB.STRATEGY_NAME<> SUBT.STRATEGY_NAME

Line 28: IEX_STRATEGY_TEMPLATES_TL SUBT

24: ) in (select
25: SUBT.STRATEGY_TEMP_ID,
26: SUBT.LANGUAGE
27: from IEX_STRATEGY_TEMPLATES_TL SUBB,
28: IEX_STRATEGY_TEMPLATES_TL SUBT
29: where SUBB.STRATEGY_TEMP_ID = SUBT.STRATEGY_TEMP_ID
30: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
31: and SUBB.STRATEGY_NAME<> SUBT.STRATEGY_NAME
32: OR (SUBB.STRATEGY_NAME IS NULL AND SUBT.STRATEGY_NAME IS NOT NULL)

Line 36: insert into IEX_STRATEGY_TEMPLATES_TL (

32: OR (SUBB.STRATEGY_NAME IS NULL AND SUBT.STRATEGY_NAME IS NOT NULL)
33: OR (SUBB.STRATEGY_NAME IS NOT NULL AND SUBT.STRATEGY_NAME IS NULL)
34: );
35:
36: insert into IEX_STRATEGY_TEMPLATES_TL (
37: STRATEGY_TEMP_ID,
38: STRATEGY_NAME,
39: LAST_UPDATE_DATE,
40: LAST_UPDATED_BY,

Line 56: from IEX_STRATEGY_TEMPLATES_TL B, FND_LANGUAGES L

52: B.CREATED_BY,
53: B.LAST_UPDATE_LOGIN,
54: L.LANGUAGE_CODE,
55: B.SOURCE_LANG
56: from IEX_STRATEGY_TEMPLATES_TL B, FND_LANGUAGES L
57: where L.INSTALLED_FLAG in ('I', 'B')
58: and B.LANGUAGE = userenv('LANG')
59: and not exists
60: (select NULL

Line 61: from IEX_STRATEGY_TEMPLATES_TL T

57: where L.INSTALLED_FLAG in ('I', 'B')
58: and B.LANGUAGE = userenv('LANG')
59: and not exists
60: (select NULL
61: from IEX_STRATEGY_TEMPLATES_TL T
62: where T.STRATEGY_TEMP_ID = B.STRATEGY_TEMP_ID
63: and T.LANGUAGE = L.LANGUAGE_CODE);
64:
65: end ADD_LANGUAGE;

Line 76: UPDATE IEX_STRATEGY_TEMPLATES_TL SET

72: X_OWNER in VARCHAR2
73: ) IS
74:
75: begin
76: UPDATE IEX_STRATEGY_TEMPLATES_TL SET
77: STRATEGY_NAME=X_STRATEGY_NAME,
78: last_update_date = sysdate,
79: last_updated_by = decode(X_OWNER, 'SEED', 1, 0),
80: last_update_login = 0,

Line 265: INSERT INTO IEX_STRATEGY_TEMPLATES_tl (

261:
262:
263: IEX_DEBUG_PUB.logmessage('Done inserting... IEX_STRATEGY_TEMPLATES_B');
264:
265: INSERT INTO IEX_STRATEGY_TEMPLATES_tl (
266: CREATED_BY,
267: CREATION_DATE,
268: LAST_UPDATE_DATE,
269: LAST_UPDATED_BY,