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.

[Home] [Help]

APPS.PAY_HK_IR56 dependencies on HR_UTILITY

Line 50: ** 15-JUN-2004 abhkumar 3626489 115.19 Added hr_utility.debug_enabled to each of three functions.

46: ** has been included.
47: ** 17-Dec-2003 srrajago 3193217 115.16 In the function 'get_emoluments' -> IF check -> Replaced '!=' with '<>' to remove GSCC error.
48: ** 09-Feb-2003 avenkatk 3417275 115.17 In the procedure 'populate_defined_balance_ids',removed references to the 4 IR56_Q quarter balances.
49: ** 14-JUN-2004 abhkumar 3626489 115.18 Removed gscc warnings.
50: ** 15-JUN-2004 abhkumar 3626489 115.19 Added hr_utility.debug_enabled to each of three functions.
51: ** 15-JUN-2004 abhkumar 3626489 115.20 Commented hr_utility.debug_enabled and initialised g_debug to FALSE.
52: ** 31-JAN-2005 JLin 3609072 115.21 Modified to be able to run the balance retrieval batch mode.
53: ** 14-Dec-2005 snimmala 4864213 115.22 Added a new function get_quarters_start_date and is used in the view
54: ** pay_hk_ir56_quarters_info_v.

Line 51: ** 15-JUN-2004 abhkumar 3626489 115.20 Commented hr_utility.debug_enabled and initialised g_debug to FALSE.

47: ** 17-Dec-2003 srrajago 3193217 115.16 In the function 'get_emoluments' -> IF check -> Replaced '!=' with '<>' to remove GSCC error.
48: ** 09-Feb-2003 avenkatk 3417275 115.17 In the procedure 'populate_defined_balance_ids',removed references to the 4 IR56_Q quarter balances.
49: ** 14-JUN-2004 abhkumar 3626489 115.18 Removed gscc warnings.
50: ** 15-JUN-2004 abhkumar 3626489 115.19 Added hr_utility.debug_enabled to each of three functions.
51: ** 15-JUN-2004 abhkumar 3626489 115.20 Commented hr_utility.debug_enabled and initialised g_debug to FALSE.
52: ** 31-JAN-2005 JLin 3609072 115.21 Modified to be able to run the balance retrieval batch mode.
53: ** 14-Dec-2005 snimmala 4864213 115.22 Added a new function get_quarters_start_date and is used in the view
54: ** pay_hk_ir56_quarters_info_v.
55: ** 09-Jan-2005 vborhade 4688776 115.23 Modified procedure get_emoluments for period end date.

Line 135: /Bug# 3626489 g_debug := hr_utility.debug_enabled;/

131: AND paf.period_of_service_id = pps.period_of_service_id; /* Bug No : 2850738 */
132:
133: BEGIN
134:
135: /*Bug# 3626489 g_debug := hr_utility.debug_enabled;*/
136: g_debug := FALSE;
137:
138: IF g_debug THEN
139: hr_utility.trace('Leaving:' || 'pay_hk_ir56.get_emoluments');

Line 139: hr_utility.trace('Leaving:' || 'pay_hk_ir56.get_emoluments');

135: /*Bug# 3626489 g_debug := hr_utility.debug_enabled;*/
136: g_debug := FALSE;
137:
138: IF g_debug THEN
139: hr_utility.trace('Leaving:' || 'pay_hk_ir56.get_emoluments');
140: hr_utility.trace('Values of the input parameters');
141: hr_utility.trace('------------------------------');
142: hr_utility.trace('Assignment id' || ' =>' || p_assignment_id);
143: hr_utility.trace('Assignment Action Id' || '=>' || p_assignment_action_id);

Line 140: hr_utility.trace('Values of the input parameters');

136: g_debug := FALSE;
137:
138: IF g_debug THEN
139: hr_utility.trace('Leaving:' || 'pay_hk_ir56.get_emoluments');
140: hr_utility.trace('Values of the input parameters');
141: hr_utility.trace('------------------------------');
142: hr_utility.trace('Assignment id' || ' =>' || p_assignment_id);
143: hr_utility.trace('Assignment Action Id' || '=>' || p_assignment_action_id);
144: hr_utility.trace('Tax Unit Id' || ' =>' || p_tax_unit_id);

Line 141: hr_utility.trace('------------------------------');

137:
138: IF g_debug THEN
139: hr_utility.trace('Leaving:' || 'pay_hk_ir56.get_emoluments');
140: hr_utility.trace('Values of the input parameters');
141: hr_utility.trace('------------------------------');
142: hr_utility.trace('Assignment id' || ' =>' || p_assignment_id);
143: hr_utility.trace('Assignment Action Id' || '=>' || p_assignment_action_id);
144: hr_utility.trace('Tax Unit Id' || ' =>' || p_tax_unit_id);
145: hr_utility.trace('Reporting Year' || ' =>' || p_reporting_year);

Line 142: hr_utility.trace('Assignment id' || ' =>' || p_assignment_id);

138: IF g_debug THEN
139: hr_utility.trace('Leaving:' || 'pay_hk_ir56.get_emoluments');
140: hr_utility.trace('Values of the input parameters');
141: hr_utility.trace('------------------------------');
142: hr_utility.trace('Assignment id' || ' =>' || p_assignment_id);
143: hr_utility.trace('Assignment Action Id' || '=>' || p_assignment_action_id);
144: hr_utility.trace('Tax Unit Id' || ' =>' || p_tax_unit_id);
145: hr_utility.trace('Reporting Year' || ' =>' || p_reporting_year);
146: END IF;

Line 143: hr_utility.trace('Assignment Action Id' || '=>' || p_assignment_action_id);

139: hr_utility.trace('Leaving:' || 'pay_hk_ir56.get_emoluments');
140: hr_utility.trace('Values of the input parameters');
141: hr_utility.trace('------------------------------');
142: hr_utility.trace('Assignment id' || ' =>' || p_assignment_id);
143: hr_utility.trace('Assignment Action Id' || '=>' || p_assignment_action_id);
144: hr_utility.trace('Tax Unit Id' || ' =>' || p_tax_unit_id);
145: hr_utility.trace('Reporting Year' || ' =>' || p_reporting_year);
146: END IF;
147:

Line 144: hr_utility.trace('Tax Unit Id' || ' =>' || p_tax_unit_id);

140: hr_utility.trace('Values of the input parameters');
141: hr_utility.trace('------------------------------');
142: hr_utility.trace('Assignment id' || ' =>' || p_assignment_id);
143: hr_utility.trace('Assignment Action Id' || '=>' || p_assignment_action_id);
144: hr_utility.trace('Tax Unit Id' || ' =>' || p_tax_unit_id);
145: hr_utility.trace('Reporting Year' || ' =>' || p_reporting_year);
146: END IF;
147:
148: populate_defined_balance_ids;

Line 145: hr_utility.trace('Reporting Year' || ' =>' || p_reporting_year);

141: hr_utility.trace('------------------------------');
142: hr_utility.trace('Assignment id' || ' =>' || p_assignment_id);
143: hr_utility.trace('Assignment Action Id' || '=>' || p_assignment_action_id);
144: hr_utility.trace('Tax Unit Id' || ' =>' || p_tax_unit_id);
145: hr_utility.trace('Reporting Year' || ' =>' || p_reporting_year);
146: END IF;
147:
148: populate_defined_balance_ids;
149:

Line 151: hr_utility.trace('Balance Name Balance Value');

147:
148: populate_defined_balance_ids;
149:
150: IF g_debug THEN
151: hr_utility.trace('Balance Name Balance Value');
152: hr_utility.trace('----------------------------------------------');
153: END IF;
154:
155: IF ((p_assignment_action_id IS NOT NULL) AND (p_assignment_action_id <> 0)) THEN

Line 152: hr_utility.trace('----------------------------------------------');

148: populate_defined_balance_ids;
149:
150: IF g_debug THEN
151: hr_utility.trace('Balance Name Balance Value');
152: hr_utility.trace('----------------------------------------------');
153: END IF;
154:
155: IF ((p_assignment_action_id IS NOT NULL) AND (p_assignment_action_id <> 0)) THEN
156:

Line 161: hr_utility.trace('Jay get_value');

157:
158: /* Bug 3609072 */
159: p_context_table(1).tax_unit_id := p_tax_unit_id;
160:
161: hr_utility.trace('Jay get_value');
162: pay_balance_pkg.get_value(p_assignment_action_id => p_assignment_action_id
163: ,p_defined_balance_lst => p_balance_value_tab
164: ,p_context_lst => p_context_table
165: ,p_output_table => p_result_table);

Line 194: hr_utility.trace('Financial Year Start Date' || '=>' || l_fin_start_date);

190: FETCH csr_hire_date INTO l_hire_date,l_actual_termination_date;
191: CLOSE csr_hire_date;
192:
193: IF g_debug THEN
194: hr_utility.trace('Financial Year Start Date' || '=>' || l_fin_start_date);
195: hr_utility.trace('Financial Year End Date' || '=>' || l_fin_end_date);
196: hr_utility.trace('Hire Date' || ' =>' || l_hire_date);
197: hr_utility.trace('Actual Termination Date' || ' =>' || l_actual_termination_date);
198: hr_utility.trace(' ');

Line 195: hr_utility.trace('Financial Year End Date' || '=>' || l_fin_end_date);

191: CLOSE csr_hire_date;
192:
193: IF g_debug THEN
194: hr_utility.trace('Financial Year Start Date' || '=>' || l_fin_start_date);
195: hr_utility.trace('Financial Year End Date' || '=>' || l_fin_end_date);
196: hr_utility.trace('Hire Date' || ' =>' || l_hire_date);
197: hr_utility.trace('Actual Termination Date' || ' =>' || l_actual_termination_date);
198: hr_utility.trace(' ');
199: hr_utility.trace('Balance name Period Dates Particulars');

Line 196: hr_utility.trace('Hire Date' || ' =>' || l_hire_date);

192:
193: IF g_debug THEN
194: hr_utility.trace('Financial Year Start Date' || '=>' || l_fin_start_date);
195: hr_utility.trace('Financial Year End Date' || '=>' || l_fin_end_date);
196: hr_utility.trace('Hire Date' || ' =>' || l_hire_date);
197: hr_utility.trace('Actual Termination Date' || ' =>' || l_actual_termination_date);
198: hr_utility.trace(' ');
199: hr_utility.trace('Balance name Period Dates Particulars');
200: hr_utility.trace('------------------------------------------------------------------');

Line 197: hr_utility.trace('Actual Termination Date' || ' =>' || l_actual_termination_date);

193: IF g_debug THEN
194: hr_utility.trace('Financial Year Start Date' || '=>' || l_fin_start_date);
195: hr_utility.trace('Financial Year End Date' || '=>' || l_fin_end_date);
196: hr_utility.trace('Hire Date' || ' =>' || l_hire_date);
197: hr_utility.trace('Actual Termination Date' || ' =>' || l_actual_termination_date);
198: hr_utility.trace(' ');
199: hr_utility.trace('Balance name Period Dates Particulars');
200: hr_utility.trace('------------------------------------------------------------------');
201: END IF;

Line 198: hr_utility.trace(' ');

194: hr_utility.trace('Financial Year Start Date' || '=>' || l_fin_start_date);
195: hr_utility.trace('Financial Year End Date' || '=>' || l_fin_end_date);
196: hr_utility.trace('Hire Date' || ' =>' || l_hire_date);
197: hr_utility.trace('Actual Termination Date' || ' =>' || l_actual_termination_date);
198: hr_utility.trace(' ');
199: hr_utility.trace('Balance name Period Dates Particulars');
200: hr_utility.trace('------------------------------------------------------------------');
201: END IF;
202:

Line 199: hr_utility.trace('Balance name Period Dates Particulars');

195: hr_utility.trace('Financial Year End Date' || '=>' || l_fin_end_date);
196: hr_utility.trace('Hire Date' || ' =>' || l_hire_date);
197: hr_utility.trace('Actual Termination Date' || ' =>' || l_actual_termination_date);
198: hr_utility.trace(' ');
199: hr_utility.trace('Balance name Period Dates Particulars');
200: hr_utility.trace('------------------------------------------------------------------');
201: END IF;
202:
203: FOR i IN g_emol_details.FIRST..g_emol_details.LAST

Line 200: hr_utility.trace('------------------------------------------------------------------');

196: hr_utility.trace('Hire Date' || ' =>' || l_hire_date);
197: hr_utility.trace('Actual Termination Date' || ' =>' || l_actual_termination_date);
198: hr_utility.trace(' ');
199: hr_utility.trace('Balance name Period Dates Particulars');
200: hr_utility.trace('------------------------------------------------------------------');
201: END IF;
202:
203: FOR i IN g_emol_details.FIRST..g_emol_details.LAST
204: LOOP

Line 249: hr_utility.trace(g_emol_details(i).balance_name || ' ' || g_emol_details(i).period_dates || ' ' ||

245: END IF;
246: CLOSE csr_element_entry_dates;
247:
248: IF g_debug THEN
249: hr_utility.trace(g_emol_details(i).balance_name || ' ' || g_emol_details(i).period_dates || ' ' ||
250: g_emol_details(i).particulars || ' ' || g_emol_details(i).balance_value);
251: END IF;
252: END IF;
253: END LOOP;

Line 258: hr_utility.trace('Leaving:' || 'pay_hk_ir56.get_emoluments');

254:
255: RETURN g_emol_details;
256:
257: IF g_debug THEN
258: hr_utility.trace('Leaving:' || 'pay_hk_ir56.get_emoluments');
259: END IF;
260:
261: EXCEPTION
262: WHEN others THEN

Line 292: /* Bug# 3626489 g_debug := hr_utility.debug_enabled;*/

288: i NUMBER := 0;
289:
290: BEGIN
291:
292: /* Bug# 3626489 g_debug := hr_utility.debug_enabled;*/
293: g_debug := FALSE;
294:
295: IF g_debug THEN
296: hr_utility.trace('Entering:' || 'pay_hk_ir56.populate_defined_balance_ids');

Line 296: hr_utility.trace('Entering:' || 'pay_hk_ir56.populate_defined_balance_ids');

292: /* Bug# 3626489 g_debug := hr_utility.debug_enabled;*/
293: g_debug := FALSE;
294:
295: IF g_debug THEN
296: hr_utility.trace('Entering:' || 'pay_hk_ir56.populate_defined_balance_ids');
297: END IF;
298:
299: /* Bug 3609072 */
300: p_balance_value_tab.delete;

Line 327: hr_utility.trace('Balance Name and its Defined Balance ids for IR56% Balances with dimension _ASG_LE_YTD');

323: 15 IR56_M
324: ------------------------------------------------------------ */
325:
326: IF g_debug THEN
327: hr_utility.trace('Balance Name and its Defined Balance ids for IR56% Balances with dimension _ASG_LE_YTD');
328: hr_utility.trace('--------------------------------------------------------------------------------------');
329: END IF;
330:
331: FOR csr_rec IN csr_defined_balance_id

Line 328: hr_utility.trace('--------------------------------------------------------------------------------------');

324: ------------------------------------------------------------ */
325:
326: IF g_debug THEN
327: hr_utility.trace('Balance Name and its Defined Balance ids for IR56% Balances with dimension _ASG_LE_YTD');
328: hr_utility.trace('--------------------------------------------------------------------------------------');
329: END IF;
330:
331: FOR csr_rec IN csr_defined_balance_id
332: LOOP

Line 338: hr_utility.trace(g_emol_details(csr_rec.sort_index).balance_name || ' ===>' ||

334: p_balance_value_tab(csr_rec.sort_index).defined_balance_id := csr_rec.defined_balance_id;
335: g_emol_details(csr_rec.sort_index).balance_name := csr_rec.balance_name;
336:
337: IF g_debug THEN
338: hr_utility.trace(g_emol_details(csr_rec.sort_index).balance_name || ' ===>' ||
339: p_balance_value_tab(csr_rec.sort_index).defined_balance_id);
340: END IF;
341:
342: END LOOP;

Line 344: hr_utility.trace('---------------------------------------------------------------------------------------');

340: END IF;
341:
342: END LOOP;
343: IF g_debug THEN
344: hr_utility.trace('---------------------------------------------------------------------------------------');
345: hr_utility.trace('Leaving:' || 'pay_hk_ir56.populate_defined_balance_ids');
346: END IF;
347:
348: END populate_defined_balance_ids;

Line 345: hr_utility.trace('Leaving:' || 'pay_hk_ir56.populate_defined_balance_ids');

341:
342: END LOOP;
343: IF g_debug THEN
344: hr_utility.trace('---------------------------------------------------------------------------------------');
345: hr_utility.trace('Leaving:' || 'pay_hk_ir56.populate_defined_balance_ids');
346: END IF;
347:
348: END populate_defined_balance_ids;
349:

Line 361: /* Bug# 3626489 g_debug := hr_utility.debug_enabled;*/

357: l_proc varchar2(72);
358: l_tax_year_start date := null;
359: begin
360:
361: /* Bug# 3626489 g_debug := hr_utility.debug_enabled;*/
362: g_debug := FALSE;
363:
364: l_proc := 'pay_hk_ir56.get_last_anniversary'; --3626489
365: hr_utility.trace('In: ' || l_proc) ;

Line 365: hr_utility.trace('In: ' || l_proc) ;

361: /* Bug# 3626489 g_debug := hr_utility.debug_enabled;*/
362: g_debug := FALSE;
363:
364: l_proc := 'pay_hk_ir56.get_last_anniversary'; --3626489
365: hr_utility.trace('In: ' || l_proc) ;
366: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
367: hr_utility.trace(' p_calculation_date: ' || to_char(p_calculation_date,'DD-MON-YYYY')) ;
368:
369: l_tax_year_start := to_date('0104'||to_char(p_calculation_date,'YYYY'),'DDMMYYYY');

Line 366: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;

362: g_debug := FALSE;
363:
364: l_proc := 'pay_hk_ir56.get_last_anniversary'; --3626489
365: hr_utility.trace('In: ' || l_proc) ;
366: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
367: hr_utility.trace(' p_calculation_date: ' || to_char(p_calculation_date,'DD-MON-YYYY')) ;
368:
369: l_tax_year_start := to_date('0104'||to_char(p_calculation_date,'YYYY'),'DDMMYYYY');
370: if (l_tax_year_start > p_calculation_date) then

Line 367: hr_utility.trace(' p_calculation_date: ' || to_char(p_calculation_date,'DD-MON-YYYY')) ;

363:
364: l_proc := 'pay_hk_ir56.get_last_anniversary'; --3626489
365: hr_utility.trace('In: ' || l_proc) ;
366: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
367: hr_utility.trace(' p_calculation_date: ' || to_char(p_calculation_date,'DD-MON-YYYY')) ;
368:
369: l_tax_year_start := to_date('0104'||to_char(p_calculation_date,'YYYY'),'DDMMYYYY');
370: if (l_tax_year_start > p_calculation_date) then
371: l_tax_year_start := add_months(l_tax_year_start,-12);

Line 373: hr_utility.trace(' return: ' || to_char(l_tax_year_start,'DD-MON-YYYY')) ;

369: l_tax_year_start := to_date('0104'||to_char(p_calculation_date,'YYYY'),'DDMMYYYY');
370: if (l_tax_year_start > p_calculation_date) then
371: l_tax_year_start := add_months(l_tax_year_start,-12);
372: end if;
373: hr_utility.trace(' return: ' || to_char(l_tax_year_start,'DD-MON-YYYY')) ;
374: hr_utility.trace('Out: ' || l_proc) ;
375: return l_tax_year_start;
376: end;
377:

Line 374: hr_utility.trace('Out: ' || l_proc) ;

370: if (l_tax_year_start > p_calculation_date) then
371: l_tax_year_start := add_months(l_tax_year_start,-12);
372: end if;
373: hr_utility.trace(' return: ' || to_char(l_tax_year_start,'DD-MON-YYYY')) ;
374: hr_utility.trace('Out: ' || l_proc) ;
375: return l_tax_year_start;
376: end;
377:
378: /*