APPS.PAY_SG_SOE dependencies on HR_UTILITY

Line 256: hr_utility.trace('Act_Act_Id' || to_char(p_assignment_action_id));

252: close balance_value;
253: else
254:
255: /* Bug 2824397 */
256: hr_utility.trace('Act_Act_Id' || to_char(p_assignment_action_id));
257: hr_utility.trace('Person_Id' || to_char(p_person_id));
258: hr_utility.trace('Date' ||to_char(v_date_earned));
259:
260: /* Get the Date Earned of the Assignment Action */

Line 257: hr_utility.trace('Person_Id' || to_char(p_person_id));

253: else
254:
255: /* Bug 2824397 */
256: hr_utility.trace('Act_Act_Id' || to_char(p_assignment_action_id));
257: hr_utility.trace('Person_Id' || to_char(p_person_id));
258: hr_utility.trace('Date' ||to_char(v_date_earned));
259:
260: /* Get the Date Earned of the Assignment Action */
261: open c_date_earned(p_assignment_action_id);

Line 258: hr_utility.trace('Date' ||to_char(v_date_earned));

254:
255: /* Bug 2824397 */
256: hr_utility.trace('Act_Act_Id' || to_char(p_assignment_action_id));
257: hr_utility.trace('Person_Id' || to_char(p_person_id));
258: hr_utility.trace('Date' ||to_char(v_date_earned));
259:
260: /* Get the Date Earned of the Assignment Action */
261: open c_date_earned(p_assignment_action_id);
262: fetch c_date_earned into v_date_earned;

Line 265: hr_utility.trace('Date' ||to_char(v_date_earned));

261: open c_date_earned(p_assignment_action_id);
262: fetch c_date_earned into v_date_earned;
263: close c_date_earned;
264:
265: hr_utility.trace('Date' ||to_char(v_date_earned));
266:
267: /* Get all the assignments for the person_id and place the data into a PLSQL Table */
268:
269: open c_check_assignment(p_person_id,v_date_earned);

Line 277: hr_utility.trace('Count' || to_char(assignment_table.count));

273: v_assign_count := v_assign_count + 1;
274: end loop;
275: close c_check_assignment;
276:
277: hr_utility.trace('Count' || to_char(assignment_table.count));
278:
279: if assignment_table.count > 1 then
280: for v_counter in 1..assignment_table.count
281: loop

Line 291: hr_utility.trace('Loop_Id' || to_char(v_ass_act_id));

287: open c_max_assign_action(assignment_table(v_counter),v_date_earned);
288: fetch c_max_assign_action into v_ass_act_id;
289: close c_max_assign_action;
290:
291: hr_utility.trace('Loop_Id' || to_char(v_ass_act_id));
292: if (v_ass_act_id is not null) then
293: open balance_value (v_ass_act_id,
294: p_balance_name,
295: '_ASG_LE_YTD');

Line 300: hr_utility.trace('v_asg_le_value' || to_char(v_asg_le_value));

296: fetch balance_value into v_asg_le_value;
297: close balance_value;
298: end if;
299:
300: hr_utility.trace('v_asg_le_value' || to_char(v_asg_le_value));
301:
302: /* Sum up the asg_le value to arrive at the per_le value */
303:
304: v_per_le_ytd := nvl(v_per_le_ytd,0) + nvl(v_asg_le_value,0);

Line 305: hr_utility.trace('v_per_le_ytd' || to_char(v_per_le_ytd));

301:
302: /* Sum up the asg_le value to arrive at the per_le value */
303:
304: v_per_le_ytd := nvl(v_per_le_ytd,0) + nvl(v_asg_le_value,0);
305: hr_utility.trace('v_per_le_ytd' || to_char(v_per_le_ytd));
306:
307: end loop;
308:
309: p_ytd_balance := nvl(v_per_le_ytd,0);

Line 311: hr_utility.trace('p_ytd_balance' || to_char(p_ytd_balance));

307: end loop;
308:
309: p_ytd_balance := nvl(v_per_le_ytd,0);
310:
311: hr_utility.trace('p_ytd_balance' || to_char(p_ytd_balance));
312:
313: else
314:
315: /* If the person has a single assignment_id then directly use asg_le_ytd value,

Line 494: hr_utility.trace('Date' ||to_char(v_date_earned));

490: open c_date_earned(p_assignment_action_id);
491: fetch c_date_earned into v_date_earned;
492: close c_date_earned;
493:
494: hr_utility.trace('Date' ||to_char(v_date_earned));
495: /* Get all the assignments for the person_id and place the data into a PLSQL Table */
496:
497: open c_check_assignment(p_person_id,v_date_earned);
498: loop

Line 610: hr_utility.trace('JL pay_sg_soe, p_assignment_action_id:'||p_assignment_action_id);

606: v_tax_id := get_tax_id(p_assignment_action_id);
607:
608: pay_balance_pkg.set_context('TAX_UNIT_ID',v_tax_id);
609: -- Call procedure to get Current and YTD balances for Payment Summary Totals
610: hr_utility.trace('JL pay_sg_soe, p_assignment_action_id:'||p_assignment_action_id);
611: current_and_ytd_balances (p_prepaid_tag => p_prepaid_tag,
612: p_assignment_action_id => p_assignment_action_id,
613: p_balance_name => 'Gross Pay',
614: p_person_id => p_person_id,

Line 617: hr_utility.trace('JL v_gross_pay_curr:'||v_gross_pay_curr);

613: p_balance_name => 'Gross Pay',
614: p_person_id => p_person_id,
615: p_current_balance => v_gross_pay_curr,
616: p_ytd_balance => v_gross_pay_ytd);
617: hr_utility.trace('JL v_gross_pay_curr:'||v_gross_pay_curr);
618:
619: current_and_ytd_balances (p_prepaid_tag => p_prepaid_tag,
620: p_assignment_action_id => p_assignment_action_id,
621: p_balance_name => 'Statutory Deductions',