DBA Data[Home] [Help]

APPS.PAY_SG_IRAS_MAGTAPE dependencies on HR_UTILITY

Line 16: hr_utility.set_location('Start of range_code',1);

12: procedure range_code
13: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
14: p_sql out nocopy varchar2) is
15: begin
16: hr_utility.set_location('Start of range_code',1);
17:
18: p_sql := 'select distinct person_id ' ||
19: 'from per_people_f ppf, ' ||
20: 'pay_payroll_actions ppa ' ||

Line 25: hr_utility.set_location('End of range_code',2);

21: 'where ppa.payroll_action_id = :payroll_action_id ' ||
22: 'and ppa.business_group_id = ppf.business_group_id ' ||
23: 'order by ppf.person_id';
24:
25: hr_utility.set_location('End of range_code',2);
26: end range_code;
27:
28: --------------------------------------------------------------------------
29: -- --

Line 202: hr_utility.set_location('Start of assignment_action_code',3);

198: where pac.assignment_id = c_assignment_id
199: and pac.payroll_action_id = c_payroll_action_id;
200:
201: begin
202: hr_utility.set_location('Start of assignment_action_code',3);
203:
204: initialization_code(p_payroll_action_id);
205:
206: select decode(g_file,'IR8A', 'X_IR8A_AMEND_INDICATOR','IR8S', 'X_IR8S_AMEND_INDICATOR','A8A','X_A8A_AMEND_INDICATOR','A8B','X_A8B_AMEND_INDICATOR')

Line 217: hr_utility.set_location('Before calling hr_nonrun_asact.insact',4);

213: open next_action_id;
214: fetch next_action_id into v_next_action_id;
215: close next_action_id;
216:
217: hr_utility.set_location('Before calling hr_nonrun_asact.insact',4);
218:
219: pay_balance_pkg.set_context('TAX_UNIT_ID',process_rec.legal_entity_id);
220: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',v_next_action_id);
221:

Line 237: hr_utility.set_location('After calling hr_nonrun_asact.insact',4);

233: v_archive_action_id); -- locked action id
234: else
235: close locked_action;
236: end if;
237: hr_utility.set_location('After calling hr_nonrun_asact.insact',4);
238:
239: end loop;
240:
241: hr_utility.set_location('End of assignment_action_code',5);

Line 241: hr_utility.set_location('End of assignment_action_code',5);

237: hr_utility.set_location('After calling hr_nonrun_asact.insact',4);
238:
239: end loop;
240:
241: hr_utility.set_location('End of assignment_action_code',5);
242: end assignment_action_code;
243: ------------------------------------------------------------------------
244: -- This is used by legislation groups to set global contexts that are
245: -- required for the lifetime of the archiving process. This is null

Line 253: hr_utility.set_location('Start of initialization_code',6);

249: ------------------------------------------------------------------------
250: procedure initialization_code
251: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type) is
252: begin
253: hr_utility.set_location('Start of initialization_code',6);
254: get_parameters(p_payroll_action_id,'REP_TYPE',g_report_type);
255: get_parameters(p_payroll_action_id,'FILE',g_file);
256: hr_utility.set_location('End of initialization_code',7);
257: end initialization_code;

Line 256: hr_utility.set_location('End of initialization_code',7);

252: begin
253: hr_utility.set_location('Start of initialization_code',6);
254: get_parameters(p_payroll_action_id,'REP_TYPE',g_report_type);
255: get_parameters(p_payroll_action_id,'FILE',g_file);
256: hr_utility.set_location('End of initialization_code',7);
257: end initialization_code;
258: ------------------------------------------------------------------------
259: -- Used to actually perform the archival of data. We are not archiving
260: -- any data here, so this is null.

Line 267: hr_utility.set_location('Start of archive_code',8);

263: (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
264: p_effective_date in date) is
265:
266: begin
267: hr_utility.set_location('Start of archive_code',8);
268: null;
269: hr_utility.set_location('End of archive_code',9);
270: end archive_code;
271:

Line 269: hr_utility.set_location('End of archive_code',9);

265:
266: begin
267: hr_utility.set_location('Start of archive_code',8);
268: null;
269: hr_utility.set_location('End of archive_code',9);
270: end archive_code;
271:
272: end pay_sg_iras_magtape;