[Home] [Help]
1: package body PAY_SOE_GLB as
2: /* $Header: pysoeglb.pkb 120.15.12020000.2 2012/10/15 12:26:10 bklingam ship $ */
3: --
4: l_sql long;
5: g_debug boolean := hr_utility.debug_enabled;
68: --
69: begin
70: --
71: if g_debug then
72: hr_utility.set_location('Entering pay_soe_glb.setParameters', 10);
73: end if;
74: --
75: -- Prepay change
76: select action_type
147: end if;
148: --
149: if g_debug then
150: hr_utility.trace('l_parameters = ' || l_parameters);
151: hr_utility.set_location('Leaving pay_soe_glb.setParameters', 20);
152: end if;
153: --
154: return l_parameters;
155: end;
187: l_assignment_id number;
188: begin
189: --
190: if g_debug then
191: hr_utility.set_location('Entering pay_soe_glb.setParameters', 10);
192: end if;
193: --
194: l_assignment_id := p_assignment_id;
195: if l_assignment_id is null then
207: * null, so we are passing -1 to java layer to raise error message.*/
208: if (l_assignment_action_id is null) then
209: return '-1';
210: else
211: return pay_soe_glb.setParameters(l_assignment_action_id);
212: end if;
213: --
214: end;
215: --
224: --
225: begin
226: --
227: if g_debug then
228: hr_utility.set_location('Entering pay_soe_glb.Employee', 10);
229: end if;
230: --
231: l_sql :=
232: 'Select org.name COL01
291: and hl.lookup_code (+) =peo.nationality';
292: --
293: --
294: if g_debug then
295: hr_utility.set_location('Leaving pay_soe_glb.Employee', 20);
296: end if;
297: --
298: return l_sql;
299: --
317:
318: begin
319: --
320: if g_debug then
321: hr_utility.set_location('Entering pay_soe_glb.Period', 10);
322: end if;
323: --
324:
325: open periodDates;
407: end if;
408: --
409: --
410: if g_debug then
411: hr_utility.set_location('Leaving pay_soe_glb.Period', 20);
412: end if;
413: --
414: return l_sql;
415: end Period;
424: begin
425: --
426: --
427: if g_debug then
428: hr_utility.set_location('Entering pay_soe_glb.getElements', 10);
429: end if;
430: --
431: -- Bugfix 5724212
432: -- Return null if p_element_set_name is NULL (since the SQL statement below
538: end if;
539: --
540: --
541: if g_debug then
542: hr_utility.set_location('Leaving pay_soe_glb.getElements', 20);
543: end if;
544: --
545: return l_sql;
546: --
684: --
685: begin
686: --
687: if g_debug then
688: hr_utility.set_location('Entering pay_soe_glb.getBalances', 10);
689: end if;
690: --
691: open getAction;
692: fetch getAction into l_payroll_id,
706: --
707: i := 0;
708: --
709: if g_debug then
710: hr_utility.set_location('pay_soe_glb.getBalances', 20);
711: end if;
712: --
713: for db in getDBal loop
714: i := i + 1;
739: --
740: i := 0;
741: if l_save_asg_run_bal = 'Y' then
742: if g_debug then
743: hr_utility.set_location('pay_soe_glb.getBalances', 30);
744: end if;
745: for ctx in getRBContexts loop
746: i := i + 1;
747: l_context_lst(i).TAX_UNIT_ID := ctx.TAX_UNIT_ID;
752: l_context_lst(i).SOURCE_TEXT2 := ctx.SOURCE_TEXT2;
753: end loop;
754: else
755: if g_debug then
756: hr_utility.set_location('pay_soe_glb.getBalances', 40);
757: end if;
758: -- Check whether the SOURCE_ID, SOURCE_TEXT contexts are used.
759: l_si_needed_chr := 'N';
760: l_st_needed_chr := 'N';
806: end if;
807: --
808: --
809: if g_debug then
810: hr_utility.set_location('pay_soe_glb.getBalances', 50);
811: end if;
812: --
813: pay_balance_pkg.get_value (p_assignment_action_id => p_assignment_action_id
814: ,p_defined_balance_lst => l_defined_balance_lst
820: balCount := 0;
821: if l_output_table.count > 0 then
822: --
823: if g_debug then
824: hr_utility.set_location('pay_soe_glb.getBalances', 60);
825: end if;
826: --
827: for i in l_output_table.first..l_output_table.last loop
828: if l_output_table(i).balance_value <> 0 then
1298: return l_period_num_year;
1299: end if;
1300: end get_retro_period;
1301:
1302: end pay_soe_glb;