[Home] [Help]
1: package body PAY_FR_GENERAL as
2: /* $Header: pyfrgenr.pkb 120.0 2005/05/29 05:02:49 appldev noship $ */
3: --
4: g_package varchar2(30) := 'pay_fr_general';
5:
1: package body PAY_FR_GENERAL as
2: /* $Header: pyfrgenr.pkb 120.0 2005/05/29 05:02:49 appldev noship $ */
3: --
4: g_package varchar2(30) := 'pay_fr_general';
5:
6: g_summary_deductions t_summary_deductions;
7: g_summary_idx number := 0;
8:
402: and (cu.business_group_id is NULL or cu.business_group_id = p_business_group_id);
403:
404:
405: begin
406: hr_utility.set_location('Entered pay_fr_general.get_contribution_usage',10);
407: hr_utility.set_location('Obtaining row, Element='||p_element_name, 11);
408: hr_utility.set_location('. p_process_type='||p_process_type,12);
409: hr_utility.set_location('. p_usage_type='||p_usage_type,13);
410:
465:
466: l_proc varchar2(72) := g_package||'.GET_RATE_VALUE';
467:
468: begin
469: hr_utility.set_location('Entered pay_fr_general.get_rate_type',10);
470: hr_utility.set_location('Obtaining row, Element='||p_element_name, 11);
471: hr_utility.set_location('. p_process_type='||g_process_type,12);
472: hr_utility.set_location('. p_usage_type='||p_usage_type,13);
473: hr_utility.set_location('. p_date_earnd='||p_date_earned,14);
746: ,p_business_group_id => p_business_group_id
747: ,p_tax_unit_id => p_tax_unit_id -- Tax_Unit_id is Establishment_ID
748: ,p_orig_entry_id => p_orig_entry_id );
749:
750: hr_utility.set_location('leaving pay_fr_general.initialize_payroll',50);
751: return 0;
752: end initialize_payroll;
753:
754:
1086: l_new_ytd_p3_band number;
1087: l_ytd_gmp_value number;
1088: l_run_gmp_band number;
1089: begin
1090: hr_utility.set_location('Entered pay_fr_general.get_gmp_band',10);
1091:
1092: hr_utility.set_location('YTD GMP ceiling:'||p_ytd_gmp_ceiling,25);
1093: l_new_ytd_p3_band := p_ytd_p3_band + p_run_p3_band;
1094: hr_utility.set_location('YTD P3 band:'||l_new_ytd_p3_band,30);
1219: is
1220:
1221: begin
1222: --
1223: return pay_fr_general.g_calendar_days_worked;
1224: --
1225: end read_calendar_days_worked;
1226:
1227: ------------------------------------------------------------------------
2147: ------------------------------------------------------------------------
2148: function get_monthly_hours return number is
2149: begin
2150: --
2151: return pay_fr_general.g_monthly_hours;
2152: --
2153: end get_monthly_hours;
2154: --
2155: ------------------------------------------------------------------------
2331: /* Convert the normal working hours into a monthly figure so that
2332: it can be compared with the Monthly salary basis */
2333: --
2334: if l_normal_hours is not null and l_frequency is not null then
2335: l_normal_hours := pay_fr_general.convert_hours(p_effective_date
2336: ,p_business_group_id
2337: ,p_assignment_id
2338: ,l_normal_hours
2339: ,l_frequency
2348: /* Convert the normal working hours into an annual figure so that
2349: it can be compared with the Annual salary basis */
2350: --
2351: if l_normal_hours is not null and l_frequency is not null then
2352: l_normal_hours := pay_fr_general.convert_hours(p_effective_date
2353: ,p_business_group_id
2354: ,p_assignment_id
2355: ,l_normal_hours
2356: ,l_frequency
2403: begin
2404: --
2405: hr_utility.set_location('Entering '||l_proc,10);
2406: --
2407: if p_payroll_action_id <> nvl(pay_fr_general.g_payroll_action_id,-1) then
2408: --
2409: open csr_get_time_period;
2410: fetch csr_get_time_period into p_start_date,p_end_date;
2411: if csr_get_time_period%found then
2408: --
2409: open csr_get_time_period;
2410: fetch csr_get_time_period into p_start_date,p_end_date;
2411: if csr_get_time_period%found then
2412: pay_fr_general.g_payroll_action_id := p_payroll_action_id;
2413: close csr_get_time_period;
2414: return 0;
2415: else
2416: close csr_get_time_period;
2927:
2928: end COUNT_SUMMARY_DEDUCTIONS;
2929:
2930: ------------------------------------------------------------------------
2931: end PAY_FR_GENERAL;