DBA Data[Home] [Help]

APPS.PAY_MX_SOE_SS_PKG dependencies on PAY_SOE_UTIL

Line 69: pay_soe_util.clear;

65:
66: hr_utility.trace('Entering.. pay_mx_soe_ss_pkg.employee_earnings ');
67: hr_utility.trace('p_assignment_action_id '||p_assignment_action_id);
68:
69: pay_soe_util.clear;
70:
71: lv_sql := 'select earn_bal_name COL01
72: ,nvl(earn_reporting_name, earn_bal_name) COL02
73: ,to_char(days_run_val

Line 94: pay_soe_util.clear;

90:
91: hr_utility.trace('Entering.. pay_mx_soe_ss_pkg.employee_taxes ');
92: hr_utility.trace('p_assignment_action_id '||p_assignment_action_id);
93:
94: pay_soe_util.clear;
95:
96: lv_sql := 'select balance_name COL01
97: ,nvl(reporting_name, balance_name) COL02
98: ,to_char(run_val

Line 117: pay_soe_util.clear;

113:
114: hr_utility.trace('Entering.. pay_mx_soe_ss_pkg.tax_calc_details ');
115: hr_utility.trace('p_assignment_action_id '||p_assignment_action_id);
116:
117: pay_soe_util.clear;
118:
119: lv_sql := 'select balance_name COL01
120: ,nvl(reporting_name, balance_name) COL02
121: ,to_char(run_val

Line 202: pay_soe_util.clear;

198: ln_cnt := ln_cnt + 1;
199: summary(ln_cnt).bal_name := 'Total Pay';
200: summary(ln_cnt).reporting_name := 'Total Pay';
201:
202: pay_soe_util.clear;
203:
204: for i in summary.first..summary.last loop
205:
206: hr_utility.trace('i = '||i);

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

227: -- ,p_assignment_action_id);
228: --
229: --
230: hr_utility.trace(' summary(i).curr_val '|| summary(i).curr_val);
231: pay_soe_util.setValue('01' ,summary(i).bal_name ,TRUE, FALSE);
232: pay_soe_util.setValue('02' ,summary(i).reporting_name ,FALSE, FALSE);
233: pay_soe_util.setValue('16' ,summary(i).curr_val, FALSE, FALSE );
234: pay_soe_util.setValue('17' ,summary(i).ytd_val, FALSE, TRUE );
235: --

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

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

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

229: --
230: hr_utility.trace(' summary(i).curr_val '|| summary(i).curr_val);
231: pay_soe_util.setValue('01' ,summary(i).bal_name ,TRUE, FALSE);
232: pay_soe_util.setValue('02' ,summary(i).reporting_name ,FALSE, FALSE);
233: pay_soe_util.setValue('16' ,summary(i).curr_val, FALSE, FALSE );
234: pay_soe_util.setValue('17' ,summary(i).ytd_val, FALSE, TRUE );
235: --
236: end loop;
237:

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

230: hr_utility.trace(' summary(i).curr_val '|| summary(i).curr_val);
231: pay_soe_util.setValue('01' ,summary(i).bal_name ,TRUE, FALSE);
232: pay_soe_util.setValue('02' ,summary(i).reporting_name ,FALSE, FALSE);
233: pay_soe_util.setValue('16' ,summary(i).curr_val, FALSE, FALSE );
234: pay_soe_util.setValue('17' ,summary(i).ytd_val, FALSE, TRUE );
235: --
236: end loop;
237:
238: hr_utility.trace('Leaving.. pay_mx_soe_ss_pkg.mx_summary_balances ');

Line 240: return pay_soe_util.genCursor;

236: end loop;
237:
238: hr_utility.trace('Leaving.. pay_mx_soe_ss_pkg.mx_summary_balances ');
239:
240: return pay_soe_util.genCursor;
241:
242: END summary_balances;
243:
244: FUNCTION hourly_earnings( p_assignment_action_id in NUMBER )

Line 251: pay_soe_util.clear;

247:
248: hr_utility.trace('Entering.. pay_mx_soe_ss_pkg.hourly_earnings ');
249: hr_utility.trace('p_assignment_action_id '||p_assignment_action_id);
250:
251: pay_soe_util.clear;
252:
253: lv_sql := 'select earn_bal_name COL01
254: ,nvl(earn_reporting_name, earn_bal_name) COL02
255: ,to_char(hours_run_val

Line 276: pay_soe_util.clear;

272:
273: hr_utility.trace('Entering.. pay_mx_soe_ss_pkg.taxable_benefits ');
274: hr_utility.trace('p_assignment_action_id '||p_assignment_action_id);
275:
276: pay_soe_util.clear;
277:
278: lv_sql := 'select balance_name COL01
279: ,nvl(reporting_name, balance_name) COL02
280: ,to_char(run_val

Line 299: pay_soe_util.clear;

295:
296: hr_utility.trace('Entering.. pay_mx_soe_ss_pkg.tax_balances ');
297: hr_utility.trace('p_assignment_action_id '||p_assignment_action_id);
298:
299: pay_soe_util.clear;
300:
301: lv_sql := 'select balance_name COL01
302: ,nvl(reporting_name, balance_name) COL02
303: ,to_char(run_val

Line 322: pay_soe_util.clear;

318:
319: hr_utility.trace('Entering.. pay_mx_soe_ss_pkg.deductions ');
320: hr_utility.trace('p_assignment_action_id '||p_assignment_action_id);
321:
322: pay_soe_util.clear;
323:
324: lv_sql := 'select balance_name COL01
325: ,nvl(reporting_name, balance_name) COL02
326: ,to_char(run_val

Line 345: pay_soe_util.clear;

341:
342: hr_utility.trace('Entering.. pay_mx_soe_ss_pkg.other_balances ');
343: hr_utility.trace('p_assignment_action_id '||p_assignment_action_id);
344:
345: pay_soe_util.clear;
346:
347: lv_sql := 'select balance_name COL01
348: ,nvl(reporting_name, balance_name) COL02
349: ,to_char(run_val