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_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 170: /Bug# 3626489 g_debug := hr_utility.debug_enabled;/

166: AND pee.effective_end_date >= p_fin_start_date;
167:
168: BEGIN
169:
170: /*Bug# 3626489 g_debug := hr_utility.debug_enabled;*/
171: g_debug := FALSE;
172:
173: IF g_debug THEN
174: hr_utility.trace('Leaving:' || 'pay_hk_ir56.get_emoluments');

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

170: /*Bug# 3626489 g_debug := hr_utility.debug_enabled;*/
171: g_debug := FALSE;
172:
173: IF g_debug THEN
174: hr_utility.trace('Leaving:' || 'pay_hk_ir56.get_emoluments');
175: hr_utility.trace('Values of the input parameters');
176: hr_utility.trace('------------------------------');
177: hr_utility.trace('Assignment id' || ' =>' || p_assignment_id);
178: hr_utility.trace('Assignment Action Id' || '=>' || p_assignment_action_id);

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

171: g_debug := FALSE;
172:
173: IF g_debug THEN
174: hr_utility.trace('Leaving:' || 'pay_hk_ir56.get_emoluments');
175: hr_utility.trace('Values of the input parameters');
176: hr_utility.trace('------------------------------');
177: hr_utility.trace('Assignment id' || ' =>' || p_assignment_id);
178: hr_utility.trace('Assignment Action Id' || '=>' || p_assignment_action_id);
179: hr_utility.trace('Tax Unit Id' || ' =>' || p_tax_unit_id);

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

172:
173: IF g_debug THEN
174: hr_utility.trace('Leaving:' || 'pay_hk_ir56.get_emoluments');
175: hr_utility.trace('Values of the input parameters');
176: hr_utility.trace('------------------------------');
177: hr_utility.trace('Assignment id' || ' =>' || p_assignment_id);
178: hr_utility.trace('Assignment Action Id' || '=>' || p_assignment_action_id);
179: hr_utility.trace('Tax Unit Id' || ' =>' || p_tax_unit_id);
180: hr_utility.trace('Reporting Year' || ' =>' || p_reporting_year);

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

173: IF g_debug THEN
174: hr_utility.trace('Leaving:' || 'pay_hk_ir56.get_emoluments');
175: hr_utility.trace('Values of the input parameters');
176: hr_utility.trace('------------------------------');
177: hr_utility.trace('Assignment id' || ' =>' || p_assignment_id);
178: hr_utility.trace('Assignment Action Id' || '=>' || p_assignment_action_id);
179: hr_utility.trace('Tax Unit Id' || ' =>' || p_tax_unit_id);
180: hr_utility.trace('Reporting Year' || ' =>' || p_reporting_year);
181: END IF;

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

174: hr_utility.trace('Leaving:' || 'pay_hk_ir56.get_emoluments');
175: hr_utility.trace('Values of the input parameters');
176: hr_utility.trace('------------------------------');
177: hr_utility.trace('Assignment id' || ' =>' || p_assignment_id);
178: hr_utility.trace('Assignment Action Id' || '=>' || p_assignment_action_id);
179: hr_utility.trace('Tax Unit Id' || ' =>' || p_tax_unit_id);
180: hr_utility.trace('Reporting Year' || ' =>' || p_reporting_year);
181: END IF;
182:

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

175: hr_utility.trace('Values of the input parameters');
176: hr_utility.trace('------------------------------');
177: hr_utility.trace('Assignment id' || ' =>' || p_assignment_id);
178: hr_utility.trace('Assignment Action Id' || '=>' || p_assignment_action_id);
179: hr_utility.trace('Tax Unit Id' || ' =>' || p_tax_unit_id);
180: hr_utility.trace('Reporting Year' || ' =>' || p_reporting_year);
181: END IF;
182:
183: populate_defined_balance_ids;

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

176: hr_utility.trace('------------------------------');
177: hr_utility.trace('Assignment id' || ' =>' || p_assignment_id);
178: hr_utility.trace('Assignment Action Id' || '=>' || p_assignment_action_id);
179: hr_utility.trace('Tax Unit Id' || ' =>' || p_tax_unit_id);
180: hr_utility.trace('Reporting Year' || ' =>' || p_reporting_year);
181: END IF;
182:
183: populate_defined_balance_ids;
184:

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

182:
183: populate_defined_balance_ids;
184:
185: IF g_debug THEN
186: hr_utility.trace('Balance Name Balance Value');
187: hr_utility.trace('----------------------------------------------');
188: END IF;
189:
190: IF ((p_assignment_action_id IS NOT NULL) AND (p_assignment_action_id <> 0)) THEN

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

183: populate_defined_balance_ids;
184:
185: IF g_debug THEN
186: hr_utility.trace('Balance Name Balance Value');
187: hr_utility.trace('----------------------------------------------');
188: END IF;
189:
190: IF ((p_assignment_action_id IS NOT NULL) AND (p_assignment_action_id <> 0)) THEN
191:

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

192:
193: /* Bug 3609072 */
194: p_context_table(1).tax_unit_id := p_tax_unit_id;
195:
196: hr_utility.trace('Jay get_value');
197: pay_balance_pkg.get_value(p_assignment_action_id => p_assignment_action_id
198: ,p_defined_balance_lst => p_balance_value_tab
199: ,p_context_lst => p_context_table
200: ,p_output_table => p_result_table);

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

225: FETCH csr_hire_date INTO l_hire_date,l_actual_termination_date;
226: CLOSE csr_hire_date;
227:
228: IF g_debug THEN
229: hr_utility.trace('Financial Year Start Date' || '=>' || l_fin_start_date);
230: hr_utility.trace('Financial Year End Date' || '=>' || l_fin_end_date);
231: hr_utility.trace('Hire Date' || ' =>' || l_hire_date);
232: hr_utility.trace('Actual Termination Date' || ' =>' || l_actual_termination_date);
233: hr_utility.trace(' ');

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

226: CLOSE csr_hire_date;
227:
228: IF g_debug THEN
229: hr_utility.trace('Financial Year Start Date' || '=>' || l_fin_start_date);
230: hr_utility.trace('Financial Year End Date' || '=>' || l_fin_end_date);
231: hr_utility.trace('Hire Date' || ' =>' || l_hire_date);
232: hr_utility.trace('Actual Termination Date' || ' =>' || l_actual_termination_date);
233: hr_utility.trace(' ');
234: hr_utility.trace('Balance name Period Dates Particulars');

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

227:
228: IF g_debug THEN
229: hr_utility.trace('Financial Year Start Date' || '=>' || l_fin_start_date);
230: hr_utility.trace('Financial Year End Date' || '=>' || l_fin_end_date);
231: hr_utility.trace('Hire Date' || ' =>' || l_hire_date);
232: hr_utility.trace('Actual Termination Date' || ' =>' || l_actual_termination_date);
233: hr_utility.trace(' ');
234: hr_utility.trace('Balance name Period Dates Particulars');
235: hr_utility.trace('------------------------------------------------------------------');

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

228: IF g_debug THEN
229: hr_utility.trace('Financial Year Start Date' || '=>' || l_fin_start_date);
230: hr_utility.trace('Financial Year End Date' || '=>' || l_fin_end_date);
231: hr_utility.trace('Hire Date' || ' =>' || l_hire_date);
232: hr_utility.trace('Actual Termination Date' || ' =>' || l_actual_termination_date);
233: hr_utility.trace(' ');
234: hr_utility.trace('Balance name Period Dates Particulars');
235: hr_utility.trace('------------------------------------------------------------------');
236: END IF;

Line 233: hr_utility.trace(' ');

229: hr_utility.trace('Financial Year Start Date' || '=>' || l_fin_start_date);
230: hr_utility.trace('Financial Year End Date' || '=>' || l_fin_end_date);
231: hr_utility.trace('Hire Date' || ' =>' || l_hire_date);
232: hr_utility.trace('Actual Termination Date' || ' =>' || l_actual_termination_date);
233: hr_utility.trace(' ');
234: hr_utility.trace('Balance name Period Dates Particulars');
235: hr_utility.trace('------------------------------------------------------------------');
236: END IF;
237:

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

230: hr_utility.trace('Financial Year End Date' || '=>' || l_fin_end_date);
231: hr_utility.trace('Hire Date' || ' =>' || l_hire_date);
232: hr_utility.trace('Actual Termination Date' || ' =>' || l_actual_termination_date);
233: hr_utility.trace(' ');
234: hr_utility.trace('Balance name Period Dates Particulars');
235: hr_utility.trace('------------------------------------------------------------------');
236: END IF;
237:
238: FOR i IN g_emol_details.FIRST..g_emol_details.LAST

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

231: hr_utility.trace('Hire Date' || ' =>' || l_hire_date);
232: hr_utility.trace('Actual Termination Date' || ' =>' || l_actual_termination_date);
233: hr_utility.trace(' ');
234: hr_utility.trace('Balance name Period Dates Particulars');
235: hr_utility.trace('------------------------------------------------------------------');
236: END IF;
237:
238: FOR i IN g_emol_details.FIRST..g_emol_details.LAST
239: LOOP

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

295: END IF;
296: CLOSE csr_element_entry_dates;
297:
298: IF g_debug THEN
299: hr_utility.trace(g_emol_details(i).balance_name || ' ' || g_emol_details(i).period_dates || ' ' ||
300: g_emol_details(i).particulars || ' ' || g_emol_details(i).balance_value);
301: END IF;
302: END IF;
303: END LOOP;

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

304:
305: RETURN g_emol_details;
306:
307: IF g_debug THEN
308: hr_utility.trace('Leaving:' || 'pay_hk_ir56.get_emoluments');
309: END IF;
310:
311: EXCEPTION
312: WHEN others THEN

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

338: i NUMBER := 0;
339:
340: BEGIN
341:
342: /* Bug# 3626489 g_debug := hr_utility.debug_enabled;*/
343: g_debug := FALSE;
344:
345: IF g_debug THEN
346: hr_utility.trace('Entering:' || 'pay_hk_ir56.populate_defined_balance_ids');

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

342: /* Bug# 3626489 g_debug := hr_utility.debug_enabled;*/
343: g_debug := FALSE;
344:
345: IF g_debug THEN
346: hr_utility.trace('Entering:' || 'pay_hk_ir56.populate_defined_balance_ids');
347: END IF;
348:
349: /* Bug 3609072 */
350: p_balance_value_tab.delete;

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

373: 15 IR56_M
374: ------------------------------------------------------------ */
375:
376: IF g_debug THEN
377: hr_utility.trace('Balance Name and its Defined Balance ids for IR56% Balances with dimension _ASG_LE_YTD');
378: hr_utility.trace('--------------------------------------------------------------------------------------');
379: END IF;
380:
381: FOR csr_rec IN csr_defined_balance_id

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

374: ------------------------------------------------------------ */
375:
376: IF g_debug THEN
377: hr_utility.trace('Balance Name and its Defined Balance ids for IR56% Balances with dimension _ASG_LE_YTD');
378: hr_utility.trace('--------------------------------------------------------------------------------------');
379: END IF;
380:
381: FOR csr_rec IN csr_defined_balance_id
382: LOOP

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

384: p_balance_value_tab(csr_rec.sort_index).defined_balance_id := csr_rec.defined_balance_id;
385: g_emol_details(csr_rec.sort_index).balance_name := csr_rec.balance_name;
386:
387: IF g_debug THEN
388: hr_utility.trace(g_emol_details(csr_rec.sort_index).balance_name || ' ===>' ||
389: p_balance_value_tab(csr_rec.sort_index).defined_balance_id);
390: END IF;
391:
392: END LOOP;

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

390: END IF;
391:
392: END LOOP;
393: IF g_debug THEN
394: hr_utility.trace('---------------------------------------------------------------------------------------');
395: hr_utility.trace('Leaving:' || 'pay_hk_ir56.populate_defined_balance_ids');
396: END IF;
397:
398: END populate_defined_balance_ids;

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

391:
392: END LOOP;
393: IF g_debug THEN
394: hr_utility.trace('---------------------------------------------------------------------------------------');
395: hr_utility.trace('Leaving:' || 'pay_hk_ir56.populate_defined_balance_ids');
396: END IF;
397:
398: END populate_defined_balance_ids;
399:

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

407: l_proc varchar2(72);
408: l_tax_year_start date := null;
409: begin
410:
411: /* Bug# 3626489 g_debug := hr_utility.debug_enabled;*/
412: g_debug := FALSE;
413:
414: l_proc := 'pay_hk_ir56.get_last_anniversary'; --3626489
415: hr_utility.trace('In: ' || l_proc) ;

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

411: /* Bug# 3626489 g_debug := hr_utility.debug_enabled;*/
412: g_debug := FALSE;
413:
414: l_proc := 'pay_hk_ir56.get_last_anniversary'; --3626489
415: hr_utility.trace('In: ' || l_proc) ;
416: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
417: hr_utility.trace(' p_calculation_date: ' || to_char(p_calculation_date,'DD-MON-YYYY')) ;
418:
419: l_tax_year_start := to_date('0104'||to_char(p_calculation_date,'YYYY'),'DDMMYYYY');

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

412: g_debug := FALSE;
413:
414: l_proc := 'pay_hk_ir56.get_last_anniversary'; --3626489
415: hr_utility.trace('In: ' || l_proc) ;
416: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
417: hr_utility.trace(' p_calculation_date: ' || to_char(p_calculation_date,'DD-MON-YYYY')) ;
418:
419: l_tax_year_start := to_date('0104'||to_char(p_calculation_date,'YYYY'),'DDMMYYYY');
420: if (l_tax_year_start > p_calculation_date) then

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

413:
414: l_proc := 'pay_hk_ir56.get_last_anniversary'; --3626489
415: hr_utility.trace('In: ' || l_proc) ;
416: hr_utility.trace(' p_assignment_id: ' || to_char(p_assignment_id)) ;
417: hr_utility.trace(' p_calculation_date: ' || to_char(p_calculation_date,'DD-MON-YYYY')) ;
418:
419: l_tax_year_start := to_date('0104'||to_char(p_calculation_date,'YYYY'),'DDMMYYYY');
420: if (l_tax_year_start > p_calculation_date) then
421: l_tax_year_start := add_months(l_tax_year_start,-12);

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

419: l_tax_year_start := to_date('0104'||to_char(p_calculation_date,'YYYY'),'DDMMYYYY');
420: if (l_tax_year_start > p_calculation_date) then
421: l_tax_year_start := add_months(l_tax_year_start,-12);
422: end if;
423: hr_utility.trace(' return: ' || to_char(l_tax_year_start,'DD-MON-YYYY')) ;
424: hr_utility.trace('Out: ' || l_proc) ;
425: return l_tax_year_start;
426: end;
427:

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

420: if (l_tax_year_start > p_calculation_date) then
421: l_tax_year_start := add_months(l_tax_year_start,-12);
422: end if;
423: hr_utility.trace(' return: ' || to_char(l_tax_year_start,'DD-MON-YYYY')) ;
424: hr_utility.trace('Out: ' || l_proc) ;
425: return l_tax_year_start;
426: end;
427:
428: /*