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.HRSUMREP dependencies on HR_UTILITY

Line 140: hr_utility.set_location('Entering : hrumrep.process_run ', 5);

136: p_retcode :=0; /* Default retcode to zero, to indicate no error */
137:
138: -- Set STORE_DATA utility package global
139: --
140: hr_utility.set_location('Entering : hrumrep.process_run ', 5);
141: hr_summary_util.store_data := p_store_data;
142: --
143: -- If the process needs to write data then initialize it by writing
144: -- and process row and parameter rows, otherwise just setup business group

Line 211: hr_utility.trace('processing item ' || itutab(x).itu_name || ' ' || itutab(x).it_name);

207: l_group_clause := null;
208: --
209: -- Begin determining the dynamic SQL components
210: --
211: hr_utility.trace('processing item ' || itutab(x).itu_name || ' ' || itutab(x).it_name);
212: l_count_clause1 := ituTab(x).count_clause1 || ' col_value1 ';
213: if ituTab(x).count_clause2 is not null then
214: l_count_clause2 := ','||ituTab(x).count_clause2 || ' col_value2 ';
215: end if;

Line 237: hr_utility.trace('hrsumrep - keytab');

233: b) build up the select clause
234: c) build up the group by clause
235: ----------------------------------------------------------------- */
236: --
237: hr_utility.trace('hrsumrep - keytab');
238: if ktyTab.count > 0 then
239: for i in ktyTab.first..ktyTab.last loop
240: --
241: --

Line 282: hr_utility.trace('hrsumrep - restrictions');

278: end if;
279:
280: --
281: --
282: hr_utility.trace('hrsumrep - restrictions');
283: /* -----------------------------------------------------------------
284: If there are restrictions being used build up the restriction clause
285: ----------------------------------------------------------------- */
286: --

Line 309: hr_utility.trace('hrsumrep - restrictions1');

305: l_restriction_clause := ' and @.'||vrt.restriction_clause || ' ' ||
306: vrt.restriction_type || ' ';
307: end if;
308: --
309: hr_utility.trace('hrsumrep - restrictions1');
310: l_comma := '(';
311: for rvl in c_get_restriction_value(vrt.restriction_usage_id) loop
312: if vrt.data_type = 'C' then
313: l_restriction_value := '''' || rvl.value || '''';

Line 354: hr_utility.trace('hrsumrep - restrictions1b');

350: l_pos1 := nvl(instr(l_where_clause,vrt.name||'['),0);
351: exit when l_pos1 = 0;
352: l_pos1 := l_pos1+length(vrt.name)+1;
353: l_pos2 := instr(l_where_clause,']',l_pos1,1);
354: hr_utility.trace('hrsumrep - restrictions1b');
355: hr_utility.trace('l_pos1 = ' || l_pos1 || ' ' || l_pos2);
356: l_alias := substr(l_where_clause,l_pos1,l_pos2-l_pos1);
357: hr_utility.trace('l_alias = ' || l_alias);
358: if l_character_after_brkt = concat('/','*parameteralias') then

Line 355: hr_utility.trace('l_pos1 = ' || l_pos1 || ' ' || l_pos2);

351: exit when l_pos1 = 0;
352: l_pos1 := l_pos1+length(vrt.name)+1;
353: l_pos2 := instr(l_where_clause,']',l_pos1,1);
354: hr_utility.trace('hrsumrep - restrictions1b');
355: hr_utility.trace('l_pos1 = ' || l_pos1 || ' ' || l_pos2);
356: l_alias := substr(l_where_clause,l_pos1,l_pos2-l_pos1);
357: hr_utility.trace('l_alias = ' || l_alias);
358: if l_character_after_brkt = concat('/','*parameteralias') then
359: -- l_alias := ' ';

Line 357: hr_utility.trace('l_alias = ' || l_alias);

353: l_pos2 := instr(l_where_clause,']',l_pos1,1);
354: hr_utility.trace('hrsumrep - restrictions1b');
355: hr_utility.trace('l_pos1 = ' || l_pos1 || ' ' || l_pos2);
356: l_alias := substr(l_where_clause,l_pos1,l_pos2-l_pos1);
357: hr_utility.trace('l_alias = ' || l_alias);
358: if l_character_after_brkt = concat('/','*parameteralias') then
359: -- l_alias := ' ';
360: hr_utility.trace('hrsumrep - restrictions1c');
361: l_restriction_clause2 := REPLACE(l_restriction_clause,'aliasreplace',l_parameter_alias);

Line 360: hr_utility.trace('hrsumrep - restrictions1c');

356: l_alias := substr(l_where_clause,l_pos1,l_pos2-l_pos1);
357: hr_utility.trace('l_alias = ' || l_alias);
358: if l_character_after_brkt = concat('/','*parameteralias') then
359: -- l_alias := ' ';
360: hr_utility.trace('hrsumrep - restrictions1c');
361: l_restriction_clause2 := REPLACE(l_restriction_clause,'aliasreplace',l_parameter_alias);
362: l_restriction_clause2 := REPLACE(l_restriction_clause2,'@',' ');
363: hr_utility.trace('hrsumrep - restrictions1d');
364: -- write_stmt_log (p_stmt => 'l_restric2 = ' || l_restriction_clause2);

Line 363: hr_utility.trace('hrsumrep - restrictions1d');

359: -- l_alias := ' ';
360: hr_utility.trace('hrsumrep - restrictions1c');
361: l_restriction_clause2 := REPLACE(l_restriction_clause,'aliasreplace',l_parameter_alias);
362: l_restriction_clause2 := REPLACE(l_restriction_clause2,'@',' ');
363: hr_utility.trace('hrsumrep - restrictions1d');
364: -- write_stmt_log (p_stmt => 'l_restric2 = ' || l_restriction_clause2);
365: else
366: hr_utility.trace('hrsumrep - restrictions1e');
367: l_restriction_clause2 := REPLACE(l_restriction_clause,'@',l_alias);

Line 366: hr_utility.trace('hrsumrep - restrictions1e');

362: l_restriction_clause2 := REPLACE(l_restriction_clause2,'@',' ');
363: hr_utility.trace('hrsumrep - restrictions1d');
364: -- write_stmt_log (p_stmt => 'l_restric2 = ' || l_restriction_clause2);
365: else
366: hr_utility.trace('hrsumrep - restrictions1e');
367: l_restriction_clause2 := REPLACE(l_restriction_clause,'@',l_alias);
368: end if;
369:
370: hr_utility.trace('hrsumrep - restrictions2');

Line 370: hr_utility.trace('hrsumrep - restrictions2');

366: hr_utility.trace('hrsumrep - restrictions1e');
367: l_restriction_clause2 := REPLACE(l_restriction_clause,'@',l_alias);
368: end if;
369:
370: hr_utility.trace('hrsumrep - restrictions2');
371: If l_character_after_brkt = concat('/','*parameteralias') then
372: l_where_clause := REPLACE(l_where_clause,'RESTRICTION.'||vrt.name||'['||l_alias||']',l_restriction_clause2);
373: --write_stmt_log (p_stmt => 'l_where_cla= ' || l_where_clause);
374: else

Line 391: hr_utility.trace('hrsumrep - complete restrictions');

387: l_pos2 := instr(l_where_clause,']',l_pos1,1)+1;
388: l_where_clause := substr(l_where_clause,1,l_pos1-1)||substr(l_where_clause,l_pos2,length(l_where_clause));
389: end loop;
390: --
391: hr_utility.trace('hrsumrep - complete restrictions');
392: -- Concatenate the full dynamic statement
393: --
394: l_stmt := 'select '||
395: l_count_clause1 ||

Line 448: hr_utility.set_location('Leaving : hrumrep.process_run ', 10);

444:
445: end if; -- p_store_data
446: end loop;
447: end if;
448: hr_utility.set_location('Leaving : hrumrep.process_run ', 10);
449: exception
450: when others then
451: p_retcode :=2; /* unknown error, so set status to Error */
452: write_error('Process Run error:');

Line 600: hr_utility.set_location('Entering : hrumrep.process_run ', 5);

596: --
597: begin
598: -- Set STORE_DATA utility package global
599: --
600: hr_utility.set_location('Entering : hrumrep.process_run ', 5);
601: hr_summary_util.store_data := p_store_data;
602: --
603: --
604: /* ------------------------------------------------------------------

Line 661: hr_utility.trace('processing item ' || itutab(x).itu_name || ' ' || itutab(x).it_name);

657: l_group_clause := null;
658: --
659: -- Begin determining the dynamic SQL components
660: --
661: hr_utility.trace('processing item ' || itutab(x).itu_name || ' ' || itutab(x).it_name);
662: l_count_clause1 := ituTab(x).count_clause1 || ' col_value1 ';
663: if ituTab(x).count_clause2 is not null then
664: l_count_clause2 := ','||ituTab(x).count_clause2 || ' col_value2 ';
665: end if;

Line 687: hr_utility.trace('hrsumrep - keytab');

683: b) build up the select clause
684: c) build up the group by clause
685: ----------------------------------------------------------------- */
686: --
687: hr_utility.trace('hrsumrep - keytab');
688: if ktyTab.count > 0 then
689: for i in ktyTab.first..ktyTab.last loop
690: --
691: l_stmt := 'declare key_type_id number := '||ktyTab(i).key_type_id||';

Line 731: hr_utility.trace('hrsumrep - restrictions');

727: end if;
728:
729: --
730: --
731: hr_utility.trace('hrsumrep - restrictions');
732: /* -----------------------------------------------------------------
733: If there are restrictions being used build up the restriction clause
734: ----------------------------------------------------------------- */
735: --

Line 758: hr_utility.trace('hrsumrep - restrictions1');

754: l_restriction_clause := ' and @.'||vrt.restriction_clause || ' ' ||
755: vrt.restriction_type || ' ';
756: end if;
757: --
758: hr_utility.trace('hrsumrep - restrictions1');
759: l_comma := '(';
760: for rvl in c_get_restriction_value(vrt.restriction_usage_id) loop
761: if vrt.data_type = 'C' then
762: l_restriction_value := '''' || rvl.value || '''';

Line 803: hr_utility.trace('hrsumrep - restrictions1b');

799: l_pos1 := nvl(instr(l_where_clause,vrt.name||'['),0);
800: exit when l_pos1 = 0;
801: l_pos1 := l_pos1+length(vrt.name)+1;
802: l_pos2 := instr(l_where_clause,']',l_pos1,1);
803: hr_utility.trace('hrsumrep - restrictions1b');
804: hr_utility.trace('l_pos1 = ' || l_pos1 || ' ' || l_pos2);
805: l_alias := substr(l_where_clause,l_pos1,l_pos2-l_pos1);
806: hr_utility.trace('l_alias = ' || l_alias);
807: if l_character_after_brkt = concat('/','*parameteralias') then

Line 804: hr_utility.trace('l_pos1 = ' || l_pos1 || ' ' || l_pos2);

800: exit when l_pos1 = 0;
801: l_pos1 := l_pos1+length(vrt.name)+1;
802: l_pos2 := instr(l_where_clause,']',l_pos1,1);
803: hr_utility.trace('hrsumrep - restrictions1b');
804: hr_utility.trace('l_pos1 = ' || l_pos1 || ' ' || l_pos2);
805: l_alias := substr(l_where_clause,l_pos1,l_pos2-l_pos1);
806: hr_utility.trace('l_alias = ' || l_alias);
807: if l_character_after_brkt = concat('/','*parameteralias') then
808: -- l_alias := ' ';

Line 806: hr_utility.trace('l_alias = ' || l_alias);

802: l_pos2 := instr(l_where_clause,']',l_pos1,1);
803: hr_utility.trace('hrsumrep - restrictions1b');
804: hr_utility.trace('l_pos1 = ' || l_pos1 || ' ' || l_pos2);
805: l_alias := substr(l_where_clause,l_pos1,l_pos2-l_pos1);
806: hr_utility.trace('l_alias = ' || l_alias);
807: if l_character_after_brkt = concat('/','*parameteralias') then
808: -- l_alias := ' ';
809: hr_utility.trace('hrsumrep - restrictions1c');
810: l_restriction_clause2 := REPLACE(l_restriction_clause,'aliasreplace',l_parameter_alias);

Line 809: hr_utility.trace('hrsumrep - restrictions1c');

805: l_alias := substr(l_where_clause,l_pos1,l_pos2-l_pos1);
806: hr_utility.trace('l_alias = ' || l_alias);
807: if l_character_after_brkt = concat('/','*parameteralias') then
808: -- l_alias := ' ';
809: hr_utility.trace('hrsumrep - restrictions1c');
810: l_restriction_clause2 := REPLACE(l_restriction_clause,'aliasreplace',l_parameter_alias);
811: l_restriction_clause2 := REPLACE(l_restriction_clause2,'@',' ');
812: hr_utility.trace('hrsumrep - restrictions1d');
813: -- write_stmt_log (p_stmt => 'l_restric2 = ' || l_restriction_clause2);

Line 812: hr_utility.trace('hrsumrep - restrictions1d');

808: -- l_alias := ' ';
809: hr_utility.trace('hrsumrep - restrictions1c');
810: l_restriction_clause2 := REPLACE(l_restriction_clause,'aliasreplace',l_parameter_alias);
811: l_restriction_clause2 := REPLACE(l_restriction_clause2,'@',' ');
812: hr_utility.trace('hrsumrep - restrictions1d');
813: -- write_stmt_log (p_stmt => 'l_restric2 = ' || l_restriction_clause2);
814: else
815: hr_utility.trace('hrsumrep - restrictions1e');
816: l_restriction_clause2 := REPLACE(l_restriction_clause,'@',l_alias);

Line 815: hr_utility.trace('hrsumrep - restrictions1e');

811: l_restriction_clause2 := REPLACE(l_restriction_clause2,'@',' ');
812: hr_utility.trace('hrsumrep - restrictions1d');
813: -- write_stmt_log (p_stmt => 'l_restric2 = ' || l_restriction_clause2);
814: else
815: hr_utility.trace('hrsumrep - restrictions1e');
816: l_restriction_clause2 := REPLACE(l_restriction_clause,'@',l_alias);
817: end if;
818:
819: hr_utility.trace('hrsumrep - restrictions2');

Line 819: hr_utility.trace('hrsumrep - restrictions2');

815: hr_utility.trace('hrsumrep - restrictions1e');
816: l_restriction_clause2 := REPLACE(l_restriction_clause,'@',l_alias);
817: end if;
818:
819: hr_utility.trace('hrsumrep - restrictions2');
820: If l_character_after_brkt = concat('/','*parameteralias') then
821: l_where_clause := REPLACE(l_where_clause,'RESTRICTION.'||vrt.name||'['||l_alias||']',l_restriction_clause2); --write_stmt_log (p_stmt => 'l_where_cla= ' || l_where_clause);
822: else
823: l_where_clause := REPLACE(l_where_clause,'RESTRICTION.'||vrt.name||'['||l_alias||']',l_restriction_clause2); end if;

Line 838: hr_utility.trace('hrsumrep - complete restrictions');

834: l_pos2 := instr(l_where_clause,']',l_pos1,1)+1;
835: l_where_clause := substr(l_where_clause,1,l_pos1-1)||substr(l_where_clause,l_pos2,length(l_where_clause));
836: end loop;
837: --
838: hr_utility.trace('hrsumrep - complete restrictions');
839: -- Concatenate the full dynamic statement
840: --
841: l_stmt := 'select '||
842: l_count_clause1 ||

Line 854: hr_utility.set_location('Leaving : hrumrep.process_run ', 10);

850: p_statement := l_stmt;
851: --
852: end loop;
853: end if;
854: hr_utility.set_location('Leaving : hrumrep.process_run ', 10);
855: exception
856: when others then
857: write_error('Process Run error:');
858: write_error(sqlcode);