[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: ) is
1185: --
1186: v_payroll_id pay_payroll_actions.payroll_id%TYPE;
1469: --
1470: Procedure chk_legislative_parameters
1471: (p_legislative_parameters pay_payroll_actions.legislative_parameters%TYPE
1472: ,p_action_status varchar2
1473: ,p_legislation_code per_business_groups.legislation_code%TYPE
1474: ) Is
1475: --
1476: v_proc varchar2(72) := g_package||'chk_legislative_parameters';
1477: --
1560: Procedure chk_run_type
1561: ( p_run_type_id in pay_run_types_f.run_type_id%type
1562: ,p_effective_date in pay_payroll_actions.effective_date%TYPE
1563: ,p_business_group_id in pay_payroll_actions.business_group_id%TYPE
1564: ,p_legislation_code in per_business_groups.legislation_code%TYPE
1565: )
1566: --
1567: IS
1568: v_proc varchar2(72) := g_package||'chk_run_type';
1783: ) return varchar2 is
1784: --
1785: cursor cur_leg is
1786: select legislation_code
1787: from per_business_groups_perf
1788: where business_group_id = p_business_group_id;
1789: --
1790: v_legislation_code per_business_groups.legislation_code%TYPE;
1791: v_proc varchar2(72) := g_package||'get_legislation_code';
1786: select legislation_code
1787: from per_business_groups_perf
1788: where business_group_id = p_business_group_id;
1789: --
1790: v_legislation_code per_business_groups.legislation_code%TYPE;
1791: v_proc varchar2(72) := g_package||'get_legislation_code';
1792: --
1793: Begin
1794: hr_utility.set_location('Entering:'|| v_proc, 5);
3130: ) is
3131: --
3132: v_unused_return_b boolean;
3133: v_unused_return_d date;
3134: v_legislation_code per_business_groups.legislation_code%TYPE;
3135: v_unused_return_nam per_time_periods.period_name%TYPE;
3136: v_payroll_id pay_payroll_actions.payroll_id%TYPE;
3137: v_time_period_id pay_payroll_actions.time_period_id%TYPE;
3138: v_proc varchar2(72) := g_package||'insert_validate';
3267: procedure update_validate
3268: (p_rec in g_rec_type
3269: ) is
3270: --
3271: v_legislation_code per_business_groups.legislation_code%TYPE;
3272: v_proc varchar2(72) := g_package||'update_validate';
3273: --
3274: Begin
3275: hr_utility.set_location('Entering:'|| v_proc, 5);
3846: , hr_general.decode_lookup('ACTION_TYPE', 'Q')
3847: from per_assignments_f asg
3848: , pay_payrolls_f pro
3849: , pay_consolidation_sets con
3850: , per_business_groups_perf bus
3851: where /* Assignment's Payroll details */
3852: asg.assignment_id = p_assignment_id
3853: and v_cur_date between asg.effective_start_date
3854: and asg.effective_end_date
3873: --
3874: -- Local variables
3875: --
3876: -- The assignment's business group legislation_code:
3877: v_legislation_code per_business_groups.legislation_code%TYPE;
3878: --
3879: -- The assignment's payroll as of the session effective or trunc(sysdate).
3880: v_payroll_id per_assignments_f.payroll_id%TYPE;
3881: --
4164: v_proc varchar2(72) := g_package||'start_quickpay_process';
4165: v_request_id pay_payroll_actions.request_id%TYPE;
4166: v_action_type pay_payroll_actions.action_type%TYPE;
4167: v_a_action_status pay_assignment_actions.action_status%TYPE;
4168: v_leg_code per_business_groups.legislation_code%TYPE;
4169: v_process_name varchar2(30);
4170: v_first_arg varchar2(30);
4171: v_asactid varchar2(30);
4172: v_asgid varchar2(30);
4341: hr_utility.set_location(v_proc, 6);
4342: --
4343: select pbg.legislation_code
4344: into v_leg_code
4345: from per_business_groups_perf pbg,
4346: pay_payroll_actions ppa
4347: where ppa.payroll_action_id = p_payroll_action_id
4348: and pbg.business_group_id = ppa.business_group_id;
4349: --