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 ;