DBA Data[Home] [Help]

APPS.PSB_HR_POPULATE_DATA_PVT dependencies on FND_NUMBER

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

425: ' ratetype ' || l_rate_type,336);
426:
427: if (l_rate_type = 'G') then
428: l_rate_or_payscale_id := C_Pay_Grade_Rec.rate_id;
429: l_value := fnd_number.canonical_to_number(C_Pay_Grade_Rec.value);
430: l_salary_type := 'RATE';
431:
432: hr_utility.set_location(' payscale '||l_rate_or_payscale_id,335);
433: For C_Rate_Rec in C_Rate

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

445:
446: else
447: l_grade_or_spinal_point_id := C_Pay_Grade_Rec.grade_or_spinal_point_id;
448: l_sequence := C_Pay_Grade_Rec.sequence;
449: l_value := fnd_number.canonical_to_number( C_Pay_Grade_Rec.value);
450: l_salary_type := 'STEP';
451:
452: For C_grade_spine_rec in C_grade_spine
453: Loop

Line 610: fnd_number.canonical_to_number(C_Pay_Grade_Rec.value),

606: p_effective_END_DATE => p_date_end,
607: p_worksheet_id => NULL,
608: p_element_value_type => 'A',
609: p_element_value =>
610: fnd_number.canonical_to_number(C_Pay_Grade_Rec.value),
611: p_pay_basIS => l_pay_basis,
612: p_FORmula_id => NULL,
613: p_maximum_value =>
614: fnd_number.canonical_to_number(C_Pay_Grade_Rec.maximum),

Line 614: fnd_number.canonical_to_number(C_Pay_Grade_Rec.maximum),

610: fnd_number.canonical_to_number(C_Pay_Grade_Rec.value),
611: p_pay_basIS => l_pay_basis,
612: p_FORmula_id => NULL,
613: p_maximum_value =>
614: fnd_number.canonical_to_number(C_Pay_Grade_Rec.maximum),
615: p_mid_value =>
616: fnd_number.canonical_to_number(C_Pay_Grade_Rec.mid_value),
617: p_minimum_value =>
618: fnd_number.canonical_to_number(C_Pay_Grade_Rec.minimum),

Line 616: fnd_number.canonical_to_number(C_Pay_Grade_Rec.mid_value),

612: p_FORmula_id => NULL,
613: p_maximum_value =>
614: fnd_number.canonical_to_number(C_Pay_Grade_Rec.maximum),
615: p_mid_value =>
616: fnd_number.canonical_to_number(C_Pay_Grade_Rec.mid_value),
617: p_minimum_value =>
618: fnd_number.canonical_to_number(C_Pay_Grade_Rec.minimum),
619: p_currency_code => l_currency_code,
620: p_last_update_date => l_last_update_date,

Line 618: fnd_number.canonical_to_number(C_Pay_Grade_Rec.minimum),

614: fnd_number.canonical_to_number(C_Pay_Grade_Rec.maximum),
615: p_mid_value =>
616: fnd_number.canonical_to_number(C_Pay_Grade_Rec.mid_value),
617: p_minimum_value =>
618: fnd_number.canonical_to_number(C_Pay_Grade_Rec.minimum),
619: p_currency_code => l_currency_code,
620: p_last_update_date => l_last_update_date,
621: p_last_updated_by => l_last_updated_by,
622: p_last_update_login => l_last_update_login,

Line 955: lp_attribute_value := fnd_number.number_to_canonical(p_working_hours);

951: l_valid_attribute := 'Y' ;
952:
953: elsif C_Attribute_Rec.system_attribute_type = 'DEFAULT_WEEKLY_HOURS' then
954: if (p_frequency = 'W') then
955: lp_attribute_value := fnd_number.number_to_canonical(p_working_hours);
956: end if;
957: l_valid_attribute := 'Y' ;
958: -- Bug#2109120: Commenting
959: /*

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

1272: end;
1273: elsif (C_Attribute_Rec.data_type = 'N') then
1274: begin
1275: dbms_sql.column_value(v_ocursorid,1,v_onumber);
1276: v_osegment := fnd_number.number_to_canonical(v_onumber);
1277: exception
1278: when INVALID_NUMBER then
1279:
1280: -- Changed the exception part for Bug#4658351