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

Line 268: SELECT fnd_number.canonical_to_number(working_hours)

264: AND pos.actual_termination_date <= p_qualifying_date
265: ORDER BY pos.actual_termination_date DESC; --BUG1712478
266: --
267: CURSOR get_org_std_hrs IS
268: SELECT fnd_number.canonical_to_number(working_hours)
269: FROM per_organization_units ou
270: WHERE ou.organization_id = p_organization_id
271: AND ou.business_group_id + 0 = p_business_group_id
272: AND ou.date_from <=p_qualifying_date;

Line 933: fnd_number.number_to_canonical(

929: et.element_type_id,
930: p_business_group_id,
931: NVL(eev_cov.screen_entry_value, iv_cov.default_value),
932: 'ACC',
933: fnd_number.number_to_canonical(
934: 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))) +
935: 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)))
936: ),
937: trunc(sysdate),

Line 934: 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))) +

930: p_business_group_id,
931: NVL(eev_cov.screen_entry_value, iv_cov.default_value),
932: 'ACC',
933: fnd_number.number_to_canonical(
934: 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))) +
935: 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)))
936: ),
937: trunc(sysdate),
938: l_user_id,

Line 935: 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)))

931: NVL(eev_cov.screen_entry_value, iv_cov.default_value),
932: 'ACC',
933: fnd_number.number_to_canonical(
934: 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))) +
935: 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)))
936: ),
937: trunc(sysdate),
938: l_user_id,
939: TRUNC(sysdate),

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

1038: --
1039: l_amount_charged VARCHAR2(60);
1040: --
1041: -- declare cursor
1042: -- 946707: Should not have TO_CHAR or TO_NUMBER calls directly. Use the fnd_number
1043: -- procedures instead. Note: Presumes coverage amounts are stored in the canonical
1044: -- format
1045: -- SELECT TO_CHAR(sum(TO_NUMBER(ccb.coverage_amount)), 999999999990.99)
1046: --

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

1046: --
1047: -- Added p_session_date to get correct amount_charged value when there are more
1048: -- than one record for same cobra_coverage_enrollment_id. Part of fix#4599753
1049: CURSOR amount_charged IS
1050: SELECT fnd_number.number_to_canonical(SUM(fnd_number.canonical_to_number(ccb.coverage_amount)))
1051: FROM per_cobra_coverage_benefits_f ccb
1052: WHERE ccb.cobra_coverage_enrollment_id = p_cobra_coverage_enrollment_id
1053: and p_session_date between ccb.effective_start_date and ccb.effective_end_date
1054: AND ccb.accept_reject_flag = 'ACC';

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

1186: SELECT
1187: l_scp_id,
1188: p_business_group_id,
1189: p_cobra_coverage_enrollment_id,
1190: fnd_number.number_to_canonical(NVL(SUM(fnd_number.canonical_to_number(coverage_amount)),'0')),
1191: ADD_MONTHS(p_first_payment_due_date, l_count),
1192: ADD_MONTHS(p_first_payment_due_date, l_count) + p_grace_days,
1193: NULL,
1194: NULL,

Line 1703: fnd_number.number_to_canonical(

1699: et.element_type_id,
1700: p_business_group_id,
1701: NVL(eev_cov.screen_entry_value, iv_cov.default_value),
1702: 'ACC',
1703: fnd_number.number_to_canonical(
1704: NVL(fnd_number.canonical_to_number(eev_er.screen_entry_value),
1705: NVL(fnd_number.canonical_to_number(bc.employer_contribution),
1706: fnd_number.canonical_to_number(iv_er.default_value))) +
1707: NVL(fnd_number.canonical_to_number(eev_ee.screen_entry_value),

Line 1704: NVL(fnd_number.canonical_to_number(eev_er.screen_entry_value),

1700: p_business_group_id,
1701: NVL(eev_cov.screen_entry_value, iv_cov.default_value),
1702: 'ACC',
1703: fnd_number.number_to_canonical(
1704: NVL(fnd_number.canonical_to_number(eev_er.screen_entry_value),
1705: NVL(fnd_number.canonical_to_number(bc.employer_contribution),
1706: fnd_number.canonical_to_number(iv_er.default_value))) +
1707: NVL(fnd_number.canonical_to_number(eev_ee.screen_entry_value),
1708: NVL(fnd_number.canonical_to_number(bc.employee_contribution),

Line 1705: NVL(fnd_number.canonical_to_number(bc.employer_contribution),

1701: NVL(eev_cov.screen_entry_value, iv_cov.default_value),
1702: 'ACC',
1703: fnd_number.number_to_canonical(
1704: NVL(fnd_number.canonical_to_number(eev_er.screen_entry_value),
1705: NVL(fnd_number.canonical_to_number(bc.employer_contribution),
1706: fnd_number.canonical_to_number(iv_er.default_value))) +
1707: NVL(fnd_number.canonical_to_number(eev_ee.screen_entry_value),
1708: NVL(fnd_number.canonical_to_number(bc.employee_contribution),
1709: fnd_number.canonical_to_number(iv_ee.default_value)))),

Line 1706: fnd_number.canonical_to_number(iv_er.default_value))) +

1702: 'ACC',
1703: fnd_number.number_to_canonical(
1704: NVL(fnd_number.canonical_to_number(eev_er.screen_entry_value),
1705: NVL(fnd_number.canonical_to_number(bc.employer_contribution),
1706: fnd_number.canonical_to_number(iv_er.default_value))) +
1707: NVL(fnd_number.canonical_to_number(eev_ee.screen_entry_value),
1708: NVL(fnd_number.canonical_to_number(bc.employee_contribution),
1709: fnd_number.canonical_to_number(iv_ee.default_value)))),
1710: trunc(sysdate),

Line 1707: NVL(fnd_number.canonical_to_number(eev_ee.screen_entry_value),

1703: fnd_number.number_to_canonical(
1704: NVL(fnd_number.canonical_to_number(eev_er.screen_entry_value),
1705: NVL(fnd_number.canonical_to_number(bc.employer_contribution),
1706: fnd_number.canonical_to_number(iv_er.default_value))) +
1707: NVL(fnd_number.canonical_to_number(eev_ee.screen_entry_value),
1708: NVL(fnd_number.canonical_to_number(bc.employee_contribution),
1709: fnd_number.canonical_to_number(iv_ee.default_value)))),
1710: trunc(sysdate),
1711: l_user_id,

Line 1708: NVL(fnd_number.canonical_to_number(bc.employee_contribution),

1704: NVL(fnd_number.canonical_to_number(eev_er.screen_entry_value),
1705: NVL(fnd_number.canonical_to_number(bc.employer_contribution),
1706: fnd_number.canonical_to_number(iv_er.default_value))) +
1707: NVL(fnd_number.canonical_to_number(eev_ee.screen_entry_value),
1708: NVL(fnd_number.canonical_to_number(bc.employee_contribution),
1709: fnd_number.canonical_to_number(iv_ee.default_value)))),
1710: trunc(sysdate),
1711: l_user_id,
1712: TRUNC(sysdate),

Line 1709: fnd_number.canonical_to_number(iv_ee.default_value)))),

1705: NVL(fnd_number.canonical_to_number(bc.employer_contribution),
1706: fnd_number.canonical_to_number(iv_er.default_value))) +
1707: NVL(fnd_number.canonical_to_number(eev_ee.screen_entry_value),
1708: NVL(fnd_number.canonical_to_number(bc.employee_contribution),
1709: fnd_number.canonical_to_number(iv_ee.default_value)))),
1710: trunc(sysdate),
1711: l_user_id,
1712: TRUNC(sysdate),
1713: l_user_id,

Line 2996: NVL(fnd_number.number_to_canonical(

2992: -- get_basic_cost_ee - retrieves basic cost looking at the ee level
2993: --
2994: CURSOR get_basic_cost_ee IS
2995: SELECT
2996: NVL(fnd_number.number_to_canonical(
2997: 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))) +
2998: 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)))
2999: ),'0')
3000: FROM

Line 2997: 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))) +

2993: --
2994: CURSOR get_basic_cost_ee IS
2995: SELECT
2996: NVL(fnd_number.number_to_canonical(
2997: 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))) +
2998: 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)))
2999: ),'0')
3000: FROM
3001: pay_element_entry_values eev_er,

Line 2998: 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)))

2994: CURSOR get_basic_cost_ee IS
2995: SELECT
2996: NVL(fnd_number.number_to_canonical(
2997: 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))) +
2998: 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)))
2999: ),'0')
3000: FROM
3001: pay_element_entry_values eev_er,
3002: pay_element_entry_values eev_ee,

Line 3050: NVL(fnd_number.number_to_canonical(

3046: -- get_basic_cost - retrieves basic cost without looking at the ee level
3047: --
3048: CURSOR get_basic_cost IS
3049: SELECT
3050: NVL(fnd_number.number_to_canonical(
3051: 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))) +
3052: 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)))
3053: ),'0')
3054: FROM

Line 3051: 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))) +

3047: --
3048: CURSOR get_basic_cost IS
3049: SELECT
3050: NVL(fnd_number.number_to_canonical(
3051: 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))) +
3052: 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)))
3053: ),'0')
3054: FROM
3055: ben_benefit_contributions bc,

Line 3052: 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)))

3048: CURSOR get_basic_cost IS
3049: SELECT
3050: NVL(fnd_number.number_to_canonical(
3051: 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))) +
3052: 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)))
3053: ),'0')
3054: FROM
3055: ben_benefit_contributions bc,
3056: pay_input_values iv_er,

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

3164: BEGIN
3165: --
3166: UPDATE per_sched_cobra_payments scp
3167: SET amount_due =
3168: ( SELECT fnd_number.number_to_canonical(NVL(SUM(fnd_number.canonical_to_number(coverage_amount)),'0'))
3169: FROM per_cobra_coverage_benefits_f ccb
3170: WHERE ccb.cobra_coverage_enrollment_id = p_cobra_coverage_enrollment_id
3171: AND scp.date_due BETWEEN
3172: ccb.effective_start_date AND ccb.effective_end_date