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.
PACKAGE: APPS.PER_PERRPFP1_XMLP_PKG

Source


1 PACKAGE PER_PERRPFP1_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: PERRPFP1S.pls 120.1 2007/12/06 11:28:33 amakrish noship $ */
3 	P_BUSINESS_GROUP_ID	number;
4 	P_SESSION_DATE1 varchar2(240);
5 	P_SESSION_DATE	date;
6 	P_CONC_REQUEST_ID	number;
7 	P_person_id	number;
8 	--P_SPECIAL_INFO_SEGS	varchar2(240);
9 	P_SPECIAL_INFO_SEGS	varchar2(240) := 'lpad('' '',240)';
10 	--P_ass_scl_segs	varchar2(240);
11 	P_ass_scl_segs	varchar2(240) := 'lpad('' '',240)';
12 	--P_ass_cost_segs	varchar2(240);
13 	P_ass_cost_segs	varchar2(240) := 'lpad('' '',240)';
14 	--P_EXT_ACT_SEGS	varchar2(240);
15 	P_EXT_ACT_SEGS	varchar2(240) := 'lpad('' '',240)';
16 	P_town_of_birth	varchar2(60);
17 	P_region_of_birth	varchar2(60);
18 	C_address1	varchar2(240);
19 	C_address2	varchar2(240);
20 	C_address3	varchar2(240);
21 	C_address4	varchar2(240);
22 	C_address5	varchar2(240);
23 	C_address6	varchar2(240);
24 	C_address7	varchar2(240);
25 	C_address8	varchar2(240);
26 	C_address9	varchar2(240);
27 	C_address10	varchar2(240);
28 	C_address11	varchar2(240);
29 	C_address12	varchar2(240);
30 	C_address13	varchar2(240);
31 	C_address14	varchar2(240);
32 	C_address15	varchar2(240);
33 	C_address16	varchar2(240);
34 	C_address17	varchar2(240);
35 	C_address18	varchar2(240);
36 	C_address19	varchar2(240);
37 	C_address20	varchar2(240);
38 	C_BUSINESS_GROUP_NAME	varchar2(240);
39 	C_details	varchar2(2000) :=    'ADD1.ADDRESS_LINE1||''.''||ADD1.ADDRESS_LINE2||''.''||ADD1.ADDRESS_LINE3||''.''||ADD1.ADDRESS_LINE1||''.''||ADD1.ADDRESS_LINE2||''.''||ADD1.ADDRESS_LINE3||''.''||ADD1.ADDRESS_LINE1||''.''||
40 	ADD1.ADDRESS_LINE2||''.''||ADD1.ADDRESS_LINE3||''.''||ADD1.ADDRESS_LINE1||''.''||ADD1.ADDRESS_LINE2||''.''||ADD1.ADDRESS_LINE3||''.''||ADD1.ADDRESS_LINE1||''.''||ADD1.ADDRESS_LINE2||''.''||ADD1.ADDRESS_LINE3||''.''||
41 	ADD1.ADDRESS_LINE1||''.''||ADD1.ADDRESS_LINE2||''.''||ADD1.ADDRESS_LINE3||''.''||ADD1.ADDRESS_LINE1||''.''||ADD1.ADDRESS_LINE2||''.''||ADD1.ADDRESS_LINE3||''.''||ADD1.ADDRESS_LINE1||''.''||ADD1.ADDRESS_LINE2||''.''||
42 	ADD1.ADDRESS_LINE3||''.''||ADD1.ADDRESS_LINE1||''.''||ADD1.ADDRESS_LINE2||''.''||ADD1.ADDRESS_LINE3||''.''||ADD1.ADDRESS_LINE1||''.''||ADD1.ADDRESS_LINE2||''.''||ADD1.ADDRESS_LINE3||''.''||ADD1.ADDRESS_LINE1||''.''||
43 	ADD1.ADDRESS_LINE2||''.''||ADD1.ADDRESS_LINE3||''.''||ADD1.ADDRESS_LINE1||''.''||ADD1.ADDRESS_LINE2||''.''||ADD1.ADDRESS_LINE3||''.''||ADD1.ADDRESS_LINE1||''.''||ADD1.ADDRESS_LINE2||''.''||ADD1.ADDRESS_LINE3||''.''||
44 	ADD1.ADDRESS_LINE1||''.''||ADD1.ADDRESS_LINE2||''.''||ADD1.ADDRESS_LINE3' ;
45 --	 C_cont_details	varchar2(240) := := 'ADD1.ADDRESS_LINE1' ;
46         C_cont_details	varchar2(240) := 'ADD1.ADDRESS_LINE1' ;
47 	C_requirement_desc	varchar2(240);
48 	C_requirement_value	varchar2(240);
49 	C_header_name	varchar2(350);
50 	C_pay_meth_count	number;
51 --	 C_emp_df_details	varchar2(32000) := := 'rpad(peo.ATTRIBUTE1,32000,' ')' ;
52 C_emp_df_details	varchar2(32000) := 'rpad(peo.ATTRIBUTE1,32000,'' '')' ;
53 --	 C_emp_leg_df_details	varchar2(2000) := := 'rpad(pp.per_information1,2000,' ')' ;
54 C_emp_leg_df_details	varchar2(2000)  := 'rpad(pp.per_information1,2000,'' '')' ;
55 --	 C_add_df_details	varchar2(32000) := := rpad(addr.ADDR_ATTRIBUTE1,32000,' ')' ;
56 C_add_df_details	varchar2(32000) := 'rpad(addr.ADDR_ATTRIBUTE1,32000,'' '')' ;
57 --	 C_cont_df_details	varchar2(32000) := := 'rpad(con.cont_attribute1,32000,' ')' ;
58 C_cont_df_details	varchar2(32000) := 'rpad(con.cont_attribute1,32000,'' '')' ;
59 --	 C_app_df_details	varchar2(2000) := := 'app.APPL_ATTRIBUTE1' ;
60 C_app_df_details	varchar2(2000) := 'app.APPL_ATTRIBUTE1' ;
61 --	 c_app_ass_df_details	varchar2(400) := := 'asg.ass_attribute1' ;
62 c_app_ass_df_details	varchar2(400) := 'as'||'g.ass_attribute1' ;
63 --	 C_sec_ass_df_details	varchar2(600) := := 'sst.attribute1' ;
64 C_sec_ass_df_details	varchar2(600) := 'sst.attribute1' ;
65 --	 C_per_serv_df_details	varchar2(4000) := := 'A.ATTRIBUTE1' ;
66 C_per_serv_df_details	varchar2(4000) := 'A.ATTRIBUTE1' ;
67 --	 C_temp	varchar2(240) := := 'got nothing mate' ;
68 C_temp	varchar2(240) := 'got nothing mate' ;
69 --	 C_add_df_label	varchar2(32000) := := '''' ;
70 --C_add_df_label	varchar2(32000) := '''' ;
71 C_add_df_label	varchar2(32000) := '''''' ;
72 --	 C_emp_df_label	varchar2(32000) := := 'rpad(peo.ATTRIBUTE1,32000,' ')' ;
73 C_emp_df_label	varchar2(32000) := 'rpad(peo.ATTRIBUTE1,32000,'' '')' ;
74 	C_emp_leg_df_label	varchar2(2000);
75 --	 C_cont_df_label	varchar2(32000) := := '''' ;
76 --C_cont_df_label	varchar2(32000) := '''' ;
77 C_cont_df_label	varchar2(32000) := '''''' ;
78 	C_app_df_label	varchar2(600);
79 	C_app_ass_df_label	varchar2(600);
80 --	 C_app_sec_status_details	varchar2(600) := := 'sst.attribute1' ;
81 C_app_sec_status_details	varchar2(600) := 'sst.attribute1' ;
82 	C_app_sec_status_label	varchar2(600);
83 --	 C_inter_df_details	varchar2(600) := := 'a.attribute1' ;
84 C_inter_df_details	varchar2(600) := 'a.attribute1' ;
85 	C_inter_df_label	varchar2(600);
86 	C_sec_ass_df_label	varchar2(600);
87 --	 C_ass_df_details	varchar2(600) := := 'asg.ass_attribute1' ;
88 C_ass_df_details	varchar2(600) := 'as'||'g.ass_attribute1' ;
89 	C_ass_df_label	varchar2(600);
90 --	 C_fur_info_df_details	varchar2(32000) := := 'f.aei_attribute1' ;
91 C_fur_info_df_details	varchar2(32000) := 'f.aei_attribute1' ;
92 	C_fur_info_df_label	varchar2(32000);
93 --	 C_fur_info_ddf_details	varchar2(600) := := 'f.aei_information1' ;
94 C_fur_info_ddf_details	varchar2(600) := 'f.aei_information1' ;
95 	C_fur_info_ddf_label	varchar2(600);
96 	C_cost_id_flex_num	number;
97 	C_scl_id_flex_num	number;
98 	C_scl_desc	varchar2(240);
99 	C_scl_value	varchar2(240);
100 	C_cost_desc	varchar2(240);
101 	C_cost_values	varchar2(240);
102 --	 C_ppm_df_details	varchar2(600) := := 'ppm.attribute1' ;
103 C_ppm_df_details	varchar2(600) := 'ppm.attribute1' ;
104 	C_ppm_df_label	varchar2(600);
105 	C_ext_act_desc	varchar2(600);
106 	C_ext_act_values	varchar2(600);
107 --	 C_ele_df_details	varchar2(600) := := 'ee.attribute1' ;
108 C_ele_df_details	varchar2(600) := 'ee.attribute1' ;
109 	C_ele_df_label	varchar2(600);
110 	C_ele_cost_desc	varchar2(240);
111 	C_ele_cost_values	varchar2(240);
112 --	 C_event_df_details	varchar2(600) := := 'a.attribute1' ;
113 C_event_df_details	varchar2(600) := 'a.attribute1' ;
114 	C_event_df_label	varchar2(600);
115 --	 C_book_df_details	varchar2(600) := := 'b.attribute1' ;
116 C_book_df_details	varchar2(600) := 'b.attribute1' ;
117 	C_book_df_label	varchar2(600);
118 --	 C_special_df_details	varchar2(600) := := 'jr.attribute1' ;
119 C_special_df_details	varchar2(600) := 'jr.attribute1' ;
120 	C_special_df_label	varchar2(600);
121 	C_per_serv_df_label	varchar2(4000);
122 --	 C_absence_df_details	varchar2(600) := := 'a.attribute1' ;
123 C_absence_df_details	varchar2(600) := 'a.attribute1' ;
124 	C_absence_df_label	varchar2(600);
125 --	 C_SUBTITLE	varchar2(60) := := 'Full Person Details' ;
126 C_SUBTITLE	varchar2(60) := 'Full Person Details' ;
127 --	 C_details10	varchar2(900) := := 'add1.address_line1' ;
128 C_details10	varchar2(900) := 'add1.address_line1' ;
129 	C_END_OF_TIME	varchar2(900);
130 	function BeforeReport return boolean  ;
131 	function c_get_flexformula(style in varchar2) return number  ;
132 	function c_address_copyformula(conc_address in varchar2) return varchar2  ;
133 	function c_split_flexformula(c_address_copy in varchar2) return number  ;
134 	function c_get_emp_leg_dfformula(per_information_category in varchar2) return number  ;
135 	function AfterReport return boolean  ;
136 	Function C_address1_p return varchar2;
137 	Function C_address2_p return varchar2;
138 	Function C_address3_p return varchar2;
139 	Function C_address4_p return varchar2;
140 	Function C_address5_p return varchar2;
141 	Function C_address6_p return varchar2;
142 	Function C_address7_p return varchar2;
143 	Function C_address8_p return varchar2;
144 	Function C_address9_p return varchar2;
145 	Function C_address10_p return varchar2;
146 	Function C_address11_p return varchar2;
147 	Function C_address12_p return varchar2;
148 	Function C_address13_p return varchar2;
149 	Function C_address14_p return varchar2;
150 	Function C_address15_p return varchar2;
151 	Function C_address16_p return varchar2;
152 	Function C_address17_p return varchar2;
153 	Function C_address18_p return varchar2;
154 	Function C_address19_p return varchar2;
155 	Function C_address20_p return varchar2;
156 	Function C_BUSINESS_GROUP_NAME_p return varchar2;
157 	Function C_details_p return varchar2;
158 	Function C_cont_details_p return varchar2;
159 	Function C_requirement_desc_p return varchar2;
160 	Function C_requirement_value_p return varchar2;
161 	Function C_header_name_p return varchar2;
162 	Function C_pay_meth_count_p return number;
163 	Function C_emp_df_details_p return varchar2;
164 	Function C_emp_leg_df_details_p return varchar2;
165 	Function C_add_df_details_p return varchar2;
166 	Function C_cont_df_details_p return varchar2;
167 	Function C_app_df_details_p return varchar2;
168 	Function c_app_ass_df_details_p return varchar2;
169 	Function C_sec_ass_df_details_p return varchar2;
170 	Function C_per_serv_df_details_p return varchar2;
171 	Function C_temp_p return varchar2;
172 	Function C_add_df_label_p return varchar2;
173 	Function C_emp_df_label_p return varchar2;
174 	Function C_emp_leg_df_label_p return varchar2;
175 	Function C_cont_df_label_p return varchar2;
176 	Function C_app_df_label_p return varchar2;
177 	Function C_app_ass_df_label_p return varchar2;
178 	Function C_app_sec_status_details_p return varchar2;
179 	Function C_app_sec_status_label_p return varchar2;
180 	Function C_inter_df_details_p return varchar2;
181 	Function C_inter_df_label_p return varchar2;
182 	Function C_sec_ass_df_label_p return varchar2;
183 	Function C_ass_df_details_p return varchar2;
184 	Function C_ass_df_label_p return varchar2;
185 	Function C_fur_info_df_details_p return varchar2;
186 	Function C_fur_info_df_label_p return varchar2;
187 	Function C_fur_info_ddf_details_p return varchar2;
188 	Function C_fur_info_ddf_label_p return varchar2;
189 	Function C_cost_id_flex_num_p return number;
190 	Function C_scl_id_flex_num_p return number;
191 	Function C_scl_desc_p return varchar2;
192 	Function C_scl_value_p return varchar2;
193 	Function C_cost_desc_p return varchar2;
194 	Function C_cost_values_p return varchar2;
195 	Function C_ppm_df_details_p return varchar2;
196 	Function C_ppm_df_label_p return varchar2;
197 	Function C_ext_act_desc_p return varchar2;
198 	Function C_ext_act_values_p return varchar2;
199 	Function C_ele_df_details_p return varchar2;
200 	Function C_ele_df_label_p return varchar2;
201 	Function C_ele_cost_desc_p return varchar2;
202 	Function C_ele_cost_values_p return varchar2;
203 	Function C_event_df_details_p return varchar2;
204 	Function C_event_df_label_p return varchar2;
205 	Function C_book_df_details_p return varchar2;
206 	Function C_book_df_label_p return varchar2;
207 	Function C_special_df_details_p return varchar2;
208 	Function C_special_df_label_p return varchar2;
209 	Function C_per_serv_df_label_p return varchar2;
210 	Function C_absence_df_details_p return varchar2;
211 	Function C_absence_df_label_p return varchar2;
212 	Function C_SUBTITLE_p return varchar2;
213 	Function C_details10_p return varchar2;
214 	Function C_END_OF_TIME_p return varchar2;
215 
216 END PER_PERRPFP1_XMLP_PKG;