1 PACKAGE AHL_PRD_PRINT_PVT AS
2 /* $Header: AHLVPPRS.pls 120.1 2006/06/22 14:50:51 bachandr noship $ */
3
4 TYPE WORKORDER_TBL_TYPE IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
5
6 ------------------------------------------------------------------------------------------------
7 -- Procedure to generate XML data for workorder(s).
8 ------------------------------------------------------------------------------------------------
9 -- Start of Comments
10 -- Procedure name :
11 -- Type : Private
12 -- Pre-reqs :
13 -- Function : Gen_Wo_Xml
14 -- Parameters :
15 --
16 -- Standard IN Parameters :
17 -- p_api_version NUMBER Required
18 -- p_init_msg_list VARCHAR2 Default FND_API.G_FALSE
19 -- p_commit VARCHAR2 Default FND_API.G_FALSE
20 -- p_validation_level NUMBER Default FND_API.G_VALID_LEVEL_FULL
21 -- p_default VARCHAR2 Default FND_API.G_TRUE
22 -- p_module_type VARCHAR2 Default NULL
23 --
24 -- Standard OUT Parameters :
25 -- x_return_status VARCHAR2 Required
26 -- x_msg_count NUMBER Required
27 -- x_msg_data VARCHAR2 Required
28 --
29 -- IN parameters:
30 -- p_workorder_id NUMBER Required
31 -- p_visit_id NUMBER Required
32 --
33 -- IN OUT parameters:
34 -- None
35 --
36 -- OUT parameters:
37 -- x_xml_data CLOB
38 --
39 -- Version :
40 -- Current version 1.0
41 --
42 -- Return Parameter type
43 -- CLOB
44 -- End of Comments
45
46 PROCEDURE Gen_Wo_Xml(
47 p_api_version IN NUMBER :=1.0,
48 p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
49 p_commit IN VARCHAR2 :=FND_API.G_FALSE,
50 p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
51 p_default IN VARCHAR2 :=FND_API.G_FALSE,
52 p_module_type IN VARCHAR2 :=NULL,
53 x_return_status OUT NOCOPY VARCHAR2,
54 x_msg_count OUT NOCOPY NUMBER,
55 x_msg_data OUT NOCOPY VARCHAR2,
56 p_workorders_tbl IN WORKORDER_TBL_TYPE,
57 p_employee_id IN NUMBER,
58 p_user_role IN VARCHAR2,-- required for resource transactions
59 p_material_req_flag IN VARCHAR2 := 'N',--not required any more
60 x_xml_data OUT NOCOPY CLOB,
61 p_concurrent_flag IN VARCHAR2 := 'N'-- pass as N non concurrent programs
62 );
63
64 ------------------------------------------------------------------------------------------------
65 -- Procedure to generate XML data for Workcard concurrent program
66 ------------------------------------------------------------------------------------------------
67 -- Start of Comments
68 -- Procedure name :
69 -- Type : Private
70 -- Pre-reqs :
71 -- Function : Gen_Workcard_Xml
72 -- Parameters :
73 --
74 -- Standard IN Parameters :
75 -- p_api_version NUMBER Required
76 --
77 -- Standard OUT Parameters :
78 -- errbuf OUT NOCOPY VARCHAR2,
79 -- retcode OUT NOCOPY NUMBER,
80 --
81 -- IN parameters:
82 -- p_visit_id IN NUMBER Required
83 -- p_stage_id IN NUMBER Required
84 -- p_wo_no_from IN VARCHAR2 Required
85 -- p_wo_no_to IN VARCHAR2 Required
86 -- p_sch_start_from IN VARCHAR2 Required
87 -- p_sch_start_to IN VARCHAR2 Required
88 -- p_employee_id IN NUMBER Required
89 --
90 -- IN OUT parameters:
91 -- None
92 --
93 -- OUT parameters:
94 -- None.
95 --
96 -- Version :
97 -- Current version 1.0
98 --
99 -- Return Parameter
100 -- CLOB
101 -- End of Comments
102
103 PROCEDURE Gen_Workcard_Xml(
104 errbuf OUT NOCOPY VARCHAR2,
105 retcode OUT NOCOPY NUMBER,
106 p_api_version IN NUMBER,
107 p_visit_id IN NUMBER,
108 p_stage_id IN NUMBER,
109 p_wo_no_from IN VARCHAR2,
110 p_wo_no_to IN VARCHAR2,
111 p_sch_start_from IN VARCHAR2,
112 p_sch_start_to IN VARCHAR2,
113 p_employee_id IN NUMBER
114 );
115
116 FUNCTION get_tz_offset
117 RETURN VARCHAR2;
118
119 END AHL_PRD_PRINT_PVT;