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_MX_SOE_SS_PKG dependencies on PAY_MX_SOE_SS_PKG

Line 1: package body pay_mx_soe_ss_pkg as

1: package body pay_mx_soe_ss_pkg as
2: /* $Header: paymxsoe.pkb 120.4 2012/01/19 08:10:37 rpahune ship $ */
3: --
4: /*
5: /*

Line 66: hr_utility.trace('Entering.. pay_mx_soe_ss_pkg.employee_earnings ');

62: FUNCTION employee_earnings( p_assignment_action_id in NUMBER )
63: RETURN CLOB IS
64: BEGIN
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:

Line 81: hr_utility.trace('Leaving.. pay_mx_soe_ss_pkg.employee_earnings ');

77: from PAY_MX_EMPLOYEE_EARNINGS_V
78: where assignment_action_id :action_clause
79: and earn_run_val <> 0';
80:
81: hr_utility.trace('Leaving.. pay_mx_soe_ss_pkg.employee_earnings ');
82:
83: return lv_sql;
84:
85: END employee_earnings;

Line 91: hr_utility.trace('Entering.. pay_mx_soe_ss_pkg.employee_taxes ');

87: FUNCTION employee_taxes( p_assignment_action_id in NUMBER )
88: RETURN CLOB IS
89: BEGIN
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:

Line 104: hr_utility.trace('Leaving.. pay_mx_soe_ss_pkg.employee_taxes ');

100: from PAY_MX_EMPLOYEE_TAXES_V
101: where assignment_action_id :action_clause
102: and run_val <> 0';
103:
104: hr_utility.trace('Leaving.. pay_mx_soe_ss_pkg.employee_taxes ');
105:
106: return lv_sql;
107:
108: END employee_taxes;

Line 114: hr_utility.trace('Entering.. pay_mx_soe_ss_pkg.tax_calc_details ');

110: FUNCTION tax_calc_details( p_assignment_action_id in NUMBER )
111: RETURN CLOB IS
112: BEGIN
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:

Line 127: hr_utility.trace('Leaving.. pay_mx_soe_ss_pkg.tax_calc_details ');

123: from PAY_MX_TAX_CALC_DETAILS_V
124: where assignment_action_id :action_clause
125: and run_val <> 0';
126:
127: hr_utility.trace('Leaving.. pay_mx_soe_ss_pkg.tax_calc_details ');
128:
129: return lv_sql;
130:
131: END tax_calc_details;

Line 160: hr_utility.trace('Entering.. pay_mx_soe_ss_pkg.mx_summary_balances ');

156:
157: summary summary_bal;
158:
159: BEGIN
160: hr_utility.trace('Entering.. pay_mx_soe_ss_pkg.mx_summary_balances ');
161: hr_utility.trace('p_assignment_action_id '||p_assignment_action_id);
162: hr_utility.trace('lv_currency_code '||lv_currency_code);
163:
164: open c_tax_unit(p_assignment_action_id);

Line 238: hr_utility.trace('Leaving.. pay_mx_soe_ss_pkg.mx_summary_balances ');

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 ');
239:
240: return pay_soe_util.genCursor;
241:
242: END summary_balances;

Line 248: hr_utility.trace('Entering.. pay_mx_soe_ss_pkg.hourly_earnings ');

244: FUNCTION hourly_earnings( p_assignment_action_id in NUMBER )
245: RETURN CLOB IS
246: BEGIN
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:

Line 263: hr_utility.trace('Leaving.. pay_mx_soe_ss_pkg.employee_earnings ');

259: from PAY_MX_HOURLY_EARNINGS_V
260: where assignment_action_id :action_clause
261: and earn_run_val <> 0';
262:
263: hr_utility.trace('Leaving.. pay_mx_soe_ss_pkg.employee_earnings ');
264:
265: return lv_sql;
266:
267: END hourly_earnings;

Line 273: hr_utility.trace('Entering.. pay_mx_soe_ss_pkg.taxable_benefits ');

269: FUNCTION taxable_benefits( p_assignment_action_id in NUMBER )
270: RETURN CLOB IS
271: BEGIN
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:

Line 286: hr_utility.trace('Leaving.. pay_mx_soe_ss_pkg.tax_calc_details ');

282: from PAY_MX_TAXABLE_BENEFITS_V
283: where assignment_action_id :action_clause
284: and run_val <> 0';
285:
286: hr_utility.trace('Leaving.. pay_mx_soe_ss_pkg.tax_calc_details ');
287:
288: return lv_sql;
289:
290: END taxable_benefits;

Line 296: hr_utility.trace('Entering.. pay_mx_soe_ss_pkg.tax_balances ');

292: FUNCTION tax_balances( p_assignment_action_id in NUMBER )
293: RETURN CLOB IS
294: BEGIN
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:

Line 309: hr_utility.trace('Leaving.. pay_mx_soe_ss_pkg.tax_calc_details ');

305: from PAY_MX_TAX_BALANCES_V
306: where assignment_action_id :action_clause
307: and run_val <> 0';
308:
309: hr_utility.trace('Leaving.. pay_mx_soe_ss_pkg.tax_calc_details ');
310:
311: return lv_sql;
312:
313: END tax_balances;

Line 319: hr_utility.trace('Entering.. pay_mx_soe_ss_pkg.deductions ');

315: FUNCTION deductions( p_assignment_action_id in NUMBER )
316: RETURN CLOB IS
317: BEGIN
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:

Line 332: hr_utility.trace('Leaving.. pay_mx_soe_ss_pkg.tax_calc_details ');

328: from PAY_MX_DEDUCTIONS_V
329: where assignment_action_id :action_clause
330: and run_val <> 0';
331:
332: hr_utility.trace('Leaving.. pay_mx_soe_ss_pkg.tax_calc_details ');
333:
334: return lv_sql;
335:
336: END deductions;

Line 342: hr_utility.trace('Entering.. pay_mx_soe_ss_pkg.other_balances ');

338: FUNCTION other_balances( p_assignment_action_id in NUMBER )
339: RETURN CLOB IS
340: BEGIN
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:

Line 358: hr_utility.trace('Leaving.. pay_mx_soe_ss_pkg.tax_calc_details ');

354: ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL18
355: from PAY_MX_OTHER_BALANCES_V
356: where assignment_action_id :action_clause';
357:
358: hr_utility.trace('Leaving.. pay_mx_soe_ss_pkg.tax_calc_details ');
359:
360: return lv_sql;
361:
362: END other_balances;

Line 554: END pay_mx_soe_ss_pkg;

550:
551: BEGIN
552: -- hr_utility.trace_on(NULL, 'DEBUG');
553: lv_currency_code := 'MXN';
554: END pay_mx_soe_ss_pkg;