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

Line 18: hr_utility.set_location('Entering:'|| l_proc, 10);

14: l_proc varchar2(72) := 'lck';
15: --
16: begin
17: --
18: hr_utility.set_location('Entering:'|| l_proc, 10);
19: --
20: per_bil_shd.lck
21: (
22: p_id_value => p_id_value

Line 26: hr_utility.set_location(' Leaving:'||l_proc, 70);

22: p_id_value => p_id_value
23: ,p_object_version_number => p_object_version_number
24: );
25: --
26: hr_utility.set_location(' Leaving:'||l_proc, 70);
27: --
28: end lck;
29: -----------------
30: procedure row_data (p_business_group_id in number,

Line 76: hr_utility.set_location('Entering: hr_summary_api.row_data', 10);

72: );
73: --
74: begin
75: --
76: hr_utility.set_location('Entering: hr_summary_api.row_data', 10);
77: --
78: open csr_exists;
79: fetch csr_exists into l_id_value,
80: l_ovn;

Line 87: hr_utility.set_location('Leaving: hr_summary_api.row_data', 20);

83: l_ovn := 0;
84: end if;
85: close csr_exists;
86: --
87: hr_utility.set_location('Leaving: hr_summary_api.row_data', 20);
88: --
89: end row_data;
90: -----------------
91: function get_id (p_name in varchar2,

Line 293: hr_utility.set_location('Entering: hr_summary_api.create_item_type', 10);

289: l_ovn number := 0;
290: --
291: begin
292: --
293: hr_utility.set_location('Entering: hr_summary_api.create_item_type', 10);
294: --
295: row_data (p_business_group_id => p_business_group_id
296: ,p_type => 'ITEM_TYPE'
297: ,p_text_value1 => p_name

Line 328: hr_utility.set_location('Leaving: hr_summary_api.create_item_type', 20);

324: ,p_text_value6 => p_where_clause
325: ,p_text_value7 => p_seeded_data);
326: end if;
327: --
328: hr_utility.set_location('Leaving: hr_summary_api.create_item_type', 20);
329: --
330: end create_item_type;
331: -----------------
332: procedure create_key_type (p_key_type_id out nocopy number

Line 344: hr_utility.set_location('Entering: hr_summary_api.create_key_type'||p_seeded_data, 10);

340: l_ovn number := 0;
341: --
342: begin
343: --
344: hr_utility.set_location('Entering: hr_summary_api.create_key_type'||p_seeded_data, 10);
345: --
346: row_data (p_business_group_id => p_business_group_id
347: ,p_type => 'KEY_TYPE'
348: ,p_text_value1 => p_name

Line 371: hr_utility.set_location('Leaving: hr_summary_api.create_key_type'||p_seeded_data, 20);

367: ,p_text_value6 => p_key_function
368: ,p_text_value7 => p_seeded_data);
369: end if;
370: --
371: hr_utility.set_location('Leaving: hr_summary_api.create_key_type'||p_seeded_data, 20);
372: --
373: end create_key_type;
374: -----------------
375: procedure create_key_value (p_key_value_id out nocopy number

Line 383: hr_utility.set_location('Entering: hr_summary_api.create_key_value', 10);

379: ,p_item_value_id in number
380: ,p_name in varchar2 ) is
381: begin
382: --
383: hr_utility.set_location('Entering: hr_summary_api.create_key_value', 10);
384: --
385: /* call row handler package with correct parameters */
386: per_bil_ins.ins(p_type => 'KEY_VALUE'
387: ,p_id_value => p_key_value_id

Line 394: hr_utility.set_location('Leaving: hr_summary_api.create_key_value', 20);

390: ,p_fk_value1 => p_key_type_id
391: ,p_fk_value2 => p_item_value_id
392: ,p_text_value1 => p_name);
393: --
394: hr_utility.set_location('Leaving: hr_summary_api.create_key_value', 20);
395: --
396: end create_key_value;
397: -----------------
398: procedure create_item_value (p_item_value_id out nocopy number

Line 409: hr_utility.set_location('Entering: hr_summary_api.create_item_value', 10);

405: ,p_numvalue2 in number
406: ,p_datevalue in date ) is
407: begin
408: --
409: hr_utility.set_location('Entering: hr_summary_api.create_item_value', 10);
410: --
411: /* call row handler package with correct parameters */
412: per_bil_ins.ins(p_type => 'ITEM_VALUE'
413: ,p_id_value => p_item_value_id

Line 423: hr_utility.set_location('Leaving: hr_summary_api.create_item_value', 20);

419: ,p_num_value1 => p_numvalue1
420: ,p_num_value2 => p_numvalue2
421: ,p_date_value1 => p_datevalue);
422: --
423: hr_utility.set_location('Leaving: hr_summary_api.create_item_value', 20);
424: --
425: end create_item_value;
426: -----------------
427: procedure create_valid_restriction (p_valid_restriction_id out nocopy number

Line 439: hr_utility.set_location('Entering: hr_summary_api.create_valid_restriction', 10);

435: l_ovn number := 0;
436: --
437: begin
438: --
439: hr_utility.set_location('Entering: hr_summary_api.create_valid_restriction', 10);
440: --
441: row_data (p_business_group_id => p_business_group_id
442: ,p_type => 'VALID_RESTRICTION'
443: ,p_fk_value1 => p_item_type_id

Line 467: hr_utility.set_location('Leaving: hr_summary_api.create_valid_restriction', 20);

463: ,p_fk_value2 => p_restriction_type_id
464: ,p_text_value7 => p_seeded_data);
465: end if;
466: --
467: hr_utility.set_location('Leaving: hr_summary_api.create_valid_restriction', 20);
468: --
469: end create_valid_restriction;
470: -----------------
471: procedure create_restriction_type (p_restriction_type_id out nocopy number

Line 485: hr_utility.set_location('Entering: hr_summary_api.create_restriction_type', 10);

481: l_ovn number := 0;
482: --
483: begin
484: --
485: hr_utility.set_location('Entering: hr_summary_api.create_restriction_type', 10);
486: --
487: row_data (p_business_group_id => p_business_group_id
488: ,p_type => 'RESTRICTION_TYPE'
489: ,p_text_value1 => p_name

Line 516: hr_utility.set_location('Leaving: hr_summary_api.create_restriction_type', 20);

512: ,p_text_value4 => p_restriction_sql
513: ,p_text_value7 => p_seeded_data);
514: end if;
515: --
516: hr_utility.set_location('Leaving: hr_summary_api.create_restriction_type', 20);
517: --
518: end create_restriction_type;
519: -----------------
520: procedure create_restriction_usage (p_restriction_usage_id out nocopy number

Line 533: hr_utility.set_location('Entering: hr_summary_api.create_restriction_usage', 10);

529: l_ovn number := 0;
530: --
531: begin
532: --
533: hr_utility.set_location('Entering: hr_summary_api.create_restriction_usage', 10);
534: --
535: row_data (p_business_group_id => p_business_group_id
536: ,p_type => 'RESTRICTION_USAGE'
537: ,p_fk_value1 => p_item_type_usage_id

Line 563: hr_utility.set_location('Leaving: hr_summary_api.create_restriction_usage', 20);

559: ,p_text_value1 => p_restriction_type
560: ,p_text_value7 => p_seeded_data);
561: end if;
562: --
563: hr_utility.set_location('Leaving: hr_summary_api.create_restriction_usage', 20);
564: --
565: end create_restriction_usage;
566: -----------------
567: procedure create_restriction_value ( p_restriction_value_id out nocopy number

Line 579: hr_utility.set_location('Entering: hr_summary_api.create_restriction_value', 10);

575: l_ovn number := 0;
576: --
577: begin
578: --
579: hr_utility.set_location('Entering: hr_summary_api.create_restriction_value', 10);
580: --
581: row_data (p_business_group_id => p_business_group_id
582: ,p_type => 'RESTRICTION_VALUE'
583: ,p_text_value1 => p_value

Line 605: hr_utility.set_location('Leaving: hr_summary_api.create_restriction_value', 20);

601: ,p_fk_value1 => p_restriction_usage_id
602: ,p_text_value1 => p_value);
603: end if;
604: --
605: hr_utility.set_location('Leaving: hr_summary_api.create_restriction_value', 20);
606: --
607: end create_restriction_value;
608: -----------------
609: procedure create_item_type_usage ( p_item_type_usage_id out nocopy number

Line 623: hr_utility.set_location('Entering: hr_summary_api.create_item_type_usage', 10);

619: l_ovn number := 0;
620: --
621: begin
622: --
623: hr_utility.set_location('Entering: hr_summary_api.create_item_type_usage', 10);
624: --
625: row_data (p_business_group_id => p_business_group_id
626: ,p_type => 'ITEM_TYPE_USAGE'
627: ,p_text_value1 => p_name

Line 656: hr_utility.set_location('Leaving: hr_summary_api.create_item_type_usage', 20);

652: ,p_fk_value2 => p_item_type_id
653: ,p_text_value7 => p_seeded_data);
654: end if;
655: --
656: hr_utility.set_location('Leaving: hr_summary_api.create_item_type_usage', 20);
657: --
658: end create_item_type_usage;
659: -----------------
660: procedure create_valid_key_type (p_valid_key_type_id out nocopy number

Line 672: hr_utility.set_location('Entering: hr_summary_api.create_valid_key_type', 10);

668: l_ovn number := 0;
669: --
670: begin
671: --
672: hr_utility.set_location('Entering: hr_summary_api.create_valid_key_type', 10);
673: --
674: row_data (p_business_group_id => p_business_group_id
675: ,p_type => 'VALID_KEY_TYPE'
676: ,p_fk_value1 => p_item_type_id

Line 700: hr_utility.set_location('Leaving: hr_summary_api.create_valid_key_type', 20);

696: ,p_fk_value2 => p_key_type_id
697: ,p_text_value7 => p_seeded_data);
698: end if;
699: --
700: hr_utility.set_location('Leaving: hr_summary_api.create_valid_key_type', 20);
701: --
702: end create_valid_key_type;
703: -----------------
704: procedure create_key_type_usage (p_key_type_usage_id out nocopy number

Line 716: hr_utility.set_location('Entering: hr_summary_api.create_key_type_usage', 10);

712: l_ovn number := 0;
713: --
714: begin
715: --
716: hr_utility.set_location('Entering: hr_summary_api.create_key_type_usage', 10);
717: --
718: row_data (p_business_group_id => p_business_group_id
719: ,p_type => 'KEY_TYPE_USAGE'
720: ,p_fk_value1 => p_item_type_usage_id

Line 744: hr_utility.set_location('Leaving: hr_summary_api.create_key_type_usage', 20);

740: ,p_fk_value2 => p_valid_key_type_id
741: ,p_text_value7 => p_seeded_data);
742: end if;
743: --
744: hr_utility.set_location('Leaving: hr_summary_api.create_key_type_usage', 20);
745: --
746: end create_key_type_usage;
747: -----------------
748: procedure create_template (p_template_id out nocopy number

Line 759: hr_utility.set_location('Entering: hr_summary_api.create_template', 10);

755: l_ovn number := 0;
756: --
757: begin
758: --
759: hr_utility.set_location('Entering: hr_summary_api.create_template', 10);
760: --
761: row_data (p_business_group_id => p_business_group_id
762: ,p_type => 'TEMPLATE'
763: ,p_text_value1 => p_name

Line 784: hr_utility.set_location('Leaving: hr_summary_api.create_template', 20);

780: ,p_text_value1 => p_name
781: ,p_text_value7 => p_seeded_data);
782: end if;
783: --
784: hr_utility.set_location('Leaving: hr_summary_api.create_template', 20);
785: --
786: end create_template;
787: -----------------
788: procedure create_process_run (p_process_run_id out nocopy number

Line 796: hr_utility.set_location('Entering: hr_summary_api.create_process_run', 10);

792: ,p_template_id in varchar2
793: ,p_process_type in varchar2) is
794: begin
795: --
796: hr_utility.set_location('Entering: hr_summary_api.create_process_run', 10);
797: --
798: /* call row handler package with correct parameters */
799: per_bil_ins.ins(p_type => 'PROCESS_RUN'
800: ,p_id_value => p_process_run_id

Line 807: hr_utility.set_location('Leaving: hr_summary_api.create_process_run', 20);

803: ,p_text_value2 => p_name
804: ,p_fk_value1 => p_template_id
805: ,p_text_value1 => p_process_type);
806: --
807: hr_utility.set_location('Leaving: hr_summary_api.create_process_run', 20);
808: --
809: end create_process_run;
810: -----------------
811: procedure create_parameter (p_parameter_id out nocopy number

Line 819: hr_utility.set_location('Entering: hr_summary_api.create_process_run', 10);

815: ,p_name in varchar2
816: ,p_value in varchar2) is
817: begin
818: --
819: hr_utility.set_location('Entering: hr_summary_api.create_process_run', 10);
820: --
821: /* call row handler package with correct parameters */
822: per_bil_ins.ins(p_type => 'PARAMETER'
823: ,p_id_value => p_parameter_id

Line 830: hr_utility.set_location('Leaving: hr_summary_api.create_process_run', 20);

826: ,p_fk_value1 => p_process_run_id
827: ,p_text_value1 => p_name
828: ,p_text_value6 => p_value);
829: --
830: hr_utility.set_location('Leaving: hr_summary_api.create_process_run', 20);
831: --
832: end create_parameter;
833: -----------------------------------------------
834: --@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@--

Line 847: hr_utility.set_location('Entering:'|| l_proc, 10);

843: l_object_version_number hr_summary.object_version_number%TYPE;
844: --
845: begin
846: --
847: hr_utility.set_location('Entering:'|| l_proc, 10);
848: --
849: -- Issue a savepoint if operating in validation only mode
850: --
851: savepoint delete_hr_summary;

Line 853: hr_utility.set_location(l_proc, 20);

849: -- Issue a savepoint if operating in validation only mode
850: --
851: savepoint delete_hr_summary;
852: --
853: hr_utility.set_location(l_proc, 20);
854: --
855: -- Process Logic
856: --
857: l_object_version_number := p_object_version_number;

Line 863: hr_utility.set_location(l_proc, 60);

859: per_bil_del.del(p_id_value => p_id_value
860: ,p_object_version_number => l_object_version_number);
861: --
862: --
863: hr_utility.set_location(l_proc, 60);
864: --
865: -- When in validation only mode raise the Validate_Enabled exception
866: --
867: if p_validate then

Line 871: hr_utility.set_location(' Leaving:'||l_proc, 70);

867: if p_validate then
868: raise hr_api.validate_enabled;
869: end if;
870: --
871: hr_utility.set_location(' Leaving:'||l_proc, 70);
872: --
873: exception
874: --
875: when hr_api.validate_enabled then