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 834: if(hr_transaction_api.get_varchar2_value(ln_step_id,'p_multiple_components')='Y') then

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

Line 836: ln_no_of_components :=hr_transaction_api.get_number_value

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

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

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

Line 1609: lv_orginal_value:= hr_transaction_api.get_original_varchar2_value

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

Line 1653: lv_leaving_reason:= hr_transaction_api.get_varchar2_value

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

Line 1781: lv_new_value:= hr_transaction_api.get_varchar2_value

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

Line 1785: lv_orginal_value:= hr_transaction_api.get_original_varchar2_value

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

Line 2178: ln_pay_basis_id := hr_transaction_api.get_number_value

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

Line 2254: l_new_pay_basis_id := hr_transaction_api.get_number_value

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

Line 2258: l_payroll_id := hr_transaction_api.get_number_value

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

Line 2262: l_assignment_id := hr_transaction_api.get_number_value

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