[Home] [Help]
PACKAGE BODY: APPS.PQH_PQIPED1_XMLP_PKG
Source
1 PACKAGE BODY PQH_PQIPED1_XMLP_PKG AS
2 /* $Header: PQIPED1B.pls 120.1 2007/12/21 17:23:33 vjaganat noship $ */
3
4 function lineFormula return Number is
5 temp_num number;
6 begin
7 temp_num := line_num;
8 line_num:= line_num + 1;
9 if (line_num = 12) then
10 line_num := 14;
11 end if;
12 return temp_num;
13 end;
14
15 function CF_TotTitleFormula(orgCode in varchar2) return Char is
16 l_total_title VARCHAR2(200) := '';
17 l_org_code VARCHAR2(9) := orgCode;
18 begin
19 IF l_org_code = 'MED' THEN
20 l_total_title := '24 Total Medical Only';
21 ELSIF l_org_code = 'NON-MED' THEN
22 l_total_title := '12 Total Non-Medical';
23 END IF;
24
25 return l_total_title;
26
27 end;
28
29 function CF_dispNameFormula(orgCode in varchar2) return Char is
30 l_disp_title VARCHAR2(200) := '';
31 l_org_code VARCHAR2(9) := orgCode;
32 begin
33 IF l_org_code = 'MED' THEN
34 l_disp_title := '13 Instruction Combined with Research and/or Public Service';
35 ELSIF l_org_code = 'NON-MED' THEN
36 l_disp_title := '1 Instruction Combined with Research and/or Public Service';
37 END IF;
38
39 return l_disp_title;
40
41 end;
42
43 function BeforePForm return boolean is
44 begin
45
46 return (TRUE);
47 end;
48
49 function BeforeReport return boolean is
50 l_query_text varchar2(2000);
51 l_fr varchar2(2000);
52 l_ft varchar2(2000);
53 l_pr varchar2(2000);
54 l_pt varchar2(2000);
55
56
57 begin
58 P_REPORT_DATE_T := to_char(P_REPORT_DATE,'DD-MON-YYYY');
59 --hr_standard.event('BEFORE REPORT');
60
61 pqh_employment_category.fetch_empl_categories(p_business_group_id,l_fr,l_ft,l_pr,l_pt);
62
63 cp_fr := l_fr;
64 cp_ft := l_ft;
65 cp_pr := l_pr;
66 cp_pt := l_pt;
67
68
69 return TRUE;
70 end;
71
72 function cf_sumfacultyformula(SumFacultyTenured in number, SumFacultyOnTenure in number, SumFacultyNotOnTenure in number) return number is
73 begin
74 return (SumFacultyTenured + SumFacultyOnTenure + SumFacultyNotOnTenure);
75 end;
76
77 function AfterReport return boolean is
78 begin
79 --hr_standard.event('AFTER REPORT');
80 return (TRUE);
81 end;
82
83 --Functions to refer Oracle report placeholders--
84
85 Function line_num_p return number is
86 Begin
87 return line_num;
88 END;
89 Function CP_FT_p return varchar2 is
90 Begin
91 return CP_FT;
92 END;
93 Function CP_FR_p return varchar2 is
94 Begin
95 return CP_FR;
96 END;
97 Function CP_PT_p return varchar2 is
98 Begin
99 return CP_PT;
100 END;
101 Function CP_pr_p return varchar2 is
102 Begin
103 return CP_pr;
104 END;
105 END PQH_PQIPED1_XMLP_PKG ;