[Home] [Help]
PACKAGE: APPS.BEN_BENERPER_XMLP_PKG
Source
1 PACKAGE BEN_BENERPER_XMLP_PKG AS
2 /* $Header: BENERPERS.pls 120.1 2007/12/10 08:31:58 vjaganat noship $ */
3 run_mode varchar2(100);
4 P_CONCURRENT_REQUEST_ID number;
5 P_SUB_TITLE varchar2(60);
6 P_CONC_REQUEST_ID number;
7 CP_PROCESS_DATE varchar2(30);
8 CP_DERIVABLE_FACTORS varchar2(80);
9 CP_VALIDATE varchar2(240);
10 CP_PERSON varchar2(270);
11 CP_PERSON_TYPE varchar2(240);
12 CP_PROGRAM varchar2(240);
13 CP_BUSINESS_GROUP varchar2(240);
14 CP_PLAN varchar2(240);
15 CP_ENROLLMENT_TYPE_CYCLE varchar2(800);
16 CP_PLANS_NOT_IN_PROGRAMS varchar2(240);
17 CP_JUST_PROGRAMS varchar2(240);
18 CP_COMP_OBJECT_SELECTION_RULE varchar2(240);
19 CP_PERSON_SELECTION_RULE varchar2(240);
20 CP_LIFE_EVENT_REASON varchar2(240);
21 CP_ORGANIZATION varchar2(240);
22 CP_POSTAL_ZIP_RANGE varchar2(80);
23 CP_REPORTING_GROUP varchar2(240);
24 CP_PLAN_TYPE varchar2(240);
25 CP_OPTION varchar2(240);
26 CP_ELIGIBILITY_PROFILE varchar2(240);
27 CP_VARIABLE_RATE_PROFILE varchar2(270);
28 CP_LEGAL_ENTITY varchar2(240);
29 CP_PAYROLL varchar2(240);
30 CP_CONCURRENT_PROGRAM_NAME varchar2(270);
31 CP_MODE varchar2(90);
32 CP_STATUS varchar2(240);
33 CP_START_DATE varchar2(30);
34 CP_END_DATE varchar2(30);
35 CP_START_TIME varchar2(30);
36 CP_END_TIME varchar2(30);
37 CP_ELAPSED_TIME varchar2(30);
38 CP_PERSONS_SELECTED number;
39 CP_PERSONS_PROCESSED number;
40 CP_PERSONS_ERRORED number;
41 CP_PERSONS_UNPROCESSED number;
42 CP_PERSONS_PROCESSED_SUCC number;
43 CD_01 varchar2(80);
44 CD_02 varchar2(80);
45 CD_03 varchar2(80);
46 CD_04 varchar2(80);
47 CD_05 varchar2(80);
48 CD_06 varchar2(80);
49 CD_07 varchar2(80);
50 CD_08 varchar2(80);
51 CD_09 varchar2(80);
52 CD_10 varchar2(80);
53 CD_11 varchar2(80);
54 CD_12 varchar2(80);
55 CD_13 varchar2(80);
56 CD_14 varchar2(80);
57 CD_15 varchar2(80);
58 CD_16 varchar2(80);
59 CD_17 varchar2(80);
60 CD_18 varchar2(80);
61 CD_19 varchar2(80);
62 CD_20 varchar2(80);
63 CV_01 varchar2(240);
64 CV_02 varchar2(240);
65 CV_03 varchar2(240);
66 CV_04 varchar2(240);
67 CV_05 varchar2(240);
68 CV_06 varchar2(240);
69 CV_07 varchar2(240);
70 CV_08 varchar2(240);
71 CV_09 varchar2(240);
72 CV_10 varchar2(240);
73 CV_11 varchar2(240);
74 CV_12 varchar2(240);
75 CV_13 varchar2(240);
76 CV_14 varchar2(240);
77 CV_15 varchar2(240);
78 CV_16 varchar2(240);
79 CV_17 varchar2(240);
80 CV_18 varchar2(240);
81 CV_19 varchar2(240);
82 CV_20 varchar2(240);
83 CP_DEBUG_MESSAGE varchar2(240);
84 CP_LOCATION varchar2(240);
85 CP_AUDIT_LOG varchar2(240);
86 CP_BENFT_GROUP varchar2(240);
87 CP_1 varchar2(272);
88 CP_FROM_OCRD_DT varchar2(30);
89 CP_TO_OCRD_DT varchar2(30);
90 CP_BCKT_STAT_CD varchar2(30);
91 function CF_STANDARD_HEADERFormula return Number ;
92 function CF_1Formula return Number ;
93 FUNCTION Get_val (p_cd varchar2) RETURN varchar2 ;
94 function BeforePForm return boolean ;
95 function AfterPForm return boolean ;
96 function BeforeReport return boolean ;
97 function AfterReport return boolean ;
98 Function CP_PROCESS_DATE_p return varchar2;
99 Function CP_DERIVABLE_FACTORS_p return varchar2;
100 Function CP_VALIDATE_p return varchar2;
101 Function CP_PERSON_p return varchar2;
102 Function CP_PERSON_TYPE_p return varchar2;
103 Function CP_PROGRAM_p return varchar2;
104 Function CP_BUSINESS_GROUP_p return varchar2;
105 Function CP_PLAN_p return varchar2;
106 Function CP_ENROLLMENT_TYPE_CYCLE_p return varchar2;
107 Function CP_PLANS_NOT_IN_PROGRAMS_p return varchar2;
108 Function CP_JUST_PROGRAMS_p return varchar2;
109 Function CP_COMP_OBJECT_SELECTION_RULE1 return varchar2;
110 Function CP_PERSON_SELECTION_RULE_p return varchar2;
111 Function CP_LIFE_EVENT_REASON_p return varchar2;
112 Function CP_ORGANIZATION_p return varchar2;
113 Function CP_POSTAL_ZIP_RANGE_p return varchar2;
114 Function CP_REPORTING_GROUP_p return varchar2;
115 Function CP_PLAN_TYPE_p return varchar2;
116 Function CP_OPTION_p return varchar2;
117 Function CP_ELIGIBILITY_PROFILE_p return varchar2;
118 Function CP_VARIABLE_RATE_PROFILE_p return varchar2;
119 Function CP_LEGAL_ENTITY_p return varchar2;
120 Function CP_PAYROLL_p return varchar2;
121 Function CP_CONCURRENT_PROGRAM_NAME_p return varchar2;
122 Function CP_MODE_p return varchar2;
123 Function CP_STATUS_p return varchar2;
124 Function CP_START_DATE_p return varchar2;
125 Function CP_END_DATE_p return varchar2;
126 Function CP_START_TIME_p return varchar2;
127 Function CP_END_TIME_p return varchar2;
128 Function CP_ELAPSED_TIME_p return varchar2;
129 Function CP_PERSONS_SELECTED_p return number;
130 Function CP_PERSONS_PROCESSED_p return number;
131 Function CP_PERSONS_ERRORED_p return number;
132 Function CP_PERSONS_UNPROCESSED_p return number;
133 Function CP_PERSONS_PROCESSED_SUCC_p return number;
134 Function CD_01_p return varchar2;
135 Function CD_02_p return varchar2;
136 Function CD_03_p return varchar2;
137 Function CD_04_p return varchar2;
138 Function CD_05_p return varchar2;
139 Function CD_06_p return varchar2;
140 Function CD_07_p return varchar2;
141 Function CD_08_p return varchar2;
142 Function CD_09_p return varchar2;
143 Function CD_10_p return varchar2;
144 Function CD_11_p return varchar2;
145 Function CD_12_p return varchar2;
146 Function CD_13_p return varchar2;
147 Function CD_14_p return varchar2;
148 Function CD_15_p return varchar2;
149 Function CD_16_p return varchar2;
150 Function CD_17_p return varchar2;
151 Function CD_18_p return varchar2;
152 Function CD_19_p return varchar2;
153 Function CD_20_p return varchar2;
154 Function CV_01_p return varchar2;
155 Function CV_02_p return varchar2;
156 Function CV_03_p return varchar2;
157 Function CV_04_p return varchar2;
158 Function CV_05_p return varchar2;
159 Function CV_06_p return varchar2;
160 Function CV_07_p return varchar2;
161 Function CV_08_p return varchar2;
162 Function CV_09_p return varchar2;
163 Function CV_10_p return varchar2;
164 Function CV_11_p return varchar2;
165 Function CV_12_p return varchar2;
166 Function CV_13_p return varchar2;
167 Function CV_14_p return varchar2;
168 Function CV_15_p return varchar2;
169 Function CV_16_p return varchar2;
170 Function CV_17_p return varchar2;
171 Function CV_18_p return varchar2;
172 Function CV_19_p return varchar2;
173 Function CV_20_p return varchar2;
174 Function CP_DEBUG_MESSAGE_p return varchar2;
175 Function CP_LOCATION_p return varchar2;
176 Function CP_AUDIT_LOG_p return varchar2;
177 Function CP_BENFT_GROUP_p return varchar2;
178 Function CP_1_p return varchar2;
179 Function CP_FROM_OCRD_DT_p return varchar2;
180 Function CP_TO_OCRD_DT_p return varchar2;
181 Function CP_BCKT_STAT_CD_p return varchar2;
182 END BEN_BENERPER_XMLP_PKG;