APPS.IEU_WP_ACT_PARAM_SETS_SEED_PKG dependencies on IEU_WP_ACT_PARAM_SETS_TL

Line 21: UPDATE ieu_WP_ACT_PARAM_SETS_tl SET

17: IF (SQL%NOTFOUND) THEN
18: RAISE no_data_found;
19: END IF;
20:
21: UPDATE ieu_WP_ACT_PARAM_SETS_tl SET
22: ACTION_PARAM_SET_LABEL = p_WP_ACT_PARAM_SETS_rec.ACTION_PARAM_SET_LABEL,
23: action_param_set_desc = p_wp_act_param_sets_rec.action_param_set_desc,
24: source_lang = USERENV('LANG'),
25: last_updated_by = p_WP_ACT_PARAM_SETS_rec.last_updated_by,

Line 111: UPDATE ieu_WP_ACT_PARAM_SETS_tl SET

107: -- only UPDATE rows that have not been altered by user
108:
109: user_id := fnd_load_util.owner_id(P_OWNER);
110:
111: UPDATE ieu_WP_ACT_PARAM_SETS_tl SET
112: ACTION_PARAM_SET_LABEL = p_ACTION_PARAM_SET_LABEL,
113: action_param_set_desc = p_action_param_set_desc,
114: source_lang = userenv('LANG'),
115: last_update_date = decode(p_last_update_date,null,sysdate,to_date(p_last_update_date, 'YYYY/MM/DD')),

Line 129: delete from IEU_WP_ACT_PARAM_SETS_TL

125: procedure DELETE_ROW (
126: X_ACTION_PARAM_SET_ID in NUMBER
127: ) is
128: begin
129: delete from IEU_WP_ACT_PARAM_SETS_TL
130: where ACTION_PARAM_SET_ID = X_ACTION_PARAM_SET_ID;
131:
132: if (sql%notfound) then
133: raise no_data_found;

Line 174: INSERT INTO ieu_WP_ACT_PARAM_SETS_tl (

170: FND_GLOBAL.LOGIN_ID,
171: p_WP_ACT_PARAM_SETS_rec.WP_ACTION_DEF_ID,
172: 1,
173: null);
174: INSERT INTO ieu_WP_ACT_PARAM_SETS_tl (
175: ACTION_PARAM_SET_ID,
176: language,
177: created_by,
178: creation_date,

Line 204: FROM ieu_WP_ACT_PARAM_SETS_tl t

200: FROM fnd_languages l
201: WHERE l.installed_flag IN ('I', 'B')
202: AND NOT EXISTS
203: (SELECT NULL
204: FROM ieu_WP_ACT_PARAM_SETS_tl t
205: WHERE t.ACTION_PARAM_SET_ID = p_WP_ACT_PARAM_SETS_rec.ACTION_PARAM_SET_ID
206: AND t.language = l.language_code);
207:
208: OPEN c;

Line 221: delete from IEU_WP_ACT_PARAM_SETS_TL T

217:
218: procedure ADD_LANGUAGE
219: is
220: begin
221: delete from IEU_WP_ACT_PARAM_SETS_TL T
222: where not exists
223: (select NULL
224: from IEU_WP_ACT_PARAM_SETS_B B
225: where B.ACTION_PARAM_SET_ID = T.ACTION_PARAM_SET_ID

Line 228: update IEU_WP_ACT_PARAM_SETS_TL T set (

224: from IEU_WP_ACT_PARAM_SETS_B B
225: where B.ACTION_PARAM_SET_ID = T.ACTION_PARAM_SET_ID
226: );
227:
228: update IEU_WP_ACT_PARAM_SETS_TL T set (
229: ACTION_PARAM_SET_LABEL,
230: ACTION_PARAM_SET_DESC
231: ) = (select
232: B.ACTION_PARAM_SET_LABEL,

Line 234: from IEU_WP_ACT_PARAM_SETS_TL B

230: ACTION_PARAM_SET_DESC
231: ) = (select
232: B.ACTION_PARAM_SET_LABEL,
233: B.ACTION_PARAM_SET_DESC
234: from IEU_WP_ACT_PARAM_SETS_TL B
235: where B.ACTION_PARAM_SET_ID = T.ACTION_PARAM_SET_ID
236: and B.LANGUAGE = T.SOURCE_LANG)
237: where (
238: T.ACTION_PARAM_SET_ID,

Line 243: from IEU_WP_ACT_PARAM_SETS_TL SUBB, IEU_WP_ACT_PARAM_SETS_TL SUBT

239: T.LANGUAGE
240: ) in (select
241: SUBT.ACTION_PARAM_SET_ID,
242: SUBT.LANGUAGE
243: from IEU_WP_ACT_PARAM_SETS_TL SUBB, IEU_WP_ACT_PARAM_SETS_TL SUBT
244: where SUBB.ACTION_PARAM_SET_ID = SUBT.ACTION_PARAM_SET_ID
245: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
246: and (SUBB.ACTION_PARAM_SET_LABEL <> SUBT.ACTION_PARAM_SET_LABEL
247: or SUBB.ACTION_PARAM_SET_DESC <> SUBT.ACTION_PARAM_SET_DESC

Line 252: insert into IEU_WP_ACT_PARAM_SETS_TL (

248: or (SUBB.ACTION_PARAM_SET_DESC is null and SUBT.ACTION_PARAM_SET_DESC is not null)
249: or (SUBB.ACTION_PARAM_SET_DESC is not null and SUBT.ACTION_PARAM_SET_DESC is null)
250: ));
251:
252: insert into IEU_WP_ACT_PARAM_SETS_TL (
253: ACTION_PARAM_SET_ID,
254: OBJECT_VERSION_NUMBER,
255: CREATED_BY,
256: CREATION_DATE,

Line 278: from IEU_WP_ACT_PARAM_SETS_TL B, FND_LANGUAGES L

274: B.ACTION_PARAM_SET_LABEL,
275: B.ACTION_PARAM_SET_DESC,
276: L.LANGUAGE_CODE,
277: B.SOURCE_LANG
278: from IEU_WP_ACT_PARAM_SETS_TL B, FND_LANGUAGES L
279: where L.INSTALLED_FLAG in ('I', 'B')
280: and B.LANGUAGE = userenv('LANG')
281: and not exists
282: (select NULL

Line 283: from IEU_WP_ACT_PARAM_SETS_TL T

279: where L.INSTALLED_FLAG in ('I', 'B')
280: and B.LANGUAGE = userenv('LANG')
281: and not exists
282: (select NULL
283: from IEU_WP_ACT_PARAM_SETS_TL T
284: where T.ACTION_PARAM_SET_ID = B.ACTION_PARAM_SET_ID
285: and T.LANGUAGE = L.LANGUAGE_CODE);
286: end ADD_LANGUAGE;
287: