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 HR_TRANSACTION_API

Line 753: if(hr_transaction_api.get_varchar2_value(ln_step_id,'p_multiple_components')='Y') then

749: ln_salary_percent_change := null;
750: else
751: -- fix for bug 4148680
752: if (is_new_change_pay (ln_step_id)= ame_util.booleanAttributeFalse)then
753: if(hr_transaction_api.get_varchar2_value(ln_step_id,'p_multiple_components')='Y') then
754: -- get number of components P_NO_OF_COMPONENTS
755:
756: ln_no_of_components :=hr_transaction_api.get_number_value
757: (p_transaction_step_id => ln_step_id,

Line 756: ln_no_of_components :=hr_transaction_api.get_number_value

752: if (is_new_change_pay (ln_step_id)= ame_util.booleanAttributeFalse)then
753: if(hr_transaction_api.get_varchar2_value(ln_step_id,'p_multiple_components')='Y') then
754: -- get number of components P_NO_OF_COMPONENTS
755:
756: ln_no_of_components :=hr_transaction_api.get_number_value
757: (p_transaction_step_id => ln_step_id,
758: p_name =>'P_NO_OF_COMPONENTS');
759: ln_salary_percent_change:= 0;
760: FOR i in 1..ln_no_of_components

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 769: ln_salary_percent_change:= hr_transaction_api.get_number_value

765: p_name =>lv_param_name));
766: end loop;
767: else
768:
769: ln_salary_percent_change:= hr_transaction_api.get_number_value
770: (p_transaction_step_id => ln_step_id,
771: p_name =>'p_change_percent');
772: end if;
773:

Line 835: if(hr_transaction_api.get_varchar2_value(ln_step_id,'p_multiple_components')='Y') then

831: ln_salary_amt_change := null;
832: else
833: if (is_new_change_pay(ln_step_id) = ame_util.booleanAttributeFalse) then
834: -- fix for bug 4148680
835: if(hr_transaction_api.get_varchar2_value(ln_step_id,'p_multiple_components')='Y') then
836: -- get number of components P_NO_OF_COMPONENTS
837: ln_no_of_components :=hr_transaction_api.get_number_value
838: (p_transaction_step_id => ln_step_id,
839: p_name =>'P_NO_OF_COMPONENTS');

Line 837: ln_no_of_components :=hr_transaction_api.get_number_value

833: if (is_new_change_pay(ln_step_id) = ame_util.booleanAttributeFalse) then
834: -- fix for bug 4148680
835: if(hr_transaction_api.get_varchar2_value(ln_step_id,'p_multiple_components')='Y') then
836: -- get number of components P_NO_OF_COMPONENTS
837: ln_no_of_components :=hr_transaction_api.get_number_value
838: (p_transaction_step_id => ln_step_id,
839: p_name =>'P_NO_OF_COMPONENTS');
840: ln_salary_amt_change:= 0;
841: FOR i in 1..ln_no_of_components

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 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 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 1607: lv_new_value:= hr_transaction_api.get_varchar2_value

1603:
1604: ln_step_id := get_assignment_step_id(p_transaction_id);
1605: if(ln_step_id is not null) then
1606:
1607: lv_new_value:= hr_transaction_api.get_varchar2_value
1608: (p_transaction_step_id => ln_step_id
1609: ,p_name => 'P_CHANGE_REASON');
1610:
1611: lv_orginal_value:= hr_transaction_api.get_original_varchar2_value

Line 1611: lv_orginal_value:= hr_transaction_api.get_original_varchar2_value

1607: lv_new_value:= hr_transaction_api.get_varchar2_value
1608: (p_transaction_step_id => ln_step_id
1609: ,p_name => 'P_CHANGE_REASON');
1610:
1611: lv_orginal_value:= hr_transaction_api.get_original_varchar2_value
1612: (p_transaction_step_id => ln_step_id
1613: ,p_name => 'P_CHANGE_REASON');
1614:
1615: if(nvl(lv_new_value,'-111')<>nvl(lv_orginal_value,'-111')) then

Line 1655: lv_leaving_reason:= hr_transaction_api.get_varchar2_value

1651: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
1652: end if;
1653: ln_step_id := get_termination_step_id(p_transaction_id);
1654: if(ln_step_id is not null) then
1655: lv_leaving_reason:= hr_transaction_api.get_varchar2_value
1656: (p_transaction_step_id => ln_step_id
1657: ,p_name => 'P_LEAVING_REASON');
1658: else
1659: lv_leaving_reason:= null;

Line 1783: lv_new_value:= hr_transaction_api.get_varchar2_value

1779: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
1780: end if;
1781: ln_step_id := get_assignment_step_id(p_transaction_id);
1782: if(ln_step_id is not null) then
1783: lv_new_value:= hr_transaction_api.get_varchar2_value
1784: (p_transaction_step_id => ln_step_id
1785: ,p_name => 'P_EMPLOYMENT_CATEGORY');
1786:
1787: lv_orginal_value:= hr_transaction_api.get_original_varchar2_value

Line 1787: lv_orginal_value:= hr_transaction_api.get_original_varchar2_value

1783: lv_new_value:= hr_transaction_api.get_varchar2_value
1784: (p_transaction_step_id => ln_step_id
1785: ,p_name => 'P_EMPLOYMENT_CATEGORY');
1786:
1787: lv_orginal_value:= hr_transaction_api.get_original_varchar2_value
1788: (p_transaction_step_id => ln_step_id
1789: ,p_name => 'P_EMPLOYMENT_CATEGORY');
1790:
1791: if(nvl(lv_new_value,'-111')<>nvl(lv_orginal_value,'-111')) then

Line 2180: ln_pay_basis_id := hr_transaction_api.get_number_value

2176: end if;
2177:
2178: ln_step_id := get_assignment_step_id(p_transaction_id);
2179: if(ln_step_id is not null) then
2180: ln_pay_basis_id := hr_transaction_api.get_number_value
2181: (p_transaction_step_id => ln_step_id
2182: ,p_name => 'P_PAY_BASIS_ID');
2183:
2184: end if;

Line 2256: l_new_pay_basis_id := hr_transaction_api.get_number_value

2252: (p_transaction_step_id => l_asg_txn_step_id),
2253: hr_transaction_ss.g_date_format);
2254:
2255: -- Get the pay_basis_id and payroll_id
2256: l_new_pay_basis_id := hr_transaction_api.get_number_value
2257: (p_transaction_step_id => l_asg_txn_step_id
2258: ,p_name => 'P_PAY_BASIS_ID');
2259:
2260: l_payroll_id := hr_transaction_api.get_number_value

Line 2260: l_payroll_id := hr_transaction_api.get_number_value

2256: l_new_pay_basis_id := hr_transaction_api.get_number_value
2257: (p_transaction_step_id => l_asg_txn_step_id
2258: ,p_name => 'P_PAY_BASIS_ID');
2259:
2260: l_payroll_id := hr_transaction_api.get_number_value
2261: (p_transaction_step_id => l_asg_txn_step_id
2262: ,p_name => 'P_PAYROLL_ID');
2263:
2264: l_assignment_id := hr_transaction_api.get_number_value

Line 2264: l_assignment_id := hr_transaction_api.get_number_value

2260: l_payroll_id := hr_transaction_api.get_number_value
2261: (p_transaction_step_id => l_asg_txn_step_id
2262: ,p_name => 'P_PAYROLL_ID');
2263:
2264: l_assignment_id := hr_transaction_api.get_number_value
2265: (p_transaction_step_id => l_asg_txn_step_id
2266: ,p_name => 'P_ASSIGNMENT_ID');
2267:
2268: -- Now get the old pay basis id