DBA Data[Home] [Help]

PACKAGE: APPS.PER_PERUSCCR_XMLP_PKG

Source


1 PACKAGE PER_PERUSCCR_XMLP_PKG AS
2 /* $Header: PERUSCCRS.pls 120.2 2008/04/02 08:18:25 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_PARENT_ORGANIZATION_ID	varchar2(40);
8 	P_ORG_STRUCTURE_VERSION_ID	varchar2(40);
9 	P_QL_DATE_FROM	date;
10 	P_QL_DATE_FROM1 varchar2(240);
11 	P_QL_DATE_TO	date;
12 	P_QL_DATE_TO1 varchar2(240);
13 	P_QUALIFYING_EVENT	varchar2(40);
14 	P_COV_START_FROM	date;
15 	P_COV_START_FROM1 varchar2(240);
16 	P_COV_START_TO	date;
17 	P_COV_START_TO1 varchar2(240);
18 	P_COV_END_FROM	date;
19 	P_COV_END_FROM1 varchar2(240);
20 	P_COVERAGE_END_TO	date;
21 	P_COV_END_TO1 varchar2(240);
22 	P_COBRA_STATUS	varchar2(40);
23 	P_BEN_PLAN_TYPE_ID	number;
24 	P_BENEFIT_PLAN_TYPE_ID	varchar2(40);
25 	C_BUSINESS_GROUP_NAME	varchar2(240);
26 	C_REPORT_SUBTITLE	varchar2(60);
27 	C_qualifying_event	varchar2(80);
28 	C_COBRA_STATUS	varchar2(80);
29 	C_PARENT_ORGANIZATION_NAME	varchar2(240);
30 	C_ORG_STRUCTURE_NAME	varchar2(30);
31 	C_BENEFIT_PLAN_NAME	varchar2(30);
32 	C_END_OF_TIME	date;
33 	function BeforeReport return boolean  ;
34 	function AfterReport return boolean  ;
35 	Function C_BUSINESS_GROUP_NAME_p return varchar2;
36 	Function C_REPORT_SUBTITLE_p return varchar2;
37 	Function C_qualifying_event_p return varchar2;
38 	Function C_COBRA_STATUS_p return varchar2;
39 	Function C_PARENT_ORGANIZATION_NAME_p return varchar2;
40 	Function C_ORG_STRUCTURE_NAME_p return varchar2;
41 	Function C_BENEFIT_PLAN_NAME_p return varchar2;
42 	Function C_END_OF_TIME_p return date;
43 END PER_PERUSCCR_XMLP_PKG;