DBA Data[Home] [Help]

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 844: ln_salary_amt_change:= ln_salary_amt_change + fnd_number.number_to_canonical(hr_transaction_api.get_number_value

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

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

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

Line 1031: fnd_number.number_to_canonical(hr_transaction_api.get_number_value

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

Line 1035: fnd_number.number_to_canonical(hr_transaction_api.get_number_value

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

Line 1098: return fnd_number.number_to_canonical(lv_selected_person_id);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1408: return fnd_number.number_to_canonical(ln_overall_rating);

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

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

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

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

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

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

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

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

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

Line 1755: return fnd_number.number_to_canonical(ln_length_of_service);

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

Line 1886: return fnd_number.number_to_canonical(ln_step_id);

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

Line 1962: return fnd_number.number_to_canonical(ln_step_id);

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

Line 2039: return fnd_number.number_to_canonical(ln_step_id);

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

Line 2114: return fnd_number.number_to_canonical(ln_step_id);

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

Line 2190: return fnd_number.number_to_canonical(ln_pay_basis_id);

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