DBA Data[Home] [Help]

APPS.PAY_APAC_PAYSLIP_ARCHIVE dependencies on FND_NUMBER

Line 52: canonical using fnd_number.number_to_canonical while archiving.

48: >Changed hr_utility.trace to execute conditionally.
49: 19-Apr-2004 bramajey 115.5 3578040 Renamed procedure range_code to
50: archive_payroll_level_data
51: 04-May-2004 bramajey 115.6 3604206 Added code to convert numeric data to
52: canonical using fnd_number.number_to_canonical while archiving.
53: Reverted back changes done for 3578040
54: 29-Jun-2004 punmehta 115.7 3731940 Added source_action_id check
55: 02-Jul-2004 punmehta 115.8 3731940 Modified source_action_id check
56: 02-Jul-2004 punmehta 115.9 3731940 Modified for GSCC warnings

Line 399: , p_action_information4 => fnd_number.number_to_canonical(l_balance_value) -- Bug 3604206

395: , p_source_id => p_run_assignment_action_id
396: , p_source_text => NULL
397: , p_action_information_category => 'EMEA BALANCES'
398: , p_action_information1 => pay_apac_payslip_archive.g_user_balance_table(l_index).defined_balance_id
399: , p_action_information4 => fnd_number.number_to_canonical(l_balance_value) -- Bug 3604206
400: );
401:
402: END IF;
403:

Line 513: SELECT sum(fnd_number.canonical_to_number(prv.result_value)) value/*Bug 3228928*/

509: CURSOR csr_element_num_val(p_assignment_action_id NUMBER,
510: p_element_type_id NUMBER,
511: p_input_value_id NUMBER)
512: IS
513: SELECT sum(fnd_number.canonical_to_number(prv.result_value)) value/*Bug 3228928*/
514: FROM pay_run_result_values prv,
515: pay_run_results prr
516: WHERE prr.status IN ('P','PA')
517: AND prv.run_result_id = prr.run_result_id

Line 611: , p_action_information4 => fnd_number.number_to_canonical(l_sum_value) -- Bug 3604206

607: , p_source_text => NULL
608: , p_action_information_category => 'EMEA ELEMENT INFO'
609: , p_action_information1 => g_element_table(l_index).element_type_id
610: , p_action_information2 => g_element_table(l_index).input_value_id
611: , p_action_information4 => fnd_number.number_to_canonical(l_sum_value) -- Bug 3604206
612: );
613:
614: END IF;
615: