PACKAGE: APPS.HXC_TCD_XML_PKG

Source

1 PACKAGE HXC_TCD_XML_PKG AS
2 /* $Header: hxctcdrpt.pkh 120.3.12010000.3 2008/11/14 13:37:55 anuthi ship $ */
3 
4 
5 	p_resource_id		varchar2(100);
6 
7 	p_rec_period_id	varchar2(100);
8 	p_tc_period		varchar2(100);
9 	p_period_start_date	DATE;
10 	p_period_end_date	DATE;
11 	p_supervisor_id	varchar2(100);
12 	p_reptng_emp		varchar2(20) ;
13 	p_org_id		varchar2(100);
14 	p_location_id		varchar2(100);
15 
16 	p_sel_supervisor_id 	varchar2(100);
17 	p_sel_tc_status		varchar2(20);
18 
19 
20 	l_resource_id		varchar2(100);
21 
22 	l_rec_period_id		varchar2(100);
23 	l_period_start_date	DATE;
24 	l_period_end_date	DATE;
25 	l_supervisor_id		varchar2(100);
26 	l_reptng_emp		varchar2(20) ;
27 	l_org_id		varchar2(100);
28 	l_location_id		varchar2(100);
29 
30 	l_rec_period		varchar2(100);
31 	l_tc_period		varchar2(100);
32 	l_supervisor_name	varchar2(240);
33 	l_location_name	varchar2(240);
34 	l_org_name		varchar2(240);
35 
36 	l_sel_supervisor_id 	varchar2(100);
37 	l_sel_tc_status		varchar2(20);
38 	l_rpt_status		varchar2(50);
39 
40 
41 	procedure populate_report_table;
42 	procedure clear_report_table;
43 	function afterpform return boolean;
44 	function BeforeReport return boolean  ;
45 	function AfterReport return boolean  ;
46 	function get_timecard_end_date(p_person_id IN NUMBER, p_timecard_id IN NUMBER, p_period_end_date IN DATE default null) return date;
47 	function get_timecard_start_date(p_person_id IN NUMBER, p_timecard_id IN NUMBER, p_period_start_date IN DATE default null, p_period_end_date IN DATE default null) return date;
48 END HXC_TCD_XML_PKG;