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

Line 101: fnd_number.number_to_canonical(p_data)

97: p_attribs varchar2 default null) is
98: begin
99: load_xml(p_xml
100: ,'<'||p_node||rtrim(' '||p_attribs)||'>'||
101: fnd_number.number_to_canonical(p_data)
102: ||'
103: ');
104: end load_xml;
105: --

Line 639: ,''HOUR'',fnd_number.canonical_to_number(

635: month.end_date,
636: org_comp.business_group_id,
637: ass.assignment_id,
638: decode(ctr.ctr_information12
639: ,''HOUR'',fnd_number.canonical_to_number(
640: ctr.ctr_information11)
641: ,nvl(ass.normal_hours,0)),
642: nvl(decode(ctr.ctr_information12
643: ,''HOUR'',ctr.ctr_information13

Line 659: ,''HOUR'',fnd_number.canonical_to_number(ctr.ctr_information11)

655: org_comp.business_group_id,
656: ass.assignment_id,
657: decode(
658: ctr.ctr_information12
659: ,''HOUR'',fnd_number.canonical_to_number(ctr.ctr_information11)
660: ,nvl(ass.normal_hours,0)),
661: nvl(decode(ctr.ctr_information12
662: ,''HOUR'',ctr.ctr_information13
663: ,ass.frequency)

Line 666: fnd_number.canonical_to_number(org_info_estab.org_information4)

662: ,''HOUR'',ctr.ctr_information13
663: ,ass.frequency)
664: ,''M''),
665: ''M'') /
666: fnd_number.canonical_to_number(org_info_estab.org_information4)
667: ,1 /*I or D*/) mth_count
668: from hr_all_organization_units org_comp,
669: hr_all_organization_units org_estab,
670: hr_organization_information org_info_estab,

Line 1072: ,nvl(fnd_number.canonical_to_number(tpc.tp_cost_information3)

1068: ,DECODE(per.sex, ''M'', per.person_id) mtrn_id
1069: ,DECODE(per.sex, ''F'', per.person_id) ftrn_id
1070: ,decode(tmt.tp_measurement_code
1071: ,''FR_ACTUAL_HOURS'',tpc.amount
1072: ,nvl(fnd_number.canonical_to_number(tpc.tp_cost_information3)
1073: ,0)) trn_hrs
1074: ,to_number(NULL) dif_trn_id
1075: ,to_number(NULL) dif_hrs
1076: ,to_number(NULL) dif_bal

Line 1482: ,fnd_number.canonical_to_number(tp_cost_hrs.tp_cost_information4) out_hrs

1478: ';
1479: L_ORDER_BY := ')';
1480: L_SELECT_INNER1:= 'select
1481: per.person_id
1482: ,fnd_number.canonical_to_number(tp_cost_hrs.tp_cost_information4) out_hrs
1483: ,decode(tp_cost.currency_code
1484: ,''EUR'',tp_cost.amount
1485: ,hr_currency_pkg.convert_amount_sql(
1486: tp_cost.currency_code

Line 1495: ,fnd_number.canonical_to_number(pabs.abs_information20) out_hrs

1491: ';
1492:
1493: L_SELECT_INNER2:= 'select
1494: per.person_id
1495: ,fnd_number.canonical_to_number(pabs.abs_information20) out_hrs
1496: ,decode(bg_info.org_information10
1497: ,''EUR'',fnd_number.canonical_to_number(pabs.abs_information22)
1498: ,hr_currency_pkg.convert_amount_sql(
1499: bg_info.org_information10

Line 1497: ,''EUR'',fnd_number.canonical_to_number(pabs.abs_information22)

1493: L_SELECT_INNER2:= 'select
1494: per.person_id
1495: ,fnd_number.canonical_to_number(pabs.abs_information20) out_hrs
1496: ,decode(bg_info.org_information10
1497: ,''EUR'',fnd_number.canonical_to_number(pabs.abs_information22)
1498: ,hr_currency_pkg.convert_amount_sql(
1499: bg_info.org_information10
1500: ,''EUR''
1501: ,sysdate

Line 1502: ,nvl(fnd_number.canonical_to_number(pabs.abs_information22),0)

1498: ,hr_currency_pkg.convert_amount_sql(
1499: bg_info.org_information10
1500: ,''EUR''
1501: ,sysdate
1502: ,nvl(fnd_number.canonical_to_number(pabs.abs_information22),0)
1503: ,:CURRENCY_RATE_TYPE)) trn_al
1504: ';
1505: else -- debug
1506: hr_utility.trace('Section B9 and 10 and Fd RTF');

Line 1533: ,fnd_number.canonical_to_number(pabs.abs_information22) trn_al

1529: ,null class
1530: ,hlu_legal.meaning legal_cat
1531: ,nvl(pabs.absence_hours,0) act_hrs
1532: ,nvl(pabs.abs_information20,''0'') out_hrs
1533: ,fnd_number.canonical_to_number(pabs.abs_information22) trn_al
1534: ,bg_info.org_information10 trn_al_cc
1535: ';
1536: L_ORDER_BY := '
1537: ORDER BY 1,3,4,5 desc';

Line 1705: l_c4 := l_c4 + fnd_number.canonical_to_number(l_curr_rec.out_hrs_chr);

1701: ,l_currency_rate_type));
1702: end if;
1703: load_xml(p_xml,'TRAINING',c_CloseGrpTag);
1704: l_tot_act_hrs := l_tot_act_hrs + l_curr_rec.num1;
1705: l_c4 := l_c4 + fnd_number.canonical_to_number(l_curr_rec.out_hrs_chr);
1706: l_C121 := l_C121 + l_curr_rec.num2;
1707: l_prev_rec := l_curr_rec;
1708: end loop;
1709: load_xml(p_xml,'c3',l_c3);

Line 1734: NULL,fnd_number.canonical_to_number(tp_cost.tp_cost_information1),

1730: ''FR_DEDUCT_EXT_TRN_PLAN_SA'', ''SA'',
1731: ''FR_SKILLS_ASSESSMENT'', ''SA'',
1732: ''FR_VAE'', ''VAE'') trn_type
1733: ,decode(tp_cost.booking_id,
1734: NULL,fnd_number.canonical_to_number(tp_cost.tp_cost_information1),
1735: 1) num_courses
1736: ';
1737: L_SELECT_INNER2:= 'select
1738: decode(pabs.abs_information1,

Line 1755: ,NULL,fnd_number.canonical_to_number(tp_cost.tp_cost_information1)

1751: ,event.course_end_date trn_end
1752: ,tp.name plan
1753: ,event_tl.title class
1754: ,decode(tp_cost.booking_id
1755: ,NULL,fnd_number.canonical_to_number(tp_cost.tp_cost_information1)
1756: ,1) num_courses
1757: ';
1758: L_SELECT_INNER2:= 'select
1759: per.order_name order_name

Line 1965: fnd_number.canonical_to_number(

1961: fnd_date.date_to_canonical(l_header_rec.date2));
1962: fetch csr_comp_training_contrib_info into l_training_contrib_rec;
1963: begin
1964: l_er_tp_contrib_rate :=
1965: fnd_number.canonical_to_number(
1966: hruserdt.get_table_value(l_header_rec.bg_id
1967: ,'FR_CONTRIBUTION_RATES'
1968: ,'Value (EUR)'
1969: ,'ER_TRAINING_PLAN_CONTRIBUTION'

Line 1972: fnd_number.canonical_to_number(

1968: ,'Value (EUR)'
1969: ,'ER_TRAINING_PLAN_CONTRIBUTION'
1970: ,l_header_rec.date2));
1971: l_er_cif_contrib_rate :=
1972: fnd_number.canonical_to_number(
1973: hruserdt.get_table_value(l_header_rec.bg_id
1974: ,'FR_CONTRIBUTION_RATES'
1975: ,'Value (EUR)'
1976: ,'ER_CIF_CONTRIBUTION'

Line 1979: fnd_number.canonical_to_number(

1975: ,'Value (EUR)'
1976: ,'ER_CIF_CONTRIBUTION'
1977: ,l_header_rec.date2));
1978: l_er_alternance_contrib_rate :=
1979: fnd_number.canonical_to_number(
1980: hruserdt.get_table_value(l_header_rec.bg_id
1981: ,'FR_CONTRIBUTION_RATES'
1982: ,'Value (EUR)'
1983: ,'ER_ALTERNANCE_CONTRIBUTION'

Line 1994: *(100 - nvl(fnd_number.canonical_to_number(

1990: load_xml(p_xml,'C21'
1991: ,round((l_er_tp_contrib_rate
1992: +l_er_cif_contrib_rate
1993: +l_er_alternance_contrib_rate)
1994: *(100 - nvl(fnd_number.canonical_to_number(
1995: l_training_contrib_rec.reduction_chr)
1996: ,0))
1997: /100
1998: ,2));

Line 2002: *(100 - nvl(fnd_number.canonical_to_number(

1998: ,2));
1999: -- write XML for section D
2000: load_xml(p_xml,'C31'
2001: ,round(l_er_cif_contrib_rate
2002: *(100 - nvl(fnd_number.canonical_to_number(
2003: l_training_contrib_rec.reduction_chr)
2004: ,0))
2005: /100
2006: ,3));

Line 2010: *(100 - nvl(fnd_number.canonical_to_number(

2006: ,3));
2007: -- write XML for section E
2008: load_xml(p_xml,'C61'
2009: ,round(l_er_alternance_contrib_rate
2010: *(100 - nvl(fnd_number.canonical_to_number(
2011: l_training_contrib_rec.reduction_chr)
2012: ,0))
2013: /100
2014: ,3));

Line 2034: ,''EUR'',fnd_number.canonical_to_number(pabs.abs_information11)

2030: L_GROUP_INNER1 := '
2031: ';
2032: L_SELECT_INNER2:= 'select
2033: sum(decode(nvl(pabs.abs_information8,bg_info.org_information10)
2034: ,''EUR'',fnd_number.canonical_to_number(pabs.abs_information11)
2035: ,hr_currency_pkg.convert_amount_sql(
2036: nvl(pabs.abs_information8,bg_info.org_information10)
2037: ,''EUR''
2038: ,sysdate

Line 2039: ,nvl(fnd_number.canonical_to_number(pabs.abs_information11),0)

2035: ,hr_currency_pkg.convert_amount_sql(
2036: nvl(pabs.abs_information8,bg_info.org_information10)
2037: ,''EUR''
2038: ,sysdate
2039: ,nvl(fnd_number.canonical_to_number(pabs.abs_information11),0)
2040: ,:CURR_RATE_TYPE))) tot
2041: ';
2042: else -- p_detail_section = 'FA'
2043: hr_utility.trace('Section Fa RTF');

Line 2174: ,''EUR'',fnd_number.canonical_to_number(pabs.abs_information11)

2170: ,null trn_tran
2171: ,null trn_accom
2172: ,null other
2173: ,decode(nvl(pabs.abs_information8,bg_info.org_information10)
2174: ,''EUR'',fnd_number.canonical_to_number(pabs.abs_information11)
2175: ,hr_currency_pkg.convert_amount_sql(
2176: nvl(pabs.abs_information8,bg_info.org_information10)
2177: ,''EUR''
2178: ,sysdate

Line 2179: ,nvl(fnd_number.canonical_to_number(pabs.abs_information11),0)

2175: ,hr_currency_pkg.convert_amount_sql(
2176: nvl(pabs.abs_information8,bg_info.org_information10)
2177: ,''EUR''
2178: ,sysdate
2179: ,nvl(fnd_number.canonical_to_number(pabs.abs_information11),0)
2180: ,:CURR_RATE_TYPE)) emp_tot
2181: ';
2182: L_ORDER_BY := '
2183: order by 2 NULLS FIRST,3 NULLS FIRST,4 NULLS FIRST,6,7';

Line 2464: ,''EUR'',fnd_number.canonical_to_number(pabs.abs_information11)

2460: ''SKILLS_ASSESSMENT'',''SA'',
2461: ''VAE'', ''VAE'',
2462: ''CONTRACTED'') trn_type
2463: ,decode(nvl(pabs.abs_information8,bg_info.org_information10)
2464: ,''EUR'',fnd_number.canonical_to_number(pabs.abs_information11)
2465: ,hr_currency_pkg.convert_amount_sql(
2466: nvl(pabs.abs_information8,bg_info.org_information10)
2467: ,''EUR''
2468: ,sysdate

Line 2469: ,nvl(fnd_number.canonical_to_number(pabs.abs_information11),0)

2465: ,hr_currency_pkg.convert_amount_sql(
2466: nvl(pabs.abs_information8,bg_info.org_information10)
2467: ,''EUR''
2468: ,sysdate
2469: ,nvl(fnd_number.canonical_to_number(pabs.abs_information11),0)
2470: ,:CURR_RATE_TYPE)) trn_cost
2471: ';
2472: L_WHERE_INNER2 := null;
2473: else -- p_detail_section like 'FB%'

Line 2527: ,nvl(fnd_number.canonical_to_number(pabs.abs_information11),0) trn_cost

2523: ,pabs.date_end trn_end
2524: ,null class_name
2525: ,ota_pv.vendor_name supplier_name
2526: ,null plan_name
2527: ,nvl(fnd_number.canonical_to_number(pabs.abs_information11),0) trn_cost
2528: ,nvl(pabs.abs_information8,bg_info.org_information10) trn_cost_cc
2529: ';
2530: L_WHERE_INNER2:= '
2531: and decode(pabs.abs_information1,

Line 2771: ,''EUR'',fnd_number.canonical_to_number(pabs.abs_information21)

2767: ,:CURR_RATE_TYPE)) sal
2768: ';
2769: L_SELECT_INNER2:= 'select
2770: decode(bg_info.org_information10
2771: ,''EUR'',fnd_number.canonical_to_number(pabs.abs_information21)
2772: ,hr_currency_pkg.convert_amount_sql(
2773: bg_info.org_information10
2774: ,''EUR''
2775: ,sysdate

Line 2776: ,nvl(fnd_number.canonical_to_number(pabs.abs_information21),0)

2772: ,hr_currency_pkg.convert_amount_sql(
2773: bg_info.org_information10
2774: ,''EUR''
2775: ,sysdate
2776: ,nvl(fnd_number.canonical_to_number(pabs.abs_information21),0)
2777: ,:CURR_RATE_TYPE)) sal
2778: ';
2779: else -- p_detail_section = 'FC'
2780: hr_utility.trace('Section Fc RTF');

Line 2799: ''FR_ACTUAL_HOURS'',fnd_number.number_to_canonical(TPC_hrs.amount),

2795: ,to_date(null) abs_st
2796: ,to_date(null) abs_en
2797: ,tp.name plan_name
2798: ,decode(tmt.tp_measurement_code,
2799: ''FR_ACTUAL_HOURS'',fnd_number.number_to_canonical(TPC_hrs.amount),
2800: ''FR_SKILLS_ASSESSMENT'',TPC_hrs.tp_cost_information3,
2801: ''FR_VAE'',TPC_hrs.tp_cost_information3) act_hrs
2802: ,decode(tmt.tp_measurement_code,
2803: ''FR_ACTUAL_HOURS'',TPC_hrs.tp_cost_information4,

Line 2821: ,fnd_number.number_to_canonical(pabs.absence_hours) act_hrs

2817: ,leavecat.meaning leav_cat
2818: ,pabs.date_start abs_st
2819: ,pabs.date_end abs_en
2820: ,null plan_name
2821: ,fnd_number.number_to_canonical(pabs.absence_hours) act_hrs
2822: ,pabs.abs_information20 out_hrs
2823: ,legalcat.meaning legal_cat
2824: ,nvl(fnd_number.canonical_to_number(pabs.abs_information21),0) sal
2825: ,bg_info.org_information10 sal_cc

Line 2824: ,nvl(fnd_number.canonical_to_number(pabs.abs_information21),0) sal

2820: ,null plan_name
2821: ,fnd_number.number_to_canonical(pabs.absence_hours) act_hrs
2822: ,pabs.abs_information20 out_hrs
2823: ,legalcat.meaning legal_cat
2824: ,nvl(fnd_number.canonical_to_number(pabs.abs_information21),0) sal
2825: ,bg_info.org_information10 sal_cc
2826: ';
2827: L_ORDER_BY := '
2828: order by 1,2,4,5,6,8';

Line 3055: fnd_number.canonical_to_number(nvl(l_curr_rec.act_hrs_chr,'0'));

3051: load_xml(p_xml,'OUT_HRS',l_curr_rec.out_hrs_chr);
3052: load_xml(p_xml,'SAL',l_curr_rec.num2);
3053: load_xml(p_xml,'ABS',c_CloseGrpTag);
3054: l_tot_act_hrs := l_tot_act_hrs +
3055: fnd_number.canonical_to_number(nvl(l_curr_rec.act_hrs_chr,'0'));
3056: l_tot_out_hrs := l_tot_out_hrs +
3057: fnd_number.canonical_to_number(nvl(l_curr_rec.out_hrs_chr,'0'));
3058: l_total := l_total + l_curr_rec.num2;
3059: else -- l_curr_rec.num1 in (1,2,3)

Line 3057: fnd_number.canonical_to_number(nvl(l_curr_rec.out_hrs_chr,'0'));

3053: load_xml(p_xml,'ABS',c_CloseGrpTag);
3054: l_tot_act_hrs := l_tot_act_hrs +
3055: fnd_number.canonical_to_number(nvl(l_curr_rec.act_hrs_chr,'0'));
3056: l_tot_out_hrs := l_tot_out_hrs +
3057: fnd_number.canonical_to_number(nvl(l_curr_rec.out_hrs_chr,'0'));
3058: l_total := l_total + l_curr_rec.num2;
3059: else -- l_curr_rec.num1 in (1,2,3)
3060: if nvl(l_prev_rec.num1,0) <> l_curr_rec.num1
3061: or l_prev_rec.class_name <> l_curr_rec.class_name

Line 3077: fnd_number.canonical_to_number(nvl(l_curr_rec.act_hrs_chr,'0'));

3073: load_xml(p_xml,'OUT_HRS',l_curr_rec.out_hrs_chr);
3074: load_xml(p_xml,'SAL',l_curr_rec.num2);
3075: load_xml(p_xml,'STUDENT',c_CloseGrpTag);
3076: l_tot_act_hrs := l_tot_act_hrs +
3077: fnd_number.canonical_to_number(nvl(l_curr_rec.act_hrs_chr,'0'));
3078: l_tot_out_hrs := l_tot_out_hrs +
3079: fnd_number.canonical_to_number(nvl(l_curr_rec.out_hrs_chr,'0'));
3080: l_total := l_total + l_curr_rec.num2;
3081: end if;

Line 3079: fnd_number.canonical_to_number(nvl(l_curr_rec.out_hrs_chr,'0'));

3075: load_xml(p_xml,'STUDENT',c_CloseGrpTag);
3076: l_tot_act_hrs := l_tot_act_hrs +
3077: fnd_number.canonical_to_number(nvl(l_curr_rec.act_hrs_chr,'0'));
3078: l_tot_out_hrs := l_tot_out_hrs +
3079: fnd_number.canonical_to_number(nvl(l_curr_rec.out_hrs_chr,'0'));
3080: l_total := l_total + l_curr_rec.num2;
3081: end if;
3082: l_prev_rec := l_curr_rec;
3083: end loop;