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.1 2005/08/22 11:47:41 vmehta noship $ */
3: --
4: /*
5: /*

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

57: FUNCTION employee_earnings( p_assignment_action_id in NUMBER )
58: RETURN LONG IS
59: BEGIN
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:

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

72: from PAY_MX_EMPLOYEE_EARNINGS_V
73: where assignment_action_id :action_clause
74: and earn_run_val <> 0';
75:
76: hr_utility.trace('Leaving.. pay_mx_soe_ss_pkg.employee_earnings ');
77:
78: return lv_sql;
79:
80: END employee_earnings;

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

82: FUNCTION employee_taxes( p_assignment_action_id in NUMBER )
83: RETURN LONG IS
84: BEGIN
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:

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

95: from PAY_MX_EMPLOYEE_TAXES_V
96: where assignment_action_id :action_clause
97: and run_val <> 0';
98:
99: hr_utility.trace('Leaving.. pay_mx_soe_ss_pkg.employee_taxes ');
100:
101: return lv_sql;
102:
103: END employee_taxes;

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

105: FUNCTION tax_calc_details( p_assignment_action_id in NUMBER )
106: RETURN LONG IS
107: BEGIN
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:

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

118: from PAY_MX_TAX_CALC_DETAILS_V
119: where assignment_action_id :action_clause
120: and run_val <> 0';
121:
122: hr_utility.trace('Leaving.. pay_mx_soe_ss_pkg.tax_calc_details ');
123:
124: return lv_sql;
125:
126: END tax_calc_details;

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

151:
152: summary summary_bal;
153:
154: BEGIN
155: hr_utility.trace('Entering.. pay_mx_soe_ss_pkg.mx_summary_balances ');
156: hr_utility.trace('p_assignment_action_id '||p_assignment_action_id);
157: hr_utility.trace('lv_currency_code '||lv_currency_code);
158:
159: open c_tax_unit(p_assignment_action_id);

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

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 ');
234:
235: return pay_soe_util.genCursor;
236:
237: END summary_balances;

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

239: FUNCTION hourly_earnings( p_assignment_action_id in NUMBER )
240: RETURN LONG IS
241: BEGIN
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:

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

254: from PAY_MX_HOURLY_EARNINGS_V
255: where assignment_action_id :action_clause
256: and earn_run_val <> 0';
257:
258: hr_utility.trace('Leaving.. pay_mx_soe_ss_pkg.employee_earnings ');
259:
260: return lv_sql;
261:
262: END hourly_earnings;

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

264: FUNCTION taxable_benefits( p_assignment_action_id in NUMBER )
265: RETURN LONG IS
266: BEGIN
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:

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

277: from PAY_MX_TAXABLE_BENEFITS_V
278: where assignment_action_id :action_clause
279: and run_val <> 0';
280:
281: hr_utility.trace('Leaving.. pay_mx_soe_ss_pkg.tax_calc_details ');
282:
283: return lv_sql;
284:
285: END taxable_benefits;

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

287: FUNCTION tax_balances( p_assignment_action_id in NUMBER )
288: RETURN LONG IS
289: BEGIN
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:

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

300: from PAY_MX_TAX_BALANCES_V
301: where assignment_action_id :action_clause
302: and run_val <> 0';
303:
304: hr_utility.trace('Leaving.. pay_mx_soe_ss_pkg.tax_calc_details ');
305:
306: return lv_sql;
307:
308: END tax_balances;

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

310: FUNCTION deductions( p_assignment_action_id in NUMBER )
311: RETURN LONG IS
312: BEGIN
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:

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

323: from PAY_MX_DEDUCTIONS_V
324: where assignment_action_id :action_clause
325: and run_val <> 0';
326:
327: hr_utility.trace('Leaving.. pay_mx_soe_ss_pkg.tax_calc_details ');
328:
329: return lv_sql;
330:
331: END deductions;

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

333: FUNCTION other_balances( p_assignment_action_id in NUMBER )
334: RETURN LONG IS
335: BEGIN
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:

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

349: ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL18
350: from PAY_MX_OTHER_BALANCES_V
351: where assignment_action_id :action_clause';
352:
353: hr_utility.trace('Leaving.. pay_mx_soe_ss_pkg.tax_calc_details ');
354:
355: return lv_sql;
356:
357: END other_balances;

Line 546: END pay_mx_soe_ss_pkg;

542:
543: BEGIN
544: -- hr_utility.trace_on(NULL, 'DEBUG');
545: lv_currency_code := 'MXN';
546: END pay_mx_soe_ss_pkg;