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_BENLESUM_XMLP_PKG

Source


1 PACKAGE BEN_BENLESUM_XMLP_PKG AUTHID CURRENT_USER AS
2 /* $Header: BENLESUMS.pls 120.1 2007/12/10 08:36:52 vjaganat noship $ */
3 --Display elements added
4 	T_RUN_DATE	varchar2(40);
5 	T_COMP_PERD_STRT_DT	varchar2(40);
6 	T_COMP_PERD_END_DT	varchar2(40);
7 	T_REPT_PERD_STRT_DT	varchar2(40);
8 	T_REPT_PERD_END_DT	varchar2(40);
9 	T_CONC_REQUEST_ID	number;
10 	P_BUSINESS_GROUP_ID	number;
11 	P_REPT_PERD_STRT_DT	date;
12 	P_REPT_PERD_END_DT	date;
13 	P_PERSON_ID	number;
14 	P_BENEFIT_GROUP_ID	number;
15 	P_RUN_DATE	date;
16 	P_LER_ID	number;
17 	P_LER_TYPE	varchar2(40);
18 	P_LOCATION_ID	number;
19 	P_ASSIGNMENT_TYPE	varchar2(10);
20 	P_ORGANIZATION_ID	number;
21 	P_COMP_PERD_STRT_DT	date;
22 	P_COMP_PERD_END_DT	date;
23 	P_REPORTING_GROUP_ID	number;
24 	P_PL_ID	number;
25 	P_REPORT_MODULE_CD	varchar2(40);
26 	p_sort	varchar2(2000);
27 	p_sort1	varchar2(2000); --Added during DT Fixes
28 	P_SORT_order_1	varchar2(100);
29 	P_sort_order_2	varchar2(100);
30 	P_sort_order_3	varchar2(100);
31 	P_sort_order_4	varchar2(100);
32 	P_NAT_IDENT	varchar2(100);
33 	P_ERROR	varchar2(2000);
34 	P_RUN_REPORT	varchar2(1) := 'Y';
35 	P_DATE_mask	varchar2(50);
36 	P_conc_request_id	number;
37 	P_user_sort	varchar2(200);
38 	P_disp_flex_fields_flag	varchar2(1);
39 	P_RPTG_GRP_ID	varchar2(40);
40 	P_sort_DFF	varchar2(200);
41 	P_sort_DFF2	varchar2(200); --Added during DT Fixes
42 	P_sort_DFF3	varchar2(200); --Added during DT Fixes
43 	CP_detected_name_potnl_rep	number;
44 	CP_unprocessed_name_potnl_rep	number;
45 	CP_processed_name_potnl_rep	number;
46 	CP_total_name_potnl_rep	number;
47 	CP_voided_name_potnl_rep	number;
48 	CP_settomanual_name_potnl_rep	number;
49 	CP_manover_name_potnl_rep	number;
50 	CP_detected_name_potnl_comp	number;
51 	CP_unprocessed_name_potnl_comp	number;
52 	CP_processed_name_potnl_comp	number;
53 	CP_total_name_potnl_comp	number;
54 	CP_voided_name_potnl_comp	number;
55 	CP_settomanual_name_potnl_comp	number;
56 	CP_manover_name_potnl_comp	number;
57 	CP_started_name_proc_rep	number;
58 	CP_processed_name_proc_rep	number;
59 	CP_backedout_name_proc_rep	number;
60 	CP_voided_name_proc_rep	number;
61 	CP_total_name_proc_rep	number;
62 	CP_started_name_proc_comp	number;
63 	CP_processed_name_proc_comp	number;
64 	CP_backedout_name_proc_comp	number;
65 	CP_voided_name_proc_comp	number;
66 	CP_total_name_proc_comp	number;
67 	CP_report_module_name	varchar2(300);
68 	CP_asg_type	varchar2(300);
69 	CP_ler_type	varchar2(300);
70 	CP_business_group_name	varchar2(300);
71 	CP_location_name	varchar2(300);
72 	CP_organization_name	varchar2(300);
73 	CP_reporting_group_name	varchar2(300);
74 	CP_benefit_group_name	varchar2(300);
75 	CP_pln_name	varchar2(300);
76 	CP_ler_name	varchar2(300);
77 	CP_person_name	varchar2(300);
78 	CP_nat_ident	varchar2(100);
79 	CP_displ_flex	varchar2(30);
80 	CP_rept_strt_end_dt	varchar2(40);
81 	CP_comp_strt_end_dt	varchar2(40);
82 	function cf_transfer_valuesformula(CS_detected_name_potnl_rep in number,
83 	CS_unprocessed_name_potnl_rep in number, CS_processed_name_potnl_rep in number,
84 	CS_voided_name_potnl_rep in number, CS_settoman_name_potnl_rep in number,
85 	CS_manover_name_potnl_rep in number, CS_total_name_potnl_rep in number,
86 CS_detected_name_potnl_comp in number, CS_unprocessed_name_potnl_comp in number,
87 CS_processed_name_potnl_comp in number, CS_voided_name_potnl_comp in number,
88 CS_settoman_name_potnl_comp in number, CS_manover_name_potnl_comp in number,
89 CS_total_name_potnl_comp in number, CS_started_name_processed_rep in number,
90 CS_proc_name_processed_rep in number, CS_backedout_name_proc_rep in number,
91 CS_voided_name_proc_rep in number, CS_total_name_proc_rep in number,
92 CS_started_name_processed_comp in number, CS_proc_name_processed_comp in number,
93 CS_backedout_name_proc_comp in number, CS_voided_name_proc_comp in number, CS_total_name_proc_comp in number) return number  ;
94 	function AfterPForm return boolean ;
95 	PROCEDURE append_order_by(colname varchar2)  ;
96 	FUNCTION FIND_COL(col_name varchar2) RETURN varchar2  ;
97 	function BeforeReport return boolean  ;
98 	function AfterReport return boolean  ;
99 	Function CP_detected_name_potnl_rep_p return number;
100 	Function CP_unprocessed_name_potnl_rep1 return number;
101 	Function CP_processed_name_potnl_rep_p return number;
102 	Function CP_total_name_potnl_rep_p return number;
103 	Function CP_voided_name_potnl_rep_p return number;
104 	Function CP_settomanual_name_potnl_rep1 return number;
105 	Function CP_manover_name_potnl_rep_p return number;
106 	Function CP_detected_name_potnl_comp_p return number;
107 	Function CP_unprocessed_name_potnl_com return number;
108 	Function CP_processed_name_potnl_comp_p return number;
109 	Function CP_total_name_potnl_comp_p return number;
110 	Function CP_voided_name_potnl_comp_p return number;
111 	Function CP_settomanual_name_potnl_com return number;
112 	Function CP_manover_name_potnl_comp_p return number;
113 	Function CP_started_name_proc_rep_p return number;
114 	Function CP_processed_name_proc_rep_p return number;
115 	Function CP_backedout_name_proc_rep_p return number;
116 	Function CP_voided_name_proc_rep_p return number;
117 	Function CP_total_name_proc_rep_p return number;
118 	Function CP_started_name_proc_comp_p return number;
119 	Function CP_processed_name_proc_comp_p return number;
120 	Function CP_backedout_name_proc_comp_p return number;
121 	Function CP_voided_name_proc_comp_p return number;
122 	Function CP_total_name_proc_comp_p return number;
123 	Function CP_report_module_name_p return varchar2;
124 	Function CP_asg_type_p return varchar2;
125 	Function CP_ler_type_p return varchar2;
126 	Function CP_business_group_name_p return varchar2;
127 	Function CP_location_name_p return varchar2;
128 	Function CP_organization_name_p return varchar2;
129 	Function CP_reporting_group_name_p return varchar2;
130 	Function CP_benefit_group_name_p return varchar2;
131 	Function CP_pln_name_p return varchar2;
132 	Function CP_ler_name_p return varchar2;
133 	Function CP_person_name_p return varchar2;
134 	Function CP_nat_ident_p return varchar2;
135 	Function CP_displ_flex_p return varchar2;
136 	Function CP_rept_strt_end_dt_p return varchar2;
137 	Function CP_comp_strt_end_dt_p return varchar2;
138 END BEN_BENLESUM_XMLP_PKG;