DBA Data[Home] [Help]

APPS.PAY_SE_RULES dependencies on FND_NUMBER

Line 567: load_xml('D', 'EMEA ELEMENT INFO', 'ACTION_INFORMATION4', fnd_number.canonical_to_number(element_info_rec.value));

563: --load_xml('D', 'EMEA ELEMENT DEFINITION', 'ACTION_INFORMATION7', element_info_rec.CODE);
564: load_xml('DIRECT', NULL, 'ELEMENT_CODE', element_info_rec.CODE);
565: load_xml('D', 'EMEA ELEMENT INFO', 'ACTION_INFORMATION8', element_info_rec.record_count);
566: load_xml('DIRECT', NULL, 'UNIT_PRICE', element_info_rec.unit_price);
567: load_xml('D', 'EMEA ELEMENT INFO', 'ACTION_INFORMATION4', fnd_number.canonical_to_number(element_info_rec.value));
568: load_xml('CE', NULL, 'ELEMENT DETAILS', NULL);
569:
570: IF element_info_rec.type = 'E' THEN
571: l_total_earnings := fnd_number.canonical_to_number(l_total_earnings) + fnd_number.canonical_to_number(nvl(element_info_rec.value,0)) ;

Line 571: l_total_earnings := fnd_number.canonical_to_number(l_total_earnings) + fnd_number.canonical_to_number(nvl(element_info_rec.value,0)) ;

567: load_xml('D', 'EMEA ELEMENT INFO', 'ACTION_INFORMATION4', fnd_number.canonical_to_number(element_info_rec.value));
568: load_xml('CE', NULL, 'ELEMENT DETAILS', NULL);
569:
570: IF element_info_rec.type = 'E' THEN
571: l_total_earnings := fnd_number.canonical_to_number(l_total_earnings) + fnd_number.canonical_to_number(nvl(element_info_rec.value,0)) ;
572: ELSIF element_info_rec.type = 'D' THEN
573: l_total_deductions := fnd_number.canonical_to_number(l_total_deductions) + fnd_number.canonical_to_number(nvl(element_info_rec.value,0)) ;
574: END IF ;
575: l_total_pay := l_total_earnings - l_total_deductions ;

Line 573: l_total_deductions := fnd_number.canonical_to_number(l_total_deductions) + fnd_number.canonical_to_number(nvl(element_info_rec.value,0)) ;

569:
570: IF element_info_rec.type = 'E' THEN
571: l_total_earnings := fnd_number.canonical_to_number(l_total_earnings) + fnd_number.canonical_to_number(nvl(element_info_rec.value,0)) ;
572: ELSIF element_info_rec.type = 'D' THEN
573: l_total_deductions := fnd_number.canonical_to_number(l_total_deductions) + fnd_number.canonical_to_number(nvl(element_info_rec.value,0)) ;
574: END IF ;
575: l_total_pay := l_total_earnings - l_total_deductions ;
576:
577: END LOOP;

Line 591: load_xml('D', 'EMEA ELEMENT INFO', 'ACTION_INFORMATION4', fnd_number.canonical_to_number(add_element_info_rec.value));

587: load_xml('D', 'EMEA ELEMENT DEFINITION', 'ACTION_INFORMATION6', add_element_info_rec.uom);
588: load_xml('DIRECT', NULL, 'ELEMENT_CODE', add_element_info_rec.CODE);
589: load_xml('D', 'EMEA ELEMENT INFO', 'ACTION_INFORMATION8', add_element_info_rec.record_count);
590: load_xml('DIRECT', NULL, 'UNIT_PRICE', add_element_info_rec.unit_price);
591: load_xml('D', 'EMEA ELEMENT INFO', 'ACTION_INFORMATION4', fnd_number.canonical_to_number(add_element_info_rec.value));
592:
593: load_xml('CE', NULL, 'ELEMENT DETAILS', NULL);
594:
595: END LOOP;