[Home] [Help]
PACKAGE: APPS.PER_PERRPFP1_XMLP_PKG
Source
1 PACKAGE PER_PERRPFP1_XMLP_PKG 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;