APPS.IEU_WP_PARAM_PROPS_SEED_PKG dependencies on IEU_WP_PARAM_PROPS_TL

Line 25: UPDATE ieu_wp_param_props_tl SET

21: IF (SQL%NOTFOUND) THEN
22: RAISE no_data_found;
23: END IF;
24:
25: UPDATE ieu_wp_param_props_tl SET
26: property_value = p_wp_param_props_rec.property_value_tl,
27: source_lang = USERENV('LANG'),
28: last_updated_by = p_wp_param_props_rec.last_updated_by,
29: last_update_date = p_wp_param_props_rec.last_update_date,

Line 110: UPDATE ieu_wp_param_props_tl SET

106:
107: user_id := fnd_load_util.owner_id(P_OWNER);
108:
109: -- only UPDATE rows that have not been altered by user
110: UPDATE ieu_wp_param_props_tl SET
111: PROPERTY_VALUE = p_PROPERTY_VALUE_TL,
112: source_lang = userenv('LANG'),
113: last_update_date = decode(p_last_update_date, null,sysdate,to_date(p_last_update_date, 'YYYY/MM/DD')),
114: --last_updated_by = decode(p_owner, 'SEED', -1, 0),

Line 127: delete from IEU_WP_PARAM_PROPS_TL

123: procedure DELETE_ROW (
124: X_PARAM_PROPERTY_ID in NUMBER)
125: is
126: begin
127: delete from IEU_WP_PARAM_PROPS_TL
128: where PARAM_PROPERTY_ID = X_PARAM_PROPERTY_ID;
129:
130: if (sql%notfound) then
131: raise no_data_found;

Line 191: INSERT INTO ieu_wp_param_props_tl (

187: from ieu_wp_properties_b
188: where property_id =p_wp_param_props_rec.PROPERTY_ID;
189:
190: if (l_trans_flag = 'Y') then
191: INSERT INTO ieu_wp_param_props_tl (
192: PARAM_PROPERTY_ID,
193: language,
194: created_by,
195: creation_date,

Line 219: FROM ieu_wp_param_props_tl t

215: FROM fnd_languages l
216: WHERE l.installed_flag IN ('I', 'B')
217: AND NOT EXISTS
218: (SELECT NULL
219: FROM ieu_wp_param_props_tl t
220: WHERE t.PARAM_PROPERTY_ID = p_wp_param_props_rec.PARAM_PROPERTY_ID
221: AND t.language = l.language_code);
222: end if ;
223: OPEN c;

Line 237: delete from IEU_WP_PARAM_PROPS_TL T

233:
234: procedure ADD_LANGUAGE
235: is
236: begin
237: delete from IEU_WP_PARAM_PROPS_TL T
238: where not exists
239: (select NULL
240: from IEU_WP_PARAM_PROPS_B B
241: where B.PARAM_PROPERTY_ID = T.PARAM_PROPERTY_ID

Line 244: update IEU_WP_PARAM_PROPS_TL T set (

240: from IEU_WP_PARAM_PROPS_B B
241: where B.PARAM_PROPERTY_ID = T.PARAM_PROPERTY_ID
242: );
243:
244: update IEU_WP_PARAM_PROPS_TL T set (
245: PROPERTY_VALUE
246: ) = (select
247: B.PROPERTY_VALUE
248: from IEU_WP_PARAM_PROPS_TL B

Line 248: from IEU_WP_PARAM_PROPS_TL B

244: update IEU_WP_PARAM_PROPS_TL T set (
245: PROPERTY_VALUE
246: ) = (select
247: B.PROPERTY_VALUE
248: from IEU_WP_PARAM_PROPS_TL B
249: where B.PARAM_PROPERTY_ID = T.PARAM_PROPERTY_ID
250: and B.LANGUAGE = T.SOURCE_LANG)
251: where (
252: T.PARAM_PROPERTY_ID,

Line 257: from IEU_WP_PARAM_PROPS_TL SUBB, IEU_WP_PARAM_PROPS_TL SUBT

253: T.LANGUAGE
254: ) in (select
255: SUBT.PARAM_PROPERTY_ID,
256: SUBT.LANGUAGE
257: from IEU_WP_PARAM_PROPS_TL SUBB, IEU_WP_PARAM_PROPS_TL SUBT
258: where SUBB.PARAM_PROPERTY_ID = SUBT.PARAM_PROPERTY_ID
259: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
260: and (SUBB.PROPERTY_VALUE <> SUBT.PROPERTY_VALUE
261: or (SUBB.PROPERTY_VALUE is null and SUBT.PROPERTY_VALUE is not null)

Line 265: insert into IEU_WP_PARAM_PROPS_TL (

261: or (SUBB.PROPERTY_VALUE is null and SUBT.PROPERTY_VALUE is not null)
262: or (SUBB.PROPERTY_VALUE is not null and SUBT.PROPERTY_VALUE is null)
263: ));
264:
265: insert into IEU_WP_PARAM_PROPS_TL (
266: PARAM_PROPERTY_ID,
267: OBJECT_VERSION_NUMBER,
268: CREATED_BY,
269: CREATION_DATE,

Line 289: from IEU_WP_PARAM_PROPS_TL B, FND_LANGUAGES L

285: B.SECURITY_GROUP_ID,
286: B.PROPERTY_VALUE,
287: L.LANGUAGE_CODE,
288: B.SOURCE_LANG
289: from IEU_WP_PARAM_PROPS_TL B, FND_LANGUAGES L
290: where L.INSTALLED_FLAG in ('I', 'B')
291: and B.LANGUAGE = userenv('LANG')
292: and not exists
293: (select NULL

Line 294: from IEU_WP_PARAM_PROPS_TL T

290: where L.INSTALLED_FLAG in ('I', 'B')
291: and B.LANGUAGE = userenv('LANG')
292: and not exists
293: (select NULL
294: from IEU_WP_PARAM_PROPS_TL T
295: where T.PARAM_PROPERTY_ID = B.PARAM_PROPERTY_ID
296: and T.LANGUAGE = L.LANGUAGE_CODE);
297: end ADD_LANGUAGE;
298: