[Home] [Help]
133: and (element.legislation_code = 'US'
134: or (element.legislation_code is null
135: and exists (
136: select 1
137: from per_business_groups_perf BIZ_GRP
138: where element.business_group_id = biz_grp.business_group_id
139: and biz_grp.legislation_code = 'US')))
140: /* and there is or is not an input value indicating that the entry must be
141: processed separately, depending upon the parameter */
235: and (element.legislation_code = 'US'
236: or (element.legislation_code is null
237: and exists (
238: select 1
239: from per_business_groups_perf BIZ_GRP
240: where element.business_group_id = biz_grp.business_group_id
241: and biz_grp.legislation_code = 'US')))
242: /* and there is or is not an input value indicating that the entry must be
243: processed separately, depending upon the parameter */
975: --
976: procedure chk_eff_date
977: (p_effective_date in pay_payroll_actions.effective_date%TYPE
978: ,p_assignment_id in pay_assignment_actions.assignment_id%TYPE
979: ,p_legislation_code in per_business_groups.legislation_code%TYPE
980: ,p_recal_date_earned in boolean
981: ,p_payroll_id out nocopy pay_payroll_actions.payroll_id%TYPE
982: ,p_time_period_id out nocopy pay_payroll_actions.time_period_id%TYPE
983: ,p_period_name out nocopy per_time_periods.period_name%TYPE
1178: --
1179: procedure chk_date_earned
1180: (p_date_earned in pay_payroll_actions.date_earned%TYPE
1181: ,p_assignment_id in pay_assignment_actions.assignment_id%TYPE
1182: ,p_legislation_code in per_business_groups.legislation_code%TYPE
1183: ,p_effective_date in pay_payroll_actions.effective_date%TYPE
1184: ,p_payroll_id in out nocopy pay_payroll_actions.payroll_id%TYPE
1185: ,p_time_period_id in out nocopy pay_payroll_actions.time_period_id%TYPE
1186: ,p_period_name in out nocopy per_time_periods.period_name%TYPE
1488: --
1489: Procedure chk_legislative_parameters
1490: (p_legislative_parameters pay_payroll_actions.legislative_parameters%TYPE
1491: ,p_action_status varchar2
1492: ,p_legislation_code per_business_groups.legislation_code%TYPE
1493: ) Is
1494: --
1495: v_proc varchar2(72) := g_package||'chk_legislative_parameters';
1496: --
1579: Procedure chk_run_type
1580: ( p_run_type_id in pay_run_types_f.run_type_id%type
1581: ,p_effective_date in pay_payroll_actions.effective_date%TYPE
1582: ,p_business_group_id in pay_payroll_actions.business_group_id%TYPE
1583: ,p_legislation_code in per_business_groups.legislation_code%TYPE
1584: )
1585: --
1586: IS
1587: v_proc varchar2(72) := g_package||'chk_run_type';
1802: ) return varchar2 is
1803: --
1804: cursor cur_leg is
1805: select legislation_code
1806: from per_business_groups_perf
1807: where business_group_id = p_business_group_id;
1808: --
1809: v_legislation_code per_business_groups.legislation_code%TYPE;
1810: v_proc varchar2(72) := g_package||'get_legislation_code';
1805: select legislation_code
1806: from per_business_groups_perf
1807: where business_group_id = p_business_group_id;
1808: --
1809: v_legislation_code per_business_groups.legislation_code%TYPE;
1810: v_proc varchar2(72) := g_package||'get_legislation_code';
1811: --
1812: Begin
1813: hr_utility.set_location('Entering:'|| v_proc, 5);
3149: ) is
3150: --
3151: v_unused_return_b boolean;
3152: v_unused_return_d date;
3153: v_legislation_code per_business_groups.legislation_code%TYPE;
3154: v_unused_return_nam per_time_periods.period_name%TYPE;
3155: v_payroll_id pay_payroll_actions.payroll_id%TYPE;
3156: v_time_period_id pay_payroll_actions.time_period_id%TYPE;
3157: v_proc varchar2(72) := g_package||'insert_validate';
3289: procedure update_validate
3290: (p_rec in g_rec_type
3291: ) is
3292: --
3293: v_legislation_code per_business_groups.legislation_code%TYPE;
3294: v_proc varchar2(72) := g_package||'update_validate';
3295: --
3296: Begin
3297: hr_utility.set_location('Entering:'|| v_proc, 5);
3868: , hr_general.decode_lookup('ACTION_TYPE', 'Q')
3869: from per_assignments_f asg
3870: , pay_payrolls_f pro
3871: , pay_consolidation_sets con
3872: , per_business_groups_perf bus
3873: where /* Assignment's Payroll details */
3874: asg.assignment_id = p_assignment_id
3875: and v_cur_date between asg.effective_start_date
3876: and asg.effective_end_date
3895: --
3896: -- Local variables
3897: --
3898: -- The assignment's business group legislation_code:
3899: v_legislation_code per_business_groups.legislation_code%TYPE;
3900: --
3901: -- The assignment's payroll as of the session effective or trunc(sysdate).
3902: v_payroll_id per_assignments_f.payroll_id%TYPE;
3903: --
4186: v_proc varchar2(72) := g_package||'start_quickpay_process';
4187: v_request_id pay_payroll_actions.request_id%TYPE;
4188: v_action_type pay_payroll_actions.action_type%TYPE;
4189: v_a_action_status pay_assignment_actions.action_status%TYPE;
4190: v_leg_code per_business_groups.legislation_code%TYPE;
4191: v_process_name varchar2(30);
4192: v_first_arg varchar2(30);
4193: v_asactid varchar2(30);
4194: v_asgid varchar2(30);
4363: hr_utility.set_location(v_proc, 6);
4364: --
4365: select pbg.legislation_code
4366: into v_leg_code
4367: from per_business_groups_perf pbg,
4368: pay_payroll_actions ppa
4369: where ppa.payroll_action_id = p_payroll_action_id
4370: and pbg.business_group_id = ppa.business_group_id;
4371: --