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

Line 694: , p_action_information7 => FND_NUMBER.NUMBER_TO_CANONICAL(g_year)

690: , p_action_information3 => L_LEGAL_EMPLOYER_NAME
691: , p_action_information4 => hr_general.decode_lookup('SE_REQUEST_LEVEL',g_LU_request)
692: , p_action_information5 => g_local_unit_id
693: , p_action_information6 => L_LOCAL_UNIT_NAME
694: , p_action_information7 => FND_NUMBER.NUMBER_TO_CANONICAL(g_year)
695: , p_action_information8 => to_char(l_insurance_number)
696: );
697: -- *****************************************************************************
698:

Line 1094: , p_action_information11 => FND_NUMBER.NUMBER_TO_CANONICAL(emp_record(l_counter).l_gross_salary)

1090: , p_action_information7 => l_person_number
1091: , p_action_information8 => l_person_name
1092: , p_action_information9 => emp_record(l_counter).l_category
1093: , p_action_information10 => fnd_date.date_to_canonical(emp_record(l_counter).l_white_from)
1094: , p_action_information11 => FND_NUMBER.NUMBER_TO_CANONICAL(emp_record(l_counter).l_gross_salary)
1095: , p_action_information12 => emp_record(l_counter).l_termination
1096: , p_action_information13 => emp_record(l_counter).l_job
1097: );*/
1098:

Line 1122: , p_action_information11 => FND_NUMBER.NUMBER_TO_CANONICAL(emp_record(csr_record).l_gross_salary)

1118: , p_action_information7 => l_person_number
1119: , p_action_information8 => l_person_name
1120: , p_action_information9 => emp_record(csr_record).l_category
1121: , p_action_information10 => fnd_date.date_to_canonical(emp_record(csr_record).l_white_from)
1122: , p_action_information11 => FND_NUMBER.NUMBER_TO_CANONICAL(emp_record(csr_record).l_gross_salary)
1123: , p_action_information12 => emp_record(csr_record).l_termination
1124: , p_action_information13 => emp_record(csr_record).l_job
1125: );
1126: emp_record.delete(csr_record);

Line 1500: , p_action_information11 => FND_NUMBER.NUMBER_TO_CANONICAL(emp_record(csr_record).l_gross_salary)

1496: , p_action_information7 => l_person_number
1497: , p_action_information8 => l_person_name
1498: , p_action_information9 => emp_record(csr_record).l_category
1499: , p_action_information10 => fnd_date.date_to_canonical(emp_record(csr_record).l_white_from)
1500: , p_action_information11 => FND_NUMBER.NUMBER_TO_CANONICAL(emp_record(csr_record).l_gross_salary)
1501: , p_action_information12 => emp_record(csr_record).l_termination
1502: , p_action_information13 => emp_record(csr_record).l_job
1503: );
1504: emp_record.delete(csr_record);

Line 2029: (fnd_number.canonical_to_number

2025: );
2026: add_tag_value
2027: ('HOLIDAY_PAY_PER_DAY'
2028: , TO_CHAR
2029: (fnd_number.canonical_to_number
2030: (rec_all_emp_under_le.action_information7)
2031: , '999999990D99'
2032: )
2033: );

Line 2040: (fnd_number.canonical_to_number

2036: );
2037: add_tag_value
2038: ('TOTAL_PAID_DAYS_AMOUNT'
2039: , TO_CHAR
2040: (fnd_number.canonical_to_number
2041: (rec_all_emp_under_le.action_information9)
2042: , '999999990D99'
2043: )
2044: );

Line 2051: (fnd_number.canonical_to_number

2047: );
2048: add_tag_value
2049: ('TOTAL_SAVED_DAYS_AMOUNT'
2050: , TO_CHAR
2051: (fnd_number.canonical_to_number
2052: (rec_all_emp_under_le.action_information11)
2053: , '999999990D99'
2054: )
2055: );

Line 2062: (fnd_number.canonical_to_number

2058: );
2059: add_tag_value
2060: ('TOTAL_EARNED_DAYS_AMOUNT'
2061: , TO_CHAR
2062: (fnd_number.canonical_to_number
2063: (rec_all_emp_under_le.action_information13)
2064: , '999999990D99'
2065: )
2066: );

Line 2395: xml_tab(l_counter).TagValue := fnd_number.canonical_to_number(round(csr_person.Gross_Salary));

2391: l_counter:=l_counter+1;
2392: /*fnd_file.put_line(fnd_file.LOG,'xml_tab(l_counter).TagName'||xml_tab(l_counter).TagName);
2393: fnd_file.put_line(fnd_file.LOG,'xml_tab(l_counter).TagValue'||xml_tab(l_counter).TagValue);*/
2394: xml_tab(l_counter).TagName :='SALARY';
2395: xml_tab(l_counter).TagValue := fnd_number.canonical_to_number(round(csr_person.Gross_Salary));
2396: l_counter:=l_counter+1;
2397:
2398: xml_tab(l_counter).TagName :='SAL';
2399: xml_tab(l_counter).TagValue := fnd_number.canonical_to_number(round(csr_person.Gross_Salary));

Line 2399: xml_tab(l_counter).TagValue := fnd_number.canonical_to_number(round(csr_person.Gross_Salary));

2395: xml_tab(l_counter).TagValue := fnd_number.canonical_to_number(round(csr_person.Gross_Salary));
2396: l_counter:=l_counter+1;
2397:
2398: xml_tab(l_counter).TagName :='SAL';
2399: xml_tab(l_counter).TagValue := fnd_number.canonical_to_number(round(csr_person.Gross_Salary));
2400: l_counter:=l_counter+1;
2401: /*fnd_file.put_line(fnd_file.LOG,'xml_tab(l_counter).TagName'||xml_tab(l_counter).TagName);
2402: fnd_file.put_line(fnd_file.LOG,'xml_tab(l_counter).TagValue'||xml_tab(l_counter).TagValue);*/
2403: l_salary:=fnd_number.canonical_to_number(round(csr_person.Gross_Salary));

Line 2403: l_salary:=fnd_number.canonical_to_number(round(csr_person.Gross_Salary));

2399: xml_tab(l_counter).TagValue := fnd_number.canonical_to_number(round(csr_person.Gross_Salary));
2400: l_counter:=l_counter+1;
2401: /*fnd_file.put_line(fnd_file.LOG,'xml_tab(l_counter).TagName'||xml_tab(l_counter).TagName);
2402: fnd_file.put_line(fnd_file.LOG,'xml_tab(l_counter).TagValue'||xml_tab(l_counter).TagValue);*/
2403: l_salary:=fnd_number.canonical_to_number(round(csr_person.Gross_Salary));
2404: l_lu_salary:=l_lu_salary+l_salary;
2405: l_grand_salary:=l_grand_salary+l_salary;
2406: xml_tab(l_counter).TagName :='TERMINATED';
2407: xml_tab(l_counter).TagValue := csr_person.Terminated;

Line 2430: xml_tab(l_counter).TagValue :=fnd_number.canonical_to_number(l_lu_salary);

2426:
2427: END LOOP;
2428:
2429: xml_tab(l_counter).TagName :='LU_SALARY';
2430: xml_tab(l_counter).TagValue :=fnd_number.canonical_to_number(l_lu_salary);
2431: l_counter := l_counter + 1;
2432: /*fnd_file.put_line(fnd_file.LOG,'xml_tab(l_counter).TagName'||xml_tab(l_counter).TagName);
2433: fnd_file.put_line(fnd_file.LOG,'xml_tab(l_counter).TagValue'||xml_tab(l_counter).TagValue);*/
2434:

Line 2577: xml_tab(l_counter).TagValue := fnd_number.canonical_to_number(round(csr_person.Gross_Salary));

2573: /*fnd_file.put_line(fnd_file.LOG,'xml_tab(l_counter).TagName'||xml_tab(l_counter).TagName);
2574: fnd_file.put_line(fnd_file.LOG,'xml_tab(l_counter).TagValue'||xml_tab(l_counter).TagValue);*/
2575:
2576: xml_tab(l_counter).TagName :='SALARY';
2577: xml_tab(l_counter).TagValue := fnd_number.canonical_to_number(round(csr_person.Gross_Salary));
2578: l_counter:=l_counter+1;
2579:
2580: xml_tab(l_counter).TagName :='SAL';
2581: xml_tab(l_counter).TagValue := fnd_number.canonical_to_number(round(csr_person.Gross_Salary));

Line 2581: xml_tab(l_counter).TagValue := fnd_number.canonical_to_number(round(csr_person.Gross_Salary));

2577: xml_tab(l_counter).TagValue := fnd_number.canonical_to_number(round(csr_person.Gross_Salary));
2578: l_counter:=l_counter+1;
2579:
2580: xml_tab(l_counter).TagName :='SAL';
2581: xml_tab(l_counter).TagValue := fnd_number.canonical_to_number(round(csr_person.Gross_Salary));
2582: l_counter:=l_counter+1;
2583:
2584: /*fnd_file.put_line(fnd_file.LOG,'xml_tab(l_counter).TagName'||xml_tab(l_counter).TagName);
2585: fnd_file.put_line(fnd_file.LOG,'xml_tab(l_counter).TagValue'||xml_tab(l_counter).TagValue);*/

Line 2586: l_salary:=fnd_number.canonical_to_number(round(csr_person.Gross_Salary));

2582: l_counter:=l_counter+1;
2583:
2584: /*fnd_file.put_line(fnd_file.LOG,'xml_tab(l_counter).TagName'||xml_tab(l_counter).TagName);
2585: fnd_file.put_line(fnd_file.LOG,'xml_tab(l_counter).TagValue'||xml_tab(l_counter).TagValue);*/
2586: l_salary:=fnd_number.canonical_to_number(round(csr_person.Gross_Salary));
2587: l_lu_salary:=l_lu_salary+l_salary;
2588: l_grand_salary:=l_grand_salary+l_salary;
2589: xml_tab(l_counter).TagName :='TERMINATED';
2590: xml_tab(l_counter).TagValue := csr_person.Terminated;

Line 2613: xml_tab(l_counter).TagValue :=fnd_number.canonical_to_number(l_lu_salary);

2609:
2610: END LOOP;
2611:
2612: xml_tab(l_counter).TagName :='LU_SALARY';
2613: xml_tab(l_counter).TagValue :=fnd_number.canonical_to_number(l_lu_salary);
2614: l_counter := l_counter + 1;
2615: /*fnd_file.put_line(fnd_file.LOG,'xml_tab(l_counter).TagName'||xml_tab(l_counter).TagName);
2616: fnd_file.put_line(fnd_file.LOG,'xml_tab(l_counter).TagValue'||xml_tab(l_counter).TagValue);*/
2617:

Line 2637: xml_tab(l_counter).TagValue :=TO_CHAR(fnd_number.canonical_to_number(l_grand_salary), '999999990D99');

2633: END LOOP;
2634: END if;
2635:
2636: xml_tab(l_counter).TagName :='GRAND_SALARY';
2637: xml_tab(l_counter).TagValue :=TO_CHAR(fnd_number.canonical_to_number(l_grand_salary), '999999990D99');
2638: l_counter := l_counter + 1;
2639: /*fnd_file.put_line(fnd_file.LOG,'xml_tab(l_counter).TagName'||xml_tab(l_counter).TagName);
2640: fnd_file.put_line(fnd_file.LOG,'xml_tab(l_counter).TagValue'||xml_tab(l_counter).TagValue);*/
2641: /*xml_tab(l_counter).TagName :='LU_DETAILS';