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_UTILITY

Line 9: hr_utility.trace('/* The ('||lengthb(p_sql)||

5: l_start number;
6: l_len number;
7: begin
8: l_start := 1;
9: hr_utility.trace('/* The ('||lengthb(p_sql)||
10: ' byte) SQL being executed is: */');
11: loop
12: l_len := instr(p_sql||'
13: ','

Line 15: hr_utility.trace(substr(p_sql,l_start,l_len));

11: loop
12: l_len := instr(p_sql||'
13: ','
14: ',l_start) - l_start;
15: hr_utility.trace(substr(p_sql,l_start,l_len));
16: l_start := l_start + l_len +1;
17: exit when l_start > length(p_sql);
18: end loop;
19: hr_utility.trace('/* end SQL */');

Line 19: hr_utility.trace('/* end SQL */');

15: hr_utility.trace(substr(p_sql,l_start,l_len));
16: l_start := l_start + l_len +1;
17: exit when l_start > length(p_sql);
18: end loop;
19: hr_utility.trace('/* end SQL */');
20: end trace_sql;
21: --
22: procedure load_xml (p_xml in out nocopy clob,
23: p_data varchar2) is

Line 555: hr_utility.trace('comp_active_mths_in_yr: '||

551: fetch csr_measurement_types into l_meas_types_rec;
552: close csr_measurement_types;
553: --
554: if p_detail_section in ('A','NA') then
555: hr_utility.trace('comp_active_mths_in_yr: '||
556: l_header_rec.comp_active_mths_in_yr);
557: if p_detail_section = 'NA' then
558: hr_utility.trace('Section A PDF');
559: L_SELECT_OUTER := 'select

Line 558: hr_utility.trace('Section A PDF');

554: if p_detail_section in ('A','NA') then
555: hr_utility.trace('comp_active_mths_in_yr: '||
556: l_header_rec.comp_active_mths_in_yr);
557: if p_detail_section = 'NA' then
558: hr_utility.trace('Section A PDF');
559: L_SELECT_OUTER := 'select
560: round((
561: trunc(nvl(sum(decode(emp_mth.mth_num,1 ,mth_count)),0))+
562: trunc(nvl(sum(decode(emp_mth.mth_num,2 ,mth_count)),0))+

Line 577: hr_utility.trace('Section A RTF');

573: :num_comp_months) NOMBRE
574: FROM (';
575: L_ORDER_BY := ') emp_mth';
576: else
577: hr_utility.trace('Section A RTF');
578: L_SELECT_OUTER := 'select
579: emp_mth.full_name,
580: emp_mth.order_name,
581: emp_mth.employee_number,

Line 844: hr_utility.trace('Section B2-5 PDF');

840: open csr_classifications;
841: fetch csr_classifications into l_classification_rec;
842: close csr_classifications;
843: if p_detail_section = 'NA' then
844: hr_utility.trace('Section B2-5 PDF');
845: L_SELECT_OUTER := 'select
846: nvl(sum(decode(emp_cat,2,mcnt)),0) b11
847: ,nvl(sum(decode(emp_cat,2,fcnt)),0) b12
848: ,count(distinct decode(emp_cat,2,mtrn_id)) b13

Line 901: hr_utility.trace('Section '||p_detail_section||' RTF');

897: job.job_information1 LIKE ''67%'' OR
898: job.job_information1 LIKE ''68%'' OR
899: job.job_information1 LIKE ''69%'')';
900: else -- debug
901: hr_utility.trace('Section '||p_detail_section||' RTF');
902: L_SELECT_OUTER := 'select
903: full_name
904: ,order_name
905: ,employee_number

Line 1358: hr_utility.trace('Section B7 and 8 PDF');

1354: end if; -- Section B2-5
1355: --
1356: if p_detail_section in ('B7_8','NA') then
1357: if p_detail_section = 'NA' then
1358: hr_utility.trace('Section B7 and 8 PDF');
1359: L_SELECT_OUTER := 'select
1360: count(distinct per.person_id) c1
1361: ,round(nvl(sum(pabs.absence_hours),0)) c2
1362: ';

Line 1366: hr_utility.trace('Section B7 and 8 RTF');

1362: ';
1363: L_ORDER_BY := null;
1364: L_SELECT_INNER1:= null;
1365: else -- debug
1366: hr_utility.trace('Section B7 and 8 RTF');
1367: L_SELECT_OUTER := null;
1368: L_SELECT_INNER1:= 'select
1369: per.order_name order_name
1370: ,per.full_name full_name

Line 1472: hr_utility.trace('Section B9 and 10 and Fd PDF');

1468: end if; -- B7_8
1469: --
1470: if p_detail_section in ('B9_10_FD','NA') then
1471: if p_detail_section = 'NA' then
1472: hr_utility.trace('Section B9 and 10 and Fd PDF');
1473: L_SELECT_OUTER := 'select
1474: count(distinct person_id) c3
1475: ,round(nvl(sum(out_hrs),0)) c4
1476: ,round(nvl(sum(trn_al),0)) C121

Line 1506: hr_utility.trace('Section B9 and 10 and Fd RTF');

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');
1507: L_SELECT_OUTER := null;
1508: L_SELECT_INNER1:= 'select
1509: per.order_name order_name
1510: ,per.full_name full_name

Line 1720: hr_utility.trace('Section B11 and 12 PDF');

1716: end if; -- Section B9 and 10 and Fd
1717: --
1718: if p_detail_section in ('B11','B12','NA') then
1719: if p_detail_section = 'NA' then
1720: hr_utility.trace('Section B11 and 12 PDF');
1721: L_SELECT_OUTER := 'select
1722: round(nvl(sum(decode(trn_type,''SA'', num_courses)),0)) c5,
1723: round(nvl(sum(decode(trn_type,''VAE'',num_courses)),0)) c6
1724: from (

Line 1744: hr_utility.trace('Section '||p_detail_section||' RTF');

1740: ''VAE'',''VAE'') trn_type
1741: ,1 num_courses
1742: ';
1743: else -- p_detail_section in ('B11','B12')
1744: hr_utility.trace('Section '||p_detail_section||' RTF');
1745: L_SELECT_OUTER := null;
1746: L_SELECT_INNER1:= 'select
1747: per.order_name order_name
1748: ,per.full_name full_name

Line 2020: hr_utility.trace('Section Fa PDF');

2016: close csr_comp_training_contrib_info;
2017: end if;
2018: if p_detail_section in ('FA','NA') then
2019: if p_detail_section = 'NA' then
2020: hr_utility.trace('Section Fa PDF');
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

Line 2043: hr_utility.trace('Section Fa RTF');

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');
2044: L_SELECT_OUTER := null;
2045: L_SELECT_INNER1:= 'select
2046: costs.full_name
2047: ,costs.order_name

Line 2433: hr_utility.trace('Section Fb PDF');

2429: end if; -- section Fa
2430: --
2431: if p_detail_section in ('FB_CONTRACTED','FB_SA','FB_VAE','NA') then
2432: if p_detail_section = 'NA' then
2433: hr_utility.trace('Section Fb PDF');
2434: L_SELECT_OUTER := 'select
2435: round(nvl(sum(decode(trn_type,''CONTRACTED'',trn_cost)),0)) x1,
2436: round(nvl(sum(decode(trn_type,''SA'', trn_cost)),0)) x2,
2437: round(nvl(sum(decode(trn_type,''VAE'', trn_cost)),0)) x3

Line 2474: hr_utility.trace('Section '||p_detail_section||' RTF');

2470: ,:CURR_RATE_TYPE)) trn_cost
2471: ';
2472: L_WHERE_INNER2 := null;
2473: else -- p_detail_section like 'FB%'
2474: hr_utility.trace('Section '||p_detail_section||' RTF');
2475: L_SELECT_OUTER := null;
2476: L_SELECT_INNER1:= 'select
2477: costs.full_name
2478: ,costs.order_name

Line 2755: hr_utility.trace('Section Fc PDF');

2751: end if; -- section Fb
2752: --
2753: if p_detail_section in ('FC','NA') then
2754: if p_detail_section = 'NA' then
2755: hr_utility.trace('Section Fc PDF');
2756: L_SELECT_OUTER := 'select round(nvl(sum(sal),0)) C111
2757: from (
2758: ';
2759: L_ORDER_BY := ')';

Line 2780: hr_utility.trace('Section Fc RTF');

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');
2781: L_SELECT_OUTER := null;
2782: L_SELECT_INNER1:= 'select /*+ORDERED*/
2783: decode(tmt.tp_measurement_code,
2784: ''FR_SKILLS_ASSESSMENT'',2,

Line 3091: hr_utility.trace('Section Fd PDF');

3087: end if;
3088: end if; -- section Fc
3089: --
3090: if p_detail_section = 'NA' then
3091: hr_utility.trace('Section Fd PDF');
3092: -- Assemble pdf XML for section Fd using l_C121
3093: load_xml(p_xml,'C121',l_C121);
3094: end if; -- section Fd
3095: --

Line 3098: hr_utility.trace('Section Fh PDF');

3094: end if; -- section Fd
3095: --
3096: if p_detail_section in ('FH','NA') then
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''

Line 3110: hr_utility.trace('Section Fh RTF');

3106: ';
3107: L_ORDER_BY := null;
3108: L_SELECT_INNER1:= null;
3109: else -- p_detail_section = 'FH'
3110: hr_utility.trace('Section Fh RTF');
3111: L_SELECT_OUTER := 'select /*+ORDERED*/
3112: TP.name plan_name
3113: ,tpc.amount amount
3114: ,tpc.currency_code cc

Line 3199: hr_utility.trace('Leaving otfr2483.build_XML');

3195: load_xml(p_xml,'FIELDS',c_CloseGrpTag);
3196: --
3197: --dbms_lob.createtemporary(p_xml,TRUE);
3198: --p_xml := g_xml;
3199: hr_utility.trace('Leaving otfr2483.build_XML');
3200: end build_XML;
3201: --
3202: PROCEDURE run_2483 (errbuf OUT NOCOPY VARCHAR2
3203: ,retcode OUT NOCOPY NUMBER