APPS.PAY_GB_PAYSLIP_ARCHIVE dependencies on FND_NUMBER

Line 1164: ,p_action_information4 => fnd_number.number_to_canonical(l_balance_value)

1160: ,p_action_information_category => 'EMEA BALANCES'
1161: ,p_action_information1 => p_defined_bal_id
1162: ,p_action_information2 => v_csr_reference.reference -- Context value
1163: ,p_action_information3 => NULL
1164: ,p_action_information4 => fnd_number.number_to_canonical(l_balance_value)
1165: ,p_action_information5 => l_record_count
1166: ,p_action_information6 => v_context_rec.context_value);
1167: END IF;
1168:

Line 1207: ,p_action_information4 => fnd_number.number_to_canonical(l_balance_value)

1203: ,p_action_information_category => 'EMEA BALANCES'
1204: ,p_action_information1 => p_defined_bal_id
1205: ,p_action_information2 => v_context_rec.context_value -- Context value
1206: ,p_action_information3 => NULL
1207: ,p_action_information4 => fnd_number.number_to_canonical(l_balance_value)
1208: ,p_action_information5 => l_record_count );
1209: END IF;
1210: END IF;
1211: END LOOP;

Line 1287: , p_action_information4 => fnd_number.number_to_canonical(l_balance_value)

1283: , p_action_information_category => 'EMEA BALANCES'
1284: , p_action_information1 => p_defined_bal_id
1285: , p_action_information2 => NULL
1286: , p_action_information3 => NULL
1287: , p_action_information4 => fnd_number.number_to_canonical(l_balance_value)
1288: , p_action_information5 => l_record_count);
1289:
1290: END IF;
1291: END IF;

Line 1407: ltrim(rtrim(to_char(fnd_number.canonical_to_number(rec_element_value.result_value), '999999999999999990.00'))),

1403: NULL;
1404:
1405: ELSE
1406: SELECT decode(g_element_table(l_index).uom, 'M',
1407: ltrim(rtrim(to_char(fnd_number.canonical_to_number(rec_element_value.result_value), '999999999999999990.00'))),
1408: rec_element_value.result_value)
1409: INTO l_result_value
1410: FROM dual;
1411: --

Line 2674: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(prv.result_value)) value, SUM(FND_NUMBER.CANONICAL_TO_NUMBER(prv.result_value)) numeric_value

2670: p_element_type_2 IN VARCHAR,
2671: p_element_type_3 IN VARCHAR) IS
2672:
2673: SELECT /*+ leading(lck,paa2) */ lck.locking_action_id ACTION_CONTEXT_ID, pet.element_type_id, piv.input_value_id, pai.action_information4 NARRATIVE, pai.action_information5 PAYMENT_TYPE,
2674: SUM(FND_NUMBER.CANONICAL_TO_NUMBER(prv.result_value)) value, SUM(FND_NUMBER.CANONICAL_TO_NUMBER(prv.result_value)) numeric_value
2675: FROM pay_action_interlocks lck, -- archive action locking prepayment
2676: pay_assignment_actions paa1, -- prepayment action
2677: pay_assignment_actions paa2, -- archive action
2678: pay_payroll_actions ppa, -- prepayment

Line 2768: , p_action_information4 => FND_NUMBER.CANONICAL_TO_NUMBER(rec_element_value.value)

2764: , p_action_information_category => 'GB ELEMENT PAYSLIP INFO'
2765: , p_action_information1 => rec_element_value.element_type_id
2766: , p_action_information2 => rec_element_value.input_value_id
2767: , p_action_information3 => rec_element_value.payment_type
2768: , p_action_information4 => FND_NUMBER.CANONICAL_TO_NUMBER(rec_element_value.value)
2769: , p_action_information5 => rec_element_value.narrative
2770: , p_effective_date => l_effective_date
2771: , p_assignment_id => l_assignment_id
2772: );