DBA Data[Home] [Help]

APPS.PV_GE_NOTIF_RULES_PVT dependencies on PV_GE_NOTIF_RULES_TL

Line 359: FROM pv_ge_notif_rules_b b, pv_ge_notif_rules_tl tl

355: order by notif_rule_id;
356:
357: CURSOR c_get_notif_rules_tl_rec (cv_program_id IN NUMBER) IS
358: SELECT tl.notif_rule_id, notif_name, notif_content, notif_desc, language, source_lang
359: FROM pv_ge_notif_rules_b b, pv_ge_notif_rules_tl tl
360: WHERE arc_notif_for_entity_code = 'PRGM'
361: and b.notif_rule_id = tl.notif_rule_id
362: AND notif_for_entity_id = cv_program_id
363: order by tl.notif_rule_id;

Line 498: update pv_ge_notif_rules_tl

494:
495: end loop;
496:
497: forall i in 1..old_notif_rule_id_array.count
498: update pv_ge_notif_rules_tl
499: set notif_name = notif_name_array(i),
500: notif_content = notif_content_array(i),
501: notif_desc = notif_desc_array(i),
502: source_lang = source_lang_array(i),