DBA Data[Home] [Help]

APPS.PAY_NL_SOE dependencies on PAY_SOE_GLB

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

284: begin
285: --
286: --
287: if g_debug then
288: hr_utility.set_location('Entering pay_soe_glb.getElements', 10);
289: end if;
290: --
291: l_sql :=
292: 'select nvl(ettl.reporting_name,et.element_type_id) COL01

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

337: order by nvl(ettl.reporting_name,ettl.element_name),nvl(ettl.reporting_name,et.element_type_id)';
338: --
339: --
340: if g_debug then
341: hr_utility.set_location('Leaving pay_soe_glb.getElements', 20);
342: end if;
343: --
344: return l_sql;
345: --

Line 364: similar to Core Function - pay_soe_glb.getBalances

360: /* ---------------------------------------------------------------------
361: Function : getBalances
362:
363: Text : Constructs the SQL for the Balances and YTD Values Region of SOE
364: similar to Core Function - pay_soe_glb.getBalances
365: Only difference-Returns SI Type Name by calling
366: pay_nl_general.get_sit_type_name
367: ------------------------------------------------------------------------ */
368: function getBalances(p_assignment_action_id number

Line 522: hr_utility.set_location('Entering pay_soe_glb.getBalances', 10);

518: --
519: begin
520: --
521: if g_debug then
522: hr_utility.set_location('Entering pay_soe_glb.getBalances', 10);
523: end if;
524: --
525: open getAction;
526: fetch getAction into l_payroll_id,

Line 540: hr_utility.set_location('pay_soe_glb.getBalances', 20);

536: --
537: i := 0;
538: --
539: if g_debug then
540: hr_utility.set_location('pay_soe_glb.getBalances', 20);
541: end if;
542: --
543: open getLockedActionid;
544: fetch getLockedActionid into locked_assignment_action_id;

Line 582: hr_utility.set_location('pay_soe_glb.getBalances', 30);

578: --
579: i := 0;
580: if l_save_asg_run_bal = 'Y' then
581: if g_debug then
582: hr_utility.set_location('pay_soe_glb.getBalances', 30);
583: end if;
584: for ctx in getRBContexts loop
585: i := i + 1;
586: l_context_lst(i).TAX_UNIT_ID := ctx.TAX_UNIT_ID;

Line 595: hr_utility.set_location('pay_soe_glb.getBalances', 40);

591: l_context_lst(i).SOURCE_TEXT2 := ctx.SOURCE_TEXT2;
592: end loop;
593: else
594: if g_debug then
595: hr_utility.set_location('pay_soe_glb.getBalances', 40);
596: end if;
597: -- Check whether the SOURCE_ID, SOURCE_TEXT contexts are used.
598: l_si_needed_chr := 'N';
599: l_st_needed_chr := 'N';

Line 649: hr_utility.set_location('pay_soe_glb.getBalances', 50);

645: end if;
646: --
647: --
648: if g_debug then
649: hr_utility.set_location('pay_soe_glb.getBalances', 50);
650: end if;
651: --
652: pay_balance_pkg.get_value (p_assignment_action_id => p_assignment_action_id
653: ,p_defined_balance_lst => l_defined_balance_lst

Line 663: hr_utility.set_location('pay_soe_glb.getBalances', 60);

659: balCount := 0;
660: if l_output_table.count > 0 then
661: --
662: if g_debug then
663: hr_utility.set_location('pay_soe_glb.getBalances', 60);
664: end if;
665: --
666: for i in l_output_table.first..l_output_table.last loop
667: if l_output_table(i).balance_value <> 0 then

Line 714: fnd_currency.get_format_mask(substr(PAY_SOE_GLB.g_currency_code,2,3),40)),FALSE,FALSE);

710: /* end Bug 4253982 */
711: END IF;
712: pay_soe_util.setValue('12',l_si_type_name,FALSE,FALSE);
713: pay_soe_util.setValue(16,to_char(l_output_table(i).balance_value,
714: fnd_currency.get_format_mask(substr(PAY_SOE_GLB.g_currency_code,2,3),40)),FALSE,FALSE);
715: pay_soe_util.setValue(17,to_char(l_output_table(i).defined_balance_id),FALSE,TRUE);
716:
717: end if;
718: end loop;