eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_DK_ARCHIVE dependencies on FND_NUMBER

Line 1764: ,p_action_information16 => fnd_number.number_to_canonical(rec_pers_pay.value) /* 9316928 */

1760: ,p_action_information12 => NULL
1761: ,p_action_information13 => NULL
1762: ,p_action_information14 => NULL
1763: ,p_action_information15 => NULL
1764: ,p_action_information16 => fnd_number.number_to_canonical(rec_pers_pay.value) /* 9316928 */
1765: ,p_action_information17 => NULL
1766: ,p_action_information18 => rec_pers_pay.opm_name -- rec_pers_pay.pay_type
1767: ,p_assignment_id => p_assignment_id);
1768: ELSE

Line 1794: ,p_action_information16 => fnd_number.number_to_canonical(rec_pers_pay.value) /* 9316928 */

1790: ,p_action_information12 => NULL
1791: ,p_action_information13 => NULL
1792: ,p_action_information14 => NULL
1793: ,p_action_information15 => NULL
1794: ,p_action_information16 => fnd_number.number_to_canonical(rec_pers_pay.value) /* 9316928 */
1795: ,p_action_information17 => NULL
1796: ,p_action_information18 => rec_pers_pay.opm_name -- rec_pers_pay.pay_type
1797: ,p_assignment_id => p_assignment_id);
1798: END IF;

Line 1834: ,p_action_information16 => fnd_number.number_to_canonical(rec_org_pay.value) --l_pay_value

1830: ,p_action_information12 => NULL
1831: ,p_action_information13 => NULL
1832: ,p_action_information14 => NULL
1833: ,p_action_information15 => NULL
1834: ,p_action_information16 => fnd_number.number_to_canonical(rec_org_pay.value) --l_pay_value
1835: ,p_action_information17 => NULL
1836: ,p_action_information18 => rec_org_pay.opm_name -- rec_org_pay.pay_type
1837: ,p_assignment_id => p_assignment_id);
1838: END LOOP;

Line 1977: ,p_action_information5 => fnd_number.number_to_canonical(l_leave_taken)

1973: ,p_source_id => NULL
1974: ,p_source_text => NULL
1975: ,p_action_information_category => 'EMPLOYEE ACCRUALS'
1976: ,p_action_information4 => l_accrual_plan_name
1977: ,p_action_information5 => fnd_number.number_to_canonical(l_leave_taken)
1978: ,p_action_information6 => fnd_number.number_to_canonical(l_annual_leave_balance)
1979: ,p_assignment_id => p_assignment_id);
1980: --
1981: END IF;

Line 1978: ,p_action_information6 => fnd_number.number_to_canonical(l_annual_leave_balance)

1974: ,p_source_text => NULL
1975: ,p_action_information_category => 'EMPLOYEE ACCRUALS'
1976: ,p_action_information4 => l_accrual_plan_name
1977: ,p_action_information5 => fnd_number.number_to_canonical(l_leave_taken)
1978: ,p_action_information6 => fnd_number.number_to_canonical(l_annual_leave_balance)
1979: ,p_assignment_id => p_assignment_id);
1980: --
1981: END IF;
1982: --

Line 2088: and code.org_information1 = fnd_number.number_to_canonical(p_ele_type_id);

2084: select ORG_INFORMATION3,ORG_INFORMATION6,ORG_INFORMATION7,ORG_INFORMATION8,ORG_INFORMATION9,ORG_INFORMATION10
2085: from hr_organization_information code
2086: where code.organization_id = g_business_group_id
2087: and code.org_information_context ='DK_SOE_ELEMENT_ADD_DETAILS'
2088: and code.org_information1 = fnd_number.number_to_canonical(p_ele_type_id);
2089:
2090: rec_group_by csr_group_by%ROWTYPE;
2091: -----------------------------------------------------------------------------
2092: /* Cursor to retrieve sum of run result value for an given Main Element */

Line 2098: SELECT sum(fnd_number.canonical_to_number(rrv.result_value)) result_value

2094: CURSOR csr_sum_of_result_values(p_iv_id NUMBER
2095: ,p_ele_type_id NUMBER
2096: ,p_assignment_action_id NUMBER
2097: ) IS
2098: SELECT sum(fnd_number.canonical_to_number(rrv.result_value)) result_value
2099: ,count(rrv.RUN_RESULT_ID) record_count
2100: ,rrv.result_value UNIT_PRICE
2101: FROM pay_run_result_values rrv
2102: ,pay_run_results rr

Line 2126: sum(fnd_number.canonical_to_number(rrv1.result_value)) UNIT,

2122: ,p_ele_type_id NUMBER
2123: ,p_assignment_action_id NUMBER
2124: ) IS
2125: SELECT rrv3.result_value UNIT_PRICE ,
2126: sum(fnd_number.canonical_to_number(rrv1.result_value)) UNIT,
2127: sum(fnd_number.canonical_to_number(rrv2.result_value)) AMOUNT
2128: FROM pay_run_result_values rrv1
2129: ,pay_run_results rr1
2130: ,pay_assignment_actions paa

Line 2127: sum(fnd_number.canonical_to_number(rrv2.result_value)) AMOUNT

2123: ,p_assignment_action_id NUMBER
2124: ) IS
2125: SELECT rrv3.result_value UNIT_PRICE ,
2126: sum(fnd_number.canonical_to_number(rrv1.result_value)) UNIT,
2127: sum(fnd_number.canonical_to_number(rrv2.result_value)) AMOUNT
2128: FROM pay_run_result_values rrv1
2129: ,pay_run_results rr1
2130: ,pay_assignment_actions paa
2131: ,pay_payroll_actions ppa

Line 2403: ,p_action_information4 => fnd_number.number_to_canonical(csr_result_rec.result_value) /* l_formatted_value 9316928 select query has canonical to num */

2399: ,p_action_information_category => 'EMEA ELEMENT INFO'
2400: ,p_action_information1 => g_element_table(l_index).element_type_id
2401: ,p_action_information2 => g_element_table(l_index).input_value_id
2402: ,p_action_information3 => g_element_table(l_index).element_type
2403: ,p_action_information4 => fnd_number.number_to_canonical(csr_result_rec.result_value) /* l_formatted_value 9316928 select query has canonical to num */
2404: ,p_action_information8 => csr_result_rec.record_count
2405: ,p_action_information9 => 'Additional Element unit per price:'||csr_result_rec.UNIT_PRICE
2406: ,p_assignment_id => p_assignment_id);
2407:

Line 2446: ,p_action_information4 => fnd_number.number_to_canonical(csr_result_rec.AMOUNT) /* l_formatted_value 9316928 select query applied caninical to num */

2442: ,p_action_information_category => 'EMEA ELEMENT INFO'
2443: ,p_action_information1 => g_element_table(l_index).element_type_id
2444: ,p_action_information2 => g_element_table(l_index).input_value_id
2445: ,p_action_information3 => g_element_table(l_index).element_type
2446: ,p_action_information4 => fnd_number.number_to_canonical(csr_result_rec.AMOUNT) /* l_formatted_value 9316928 select query applied caninical to num */
2447: ,p_action_information8 => fnd_number.number_to_canonical(csr_result_rec.UNIT) /* l_formatted_value 9316928 select query applied caninical to num */
2448: ,p_action_information9 => 'Additional Element unit per price:'||csr_result_rec.UNIT_PRICE
2449: ,p_assignment_id => p_assignment_id);
2450:

Line 2447: ,p_action_information8 => fnd_number.number_to_canonical(csr_result_rec.UNIT) /* l_formatted_value 9316928 select query applied caninical to num */

2443: ,p_action_information1 => g_element_table(l_index).element_type_id
2444: ,p_action_information2 => g_element_table(l_index).input_value_id
2445: ,p_action_information3 => g_element_table(l_index).element_type
2446: ,p_action_information4 => fnd_number.number_to_canonical(csr_result_rec.AMOUNT) /* l_formatted_value 9316928 select query applied caninical to num */
2447: ,p_action_information8 => fnd_number.number_to_canonical(csr_result_rec.UNIT) /* l_formatted_value 9316928 select query applied caninical to num */
2448: ,p_action_information9 => 'Additional Element unit per price:'||csr_result_rec.UNIT_PRICE
2449: ,p_assignment_id => p_assignment_id);
2450:
2451: END IF;

Line 2500: l_amount := fnd_number.canonical_to_number(csr_result_rec.result_value);

2496: FOR csr_result_rec IN csr_result_value(rec_group_by.ORG_INFORMATION9 ,g_element_table(l_index).element_type_id ,p_assignment_action_id)
2497: LOOP
2498:
2499: -- we have EE id
2500: l_amount := fnd_number.canonical_to_number(csr_result_rec.result_value);
2501: IF rec_group_by.ORG_INFORMATION8 IS NOT NULL
2502: THEN
2503: OPEN csr_result_value_EE(rec_group_by.ORG_INFORMATION8 ,g_element_table(l_index).element_type_id ,p_assignment_action_id,csr_result_rec.element_entry_id );
2504: FETCH csr_result_value_EE

Line 2535: ,p_action_information4 => fnd_number.number_to_canonical(l_amount) /* l_formatted_value l_amount is applied canonical to num earlier */

2531: ,p_action_information_category => 'EMEA ELEMENT INFO'
2532: ,p_action_information1 => g_element_table(l_index).element_type_id
2533: ,p_action_information2 => g_element_table(l_index).input_value_id
2534: ,p_action_information3 => g_element_table(l_index).element_type
2535: ,p_action_information4 => fnd_number.number_to_canonical(l_amount) /* l_formatted_value l_amount is applied canonical to num earlier */
2536: ,p_action_information8 => l_unit
2537: ,p_action_information9 => 'Additional Element unit per price:'||l_unit_price
2538: ,p_assignment_id => p_assignment_id);
2539:

Line 2801: ,p_action_information4 => fnd_number.number_to_canonical(l_balance_value) --l_formatted_value

2797: ,p_source_text => NULL
2798: ,p_action_information_category => 'EMEA BALANCES'
2799: ,p_action_information1 => g_user_balance_table(l_index).defined_balance_id
2800: ,p_action_information2 => 'OBAL' --Other Balances Context
2801: ,p_action_information4 => fnd_number.number_to_canonical(l_balance_value) --l_formatted_value
2802: ,p_action_information5 => NULL
2803: ,p_action_information6 => 'Other Balances'
2804: ,p_assignment_id => p_assignment_id);
2805: END IF;

Line 3560: ,'Lunar Month',fnd_number.number_to_canonical(round(fnd_number.canonical_to_number(g_tax_card_tab(5).screen_entry_val)12/13))) /10262139 fix*/

3556: SELECT decode (l_period_type
3557: ,'Calendar Month',g_tax_card_tab(5).screen_entry_val
3558: ,'Bi-Week',g_tax_card_tab(6).screen_entry_val
3559: ,'Week',g_tax_card_tab(7).screen_entry_val
3560: ,'Lunar Month',fnd_number.number_to_canonical(round(fnd_number.canonical_to_number(g_tax_card_tab(5).screen_entry_val)*12/13))) /*10262139 fix*/
3561: INTO l_tax_deduction
3562: FROM dual ;
3563:
3564: -- l_calc_holiday_pay_asg_ytd := g_bal_val(9).bal_val ;

Line 3760: AND fnd_number.number_to_canonical(hou.organization_id) = rrv.result_value -- Bug 7656164

3756: AND rrv.input_value_id = iv.input_value_id
3757: AND iv.name = 'Third Party Payee'
3758: AND p_effective_date between
3759: iv.effective_start_date and iv.effective_end_date
3760: AND fnd_number.number_to_canonical(hou.organization_id) = rrv.result_value -- Bug 7656164
3761: --AND hou.organization_id = fnd_number.canonical_to_number(rrv.result_value)
3762: AND p_effective_date between hou.date_from and nvl(hou.date_to, p_effective_date);
3763:
3764: ---------------------------------------------------------------------------------

Line 3761: --AND hou.organization_id = fnd_number.canonical_to_number(rrv.result_value)

3757: AND iv.name = 'Third Party Payee'
3758: AND p_effective_date between
3759: iv.effective_start_date and iv.effective_end_date
3760: AND fnd_number.number_to_canonical(hou.organization_id) = rrv.result_value -- Bug 7656164
3761: --AND hou.organization_id = fnd_number.canonical_to_number(rrv.result_value)
3762: AND p_effective_date between hou.date_from and nvl(hou.date_to, p_effective_date);
3763:
3764: ---------------------------------------------------------------------------------
3765: ---------------------------------------------------------------------------------

Line 3775: and code.org_information1 =fnd_number.number_to_canonical(p_ele_type_id);

3771: select ORG_INFORMATION3,ORG_INFORMATION6,ORG_INFORMATION7,ORG_INFORMATION8,ORG_INFORMATION9,ORG_INFORMATION10
3772: from hr_organization_information code
3773: where code.organization_id = g_business_group_id
3774: and code.org_information_context ='DK_SOE_ELEMENT_ADD_DETAILS'
3775: and code.org_information1 =fnd_number.number_to_canonical(p_ele_type_id);
3776:
3777: ------------------------------------------------------------------------------------
3778: /* Cursor to retrieve run result value of Main Elements */
3779: ------------------------------------------------------------------------------------

Line 3805: SELECT sum(fnd_number.canonical_to_number(rrv.result_value)) result_value

3801: CURSOR csr_sum_of_result_values(p_iv_id NUMBER
3802: ,p_ele_type_id NUMBER
3803: ,p_assignment_action_id NUMBER
3804: ) IS
3805: SELECT sum(fnd_number.canonical_to_number(rrv.result_value)) result_value
3806: ,count(rrv.RUN_RESULT_ID) record_count
3807: ,rrv.result_value UNIT_PRICE
3808: FROM pay_run_result_values rrv
3809: ,pay_run_results rr

Line 3833: sum(fnd_number.canonical_to_number(rrv1.result_value)) UNIT,

3829: ,p_ele_type_id NUMBER
3830: ,p_assignment_action_id NUMBER
3831: ) IS
3832: SELECT rrv3.result_value UNIT_PRICE ,
3833: sum(fnd_number.canonical_to_number(rrv1.result_value)) UNIT,
3834: sum(fnd_number.canonical_to_number(rrv2.result_value)) AMOUNT
3835: FROM pay_run_result_values rrv1
3836: ,pay_run_results rr1
3837: ,pay_assignment_actions paa

Line 3834: sum(fnd_number.canonical_to_number(rrv2.result_value)) AMOUNT

3830: ,p_assignment_action_id NUMBER
3831: ) IS
3832: SELECT rrv3.result_value UNIT_PRICE ,
3833: sum(fnd_number.canonical_to_number(rrv1.result_value)) UNIT,
3834: sum(fnd_number.canonical_to_number(rrv2.result_value)) AMOUNT
3835: FROM pay_run_result_values rrv1
3836: ,pay_run_results rr1
3837: ,pay_assignment_actions paa
3838: ,pay_payroll_actions ppa

Line 4202: ,p_action_information4 => fnd_number.number_to_canonical(csr_result_rec.result_value) /* l_formatted_value 9316928 select query aplied cannonical to num */

4198: ,p_action_information_category => 'EMEA ELEMENT INFO'
4199: ,p_action_information1 => csr_rec.element_type_id
4200: ,p_action_information2 => csr_rec.input_value_id
4201: ,p_action_information3 => 'E'
4202: ,p_action_information4 => fnd_number.number_to_canonical(csr_result_rec.result_value) /* l_formatted_value 9316928 select query aplied cannonical to num */
4203: ,p_action_information8 => csr_result_rec.record_count
4204: ,p_action_information9 => 'Earning Element unit per price:'||csr_result_rec.UNIT_PRICE
4205: ,p_action_information10 => csr_rec.processing_priority /* 9358829 */
4206: ,p_assignment_id => p_assignment_id);

Line 4247: ,p_action_information4 => fnd_number.number_to_canonical(csr_result_rec.AMOUNT) /* l_formatted_value 9316928 not removing canonical because select query does a canonical to number */

4243: ,p_action_information_category => 'EMEA ELEMENT INFO'
4244: ,p_action_information1 => csr_rec.element_type_id
4245: ,p_action_information2 => csr_rec.input_value_id
4246: ,p_action_information3 => 'E'
4247: ,p_action_information4 => fnd_number.number_to_canonical(csr_result_rec.AMOUNT) /* l_formatted_value 9316928 not removing canonical because select query does a canonical to number */
4248: ,p_action_information8 => fnd_number.number_to_canonical(csr_result_rec.UNIT) /* l_formatted_value 9316928 not removing canonical because select query does a canonical to number */
4249: ,p_action_information9 => 'Earning Element unit per price:'||csr_result_rec.UNIT_PRICE
4250: ,p_action_information10 => csr_rec.processing_priority /* 9358829 */
4251: ,p_assignment_id => p_assignment_id);

Line 4248: ,p_action_information8 => fnd_number.number_to_canonical(csr_result_rec.UNIT) /* l_formatted_value 9316928 not removing canonical because select query does a canonical to number */

4244: ,p_action_information1 => csr_rec.element_type_id
4245: ,p_action_information2 => csr_rec.input_value_id
4246: ,p_action_information3 => 'E'
4247: ,p_action_information4 => fnd_number.number_to_canonical(csr_result_rec.AMOUNT) /* l_formatted_value 9316928 not removing canonical because select query does a canonical to number */
4248: ,p_action_information8 => fnd_number.number_to_canonical(csr_result_rec.UNIT) /* l_formatted_value 9316928 not removing canonical because select query does a canonical to number */
4249: ,p_action_information9 => 'Earning Element unit per price:'||csr_result_rec.UNIT_PRICE
4250: ,p_action_information10 => csr_rec.processing_priority /* 9358829 */
4251: ,p_assignment_id => p_assignment_id);
4252: fnd_file.put_line(fnd_file.log,' 3 csr_result_rec.AMOUNT '||csr_result_rec.AMOUNT);

Line 4306: l_amount := fnd_number.canonical_to_number( csr_result_rec.result_value); /* 9316928 */

4302: FOR csr_result_rec IN csr_result_value(rec_group_by.ORG_INFORMATION9 ,csr_rec.element_type_id ,p_assignment_action_id)
4303: LOOP
4304:
4305: -- we have EE id
4306: l_amount := fnd_number.canonical_to_number( csr_result_rec.result_value); /* 9316928 */
4307:
4308: IF rec_group_by.ORG_INFORMATION8 IS NOT NULL
4309: THEN
4310: OPEN csr_result_value_EE(rec_group_by.ORG_INFORMATION8 ,csr_rec.element_type_id ,p_assignment_action_id,csr_result_rec.element_entry_id );

Line 4344: ,p_action_information4 => fnd_number.number_to_canonical(l_amount) /* 9316928 canonical to num is applied on l_amount */

4340: ,p_action_information_category => 'EMEA ELEMENT INFO'
4341: ,p_action_information1 => csr_rec.element_type_id
4342: ,p_action_information2 => csr_rec.input_value_id
4343: ,p_action_information3 => 'E'
4344: ,p_action_information4 => fnd_number.number_to_canonical(l_amount) /* 9316928 canonical to num is applied on l_amount */
4345: ,p_action_information8 => l_unit
4346: ,p_action_information9 => 'Earning Element unit per price:'||l_unit_price
4347: ,p_action_information10 => csr_rec.processing_priority /* 9358829 */
4348: ,p_assignment_id => p_assignment_id);

Line 4556: ,p_action_information4 => fnd_number.number_to_canonical(l_result_value) /* l_formatted_value 9316928 select query applies canonical to number */

4552: ,p_action_information_category => 'EMEA ELEMENT INFO'
4553: ,p_action_information1 => csr_rec.element_type_id
4554: ,p_action_information2 => csr_rec.input_value_id
4555: ,p_action_information3 => l_ele_pen_context -- Added for Pension Changes
4556: ,p_action_information4 => fnd_number.number_to_canonical(l_result_value) /* l_formatted_value 9316928 select query applies canonical to number */
4557: ,p_action_information9 => l_ele_pen_context_desc||':'||csr_result_rec.UNIT_PRICE -- Added for Pension Changes
4558: ,p_assignment_id => p_assignment_id
4559: ,p_action_information8 => csr_result_rec.record_count
4560: ,p_action_information10 => csr_rec.processing_priority /* 9358829 */

Line 4634: ,p_action_information4 => fnd_number.number_to_canonical(csr_result_rec.AMOUNT) /* l_formatted_value select query applies canonical to number */

4630: ,p_action_information_category => 'EMEA ELEMENT INFO'
4631: ,p_action_information1 => csr_rec.element_type_id
4632: ,p_action_information2 => csr_rec.input_value_id
4633: ,p_action_information3 => l_ele_pen_context
4634: ,p_action_information4 => fnd_number.number_to_canonical(csr_result_rec.AMOUNT) /* l_formatted_value select query applies canonical to number */
4635: ,p_action_information8 => csr_result_rec.UNIT
4636: ,p_action_information9 => l_ele_pen_context_desc||':'||csr_result_rec.UNIT_PRICE
4637: ,p_action_information10 => csr_rec.processing_priority /* 9358829 */
4638: ,p_assignment_id => p_assignment_id);

Line 4727: l_amount := fnd_number.canonical_to_number(csr_result_rec.result_value);

4723: FOR csr_result_rec IN csr_result_value(rec_group_by.ORG_INFORMATION9 ,csr_rec.element_type_id ,p_assignment_action_id)
4724: LOOP
4725:
4726: -- we have EE id
4727: l_amount := fnd_number.canonical_to_number(csr_result_rec.result_value);
4728: IF rec_group_by.ORG_INFORMATION8 IS NOT NULL
4729: THEN
4730: OPEN csr_result_value_EE(rec_group_by.ORG_INFORMATION8 ,csr_rec.element_type_id ,p_assignment_action_id,csr_result_rec.element_entry_id );
4731: FETCH csr_result_value_EE

Line 4800: ,p_action_information4 => fnd_number.number_to_canonical(l_amount) /* l_formatted_value applied canonical to num to l_amount earlier */

4796: ,p_action_information_category => 'EMEA ELEMENT INFO'
4797: ,p_action_information1 => csr_rec.element_type_id
4798: ,p_action_information2 => csr_rec.input_value_id
4799: ,p_action_information3 => l_ele_pen_context
4800: ,p_action_information4 => fnd_number.number_to_canonical(l_amount) /* l_formatted_value applied canonical to num to l_amount earlier */
4801: ,p_action_information8 => l_unit
4802: ,p_action_information9 => l_ele_pen_context_desc||':'||l_unit_price
4803: ,p_action_information10 => csr_rec.processing_priority /* 9358829 */
4804: ,p_assignment_id => p_assignment_id);