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

Line 548: l_value := fnd_number.canonical_to_number(C_Pay_Grade_Rec.value);

544: Loop
545: l_rate_type := C_Pay_Grade_Rec.rate_type;
546: if (l_rate_type = 'G') then
547: l_rate_or_payscale_id := C_Pay_Grade_Rec.rate_id;
548: l_value := fnd_number.canonical_to_number(C_Pay_Grade_Rec.value);
549: l_salary_type := 'RATE';
550: else
551: l_grade_or_spinal_point_id := C_Pay_Grade_Rec.grade_or_spinal_point_id;
552: l_sequence := C_Pay_Grade_Rec.sequence;

Line 553: l_value := fnd_number.canonical_to_number(C_Pay_Grade_Rec.value);

549: l_salary_type := 'RATE';
550: else
551: l_grade_or_spinal_point_id := C_Pay_Grade_Rec.grade_or_spinal_point_id;
552: l_sequence := C_Pay_Grade_Rec.sequence;
553: l_value := fnd_number.canonical_to_number(C_Pay_Grade_Rec.value);
554: l_salary_type := 'STEP';
555:
556: -- Start bug no 3902996
557: For C_Payscale_rec in C_Payscale

Line 1333: l_element_value := fnd_number.canonical_to_number(salary_rec.value);

1329: l_session_date,
1330: salary_rec.grade_or_spinal_point_id,
1331: Grade_rec.grade_spine_id);
1332:
1333: l_element_value := fnd_number.canonical_to_number(salary_rec.value);
1334:
1335: INSERT INTO PSB_SALARY_I
1336: ( BUSINESS_GROUP_ID,
1337: DATA_EXTRACT_ID,

Line 1427: l_minimum_value := fnd_number.canonical_to_number(salary_rec.minimum);

1423: Loop
1424: l_grade_name := C_grade_rec.name;
1425: End Loop;
1426:
1427: l_minimum_value := fnd_number.canonical_to_number(salary_rec.minimum);
1428: l_maximum_value := fnd_number.canonical_to_number(salary_rec.maximum);
1429: l_mid_value := fnd_number.canonical_to_number(salary_rec.mid_value);
1430: l_element_value := fnd_number.canonical_to_number(salary_rec.value);
1431: l_sequence := salary_rec.sequence;

Line 1428: l_maximum_value := fnd_number.canonical_to_number(salary_rec.maximum);

1424: l_grade_name := C_grade_rec.name;
1425: End Loop;
1426:
1427: l_minimum_value := fnd_number.canonical_to_number(salary_rec.minimum);
1428: l_maximum_value := fnd_number.canonical_to_number(salary_rec.maximum);
1429: l_mid_value := fnd_number.canonical_to_number(salary_rec.mid_value);
1430: l_element_value := fnd_number.canonical_to_number(salary_rec.value);
1431: l_sequence := salary_rec.sequence;
1432:

Line 1429: l_mid_value := fnd_number.canonical_to_number(salary_rec.mid_value);

1425: End Loop;
1426:
1427: l_minimum_value := fnd_number.canonical_to_number(salary_rec.minimum);
1428: l_maximum_value := fnd_number.canonical_to_number(salary_rec.maximum);
1429: l_mid_value := fnd_number.canonical_to_number(salary_rec.mid_value);
1430: l_element_value := fnd_number.canonical_to_number(salary_rec.value);
1431: l_sequence := salary_rec.sequence;
1432:
1433: INSERT INTO PSB_SALARY_I

Line 1430: l_element_value := fnd_number.canonical_to_number(salary_rec.value);

1426:
1427: l_minimum_value := fnd_number.canonical_to_number(salary_rec.minimum);
1428: l_maximum_value := fnd_number.canonical_to_number(salary_rec.maximum);
1429: l_mid_value := fnd_number.canonical_to_number(salary_rec.mid_value);
1430: l_element_value := fnd_number.canonical_to_number(salary_rec.value);
1431: l_sequence := salary_rec.sequence;
1432:
1433: INSERT INTO PSB_SALARY_I
1434: ( BUSINESS_GROUP_ID,

Line 4029: vdef_col := fnd_number.number_to_canonical(vdef_col2);

4025: vdef_col := vdef_col1;
4026: elsif (attribute_rec.data_type = 'N') then
4027: begin
4028: DBMS_SQL.COLUMN_VALUE(v_cursorid,1,vdef_col2);
4029: vdef_col := fnd_number.number_to_canonical(vdef_col2);
4030: exception
4031: when INVALID_NUMBER then
4032:
4033: -- Changed the exception part for Bug #4658351

Line 5562: v_osegment := fnd_number.number_to_canonical(v_onumber);

5558: end;
5559: elsif (Emp_attribute_rec.data_type = 'N') then
5560: begin
5561: dbms_sql.column_value(v_ocursorid,1,v_onumber);
5562: v_osegment := fnd_number.number_to_canonical(v_onumber);
5563: exception
5564: when INVALID_NUMBER then
5565:
5566: -- Changed the exception part for Bug#4658351

Line 5826: lp_fte := fnd_number.number_to_canonical(l_fte);

5822: /*For Bug No : 2109120 End*/
5823:
5824: if (l_fte is not null) then
5825:
5826: lp_fte := fnd_number.number_to_canonical(l_fte);
5827:
5828: INSERT INTO PSB_EMPLOYEE_ASSIGNMENTS_I
5829: ( HR_POSITION_ID ,
5830: HR_EMPLOYEE_ID ,

Line 5868: lp_default_weekly_hours := fnd_number.number_to_canonical(l_default_weekly_hours);

5864: --changed the condition from frequency to working_hours
5865: --and added the inner if condition
5866: if (Employee_Rec.working_hours is not null) then
5867: l_default_weekly_hours := Employee_Rec.working_hours;
5868: lp_default_weekly_hours := fnd_number.number_to_canonical(l_default_weekly_hours);
5869:
5870: if(Employee_Rec.freq_flag = 'P') then
5871:
5872: /* start bug 4153562 */