DBA Data[Home] [Help]

APPS.PAY_ZA_SOE dependencies on HR_UTILITY

Line 4: g_debug boolean := hr_utility.debug_enabled;

1: package body PAY_ZA_SOE as
2: /* $Header: pyzasoe.pkb 120.20.12020000.7 2012/12/07 13:55:09 sgmaram ship $ */
3: --
4: g_debug boolean := hr_utility.debug_enabled;
5: g_max_action number;
6: g_min_action number;
7:
8: --

Line 24: hr_utility.set_location('Entering pay_za_soe.Get_Tax_Status', 10);

20: --
21: begin
22: --
23: if g_debug then
24: hr_utility.set_location('Entering pay_za_soe.Get_Tax_Status', 10);
25: end if;
26: --
27:
28: pay_balance_pkg.set_context('ASSIGNMENT_ID', to_char(p_assignment_id));

Line 47: hr_utility.set_location('Leaving pay_za_soe.Get_Tax_Status', 20);

43: end;
44:
45: --
46: if g_debug then
47: hr_utility.set_location('Leaving pay_za_soe.Get_Tax_Status', 20);
48: end if;
49: --
50: return l_tax_status_name;
51: --

Line 69: hr_utility.set_location('Entering pay_soe_glb.getElements', 10);

65: begin
66: --
67: --
68: if g_debug then
69: hr_utility.set_location('Entering pay_soe_glb.getElements', 10);
70: end if;
71: --
72:
73: l_sql := 'Select nvl(ettl.reporting_name,et.element_type_id) COL01

Line 114: hr_utility.set_location('Leaving pay_soe_glb.getElements', 20);

110: having nvl(sum(fnd_number.canonical_to_number(rrv.result_value)),0) != 0
111: order by nvl(ettl.reporting_name,ettl.element_name)';
112: --
113: if g_debug then
114: hr_utility.set_location('Leaving pay_soe_glb.getElements', 20);
115: end if;
116: --
117: return l_sql;
118: --

Line 140: hr_utility.set_location('Entering pay_za_soe.Personal_Information', 10);

136: --
137: begin
138: --
139: if g_debug then
140: hr_utility.set_location('Entering pay_za_soe.Personal_Information', 10);
141: end if;
142: --
143: l_assignment_action_id := p_assignment_action_id;
144: --5507715

Line 232: hr_utility.set_location('Leaving pay_za_soe.Personal_Information', 20);

228: hl.lookup_type (+) = ''NATIONALITY'' and
229: hl.lookup_code (+) = peo.nationality';
230: --
231: if g_debug then
232: hr_utility.set_location('Leaving pay_za_soe.Personal_Information', 20);
233: end if;
234: --
235: return l_sql;
236: --

Line 258: hr_utility.set_location('Entering pay_za_soe.Payroll_Processing_Information', 10);

254: --
255: begin
256: --
257: if g_debug then
258: hr_utility.set_location('Entering pay_za_soe.Payroll_Processing_Information', 10);
259: end if;
260: --
261: l_assignment_action_id := p_assignment_action_id;
262: --5507715

Line 288: hr_utility.set_location('Leaving pay_za_soe.Payroll_Processing_Information', 20);

284: || 'to_date(''' || l_date_earned ||''','|| '''YYYY/MM/DD''' ||')' || ' between ptp.start_date and ptp.end_date and
285: ptp.period_type = ptt.period_type';
286: --
287: if g_debug then
288: hr_utility.set_location('Leaving pay_za_soe.Payroll_Processing_Information', 20);
289: end if;
290: --
291: return l_sql;
292: --

Line 310: hr_utility.set_location('Entering pay_za_soe.Elements1', 10);

306: --
307: begin
308: --
309: if g_debug then
310: hr_utility.set_location('Entering pay_za_soe.Elements1', 10);
311: end if;
312: --
313:
314: l_sql := getElements(p_assignment_action_id, pay_soe_util.getConfig('ELEMENTS1'));

Line 318: hr_utility.set_location('Leaving pay_za_soe.Elements1', 20);

314: l_sql := getElements(p_assignment_action_id, pay_soe_util.getConfig('ELEMENTS1'));
315:
316: --
317: if g_debug then
318: hr_utility.set_location('Leaving pay_za_soe.Elements1', 20);
319: end if;
320: --
321: return l_sql;
322: --

Line 340: hr_utility.set_location('Entering pay_za_soe.Elements2', 10);

336: --
337: begin
338: --
339: if g_debug then
340: hr_utility.set_location('Entering pay_za_soe.Elements2', 10);
341: end if;
342: --
343:
344: l_sql := getElements(p_assignment_action_id, pay_soe_util.getConfig('ELEMENTS2'));

Line 348: hr_utility.set_location('Leaving pay_za_soe.Elements2', 20);

344: l_sql := getElements(p_assignment_action_id, pay_soe_util.getConfig('ELEMENTS2'));
345:
346: --
347: if g_debug then
348: hr_utility.set_location('Leaving pay_za_soe.Elements2', 20);
349: end if;
350: --
351: return l_sql;
352: --

Line 370: hr_utility.set_location('Entering pay_za_soe.Elements3', 10);

366: --
367: begin
368: --
369: if g_debug then
370: hr_utility.set_location('Entering pay_za_soe.Elements3', 10);
371: end if;
372: --
373:
374: l_sql := getElements(p_assignment_action_id, pay_soe_util.getConfig('ELEMENTS3'));

Line 378: hr_utility.set_location('Leaving pay_za_soe.Elements3', 20);

374: l_sql := getElements(p_assignment_action_id, pay_soe_util.getConfig('ELEMENTS3'));
375:
376: --
377: if g_debug then
378: hr_utility.set_location('Leaving pay_za_soe.Elements3', 20);
379: end if;
380: --
381: return l_sql;
382: --

Line 400: hr_utility.set_location('Entering pay_za_soe.Elements4', 10);

396: --
397: begin
398: --
399: if g_debug then
400: hr_utility.set_location('Entering pay_za_soe.Elements4', 10);
401: end if;
402: --
403:
404: l_sql := getElements(p_assignment_action_id, pay_soe_util.getConfig('ELEMENTS4'));

Line 408: hr_utility.set_location('Leaving pay_za_soe.Elements4', 20);

404: l_sql := getElements(p_assignment_action_id, pay_soe_util.getConfig('ELEMENTS4'));
405:
406: --
407: if g_debug then
408: hr_utility.set_location('Leaving pay_za_soe.Elements4', 20);
409: end if;
410: --
411: return l_sql;
412: --

Line 430: hr_utility.set_location('Entering pay_za_soe.Elements5', 10);

426: --
427: begin
428: --
429: if g_debug then
430: hr_utility.set_location('Entering pay_za_soe.Elements5', 10);
431: end if;
432: --
433:
434: l_sql := getElements(p_assignment_action_id, pay_soe_util.getConfig('ELEMENTS5'));

Line 438: hr_utility.set_location('Leaving pay_za_soe.Elements5', 20);

434: l_sql := getElements(p_assignment_action_id, pay_soe_util.getConfig('ELEMENTS5'));
435:
436: --
437: if g_debug then
438: hr_utility.set_location('Leaving pay_za_soe.Elements5', 20);
439: end if;
440: --
441: return l_sql;
442: --

Line 460: hr_utility.set_location('Entering pay_za_soe.Elements6', 10);

456: --
457: begin
458: --
459: if g_debug then
460: hr_utility.set_location('Entering pay_za_soe.Elements6', 10);
461: end if;
462: --
463:
464: l_sql := getElements(p_assignment_action_id, pay_soe_util.getConfig('ELEMENTS6'));

Line 468: hr_utility.set_location('Leaving pay_za_soe.Elements6', 20);

464: l_sql := getElements(p_assignment_action_id, pay_soe_util.getConfig('ELEMENTS6'));
465:
466: --
467: if g_debug then
468: hr_utility.set_location('Leaving pay_za_soe.Elements6', 20);
469: end if;
470: --
471: return l_sql;
472: --

Line 537: hr_utility.set_location('Entering pay_za_soe.Balance_Details', 10);

533: --
534: begin
535: --
536: if g_debug then
537: hr_utility.set_location('Entering pay_za_soe.Balance_Details', 10);
538: end if;
539: --
540:
541: --

Line 904: hr_utility.set_location('Leaving pay_za_soe.Balance_Details', 20);

900: pay_soe_util.clear;
901: --
902: --
903: if g_debug then
904: hr_utility.set_location('Leaving pay_za_soe.Balance_Details', 20);
905: end if;
906: --
907: return l_sql;
908: --

Line 929: hr_utility.set_location('Entering pay_za_soe.Payment_Method_Details', 10);

925: --
926: begin
927:
928: if g_debug then
929: hr_utility.set_location('Entering pay_za_soe.Payment_Method_Details', 10);
930: end if;
931: l_assignment_action_id := p_assignment_action_id;
932: --5507715
933: PAY_ZA_PAYROLL_ACTION_PKG.formula_inputs_hc(

Line 977: hr_utility.set_location('Leaving pay_za_soe.Payment_Method_Details', 20);

973: popmf.payment_type_id = ppt.payment_type_id(+) and
974: ppt.language(+) = userenv(''LANG'')';
975: --
976: if g_debug then
977: hr_utility.set_location('Leaving pay_za_soe.Payment_Method_Details', 20);
978: end if;
979: --
980: return l_sql;
981: --