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_REPORTS dependencies on HR_REPORTS

Line 1: PACKAGE BODY hr_reports AS

1: PACKAGE BODY hr_reports AS
2: /* $Header: peperrep.pkb 120.1 2007/09/12 21:15:42 rnestor noship $
3: ******************************************************************
4: * *
5: * Copyright (C) 1992 Oracle Corporation UK Ltd., *

Line 21: Name : hr_reports (BODY)

17: * Oracle Park, Bittams Lane, Guildford Road, Chertsey, Surrey, *
18: * England. *
19: * *
20: ******************************************************************
21: Name : hr_reports (BODY)
22: File : hr_reports.pkb
23: Description : This package declares functions which are used to
24: return Values for the SRW2 reports.
25: --

Line 22: File : hr_reports.pkb

18: * England. *
19: * *
20: ******************************************************************
21: Name : hr_reports (BODY)
22: File : hr_reports.pkb
23: Description : This package declares functions which are used to
24: return Values for the SRW2 reports.
25: --
26: Change List

Line 195: hr_utility.set_location('hr_reports.get_budget',1);

191: begin
192: --
193: hr_utility.trace('Entered Get_Budget');
194: --
195: hr_utility.set_location('hr_reports.get_budget',1);
196: if p_budget_id IS NULL then
197: null;
198: else
199: begin

Line 200: hr_utility.set_location('hr_reports.get_budget',5);

196: if p_budget_id IS NULL then
197: null;
198: else
199: begin
200: hr_utility.set_location('hr_reports.get_budget',5);
201: SELECT name
202: INTO l_budget_name
203: FROM per_budgets
204: WHERE budget_id = p_budget_id;

Line 226: hr_utility.set_location('hr_reports.get_budget_version',1);

222: begin
223: --
224: hr_utility.trace('Entered Get_Budget_version');
225: --
226: hr_utility.set_location('hr_reports.get_budget_version',1);
227: if p_budget_id IS NULL OR p_budget_version_id IS NULL then
228: null;
229: else
230: begin

Line 231: hr_utility.set_location('hr_reports.get_budget_version',5);

227: if p_budget_id IS NULL OR p_budget_version_id IS NULL then
228: null;
229: else
230: begin
231: hr_utility.set_location('hr_reports.get_budget_version',5);
232: SELECT version_number
233: INTO l_budget_version_number
234: FROM per_budget_versions
235: WHERE budget_id = p_budget_id

Line 257: hr_utility.set_location('hr_reports.get_organization',5);

253: begin
254: --
255: hr_utility.trace('Entered get_organization');
256: --
257: hr_utility.set_location('hr_reports.get_organization',5);
258: if p_organization_id is null then
259: null;
260: else
261: begin

Line 262: hr_utility.set_location('hr_reports.get_organization',10);

258: if p_organization_id is null then
259: null;
260: else
261: begin
262: hr_utility.set_location('hr_reports.get_organization',10);
263: select orgtl.name,
264: hrl.meaning
265: into p_org_name,
266: p_org_type

Line 295: hr_utility.set_location('hr_reports.get_job',5);

291: --
292: hr_utility.trace('Entered Get_Job');
293: --
294: begin
295: hr_utility.set_location('hr_reports.get_job',5);
296: SELECT name
297: INTO l_job_name
298: FROM per_jobs_vl
299: WHERE job_id = p_job_id;

Line 326: hr_utility.set_location('hr_reports.get_position',5);

322: begin
323: --
324: -- Changed 02-Oct-99 SCNair (per_positions to hr_positions) Date Tracked Positions requirement
325: --
326: hr_utility.set_location('hr_reports.get_position',5);
327: SELECT name
328: INTO l_position_name
329: FROM hr_positions
330: WHERE position_id = p_position_id;

Line 358: hr_utility.set_location('hr_reports.get_position',5);

354: --
355: begin
356: --
357: --
358: hr_utility.set_location('hr_reports.get_position',5);
359: SELECT name
360: INTO l_position_name
361: FROM hr_positions_f paf
362: WHERE paf.position_id = p_position_id

Line 384: hr_utility.set_location('hr_reports.get_grade',5);

380: --
381: hr_utility.trace('Entered Get_Grade');
382: --
383: begin
384: hr_utility.set_location('hr_reports.get_grade',5);
385: SELECT name
386: INTO l_grade_name
387: FROM per_grades_vl
388: WHERE grade_id = p_grade_id;

Line 411: hr_utility.set_location('hr_reports.get_status',5);

407: --
408: hr_utility.trace('Entered Get_Status');
409: --
410: begin
411: hr_utility.set_location('hr_reports.get_status',5);
412: -- bug fix 4157312
413: -- join between per_ass_status_type_amends_tl and
414: -- per_ass_status_type_amends changed to outer join.
415:

Line 456: hr_utility.set_location('hr_reports.get_abs_type',5);

452: --
453: hr_utility.trace('Entered Get_Abs_Type');
454: --
455: begin
456: hr_utility.set_location('hr_reports.get_abs_type',5);
457: SELECT name
458: INTO l_abs_name
459: FROM per_abs_attendance_types_vl
460: WHERE absence_attendance_type_id = p_abs_att_type_id;

Line 482: hr_utility.set_location('hr_reports.get_time_period',1);

478: begin
479: --
480: hr_utility.trace('Entered Get_time_period');
481: --
482: hr_utility.set_location('hr_reports.get_time_period',1);
483: if p_time_period_id IS NULL then
484: null;
485: else
486: begin

Line 487: hr_utility.set_location('hr_reports.get_time_period',5);

483: if p_time_period_id IS NULL then
484: null;
485: else
486: begin
487: hr_utility.set_location('hr_reports.get_time_period',5);
488: SELECT period_name
489: , start_date
490: , end_date
491: INTO p_period_name

Line 512: hr_utility.trace('Entered hr_reports.get_element_name');

508: AS
509: v_element_name pay_element_types_f_tl.element_name%type;
510: --
511: begin
512: hr_utility.trace('Entered hr_reports.get_element_name');
513: --
514: hr_utility.set_location('hr_reports.get_element_name',5);
515: if p_element_type_id is null then
516: null;

Line 514: hr_utility.set_location('hr_reports.get_element_name',5);

510: --
511: begin
512: hr_utility.trace('Entered hr_reports.get_element_name');
513: --
514: hr_utility.set_location('hr_reports.get_element_name',5);
515: if p_element_type_id is null then
516: null;
517: else
518: begin

Line 519: hr_utility.set_location('hr_reports.get_element_name',10);

515: if p_element_type_id is null then
516: null;
517: else
518: begin
519: hr_utility.set_location('hr_reports.get_element_name',10);
520: select etl.element_name
521: into v_element_name
522: from pay_element_types_f_tl etl,
523: pay_element_types_f e

Line 535: hr_utility.trace('Leaving hr_reports.get_element_name');

531: when no_data_found then null;
532: end;
533: end if;
534: --
535: hr_utility.trace('Leaving hr_reports.get_element_name');
536: --
537: return v_element_name;
538: --
539: end get_element_name;

Line 551: hr_utility.trace('Entered hr_reports.get_payroll_name');

547: v_payroll_name pay_payrolls_f.payroll_name%type;
548: --
549: begin
550: --
551: hr_utility.trace('Entered hr_reports.get_payroll_name');
552: --
553: hr_utility.set_location('hr_reports.get_payroll_name',5);
554: if p_payroll_id is null then
555: null;

Line 553: hr_utility.set_location('hr_reports.get_payroll_name',5);

549: begin
550: --
551: hr_utility.trace('Entered hr_reports.get_payroll_name');
552: --
553: hr_utility.set_location('hr_reports.get_payroll_name',5);
554: if p_payroll_id is null then
555: null;
556: else
557: begin

Line 558: hr_utility.set_location('hr_reports.get_payroll_name',10);

554: if p_payroll_id is null then
555: null;
556: else
557: begin
558: hr_utility.set_location('hr_reports.get_payroll_name',10);
559: select p.payroll_name
560: into v_payroll_name
561: from pay_payrolls_f p
562: where payroll_id = p_payroll_id

Line 571: hr_utility.trace('Leaving hr_reports.get_payroll_name');

567: when no_data_found then null;
568: end;
569: end if;
570: --
571: hr_utility.trace('Leaving hr_reports.get_payroll_name');
572: --
573: return v_payroll_name;
574: --
575: end get_payroll_name;

Line 586: hr_utility.trace('Entered hr_reports.get_business_group');

582: v_business_group_name hr_organization_units.name%type;
583: --
584: begin
585: --
586: hr_utility.trace('Entered hr_reports.get_business_group');
587: --
588: hr_utility.set_location('hr_reports.get_business_group',5);
589: if p_business_group_id is null then
590: null;

Line 588: hr_utility.set_location('hr_reports.get_business_group',5);

584: begin
585: --
586: hr_utility.trace('Entered hr_reports.get_business_group');
587: --
588: hr_utility.set_location('hr_reports.get_business_group',5);
589: if p_business_group_id is null then
590: null;
591: else
592: begin

Line 593: hr_utility.set_location('hr_reports.get_business_group',10);

589: if p_business_group_id is null then
590: null;
591: else
592: begin
593: hr_utility.set_location('hr_reports.get_business_group',10);
594: select org.name
595: into v_business_group_name
596: from hr_all_organization_units_tl org
597: -- where org.organization_id + 0 = p_business_group_id

Line 607: hr_utility.trace('Leaving hr_reports.get_business_group');

603: when no_data_found then null;
604: end;
605: end if;
606: --
607: hr_utility.trace('Leaving hr_reports.get_business_group');
608: --
609: return v_business_group_name;
610: --
611: end get_business_group;

Line 623: hr_utility.trace('Entered hr_reports.count_org_subordinates');

619: v_subordinate_count number;
620: --
621: begin
622: --
623: hr_utility.trace('Entered hr_reports.count_org_subordinates');
624: --
625: hr_utility.set_location('hr_reports.count_org_subordinates',5);
626: if p_org_structure_version_id is null or
627: p_parent_organization_id is null then

Line 625: hr_utility.set_location('hr_reports.count_org_subordinates',5);

621: begin
622: --
623: hr_utility.trace('Entered hr_reports.count_org_subordinates');
624: --
625: hr_utility.set_location('hr_reports.count_org_subordinates',5);
626: if p_org_structure_version_id is null or
627: p_parent_organization_id is null then
628: null;
629: else

Line 631: hr_utility.set_location('hr_reports.count_org_subordinates',10);

627: p_parent_organization_id is null then
628: null;
629: else
630: begin
631: hr_utility.set_location('hr_reports.count_org_subordinates',10);
632: select nvl(count(*),0)
633: into v_subordinate_count
634: from per_org_structure_elements ose
635: connect by ose.organization_id_parent = prior ose.organization_id_child

Line 644: hr_utility.trace('Leaving hr_reports.count_org_subordinates');

640: when no_data_found then null;
641: end;
642: end if;
643: --
644: hr_utility.trace('Leaving hr_reports.count_org_subordinates');
645: --
646: return v_subordinate_count;
647: --
648: end count_org_subordinates;

Line 660: hr_utility.trace('Entered hr_reports.count_pos_subordinates');

656: v_subordinate_count number;
657: --
658: begin
659: --
660: hr_utility.trace('Entered hr_reports.count_pos_subordinates');
661: --
662: hr_utility.set_location('hr_reports.count_pos_subordinates',5);
663: if p_pos_structure_version_id is null or
664: p_parent_position_id is null then

Line 662: hr_utility.set_location('hr_reports.count_pos_subordinates',5);

658: begin
659: --
660: hr_utility.trace('Entered hr_reports.count_pos_subordinates');
661: --
662: hr_utility.set_location('hr_reports.count_pos_subordinates',5);
663: if p_pos_structure_version_id is null or
664: p_parent_position_id is null then
665: null;
666: else

Line 668: hr_utility.set_location('hr_reports.count_pos_subordinates',10);

664: p_parent_position_id is null then
665: null;
666: else
667: begin
668: hr_utility.set_location('hr_reports.count_pos_subordinates',10);
669: select nvl(count(*),0)
670: into v_subordinate_count
671: from per_pos_structure_elements pse
672: connect by pse.parent_position_id = prior pse.subordinate_position_id

Line 681: hr_utility.trace('Leaving hr_reports.count_pos_subordinates');

677: when no_data_found then null;
678: end;
679: end if;
680: --
681: hr_utility.trace('Leaving hr_reports.count_pos_subordinates');
682: --
683: return v_subordinate_count;
684: --
685: end count_pos_subordinates;

Line 700: hr_utility.trace('Entered hr_reports.get_organization_hierarchy');

696: AS
697: --
698: begin
699: --
700: hr_utility.trace('Entered hr_reports.get_organization_hierarchy');
701: --
702: hr_utility.set_location('hr_reports.get_organization_hierarchy',5);
703: if p_organization_structure_id is not null then
704: begin

Line 702: hr_utility.set_location('hr_reports.get_organization_hierarchy',5);

698: begin
699: --
700: hr_utility.trace('Entered hr_reports.get_organization_hierarchy');
701: --
702: hr_utility.set_location('hr_reports.get_organization_hierarchy',5);
703: if p_organization_structure_id is not null then
704: begin
705: hr_utility.set_location('hr_reports.get_organization_hierarchy',10);
706: select ost.name

Line 705: hr_utility.set_location('hr_reports.get_organization_hierarchy',10);

701: --
702: hr_utility.set_location('hr_reports.get_organization_hierarchy',5);
703: if p_organization_structure_id is not null then
704: begin
705: hr_utility.set_location('hr_reports.get_organization_hierarchy',10);
706: select ost.name
707: into p_org_structure_name
708: from per_organization_structures ost
709: where ost.organization_structure_id = p_organization_structure_id;

Line 715: hr_utility.set_location('hr_reports.get_organization_hierarchy',15);

711: when no_data_found then null;
712: end;
713: elsif p_org_structure_version_id is not null then
714: begin
715: hr_utility.set_location('hr_reports.get_organization_hierarchy',15);
716: select ost.name,
717: osv.version_number,
718: osv.date_from,
719: osv.date_to

Line 733: hr_utility.trace('Leaving hr_reports.get_organization_hierarchy');

729: when no_data_found then null;
730: end;
731: end if;
732: --
733: hr_utility.trace('Leaving hr_reports.get_organization_hierarchy');
734: --
735: end get_organization_hierarchy;
736: --
737: --

Line 750: hr_utility.trace('Entered hr_reports.get_position_hierarchy');

746: AS
747: --
748: begin
749: --
750: hr_utility.trace('Entered hr_reports.get_position_hierarchy');
751: --
752: hr_utility.set_location('hr_reports.get_position_hierarchy',5);
753: if p_position_structure_id is not null then
754: begin

Line 752: hr_utility.set_location('hr_reports.get_position_hierarchy',5);

748: begin
749: --
750: hr_utility.trace('Entered hr_reports.get_position_hierarchy');
751: --
752: hr_utility.set_location('hr_reports.get_position_hierarchy',5);
753: if p_position_structure_id is not null then
754: begin
755: hr_utility.set_location('hr_reports.get_position_hierarchy',10);
756: select pst.name

Line 755: hr_utility.set_location('hr_reports.get_position_hierarchy',10);

751: --
752: hr_utility.set_location('hr_reports.get_position_hierarchy',5);
753: if p_position_structure_id is not null then
754: begin
755: hr_utility.set_location('hr_reports.get_position_hierarchy',10);
756: select pst.name
757: into p_pos_structure_name
758: from per_position_structures pst
759: where pst.position_structure_id = p_position_structure_id;

Line 765: hr_utility.set_location('hr_reports.get_position_hierarchy',15);

761: when no_data_found then null;
762: end;
763: elsif p_pos_structure_version_id is not null then
764: begin
765: hr_utility.set_location('hr_reports.get_position_hierarchy',15);
766: select pst.name,
767: psv.version_number,
768: psv.date_from,
769: psv.date_to

Line 783: hr_utility.trace('Leaving hr_reports.get_position_hierarchy');

779: when no_data_found then null;
780: end;
781: end if;
782: --
783: hr_utility.trace('Leaving hr_reports.get_position_hierarchy');
784: --
785: end get_position_hierarchy;
786: --
787: --

Line 797: hr_utility.trace('Entered hr_reports.get_lookup_meaning');

793: v_meaning hr_lookups.meaning%type;
794: --
795: begin
796: --
797: hr_utility.trace('Entered hr_reports.get_lookup_meaning');
798: --
799: begin
800: hr_utility.set_location('hr_reports.get_lookup_meaning',5);
801: select hrl.meaning

Line 800: hr_utility.set_location('hr_reports.get_lookup_meaning',5);

796: --
797: hr_utility.trace('Entered hr_reports.get_lookup_meaning');
798: --
799: begin
800: hr_utility.set_location('hr_reports.get_lookup_meaning',5);
801: select hrl.meaning
802: into v_meaning
803: from hr_lookups hrl
804: where hrl.lookup_type = p_lookup_type

Line 810: hr_utility.trace('Leaving hr_reports.get_lookup_meaning');

806: exception
807: when no_data_found then null;
808: end;
809: --
810: hr_utility.trace('Leaving hr_reports.get_lookup_meaning');
811: --
812: return v_meaning;
813: --
814: end get_lookup_meaning;

Line 842: hr_utility.set_location('hr_reports.person_matching_skills',5);

838: --
839: BEGIN
840: --
841: BEGIN
842: hr_utility.set_location('hr_reports.person_matching_skills',5);
843: select sign(count(*))
844: into l_number_matching
845: from per_person_analyses p
846: where p.person_id = P_PERSON_ID

Line 965: hr_utility.trace('Entered hr_reports.person_matching_skills');

961: --
962: --
963: BEGIN
964: --
965: hr_utility.trace('Entered hr_reports.person_matching_skills');
966: --
967: if p_matching_level = 'A' then
968: if p_no_of_essential > 0 then
969: hr_utility.set_location('hr_reports.person_matching_skills',10);

Line 969: hr_utility.set_location('hr_reports.person_matching_skills',10);

965: hr_utility.trace('Entered hr_reports.person_matching_skills');
966: --
967: if p_matching_level = 'A' then
968: if p_no_of_essential > 0 then
969: hr_utility.set_location('hr_reports.person_matching_skills',10);
970: l_person_matches := count_skills(p_person_id
971: ,p_job_position_id
972: ,p_job_position_type
973: ,'Y'

Line 978: hr_utility.set_location('hr_reports.person_matching_skills',10);

974: ,p_no_of_essential);
975: end if;
976: elsif p_matching_level = 'D' then
977: if p_no_of_essential > 0 then
978: hr_utility.set_location('hr_reports.person_matching_skills',10);
979: l_person_matches := count_skills(p_person_id
980: ,p_job_position_id
981: ,p_job_position_type
982: ,'Y'

Line 987: hr_utility.set_location('hr_reports.person_matching_skills',10);

983: ,p_no_of_essential);
984: end if;
985: if p_no_of_desirable > 0
986: and l_person_matches = TRUE then
987: hr_utility.set_location('hr_reports.person_matching_skills',10);
988: l_person_matches := count_skills(p_person_id
989: ,p_job_position_id
990: ,p_job_position_type
991: ,'N'

Line 996: hr_utility.set_location('hr_reports.person_matching_skills',10);

992: ,1);
993: end if;
994: else -- matching_level = 'S'
995: if p_no_of_essential > 0 then
996: hr_utility.set_location('hr_reports.person_matching_skills',10);
997: l_person_matches := count_skills(p_person_id
998: ,p_job_position_id
999: ,p_job_position_type
1000: ,'Y'

Line 1016: hr_reports.split_segments(p_concatenated_segments,

1012: ,p_id_flex_num NUMBER
1013: ,p_segtab OUT NOCOPY SegmentTabType
1014: ,p_segments_used OUT NOCOPY NUMBER) IS
1015: begin
1016: hr_reports.split_segments(p_concatenated_segments,
1017: p_id_flex_num,
1018: p_segtab,
1019: p_segments_used,
1020: NULL);

Line 1030: hr_reports.split_segments(p_concatenated_segments,

1026: ,p_segtab OUT NOCOPY SegmentTabType
1027: ,p_segments_used OUT NOCOPY NUMBER
1028: ,p_id_flex_code VARCHAR2) IS
1029: begin
1030: hr_reports.split_segments(p_concatenated_segments,
1031: p_id_flex_num,
1032: p_segtab,
1033: p_segments_used,
1034: p_id_flex_code,

Line 1055: hr_utility.trace('Entered hr_reports.split_segments');

1051: l_count NUMBER := 1;
1052: l_seg_sep VARCHAR2(1) := '.';
1053: --
1054: begin
1055: hr_utility.trace('Entered hr_reports.split_segments');
1056: --
1057: hr_utility.set_location('hr_reports.split_segments',10);
1058: --
1059: begin

Line 1057: hr_utility.set_location('hr_reports.split_segments',10);

1053: --
1054: begin
1055: hr_utility.trace('Entered hr_reports.split_segments');
1056: --
1057: hr_utility.set_location('hr_reports.split_segments',10);
1058: --
1059: begin
1060: select DISTINCT CONCATENATED_SEGMENT_DELIMITER
1061: into l_seg_sep

Line 1070: hr_utility.set_location('hr_reports.split_segments',10);

1066: exception
1067: when NO_DATA_FOUND then null;
1068: end;
1069: --
1070: hr_utility.set_location('hr_reports.split_segments',10);
1071: --
1072: l_concat_segs := l_seg_sep || p_concatenated_segments || l_seg_sep;
1073: l_no_of_segs := length(l_concat_segs)
1074: - length(replace(l_concat_segs,l_seg_sep));

Line 1095: hr_reports.gen_partial_matching_lexical(p_concatenated_segments,

1091: (p_concatenated_segments IN VARCHAR2
1092: ,p_id_flex_num IN NUMBER
1093: ,p_matching_lexical IN OUT NOCOPY VARCHAR2) IS
1094: begin
1095: hr_reports.gen_partial_matching_lexical(p_concatenated_segments,
1096: p_id_flex_num,
1097: p_matching_lexical,
1098: NULL);
1099: end;

Line 1107: hr_reports.gen_partial_matching_lexical(p_concatenated_segments,

1103: ,p_id_flex_num IN NUMBER
1104: ,p_matching_lexical IN OUT NOCOPY VARCHAR2
1105: ,p_id_flex_code IN VARCHAR2) IS
1106: begin
1107: hr_reports.gen_partial_matching_lexical(p_concatenated_segments,
1108: p_id_flex_num,
1109: p_matching_lexical,
1110: p_id_flex_code,
1111: NULL);

Line 1123: l_segtab hr_reports.SegmentTabType;

1119: ,p_id_flex_code VARCHAR2
1120: ,p_application_id IN NUMBER) IS
1121: --
1122: l_count NUMBER(10) := 0;
1123: l_segtab hr_reports.SegmentTabType;
1124: l_segments_used NUMBER(10);
1125: --
1126: -- this cursor is used to get the order of the segments from the foundation
1127: -- table

Line 1139: hr_utility.trace('Entered hr_reports.gen_partial_matching_lexical');

1135: order by segment_num;
1136: --
1137: begin
1138: --
1139: hr_utility.trace('Entered hr_reports.gen_partial_matching_lexical');
1140: --
1141: hr_utility.set_location ('hr_reports.gen_partial_matching_lexical', 5);
1142: --
1143: hr_reports.split_segments(p_concatenated_segments

Line 1141: hr_utility.set_location ('hr_reports.gen_partial_matching_lexical', 5);

1137: begin
1138: --
1139: hr_utility.trace('Entered hr_reports.gen_partial_matching_lexical');
1140: --
1141: hr_utility.set_location ('hr_reports.gen_partial_matching_lexical', 5);
1142: --
1143: hr_reports.split_segments(p_concatenated_segments
1144: ,p_id_flex_num
1145: ,l_segtab

Line 1143: hr_reports.split_segments(p_concatenated_segments

1139: hr_utility.trace('Entered hr_reports.gen_partial_matching_lexical');
1140: --
1141: hr_utility.set_location ('hr_reports.gen_partial_matching_lexical', 5);
1142: --
1143: hr_reports.split_segments(p_concatenated_segments
1144: ,p_id_flex_num
1145: ,l_segtab
1146: ,l_segments_used
1147: ,p_id_flex_code);

Line 1149: hr_utility.set_location ('hr_reports.gen_partial_matching_lexical', 10);

1145: ,l_segtab
1146: ,l_segments_used
1147: ,p_id_flex_code);
1148: --
1149: hr_utility.set_location ('hr_reports.gen_partial_matching_lexical', 10);
1150: for c1rec in c1 loop
1151: l_count := l_count + 1;
1152: --
1153: if l_segtab(l_count) is null then null;

Line 1204: hr_reports.get_attributes( p_concatenated_segments

1200: l_aol_seperator_flag boolean := true;
1201: --
1202: begin
1203: --
1204: hr_reports.get_attributes( p_concatenated_segments
1205: ,p_name
1206: ,l_aol_seperator_flag
1207: ,p_segments_used
1208: ,p_value1

Line 1280: l_segtab hr_reports.SegmentTabType;

1276: ,p_value28 OUT NOCOPY VARCHAR2
1277: ,p_value29 OUT NOCOPY VARCHAR2
1278: ,p_value30 OUT NOCOPY VARCHAR2 ) IS
1279: --
1280: l_segtab hr_reports.SegmentTabType;
1281: l_segments_used NUMBER(10);
1282: --
1283: begin
1284: --

Line 1285: hr_utility.trace('Entered hr_reports.get_attributes');

1281: l_segments_used NUMBER(10);
1282: --
1283: begin
1284: --
1285: hr_utility.trace('Entered hr_reports.get_attributes');
1286: --
1287: hr_utility.set_location ('hr_reports.get_attributes', 5);
1288: --
1289: hr_reports.split_attributes( p_concatenated_segments

Line 1287: hr_utility.set_location ('hr_reports.get_attributes', 5);

1283: begin
1284: --
1285: hr_utility.trace('Entered hr_reports.get_attributes');
1286: --
1287: hr_utility.set_location ('hr_reports.get_attributes', 5);
1288: --
1289: hr_reports.split_attributes( p_concatenated_segments
1290: ,p_name
1291: ,p_aol_seperator_flag

Line 1289: hr_reports.split_attributes( p_concatenated_segments

1285: hr_utility.trace('Entered hr_reports.get_attributes');
1286: --
1287: hr_utility.set_location ('hr_reports.get_attributes', 5);
1288: --
1289: hr_reports.split_attributes( p_concatenated_segments
1290: ,p_name
1291: ,p_aol_seperator_flag
1292: ,l_segtab
1293: ,l_segments_used);

Line 1299: hr_utility.set_location ('hr_reports.get_attributes', 10);

1295: for i in nvl(l_segments_used, 0) + 1..30 loop
1296: l_segtab(i) := null;
1297: end loop;
1298: --
1299: hr_utility.set_location ('hr_reports.get_attributes', 10);
1300: --
1301: p_segments_used := l_segments_used;
1302: p_value1 := l_segtab(1);
1303: p_value2 := l_segtab(2);

Line 1349: hr_reports.split_attributes( p_concatenated_segments

1345: l_aol_seperator_flag boolean := true;
1346: --
1347: begin
1348: --
1349: hr_reports.split_attributes( p_concatenated_segments
1350: ,p_title
1351: ,l_aol_seperator_flag
1352: ,p_segtab
1353: ,p_segments_used

Line 1376: hr_utility.trace('Entered hr_reports.split_attributes');

1372: l_count NUMBER := 1;
1373: l_seg_sep VARCHAR2(1) := '.';
1374: --
1375: begin
1376: hr_utility.trace('Entered hr_reports.split_attributes');
1377: --
1378: hr_utility.set_location('hr_reports.split_attributes',10);
1379: --
1380: if (p_aol_seperator_flag = true) then

Line 1378: hr_utility.set_location('hr_reports.split_attributes',10);

1374: --
1375: begin
1376: hr_utility.trace('Entered hr_reports.split_attributes');
1377: --
1378: hr_utility.set_location('hr_reports.split_attributes',10);
1379: --
1380: if (p_aol_seperator_flag = true) then
1381: --
1382: begin

Line 1395: hr_utility.set_location('hr_reports.split_attributes',10);

1391: else
1392: l_seg_sep := fnd_global.local_chr(127);
1393: end if;
1394: --
1395: hr_utility.set_location('hr_reports.split_attributes',10);
1396: --
1397: l_concat_segs := l_seg_sep || p_concatenated_segments || l_seg_sep;
1398: l_no_of_segs := length(l_concat_segs)
1399: - length(replace(l_concat_segs,l_seg_sep));

Line 1448: l_segtab hr_reports.SegmentTabType;

1444: ,p_value28 OUT NOCOPY VARCHAR2
1445: ,p_value29 OUT NOCOPY VARCHAR2
1446: ,p_value30 OUT NOCOPY VARCHAR2 ) IS
1447: --
1448: l_segtab hr_reports.SegmentTabType;
1449: l_segments_used NUMBER(10);
1450: --
1451: begin
1452: --

Line 1453: hr_utility.trace('Entered hr_reports.get_segments');

1449: l_segments_used NUMBER(10);
1450: --
1451: begin
1452: --
1453: hr_utility.trace('Entered hr_reports.get_segments');
1454: --
1455: hr_utility.set_location ('hr_reports.get_segments', 5);
1456: hr_reports.split_segments(p_concatenated_segments
1457: ,p_id_flex_num

Line 1455: hr_utility.set_location ('hr_reports.get_segments', 5);

1451: begin
1452: --
1453: hr_utility.trace('Entered hr_reports.get_segments');
1454: --
1455: hr_utility.set_location ('hr_reports.get_segments', 5);
1456: hr_reports.split_segments(p_concatenated_segments
1457: ,p_id_flex_num
1458: ,l_segtab
1459: ,l_segments_used);

Line 1456: hr_reports.split_segments(p_concatenated_segments

1452: --
1453: hr_utility.trace('Entered hr_reports.get_segments');
1454: --
1455: hr_utility.set_location ('hr_reports.get_segments', 5);
1456: hr_reports.split_segments(p_concatenated_segments
1457: ,p_id_flex_num
1458: ,l_segtab
1459: ,l_segments_used);
1460: --

Line 1465: hr_utility.set_location ('hr_reports.get_segments', 10);

1461: for i in l_segments_used + 1..30 loop
1462: l_segtab(i) := null;
1463: end loop;
1464: --
1465: hr_utility.set_location ('hr_reports.get_segments', 10);
1466: --
1467: p_segments_used := l_segments_used;
1468: p_value1 := l_segtab(1);
1469: p_value2 := l_segtab(2);

Line 1612: hr_reports.get_desc_flex_context

1608: p_label_expr out nocopy varchar2,
1609: p_column_expr out nocopy varchar2
1610: ) is
1611: begin
1612: hr_reports.get_desc_flex_context
1613: (p_appl_short_name,
1614: p_desc_flex_name,
1615: p_table_alias,
1616: 'Y',

Line 1798: hr_reports.get_dvlpr_desc_flex( p_appl_short_name

1794: l_aol_seperator_flag boolean := true;
1795: --
1796: begin
1797: --
1798: hr_reports.get_dvlpr_desc_flex( p_appl_short_name
1799: ,p_desc_flex_name
1800: ,p_desc_flex_context
1801: ,p_table_alias
1802: ,l_aol_seperator_flag

Line 1924: hr_utility.trace('entered hr_reports.get_person_name');

1920: v_person_name per_all_people_f.full_name%type;
1921: --
1922: begin
1923: --
1924: hr_utility.trace('entered hr_reports.get_person_name');
1925: --
1926: hr_utility.set_location('hr_reports.get_person_name',5);
1927: if p_person_id is null then
1928: null;

Line 1926: hr_utility.set_location('hr_reports.get_person_name',5);

1922: begin
1923: --
1924: hr_utility.trace('entered hr_reports.get_person_name');
1925: --
1926: hr_utility.set_location('hr_reports.get_person_name',5);
1927: if p_person_id is null then
1928: null;
1929: else
1930: begin

Line 1931: hr_utility.set_location('hr_reports.get_person_name',10);

1927: if p_person_id is null then
1928: null;
1929: else
1930: begin
1931: hr_utility.set_location('hr_reports.get_person_name',10);
1932: select p.full_name
1933: into v_person_name
1934: from per_all_people_f p
1935: where p.person_id = p_person_id

Line 1943: hr_utility.trace('leaving hr_reports.get_person_name');

1939: when no_data_found then null;
1940: end;
1941: end if;
1942: --
1943: hr_utility.trace('leaving hr_reports.get_person_name');
1944: --
1945: return v_person_name;
1946: --
1947: end get_person_name;

Line 1956: hr_utility.set_location('Entering hr_reports.get_party_number',5);

1952: l_party_number hz_parties.party_number%type;
1953: --
1954: begin
1955: --
1956: hr_utility.set_location('Entering hr_reports.get_party_number',5);
1957: --
1958: begin
1959: --
1960: select party_number

Line 1965: hr_utility.set_location('hr_reports.get_party_number',10);

1961: into l_party_number
1962: from hz_parties
1963: where party_id = p_party_id;
1964: --
1965: hr_utility.set_location('hr_reports.get_party_number',10);
1966: --
1967: exception
1968: when no_data_found then
1969: null;

Line 1970: hr_utility.set_location('hr_reports.get_party_number',15);

1966: --
1967: exception
1968: when no_data_found then
1969: null;
1970: hr_utility.set_location('hr_reports.get_party_number',15);
1971: end;
1972: --
1973: hr_utility.set_location('Leaving hr_reports.get_party_number',20);
1974: --

Line 1973: hr_utility.set_location('Leaving hr_reports.get_party_number',20);

1969: null;
1970: hr_utility.set_location('hr_reports.get_party_number',15);
1971: end;
1972: --
1973: hr_utility.set_location('Leaving hr_reports.get_party_number',20);
1974: --
1975: return l_party_number;
1976: --
1977: end get_party_number;

Line 1979: end hr_reports;

1975: return l_party_number;
1976: --
1977: end get_party_number;
1978: --
1979: end hr_reports;