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_PERRPFP2_XMLP_PKG

Source


1 PACKAGE PER_PERRPFP2_XMLP_PKG AS
2 /* $Header: PERRPFP2S.pls 120.2 2008/05/15 10:06:56 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 	C_BUSINESS_GROUP_NAME	varchar2(240);
17 	--C_details	varchar2(900) := := 'ADD1.ADDRESS_LINE1' ;
18           C_details	varchar2(900) :=  'ADD1.ADDRESS_LINE1' ;
19 	--C_cont_details	varchar2(240) := := 'ADD1.ADDRESS_LINE1' ;
20           C_cont_details	varchar2(240) :=  'ADD1.ADDRESS_LINE1' ;
21 	C_requirement_desc	varchar2(240);
22 	C_requirement_value	varchar2(240);
23 	C_header_name	varchar2(350);
24 	C_pay_meth_count	number;
25 	--C_emp_df_details	varchar2(2000) := := 'peo.ATTRIBUTE1' ;
26 	  C_emp_df_details	varchar2(2000) :=  'peo.ATTRIBUTE1' ;
27 	--C_emp_leg_df_details	varchar2(2000) := := 'pp.per_information1' ;
28 	  C_emp_leg_df_details	varchar2(2000) :=  'pp.per_information1' ;
29 	--C_add_df_details	varchar2(2000) := := 'addr.ADDR_ATTRIBUTE1' ;
30 	C_add_df_details	varchar2(2000) :=  'addr.ADDR_ATTRIBUTE1' ;
31 	--C_cont_df_details	varchar2(2000) := := 'con.cont_attribute1' ;
32 	  C_cont_df_details	varchar2(2000) :=  'con.cont_attribute1' ;
33 	--C_app_df_details	varchar2(32000) := := 'rpad(app.APPL_ATTRIBUTE1,32000,' ')' ;
34 	  C_app_df_details	varchar2(32000) := 'rpad(app.APPL_ATTRIBUTE1,32000,'' '')' ;
35           c_app_ass_df_details	varchar2(32000) := 'rpad(as'||'g.ass_attribute1,32000,'' '')' ;
36 	--C_sec_ass_df_details	varchar2(2000) := := 'sst.attribute1' ;
37 	  C_sec_ass_df_details	varchar2(2000) :=  'sst.attribute1' ;
38 	--C_per_serv_df_details	varchar2(4000) := := 'A.ATTRIBUTE1' ;
39 	  C_per_serv_df_details	varchar2(4000) :=  'A.ATTRIBUTE1' ;
40 	--C_temp	varchar2(240) := := 'got nothing mate' ;
41 	  C_temp	varchar2(240) :=  'got nothing mate' ;
42 	C_add_df_label	varchar2(600);
43 	C_emp_df_label	varchar2(600);
44 	C_emp_leg_df_label	varchar2(600);
45 	C_cont_df_label	varchar2(600);
46 	--C_app_df_label	varchar2(32000) := := 'rpad(' ',4000)' ;
47 	  C_app_df_label	varchar2(32000) :=  'rpad('' '',4000)' ;
48 	--C_app_ass_df_label	varchar2(32000) := := 'rpad(' ',4000)' ;
49 	  C_app_ass_df_label	varchar2(32000) :=  'rpad('' '',4000) ';
50 	--C_app_sec_status_details	varchar2(32000) := := 'rpad(sst.attribute1,32000,' ')' ;
51 	  C_app_sec_status_details	varchar2(32000) :=  'rpad(sst.attribute1,32000,'' '')' ;
52 	--C_app_sec_status_label	varchar2(32000) := := '''' ;
53 	  C_app_sec_status_label	varchar2(32000) :=  '''''' ;
54 	--C_inter_df_details	varchar2(32000) := := 'rpad(a.attribute1,32000,' ')' ;
55 	  C_inter_df_details	varchar2(32000) :=  'rpad(a.attribute1,32000,'' '')';
56 	--C_inter_df_label	varchar2(32000) := := 'rpad(' ',4000)' ;
57 	  C_inter_df_label	varchar2(32000) :=  'rpad('' '',4000)' ;
58 	--C_sec_ass_df_label	varchar2(10000) := := '''' ;
59 	  C_sec_ass_df_label	varchar2(10000) :=  '''''' ;
60 	--C_ass_df_details	varchar2(2000) := := 'asg.ass_attribute1' ;
61 	  C_ass_df_details	varchar2(2000) :=  'as'||'g.ass_attribute1' ;
62 	C_ass_df_label	varchar2(600);
63 	--C_fur_info_df_details	varchar2(2000) := := 'f.aei_attribute1' ;
64 	  C_fur_info_df_details	varchar2(2000) :=  'f.aei_attribute1' ;
65 	C_fur_info_df_label	varchar2(600);
66 	--C_fur_info_ddf_details	varchar2(2000) := := 'f.aei_information1' ;
67 	  C_fur_info_ddf_details	varchar2(2000) :=  'f.aei_information1' ;
68 	C_fur_info_ddf_label	varchar2(600);
69 	C_cost_id_flex_num	number;
70 	C_scl_id_flex_num	number;
71 	C_scl_desc	varchar2(240);
72 	C_scl_value	varchar2(240);
73 	C_cost_desc	varchar2(240);
74 	C_cost_values	varchar2(240);
75 	--C_ppm_df_details	varchar2(2000) := := 'ppm.attribute1' ;
76 	  C_ppm_df_details	varchar2(2000) :=  'ppm.attribute1' ;
77 	C_ppm_df_label	varchar2(600);
78 	C_ext_act_desc	varchar2(600);
79 	C_ext_act_values	varchar2(600);
80 	--C_ele_df_details	varchar2(2000) := := 'ee.attribute1' ;
81 	  C_ele_df_details	varchar2(2000) :=  'ee.attribute1' ;
82 	C_ele_df_label	varchar2(600);
83 	C_ele_cost_desc	varchar2(240);
84 	C_ele_cost_values	varchar2(240);
85 	--C_event_df_details	varchar2(2000) := := 'a.attribute1' ;
86 	  C_event_df_details	varchar2(2000) :=  'a.attribute1' ;
87 	C_event_df_label	varchar2(600);
88 	--C_book_df_details	varchar2(2000) := := 'b.attribute1' ;
89 	  C_book_df_details	varchar2(2000) :=  'b.attribute1' ;
90 	C_book_df_label	varchar2(600);
91 	--C_special_df_details	varchar2(2000) := := 'jr.attribute1' ;
92 	  C_special_df_details	varchar2(2000) :=  'jr.attribute1' ;
93 	C_special_df_label	varchar2(600);
94 	C_per_serv_df_label	varchar2(4000);
95 	--C_absence_df_details	varchar2(2000) := := 'a.attribute1' ;
96 	  C_absence_df_details	varchar2(2000) :=  'a.attribute1' ;
97 	C_absence_df_label	varchar2(600);
98 	--C_subtitle	varchar2(60) := := 'Full Applicant Details' ;
99 	  C_subtitle	varchar2(60) :=  'Full Applicant Details' ;
100 	C_END_OF_TIME	varchar2(60);
101 	function BeforeReport return boolean  ;
102 	function AfterReport return boolean  ;
103 	Function C_BUSINESS_GROUP_NAME_p return varchar2;
104 	Function C_details_p return varchar2;
105 	Function C_cont_details_p return varchar2;
106 	Function C_requirement_desc_p return varchar2;
107 	Function C_requirement_value_p return varchar2;
108 	Function C_header_name_p return varchar2;
109 	Function C_pay_meth_count_p return number;
110 	Function C_emp_df_details_p return varchar2;
111 	Function C_emp_leg_df_details_p return varchar2;
112 	Function C_add_df_details_p return varchar2;
113 	Function C_cont_df_details_p return varchar2;
114 	Function C_app_df_details_p return varchar2;
115 	Function c_app_ass_df_details_p return varchar2;
116 	Function C_sec_ass_df_details_p return varchar2;
117 	Function C_per_serv_df_details_p return varchar2;
118 	Function C_temp_p return varchar2;
119 	Function C_add_df_label_p return varchar2;
120 	Function C_emp_df_label_p return varchar2;
121 	Function C_emp_leg_df_label_p return varchar2;
122 	Function C_cont_df_label_p return varchar2;
123 	Function C_app_df_label_p return varchar2;
124 	Function C_app_ass_df_label_p return varchar2;
125 	Function C_app_sec_status_details_p return varchar2;
126 	Function C_app_sec_status_label_p return varchar2;
127 	Function C_inter_df_details_p return varchar2;
128 	Function C_inter_df_label_p return varchar2;
129 	Function C_sec_ass_df_label_p return varchar2;
130 	Function C_ass_df_details_p return varchar2;
131 	Function C_ass_df_label_p return varchar2;
132 	Function C_fur_info_df_details_p return varchar2;
133 	Function C_fur_info_df_label_p return varchar2;
134 	Function C_fur_info_ddf_details_p return varchar2;
135 	Function C_fur_info_ddf_label_p return varchar2;
136 	Function C_cost_id_flex_num_p return number;
137 	Function C_scl_id_flex_num_p return number;
138 	Function C_scl_desc_p return varchar2;
139 	Function C_scl_value_p return varchar2;
140 	Function C_cost_desc_p return varchar2;
141 	Function C_cost_values_p return varchar2;
142 	Function C_ppm_df_details_p return varchar2;
143 	Function C_ppm_df_label_p return varchar2;
144 	Function C_ext_act_desc_p return varchar2;
145 	Function C_ext_act_values_p return varchar2;
146 	Function C_ele_df_details_p return varchar2;
147 	Function C_ele_df_label_p return varchar2;
148 	Function C_ele_cost_desc_p return varchar2;
149 	Function C_ele_cost_values_p return varchar2;
150 	Function C_event_df_details_p return varchar2;
151 	Function C_event_df_label_p return varchar2;
152 	Function C_book_df_details_p return varchar2;
153 	Function C_book_df_label_p return varchar2;
154 	Function C_special_df_details_p return varchar2;
155 	Function C_special_df_label_p return varchar2;
156 	Function C_per_serv_df_label_p return varchar2;
157 	Function C_absence_df_details_p return varchar2;
158 	Function C_absence_df_label_p return varchar2;
159 	Function C_subtitle_p return varchar2;
160 	Function C_END_OF_TIME_p return varchar2;
161 	function M_4FormatTrigger return number;
162 	function M_5FormatTrigger return number;
163 END PER_PERRPFP2_XMLP_PKG;