[Home] [Help]
26: -- argument.
27: --
28: -- Post Success:
29: -- Ends successfully if a matching assignment_action_id exists in
30: -- pay_assignment_actions and it is for a QuickPay Run process.
31: --
32: -- Post Failure:
33: -- Raises an error if at least one of the following is true:
34: -- 1) An Assignment Process with an id of p_assignment_action_id does
41: --
42: -- {End Of Comments}
43: --
44: procedure validate_asg_act_id
45: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE
46: ) is
47: --
48: v_exists varchar2(1);
49: v_proc varchar2(72) := g_package||'validate_asg_act_id';
49: v_proc varchar2(72) := g_package||'validate_asg_act_id';
50: --
51: cursor sel_exists is
52: select 'Y'
53: from pay_assignment_actions
54: where assignment_action_id = p_assignment_action_id;
55: --
56: cursor sel_for_qpr is
57: select 'Y'
55: --
56: cursor sel_for_qpr is
57: select 'Y'
58: from pay_payroll_actions pya
59: , pay_assignment_actions asa
60: where pya.action_type = 'Q'
61: and pya.payroll_action_id = asa.payroll_action_id
62: and asa.assignment_action_id = p_assignment_action_id;
63: begin
156: pay_element_types_f et
157: , pay_element_links_f el
158: , pay_element_entries_f ent
159: , pay_payroll_actions pya
160: , pay_assignment_actions aga
161: where ent.element_entry_id = p_rec.element_entry_id
162: and ent.effective_start_date <= pya.date_earned
163: and ent.effective_end_date >= decode(et.proration_group_id, null, pya.date_earned,
164: pay_interpreter_pkg.prorate_start_date
180: pay_element_types_f et
181: , pay_element_links_f el
182: , pay_element_entries_f ent
183: , pay_payroll_actions pya
184: , pay_assignment_actions aga
185: where ent.element_entry_id = p_rec.element_entry_id
186: and ent.assignment_id = aga.assignment_id
187: and ent.effective_start_date <= pya.date_earned
188: and ent.effective_end_date >= decode(et.proration_group_id, null, pya.date_earned,
203: p_assignment_action_id in number,
204: p_element_entry_id in number
205: ) is
206: select 'Y'
207: from pay_assignment_actions asgt_act,
208: pay_run_results rr
209: where asgt_act.assignment_action_id = rr.assignment_action_id
210: and rr.source_id = p_element_entry_id
211: and rr.source_type in ('E','I')
351: -- Checks that the payroll action does not have a current task set to not
352: -- null. This procedure is used in insert and delete validation.
353: --
354: -- Pre Conditions:
355: -- A QuickPay Run assignment process already exists in pay_assignment_actions
356: -- with an id of p_assignment_action_id.
357: --
358: -- In Arguments:
359: -- p_assignment_action_id is the assignment_action_id on the Quickpay
370: --
371: -- {End Of Comments}
372: --
373: procedure validate_act_cmp
374: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE
375: ) is
376: --
377: v_exists varchar2(1);
378: v_proc varchar2(72) := g_package||'validate_act_cmp';
381: -- No longer require cur_aga_act for quickpay exclusions...
382: /*
383: cursor cur_aga_act is
384: select 'Y'
385: from pay_assignment_actions
386: where assignment_action_id = p_assignment_action_id
387: and action_status in ('C', 'S');
388: */
389: --
390: --
391: cursor cur_pya_act is
392: select 'Y'
393: from pay_payroll_actions pya
394: , pay_assignment_actions aga
395: where aga.assignment_action_id = p_assignment_action_id
396: and pya.payroll_action_id = aga.payroll_action_id
397: and pya.current_task is not null;
398: begin