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.HR_AMEUTIL_SS dependencies on FND_NUMBER

Line 314: return fnd_number.number_to_canonical(ln_requestor_person_id);

310: -- write debug statements
311: hr_utility.set_location('Leaving'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
312: end if;
313:
314: return fnd_number.number_to_canonical(ln_requestor_person_id);
315: EXCEPTION
316:
317: WHEN OTHERS THEN
318: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);

Line 346: return fnd_number.number_to_canonical(c_assignment_id);

342: select assignment_id into c_assignment_id from hr_api_transactions
343: where transaction_id = p_transaction_id;
344: end if;
345:
346: return fnd_number.number_to_canonical(c_assignment_id);
347: EXCEPTION
348: WHEN OTHERS THEN
349: WF_CORE.CONTEXT(g_package,'.get_sel_person_assignment_id',c_item_type,c_item_key);
350: RAISE;

Line 385: return fnd_number.number_to_canonical(ln_step_id);

381: if(hr_utility.debug_enabled) then
382: -- write debug statements
383: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
384: end if;
385: return fnd_number.number_to_canonical(ln_step_id);
386: EXCEPTION
387:
388: WHEN OTHERS THEN
389: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);

Line 425: return fnd_number.number_to_canonical(ln_step_id);

421: -- write debug statements
422: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
423: end if;
424:
425: return fnd_number.number_to_canonical(ln_step_id);
426: EXCEPTION
427:
428: WHEN OTHERS THEN
429: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);

Line 463: return fnd_number.number_to_canonical(ln_step_id);

459: if(hr_utility.debug_enabled) then
460: -- write debug statements
461: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
462: end if;
463: return fnd_number.number_to_canonical(ln_step_id);
464: EXCEPTION
465:
466: WHEN OTHERS THEN
467: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);

Line 501: return fnd_number.number_to_canonical(ln_step_id);

497: if(hr_utility.debug_enabled) then
498: -- write debug statements
499: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
500: end if;
501: return fnd_number.number_to_canonical(ln_step_id);
502: EXCEPTION
503:
504: WHEN OTHERS THEN
505: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);

Line 539: return fnd_number.number_to_canonical(ln_step_id);

535: if(hr_utility.debug_enabled) then
536: -- write debug statements
537: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
538: end if;
539: return fnd_number.number_to_canonical(ln_step_id);
540: EXCEPTION
541:
542: WHEN OTHERS THEN
543: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);

Line 763: ln_salary_percent_change:= ln_salary_percent_change + fnd_number.number_to_canonical(hr_transaction_api.get_number_value

759: ln_salary_percent_change:= 0;
760: FOR i in 1..ln_no_of_components
761: LOOP
762: lv_param_name := 'p_change_percent'||i;
763: ln_salary_percent_change:= ln_salary_percent_change + fnd_number.number_to_canonical(hr_transaction_api.get_number_value
764: (p_transaction_step_id => ln_step_id,
765: p_name =>lv_param_name));
766: end loop;
767: else

Line 843: ln_salary_amt_change:= ln_salary_amt_change + fnd_number.number_to_canonical(hr_transaction_api.get_number_value

839: ln_salary_amt_change:= 0;
840: FOR i in 1..ln_no_of_components
841: LOOP
842: lv_param_name := 'p_change_amount'||i;
843: ln_salary_amt_change:= ln_salary_amt_change + fnd_number.number_to_canonical(hr_transaction_api.get_number_value
844: (p_transaction_step_id => ln_step_id,
845: p_name =>lv_param_name));
846: end loop;
847: else

Line 848: ln_salary_amt_change:= fnd_number.number_to_canonical(hr_transaction_api.get_number_value

844: (p_transaction_step_id => ln_step_id,
845: p_name =>lv_param_name));
846: end loop;
847: else
848: ln_salary_amt_change:= fnd_number.number_to_canonical(hr_transaction_api.get_number_value
849: (p_transaction_step_id => ln_step_id,
850: p_name =>'p_change_amount'));
851: end if;
852: --changes made by schowdhu Bug#6919576

Line 1029: fnd_number.number_to_canonical(hr_transaction_api.get_number_value

1025: -- get step id
1026: ln_step_id:= get_supeversior_Chg_step_id(p_transaction_id);
1027: if(ln_step_id is not null) then
1028: ln_new_sel_person_prop_sup_id :=
1029: fnd_number.number_to_canonical(hr_transaction_api.get_number_value
1030: (p_transaction_step_id => ln_step_id,
1031: p_name =>'p_selected_person_sup_id'));
1032: ln_old_sel_person_prop_sup_id :=
1033: fnd_number.number_to_canonical(hr_transaction_api.get_number_value

Line 1033: fnd_number.number_to_canonical(hr_transaction_api.get_number_value

1029: fnd_number.number_to_canonical(hr_transaction_api.get_number_value
1030: (p_transaction_step_id => ln_step_id,
1031: p_name =>'p_selected_person_sup_id'));
1032: ln_old_sel_person_prop_sup_id :=
1033: fnd_number.number_to_canonical(hr_transaction_api.get_number_value
1034: (p_transaction_step_id => ln_step_id,
1035: p_name =>'p_selected_person_old_sup_id'));
1036:
1037: if(nvl(ln_new_sel_person_prop_sup_id,-111)<>nvl(ln_old_sel_person_prop_sup_id,-111)) then

Line 1096: return fnd_number.number_to_canonical(lv_selected_person_id);

1092: -- write debug statements
1093: hr_utility.set_location('Leaving'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
1094: end if;
1095:
1096: return fnd_number.number_to_canonical(lv_selected_person_id);
1097: EXCEPTION
1098:
1099: WHEN OTHERS THEN
1100: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);

Line 1124: ln_new_job_id := fnd_number.number_to_canonical(hr_transaction_api.get_number_value

1120:
1121: ln_step_id := get_assignment_step_id(p_transaction_id);
1122: if(ln_step_id is not null) then
1123: -- fix for bug 4145754
1124: ln_new_job_id := fnd_number.number_to_canonical(hr_transaction_api.get_number_value
1125: (p_transaction_step_id => ln_step_id
1126: ,p_name => 'P_JOB_ID'));
1127:
1128: ln_orginal_job_id := fnd_number.number_to_canonical(hr_transaction_api.get_original_number_value

Line 1128: ln_orginal_job_id := fnd_number.number_to_canonical(hr_transaction_api.get_original_number_value

1124: ln_new_job_id := fnd_number.number_to_canonical(hr_transaction_api.get_number_value
1125: (p_transaction_step_id => ln_step_id
1126: ,p_name => 'P_JOB_ID'));
1127:
1128: ln_orginal_job_id := fnd_number.number_to_canonical(hr_transaction_api.get_original_number_value
1129: (p_transaction_step_id => ln_step_id
1130: ,p_name => 'P_JOB_ID'));
1131: if(nvl(ln_new_job_id,-111)<>nvl(ln_orginal_job_id,-111)) then
1132: lv_job_id:=ln_new_job_id;

Line 1174: ln_new_position_id := fnd_number.number_to_canonical(hr_transaction_api.get_number_value

1170:
1171: ln_step_id := get_assignment_step_id(p_transaction_id);
1172: if(ln_step_id is not null) then
1173:
1174: ln_new_position_id := fnd_number.number_to_canonical(hr_transaction_api.get_number_value
1175: (p_transaction_step_id => ln_step_id
1176: ,p_name => 'P_POSITION_ID'));
1177:
1178: ln_orginal_position_id := fnd_number.number_to_canonical(hr_transaction_api.get_original_number_value

Line 1178: ln_orginal_position_id := fnd_number.number_to_canonical(hr_transaction_api.get_original_number_value

1174: ln_new_position_id := fnd_number.number_to_canonical(hr_transaction_api.get_number_value
1175: (p_transaction_step_id => ln_step_id
1176: ,p_name => 'P_POSITION_ID'));
1177:
1178: ln_orginal_position_id := fnd_number.number_to_canonical(hr_transaction_api.get_original_number_value
1179: (p_transaction_step_id => ln_step_id
1180: ,p_name => 'P_POSITION_ID'));
1181: if(nvl(ln_new_position_id,-111)<>nvl(ln_orginal_position_id,-111)) then
1182: lv_position_id:=ln_new_position_id;

Line 1226: ln_new_id := fnd_number.number_to_canonical(hr_transaction_api.get_number_value

1222:
1223: ln_step_id := get_assignment_step_id(p_transaction_id);
1224: if(ln_step_id is not null) then
1225:
1226: ln_new_id := fnd_number.number_to_canonical(hr_transaction_api.get_number_value
1227: (p_transaction_step_id => ln_step_id
1228: ,p_name => 'P_GRADE_ID'));
1229:
1230: ln_orginal_id := fnd_number.number_to_canonical(hr_transaction_api.get_original_number_value

Line 1230: ln_orginal_id := fnd_number.number_to_canonical(hr_transaction_api.get_original_number_value

1226: ln_new_id := fnd_number.number_to_canonical(hr_transaction_api.get_number_value
1227: (p_transaction_step_id => ln_step_id
1228: ,p_name => 'P_GRADE_ID'));
1229:
1230: ln_orginal_id := fnd_number.number_to_canonical(hr_transaction_api.get_original_number_value
1231: (p_transaction_step_id => ln_step_id
1232: ,p_name => 'P_GRADE_ID'));
1233: if(nvl(ln_new_id,-111)<>nvl(ln_orginal_id,-111)) then
1234: lv_grade_id:=ln_new_id;

Line 1275: ln_new_id := fnd_number.number_to_canonical(hr_transaction_api.get_number_value

1271: end if;
1272: ln_step_id := get_assignment_step_id(p_transaction_id);
1273: if(ln_step_id is not null) then
1274:
1275: ln_new_id := fnd_number.number_to_canonical(hr_transaction_api.get_number_value
1276: (p_transaction_step_id => ln_step_id
1277: ,p_name => 'P_LOCATION_ID'));
1278:
1279: ln_orginal_id := fnd_number.number_to_canonical(hr_transaction_api.get_original_number_value

Line 1279: ln_orginal_id := fnd_number.number_to_canonical(hr_transaction_api.get_original_number_value

1275: ln_new_id := fnd_number.number_to_canonical(hr_transaction_api.get_number_value
1276: (p_transaction_step_id => ln_step_id
1277: ,p_name => 'P_LOCATION_ID'));
1278:
1279: ln_orginal_id := fnd_number.number_to_canonical(hr_transaction_api.get_original_number_value
1280: (p_transaction_step_id => ln_step_id
1281: ,p_name => 'P_LOCATION_ID'));
1282: if(nvl(ln_new_id,-111)<>nvl(ln_orginal_id,-111)) then
1283: lv_location_id:=ln_new_id;

Line 1406: return fnd_number.number_to_canonical(ln_overall_rating);

1402: if(hr_utility.debug_enabled) then
1403: -- write debug statements
1404: hr_utility.set_location('Leaving'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
1405: end if;
1406: return fnd_number.number_to_canonical(ln_overall_rating);
1407: EXCEPTION
1408:
1409: WHEN OTHERS THEN
1410: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);

Line 1469: ln_new_id := fnd_number.number_to_canonical(hr_transaction_api.get_number_value

1465: end if;
1466: ln_step_id := get_assignment_step_id(p_transaction_id);
1467: if(ln_step_id is not null) then
1468:
1469: ln_new_id := fnd_number.number_to_canonical(hr_transaction_api.get_number_value
1470: (p_transaction_step_id => ln_step_id
1471: ,p_name => 'P_PAYROLL_ID'));
1472:
1473: ln_orginal_id := fnd_number.number_to_canonical(hr_transaction_api.get_original_number_value

Line 1473: ln_orginal_id := fnd_number.number_to_canonical(hr_transaction_api.get_original_number_value

1469: ln_new_id := fnd_number.number_to_canonical(hr_transaction_api.get_number_value
1470: (p_transaction_step_id => ln_step_id
1471: ,p_name => 'P_PAYROLL_ID'));
1472:
1473: ln_orginal_id := fnd_number.number_to_canonical(hr_transaction_api.get_original_number_value
1474: (p_transaction_step_id => ln_step_id
1475: ,p_name => 'P_PAYROLL_ID'));
1476: if(nvl(ln_new_id,-111)<>nvl(ln_orginal_id,-111)) then
1477: lv_payroll_id:=ln_new_id;

Line 1522: ln_new_id := fnd_number.number_to_canonical(hr_transaction_api.get_number_value

1518: end if;
1519:
1520: ln_step_id := get_assignment_step_id(p_transaction_id);
1521: if(ln_step_id is not null) then
1522: ln_new_id := fnd_number.number_to_canonical(hr_transaction_api.get_number_value
1523: (p_transaction_step_id => ln_step_id
1524: ,p_name => 'P_PAY_BASIS_ID'));
1525:
1526: ln_orginal_id := fnd_number.number_to_canonical(hr_transaction_api.get_original_number_value

Line 1526: ln_orginal_id := fnd_number.number_to_canonical(hr_transaction_api.get_original_number_value

1522: ln_new_id := fnd_number.number_to_canonical(hr_transaction_api.get_number_value
1523: (p_transaction_step_id => ln_step_id
1524: ,p_name => 'P_PAY_BASIS_ID'));
1525:
1526: ln_orginal_id := fnd_number.number_to_canonical(hr_transaction_api.get_original_number_value
1527: (p_transaction_step_id => ln_step_id
1528: ,p_name => 'P_PAY_BASIS_ID'));
1529: if(nvl(ln_new_id,-111)<>nvl(ln_orginal_id,-111)) then
1530: ln_pay_basis_id:=ln_new_id;

Line 1753: return fnd_number.number_to_canonical(ln_length_of_service);

1749: if(hr_utility.debug_enabled) then
1750: -- write debug statements
1751: hr_utility.set_location('Leaving'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
1752: end if;
1753: return fnd_number.number_to_canonical(ln_length_of_service);
1754: EXCEPTION
1755:
1756: WHEN OTHERS THEN
1757: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);

Line 1884: return fnd_number.number_to_canonical(ln_step_id);

1880: if(hr_utility.debug_enabled) then
1881: -- write debug statements
1882: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
1883: end if;
1884: return fnd_number.number_to_canonical(ln_step_id);
1885: EXCEPTION
1886:
1887: WHEN OTHERS THEN
1888: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);

Line 1960: return fnd_number.number_to_canonical(ln_step_id);

1956: if(hr_utility.debug_enabled) then
1957: -- write debug statements
1958: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
1959: end if;
1960: return fnd_number.number_to_canonical(ln_step_id);
1961: EXCEPTION
1962:
1963: WHEN OTHERS THEN
1964: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);

Line 2037: return fnd_number.number_to_canonical(ln_step_id);

2033: if(hr_utility.debug_enabled) then
2034: -- write debug statements
2035: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
2036: end if;
2037: return fnd_number.number_to_canonical(ln_step_id);
2038: EXCEPTION
2039:
2040: WHEN OTHERS THEN
2041: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);

Line 2112: return fnd_number.number_to_canonical(ln_step_id);

2108: if(hr_utility.debug_enabled) then
2109: -- write debug statements
2110: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
2111: end if;
2112: return fnd_number.number_to_canonical(ln_step_id);
2113: EXCEPTION
2114:
2115: WHEN OTHERS THEN
2116: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);

Line 2188: return fnd_number.number_to_canonical(ln_pay_basis_id);

2184: if(hr_utility.debug_enabled) then
2185: -- write debug statements
2186: hr_utility.set_location('Leaving'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
2187: end if;
2188: return fnd_number.number_to_canonical(ln_pay_basis_id);
2189: EXCEPTION
2190:
2191: WHEN OTHERS THEN
2192: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);