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