[Home] [Help]
PACKAGE: APPS.BEN_BENRECON_XMLP_PKG
Source
1 PACKAGE BEN_BENRECON_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: BENRECONS.pls 120.1 2007/12/10 08:38:16 vjaganat noship $ */
3 P_PL_ID varchar2(40);
4 P_PGM_ID varchar2(40);
5 P_BUSINESS_GROUP_ID varchar2(40);
6 P_RUN_DATE date;
7 P_PERSON_ID varchar2(40);
8 P_PER_SEL_RULE varchar2(40);
9 P_BENEFIT_ACTION_ID varchar2(40);
10 P_NTL_IDENTIFIER varchar2(40);
11 P_PREM_TYPE varchar2(40);
12 P_REPORT_START_DATE date;
13 P_PAYROLL_ID varchar2(40);
14 P_REPORT_END_DATE date;
15 P_ORGANIZATION_ID varchar2(40);
16 P_LOCATION_ID varchar2(40);
17 P_BENFTS_GRP_ID varchar2(40);
18 P_RPTG_GRP_ID varchar2(40);
19 P_plan_recn_rep_header varchar2(3000) := 'Reconciliation for';
20 P_PERIOD_TOT varchar2(30);
21 P_ACTUAL_TOT varchar2(30);
22 P_PLAN_PRTT_SUBTOTAL_NAME varchar2(500);
23 P_plan_disc_rep_header varchar2(3000) := 'Discrepancies for';
24 P_LFE_REP_HEADER varchar2(3000) := 'Life Events Affecting Premiums for';
25 P_PLAN_PRTT_REP_HEADER varchar2(3000) := 'Plan Participant Details for';
26
27 P_DSPLY_PL_RECN_REP varchar2(30);
28 P_DSPLY_PL_DISC_REP varchar2(30);
29 P_DSPLY_PL_PRTT_REP varchar2(30);
30 P_DSPLY_LFE_REP varchar2(30);
31
32 T_DSPLY_PL_RECN_REP varchar2(30);
33 T_DSPLY_PL_DISC_REP varchar2(30);
34 T_DSPLY_PL_PRTT_REP varchar2(30);
35 T_DSPLY_LFE_REP varchar2(30);
36
37
38
39
40 P_DSPLY_PRTT_REPS varchar2(30);
41 P_EMP_NAME_FORMAT varchar2(40);
42 P_conc_request_id number;
43 P_MON_YEAR varchar2(32767);
44 P_DSPLY_DISC varchar2(32767) := 'Y';
45 P_DSPLY_RECN varchar2(32767) := 'Y';
46 P_DSPLY_LFE varchar2(32767) := 'Y';
47 P_DSPLY_PL_PRTT varchar2(32767) := 'Y';
48 P_OUTPUT_TYP varchar2(32767);
49 P_op_file_name varchar2(200);
50 P_REP_ST_DT date;
51 P_REP_END_DT date;
52 Pl_uom varchar2(32767);
53 P_ERROR varchar2(4000);
54 P_DATE_FORMAT varchar2(32767);
55 CP_PL_RECN_PRTT_COUNT number := 0 ;
56 CP_PL_PRTT_COUNT number := 0 ;
57 CP_LFE_PRTT_COUNT number := 0 ;
58 CP_DISC_PRTT_COUNT number := 0 ;
59 CP_DSPLY_RECN varchar2(20) := 'Y' ;
60 CP_DSPLY_DISC varchar2(20) := 'Y' ;
61 CP_DSPLY_LFE varchar2(20) := 'Y' ;
62 CP_DSPLY_PL_PRTT varchar2(20) := 'Y' ;
63 CP_PERSON varchar2(300);
64 CP_LOCATION varchar2(300);
65 CP_BENFTS_GRP varchar2(300);
66 CP_RPTG_GRP varchar2(300);
67 CP_PREM_TYPE varchar2(300);
68 CP_OUTPUT_TYP varchar2(300);
69 CP_EMP_NAME_FORMAT varchar2(300);
70 CP_PGM varchar2(300);
71 CP_PL varchar2(300);
72 CP_PER_SEL_RULE varchar2(300);
73 CP_BUSINESS_GROUP varchar2(300);
74 CP_ORGANIZATION varchar2(300);
75 CP_PAYROLL varchar2(300);
76 CP_NTL_IDENTIFIER varchar2(50);
77 function Format_Mask(p_uom varchar2) return varchar2 ;
78 function AfterPForm return boolean ;
79 function cf_levelformula(levels in varchar2) return number ;
80 function cf_uomformula(pl_sql_uom in varchar2) return number ;
81 function CF_LFE_PRTT_COUNTFormula return Number ;
82 function cf_1formula(uom2 in varchar2) return number ;
83 function cf_dsicrepencyformula(pay_perd_total1 in number, actual_total1 in number, pl_prem_val1 in number, pl_sql_uom1 in varchar2) return char ;
84 function CF_DISC_PRTT_COUNTFormula return Number ;
85 function CF_headerFormula return Number ;
86 function BeforeReport return boolean ;
87 function AfterReport return boolean ;
88 Function CP_PL_RECN_PRTT_COUNT_p return number;
89 Function CP_PL_PRTT_COUNT_p return number;
90 Function CP_LFE_PRTT_COUNT_p return number;
91 Function CP_DISC_PRTT_COUNT_p return number;
92 Function CP_DSPLY_RECN_p return varchar2;
93 Function CP_DSPLY_DISC_p return varchar2;
94 Function CP_DSPLY_LFE_p return varchar2;
95 Function CP_DSPLY_PL_PRTT_p return varchar2;
96 Function CP_PERSON_p return varchar2;
97 Function CP_LOCATION_p return varchar2;
98 Function CP_BENFTS_GRP_p return varchar2;
99 Function CP_RPTG_GRP_p return varchar2;
100 Function CP_PREM_TYPE_p return varchar2;
101 Function CP_OUTPUT_TYP_p return varchar2;
102 Function CP_EMP_NAME_FORMAT_p return varchar2;
103 Function CP_PGM_p return varchar2;
104 Function CP_PL_p return varchar2;
105 Function CP_PER_SEL_RULE_p return varchar2;
106 Function CP_BUSINESS_GROUP_p return varchar2;
107 Function CP_ORGANIZATION_p return varchar2;
108 Function CP_PAYROLL_p return varchar2;
109 Function CP_NTL_IDENTIFIER_p return varchar2;
110 END BEN_BENRECON_XMLP_PKG;