eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_ACTION_CONTEXTS_PKG dependencies on HR_UTILITY

Line 19: hr_utility.trace('> archinit()');

15:
16: procedure archinit(p_pay_act_id in number)
17: is
18: begin
19: hr_utility.trace('> archinit()');
20:
21: --
22: -- lookup up context id values for contexts to be populated
23: --

Line 58: hr_utility.trace('< archinit()');

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;
60:
61:
62:

Line 67: hr_utility.trace('> range_cursor()');

63: procedure range_cursor(p_pay_act_id in number
64: ,p_sqlstr out nocopy varchar2)
65: is
66: begin
67: hr_utility.trace('> range_cursor()');
68:
69: p_sqlstr :=
70: 'SELECT DISTINCT
71: asg.person_id

Line 79: hr_utility.trace('< range_cursor()');

75: and asg.business_group_id = pa.business_group_id
76: ORDER BY
77: asg.person_id';
78:
79: hr_utility.trace('< range_cursor()');
80: end range_cursor;
81:
82:
83:

Line 105: hr_utility.trace('> action_creation()');

101: and pos.person_id between b_stperson and b_endperson;
102:
103: l_locking_asg_act_id number;
104: begin
105: hr_utility.trace('> action_creation()');
106:
107: for rec_asg_act in csr_asg_acts(p_pay_act_id, p_stperson, p_endperson) loop
108: SELECT pay_assignment_actions_s.nextval
109: INTO l_locking_asg_act_id

Line 119: hr_utility.trace('< action_creation()');

115: hr_nonrun_asact.insact(l_locking_asg_act_id, rec_asg_act.assignment_id,
116: p_pay_act_id, p_chunk, null);
117: end loop;
118:
119: hr_utility.trace('< action_creation()');
120: end action_creation;
121:
122:
123:

Line 142: hr_utility.trace('> ins_action_context()');

138: and ac.context_value = b_context_value;
139:
140: rec_dummy csr_chk_dup%rowtype;
141: begin
142: hr_utility.trace('> ins_action_context()');
143:
144: --
145: -- before doing insert,
146: -- check if context value already exists,

Line 155: hr_utility.trace('AA_ID>' || p_asg_act_id || '< ' ||

151: open csr_chk_dup(p_asg_act_id, p_asg_id, p_context_id, p_context_value);
152: fetch csr_chk_dup into rec_dummy;
153:
154: if csr_chk_dup%notfound then
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 (

Line 173: hr_utility.trace('< ins_action_context()');

169: end if;
170:
171: close csr_chk_dup;
172:
173: hr_utility.trace('< ins_action_context()');
174: exception
175: when others then
176: close csr_chk_dup;
177: raise;

Line 226: hr_utility.trace('> process_asg_act()');

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: --
229: -- if in US legislation then also look up tax group
230: --

Line 324: hr_utility.trace('< process_asg_act()');

320: rec_context_value.jurisdiction_code);
321: end if;
322: end loop;
323:
324: hr_utility.trace('< process_asg_act()');
325: end process_asg_act;
326:
327:
328:

Line 364: hr_utility.trace('> * archive_data() *');

360: WHERE ac.assignment_action_id = aat.assignment_action_id)
361: ORDER BY
362: aat.assignment_action_id;
363: begin
364: hr_utility.trace('> ***** archive_data() *****');
365: hr_utility.trace(' p_asg_act_id>' || p_asg_act_id || '<');
366: hr_utility.trace(' p_effective_date>' || p_effective_date || '<');
367:
368: --

Line 365: hr_utility.trace(' p_asg_act_id>' || p_asg_act_id || '<');

361: ORDER BY
362: aat.assignment_action_id;
363: begin
364: hr_utility.trace('> ***** archive_data() *****');
365: hr_utility.trace(' p_asg_act_id>' || p_asg_act_id || '<');
366: hr_utility.trace(' p_effective_date>' || p_effective_date || '<');
367:
368: --
369: -- loop through all assignment actions associated with an assignment,

Line 366: hr_utility.trace(' p_effective_date>' || p_effective_date || '<');

362: aat.assignment_action_id;
363: begin
364: hr_utility.trace('> ***** archive_data() *****');
365: hr_utility.trace(' p_asg_act_id>' || p_asg_act_id || '<');
366: hr_utility.trace(' p_effective_date>' || p_effective_date || '<');
367:
368: --
369: -- loop through all assignment actions associated with an assignment,
370: -- do context processing for each assignment action individually

Line 380: hr_utility.trace('< * archive_data() *');

376: rec_asg_act.effective_date,
377: rec_asg_act.action_type);
378: end loop;
379:
380: hr_utility.trace('< ***** archive_data() *****');
381: exception
382: when others then
383: hr_utility.trace('***** others');
384: hr_utility.trace('***** sqlcode>' || sqlcode || '<');

Line 383: hr_utility.trace('***** others');

379:
380: hr_utility.trace('< ***** archive_data() *****');
381: exception
382: when others then
383: hr_utility.trace('***** others');
384: hr_utility.trace('***** sqlcode>' || sqlcode || '<');
385: hr_utility.trace('***** sqlerrm>' || sqlerrm || '<');
386: raise;
387: end archive_data;

Line 384: hr_utility.trace('***** sqlcode>' || sqlcode || '<');

380: hr_utility.trace('< ***** archive_data() *****');
381: exception
382: when others then
383: hr_utility.trace('***** others');
384: hr_utility.trace('***** sqlcode>' || sqlcode || '<');
385: hr_utility.trace('***** sqlerrm>' || sqlerrm || '<');
386: raise;
387: end archive_data;
388:

Line 385: hr_utility.trace('***** sqlerrm>' || sqlerrm || '<');

381: exception
382: when others then
383: hr_utility.trace('***** others');
384: hr_utility.trace('***** sqlcode>' || sqlcode || '<');
385: hr_utility.trace('***** sqlerrm>' || sqlerrm || '<');
386: raise;
387: end archive_data;
388:
389:

Line 394: hr_utility.trace('> deinitialise()');

390:
391: procedure deinitialise(p_pay_act_id in number)
392: is
393: begin
394: hr_utility.trace('> deinitialise()');
395: hr_utility.trace('< deinitialise()');
396: end deinitialise;
397:
398: end pay_action_contexts_pkg;

Line 395: hr_utility.trace('< deinitialise()');

391: procedure deinitialise(p_pay_act_id in number)
392: is
393: begin
394: hr_utility.trace('> deinitialise()');
395: hr_utility.trace('< deinitialise()');
396: end deinitialise;
397:
398: end pay_action_contexts_pkg;