APPS.PAY_NL_IZA_UPLOAD dependencies on FND_NUMBER

Line 1028: l_contribution1 := fnd_number.canonical_to_number(substr(p_line_read,85,5) || '.' || substr(p_line_read,90,2)) ;

1024: l_iza_corr2_end_date:=last_day(to_date(l_iza_corr2_yr_mm,'YYYYMM'));
1025: END IF;
1026:
1027: l_contribution1_sign := substr(p_line_read,92,1);
1028: l_contribution1 := fnd_number.canonical_to_number(substr(p_line_read,85,5) || '.' || substr(p_line_read,90,2)) ;
1029: IF l_contribution1_sign = '-' THEN
1030: l_contribution1 := (-1) * l_contribution1;
1031: END IF;
1032:

Line 1034: l_corr_cont1 := fnd_number.canonical_to_number(substr(p_line_read,93,5) || '.' || substr(p_line_read,98,2));

1030: l_contribution1 := (-1) * l_contribution1;
1031: END IF;
1032:
1033: l_corr_cont1_sign := substr(p_line_read,100,1);
1034: l_corr_cont1 := fnd_number.canonical_to_number(substr(p_line_read,93,5) || '.' || substr(p_line_read,98,2));
1035: IF l_corr_cont1_sign = '-' THEN
1036: l_corr_cont1 := (-1) * l_corr_cont1;
1037: END IF;
1038:

Line 1040: l_contribution2 := fnd_number.canonical_to_number(substr(p_line_read,110,5) || '.' || substr(p_line_read,115,2));

1036: l_corr_cont1 := (-1) * l_corr_cont1;
1037: END IF;
1038:
1039: l_contribution2_sign := substr(p_line_read,117,1);
1040: l_contribution2 := fnd_number.canonical_to_number(substr(p_line_read,110,5) || '.' || substr(p_line_read,115,2));
1041: IF l_contribution2_sign = '-' THEN
1042: l_contribution2 := (-1) * l_contribution2;
1043: END IF;
1044:

Line 1046: l_corr_cont2 := fnd_number.canonical_to_number(substr(p_line_read,118,5) || '.' || substr(p_line_read,123,2));

1042: l_contribution2 := (-1) * l_contribution2;
1043: END IF;
1044:
1045: l_corr_cont2_sign := substr(p_line_read,125,1);
1046: l_corr_cont2 := fnd_number.canonical_to_number(substr(p_line_read,118,5) || '.' || substr(p_line_read,123,2));
1047: IF l_corr_cont2_sign = '-' THEN
1048: l_corr_cont2 := (-1) * l_corr_cont2;
1049: END IF;
1050:

Line 1176: ,p_value_1 => fnd_number.number_to_canonical(l_contribution1)

1172: ,p_effective_date => l_entry_eff_date
1173: ,p_date_earned => l_entry_eff_date
1174: ,p_element_name => l_element_name
1175: ,p_element_type_id => g_element_type_id
1176: ,p_value_1 => fnd_number.number_to_canonical(l_contribution1)
1177: ,p_bline_id => p_batch_line_id
1178: ,p_obj_vn => p_bl_ovn
1179: );
1180: END IF;

Line 1194: ,p_value_1 => fnd_number.number_to_canonical(l_corr_cont1)

1190: ,p_effective_date => l_entry_corr_eff_date
1191: ,p_date_earned => l_entry_corr_eff_date
1192: ,p_element_name => l_element_name
1193: ,p_element_type_id => g_element_type_id
1194: ,p_value_1 => fnd_number.number_to_canonical(l_corr_cont1)
1195: ,p_bline_id => p_batch_line_id
1196: ,p_obj_vn => p_bl_ovn
1197: );
1198:

Line 1215: ,p_value_1 => fnd_number.number_to_canonical(l_contribution2)

1211: ,p_effective_date => l_entry_eff_date
1212: ,p_date_earned => l_entry_eff_date
1213: ,p_element_name => l_element_name
1214: ,p_element_type_id => g_element_type_id
1215: ,p_value_1 => fnd_number.number_to_canonical(l_contribution2)
1216: ,p_bline_id => p_batch_line_id
1217: ,p_obj_vn => p_bl_ovn
1218: );
1219: END IF;

Line 1235: ,p_value_1 => fnd_number.number_to_canonical(l_corr_cont2)

1231: ,p_effective_date => l_entry_corr2_eff_date
1232: ,p_date_earned => l_entry_corr2_eff_date
1233: ,p_element_name => l_element_name
1234: ,p_element_type_id => g_element_type_id
1235: ,p_value_1 => fnd_number.number_to_canonical(l_corr_cont2)
1236: ,p_bline_id => p_batch_line_id
1237: ,p_obj_vn => p_bl_ovn
1238: );
1239: