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

Line 2214: l_pl_id_txt := fnd_number.number_to_canonical(p_pl_id);

2210: -- information_types other than the one desired which might cause
2211: -- the fnd_date conversion to fail.
2212: l_override_entitlement_found := FALSE;
2213:
2214: l_pl_id_txt := fnd_number.number_to_canonical(p_pl_id);
2215:
2216: FOR r_override_entitlement
2217: IN csr_override_entitlement
2218: (p_assignment_id => p_assignment_id

Line 2253: fnd_number.canonical_to_number(l_override_entitlement.band1);

2249:
2250: -- think of a way for removing hard coded band names
2251:
2252: l_band_entitlement :=
2253: fnd_number.canonical_to_number(l_override_entitlement.band1);
2254:
2255: --IF l_band_entitlement > 0
2256: --THEN
2257: i := i + 1;

Line 2266: l_band_entitlement := fnd_number.canonical_to_number(l_override_entitlement.band2);

2262: ,l_band_entitlements(i).band);
2263: l_band_entitlements(i).entitlement := l_band_entitlement;
2264: --END IF;
2265:
2266: l_band_entitlement := fnd_number.canonical_to_number(l_override_entitlement.band2);
2267:
2268: IF l_band_entitlement > 0
2269: THEN
2270: i := i + 1;

Line 2279: l_band_entitlement := fnd_number.canonical_to_number(l_override_entitlement.band3);

2275: ,l_band_entitlements(i).band);
2276: l_band_entitlements(i).entitlement := l_band_entitlement;
2277: END IF;
2278:
2279: l_band_entitlement := fnd_number.canonical_to_number(l_override_entitlement.band3);
2280:
2281: IF l_band_entitlement > 0
2282: THEN
2283: i := i + 1;

Line 2292: l_band_entitlement := fnd_number.canonical_to_number(l_override_entitlement.band4);

2288: ,l_band_entitlements(i).band);
2289: l_band_entitlements(i).entitlement := l_band_entitlement;
2290: END IF;
2291:
2292: l_band_entitlement := fnd_number.canonical_to_number(l_override_entitlement.band4);
2293:
2294: IF l_band_entitlement > 0
2295: THEN
2296: i := i + 1;

Line 2378: fnd_number.number_to_canonical(p_entitlement_UDT_id);

2374: SELECT eei_information9 UOM -- "Absence Entitlement Days Type" segment
2375: FROM pay_element_type_extra_info
2376: WHERE information_type = 'PQP_GB_OMP_ABSENCE_PLAN_INFO' -- OMP col indexed
2377: AND eei_information11 = -- "Absence Entitlement Parameters" segment
2378: fnd_number.number_to_canonical(p_entitlement_UDT_id);
2379:
2380:
2381: CURSOR csr_osp_entitlement_UOM
2382: (p_entitlement_UDT_id IN NUMBER

Line 2388: fnd_number.number_to_canonical(p_entitlement_UDT_id);

2384: SELECT eei_information8 UOM -- "Absence Days" segment
2385: FROM pay_element_type_extra_info
2386: WHERE information_type = 'PQP_GB_OSP_ABSENCE_PLAN_INFO' -- OSP col indexed
2387: AND eei_information9 = -- "Absence Entitlement Sick Leave" segment
2388: fnd_number.number_to_canonical(p_entitlement_UDT_id);
2389:
2390: l_entitlement_UOM pay_element_type_extra_info.eei_information8%TYPE;
2391: l_entitlement_override_is_set BOOLEAN:= FALSE;
2392:

Line 3122: l_pl_id := fnd_number.canonical_to_number(l_pl_id_txt);

3118: IF l_retval < 0 THEN
3119: check_error_code(l_retval,p_error_msg);
3120: END IF;
3121:
3122: l_pl_id := fnd_number.canonical_to_number(l_pl_id_txt);
3123:
3124: --Set the global rounding factor cache if the values are not already set
3125: IF g_ft_entitl_rounding_type is null OR g_round_cache_plan_id <> l_pl_id THEN
3126: PQP_GB_OSP_FUNCTIONS.set_osp_omp_rounding_factors

Line 4151: l_pl_id := fnd_number.canonical_to_number(l_pl_id_txt);

4147: IF l_retval < 0 THEN
4148: check_error_code(l_retval,p_error_msg);
4149: END IF;
4150:
4151: l_pl_id := fnd_number.canonical_to_number(l_pl_id_txt);
4152:
4153: l_retval :=
4154: get_entitlement_parameters(
4155: p_business_group_id => p_business_group_id

Line 5465: || fnd_number.number_to_canonical(p_calendar_table_id)

5461: p_error_code := 0;
5462: debug('p_date:' || fnd_date.date_to_canonical(p_date));
5463: debug(
5464: 'p_calendar_table_id:'
5465: || fnd_number.number_to_canonical(p_calendar_table_id)
5466: );
5467: debug('p_calendar_rules_list:' || p_calendar_rules_list);
5468: debug('p_cal_value:' || p_cal_value);
5469: debug('p_filter:' || p_filter);

Line 5485: debug('l_retval:' || fnd_number.number_to_canonical(l_retval));

5481: l_retval := -1;
5482: END IF;
5483:
5484: CLOSE csr_cal_occur;
5485: debug('l_retval:' || fnd_number.number_to_canonical(l_retval));
5486: IF g_debug THEN
5487: debug('l_retval:'||l_retval);
5488: debug_exit(l_proc_name);
5489: END IF;

Line 5628: FND_NUMBER.canonical_to_number(NVL(l_abs_precision,5));

5624: -- assign the rounding precision to global variable.
5625: -- if null then asssign rounding precision to be 5
5626: -- so by default absemces taken would be rounded to 5 places.
5627: g_abs_rounding_precision :=
5628: FND_NUMBER.canonical_to_number(NVL(l_abs_precision,5));
5629:
5630: IF g_debug THEN
5631: debug('g_abs_rounding_precision');
5632: debug(g_abs_rounding_precision);

Line 5970: AND pln.pl_id = fnd_number.canonical_to_number(eei.eei_information1)

5966: ,ben_pl_f pln
5967: WHERE eei.element_type_id = p_element_type_id
5968: --AND eei.information_type = 'PQP_GB_OSP_ABSENCE_PLAN_INFO' -- is indexed
5969: AND UPPER(eei.eei_information19) = 'ABSENCE INFO'
5970: AND pln.pl_id = fnd_number.canonical_to_number(eei.eei_information1)
5971: AND p_effective_date BETWEEN pln.effective_start_date
5972: AND pln.effective_end_date;
5973:
5974: l_scheme_det csr_osp_scheme_det%ROWTYPE;

Line 6239: AND eei.eei_information1 = fnd_number.number_to_canonical(p_pl_id)

6235: SELECT eei.element_type_id
6236: FROM pay_element_type_extra_info eei
6237: WHERE eei.information_type = 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
6238: -- needs to be extended for omp
6239: AND eei.eei_information1 = fnd_number.number_to_canonical(p_pl_id)
6240: AND UPPER(eei.eei_information19) = 'ABSENCE INFO';
6241: BEGIN
6242: IF g_debug THEN
6243: debug_enter(l_proc_name);

Line 6632: SELECT fnd_number.canonical_to_number(security_group_id)

6628: -- given business_group_id
6629:
6630: CURSOR csr_get_security_group
6631: IS
6632: SELECT fnd_number.canonical_to_number(security_group_id)
6633: security_group_id
6634: FROM per_business_groups
6635: WHERE business_group_id = p_business_group_id;
6636:

Line 6879: fnd_number.canonical_to_number(eei.eei_information1)

6875: WHERE UPPER(eei.eei_information19) = 'ABSENCE INFO'
6876: AND eei.element_type_id = p_element_type_id
6877: --AND eei.information_type = 'PQP_GB_OMP_ABSENCE_PLAN_INFO'
6878: AND pln.pl_id =
6879: fnd_number.canonical_to_number(eei.eei_information1)
6880: AND p_effective_date BETWEEN pln.effective_start_date
6881: AND pln.effective_end_date;
6882:
6883: l_scheme_det csr_osp_scheme_det%ROWTYPE;

Line 8034: -- fnd_number.canonical_to_number(p_pei_information3);

8030: l_override_end_date :=
8031: fnd_date.canonical_to_date(p_pei_information2);
8032:
8033: --l_override_pl_id :=
8034: -- fnd_number.canonical_to_number(p_pei_information3);
8035:
8036: IF g_debug THEN
8037: debug('p_pei_information1:'||p_pei_information1);
8038: debug('p_pei_information2:'||p_pei_information2);

Line 8081: -- fnd_number.canonical_to_number(r_other_override_row.pl_id_txt);

8077: l_other_override_end_date :=
8078: fnd_date.canonical_to_date(r_other_override_row.override_end_date_txt);
8079:
8080: --l_other_override_pl_id :=
8081: -- fnd_number.canonical_to_number(r_other_override_row.pl_id_txt);
8082:
8083: IF ( l_override_start_date -- |---------|
8084: BETWEEN l_other_override_start_date -- |-------------|
8085: AND l_other_override_end_date -- |---------|

Line 9092: fnd_number.canonical_to_number(l_screen_entry_value);

9088: FETCH get_element_entry_value INTO l_screen_entry_value;
9089: CLOSE get_element_entry_value;
9090: IF j = 1 THEN -- its amount
9091: r_ssp_entry.amount :=
9092: fnd_number.canonical_to_number(l_screen_entry_value);
9093: END IF;
9094: IF j = 2 THEN -- its ssp_days_due
9095: r_ssp_entry.ssp_days_due :=
9096: fnd_number.canonical_to_number(l_screen_entry_value);

Line 9096: fnd_number.canonical_to_number(l_screen_entry_value);

9092: fnd_number.canonical_to_number(l_screen_entry_value);
9093: END IF;
9094: IF j = 2 THEN -- its ssp_days_due
9095: r_ssp_entry.ssp_days_due :=
9096: fnd_number.canonical_to_number(l_screen_entry_value);
9097: END IF;
9098: IF j = 3 THEN -- its date_from
9099: r_ssp_entry.date_from:=
9100: fnd_date.canonical_to_date(l_screen_entry_value);

Line 9108: fnd_number.canonical_to_number(l_screen_entry_value);

9104: fnd_date.canonical_to_date(l_screen_entry_value);
9105: END IF;
9106: IF j = 5 THEN -- its rate
9107: r_ssp_entry.rate:=
9108: fnd_number.canonical_to_number(l_screen_entry_value);
9109: END IF;
9110: IF j = 6 THEN -- its withheld_days
9111: r_ssp_entry.withheld_days:=
9112: fnd_number.canonical_to_number(l_screen_entry_value);

Line 9112: fnd_number.canonical_to_number(l_screen_entry_value);

9108: fnd_number.canonical_to_number(l_screen_entry_value);
9109: END IF;
9110: IF j = 6 THEN -- its withheld_days
9111: r_ssp_entry.withheld_days:=
9112: fnd_number.canonical_to_number(l_screen_entry_value);
9113: END IF;
9114: --IF j = 7 THEN -- its ssp_weeks
9115: -- r_ssp_entry.ssp_weeks:=
9116: -- fnd_number.canonical_to_number(l_screen_entry_value);

Line 9116: -- fnd_number.canonical_to_number(l_screen_entry_value);

9112: fnd_number.canonical_to_number(l_screen_entry_value);
9113: END IF;
9114: --IF j = 7 THEN -- its ssp_weeks
9115: -- r_ssp_entry.ssp_weeks:=
9116: -- fnd_number.canonical_to_number(l_screen_entry_value);
9117: --END IF;
9118: IF j = 8 THEN -- its qualifying_days
9119: r_ssp_entry.qualifying_days:=
9120: fnd_number.canonical_to_number(l_screen_entry_value);

Line 9120: fnd_number.canonical_to_number(l_screen_entry_value);

9116: -- fnd_number.canonical_to_number(l_screen_entry_value);
9117: --END IF;
9118: IF j = 8 THEN -- its qualifying_days
9119: r_ssp_entry.qualifying_days:=
9120: fnd_number.canonical_to_number(l_screen_entry_value);
9121: END IF;
9122: j := l_ssp_input_values.NEXT(j);
9123: END LOOP;
9124:

Line 9218: fnd_number.canonical_to_number(l_screen_entry_value);

9214: FETCH get_element_entry_value INTO l_screen_entry_value;
9215: CLOSE get_element_entry_value;
9216: IF j = 1 THEN -- its amount
9217: r_ssp_entry.amount :=
9218: fnd_number.canonical_to_number(l_screen_entry_value);
9219: END IF;
9220: IF j = 2 THEN -- its ssp_days_due
9221: r_ssp_entry.ssp_days_due :=
9222: fnd_number.canonical_to_number(l_screen_entry_value);

Line 9222: fnd_number.canonical_to_number(l_screen_entry_value);

9218: fnd_number.canonical_to_number(l_screen_entry_value);
9219: END IF;
9220: IF j = 2 THEN -- its ssp_days_due
9221: r_ssp_entry.ssp_days_due :=
9222: fnd_number.canonical_to_number(l_screen_entry_value);
9223: END IF;
9224: IF j = 3 THEN -- its date_from
9225: r_ssp_entry.date_from:=
9226: fnd_date.canonical_to_date(l_screen_entry_value);

Line 9234: fnd_number.canonical_to_number(l_screen_entry_value);

9230: fnd_date.canonical_to_date(l_screen_entry_value);
9231: END IF;
9232: IF j = 5 THEN -- its rate
9233: r_ssp_entry.rate:=
9234: fnd_number.canonical_to_number(l_screen_entry_value);
9235: END IF;
9236: IF j = 6 THEN -- its withheld_days
9237: r_ssp_entry.withheld_days:=
9238: fnd_number.canonical_to_number(l_screen_entry_value);

Line 9238: fnd_number.canonical_to_number(l_screen_entry_value);

9234: fnd_number.canonical_to_number(l_screen_entry_value);
9235: END IF;
9236: IF j = 6 THEN -- its withheld_days
9237: r_ssp_entry.withheld_days:=
9238: fnd_number.canonical_to_number(l_screen_entry_value);
9239: END IF;
9240: --IF j = 7 THEN -- its ssp_weeks
9241: -- r_ssp_entry.ssp_weeks:=
9242: -- fnd_number.canonical_to_number(l_screen_entry_value);

Line 9242: -- fnd_number.canonical_to_number(l_screen_entry_value);

9238: fnd_number.canonical_to_number(l_screen_entry_value);
9239: END IF;
9240: --IF j = 7 THEN -- its ssp_weeks
9241: -- r_ssp_entry.ssp_weeks:=
9242: -- fnd_number.canonical_to_number(l_screen_entry_value);
9243: --END IF;
9244: IF j = 8 THEN -- its qualifying_days
9245: r_ssp_entry.qualifying_days:=
9246: fnd_number.canonical_to_number(l_screen_entry_value);

Line 9246: fnd_number.canonical_to_number(l_screen_entry_value);

9242: -- fnd_number.canonical_to_number(l_screen_entry_value);
9243: --END IF;
9244: IF j = 8 THEN -- its qualifying_days
9245: r_ssp_entry.qualifying_days:=
9246: fnd_number.canonical_to_number(l_screen_entry_value);
9247: END IF;
9248: j := l_ssp_retro_input_values.NEXT(j);
9249: END LOOP;
9250:

Line 9945: fnd_number.canonical_to_number(l_screen_entry_value);

9941: FETCH get_element_entry_value INTO l_screen_entry_value;
9942: CLOSE get_element_entry_value;
9943: IF j = 1 THEN -- its amount
9944: r_smp_entry.amount :=
9945: fnd_number.canonical_to_number(l_screen_entry_value);
9946: END IF;
9947: IF j = 2 THEN -- its week_commencing
9948: r_smp_entry.week_commencing :=
9949: fnd_date.canonical_to_date(l_screen_entry_value);

Line 9957: -- fnd_number.canonical_to_number(l_screen_entry_value);

9953: -- l_screen_entry_value;
9954: --END IF;
9955: --IF j = 4 THEN -- its recoverable_amount
9956: -- r_smp_entry.l_smp_retro_input_valuesrecoverable_amount:=
9957: -- fnd_number.canonical_to_number(l_screen_entry_value);
9958: --END IF;
9959:
9960: j := l_smp_input_values.NEXT(j);
9961: END LOOP;

Line 10043: fnd_number.canonical_to_number(l_screen_entry_value);

10039: FETCH get_element_entry_value INTO l_screen_entry_value;
10040: CLOSE get_element_entry_value;
10041: IF j = 1 THEN -- its amount
10042: r_smp_entry.amount :=
10043: fnd_number.canonical_to_number(l_screen_entry_value);
10044: END IF;
10045: IF j = 2 THEN -- its week_commencing
10046: r_smp_entry.week_commencing :=
10047: fnd_date.canonical_to_date(l_screen_entry_value);

Line 10055: -- fnd_number.canonical_to_number(l_screen_entry_value);

10051: -- l_screen_entry_value;
10052: --END IF;
10053: --IF j = 4 THEN -- its recoverable_amount
10054: -- r_smp_entry.l_smp_retro_input_valuesrecoverable_amount:=
10055: -- fnd_number.canonical_to_number(l_screen_entry_value);
10056: --END IF;
10057:
10058: j := l_smp_retro_input_values.NEXT(j);
10059: END LOOP;

Line 11517: p_rounding_precision:=fnd_number.canonical_to_number(l_round_val_2);

11513:
11514: l_round_to:=substr(p_code,2,1);
11515: l_round_val_1:=substr(p_code,3,1);
11516: l_round_val_2:=l_round_val_1 || '.' || substr(p_code,4);
11517: p_rounding_precision:=fnd_number.canonical_to_number(l_round_val_2);
11518:
11519: IF l_round_to='N' THEN
11520: p_rounding_type:='NEAREST';
11521: ELSIF l_round_to='U' THEN

Line 11641: FND_NUMBER.canonical_to_number(NVL(l_abs_precision,5));

11637: -- assign the rounding precision to global variable.
11638: -- if null then asssign rounding precision to be 5
11639: -- so by default absemces taken would be rounded to 5 places.
11640: g_abs_rounding_precision :=
11641: FND_NUMBER.canonical_to_number(NVL(l_abs_precision,5));
11642:
11643: IF g_debug THEN
11644: debug('g_abs_rounding_precision');
11645: debug(g_abs_rounding_precision);

Line 11976: l_pension_rt := fnd_number.canonical_to_number(p_abs_information6);

11972:
11973:
11974: IF (p_abs_information6 <> hr_api.g_varchar2)
11975: THEN
11976: l_pension_rt := fnd_number.canonical_to_number(p_abs_information6);
11977: END IF;
11978:
11979: IF g_debug THEN
11980: debug(l_proc_name,40);