76: -- Evaluate rule
77: --
78: -- Step 2.
79: --
80: l_outputs := benutils.formula
81: (p_formula_id => p_rule_id,
82: p_effective_date => p_effective_date,
83: p_assignment_id => p_assignment_id,
84: p_business_group_id => p_business_group_id,
1480: is
1481: --
1482: l_proc varchar2(80) := g_package||'check_electable_choice_popl';
1483: --
1484: l_ctu_cm_typ_usg_id_va benutils.g_number_table := benutils.g_number_table();
1485: l_ctu_cm_usg_rl_va benutils.g_number_table := benutils.g_number_table();
1486: l_ctu_pl_id_va benutils.g_number_table := benutils.g_number_table();
1487: l_ctu_pgm_id_va benutils.g_number_table := benutils.g_number_table();
1488: l_ctu_pl_typ_id_va benutils.g_number_table := benutils.g_number_table();
1481: --
1482: l_proc varchar2(80) := g_package||'check_electable_choice_popl';
1483: --
1484: l_ctu_cm_typ_usg_id_va benutils.g_number_table := benutils.g_number_table();
1485: l_ctu_cm_usg_rl_va benutils.g_number_table := benutils.g_number_table();
1486: l_ctu_pl_id_va benutils.g_number_table := benutils.g_number_table();
1487: l_ctu_pgm_id_va benutils.g_number_table := benutils.g_number_table();
1488: l_ctu_pl_typ_id_va benutils.g_number_table := benutils.g_number_table();
1489: --
1482: l_proc varchar2(80) := g_package||'check_electable_choice_popl';
1483: --
1484: l_ctu_cm_typ_usg_id_va benutils.g_number_table := benutils.g_number_table();
1485: l_ctu_cm_usg_rl_va benutils.g_number_table := benutils.g_number_table();
1486: l_ctu_pl_id_va benutils.g_number_table := benutils.g_number_table();
1487: l_ctu_pgm_id_va benutils.g_number_table := benutils.g_number_table();
1488: l_ctu_pl_typ_id_va benutils.g_number_table := benutils.g_number_table();
1489: --
1490: l_effective_date date;
1483: --
1484: l_ctu_cm_typ_usg_id_va benutils.g_number_table := benutils.g_number_table();
1485: l_ctu_cm_usg_rl_va benutils.g_number_table := benutils.g_number_table();
1486: l_ctu_pl_id_va benutils.g_number_table := benutils.g_number_table();
1487: l_ctu_pgm_id_va benutils.g_number_table := benutils.g_number_table();
1488: l_ctu_pl_typ_id_va benutils.g_number_table := benutils.g_number_table();
1489: --
1490: l_effective_date date;
1491: -- bug 5465081 : re-worked the c1 sql for performance
1484: l_ctu_cm_typ_usg_id_va benutils.g_number_table := benutils.g_number_table();
1485: l_ctu_cm_usg_rl_va benutils.g_number_table := benutils.g_number_table();
1486: l_ctu_pl_id_va benutils.g_number_table := benutils.g_number_table();
1487: l_ctu_pgm_id_va benutils.g_number_table := benutils.g_number_table();
1488: l_ctu_pl_typ_id_va benutils.g_number_table := benutils.g_number_table();
1489: --
1490: l_effective_date date;
1491: -- bug 5465081 : re-worked the c1 sql for performance
1492: CURSOR c1 (
4577: --
4578: fnd_message.set_name('BEN','BEN_92089_CREATED_PER_COMM');
4579: fnd_message.set_token('COMMUNICATION',l_triggers.name);
4580: if fnd_global.conc_request_id <> -1 then
4581: benutils.write(fnd_message.get);
4582: benutils.write(p_rec => g_commu_rec);
4583: g_comm_generated := true;
4584: end if;
4585: --
4578: fnd_message.set_name('BEN','BEN_92089_CREATED_PER_COMM');
4579: fnd_message.set_token('COMMUNICATION',l_triggers.name);
4580: if fnd_global.conc_request_id <> -1 then
4581: benutils.write(fnd_message.get);
4582: benutils.write(p_rec => g_commu_rec);
4583: g_comm_generated := true;
4584: end if;
4585: --
4586: end if;