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.BEN_BENACTIV_XMLP_PKG

Source


1 PACKAGE BEN_BENACTIV_XMLP_PKG AS
2 /* $Header: BENACTIVS.pls 120.1 2007/12/10 08:23:05 vjaganat noship $ */
3   	run_mode varchar2(1000);
4 	P_CONCURRENT_REQUEST_ID	number;
5 	P_CONC_REQUEST_ID	number;
6 	CP_PROCESS_DATE	varchar2(1000);
7 	CP_DERIVABLE_FACTORS	varchar2(1000);
8 	CP_VALIDATE	varchar2(1000);
9 	CP_PERSON	varchar2(1000);
10 	CP_PERSON_TYPE	varchar2(1000);
11 	CP_PROGRAM	varchar2(1000);
12 	CP_BUSINESS_GROUP	varchar2(1000);
13 	CP_PLAN	varchar2(1000);
14 	CP_ENROLLMENT_TYPE_CYCLE	varchar2(1000);
15 	CP_PLANS_NOT_IN_PROGRAMS	varchar2(1000);
16 	CP_JUST_PROGRAMS	varchar2(1000);
17 	CP_COMP_OBJECT_SELECTION_RULE	varchar2(1000);
18 	CP_PERSON_SELECTION_RULE	varchar2(1000);
19 	CP_LIFE_EVENT_REASON	varchar2(1000);
20 	CP_ORGANIZATION	varchar2(1000);
21 	CP_POSTAL_ZIP_RANGE	varchar2(1000);
22 	CP_REPORTING_GROUP	varchar2(1000);
23 	CP_PLAN_TYPE	varchar2(1000);
24 	CP_OPTION	varchar2(1000);
25 	CP_ELIGIBILITY_PROFILE	varchar2(1000);
26 	CP_VARIABLE_RATE_PROFILE	varchar2(1000);
27 	CP_LEGAL_ENTITY	varchar2(1000);
28 	CP_PAYROLL	varchar2(1000);
29 	CP_CONCURRENT_PROGRAM_NAME	varchar2(1000);
30 	CP_START_DATE	varchar2(1000);
31 	CP_END_DATE	varchar2(1000);
32 	CP_ELAPSED_TIME	varchar2(1000);
33 	CP_PERSONS_SELECTED	number;
34 	CP_PERSONS_PROCESSED	number;
35 	CP_MODE	varchar2(1000);
36 	CP_WITHOUT_ACTIVE_LIFE_EVENT	number;
37 	CP_WITH_ACTIVE_LIFE_EVENT	number;
38 	CP_END_TIME	varchar2(1000);
39 	CP_START_TIME	varchar2(1000);
40 	CP_STATUS	varchar2(1000);
41 	CP_PERSONS_ERRORED	number;
42 	CP_PERSONS_PROCESSED_SUCC	number;
43 	CP_PERSONS_UNPROCESSED	number;
44 	CP_NO_LIFE_EVENT_CREATED	number;
45 	CP_LIFE_EVENT_OPEN_AND_CLOSED	number;
46 	CP_LIFE_EVENT_STILL_ACTIVE	number;
47 	CP_LIFE_EVENT_REPLACED	number;
48 	CP_LIFE_EVENT_CREATED	number;
49 	CP_LIFE_EVENT_CLOSED	number;
50 	CP_TOTAL_CLOSED	number;
51 	CP_AGE_CHANGED	varchar2(1000);
52 	CP_LOS_CHANGED	varchar2(1000);
53 	CP_COMB_AGE_LOS_CHANGED	varchar2(1000);
54 	CP_PFT_CHANGED	varchar2(1000);
55 	CP_COMP_LVL_CHANGED	varchar2(1000);
56 	CP_HRS_WKD_CHANGED	varchar2(1000);
57 	CP_PERSONS_NO_POTENTIAL	varchar2(20);
58 	CP_PERSONS_WITH_POTENTIAL	varchar2(1000);
59 	CP_NUMBER_OF_EVENTS_CREATED	varchar2(30);
60 	CP_LIFE_EVENT_DSGN_ONLY	number;
61 	CP_LIFE_EVENT_CHOICES	number;
62 	CP_LIFE_EVENT_NO_EFFECT	number;
63 	CP_LIFE_EVENT_RT_PR_CHG	number;
64 	CP_NO_CHANGE_TO_LIFE	number;
65 	CP_CR_OPN_CLS	number;
66 	CP_LIFE_EVENT_COLLAPSED	number;
67 	CP_LIFE_EVENT_COLLISION	number;
68 	CP_LOCATION	varchar2(60);
69 	CP_PERSON_BNFT_GRP	varchar2(240);
70 	CP_AUDIT_FLAG	varchar2(3);
71 	CP_LMT_BY_ORG_FLAG	varchar2(3);
72 	CP_LOSS_OF_ELIGIBILITY	varchar2(1000);
73 	CP_late_payment	varchar2(1000);
74 	CP_max_enrollment_rchd	varchar2(1000);
75 	CP_period_enroll_changed	varchar2(1000);
76 	CP_voulntary_end_cvg	varchar2(1000);
77 	CP_waiting_satisfied	varchar2(1000);
78 	function CF_STANDARD_HEADERFormula return Number  ;
79 	function CF_SUMMARY_EVENTFormula return Number  ;
80 	function CF_1Formula return Number  ;
81 	function CF_TEMPORAL_LIFE_EVENTSFormula return Number  ;
82 	function BeforeReport return boolean  ;
83 	function AfterReport return boolean  ;
84 	function AfterPForm return boolean  ;
85 	Function CP_PROCESS_DATE_p return varchar2;
86 	Function CP_DERIVABLE_FACTORS_p return varchar2;
87 	Function CP_VALIDATE_p return varchar2;
88 	Function CP_PERSON_p return varchar2;
89 	Function CP_PERSON_TYPE_p return varchar2;
90 	Function CP_PROGRAM_p return varchar2;
91 	Function CP_BUSINESS_GROUP_p return varchar2;
92 	Function CP_PLAN_p return varchar2;
93 	Function CP_ENROLLMENT_TYPE_CYCLE_p return varchar2;
94 	Function CP_PLANS_NOT_IN_PROGRAMS_p return varchar2;
95 	Function CP_JUST_PROGRAMS_p return varchar2;
96 	Function CP_COMP_OBJECT_SELECTION_RULE1 return varchar2;
97 	Function CP_PERSON_SELECTION_RULE_p return varchar2;
98 	Function CP_LIFE_EVENT_REASON_p return varchar2;
99 	Function CP_ORGANIZATION_p return varchar2;
100 	Function CP_POSTAL_ZIP_RANGE_p return varchar2;
101 	Function CP_REPORTING_GROUP_p return varchar2;
102 	Function CP_PLAN_TYPE_p return varchar2;
103 	Function CP_OPTION_p return varchar2;
104 	Function CP_ELIGIBILITY_PROFILE_p return varchar2;
105 	Function CP_VARIABLE_RATE_PROFILE_p return varchar2;
106 	Function CP_LEGAL_ENTITY_p return varchar2;
107 	Function CP_PAYROLL_p return varchar2;
108 	Function CP_CONCURRENT_PROGRAM_NAME_p return varchar2;
109 	Function CP_START_DATE_p return varchar2;
110 	Function CP_END_DATE_p return varchar2;
111 	Function CP_ELAPSED_TIME_p return varchar2;
112 	Function CP_PERSONS_SELECTED_p return number;
113 	Function CP_PERSONS_PROCESSED_p return number;
114 	Function CP_MODE_p return varchar2;
115 	Function CP_WITHOUT_ACTIVE_LIFE_EVENT_p return number;
116 	Function CP_WITH_ACTIVE_LIFE_EVENT_p return number;
117 	Function CP_END_TIME_p return varchar2;
118 	Function CP_START_TIME_p return varchar2;
119 	Function CP_STATUS_p return varchar2;
120 	Function CP_PERSONS_ERRORED_p return number;
121 	Function CP_PERSONS_PROCESSED_SUCC_p return number;
122 	Function CP_PERSONS_UNPROCESSED_p return number;
123 	Function CP_NO_LIFE_EVENT_CREATED_p return number;
124 	Function CP_LIFE_EVENT_OPEN_AND_CLOSED1 return number;
125 	Function CP_LIFE_EVENT_STILL_ACTIVE_p return number;
126 	Function CP_LIFE_EVENT_REPLACED_p return number;
127 	Function CP_LIFE_EVENT_CREATED_p return number;
128 	Function CP_LIFE_EVENT_CLOSED_p return number;
129 	Function CP_TOTAL_CLOSED_p return number;
130 	Function CP_AGE_CHANGED_p return varchar2;
131 	Function CP_LOS_CHANGED_p return varchar2;
132 	Function CP_COMB_AGE_LOS_CHANGED_p return varchar2;
133 	Function CP_PFT_CHANGED_p return varchar2;
134 	Function CP_COMP_LVL_CHANGED_p return varchar2;
135 	Function CP_HRS_WKD_CHANGED_p return varchar2;
136 	Function CP_PERSONS_NO_POTENTIAL_p return varchar2;
137 	Function CP_PERSONS_WITH_POTENTIAL_p return varchar2;
138 	Function CP_NUMBER_OF_EVENTS_CREATED_p return varchar2;
139 	Function CP_LIFE_EVENT_DSGN_ONLY_p return number;
140 	Function CP_LIFE_EVENT_CHOICES_p return number;
141 	Function CP_LIFE_EVENT_NO_EFFECT_p return number;
142 	Function CP_LIFE_EVENT_RT_PR_CHG_p return number;
143 	Function CP_NO_CHANGE_TO_LIFE_p return number;
144 	Function CP_CR_OPN_CLS_p return number;
145 	Function CP_LIFE_EVENT_COLLAPSED_p return number;
146 	Function CP_LIFE_EVENT_COLLISION_p return number;
147 	Function CP_LOCATION_p return varchar2;
148 	Function CP_PERSON_BNFT_GRP_p return varchar2;
149 	Function CP_AUDIT_FLAG_p return varchar2;
150 	Function CP_LMT_BY_ORG_FLAG_p return varchar2;
151 	Function CP_LOSS_OF_ELIGIBILITY_p return varchar2;
152 	Function CP_late_payment_p return varchar2;
153 	Function CP_max_enrollment_rchd_p return varchar2;
154 	Function CP_period_enroll_changed_p return varchar2;
155 	Function CP_voulntary_end_cvg_p return varchar2;
156 	Function CP_waiting_satisfied_p return varchar2;
157 END BEN_BENACTIV_XMLP_PKG;