eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_US_GARN_GEN dependencies on HR_TEMPLATE_EXISTENCE

Line 575: already_exists := hr_template_existence.ele_exists(

571: v_mult_entries_allowed := 'N';
572:
573: END IF;
574:
575: already_exists := hr_template_existence.ele_exists(
576: p_ele_name => p_ele_name,
577: p_bg_id => p_bg_id,
578: p_eff_date => p_ele_eff_start_date);
579:

Line 879: already_exists := hr_template_existence.ele_ff_exists(

875: -- ie. before putting in new ff text.
876:
877: hr_utility.set_location('hr_us_garn_gen.ins_formula',20);
878:
879: already_exists := hr_template_existence.ele_ff_exists(
880: p_ele_name => p_ff_ele_name,
881: p_bg_id => p_ff_bg_id,
882: p_ff_name => v_orig_ele_formula_name,
883: p_ff_text => v_orig_ele_formula_text,

Line 2326: already_exists := hr_template_existence.bal_exists(

2322: -- Check for existence before creating baltype.
2323: -- If already exists, set dedn_assoc_bal_id(i) appropriately for
2324: -- future reference.
2325:
2326: already_exists := hr_template_existence.bal_exists(
2327: p_bg_id => p_bg_id,
2328: p_bal_name => garn_assoc_bal_names(i),
2329: p_eff_date => g_eff_start_date);
2330:

Line 2512: already_exists := hr_template_existence.spr_exists (

2508: -- on spousal and alimony...change the spr_exists fn to not use ff id...return ff of
2509: -- existing spr...then compare with v_calc_formula_id, if not the same - then update
2510: -- existing spr, if same, do nothing...if no spr exists, proceed as normal and create spr...
2511:
2512: already_exists := hr_template_existence.spr_exists (
2513: p_ele_id => v_ele_type_id,
2514: p_ff_id => v_spr_formula_id,
2515: p_bg_id => p_bg_id,
2516: p_val_date => g_eff_start_date);

Line 2566: already_exists := hr_template_existence.iv_name_exists(

2562: --
2563: hr_utility.trace('Base ivs = '||to_char(l_num_base_ivs));
2564: FOR k in 1..l_num_base_ivs LOOP
2565: hr_utility.trace('Base iv # = '||to_char(k));
2566: already_exists := hr_template_existence.iv_name_exists(
2567: p_ele_id => garn_ele_ids(1),
2568: p_bg_id => p_bg_id,
2569: p_iv_name => garn_base_iv_names(k),
2570: p_eff_date => g_eff_start_date);

Line 2736: already_exists := hr_template_existence.iv_name_exists(

2732: --
2733: hr_utility.trace('Calc ivs = '||to_char(l_num_calc_ivs));
2734: FOR c in 1..l_num_calc_ivs LOOP
2735: hr_utility.trace('Calc iv # = '||to_char(c));
2736: already_exists := hr_template_existence.iv_name_exists(
2737: p_ele_id => garn_ele_ids(2),
2738: p_bg_id => p_bg_id,
2739: p_iv_name => garn_calc_iv_names(c),
2740: p_eff_date => g_eff_start_date);

Line 2900: already_exists := hr_template_existence.iv_name_exists(

2896: hr_utility.trace('Verif ivs = '||to_char(l_num_verif_ivs));
2897: FOR v in 1..l_num_verif_ivs LOOP
2898: hr_utility.trace('Verif iv # = '||to_char(v));
2899:
2900: already_exists := hr_template_existence.iv_name_exists(
2901: p_ele_id => garn_ele_ids(3),
2902: p_bg_id => p_bg_id,
2903: p_iv_name => garn_verif_iv_names(v),
2904: p_eff_date => g_eff_start_date);

Line 3063: already_exists := hr_template_existence.iv_name_exists(

3059: --
3060: hr_utility.trace('SIV ivs = '||to_char(l_num_si_ivs));
3061: FOR siv in 1..l_num_si_ivs LOOP
3062: hr_utility.trace('SIV iv # = '||to_char(siv));
3063: already_exists := hr_template_existence.iv_name_exists(
3064: p_ele_id => garn_ele_ids(4),
3065: p_bg_id => p_bg_id,
3066: p_iv_name => garn_si_iv_names(siv),
3067: p_eff_date => g_eff_start_date);

Line 3228: already_exists := hr_template_existence.iv_name_exists(

3224: hr_utility.trace('SFV ivs = '||to_char(l_num_sf_ivs));
3225: FOR sfv in 1..l_num_sf_ivs LOOP
3226: hr_utility.trace('SFV iv # = '||to_char(sfv));
3227:
3228: already_exists := hr_template_existence.iv_name_exists(
3229: p_ele_id => garn_ele_ids(5),
3230: p_bg_id => p_bg_id,
3231: p_iv_name => garn_sf_iv_names(sfv),
3232: p_eff_date => g_eff_start_date);

Line 3391: already_exists := hr_template_existence.iv_name_exists(

3387: --
3388: hr_utility.trace('Fee ivs = '||to_char(l_num_fee_ivs));
3389: FOR lfee in 1..l_num_fee_ivs LOOP
3390: hr_utility.trace('Fees iv # = '||to_char(lfee));
3391: already_exists := hr_template_existence.iv_name_exists(
3392: p_ele_id => garn_ele_ids(6),
3393: p_bg_id => p_bg_id,
3394: p_iv_name => garn_fee_iv_names(lfee),
3395: p_eff_date => g_eff_start_date);

Line 3553: already_exists := hr_template_existence.iv_name_exists(

3549: --
3550: hr_utility.trace('VP ivs = '||to_char(l_num_vp_ivs));
3551: FOR lvp in 1..l_num_vp_ivs LOOP
3552: hr_utility.trace('VP iv # = '||to_char(lvp));
3553: already_exists := hr_template_existence.iv_name_exists(
3554: p_ele_id => garn_ele_ids(7),
3555: p_bg_id => p_bg_id,
3556: p_iv_name => garn_vp_iv_names(lvp),
3557: p_eff_date => g_eff_start_date);

Line 4264: already_exists := hr_template_existence.result_rule_exists(

4260: hr_utility.set_location('Here', 2);
4261: FOR n in 1..l_num_base_resrules LOOP
4262:
4263:
4264: already_exists := hr_template_existence.result_rule_exists(
4265: p_spr_id => garn_statproc_rule_id(1),
4266: p_frr_name => garn_base_frr_name(n),
4267: p_iv_id => garn_base_frr_iv_id(n),
4268: p_bg_id => p_bg_id,

Line 4309: already_exists := hr_template_existence.result_rule_exists(

4305: hr_utility.set_location('Here', 8);
4306: FOR o in 1..l_num_calc_resrules LOOP
4307:
4308: hr_utility.set_location('Here', 9);
4309: already_exists := hr_template_existence.result_rule_exists(
4310: p_spr_id => garn_statproc_rule_id(2),
4311: p_frr_name => garn_calc_frr_name(o),
4312: p_iv_id => garn_calc_frr_iv_id(o),
4313: p_bg_id => p_bg_id,

Line 4356: already_exists := hr_template_existence.result_rule_exists(

4352:
4353: FOR o in 1..l_num_vp_resrules LOOP
4354:
4355: hr_utility.set_location('Here', 16);
4356: already_exists := hr_template_existence.result_rule_exists(
4357: p_spr_id => garn_statproc_rule_id(7),
4358: p_frr_name => garn_vp_frr_name(o),
4359: p_iv_id => garn_vp_frr_iv_id(o),
4360: p_bg_id => p_bg_id,

Line 4402: already_exists := hr_template_existence.result_rule_exists(

4398:
4399: FOR p in 1..l_num_verif_resrules LOOP
4400:
4401: hr_utility.set_location('Here', 22);
4402: already_exists := hr_template_existence.result_rule_exists(
4403: p_spr_id => garn_statproc_rule_id(3),
4404: p_frr_name => garn_verif_frr_name(p),
4405: p_iv_id => garn_verif_frr_iv_id(p),
4406: p_bg_id => p_bg_id,

Line 4607: already_exists := hr_template_existence.bal_feed_exists (

4603: hr_utility.trace('BG Id : '||to_char(p_bg_id));
4604: hr_utility.trace('IV Id : '||to_char(garn_base_feed_iv_id(i)));
4605: hr_utility.trace('Date : '||g_eff_start_date);
4606:
4607: already_exists := hr_template_existence.bal_feed_exists (
4608: p_bal_id => garn_base_feed_bal_id(i),
4609: p_bg_id => p_bg_id,
4610: p_iv_id => garn_base_feed_iv_id(i),
4611: p_eff_date => g_eff_start_date);

Line 4644: already_exists := hr_template_existence.bal_feed_exists (

4640: hr_utility.trace('BG Id : '||to_char(p_bg_id));
4641: hr_utility.trace('IV Id : '||to_char(garn_si_feed_iv_id(sif)));
4642: hr_utility.trace('Date : '||g_eff_start_date);
4643:
4644: already_exists := hr_template_existence.bal_feed_exists (
4645: p_bal_id => garn_si_feed_bal_id(sif),
4646: p_bg_id => p_bg_id,
4647: p_iv_id => garn_si_feed_iv_id(sif),
4648: p_eff_date => g_eff_start_date);

Line 4681: already_exists := hr_template_existence.bal_feed_exists (

4677: hr_utility.trace('BG Id : '||to_char(p_bg_id));
4678: hr_utility.trace('IV Id : '||to_char(garn_sf_feed_iv_id(sf)));
4679: hr_utility.trace('Date : '||g_eff_start_date);
4680:
4681: already_exists := hr_template_existence.bal_feed_exists (
4682: p_bal_id => garn_sf_feed_bal_id(sf),
4683: p_bg_id => p_bg_id,
4684: p_iv_id => garn_sf_feed_iv_id(sf),
4685: p_eff_date => g_eff_start_date);

Line 4717: already_exists := hr_template_existence.bal_feed_exists(

4713: hr_utility.trace('BG Id : '||to_char(p_bg_id));
4714: hr_utility.trace('IV Id : '||to_char(garn_calc_feed_iv_id(scf)));
4715: hr_utility.trace('Date : '||g_eff_start_date);
4716:
4717: already_exists := hr_template_existence.bal_feed_exists(
4718: p_bal_id => garn_calc_feed_bal_id(scf),
4719: p_bg_id => p_bg_id,
4720: p_iv_id => garn_calc_feed_iv_id(scf),
4721: p_eff_date => g_eff_start_date);

Line 4752: already_exists := hr_template_existence.bal_feed_exists (

4748: hr_utility.trace('BG Id : '||to_char(p_bg_id));
4749: hr_utility.trace('IV Id : '||to_char(garn_verif_feed_iv_id(sif)));
4750: hr_utility.trace('Date : '||g_eff_start_date);
4751:
4752: already_exists := hr_template_existence.bal_feed_exists (
4753: p_bal_id => garn_verif_feed_bal_id(i),
4754: p_bg_id => p_bg_id,
4755: p_iv_id => garn_verif_feed_iv_id(i),
4756: p_eff_date => g_eff_start_date);

Line 4787: already_exists := hr_template_existence.bal_feed_exists (

4783: hr_utility.trace('BG Id : '||to_char(p_bg_id));
4784: hr_utility.trace('IV Id : '||to_char(garn_fee_feed_iv_id(nfee)));
4785: hr_utility.trace('Date : '||g_eff_start_date);
4786:
4787: already_exists := hr_template_existence.bal_feed_exists (
4788: p_bal_id => garn_fee_feed_bal_id(nfee),
4789: p_bg_id => p_bg_id,
4790: p_iv_id => garn_fee_feed_iv_id(nfee),
4791: p_eff_date => g_eff_start_date);

Line 4829: already_exists := hr_template_existence.bal_feed_exists (

4825: hr_utility.trace('BG Id : '||to_char(p_bg_id));
4826: hr_utility.trace('IV Id : '||to_char(garn_fee_iv_ids(1)));
4827: hr_utility.trace('Date : '||g_eff_start_date);
4828:
4829: already_exists := hr_template_existence.bal_feed_exists (
4830: p_bal_id => l_involbal_id,
4831: p_bg_id => p_bg_id,
4832: p_iv_id => garn_fee_iv_ids(1),
4833: p_eff_date => g_eff_start_date);

Line 4861: already_exists := hr_template_existence.bal_feed_exists (

4857: hr_utility.trace('BG Id : '||to_char(p_bg_id));
4858: hr_utility.trace('IV Id : '||to_char(garn_payval_id(1)));
4859: hr_utility.trace('Date : '||g_eff_start_date);
4860:
4861: already_exists := hr_template_existence.bal_feed_exists (
4862: p_bal_id => l_involbal_id,
4863: p_bg_id => p_bg_id,
4864: p_iv_id => garn_payval_id(1),
4865: p_eff_date => g_eff_start_date);