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 HR_CURRENCY_PKG

Line 524: l_currency_rate_type := hr_currency_pkg.get_rate_type(l_header_rec.bg_id

520: load_xml(p_xml,'code',l_header_rec.code);
521: load_xml(p_xml,'ape',l_header_rec.ape);
522: --
523: -- get the currency rate type for conversions.
524: l_currency_rate_type := hr_currency_pkg.get_rate_type(l_header_rec.bg_id
525: ,sysdate,'R');
526: --
527: else
528: -- write XML for rtf Header

Line 1485: ,hr_currency_pkg.convert_amount_sql(

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
1487: ,''EUR''
1488: ,sysdate
1489: ,tp_cost.amount

Line 1498: ,hr_currency_pkg.convert_amount_sql(

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
1502: ,nvl(fnd_number.canonical_to_number(pabs.abs_information22),0)

Line 1644: l_currency_rate_type := hr_currency_pkg.get_rate_type(l_header_rec.bg_id

1640: load_xml(p_xml,'c3',l_c3);
1641: load_xml(p_xml,'c4',l_c4);
1642: close l_ref_csr;
1643: else -- debug
1644: l_currency_rate_type := hr_currency_pkg.get_rate_type(l_header_rec.bg_id
1645: ,sysdate,'R');
1646: --
1647: OPEN l_ref_csr for l_sql using
1648: p_company_id,l_year_end,l_year_start,l_year_end,l_year_start

Line 1696: ,hr_currency_pkg.convert_amount(

1692: -- no need to convert currency
1693: load_xml(p_xml,'TRN_AL',l_curr_rec.num2);
1694: else
1695: load_xml(p_xml,'TRN_AL'
1696: ,hr_currency_pkg.convert_amount(
1697: l_curr_rec.chr1
1698: ,'EUR'
1699: ,sysdate
1700: ,l_curr_rec.num2

Line 2025: ,hr_currency_pkg.convert_amount_sql(tpc.currency_code

2021: L_SELECT_OUTER := 'select round(nvl(sum(tot),0)) C91 from (';
2022: L_ORDER_BY := ')';
2023: L_SELECT_INNER1:= 'select sum(decode(tpc.currency_code
2024: ,''EUR'',TPC.amount
2025: ,hr_currency_pkg.convert_amount_sql(tpc.currency_code
2026: ,''EUR''
2027: ,sysdate
2028: ,tpc.amount
2029: ,:CURR_RATE_TYPE))) tot ';

Line 2035: ,hr_currency_pkg.convert_amount_sql(

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
2039: ,nvl(fnd_number.canonical_to_number(pabs.abs_information11),0)

Line 2075: ,hr_currency_pkg.convert_amount_sql(tpc.currency_code

2071: ,sum(decode(TMT.tp_measurement_code
2072: ,''FR_DEDUCT_TRAINER_SALARY''
2073: ,decode(tpc.currency_code
2074: ,''EUR'',TPC.amount
2075: ,hr_currency_pkg.convert_amount_sql(tpc.currency_code
2076: ,''EUR''
2077: ,sysdate
2078: ,tpc.amount
2079: ,:CURR_RATE_TYPE))

Line 2085: ,hr_currency_pkg.convert_amount_sql(tpc.currency_code

2081: ,sum(decode(TMT.tp_measurement_code
2082: ,''FR_DEDUCT_ADMIN_SALARY''
2083: ,decode(tpc.currency_code
2084: ,''EUR'',TPC.amount
2085: ,hr_currency_pkg.convert_amount_sql(tpc.currency_code
2086: ,''EUR''
2087: ,sysdate
2088: ,tpc.amount
2089: ,:CURR_RATE_TYPE))

Line 2095: ,hr_currency_pkg.convert_amount_sql(tpc.currency_code

2091: ,sum(decode(TMT.tp_measurement_code
2092: ,''FR_DEDUCT_RUNNING_COSTS''
2093: ,decode(tpc.currency_code
2094: ,''EUR'',TPC.amount
2095: ,hr_currency_pkg.convert_amount_sql(tpc.currency_code
2096: ,''EUR''
2097: ,sysdate
2098: ,tpc.amount
2099: ,:CURR_RATE_TYPE))

Line 2105: ,hr_currency_pkg.convert_amount_sql(tpc.currency_code

2101: ,sum(decode(TMT.tp_measurement_code
2102: ,''FR_DEDUCT_TRAINER_TRANSPRT''
2103: ,decode(tpc.currency_code
2104: ,''EUR'',TPC.amount
2105: ,hr_currency_pkg.convert_amount_sql(tpc.currency_code
2106: ,''EUR''
2107: ,sysdate
2108: ,tpc.amount
2109: ,:CURR_RATE_TYPE))

Line 2115: ,hr_currency_pkg.convert_amount_sql(tpc.currency_code

2111: ,sum(decode(TMT.tp_measurement_code
2112: ,''FR_DEDUCT_TRAINER_ACCOM''
2113: ,decode(tpc.currency_code
2114: ,''EUR'',TPC.amount
2115: ,hr_currency_pkg.convert_amount_sql(tpc.currency_code
2116: ,''EUR''
2117: ,sysdate
2118: ,tpc.amount
2119: ,:CURR_RATE_TYPE))

Line 2125: ,hr_currency_pkg.convert_amount_sql(tpc.currency_code

2121: ,sum(decode(TMT.tp_measurement_code
2122: ,''FR_OTHER_CLASS_DEDUCT_COST''
2123: ,decode(tpc.currency_code
2124: ,''EUR'',TPC.amount
2125: ,hr_currency_pkg.convert_amount_sql(tpc.currency_code
2126: ,''EUR''
2127: ,sysdate
2128: ,tpc.amount
2129: ,:CURR_RATE_TYPE))

Line 2135: ,hr_currency_pkg.convert_amount_sql(tpc.currency_code

2131: ,sum(decode(TMT.tp_measurement_code
2132: ,''FR_OTHER_LEARN_DEDUCT_INT''
2133: ,decode(tpc.currency_code
2134: ,''EUR'',TPC.amount
2135: ,hr_currency_pkg.convert_amount_sql(tpc.currency_code
2136: ,''EUR''
2137: ,sysdate
2138: ,tpc.amount
2139: ,:CURR_RATE_TYPE))

Line 2175: ,hr_currency_pkg.convert_amount_sql(

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
2179: ,nvl(fnd_number.canonical_to_number(pabs.abs_information11),0)

Line 2298: l_currency_rate_type := hr_currency_pkg.get_rate_type(l_header_rec.bg_id

2294: -- Assemble pdf XML...
2295: load_xml(p_xml,'C91',l_C91);
2296: close l_ref_csr;
2297: else
2298: l_currency_rate_type := hr_currency_pkg.get_rate_type(l_header_rec.bg_id
2299: ,sysdate,'R');
2300: --
2301: OPEN l_ref_csr for l_sql using l_currency_rate_type,l_currency_rate_type
2302: ,l_currency_rate_type,l_currency_rate_type

Line 2450: ,hr_currency_pkg.convert_amount_sql(tpc.currency_code

2446: ''FR_VAE'', ''VAE'',
2447: ''CONTRACTED'') trn_type
2448: ,decode(tpc.currency_code
2449: ,''EUR'',TPC.amount
2450: ,hr_currency_pkg.convert_amount_sql(tpc.currency_code
2451: ,''EUR''
2452: ,sysdate
2453: ,tpc.amount
2454: ,:CURR_RATE_TYPE)) trn_cost

Line 2465: ,hr_currency_pkg.convert_amount_sql(

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
2469: ,nvl(fnd_number.canonical_to_number(pabs.abs_information11),0)

Line 2654: l_currency_rate_type := hr_currency_pkg.get_rate_type(l_header_rec.bg_id

2650: load_xml(p_xml,'x3',l_x3);
2651: load_xml(p_xml,'C101',l_x1+l_x2+l_x3);
2652: close l_ref_csr;
2653: else -- Fb debug
2654: l_currency_rate_type := hr_currency_pkg.get_rate_type(l_header_rec.bg_id
2655: ,sysdate,'R');
2656: --
2657: if p_detail_section = 'FB_CONTRACTED' then
2658: OPEN l_ref_csr for l_sql using

Line 2720: hr_currency_pkg.convert_amount(l_curr_rec.chr1

2716: end if;
2717: exit when l_ref_csr%NOTFOUND;
2718: if l_curr_rec.chr1 <> 'EUR' then
2719: l_curr_rec.num1 :=
2720: hr_currency_pkg.convert_amount(l_curr_rec.chr1
2721: ,'EUR'
2722: ,sysdate
2723: ,l_curr_rec.num1
2724: ,l_currency_rate_type);

Line 2763: ,hr_currency_pkg.convert_amount_sql(tpc_sal.currency_code

2759: L_ORDER_BY := ')';
2760: L_SELECT_INNER1:= 'select
2761: decode(tpc_sal.currency_code
2762: ,''EUR'',TPC_sal.amount
2763: ,hr_currency_pkg.convert_amount_sql(tpc_sal.currency_code
2764: ,''EUR''
2765: ,sysdate
2766: ,tpc_sal.amount
2767: ,:CURR_RATE_TYPE)) sal

Line 2772: ,hr_currency_pkg.convert_amount_sql(

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
2776: ,nvl(fnd_number.canonical_to_number(pabs.abs_information21),0)

Line 2955: l_currency_rate_type := hr_currency_pkg.get_rate_type(l_header_rec.bg_id

2951: -- Assemble pdf XML...
2952: load_xml(p_xml,'C111',l_C111);
2953: close l_ref_csr;
2954: else
2955: l_currency_rate_type := hr_currency_pkg.get_rate_type(l_header_rec.bg_id
2956: ,sysdate,'R');
2957: --
2958: OPEN l_ref_csr for l_sql using p_company_id,l_year_end,l_year_start
2959: ,l_year_end,l_year_start,l_year_start

Line 3025: hr_currency_pkg.convert_amount(l_curr_rec.chr1

3021: end if;
3022: exit when l_ref_csr%NOTFOUND;
3023: if l_curr_rec.chr1 <> 'EUR' then
3024: l_curr_rec.num2 :=
3025: hr_currency_pkg.convert_amount(l_curr_rec.chr1
3026: ,'EUR'
3027: ,sysdate
3028: ,l_curr_rec.num2
3029: ,l_currency_rate_type);

Line 3101: ,hr_currency_pkg.convert_amount_sql(tpc.currency_code

3097: if p_detail_section = 'NA' then
3098: hr_utility.trace('Section Fh PDF');
3099: L_SELECT_OUTER := 'select round(nvl(sum(decode(tpc.currency_code
3100: ,''EUR'',TPC.amount
3101: ,hr_currency_pkg.convert_amount_sql(tpc.currency_code
3102: ,''EUR''
3103: ,sysdate
3104: ,tpc.amount
3105: ,:CURR_RATE_TYPE))),0)) C151

Line 3158: l_currency_rate_type := hr_currency_pkg.get_rate_type(l_header_rec.bg_id

3154: -- Assemble pdf XML...
3155: load_xml(p_xml,'C151',l_C151);
3156: close l_ref_csr;
3157: else
3158: l_currency_rate_type := hr_currency_pkg.get_rate_type(l_header_rec.bg_id
3159: ,sysdate,'R');
3160: --
3161: OPEN l_ref_csr for l_sql using p_company_id,l_year_end,l_year_start
3162: ,l_year_end,l_year_start

Line 3180: ,hr_currency_pkg.convert_amount(

3176: -- no need to convert currency
3177: load_xml(p_xml,'AMOUNT',l_curr_rec.num1);
3178: else
3179: load_xml(p_xml,'AMOUNT'
3180: ,hr_currency_pkg.convert_amount(
3181: l_curr_rec.chr1
3182: ,'EUR'
3183: ,sysdate
3184: ,l_curr_rec.num1