1 PACKAGE EAM_SAFETY_REPORTS_PVT AUTHID CURRENT_USER AS
2 /* $Header: EAMVSRPS.pls 120.3 2011/06/01 10:15:07 vboddapa noship $ */
3 /***************************************************************************
4 --
5 -- Copyright (c) 2010 Oracle Corporation, Redwood Shores, CA, USA
6 -- All rights reserved.
7 --
8 -- FILENAME
9 --
10 -- EAMVSRPS.pls
11 --
12 -- DESCRIPTION
13 --
14 -- Spec of package EAM_SAFETY_REPORTS_PVT
15 --
16 -- NOTES
17 --
18 -- HISTORY
19 --
20 -- 07-APRIL-2008 Madhuri Shah Initial Creation
21 ***************************************************************************/
22
23
24 /********************************************************************
25 * Procedure : getWorkPermitReportXML
26 * Purpose : This procedure generate xml data for work permits
27 *********************************************************************/
28 TYPE eam_permit_record_type IS RECORD (
29 permit_id INT
30 );
31
32 TYPE eam_permit_tab_type IS TABLE OF eam_permit_record_type;
33
34 Function getWorkPermitReportXML
35 ( p_permit_ids in eam_permit_tab_type,
36 p_work_clearance_flag in NUMBER,
37 p_work_order_flag in NUMBER,
38 p_text_attachment_flag IN NUMBER,
39 p_url_attachment_flag IN NUMBER,
40 p_file_attachment_flag in NUMBER
41 ) return CLOB;
42
43
44 /********************************************************************
45 * Procedure : Convert_to_client_time
46 * Purpose : This procedure coverts date from Server Time zone to Client Time Zone
47 *********************************************************************/
48 Function Convert_to_client_time
49 (
50 p_server_time in date
51 ) return date;
52
53 /********************************************************************
54 * Procedure : getWorkClearanceReportXML
55 * Purpose : This procedure generate xml data for work clearances
56
57 *********************************************************************/
58 /*Function getWorkClearanceReportXML
59 ( p_work_clearance_id in system.eam_wipid_tab_type,
60 p_short_attachment_flag in int,
61 p_long_attachment_flag in int,
62 p_file_attachment_flag in int,
63 p_work_request_flag in int,
64 p_asset_bom_flag in int
65 )return CLOB;*/
66
67
68 END EAM_SAFETY_REPORTS_PVT;
69
70