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.HRWSECI dependencies on FND_NUMBER

Line 232: SELECT fnd_number.canonical_to_number(working_hours)

228: AND pos.actual_termination_date IS NOT NULL
229: AND pos.actual_termination_date <= p_qualifying_date;
230: --
231: CURSOR get_org_std_hrs IS
232: SELECT fnd_number.canonical_to_number(working_hours)
233: FROM per_organization_units ou
234: WHERE ou.organization_id = p_organization_id
235: AND ou.business_group_id + 0 = p_business_group_id
236: AND ou.date_from <=p_qualifying_date;

Line 875: fnd_number.number_to_canonical(

871: et.element_type_id,
872: p_business_group_id,
873: NVL(eev_cov.screen_entry_value, iv_cov.default_value),
874: 'ACC',
875: fnd_number.number_to_canonical(
876: NVL(fnd_number.canonical_to_number(eev_er.screen_entry_value), NVL(fnd_number.canonical_to_number(bc.employer_contribution), fnd_number.canonical_to_number(iv_er.default_value))) +
877: NVL(fnd_number.canonical_to_number(eev_ee.screen_entry_value), NVL(fnd_number.canonical_to_number(bc.employee_contribution), fnd_number.canonical_to_number(iv_ee.default_value)))
878: ),
879: trunc(sysdate),

Line 876: NVL(fnd_number.canonical_to_number(eev_er.screen_entry_value), NVL(fnd_number.canonical_to_number(bc.employer_contribution), fnd_number.canonical_to_number(iv_er.default_value))) +

872: p_business_group_id,
873: NVL(eev_cov.screen_entry_value, iv_cov.default_value),
874: 'ACC',
875: fnd_number.number_to_canonical(
876: NVL(fnd_number.canonical_to_number(eev_er.screen_entry_value), NVL(fnd_number.canonical_to_number(bc.employer_contribution), fnd_number.canonical_to_number(iv_er.default_value))) +
877: NVL(fnd_number.canonical_to_number(eev_ee.screen_entry_value), NVL(fnd_number.canonical_to_number(bc.employee_contribution), fnd_number.canonical_to_number(iv_ee.default_value)))
878: ),
879: trunc(sysdate),
880: l_user_id,

Line 877: NVL(fnd_number.canonical_to_number(eev_ee.screen_entry_value), NVL(fnd_number.canonical_to_number(bc.employee_contribution), fnd_number.canonical_to_number(iv_ee.default_value)))

873: NVL(eev_cov.screen_entry_value, iv_cov.default_value),
874: 'ACC',
875: fnd_number.number_to_canonical(
876: NVL(fnd_number.canonical_to_number(eev_er.screen_entry_value), NVL(fnd_number.canonical_to_number(bc.employer_contribution), fnd_number.canonical_to_number(iv_er.default_value))) +
877: NVL(fnd_number.canonical_to_number(eev_ee.screen_entry_value), NVL(fnd_number.canonical_to_number(bc.employee_contribution), fnd_number.canonical_to_number(iv_ee.default_value)))
878: ),
879: trunc(sysdate),
880: l_user_id,
881: TRUNC(sysdate),

Line 983: -- 946707: Should not have TO_CHAR or TO_NUMBER calls directly. Use the fnd_number

979: --
980: l_amount_charged VARCHAR2(60);
981: --
982: -- declare cursor
983: -- 946707: Should not have TO_CHAR or TO_NUMBER calls directly. Use the fnd_number
984: -- procedures instead. Note: Presumes coverage amounts are stored in the canonical
985: -- format
986: -- SELECT TO_CHAR(sum(TO_NUMBER(ccb.coverage_amount)), 999999999990.99)
987: --

Line 989: SELECT fnd_number.number_to_canonical(SUM(fnd_number.canonical_to_number(ccb.coverage_amount)))

985: -- format
986: -- SELECT TO_CHAR(sum(TO_NUMBER(ccb.coverage_amount)), 999999999990.99)
987: --
988: CURSOR amount_charged IS
989: SELECT fnd_number.number_to_canonical(SUM(fnd_number.canonical_to_number(ccb.coverage_amount)))
990: FROM per_cobra_coverage_benefits ccb
991: WHERE ccb.cobra_coverage_enrollment_id = p_cobra_coverage_enrollment_id
992: AND ccb.accept_reject_flag = 'ACC';
993: --

Line 1107: fnd_number.number_to_canonical(NVL(SUM(fnd_number.canonical_to_number(coverage_amount)),'0')),

1103: SELECT
1104: l_scp_id,
1105: p_business_group_id,
1106: p_cobra_coverage_enrollment_id,
1107: fnd_number.number_to_canonical(NVL(SUM(fnd_number.canonical_to_number(coverage_amount)),'0')),
1108: ADD_MONTHS(p_first_payment_due_date, l_count),
1109: ADD_MONTHS(p_first_payment_due_date, l_count) + p_grace_days,
1110: NULL,
1111: NULL,

Line 2373: NVL(fnd_number.number_to_canonical(

2369: -- get_basic_cost_ee - retrieves basic cost looking at the ee level
2370: --
2371: CURSOR get_basic_cost_ee IS
2372: SELECT
2373: NVL(fnd_number.number_to_canonical(
2374: NVL(fnd_number.canonical_to_number(eev_er.screen_entry_value), NVL(fnd_number.canonical_to_number(bc.employer_contribution), fnd_number.canonical_to_number(iv_er.default_value))) +
2375: NVL(fnd_number.canonical_to_number(eev_ee.screen_entry_value), NVL(fnd_number.canonical_to_number(bc.employee_contribution), fnd_number.canonical_to_number(iv_ee.default_value)))
2376: ),'0')
2377: FROM

Line 2374: NVL(fnd_number.canonical_to_number(eev_er.screen_entry_value), NVL(fnd_number.canonical_to_number(bc.employer_contribution), fnd_number.canonical_to_number(iv_er.default_value))) +

2370: --
2371: CURSOR get_basic_cost_ee IS
2372: SELECT
2373: NVL(fnd_number.number_to_canonical(
2374: NVL(fnd_number.canonical_to_number(eev_er.screen_entry_value), NVL(fnd_number.canonical_to_number(bc.employer_contribution), fnd_number.canonical_to_number(iv_er.default_value))) +
2375: NVL(fnd_number.canonical_to_number(eev_ee.screen_entry_value), NVL(fnd_number.canonical_to_number(bc.employee_contribution), fnd_number.canonical_to_number(iv_ee.default_value)))
2376: ),'0')
2377: FROM
2378: pay_element_entry_values eev_er,

Line 2375: NVL(fnd_number.canonical_to_number(eev_ee.screen_entry_value), NVL(fnd_number.canonical_to_number(bc.employee_contribution), fnd_number.canonical_to_number(iv_ee.default_value)))

2371: CURSOR get_basic_cost_ee IS
2372: SELECT
2373: NVL(fnd_number.number_to_canonical(
2374: NVL(fnd_number.canonical_to_number(eev_er.screen_entry_value), NVL(fnd_number.canonical_to_number(bc.employer_contribution), fnd_number.canonical_to_number(iv_er.default_value))) +
2375: NVL(fnd_number.canonical_to_number(eev_ee.screen_entry_value), NVL(fnd_number.canonical_to_number(bc.employee_contribution), fnd_number.canonical_to_number(iv_ee.default_value)))
2376: ),'0')
2377: FROM
2378: pay_element_entry_values eev_er,
2379: pay_element_entry_values eev_ee,

Line 2427: NVL(fnd_number.number_to_canonical(

2423: -- get_basic_cost - retrieves basic cost without looking at the ee level
2424: --
2425: CURSOR get_basic_cost IS
2426: SELECT
2427: NVL(fnd_number.number_to_canonical(
2428: NVL(fnd_number.canonical_to_number(bc.employer_contribution), DECODE(fnd_number.canonical_to_number(iv_cov.default_value), NULL, 0, fnd_number.canonical_to_number(iv_er.default_value))) +
2429: NVL(fnd_number.canonical_to_number(bc.employee_contribution), DECODE(fnd_number.canonical_to_number(iv_cov.default_value), NULL, 0, fnd_number.canonical_to_number(iv_ee.default_value)))
2430: ),'0')
2431: FROM

Line 2428: NVL(fnd_number.canonical_to_number(bc.employer_contribution), DECODE(fnd_number.canonical_to_number(iv_cov.default_value), NULL, 0, fnd_number.canonical_to_number(iv_er.default_value))) +

2424: --
2425: CURSOR get_basic_cost IS
2426: SELECT
2427: NVL(fnd_number.number_to_canonical(
2428: NVL(fnd_number.canonical_to_number(bc.employer_contribution), DECODE(fnd_number.canonical_to_number(iv_cov.default_value), NULL, 0, fnd_number.canonical_to_number(iv_er.default_value))) +
2429: NVL(fnd_number.canonical_to_number(bc.employee_contribution), DECODE(fnd_number.canonical_to_number(iv_cov.default_value), NULL, 0, fnd_number.canonical_to_number(iv_ee.default_value)))
2430: ),'0')
2431: FROM
2432: ben_benefit_contributions bc,

Line 2429: NVL(fnd_number.canonical_to_number(bc.employee_contribution), DECODE(fnd_number.canonical_to_number(iv_cov.default_value), NULL, 0, fnd_number.canonical_to_number(iv_ee.default_value)))

2425: CURSOR get_basic_cost IS
2426: SELECT
2427: NVL(fnd_number.number_to_canonical(
2428: NVL(fnd_number.canonical_to_number(bc.employer_contribution), DECODE(fnd_number.canonical_to_number(iv_cov.default_value), NULL, 0, fnd_number.canonical_to_number(iv_er.default_value))) +
2429: NVL(fnd_number.canonical_to_number(bc.employee_contribution), DECODE(fnd_number.canonical_to_number(iv_cov.default_value), NULL, 0, fnd_number.canonical_to_number(iv_ee.default_value)))
2430: ),'0')
2431: FROM
2432: ben_benefit_contributions bc,
2433: pay_input_values iv_er,

Line 2539: ( SELECT fnd_number.number_to_canonical(NVL(SUM(fnd_number.canonical_to_number(coverage_amount)),'0'))

2535: BEGIN
2536: --
2537: UPDATE per_sched_cobra_payments scp
2538: SET amount_due =
2539: ( SELECT fnd_number.number_to_canonical(NVL(SUM(fnd_number.canonical_to_number(coverage_amount)),'0'))
2540: FROM per_cobra_coverage_benefits_f ccb
2541: WHERE ccb.cobra_coverage_enrollment_id = p_cobra_coverage_enrollment_id
2542: AND scp.date_due BETWEEN
2543: ccb.effective_start_date AND ccb.effective_end_date