[Home] [Help]
PACKAGE BODY: APPS.PER_PERHDSUM_XMLP_PKG
Source
1 PACKAGE BODY PER_PERHDSUM_XMLP_PKG AS
2 /* $Header: PERHDSUMB.pls 120.1 2007/12/06 11:27:19 amakrish noship $ */
3 function BeforeReport return boolean is
4 begin
5
6 P_REPORT_DATE_FROM_LP := TO_CHAR(P_REPORT_DATE_FROM,'DD-MON-YYYY') ;
7 P_REPORT_DATE_TO_LP := TO_CHAR(P_REPORT_DATE_TO,'DD-MON-YYYY') ;
8 --hr_standard.event('BEFORE REPORT');
9
10 /*srw.message('000','File = PER_PERHDSUM_XMLP_PKG 115.0');*/null;
11
12
13 insert into fnd_sessions
14 (session_id,effective_date)
15 values(userenv('SESSIONID'),sysdate);
16
17 /*srw.message('001','Start of Before Report Trigger');*/null;
18
19
20 cp_business_group_name := hr_reports.get_business_group(p_business_group_id);
21
22 /*srw.message('002','Business group Name = '||cp_business_group_name);*/null;
23
24
25 cp_top_org_name := hr_person_flex_logic.GetOrgAliasName(
26 p_top_organization_id,sysdate);
27
28 /*srw.message('003','Top Organization Name = '||cp_top_org_name);*/null;
29
30 /*srw.message('005','viji');*/null;
31
32
33
34 select name
35 into cp_organization_hierarchy_name
36 from per_organization_structures
37 where organization_structure_id = P_ORGANIZATION_STRUCTURE_ID;
38
39 /*srw.message('004','Organization Hierarchy = '||cp_organization_hierarchy_name);*/null;
40
41
42 hr_head_count_summary.populate_summary_table(
43 P_BUSINESS_GROUP_ID,
44 P_TOP_ORGANIZATION_ID,
45 P_ORGANIZATION_STRUCTURE_ID,
46 P_BUDGET,
47 P_ROLL_UP,
48 P_INCLUDE_TOP_ORG,
49 P_REPORT_DATE_FROM,
50 P_REPORT_DATE_TO,
51 P_REPORT_DATE,
52 P_INCLUDE_ASG_TYPE,
53 P_JOB_CATEGORY => 'RG');
54
55 /*srw.message('005','End of Before Report Trigger');*/null;
56
57
58 return (TRUE);
59 end;
60
61 function AfterReport return boolean is
62 begin
63
64 -- hr_standard.event('AFTER REPORT');
65
66 return (TRUE);
67 end;
68
69 --Functions to refer Oracle report placeholders--
70
71 Function CP_BUSINESS_GROUP_NAME_p return varchar2 is
72 Begin
73 return CP_BUSINESS_GROUP_NAME;
74 END;
75 Function CP_ORGANIZATION_NAME_p return varchar2 is
76 Begin
77 return CP_ORGANIZATION_NAME;
78 END;
79 Function CP_TOP_ORG_NAME_p return varchar2 is
80 Begin
81 return CP_TOP_ORG_NAME;
82 END;
83 Function CP_ORGANIZATION_HIERARCHY_NAM return varchar2 is
84 Begin
85 return CP_ORGANIZATION_HIERARCHY_NAME;
86 END;
87 END PER_PERHDSUM_XMLP_PKG ;