[Home] [Help]
1: package body pay_action_contexts_pkg as
2: /* $Header: pyactx.pkb 120.0 2005/05/29 01:51:32 appldev noship $ */
3: --
4: -- private global variables
5: --
33: and c2.context_name = 'JURISDICTION_CODE'
34: and c3.context_name = 'TAX_GROUP';
35: exception
36: when NO_DATA_FOUND then
37: ff_utils.assert(false, 'pay_action_contexts_pkg:archinit:10');
38: end;
39:
40: --
41: -- lookup up legislation code for business group
51: and ou.organization_id = o.organization_id
52: and ou.org_information_context = 'Business Group Information';
53: exception
54: when NO_DATA_FOUND then
55: ff_utils.assert(false, 'pay_action_contexts_pkg:archinit:20');
56: end;
57:
58: hr_utility.trace('< archinit()');
59: end archinit;
130: b_asg_id number,
131: b_context_id number,
132: b_context_value varchar2) is
133: SELECT 1
134: FROM PAY_ACTION_CONTEXTS ac
135: WHERE ac.assignment_action_id = b_asg_act_id
136: and ac.assignment_id = b_asg_id
137: and ac.context_id = b_context_id
138: and ac.context_value = b_context_value;
155: hr_utility.trace('AA_ID>' || p_asg_act_id || '< ' ||
156: 'ASG_ID>' || p_asg_id || '< ' ||
157: 'CONTEXT_ID>' || p_context_id || '< ' ||
158: 'CONTEXT_VALUE>' || p_context_value || '<');
159: INSERT INTO pay_action_contexts (
160: assignment_action_id,
161: assignment_id,
162: context_id,
163: context_value)
220: and pee.entry_type = 'E';
221: --
222: l_dummy number;
223:
224: l_tax_group pay_action_contexts.context_value%type;
225: begin
226: hr_utility.trace('> process_asg_act()');
227:
228: --
355: and pa.action_type in ('R', 'Q', 'B', 'V', 'I')
356: and pa.effective_date <= p_effective_date
357: and NOT EXISTS
358: (SELECT 1
359: FROM PAY_ACTION_CONTEXTS ac
360: WHERE ac.assignment_action_id = aat.assignment_action_id)
361: ORDER BY
362: aat.assignment_action_id;
363: begin
394: hr_utility.trace('> deinitialise()');
395: hr_utility.trace('< deinitialise()');
396: end deinitialise;
397:
398: end pay_action_contexts_pkg;