DBA Data[Home] [Help]

APPS.PAY_MX_SOE_SS_PKG dependencies on PAY_SOE_UTIL

Line 64: pay_soe_util.clear;

60:
61: hr_utility.trace('Entering.. pay_mx_soe_ss_pkg.employee_earnings ');
62: hr_utility.trace('p_assignment_action_id '||p_assignment_action_id);
63:
64: pay_soe_util.clear;
65:
66: lv_sql := 'select earn_bal_name COL01
67: ,nvl(earn_reporting_name, earn_bal_name) COL02
68: ,to_char(days_run_val

Line 89: pay_soe_util.clear;

85:
86: hr_utility.trace('Entering.. pay_mx_soe_ss_pkg.employee_taxes ');
87: hr_utility.trace('p_assignment_action_id '||p_assignment_action_id);
88:
89: pay_soe_util.clear;
90:
91: lv_sql := 'select balance_name COL01
92: ,nvl(reporting_name, balance_name) COL02
93: ,to_char(run_val

Line 112: pay_soe_util.clear;

108:
109: hr_utility.trace('Entering.. pay_mx_soe_ss_pkg.tax_calc_details ');
110: hr_utility.trace('p_assignment_action_id '||p_assignment_action_id);
111:
112: pay_soe_util.clear;
113:
114: lv_sql := 'select balance_name COL01
115: ,nvl(reporting_name, balance_name) COL02
116: ,to_char(run_val

Line 197: pay_soe_util.clear;

193: ln_cnt := ln_cnt + 1;
194: summary(ln_cnt).bal_name := 'Total Pay';
195: summary(ln_cnt).reporting_name := 'Total Pay';
196:
197: pay_soe_util.clear;
198:
199: for i in summary.first..summary.last loop
200:
201: hr_utility.trace('i = '||i);

Line 226: pay_soe_util.setValue('01' ,summary(i).bal_name ,TRUE, FALSE);

222: -- ,p_assignment_action_id);
223: --
224: --
225: hr_utility.trace(' summary(i).curr_val '|| summary(i).curr_val);
226: pay_soe_util.setValue('01' ,summary(i).bal_name ,TRUE, FALSE);
227: pay_soe_util.setValue('02' ,summary(i).reporting_name ,FALSE, FALSE);
228: pay_soe_util.setValue('16' ,summary(i).curr_val, FALSE, FALSE );
229: pay_soe_util.setValue('17' ,summary(i).ytd_val, FALSE, TRUE );
230: --

Line 227: pay_soe_util.setValue('02' ,summary(i).reporting_name ,FALSE, FALSE);

223: --
224: --
225: hr_utility.trace(' summary(i).curr_val '|| summary(i).curr_val);
226: pay_soe_util.setValue('01' ,summary(i).bal_name ,TRUE, FALSE);
227: pay_soe_util.setValue('02' ,summary(i).reporting_name ,FALSE, FALSE);
228: pay_soe_util.setValue('16' ,summary(i).curr_val, FALSE, FALSE );
229: pay_soe_util.setValue('17' ,summary(i).ytd_val, FALSE, TRUE );
230: --
231: end loop;

Line 228: pay_soe_util.setValue('16' ,summary(i).curr_val, FALSE, FALSE );

224: --
225: hr_utility.trace(' summary(i).curr_val '|| summary(i).curr_val);
226: pay_soe_util.setValue('01' ,summary(i).bal_name ,TRUE, FALSE);
227: pay_soe_util.setValue('02' ,summary(i).reporting_name ,FALSE, FALSE);
228: pay_soe_util.setValue('16' ,summary(i).curr_val, FALSE, FALSE );
229: pay_soe_util.setValue('17' ,summary(i).ytd_val, FALSE, TRUE );
230: --
231: end loop;
232:

Line 229: pay_soe_util.setValue('17' ,summary(i).ytd_val, FALSE, TRUE );

225: hr_utility.trace(' summary(i).curr_val '|| summary(i).curr_val);
226: pay_soe_util.setValue('01' ,summary(i).bal_name ,TRUE, FALSE);
227: pay_soe_util.setValue('02' ,summary(i).reporting_name ,FALSE, FALSE);
228: pay_soe_util.setValue('16' ,summary(i).curr_val, FALSE, FALSE );
229: pay_soe_util.setValue('17' ,summary(i).ytd_val, FALSE, TRUE );
230: --
231: end loop;
232:
233: hr_utility.trace('Leaving.. pay_mx_soe_ss_pkg.mx_summary_balances ');

Line 235: return pay_soe_util.genCursor;

231: end loop;
232:
233: hr_utility.trace('Leaving.. pay_mx_soe_ss_pkg.mx_summary_balances ');
234:
235: return pay_soe_util.genCursor;
236:
237: END summary_balances;
238:
239: FUNCTION hourly_earnings( p_assignment_action_id in NUMBER )

Line 246: pay_soe_util.clear;

242:
243: hr_utility.trace('Entering.. pay_mx_soe_ss_pkg.hourly_earnings ');
244: hr_utility.trace('p_assignment_action_id '||p_assignment_action_id);
245:
246: pay_soe_util.clear;
247:
248: lv_sql := 'select earn_bal_name COL01
249: ,nvl(earn_reporting_name, earn_bal_name) COL02
250: ,to_char(hours_run_val

Line 271: pay_soe_util.clear;

267:
268: hr_utility.trace('Entering.. pay_mx_soe_ss_pkg.taxable_benefits ');
269: hr_utility.trace('p_assignment_action_id '||p_assignment_action_id);
270:
271: pay_soe_util.clear;
272:
273: lv_sql := 'select balance_name COL01
274: ,nvl(reporting_name, balance_name) COL02
275: ,to_char(run_val

Line 294: pay_soe_util.clear;

290:
291: hr_utility.trace('Entering.. pay_mx_soe_ss_pkg.tax_balances ');
292: hr_utility.trace('p_assignment_action_id '||p_assignment_action_id);
293:
294: pay_soe_util.clear;
295:
296: lv_sql := 'select balance_name COL01
297: ,nvl(reporting_name, balance_name) COL02
298: ,to_char(run_val

Line 317: pay_soe_util.clear;

313:
314: hr_utility.trace('Entering.. pay_mx_soe_ss_pkg.deductions ');
315: hr_utility.trace('p_assignment_action_id '||p_assignment_action_id);
316:
317: pay_soe_util.clear;
318:
319: lv_sql := 'select balance_name COL01
320: ,nvl(reporting_name, balance_name) COL02
321: ,to_char(run_val

Line 340: pay_soe_util.clear;

336:
337: hr_utility.trace('Entering.. pay_mx_soe_ss_pkg.other_balances ');
338: hr_utility.trace('p_assignment_action_id '||p_assignment_action_id);
339:
340: pay_soe_util.clear;
341:
342: lv_sql := 'select balance_name COL01
343: ,nvl(reporting_name, balance_name) COL02
344: ,to_char(run_val