PACKAGE: APPS.HXC_TCD_XML_PKG

Source

1 PACKAGE HXC_TCD_XML_PKG AUTHID CURRENT_USER AS
2 /* $Header: hxctcdrpt.pkh 120.7 2011/02/24 11:14:50 pnshukla 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 	-- Bug 8205132
42 	-- Added new plsql table type
43 
44 	TYPE DATETAB IS TABLE OF DATE;
45 
46 
47 	procedure populate_report_table;
48 	procedure clear_report_table;
49 	function afterpform return boolean;
50 	function BeforeReport return boolean  ;
51 	function AfterReport return boolean  ;
52 
53 	-- Bug 8205132
54 	-- Added new parameter assignment start date in the
55 	-- below functions.
56 	-- Bug 11806620
57 	-- Removed parameter assignment start date from the
58 	-- below functions.
59 	FUNCTION get_timecard_end_date(p_person_id              IN NUMBER,
60 	                               p_timecard_id            IN NUMBER,
61 	                               p_period_end_date        IN DATE DEFAULT NULL)
62 	RETURN DATE;
63 
64 	FUNCTION get_timecard_start_date(p_person_id             IN NUMBER,
65 	                                 p_timecard_id           IN NUMBER,
66 	                                 p_period_start_date     IN DATE DEFAULT NULL,
67 	                                 p_period_end_date       IN DATE DEFAULT NULL)
68 	RETURN DATE;
69 
70 END HXC_TCD_XML_PKG;