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_SOE_GLB dependencies on HR_UTILITY

Line 5: g_debug boolean := hr_utility.debug_enabled;

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;
6: g_max_action number;
7: g_min_action number;
8:
9: --

Line 72: hr_utility.set_location('Entering pay_soe_glb.setParameters', 10);

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

Line 128: hr_utility.trace('p_payroll_id = ' || p.payroll_id);

124: 'PREPAY_MIN_ACTION:' ||l_min_action ||':'||
125: 'CURRENCY_NAME:' ||p.currency_name ||':'||
126: 'ASSIGNMENT_ACTION_ID:'||p_assignment_action_id||':';
127: if g_debug then
128: hr_utility.trace('p_payroll_id = ' || p.payroll_id);
129: hr_utility.trace('jsqldate = ' || p.jsqldate);
130: hr_utility.trace('effective_date = ' || p.effective_date);
131: hr_utility.trace('assignment_id = ' || p.assignment_id);
132: hr_utility.trace('business_group_id = ' || p.business_group_id);

Line 129: hr_utility.trace('jsqldate = ' || p.jsqldate);

125: 'CURRENCY_NAME:' ||p.currency_name ||':'||
126: 'ASSIGNMENT_ACTION_ID:'||p_assignment_action_id||':';
127: if g_debug then
128: hr_utility.trace('p_payroll_id = ' || p.payroll_id);
129: hr_utility.trace('jsqldate = ' || p.jsqldate);
130: hr_utility.trace('effective_date = ' || p.effective_date);
131: hr_utility.trace('assignment_id = ' || p.assignment_id);
132: hr_utility.trace('business_group_id = ' || p.business_group_id);
133: hr_utility.trace('tax_unit_id = ' || p.tax_unit_id);

Line 130: hr_utility.trace('effective_date = ' || p.effective_date);

126: 'ASSIGNMENT_ACTION_ID:'||p_assignment_action_id||':';
127: if g_debug then
128: hr_utility.trace('p_payroll_id = ' || p.payroll_id);
129: hr_utility.trace('jsqldate = ' || p.jsqldate);
130: hr_utility.trace('effective_date = ' || p.effective_date);
131: hr_utility.trace('assignment_id = ' || p.assignment_id);
132: hr_utility.trace('business_group_id = ' || p.business_group_id);
133: hr_utility.trace('tax_unit_id = ' || p.tax_unit_id);
134: hr_utility.trace('g_currency_code = ' || g_currency_code);

Line 131: hr_utility.trace('assignment_id = ' || p.assignment_id);

127: if g_debug then
128: hr_utility.trace('p_payroll_id = ' || p.payroll_id);
129: hr_utility.trace('jsqldate = ' || p.jsqldate);
130: hr_utility.trace('effective_date = ' || p.effective_date);
131: hr_utility.trace('assignment_id = ' || p.assignment_id);
132: hr_utility.trace('business_group_id = ' || p.business_group_id);
133: hr_utility.trace('tax_unit_id = ' || p.tax_unit_id);
134: hr_utility.trace('g_currency_code = ' || g_currency_code);
135: hr_utility.trace('action_clause = ' || l_actions);

Line 132: hr_utility.trace('business_group_id = ' || p.business_group_id);

128: hr_utility.trace('p_payroll_id = ' || p.payroll_id);
129: hr_utility.trace('jsqldate = ' || p.jsqldate);
130: hr_utility.trace('effective_date = ' || p.effective_date);
131: hr_utility.trace('assignment_id = ' || p.assignment_id);
132: hr_utility.trace('business_group_id = ' || p.business_group_id);
133: hr_utility.trace('tax_unit_id = ' || p.tax_unit_id);
134: hr_utility.trace('g_currency_code = ' || g_currency_code);
135: hr_utility.trace('action_clause = ' || l_actions);
136: end if;

Line 133: hr_utility.trace('tax_unit_id = ' || p.tax_unit_id);

129: hr_utility.trace('jsqldate = ' || p.jsqldate);
130: hr_utility.trace('effective_date = ' || p.effective_date);
131: hr_utility.trace('assignment_id = ' || p.assignment_id);
132: hr_utility.trace('business_group_id = ' || p.business_group_id);
133: hr_utility.trace('tax_unit_id = ' || p.tax_unit_id);
134: hr_utility.trace('g_currency_code = ' || g_currency_code);
135: hr_utility.trace('action_clause = ' || l_actions);
136: end if;
137: g_currency_code := p.currency_code;

Line 134: hr_utility.trace('g_currency_code = ' || g_currency_code);

130: hr_utility.trace('effective_date = ' || p.effective_date);
131: hr_utility.trace('assignment_id = ' || p.assignment_id);
132: hr_utility.trace('business_group_id = ' || p.business_group_id);
133: hr_utility.trace('tax_unit_id = ' || p.tax_unit_id);
134: hr_utility.trace('g_currency_code = ' || g_currency_code);
135: hr_utility.trace('action_clause = ' || l_actions);
136: end if;
137: g_currency_code := p.currency_code;
138: l_action_type := p.action_type;

Line 135: hr_utility.trace('action_clause = ' || l_actions);

131: hr_utility.trace('assignment_id = ' || p.assignment_id);
132: hr_utility.trace('business_group_id = ' || p.business_group_id);
133: hr_utility.trace('tax_unit_id = ' || p.tax_unit_id);
134: hr_utility.trace('g_currency_code = ' || g_currency_code);
135: hr_utility.trace('action_clause = ' || l_actions);
136: end if;
137: g_currency_code := p.currency_code;
138: l_action_type := p.action_type;
139: end loop;

Line 150: hr_utility.trace('l_parameters = ' || l_parameters);

146: ' in ('||l_actions ||')' ||':';
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;

Line 151: hr_utility.set_location('Leaving pay_soe_glb.setParameters', 20);

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;

Line 191: hr_utility.set_location('Entering pay_soe_glb.setParameters', 10);

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

Line 228: hr_utility.set_location('Entering pay_soe_glb.Employee', 10);

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

Line 295: hr_utility.set_location('Leaving pay_soe_glb.Employee', 20);

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: --

Line 321: hr_utility.set_location('Entering pay_soe_glb.Period', 10);

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;

Line 411: hr_utility.set_location('Leaving pay_soe_glb.Period', 20);

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;

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

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

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

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: --

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

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,

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

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;

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

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;

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

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';

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

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

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

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

Line 884: hr_utility.trace('in getInformation' || p_element_set_name || p_assignment_action_id);

880: function getInformation(p_assignment_action_id number
881: ,p_element_set_name varchar2) return long is
882: begin
883: --
884: hr_utility.trace('in getInformation' || p_element_set_name || p_assignment_action_id);
885: --
886: -- Bugfix 7527825
887: -- Added nvl(oi.org_information7, to COL02
888: --

Line 1018: hr_utility.trace('Entering elements1');

1014: Text
1015: ------------------------------------------------------------------------ */
1016: function Elements1(p_assignment_action_id number) return long is
1017: begin
1018: hr_utility.trace('Entering elements1');
1019: return getElements(p_assignment_action_id
1020: ,pay_soe_util.getConfig('ELEMENTS1'));
1021: hr_utility.trace('Leaving Elements1');
1022: end Elements1;

Line 1021: hr_utility.trace('Leaving Elements1');

1017: begin
1018: hr_utility.trace('Entering elements1');
1019: return getElements(p_assignment_action_id
1020: ,pay_soe_util.getConfig('ELEMENTS1'));
1021: hr_utility.trace('Leaving Elements1');
1022: end Elements1;
1023: --
1024: /* ---------------------------------------------------------------------
1025: Function : SetParameters

Line 1092: hr_utility.trace('in Information1');

1088: Text
1089: ------------------------------------------------------------------------ */
1090: function Information1(p_assignment_action_id number) return long is
1091: begin
1092: hr_utility.trace('in Information1');
1093: return getInformation(p_assignment_action_id
1094: ,pay_soe_util.getConfig('INFORMATION1'));
1095: end Information1;
1096: --

Line 1246: hr_utility.set_location('Entering: '||l_period_obtained_flag,1);

1242:
1243:
1244: begin
1245: l_period_obtained_flag:=1;
1246: hr_utility.set_location('Entering: '||l_period_obtained_flag,1);
1247:
1248: OPEN c_get_creator_type(p_element_entry_id,p_date_earned);
1249: FETCH c_get_creator_type INTO l_creator_type ;
1250: CLOSE c_get_creator_type;

Line 1289: hr_utility.set_location('Entering element entry id: '||p_element_entry_id,4);

1285: CLOSE get_retro_period_ee;
1286: l_period_obtained_flag:=1;
1287: end if;
1288:
1289: hr_utility.set_location('Entering element entry id: '||p_element_entry_id,4);
1290: hr_utility.set_location('Entering start date earned : '||p_date_earned,5);
1291: hr_utility.set_location('Entering period obtained flag: '||l_period_obtained_flag,6);
1292:
1293: if p_call_type = 1 then

Line 1290: hr_utility.set_location('Entering start date earned : '||p_date_earned,5);

1286: l_period_obtained_flag:=1;
1287: end if;
1288:
1289: hr_utility.set_location('Entering element entry id: '||p_element_entry_id,4);
1290: hr_utility.set_location('Entering start date earned : '||p_date_earned,5);
1291: hr_utility.set_location('Entering period obtained flag: '||l_period_obtained_flag,6);
1292:
1293: if p_call_type = 1 then
1294: return l_retro_start_date;

Line 1291: hr_utility.set_location('Entering period obtained flag: '||l_period_obtained_flag,6);

1287: end if;
1288:
1289: hr_utility.set_location('Entering element entry id: '||p_element_entry_id,4);
1290: hr_utility.set_location('Entering start date earned : '||p_date_earned,5);
1291: hr_utility.set_location('Entering period obtained flag: '||l_period_obtained_flag,6);
1292:
1293: if p_call_type = 1 then
1294: return l_retro_start_date;
1295: elsif p_call_type = 2 then