APPS.PV_GE_NOTIF_RULES_PKG dependencies on PV_GE_NOTIF_RULES_TL

Line 123: INSERT INTO pv_ge_notif_rules_tl(

119: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
120: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
121: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login));
122:
123: INSERT INTO pv_ge_notif_rules_tl(
124: notif_rule_id ,
125: language ,
126: last_update_date ,
127: last_updated_by ,

Line 150: AND NOT EXISTS(SELECT NULL FROM pv_ge_notif_rules_tl t

146: DECODE( p_notif_content , FND_API.G_MISS_CHAR, NULL, p_notif_content),
147: DECODE( p_notif_desc , FND_API.G_MISS_CHAR, NULL, p_notif_desc)
148: FROM fnd_languages l
149: WHERE l.installed_flag IN ('I','B')
150: AND NOT EXISTS(SELECT NULL FROM pv_ge_notif_rules_tl t
151: WHERE t.notif_rule_id = DECODE( px_notif_rule_id, FND_API.G_MISS_NUM, NULL, px_notif_rule_id)
152: AND t.language = l.language_code);
153: END Insert_Row;
154:

Line 219: UPDATE pv_ge_notif_rules_tl

215: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)
216: WHERE notif_rule_id = p_notif_rule_id;
217: --AND object_version_number = p_object_version_number;
218:
219: UPDATE pv_ge_notif_rules_tl
220: set notif_name = DECODE( p_notif_name, null, notif_name, FND_API.g_miss_char, null, p_notif_name),
221: notif_content = DECODE( p_notif_content, null, notif_content, FND_API.g_miss_char, null, p_notif_content),
222: notif_desc = DECODE( p_notif_desc, null, notif_desc, FND_API.g_miss_char, null, p_notif_desc),
223: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),

Line 323: delete from pv_ge_notif_rules_tl T

319:
320: PROCEDURE Add_Language
321: IS
322: BEGIN
323: delete from pv_ge_notif_rules_tl T
324: where not exists
325: (select NULL
326: from pv_ge_notif_rules_b b
327: where b.notif_rule_id = t.notif_rule_id

Line 330: update pv_ge_notif_rules_tl t set (

326: from pv_ge_notif_rules_b b
327: where b.notif_rule_id = t.notif_rule_id
328: );
329:
330: update pv_ge_notif_rules_tl t set (
331: --notif_rule_name
332: --, description
333: notif_name,
334: notif_content,

Line 342: from pv_ge_notif_rules_tl b

338: --, b.description
339: b.notif_name,
340: b.notif_content,
341: b.notif_desc
342: from pv_ge_notif_rules_tl b
343: where b.notif_rule_id = t.notif_rule_id
344: and b.language = t.source_lang)
345: where (
346: t.notif_rule_id,

Line 351: from pv_ge_notif_rules_tl subb, pv_ge_notif_rules_tl subt

347: t.language
348: ) in (select
349: subt.notif_rule_id,
350: subt.language
351: from pv_ge_notif_rules_tl subb, pv_ge_notif_rules_tl subt
352: where subb.notif_rule_id = subt.notif_rule_id
353: and subb.language = subt.source_lang
354: and (subb.notif_name <> subt.notif_name
355: or subb.notif_content <> subt.notif_content

Line 365: insert into pv_ge_notif_rules_tl (

361: --or (subb.description is null and subt.description is not null)
362: --or (subb.description is not null and subt.description is null)
363: ));
364:
365: insert into pv_ge_notif_rules_tl (
366: notif_rule_id,
367: creation_date,
368: created_by,
369: last_update_date,

Line 393: from pv_ge_notif_rules_tl b, fnd_languages l

389: --b.notif_rule_name,
390: --b.description,
391: l.language_code,
392: b.source_lang
393: from pv_ge_notif_rules_tl b, fnd_languages l
394: where l.installed_flag in ('I', 'B')
395: and b.language = userenv('lang')
396: and not exists
397: (select null

Line 398: from pv_ge_notif_rules_tl t

394: where l.installed_flag in ('I', 'B')
395: and b.language = userenv('lang')
396: and not exists
397: (select null
398: from pv_ge_notif_rules_tl t
399: where t.notif_rule_id = b.notif_rule_id
400: and t.language = l.language_code);
401: END ADD_LANGUAGE;
402: