DBA Data[Home] [Help]

APPS.PAY_ITERATE dependencies on PAY_ITERATE

Line 1: package body pay_iterate as

1: package body pay_iterate as
2: /* $Header: pyiterat.pkb 120.6.12010000.1 2008/07/27 22:56:35 appldev ship $ */
3: -- TYPES
4: --
5: -- The table types are just simple tables or various types. The records

Line 94: l_high_gross := p_target_value * pay_iterate.get_high_gross_factor(p_bg_id);

90: p_target_value in number default null
91: ) return number is
92: l_high_gross number;
93: begin
94: l_high_gross := p_target_value * pay_iterate.get_high_gross_factor(p_bg_id);
95: --
96: return pay_iterate.initialise (p_entry_id => p_entry_id,
97: p_assignment_action_id => p_assignment_action_id,
98: p_high_value => l_high_gross,

Line 96: return pay_iterate.initialise (p_entry_id => p_entry_id,

92: l_high_gross number;
93: begin
94: l_high_gross := p_target_value * pay_iterate.get_high_gross_factor(p_bg_id);
95: --
96: return pay_iterate.initialise (p_entry_id => p_entry_id,
97: p_assignment_action_id => p_assignment_action_id,
98: p_high_value => l_high_gross,
99: p_low_value => p_target_value,
100: p_target_value => p_target_value

Line 2758: hr_utility.set_location('pay_iterate.up_run_type_org_method',10);

2754: Begin --


2755: --
2756: if p_eof_number = 1 then -- if this is not the last row to be uploaded
2757: --
2758: hr_utility.set_location('pay_iterate.up_run_type_org_method',10);
2759: --
2760: -- get the business group id
2761: --
2762: select business_group_id

Line 2769: hr_utility.set_location('pay_iterate.up_run_type_org_method',20);

2765: , l_lc
2766: from per_business_groups
2767: where UPPER(name) = p_business_group;
2768: --
2769: hr_utility.set_location('pay_iterate.up_run_type_org_method',20);
2770: --
2771: -- Get the run type id
2772: --
2773: select prt.run_type_id

Line 2788: hr_utility.set_location('pay_iterate.up_run_type_org_method',30);

2784: and p_rt_lc is null
2785: and prt.business_group_id is null
2786: and prt.legislation_code is null));
2787: --
2788: hr_utility.set_location('pay_iterate.up_run_type_org_method',30);
2789: --
2790: -- get the org payment method id
2791: --
2792: select popm.org_payment_method_id

Line 2800: hr_utility.set_location('pay_iterate.up_run_type_org_method',40);

2796: and p_effective_start_date between popm.effective_start_date
2797: and popm.effective_end_date
2798: and popm.business_group_id = l_bg_id;
2799: --
2800: hr_utility.set_location('pay_iterate.up_run_type_org_method',40);
2801: --
2802: open c_row_exists;
2803: fetch c_row_exists into l_rom_id, l_ovn, l_esd, l_eed;
2804: --

Line 2834: hr_utility.set_location('pay_iterate.up_run_type_org_method',70);

2830: g_rom_rec.new_esd := l_out_esd;
2831: g_rom_rec.old_eed := p_effective_end_date;
2832: g_rom_rec.new_eed := l_out_eed;
2833: --
2834: hr_utility.set_location('pay_iterate.up_run_type_org_method',70);
2835: --
2836: else
2837: if g_rom_rec.old_eed <> hr_api.g_eot then
2838: end_date_rom;

Line 3263: hr_utility.set_location('Entering: pay_iterate.order_cumulative',5);

3259: l_rt_method pay_run_types_f.run_method%type;
3260: l_meth_order varchar2(2);
3261: --
3262: begin
3263: hr_utility.set_location('Entering: pay_iterate.order_cumulative',5);
3264: if p_business_grp_name is not null then
3265: open get_bg_id(p_business_grp_name);
3266: fetch get_bg_id into l_bg;
3267: close get_bg_id;

Line 3275: hr_utility.set_location('pay_iterate.order_cumulative',10);

3271: --
3272: open csr_child_cumulative(p_legislation_code, l_bg, p_run_type_name);
3273: fetch csr_child_cumulative into l_rt_name, l_rt_method;
3274: if csr_child_cumulative%notfound then
3275: hr_utility.set_location('pay_iterate.order_cumulative',10);
3276: close csr_child_cumulative;
3277: l_meth_order := 'C';
3278: else
3279: hr_utility.set_location('pay_iterate.order_cumulative',15);

Line 3279: hr_utility.set_location('pay_iterate.order_cumulative',15);

3275: hr_utility.set_location('pay_iterate.order_cumulative',10);
3276: close csr_child_cumulative;
3277: l_meth_order := 'C';
3278: else
3279: hr_utility.set_location('pay_iterate.order_cumulative',15);
3280: close csr_child_cumulative;
3281: l_meth_order := 'D';
3282: end if;
3283: --

Line 3294: end pay_iterate;

3290: g_entry_list.sz := 0;
3291: g_asg_id := -1;
3292: g_asg_act_id := -1;
3293: --
3294: end pay_iterate;