APPS.AMS_IBA_PS_STRATS_B_PKG dependencies on AMS_IBA_PS_STRATS_TL

Line 85: INSERT INTO AMS_IBA_PS_STRATS_TL (

81: DECODE( p_content_type, FND_API.g_miss_char, NULL, p_content_type),
82: DECODE( p_strategy_ref_code, FND_API.g_miss_char, NULL, p_strategy_ref_code),
83: DECODE( p_selector_class, FND_API.g_miss_char, NULL, p_selector_class));
84:
85: INSERT INTO AMS_IBA_PS_STRATS_TL (
86: created_by,
87: creation_date,
88: last_updated_by,
89: last_update_date,

Line 113: FROM ams_iba_ps_strats_tl t

109: FROM fnd_languages l
110: WHERE l.installed_flag IN ('I', 'B')
111: AND NOT EXISTS
112: (SELECT null
113: FROM ams_iba_ps_strats_tl t
114: WHERE t.strategy_id = DECODE( px_strategy_id, FND_API.g_miss_num, NULL, px_strategy_id)
115: AND t.language = l.language_code);
116:
117: END Insert_Row;

Line 174: UPDATE ams_iba_ps_strats_tl SET

170: IF (SQL%NOTFOUND) THEN
171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
172: END IF;
173:
174: UPDATE ams_iba_ps_strats_tl SET
175: strategy_name = decode( p_strategy_NAME, FND_API.G_MISS_CHAR, strategy_NAME, p_strategy_NAME),
176: strategy_description = decode( p_strategy_DESCRIPTION, FND_API.G_MISS_CHAR, STRATEGY_DESCRIPTION, p_strategy_DESCRIPTION),
177: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
178: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),

Line 216: DELETE FROM AMS_IBA_PS_STRATS_TL

212: If (SQL%NOTFOUND) then
213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
214: End If;
215:
216: DELETE FROM AMS_IBA_PS_STRATS_TL
217: WHERE STRATEGY_ID = p_STRATEGY_ID;
218: If (SQL%NOTFOUND) then
219: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
220: End If;

Line 227: delete from AMS_IBA_PS_STRATS_TL T

223:
224: procedure ADD_LANGUAGE
225: is
226: begin
227: delete from AMS_IBA_PS_STRATS_TL T
228: where not exists
229: (select NULL
230: from AMS_IBA_PS_STRATS_B B
231: where B.STRATEGY_ID = T.STRATEGY_ID

Line 234: update AMS_IBA_PS_STRATS_TL T set (

230: from AMS_IBA_PS_STRATS_B B
231: where B.STRATEGY_ID = T.STRATEGY_ID
232: );
233:
234: update AMS_IBA_PS_STRATS_TL T set (
235: STRATEGY_NAME,
236: STRATEGY_DESCRIPTION
237: ) = (select
238: B.STRATEGY_NAME,

Line 240: from AMS_IBA_PS_STRATS_TL B

236: STRATEGY_DESCRIPTION
237: ) = (select
238: B.STRATEGY_NAME,
239: B.STRATEGY_DESCRIPTION
240: from AMS_IBA_PS_STRATS_TL B
241: where B.STRATEGY_ID = T.STRATEGY_ID
242: and B.LANGUAGE = T.SOURCE_LANG)
243: where (
244: T.STRATEGY_ID,

Line 249: from AMS_IBA_PS_STRATS_TL SUBB, AMS_IBA_PS_STRATS_TL SUBT

245: T.LANGUAGE
246: ) in (select
247: SUBT.STRATEGY_ID,
248: SUBT.LANGUAGE
249: from AMS_IBA_PS_STRATS_TL SUBB, AMS_IBA_PS_STRATS_TL SUBT
250: where SUBB.STRATEGY_ID = SUBT.STRATEGY_ID
251: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
252: and (SUBB.STRATEGY_NAME <> SUBT.STRATEGY_NAME
253: or SUBB.STRATEGY_DESCRIPTION <> SUBT.STRATEGY_DESCRIPTION

Line 258: insert into AMS_IBA_PS_STRATS_TL (

254: or (SUBB.STRATEGY_DESCRIPTION is null and SUBT.STRATEGY_DESCRIPTION is not null)
255: or (SUBB.STRATEGY_DESCRIPTION is not null and SUBT.STRATEGY_DESCRIPTION is null)
256: ));
257:
258: insert into AMS_IBA_PS_STRATS_TL (
259: LAST_UPDATE_DATE,
260: CREATION_DATE,
261: LAST_UPDATED_BY,
262: CREATED_BY,

Line 282: from AMS_IBA_PS_STRATS_TL B, FND_LANGUAGES L

278: B.LAST_UPDATE_LOGIN,
279: B.OBJECT_VERSION_NUMBER,
280: L.LANGUAGE_CODE,
281: B.SOURCE_LANG
282: from AMS_IBA_PS_STRATS_TL B, FND_LANGUAGES L
283: where L.INSTALLED_FLAG in ('I', 'B')
284: and B.LANGUAGE = userenv('LANG')
285: and not exists
286: (select NULL

Line 287: from AMS_IBA_PS_STRATS_TL T

283: where L.INSTALLED_FLAG in ('I', 'B')
284: and B.LANGUAGE = userenv('LANG')
285: and not exists
286: (select NULL
287: from AMS_IBA_PS_STRATS_TL T
288: where T.STRATEGY_ID = B.STRATEGY_ID
289: and T.LANGUAGE = L.LANGUAGE_CODE);
290: end ADD_LANGUAGE;
291:

Line 391: from ams_iba_ps_strats_tl

387: )
388: IS
389: cursor c_last_updated_by is
390: select last_updated_by
391: from ams_iba_ps_strats_tl
392: where strategy_id = X_STRATEGY_ID
393: and USERENV('LANG') = LANGUAGE;
394:
395: l_luby number; --last updated by

Line 404: update ams_iba_ps_strats_tl

400: close c_last_updated_by;
401:
402: if (l_luby IN (0, 1, 2) or NVL(x_custom_mode, 'PRESERVE')='FORCE')
403: then
404: update ams_iba_ps_strats_tl
405: set
406: strategy_name = nvl(x_strategy_name, strategy_name),
407: strategy_description = nvl(x_strategy_description, strategy_description),
408: source_lang = userenv('LANG'),