DBA Data[Home] [Help]

APPS.PAY_NO_PACCR_PKG dependencies on FND_NUMBER

Line 671: Hr_utility.trace('#- FND_NUMBER.NUMBER_TO_CANONICAL..csr_rec.costed_value '||FND_NUMBER.NUMBER_TO_CANONICAL(csr_rec.costed_value));

667: l_ele_code := rec_ele_code.ele_code;
668: Hr_utility.trace('#- l_ele_code '||l_ele_code);
669: --
670: Hr_utility.trace('#- csr_rec.costed_value '||csr_rec.costed_value);
671: Hr_utility.trace('#- FND_NUMBER.NUMBER_TO_CANONICAL..csr_rec.costed_value '||FND_NUMBER.NUMBER_TO_CANONICAL(csr_rec.costed_value));
672: -- Uncommenting this part for bug fix 6069852
673: --l_cost_value := FND_NUMBER.NUMBER_TO_CANONICAL(csr_rec.costed_value);
674: Hr_utility.trace('#- l_ele_code '||l_ele_code);
675: --

Line 673: --l_cost_value := FND_NUMBER.NUMBER_TO_CANONICAL(csr_rec.costed_value);

669: --
670: Hr_utility.trace('#- csr_rec.costed_value '||csr_rec.costed_value);
671: Hr_utility.trace('#- FND_NUMBER.NUMBER_TO_CANONICAL..csr_rec.costed_value '||FND_NUMBER.NUMBER_TO_CANONICAL(csr_rec.costed_value));
672: -- Uncommenting this part for bug fix 6069852
673: --l_cost_value := FND_NUMBER.NUMBER_TO_CANONICAL(csr_rec.costed_value);
674: Hr_utility.trace('#- l_ele_code '||l_ele_code);
675: --
676: Hr_utility.trace('#- l_eoy_code '||l_eoy_code);
677: Hr_utility.trace('#- csr_rec.ele_type_id '||csr_rec.ele_type_id);

Line 737: ,p_action_information14 => fnd_number.number_to_canonical(csr_rec.costed_value) -- Individual Costing Value

733: ,p_action_information10 => csr_rec.ele_cost_seg -- Element Costing Flexfield Segments
734: ,p_action_information11 => csr_rec.cost_flex_id -- Costing Flexfield ID
735: ,p_action_information12 => csr_rec.debit_credit -- Debit or Credit Flag
736: ,p_action_information13 => l_ele_code -- Element Code
737: ,p_action_information14 => fnd_number.number_to_canonical(csr_rec.costed_value) -- Individual Costing Value
738: ,p_action_information15 => csr_rec.cost_or_bal -- Cost or Balance Flag
739: ,p_action_information16 => csr_rec.effective_date -- Costing Effective Date
740: ,p_action_information17 => csr_rec.emp_name -- Employee Name
741: );

Line 815: ,sum(fnd_number.canonical_to_number(action_information14)) costed_value

811: ,action_information9 eoy_code
812: ,action_information10 concatenated_segments
813: ,to_number(action_information11) cost_allocation_keyflex_id
814: ,action_information12 debit_or_credit
815: ,sum(fnd_number.canonical_to_number(action_information14)) costed_value
816: ,action_information15 balance_or_cost
817: ,tax_unit_id leg_emp_id
818: ,to_number(action_information6) local_unit_id
819: ,effective_date

Line 900: l_sum_cost_value := fnd_number.number_to_canonical(rec_costing_summary.costed_value);

896: OPEN csr_ele_code(l_ele_type_id,l_le_id);
897: FETCH csr_ele_code INTO rec_ele_code;
898: CLOSE csr_ele_code;
899: l_ele_code := rec_ele_code.ele_code;
900: l_sum_cost_value := fnd_number.number_to_canonical(rec_costing_summary.costed_value);
901: -- Archive the SUMMARY REPORT DETAILS
902: pay_action_information_api.create_action_information
903: (p_action_information_id => l_action_info_id -- out parameter
904: ,p_object_version_number => l_ovn -- out parameter

Line 1209: hr_utility.set_location('COST_DEBIT/COST_CREDIT'||fnd_number.canonical_to_number(rec_get_summ_info.action_information13),45);

1205: xml_tab(l_counter).TagName :='COST_OR_BAL';
1206: xml_tab(l_counter).TagValue :=rec_get_summ_info.action_information14;
1207: l_counter := l_counter + 1;
1208: --
1209: hr_utility.set_location('COST_DEBIT/COST_CREDIT'||fnd_number.canonical_to_number(rec_get_summ_info.action_information13),45);
1210: hr_utility.set_location('C/D'||rec_get_summ_info.action_information11,46);
1211: IF( rec_get_summ_info.action_information11 = 'D') THEN
1212: xml_tab(l_counter).TagName :='COST_DEBIT';
1213: xml_tab(l_counter).TagValue := fnd_number.canonical_to_number(rec_get_summ_info.action_information13);

Line 1213: xml_tab(l_counter).TagValue := fnd_number.canonical_to_number(rec_get_summ_info.action_information13);

1209: hr_utility.set_location('COST_DEBIT/COST_CREDIT'||fnd_number.canonical_to_number(rec_get_summ_info.action_information13),45);
1210: hr_utility.set_location('C/D'||rec_get_summ_info.action_information11,46);
1211: IF( rec_get_summ_info.action_information11 = 'D') THEN
1212: xml_tab(l_counter).TagName :='COST_DEBIT';
1213: xml_tab(l_counter).TagValue := fnd_number.canonical_to_number(rec_get_summ_info.action_information13);
1214: l_counter := l_counter + 1;
1215: l_total_cost_debit := l_total_cost_debit + fnd_number.canonical_to_number(rec_get_summ_info.action_information13);
1216: ELSIF( rec_get_summ_info.action_information11 ='C') THEN
1217: xml_tab(l_counter).TagName :='COST_CREDIT';

Line 1215: l_total_cost_debit := l_total_cost_debit + fnd_number.canonical_to_number(rec_get_summ_info.action_information13);

1211: IF( rec_get_summ_info.action_information11 = 'D') THEN
1212: xml_tab(l_counter).TagName :='COST_DEBIT';
1213: xml_tab(l_counter).TagValue := fnd_number.canonical_to_number(rec_get_summ_info.action_information13);
1214: l_counter := l_counter + 1;
1215: l_total_cost_debit := l_total_cost_debit + fnd_number.canonical_to_number(rec_get_summ_info.action_information13);
1216: ELSIF( rec_get_summ_info.action_information11 ='C') THEN
1217: xml_tab(l_counter).TagName :='COST_CREDIT';
1218: xml_tab(l_counter).TagValue := fnd_number.canonical_to_number(rec_get_summ_info.action_information13);
1219: l_counter := l_counter + 1;

Line 1218: xml_tab(l_counter).TagValue := fnd_number.canonical_to_number(rec_get_summ_info.action_information13);

1214: l_counter := l_counter + 1;
1215: l_total_cost_debit := l_total_cost_debit + fnd_number.canonical_to_number(rec_get_summ_info.action_information13);
1216: ELSIF( rec_get_summ_info.action_information11 ='C') THEN
1217: xml_tab(l_counter).TagName :='COST_CREDIT';
1218: xml_tab(l_counter).TagValue := fnd_number.canonical_to_number(rec_get_summ_info.action_information13);
1219: l_counter := l_counter + 1;
1220: l_total_cost_credit := l_total_cost_credit + fnd_number.canonical_to_number(rec_get_summ_info.action_information13);
1221: END IF;
1222: --

Line 1220: l_total_cost_credit := l_total_cost_credit + fnd_number.canonical_to_number(rec_get_summ_info.action_information13);

1216: ELSIF( rec_get_summ_info.action_information11 ='C') THEN
1217: xml_tab(l_counter).TagName :='COST_CREDIT';
1218: xml_tab(l_counter).TagValue := fnd_number.canonical_to_number(rec_get_summ_info.action_information13);
1219: l_counter := l_counter + 1;
1220: l_total_cost_credit := l_total_cost_credit + fnd_number.canonical_to_number(rec_get_summ_info.action_information13);
1221: END IF;
1222: --
1223: xml_tab(l_counter).TagName :='COSTING_START';
1224: xml_tab(l_counter).TagValue :='COSTING_END';

Line 1349: ,fnd_number.canonical_to_number(action_information14)

1345: ,action_information15
1346: ,action_information12
1347: ,action_information5
1348: ,fnd_date.date_to_canonical(action_information16)
1349: ,fnd_number.canonical_to_number(action_information14)
1350: ,effective_date;
1351:
1352:
1353: rec_get_hdr_info csr_get_hdr_info%ROWTYPE;

Line 1553: hr_utility.set_location('COST_DEBIT/COST_CREDIT'||fnd_number.canonical_to_number(rec_get_det_info.action_information14),76);

1549: xml_tab(l_counter).TagName :='COST_OR_BAL';
1550: xml_tab(l_counter).TagValue := rec_get_det_info.action_information15;
1551: l_counter := l_counter + 1;
1552: --
1553: hr_utility.set_location('COST_DEBIT/COST_CREDIT'||fnd_number.canonical_to_number(rec_get_det_info.action_information14),76);
1554: hr_utility.set_location('C/D'||rec_get_det_info.action_information12,77);
1555: IF( rec_get_det_info.action_information12 = 'D') THEN
1556: xml_tab(l_counter).TagName :='COST_DEBIT';
1557: xml_tab(l_counter).TagValue := fnd_number.canonical_to_number(rec_get_det_info.action_information14);

Line 1557: xml_tab(l_counter).TagValue := fnd_number.canonical_to_number(rec_get_det_info.action_information14);

1553: hr_utility.set_location('COST_DEBIT/COST_CREDIT'||fnd_number.canonical_to_number(rec_get_det_info.action_information14),76);
1554: hr_utility.set_location('C/D'||rec_get_det_info.action_information12,77);
1555: IF( rec_get_det_info.action_information12 = 'D') THEN
1556: xml_tab(l_counter).TagName :='COST_DEBIT';
1557: xml_tab(l_counter).TagValue := fnd_number.canonical_to_number(rec_get_det_info.action_information14);
1558: l_counter := l_counter + 1;
1559: l_total_cost_debit := l_total_cost_debit + fnd_number.canonical_to_number(rec_get_det_info.action_information14);
1560: ELSIF( rec_get_det_info.action_information12 ='C') THEN
1561: xml_tab(l_counter).TagName :='COST_CREDIT';

Line 1559: l_total_cost_debit := l_total_cost_debit + fnd_number.canonical_to_number(rec_get_det_info.action_information14);

1555: IF( rec_get_det_info.action_information12 = 'D') THEN
1556: xml_tab(l_counter).TagName :='COST_DEBIT';
1557: xml_tab(l_counter).TagValue := fnd_number.canonical_to_number(rec_get_det_info.action_information14);
1558: l_counter := l_counter + 1;
1559: l_total_cost_debit := l_total_cost_debit + fnd_number.canonical_to_number(rec_get_det_info.action_information14);
1560: ELSIF( rec_get_det_info.action_information12 ='C') THEN
1561: xml_tab(l_counter).TagName :='COST_CREDIT';
1562: xml_tab(l_counter).TagValue := fnd_number.canonical_to_number(rec_get_det_info.action_information14);
1563: l_counter := l_counter + 1;

Line 1562: xml_tab(l_counter).TagValue := fnd_number.canonical_to_number(rec_get_det_info.action_information14);

1558: l_counter := l_counter + 1;
1559: l_total_cost_debit := l_total_cost_debit + fnd_number.canonical_to_number(rec_get_det_info.action_information14);
1560: ELSIF( rec_get_det_info.action_information12 ='C') THEN
1561: xml_tab(l_counter).TagName :='COST_CREDIT';
1562: xml_tab(l_counter).TagValue := fnd_number.canonical_to_number(rec_get_det_info.action_information14);
1563: l_counter := l_counter + 1;
1564: l_total_cost_credit := l_total_cost_credit + fnd_number.canonical_to_number(rec_get_det_info.action_information14);
1565: END IF;
1566: hr_utility.set_location('l_total_cost_debit'||l_total_cost_debit,78);

Line 1564: l_total_cost_credit := l_total_cost_credit + fnd_number.canonical_to_number(rec_get_det_info.action_information14);

1560: ELSIF( rec_get_det_info.action_information12 ='C') THEN
1561: xml_tab(l_counter).TagName :='COST_CREDIT';
1562: xml_tab(l_counter).TagValue := fnd_number.canonical_to_number(rec_get_det_info.action_information14);
1563: l_counter := l_counter + 1;
1564: l_total_cost_credit := l_total_cost_credit + fnd_number.canonical_to_number(rec_get_det_info.action_information14);
1565: END IF;
1566: hr_utility.set_location('l_total_cost_debit'||l_total_cost_debit,78);
1567: hr_utility.set_location('l_total_cost_credit'||l_total_cost_credit,79);
1568: --