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_DK_EMP_TRAINEE_REIMBURSE dependencies on FND_NUMBER

Line 388: /* SQLSTR := 'SELECT '''|| TO_CHAR(NVL(FND_NUMBER.canonical_to_number(round(l_total_atp,2)),0) ,'999G999G990D99' ) || ''' as "TotalATP",'''

384: l_tot_qtr_aer := round((round(l_tot_emp_aer,2) * l_global_rate),2);
385: END IF;
386:
387: -- Constructing a dynamic string to feed query to dbms_xmlquery which will generate XML output.
388: /* SQLSTR := 'SELECT '''|| TO_CHAR(NVL(FND_NUMBER.canonical_to_number(round(l_total_atp,2)),0) ,'999G999G990D99' ) || ''' as "TotalATP",'''
389: || TO_CHAR(NVL(FND_NUMBER.canonical_to_number(round(l_emp_count,2)),0) ,'999G999G990D99' ) || ''' as "FullTimeEmpCount",'''
390: || l_ded_1 ||''' as "Deduction1",'''
391: || l_ded_50 ||''' as "Deduction50",'''
392: || l_ded_trainee ||''' as "DeductionTrainee",'''

Line 389: || TO_CHAR(NVL(FND_NUMBER.canonical_to_number(round(l_emp_count,2)),0) ,'999G999G990D99' ) || ''' as "FullTimeEmpCount",'''

385: END IF;
386:
387: -- Constructing a dynamic string to feed query to dbms_xmlquery which will generate XML output.
388: /* SQLSTR := 'SELECT '''|| TO_CHAR(NVL(FND_NUMBER.canonical_to_number(round(l_total_atp,2)),0) ,'999G999G990D99' ) || ''' as "TotalATP",'''
389: || TO_CHAR(NVL(FND_NUMBER.canonical_to_number(round(l_emp_count,2)),0) ,'999G999G990D99' ) || ''' as "FullTimeEmpCount",'''
390: || l_ded_1 ||''' as "Deduction1",'''
391: || l_ded_50 ||''' as "Deduction50",'''
392: || l_ded_trainee ||''' as "DeductionTrainee",'''
393: || TO_CHAR(NVL(FND_NUMBER.canonical_to_number(round(l_tot_emp_aer,2)),0) ,'999G999G990D99' ) ||''' as "TotalAER",'''

Line 393: || TO_CHAR(NVL(FND_NUMBER.canonical_to_number(round(l_tot_emp_aer,2)),0) ,'999G999G990D99' ) ||''' as "TotalAER",'''

389: || TO_CHAR(NVL(FND_NUMBER.canonical_to_number(round(l_emp_count,2)),0) ,'999G999G990D99' ) || ''' as "FullTimeEmpCount",'''
390: || l_ded_1 ||''' as "Deduction1",'''
391: || l_ded_50 ||''' as "Deduction50",'''
392: || l_ded_trainee ||''' as "DeductionTrainee",'''
393: || TO_CHAR(NVL(FND_NUMBER.canonical_to_number(round(l_tot_emp_aer,2)),0) ,'999G999G990D99' ) ||''' as "TotalAER",'''
394: || TO_CHAR(NVL(FND_NUMBER.canonical_to_number(l_tot_qtr_aer),0) ,'999G999G990D99' ) ||''' as "TotalAERQuarter" from dual';
395: XMLIDENT := DBMS_XMLQUERY.NEWCONTEXT(SQLSTR);
396: DBMS_XMLQUERY.SETROWSETTAG (XMLIDENT, 'AERReport');
397: DBMS_XMLQUERY.SETROWTAG (XMLIDENT, 'Employee');

Line 394: || TO_CHAR(NVL(FND_NUMBER.canonical_to_number(l_tot_qtr_aer),0) ,'999G999G990D99' ) ||''' as "TotalAERQuarter" from dual';

390: || l_ded_1 ||''' as "Deduction1",'''
391: || l_ded_50 ||''' as "Deduction50",'''
392: || l_ded_trainee ||''' as "DeductionTrainee",'''
393: || TO_CHAR(NVL(FND_NUMBER.canonical_to_number(round(l_tot_emp_aer,2)),0) ,'999G999G990D99' ) ||''' as "TotalAER",'''
394: || TO_CHAR(NVL(FND_NUMBER.canonical_to_number(l_tot_qtr_aer),0) ,'999G999G990D99' ) ||''' as "TotalAERQuarter" from dual';
395: XMLIDENT := DBMS_XMLQUERY.NEWCONTEXT(SQLSTR);
396: DBMS_XMLQUERY.SETROWSETTAG (XMLIDENT, 'AERReport');
397: DBMS_XMLQUERY.SETROWTAG (XMLIDENT, 'Employee');
398: DBMS_XMLQUERY.GETXML(XMLIDENT, XMLRESULT);

Line 411: g_xml_element_table(l_xml_element_count).tagvalue := TO_CHAR(NVL(FND_NUMBER.canonical_to_number(round(l_total_atp,2)),0) ,'999G999G990D99');

407: g_xml_element_table(l_xml_element_count).tagvalue := '_START_';
408: l_xml_element_count := l_xml_element_count + 1;
409: --
410: g_xml_element_table(l_xml_element_count).tagname := 'TotalATP';
411: g_xml_element_table(l_xml_element_count).tagvalue := TO_CHAR(NVL(FND_NUMBER.canonical_to_number(round(l_total_atp,2)),0) ,'999G999G990D99');
412: l_xml_element_count := l_xml_element_count + 1;
413: --
414: g_xml_element_table(l_xml_element_count).tagname := 'FullTimeEmpCount';
415: g_xml_element_table(l_xml_element_count).tagvalue := TO_CHAR(NVL(FND_NUMBER.canonical_to_number(round(l_emp_count,2)),0) ,'999G999G990D99');

Line 415: g_xml_element_table(l_xml_element_count).tagvalue := TO_CHAR(NVL(FND_NUMBER.canonical_to_number(round(l_emp_count,2)),0) ,'999G999G990D99');

411: g_xml_element_table(l_xml_element_count).tagvalue := TO_CHAR(NVL(FND_NUMBER.canonical_to_number(round(l_total_atp,2)),0) ,'999G999G990D99');
412: l_xml_element_count := l_xml_element_count + 1;
413: --
414: g_xml_element_table(l_xml_element_count).tagname := 'FullTimeEmpCount';
415: g_xml_element_table(l_xml_element_count).tagvalue := TO_CHAR(NVL(FND_NUMBER.canonical_to_number(round(l_emp_count,2)),0) ,'999G999G990D99');
416: l_xml_element_count := l_xml_element_count + 1;
417: --
418: g_xml_element_table(l_xml_element_count).tagname := 'Deduction1';
419: g_xml_element_table(l_xml_element_count).tagvalue := l_ded_1;

Line 431: g_xml_element_table(l_xml_element_count).tagvalue := TO_CHAR(NVL(FND_NUMBER.canonical_to_number(round(l_tot_emp_aer,2)),0) ,'999G999G990D99' );

427: g_xml_element_table(l_xml_element_count).tagvalue := l_ded_trainee;
428: l_xml_element_count := l_xml_element_count + 1;
429: --
430: g_xml_element_table(l_xml_element_count).tagname := 'TotalAER';
431: g_xml_element_table(l_xml_element_count).tagvalue := TO_CHAR(NVL(FND_NUMBER.canonical_to_number(round(l_tot_emp_aer,2)),0) ,'999G999G990D99' );
432: l_xml_element_count := l_xml_element_count + 1;
433: --
434: g_xml_element_table(l_xml_element_count).tagname := 'TotalAERQuarter';
435: g_xml_element_table(l_xml_element_count).tagvalue := TO_CHAR(NVL(FND_NUMBER.canonical_to_number(l_tot_qtr_aer),0) ,'999G999G990D99');

Line 435: g_xml_element_table(l_xml_element_count).tagvalue := TO_CHAR(NVL(FND_NUMBER.canonical_to_number(l_tot_qtr_aer),0) ,'999G999G990D99');

431: g_xml_element_table(l_xml_element_count).tagvalue := TO_CHAR(NVL(FND_NUMBER.canonical_to_number(round(l_tot_emp_aer,2)),0) ,'999G999G990D99' );
432: l_xml_element_count := l_xml_element_count + 1;
433: --
434: g_xml_element_table(l_xml_element_count).tagname := 'TotalAERQuarter';
435: g_xml_element_table(l_xml_element_count).tagvalue := TO_CHAR(NVL(FND_NUMBER.canonical_to_number(l_tot_qtr_aer),0) ,'999G999G990D99');
436: l_xml_element_count := l_xml_element_count + 1;
437: --
438: g_xml_element_table(l_xml_element_count).tagname := 'AERReport';
439: g_xml_element_table(l_xml_element_count).tagvalue := '_END_';