[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
158: pay_element_types_f et
159: , pay_element_links_f el
160: , pay_element_entries_f ent
161: , pay_payroll_actions pya
162: , pay_assignment_actions aga
163: where ent.element_entry_id = p_rec.element_entry_id
164: and ent.effective_start_date <= pya.date_earned
165: and ent.effective_end_date >= decode(et.proration_group_id, null, pya.date_earned,
166: pay_interpreter_pkg.prorate_start_date
182: pay_element_types_f et
183: , pay_element_links_f el
184: , pay_element_entries_f ent
185: , pay_payroll_actions pya
186: , pay_assignment_actions aga
187: where ent.element_entry_id = p_rec.element_entry_id
188: and ent.assignment_id = aga.assignment_id
189: and ent.effective_start_date <= pya.date_earned
190: and ent.effective_end_date >= decode(et.proration_group_id, null, pya.date_earned,
467: -- a current task set to not null. This procedure is used in insert and
468: -- delete validation.
469: --
470: -- Pre Conditions:
471: -- A QuickPay Run assignment process already exists in pay_assignment_actions
472: -- with an id of p_assignment_action_id.
473: --
474: -- In Arguments:
475: -- p_assignment_action_id is the assignment_action_id on the Quickpay
489: --
490: -- {End Of Comments}
491: --
492: procedure validate_act_cmp
493: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE
494: ) is
495: --
496: v_exists varchar2(1);
497: v_proc varchar2(72) := g_package||'validate_act_cmp';
497: v_proc varchar2(72) := g_package||'validate_act_cmp';
498: --
499: cursor cur_aga_act is
500: select 'Y'
501: from pay_assignment_actions
502: where assignment_action_id = p_assignment_action_id
503: and action_status in ('C', 'S');
504: --
505: cursor cur_pya_act is
504: --
505: cursor cur_pya_act is
506: select 'Y'
507: from pay_payroll_actions pya
508: , pay_assignment_actions aga
509: where aga.assignment_action_id = p_assignment_action_id
510: and pya.payroll_action_id = aga.payroll_action_id
511: and pya.current_task is not null;
512: begin
954: -- |-------------------------< bulk_default_ins >-----------------------------|
955: -- ----------------------------------------------------------------------------
956: --
957: procedure bulk_default_ins
958: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE
959: ,p_validate in boolean default false
960: ) is
961: --
962: v_proc varchar2(72) := g_package||'bulk_default_ins';
997: from pay_element_types_f ety
998: , pay_element_links_f elk
999: , pay_element_entries_f ent
1000: , pay_payroll_actions pya
1001: , pay_assignment_actions asa
1002: where /*
1003: * Element Type:
1004: * Only include those which can be processed in the run.
1005: */