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