DBA Data[Home] [Help]

APPS.PAY_CORE_FF_UDFS dependencies on PAY_CORE_FF_UDFS

Line 1: PACKAGE BODY PAY_CORE_FF_UDFS as

1: PACKAGE BODY PAY_CORE_FF_UDFS as
2: /* $Header: paycoreffudfs.pkb 120.22.12020000.2 2012/07/04 19:18:51 amnaraya ship $ */
3: /*
4: +======================================================================+
5: | Copyright (c) 1994 Oracle Corporation |

Line 10: Name : pay_core_ff_udfs

6: | Redwood Shores, California, USA |
7: | All rights reserved. |
8: +======================================================================+
9:
10: Name : pay_core_ff_udfs
11: Filename : paycoreffudfs.sql
12: Change List
13: --------------- -----------
14: 01-May-2005 sodhingr 115.0 Defines user defined function

Line 124: g_package varchar2(33) := ' pay_core_ff_udfs.'; -- Global package name

120: -- ----------------------------------------------------------------------------
121: -- | Private Global Definitions |
122: -- ----------------------------------------------------------------------------
123: --
124: g_package varchar2(33) := ' pay_core_ff_udfs.'; -- Global package name
125: g_legislation_code VARCHAR2(10);
126: l_normal_hours NUMBER := 0;
127:
128:

Line 794: --hr_utility.trace_on(null,'pay_core_ff_udfs');

790:
791: BEGIN -- Convert Figure
792: --begin_convert_period_type
793:
794: --hr_utility.trace_on(null,'pay_core_ff_udfs');
795:
796: IF p_from_freq IS NULL THEN
797: v_from_freq := 'NOT ENTERED';
798: END IF;

Line 1280: hr_utility.trace('calling PAY_CORE_FF_UDFS.calculate_actual_hours_worked');

1276: END IF; -- Hours in date range via work schedule or std hours.
1277: */
1278:
1279:
1280: hr_utility.trace('calling PAY_CORE_FF_UDFS.calculate_actual_hours_worked');
1281: v_hours_in_range := pay_core_ff_udfs.calculate_actual_hours_worked (
1282: null
1283: ,p_asst_id
1284: ,p_bus_grp_id

Line 1281: v_hours_in_range := pay_core_ff_udfs.calculate_actual_hours_worked (

1277: */
1278:
1279:
1280: hr_utility.trace('calling PAY_CORE_FF_UDFS.calculate_actual_hours_worked');
1281: v_hours_in_range := pay_core_ff_udfs.calculate_actual_hours_worked (
1282: null
1283: ,p_asst_id
1284: ,p_bus_grp_id
1285: ,p_ele_entry_id

Line 2041: v_hrs_per_range := pay_core_ff_udfs.calculate_actual_hours_worked (

2037:
2038: END IF;
2039: */
2040:
2041: v_hrs_per_range := pay_core_ff_udfs.calculate_actual_hours_worked (
2042: null
2043: ,p_asst_id
2044: ,p_bus_grp_id
2045: ,p_ele_entry_id

Line 4068: pay_core_ff_udfs.g_normal_hours := l_duration;

4064:
4065: IF (l_duration > 0) THEN
4066: l_work_schedule_found := true;
4067: hr_utility.trace( 'Got work schedule from ATG,duration : '||l_duration);
4068: pay_core_ff_udfs.g_normal_hours := l_duration;
4069: return l_duration;
4070: END IF;
4071:
4072: IF NOT l_work_schedule_found THEN

Line 4085: pay_core_ff_udfs.g_normal_hours := l_total_hours;

4081:
4082: IF lv_wk_sch_found = 'TRUE' THEN
4083: hr_utility.trace( 'work schedule found from SCL ');
4084: l_work_schedule_found := TRUE;
4085: pay_core_ff_udfs.g_normal_hours := l_total_hours;
4086: return l_total_hours;
4087: END IF;
4088:
4089: EXCEPTION

Line 4112: IF l_asg_frequency IS NOT NULL and pay_core_ff_udfs.g_normal_hours IS NOT NULL THEN

4108:
4109: hr_utility.trace( 'l_asg_frequency '||l_asg_frequency);
4110: hr_utility.trace( 'l_normal_hours '||l_normal_hours);
4111:
4112: IF l_asg_frequency IS NOT NULL and pay_core_ff_udfs.g_normal_hours IS NOT NULL THEN
4113: l_total_hours := standard_hours_worked(l_normal_hours
4114: ,p_period_start_date
4115: ,p_period_end_date
4116: ,l_asg_frequency);

Line 4407: hr_utility.trace('Entered into pay_core_ff_udfs.calc_reduced_reg');

4403: RETURN VARCHAR2 IS
4404: ln_red_regular_earn NUMBER;
4405: ln_red_regular_hrs NUMBER;
4406: BEGIN
4407: hr_utility.trace('Entered into pay_core_ff_udfs.calc_reduced_reg');
4408: hr_utility.trace('ctx_assignment_id := ' || ctx_assignment_id);
4409: hr_utility.trace('ctx_assignment_action_id := ' || ctx_assignment_action_id);
4410: hr_utility.trace('p_period_end_dt := ' || TO_CHAR(p_period_end_dt));
4411: hr_utility.trace('p_prorate_start_dt := ' || p_prorate_start_dt);

Line 4513: END pay_core_ff_udfs ;

4509: END IF;
4510:
4511: END get_asg_status_typ;
4512:
4513: END pay_core_ff_udfs ;