DBA Data[Home] [Help]

APPS.PAY_SE_FORA dependencies on FND_NUMBER

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

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

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

1096: , p_action_information7 => l_person_number
1097: , p_action_information8 => l_person_name
1098: , p_action_information9 => emp_record(l_counter).l_category
1099: , p_action_information10 => fnd_date.date_to_canonical(emp_record(l_counter).l_white_from)
1100: , p_action_information11 => FND_NUMBER.NUMBER_TO_CANONICAL(emp_record(l_counter).l_gross_salary)
1101: , p_action_information12 => emp_record(l_counter).l_termination
1102: , p_action_information13 => emp_record(l_counter).l_job
1103: );*/
1104:

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

1130: , p_action_information7 => l_person_number
1131: , p_action_information8 => l_person_name
1132: , p_action_information9 => emp_record(csr_record).l_category
1133: , p_action_information10 => fnd_date.date_to_canonical(emp_record(csr_record).l_white_from)
1134: , p_action_information11 => FND_NUMBER.NUMBER_TO_CANONICAL(emp_record(csr_record).l_gross_salary)
1135: , p_action_information12 => emp_record(csr_record).l_termination
1136: , p_action_information13 => emp_record(csr_record).l_job
1137: , p_action_information14 => fnd_date.date_to_canonical(emp_record(csr_record).l_termination_date) -- Bug#9440498 fix
1138: , p_action_information15 => fnd_date.date_to_canonical(l_rep_start_date) -- Bug#9440498 fix

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

1520: , p_action_information7 => l_person_number
1521: , p_action_information8 => l_person_name
1522: , p_action_information9 => emp_record(csr_record).l_category
1523: , p_action_information10 => fnd_date.date_to_canonical(emp_record(csr_record).l_white_from)
1524: , p_action_information11 => FND_NUMBER.NUMBER_TO_CANONICAL(emp_record(csr_record).l_gross_salary)
1525: , p_action_information12 => emp_record(csr_record).l_termination
1526: , p_action_information13 => emp_record(csr_record).l_job
1527: , p_action_information14 => fnd_date.date_to_canonical(emp_record(csr_record).l_termination_date) -- Bug#9440498 fix
1528: , p_action_information15 => fnd_date.date_to_canonical(l_rep_start_date) -- Bug#9440498 fix

Line 2055: (fnd_number.canonical_to_number

2051: );
2052: add_tag_value
2053: ('HOLIDAY_PAY_PER_DAY'
2054: , TO_CHAR
2055: (fnd_number.canonical_to_number
2056: (rec_all_emp_under_le.action_information7)
2057: , '999999990D99'
2058: )
2059: );

Line 2066: (fnd_number.canonical_to_number

2062: );
2063: add_tag_value
2064: ('TOTAL_PAID_DAYS_AMOUNT'
2065: , TO_CHAR
2066: (fnd_number.canonical_to_number
2067: (rec_all_emp_under_le.action_information9)
2068: , '999999990D99'
2069: )
2070: );

Line 2077: (fnd_number.canonical_to_number

2073: );
2074: add_tag_value
2075: ('TOTAL_SAVED_DAYS_AMOUNT'
2076: , TO_CHAR
2077: (fnd_number.canonical_to_number
2078: (rec_all_emp_under_le.action_information11)
2079: , '999999990D99'
2080: )
2081: );

Line 2088: (fnd_number.canonical_to_number

2084: );
2085: add_tag_value
2086: ('TOTAL_EARNED_DAYS_AMOUNT'
2087: , TO_CHAR
2088: (fnd_number.canonical_to_number
2089: (rec_all_emp_under_le.action_information13)
2090: , '999999990D99'
2091: )
2092: );

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

2420: l_counter:=l_counter+1;
2421: /*fnd_file.put_line(fnd_file.LOG,'xml_tab(l_counter).TagName'||xml_tab(l_counter).TagName);
2422: fnd_file.put_line(fnd_file.LOG,'xml_tab(l_counter).TagValue'||xml_tab(l_counter).TagValue);*/
2423: xml_tab(l_counter).TagName :='SALARY';
2424: xml_tab(l_counter).TagValue := fnd_number.canonical_to_number(round(csr_person.Gross_Salary));
2425: l_counter:=l_counter+1;
2426:
2427: xml_tab(l_counter).TagName :='SAL';
2428: xml_tab(l_counter).TagValue := fnd_number.canonical_to_number(round(csr_person.Gross_Salary));

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

2424: xml_tab(l_counter).TagValue := fnd_number.canonical_to_number(round(csr_person.Gross_Salary));
2425: l_counter:=l_counter+1;
2426:
2427: xml_tab(l_counter).TagName :='SAL';
2428: xml_tab(l_counter).TagValue := fnd_number.canonical_to_number(round(csr_person.Gross_Salary));
2429: l_counter:=l_counter+1;
2430: /*fnd_file.put_line(fnd_file.LOG,'xml_tab(l_counter).TagName'||xml_tab(l_counter).TagName);
2431: fnd_file.put_line(fnd_file.LOG,'xml_tab(l_counter).TagValue'||xml_tab(l_counter).TagValue);*/
2432: l_salary:=fnd_number.canonical_to_number(round(csr_person.Gross_Salary));

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

2428: xml_tab(l_counter).TagValue := fnd_number.canonical_to_number(round(csr_person.Gross_Salary));
2429: l_counter:=l_counter+1;
2430: /*fnd_file.put_line(fnd_file.LOG,'xml_tab(l_counter).TagName'||xml_tab(l_counter).TagName);
2431: fnd_file.put_line(fnd_file.LOG,'xml_tab(l_counter).TagValue'||xml_tab(l_counter).TagValue);*/
2432: l_salary:=fnd_number.canonical_to_number(round(csr_person.Gross_Salary));
2433: l_lu_salary:=l_lu_salary+l_salary;
2434: l_grand_salary:=l_grand_salary+l_salary;
2435: xml_tab(l_counter).TagName :='TERMINATED';
2436: xml_tab(l_counter).TagValue := csr_person.Terminated;

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

2474:
2475: END LOOP;
2476:
2477: xml_tab(l_counter).TagName :='LU_SALARY';
2478: xml_tab(l_counter).TagValue :=fnd_number.canonical_to_number(l_lu_salary);
2479: l_counter := l_counter + 1;
2480: /*fnd_file.put_line(fnd_file.LOG,'xml_tab(l_counter).TagName'||xml_tab(l_counter).TagName);
2481: fnd_file.put_line(fnd_file.LOG,'xml_tab(l_counter).TagValue'||xml_tab(l_counter).TagValue);*/
2482:

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

2624: /*fnd_file.put_line(fnd_file.LOG,'xml_tab(l_counter).TagName'||xml_tab(l_counter).TagName);
2625: fnd_file.put_line(fnd_file.LOG,'xml_tab(l_counter).TagValue'||xml_tab(l_counter).TagValue);*/
2626:
2627: xml_tab(l_counter).TagName :='SALARY';
2628: xml_tab(l_counter).TagValue := fnd_number.canonical_to_number(round(csr_person.Gross_Salary));
2629: l_counter:=l_counter+1;
2630:
2631: xml_tab(l_counter).TagName :='SAL';
2632: xml_tab(l_counter).TagValue := fnd_number.canonical_to_number(round(csr_person.Gross_Salary));

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

2628: xml_tab(l_counter).TagValue := fnd_number.canonical_to_number(round(csr_person.Gross_Salary));
2629: l_counter:=l_counter+1;
2630:
2631: xml_tab(l_counter).TagName :='SAL';
2632: xml_tab(l_counter).TagValue := fnd_number.canonical_to_number(round(csr_person.Gross_Salary));
2633: l_counter:=l_counter+1;
2634:
2635: /*fnd_file.put_line(fnd_file.LOG,'xml_tab(l_counter).TagName'||xml_tab(l_counter).TagName);
2636: fnd_file.put_line(fnd_file.LOG,'xml_tab(l_counter).TagValue'||xml_tab(l_counter).TagValue);*/

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

2633: l_counter:=l_counter+1;
2634:
2635: /*fnd_file.put_line(fnd_file.LOG,'xml_tab(l_counter).TagName'||xml_tab(l_counter).TagName);
2636: fnd_file.put_line(fnd_file.LOG,'xml_tab(l_counter).TagValue'||xml_tab(l_counter).TagValue);*/
2637: l_salary:=fnd_number.canonical_to_number(round(csr_person.Gross_Salary));
2638: l_lu_salary:=l_lu_salary+l_salary;
2639: l_grand_salary:=l_grand_salary+l_salary;
2640: xml_tab(l_counter).TagName :='TERMINATED';
2641: xml_tab(l_counter).TagValue := csr_person.Terminated;

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

2680:
2681: END LOOP;
2682:
2683: xml_tab(l_counter).TagName :='LU_SALARY';
2684: xml_tab(l_counter).TagValue :=fnd_number.canonical_to_number(l_lu_salary);
2685: l_counter := l_counter + 1;
2686: /*fnd_file.put_line(fnd_file.LOG,'xml_tab(l_counter).TagName'||xml_tab(l_counter).TagName);
2687: fnd_file.put_line(fnd_file.LOG,'xml_tab(l_counter).TagValue'||xml_tab(l_counter).TagValue);*/
2688:

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

2704: END LOOP;
2705: END if;
2706:
2707: xml_tab(l_counter).TagName :='GRAND_SALARY';
2708: xml_tab(l_counter).TagValue :=TO_CHAR(fnd_number.canonical_to_number(l_grand_salary), '999999990D99');
2709: l_counter := l_counter + 1;
2710: /*fnd_file.put_line(fnd_file.LOG,'xml_tab(l_counter).TagName'||xml_tab(l_counter).TagName);
2711: fnd_file.put_line(fnd_file.LOG,'xml_tab(l_counter).TagValue'||xml_tab(l_counter).TagValue);*/
2712: /*xml_tab(l_counter).TagName :='LU_DETAILS';