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 HRSUMREP

Line 1: package body hrsumrep as

1: package body hrsumrep as
2: /* $Header: hrsumrep.pkb 115.14 2004/06/21 07:38:31 jheer noship $ */
3: --
4: procedure delete_process_data(p_process_run_id in number) is
5: --

Line 2: /* $Header: hrsumrep.pkb 115.14 2004/06/21 07:38:31 jheer noship $ */

1: package body hrsumrep as
2: /* $Header: hrsumrep.pkb 115.14 2004/06/21 07:38:31 jheer noship $ */
3: --
4: procedure delete_process_data(p_process_run_id in number) is
5: --
6: begin

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 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 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 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 863: end hrsumrep;

859: write_error(sqlerrm);
860: end process_run_form;
861: --
862:
863: end hrsumrep;