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