304:
305: BEGIN
306:
307: step (1, 'Entering');
308: hr_general.assert_condition (all_parameters_are_valid);
309:
310: step (2);
311:
312: -- Get the number of earnings entries included in the run that must be
3860: asg.payroll_id
3861: , pro.consolidation_set_id
3862: , con.consolidation_set_name
3863: , bus.legislation_code
3864: , hr_general.decode_lookup('ASSIGNMENT_ACTION_STATUS', 'U')
3865: , hr_general.decode_lookup('ASSIGNMENT_ACTION_STATUS', 'M')
3866: , hr_general.decode_lookup('ASSIGNMENT_ACTION_STATUS', 'C')
3867: , hr_general.decode_lookup('ASSIGNMENT_ACTION_STATUS', 'E')
3868: , hr_general.decode_lookup('ACTION_TYPE', 'Q')
3861: , pro.consolidation_set_id
3862: , con.consolidation_set_name
3863: , bus.legislation_code
3864: , hr_general.decode_lookup('ASSIGNMENT_ACTION_STATUS', 'U')
3865: , hr_general.decode_lookup('ASSIGNMENT_ACTION_STATUS', 'M')
3866: , hr_general.decode_lookup('ASSIGNMENT_ACTION_STATUS', 'C')
3867: , hr_general.decode_lookup('ASSIGNMENT_ACTION_STATUS', 'E')
3868: , hr_general.decode_lookup('ACTION_TYPE', 'Q')
3869: from per_assignments_f asg
3862: , con.consolidation_set_name
3863: , bus.legislation_code
3864: , hr_general.decode_lookup('ASSIGNMENT_ACTION_STATUS', 'U')
3865: , hr_general.decode_lookup('ASSIGNMENT_ACTION_STATUS', 'M')
3866: , hr_general.decode_lookup('ASSIGNMENT_ACTION_STATUS', 'C')
3867: , hr_general.decode_lookup('ASSIGNMENT_ACTION_STATUS', 'E')
3868: , hr_general.decode_lookup('ACTION_TYPE', 'Q')
3869: from per_assignments_f asg
3870: , pay_payrolls_f pro
3863: , bus.legislation_code
3864: , hr_general.decode_lookup('ASSIGNMENT_ACTION_STATUS', 'U')
3865: , hr_general.decode_lookup('ASSIGNMENT_ACTION_STATUS', 'M')
3866: , hr_general.decode_lookup('ASSIGNMENT_ACTION_STATUS', 'C')
3867: , hr_general.decode_lookup('ASSIGNMENT_ACTION_STATUS', 'E')
3868: , hr_general.decode_lookup('ACTION_TYPE', 'Q')
3869: from per_assignments_f asg
3870: , pay_payrolls_f pro
3871: , pay_consolidation_sets con
3864: , hr_general.decode_lookup('ASSIGNMENT_ACTION_STATUS', 'U')
3865: , hr_general.decode_lookup('ASSIGNMENT_ACTION_STATUS', 'M')
3866: , hr_general.decode_lookup('ASSIGNMENT_ACTION_STATUS', 'C')
3867: , hr_general.decode_lookup('ASSIGNMENT_ACTION_STATUS', 'E')
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
3965: hr_utility.set_location(v_proc, 8);
3966: --
3967: -- Obtain the button prompts from hr_lookups
3968: --
3969: p_start_run_prompt := hr_general.decode_lookup ('PAYWSRQP_BUTTONS','SR');
3970: p_start_pre_prompt := hr_general.decode_lookup ('PAYWSRQP_BUTTONS','SP');
3971: p_retry_run_prompt := hr_general.decode_lookup ('PAYWSRQP_BUTTONS','RR');
3972: p_rerun_pre_prompt := hr_general.decode_lookup ('PAYWSRQP_BUTTONS','RP');
3973: p_start_arc_prompt := hr_general.decode_lookup ('PAYWSRQP_BUTTONS','SA');
3966: --
3967: -- Obtain the button prompts from hr_lookups
3968: --
3969: p_start_run_prompt := hr_general.decode_lookup ('PAYWSRQP_BUTTONS','SR');
3970: p_start_pre_prompt := hr_general.decode_lookup ('PAYWSRQP_BUTTONS','SP');
3971: p_retry_run_prompt := hr_general.decode_lookup ('PAYWSRQP_BUTTONS','RR');
3972: p_rerun_pre_prompt := hr_general.decode_lookup ('PAYWSRQP_BUTTONS','RP');
3973: p_start_arc_prompt := hr_general.decode_lookup ('PAYWSRQP_BUTTONS','SA');
3974: p_retry_arc_prompt := hr_general.decode_lookup ('PAYWSRQP_BUTTONS','RA');
3967: -- Obtain the button prompts from hr_lookups
3968: --
3969: p_start_run_prompt := hr_general.decode_lookup ('PAYWSRQP_BUTTONS','SR');
3970: p_start_pre_prompt := hr_general.decode_lookup ('PAYWSRQP_BUTTONS','SP');
3971: p_retry_run_prompt := hr_general.decode_lookup ('PAYWSRQP_BUTTONS','RR');
3972: p_rerun_pre_prompt := hr_general.decode_lookup ('PAYWSRQP_BUTTONS','RP');
3973: p_start_arc_prompt := hr_general.decode_lookup ('PAYWSRQP_BUTTONS','SA');
3974: p_retry_arc_prompt := hr_general.decode_lookup ('PAYWSRQP_BUTTONS','RA');
3975: if p_start_run_prompt is null or p_retry_run_prompt is null or
3968: --
3969: p_start_run_prompt := hr_general.decode_lookup ('PAYWSRQP_BUTTONS','SR');
3970: p_start_pre_prompt := hr_general.decode_lookup ('PAYWSRQP_BUTTONS','SP');
3971: p_retry_run_prompt := hr_general.decode_lookup ('PAYWSRQP_BUTTONS','RR');
3972: p_rerun_pre_prompt := hr_general.decode_lookup ('PAYWSRQP_BUTTONS','RP');
3973: p_start_arc_prompt := hr_general.decode_lookup ('PAYWSRQP_BUTTONS','SA');
3974: p_retry_arc_prompt := hr_general.decode_lookup ('PAYWSRQP_BUTTONS','RA');
3975: if p_start_run_prompt is null or p_retry_run_prompt is null or
3976: p_start_pre_prompt is null or p_rerun_pre_prompt is null or
3969: p_start_run_prompt := hr_general.decode_lookup ('PAYWSRQP_BUTTONS','SR');
3970: p_start_pre_prompt := hr_general.decode_lookup ('PAYWSRQP_BUTTONS','SP');
3971: p_retry_run_prompt := hr_general.decode_lookup ('PAYWSRQP_BUTTONS','RR');
3972: p_rerun_pre_prompt := hr_general.decode_lookup ('PAYWSRQP_BUTTONS','RP');
3973: p_start_arc_prompt := hr_general.decode_lookup ('PAYWSRQP_BUTTONS','SA');
3974: p_retry_arc_prompt := hr_general.decode_lookup ('PAYWSRQP_BUTTONS','RA');
3975: if p_start_run_prompt is null or p_retry_run_prompt is null or
3976: p_start_pre_prompt is null or p_rerun_pre_prompt is null or
3977: p_start_arc_prompt is null or p_retry_arc_prompt is null then
3970: p_start_pre_prompt := hr_general.decode_lookup ('PAYWSRQP_BUTTONS','SP');
3971: p_retry_run_prompt := hr_general.decode_lookup ('PAYWSRQP_BUTTONS','RR');
3972: p_rerun_pre_prompt := hr_general.decode_lookup ('PAYWSRQP_BUTTONS','RP');
3973: p_start_arc_prompt := hr_general.decode_lookup ('PAYWSRQP_BUTTONS','SA');
3974: p_retry_arc_prompt := hr_general.decode_lookup ('PAYWSRQP_BUTTONS','RA');
3975: if p_start_run_prompt is null or p_retry_run_prompt is null or
3976: p_start_pre_prompt is null or p_rerun_pre_prompt is null or
3977: p_start_arc_prompt is null or p_retry_arc_prompt is null then
3978: -- All six button labels could not be found in hr_lookups.