1 PACKAGE CST_eAM_WorkOrders_PVT AUTHID CURRENT_USER AS
2 /* $Header: CSTPEEAS.pls 120.1 2005/07/12 06:46 skayitha noship $ */
3
4 -----------------------------------------------------------------------------
5 -- Start of comments
6 -- API name : Generate_XMLData
7 -- Type : Private
8 -- Function : The procedure is called from concurrent request
9 -- " Concurrent Request Name "
10 --
11 -- Pre-reqs : None.
12 -- Parameters :
13 -- IN :
14 -- p_legal_entity_id NUMBER Legal Entity Id
15 -- p_cost_group_id NUMBER PAC Cost Group Id
16 -- p_cost_type_id NUMBER PAC Cost Type Id
17 -- p_pac_period_id NUMBER PAC Period id
18 -- p_range NUMBER 1 All
19 -- 2 Specific
20 -- 3 Range
21 -- p_dummy1 NUMBER Default NULL,
22 -- p_dummy2 NUMBER Default NULL,
23 -- p_from_workorder VARCHAR2 From WorkOrder
24 -- p_to_workorder VARCHAR2 To WorkOrder
25 -- p_specific_workorder VARCHAR2 Optional
26 --
27 -- OUT :
28 -- errbuf VARCHAR2
29 -- retcode NUMBER
30 --
31 -- Version : Current version 1.0
32 --
33 -- End of comments
34 -------------------------------------------------------------------------------
35
36 PROCEDURE Generate_XMLData
37 (errcode OUT NOCOPY VARCHAR2,
38 errno OUT NOCOPY NUMBER,
39 p_legal_entity_id IN NUMBER,
40 p_cost_type_id IN NUMBER,
41 p_cost_group_id IN NUMBER,
42 p_range IN NUMBER,
43 p_dummy1 IN NUMBER := NULL,
44 p_dummy2 IN NUMBER := NULL,
45 p_from_workorder IN VARCHAR2 := NULL,
46 p_to_workorder IN VARCHAR2 := NULL,
47 p_specific_workorder IN NUMBER := NULL);
48
49 -----------------------------------------------------------------------------
50 -- Start of comments
51 -- API name : Display_Parameters
52 -- Type : Private
53 -- Function : The procedure is called from Generate_XMLData
54 --
55 --
56 -- Pre-reqs : None.
57 -- Parameters :
58 -- IN :
59 -- p_api_version NUMBER Required
60 -- p_init_msg_list VARCHAR2 Required
61 -- p_validation_level NUMBER Required
62 -- p_legal_entity_id NUMBER Legal Entity Id
63 -- p_cost_group_id NUMBER PAC Cost Group Id
64 -- p_cost_type_id NUMBER PAC Cost Type Id
65 -- p_pac_period_id NUMBER PAC Period id
66 -- p_range NUMBER 1 All
67 -- 2 Specific
68 -- 3 Range
69 -- p_from_workorder VARCHAR2 From WorkOrder
70 -- p_to_workorder VARCHAR2 To WorkOrder
71 -- p_specific_workorder VARCHAR2 Optional
72 --
73 -- OUT :
74 -- x_return_status VARCHAR2
75 -- x_msg_count NUMBER
76 -- x_msg_data VARCHAR2
77 -- x_xml_doc CLOB
78 --
79 -- Version : Current version 1.0
80 --
81 -- End of comments
82 -------------------------------------------------------------------------------
83
84 PROCEDURE Display_Parameters (p_api_version IN NUMBER,
85 p_init_msg_list IN VARCHAR2,
86 p_validation_level IN NUMBER,
87 x_return_status OUT NOCOPY VARCHAR2,
88 x_msg_count OUT NOCOPY NUMBER,
89 x_msg_data OUT NOCOPY VARCHAR2,
90 p_legal_entity_id IN NUMBER,
91 p_cost_group_id IN NUMBER,
92 p_cost_type_id IN NUMBER,
93 p_range IN NUMBER,
94 p_from_workorder IN VARCHAR2,
95 p_to_workorder IN VARCHAR2,
96 p_specific_workorder IN NUMBER,
97 x_xml_doc IN OUT NOCOPY CLOB);
98
99 -----------------------------------------------------------------------------
100 -- Start of comments
101 -- API name : eAM_Est_Actual_details
102 -- Type : Private
103 -- Function : The procedure is called from Generate_XMLData
104 --
105 --
106 -- Pre-reqs : None.
107 -- Parameters :
108 -- IN :
109 -- p_api_version NUMBER Required
110 -- p_init_msg_list VARCHAR2 Required
111 -- p_validation_level NUMBER Required
112 -- p_legal_entity_id NUMBER Legal Entity Id
113 -- p_cost_group_id NUMBER PAC Cost Group Id
114 -- p_cost_type_id NUMBER PAC Cost Type Id
115 -- p_pac_period_id NUMBER PAC Period id
116 -- p_range NUMBER 1 All
117 -- 2 Specific
118 -- 3 Range
119 -- p_from_workorder VARCHAR2 From WorkOrder
120 -- p_to_workorder VARCHAR2 To WorkOrder
121 -- p_specific_workorder VARCHAR2 Optional
122 --
123 -- OUT :
124 -- x_return_status VARCHAR2
125 -- x_msg_count NUMBER
126 -- x_msg_data VARCHAR2
127 -- x_xml_doc CLOB
128 --
129 -- Version : Current version 1.0
130 --
131 -- End of comments
132 -------------------------------------------------------------------------------
133
134
135 PROCEDURE eAM_Est_Actual_details(p_api_version IN NUMBER,
136 p_init_msg_list IN VARCHAR2,
137 p_validation_level IN NUMBER,
138 x_return_status OUT NOCOPY VARCHAR2,
139 x_msg_count OUT NOCOPY NUMBER,
140 x_msg_data OUT NOCOPY VARCHAR2,
141 p_legal_entity_id IN NUMBER,
142 p_cost_group_id IN NUMBER,
143 p_cost_type_id IN NUMBER,
144 p_range IN NUMBER,
145 p_from_workorder IN VARCHAR2,
146 p_to_workorder IN VARCHAR2,
147 p_specific_workorder IN NUMBER,
148 x_xml_doc IN OUT NOCOPY CLOB);
149
150 END CST_eAM_WorkOrders_PVT;