[Home] [Help]
39: are not required for processing of
40: pre-tax deductions.
41:
42: 3rd Oct 1996 hparicha 40.7 398791 - Passing new parameter
43: to hr_template_existence functions.
44: which now uses start date of element
45: in existence comparisons.
46:
47: 4th Nov 1996 hparicha 40.8 Fixes to base input values creation.
560: END IF;
561:
562: hr_utility.set_location('hr_generate_pretax.ins_dedn_ele_type',50);
563:
564: already_exists := hr_template_existence.ele_exists(
565: p_ele_name => p_ele_name,
566: p_bg_id => p_bg_id,
567: p_eff_date => p_ele_eff_start_date);
568:
683: -- ie. before putting in new ff text.
684:
685: hr_utility.set_location('hr_generate_pretax.ins_base_formula',20);
686:
687: already_exists := hr_template_existence.ele_ff_exists(
688: p_ele_name => p_spr_ele_name,
689: p_bg_id => p_ff_bg_id,
690: p_ff_name => v_orig_ele_formula_name,
691: p_ff_text => v_orig_ele_formula_text,
1059: -- ie. before putting in new ff text.
1060:
1061: hr_utility.set_location('hr_generate_pretax.ins_calc_formula',20);
1062:
1063: already_exists := hr_template_existence.ele_ff_exists(
1064: p_ele_name => p_spr_ele_name,
1065: p_bg_id => p_ff_bg_id,
1066: p_ff_name => v_orig_ele_formula_name,
1067: p_ff_text => v_orig_ele_formula_text,
1695: -- hr_utility.trace('spr exists checking...');
1696: -- hr_utility.trace(dedn_ele_ids(1)||' '||v_calc_rule_formula_id);
1697: -- hr_utility.trace(p_bg_id||' '||p_eff_start_date);
1698: -- Calculator status proc rule...
1699: already_exists := hr_template_existence.spr_exists (
1700: p_ele_id => dedn_ele_ids(1),
1701: p_ff_id => v_spr_formula_id,
1702: p_bg_id => p_bg_id,
1703: p_val_date => p_eff_start_date);
1747: -- hr_utility.trace('spr exists checking...');
1748: -- hr_utility.trace(dedn_ele_ids(2)||' '||v_wh_formula_id);
1749: -- hr_utility.trace(p_bg_id||' '||p_eff_start_date);
1750: -- Check for base status proc rule existence...
1751: already_exists := hr_template_existence.spr_exists (
1752: p_ele_id => dedn_ele_ids(2),
1753: p_ff_id => v_spr_formula_id,
1754: p_bg_id => p_bg_id,
1755: p_val_date => p_eff_start_date);
2125: IF dedn_base_iv_names(h) IS NOT NULL THEN
2126:
2127: hr_utility.set_location('hr_upgrade_earnings.ins_uie_formula_processing',300);
2128:
2129: already_exists := hr_template_existence.iv_name_exists(
2130: p_ele_id => dedn_ele_ids(1),
2131: p_bg_id => p_bg_id,
2132: p_iv_name => dedn_base_iv_names(h),
2133: p_eff_date => g_eff_start_date);
2320: IF dedn_wh_iv_names(k) IS NOT NULL THEN
2321:
2322: hr_utility.set_location('hr_upgrade_earnings.ins_uie_formula_processing',300);
2323:
2324: already_exists := hr_template_existence.iv_name_exists(
2325: p_ele_id => dedn_ele_ids(2),
2326: p_bg_id => p_bg_id,
2327: p_iv_name => dedn_wh_iv_names(k),
2328: p_eff_date => g_eff_start_date);
2545: FOR siv in 1..l_num_si_ivs LOOP
2546:
2547: hr_utility.set_location('hr_upgrade_earnings.ins_uie_input_values ',120);
2548:
2549: already_exists := hr_template_existence.iv_name_exists(
2550: p_ele_id => dedn_ele_ids(3),
2551: p_bg_id => p_bg_id,
2552: p_iv_name => dedn_si_iv_names(siv),
2553: p_eff_date => g_eff_start_date);
2781: IF dedn_sf_iv_names(sfv) IS NOT NULL THEN
2782:
2783: hr_utility.set_location('hr_upgrade_earnings.ins_uie_input_values ',190);
2784:
2785: already_exists := hr_template_existence.iv_name_exists(
2786: p_ele_id => dedn_ele_ids(4),
2787: p_bg_id => p_bg_id,
2788: p_iv_name => dedn_sf_iv_names(sfv),
2789: p_eff_date => g_eff_start_date);
2999: IF dedn_er_iv_names(m)IS NOT NULL THEN
3000:
3001: hr_utility.set_location('hr_upgrade_earnings.ins_uie_formula_processing',400);
3002:
3003: already_exists := hr_template_existence.iv_name_exists(
3004: p_ele_id => dedn_ele_ids(5),
3005: p_bg_id => p_bg_id,
3006: p_iv_name => dedn_er_iv_names(m),
3007: p_eff_date => g_eff_start_date);
3464: IF dedn_wh_frr_name(n) IS NOT NULL THEN
3465:
3466: hr_utility.set_location('hr_upgrade_earnings.ins_uie_input_values ',270);
3467:
3468: already_exists := hr_template_existence.result_rule_exists(
3469: p_spr_id => dedn_statproc_rule_id(2),
3470: p_frr_name => dedn_wh_frr_name(n),
3471: p_iv_id => dedn_wh_frr_iv_id(n),
3472: p_bg_id => p_bg_id,
3513: IF dedn_calc_frr_name(n) IS NOT NULL THEN
3514:
3515: hr_utility.set_location('hr_upgrade_earnings.ins_uie_input_values ',270);
3516:
3517: already_exists := hr_template_existence.result_rule_exists(
3518: p_spr_id => dedn_statproc_rule_id(1),
3519: p_frr_name => dedn_calc_frr_name(n),
3520: p_iv_id => dedn_calc_frr_iv_id(n),
3521: p_bg_id => p_bg_id,
3593:
3594: fetch get_pretax_bals into l_bal_id;
3595: exit when get_pretax_bals%notfound;
3596:
3597: already_exists := hr_template_existence.bal_feed_exists (
3598: p_bal_id => l_bal_id,
3599: p_bg_id => p_busgrp_id,
3600: p_iv_id => p_inpval_id,
3601: p_eff_date => p_eff_start_date);
3660:
3661: fetch get_pretax_catbals into l_bal_id;
3662: exit when get_pretax_catbals%notfound;
3663:
3664: already_exists := hr_template_existence.bal_feed_exists (
3665: p_bal_id => l_bal_id,
3666: p_bg_id => p_busgrp_id,
3667: p_iv_id => p_inpval_id,
3668: p_eff_date => p_eff_start_date);
3782:
3783: -- Check for existence before creating baltype.
3784: -- If already exists, set dedn_assoc_bal_id(i) appropriately for future reference.
3785:
3786: already_exists := hr_template_existence.bal_exists(
3787: p_bg_id => p_bg_id,
3788: p_bal_name => dedn_assoc_bal_names(i),
3789: p_eff_date => g_eff_start_date);
3790:
4182: v_bal_rpt_name := dedn_ele_repnames(5);
4183:
4184: -- Check for existence before creating...
4185:
4186: already_exists := hr_template_existence.bal_exists(
4187: p_bg_id => p_bg_id,
4188: p_bal_name => v_balance_name,
4189: p_eff_date => g_eff_start_date);
4190:
4218: --
4219: -- Primary balance feeds
4220: --
4221:
4222: already_exists := hr_template_existence.bal_feed_exists (
4223: p_bal_id => v_er_charge_baltype_id,
4224: p_bg_id => p_bg_id,
4225: p_iv_id => dedn_payval_id(5),
4226: p_eff_date => g_eff_start_date );
4399: p_eff_start_date => g_eff_start_date);
4400:
4401: for y in 1..l_num_base_feeds LOOP
4402:
4403: already_exists := hr_template_existence.bal_feed_exists (
4404: p_bal_id => dedn_base_feed_bal_id(y),
4405: p_bg_id => p_bg_id,
4406: p_iv_id => dedn_base_feed_iv_id(y),
4407: p_eff_date => g_eff_start_date );
4430:
4431:
4432: FOR sif in 1..l_num_si_feeds LOOP
4433:
4434: already_exists := hr_template_existence.bal_feed_exists (
4435: p_bal_id => dedn_si_feed_bal_id(sif),
4436: p_bg_id => p_bg_id,
4437: p_iv_id => dedn_si_feed_iv_id(sif),
4438: p_eff_date => g_eff_start_date);
4459:
4460:
4461: FOR sf in 1..l_num_sf_feeds LOOP
4462:
4463: already_exists := hr_template_existence.bal_feed_exists (
4464: p_bal_id => dedn_sf_feed_bal_id(sf),
4465: p_bg_id => p_bg_id,
4466: p_iv_id => dedn_sf_feed_iv_id(sf),
4467: p_eff_date => g_eff_start_date);