1 PACKAGE EAM_FailureSets_PVT AS
2 /* $Header: EAMVFSPS.pls 120.0 2006/03/08 07:15:39 sshahid noship $ */
3 /**************************************************************************
4 -- Start of comments
5 -- API name : Setup_FailureSet
6 -- Type : Private.
7 -- Function : Create/Update Failure Set with failure set
8 -- information passed to this API.
9 -- Pre-reqs : None.
10 -- Parameters :
11 -- IN : p_api_version IN NUMBER Required
12 -- p_init_msg_list IN VARCHAR2 Optional
13 -- Default = FND_API.G_FALSE
14 -- p_commit IN VARCHAR2 Optional
15 -- Default = FND_API.G_FALSE
16 -- p_validation_level IN NUMBER
17 -- Default = FND_API.G_VALID_LEVEL_FULL
18 -- p_mode IN VARCHAR2 Required
19 -- Possible Values for p_mode
20 -- 'C' for create failure set
21 -- 'U' for update failure set
22 -- p_failure_set_rec IN
23 -- EAM_FailureSets_PUB.eam_failureset_rec_type
24 -- Within p_failure_set_rec, set_name column
25 -- is 'Required' while calling this API in create mode
26 -- and either set_name or set_id should have a value
27 -- in update mode..
28 -- OUT : x_return_status OUT VARCHAR2(1)
29 -- x_msg_count OUT NUMBER
30 -- x_msg_data OUT VARCHAR2(2000)
31 -- x_failureset_id OUT NUMBER
32 -- Version : Current version 1.0.
33 -- Initial version 1.0
34 -- End of comments
35 ***************************************************************************/
36 PROCEDURE Setup_FailureSet
37 (p_api_version IN NUMBER ,
38 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
39 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
40 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
41 p_mode IN VARCHAR2 ,
42 p_failureset_rec IN EAM_FailureSets_PUB.eam_failureset_rec_type,
43 x_return_status OUT NOCOPY VARCHAR2 ,
44 x_msg_count OUT NOCOPY NUMBER ,
45 x_msg_data OUT NOCOPY VARCHAR2 ,
46 x_failureset_id OUT NOCOPY NUMBER
47 );
48
49 /**************************************************************************
50 -- Start of comments
51 -- API name : Setup_SetAssociation
52 -- Type : Private.
53 -- Function : Create/Update/Delete association of Failure Set
54 -- with Asset Group/Rebuildable
55 -- Pre-reqs : None.
56 -- Parameters :
57 -- IN : p_api_version IN NUMBER Required
58 -- p_init_msg_list IN VARCHAR2 Optional
59 -- Default = FND_API.G_FALSE
60 -- p_commit IN VARCHAR2 Optional
61 -- Default = FND_API.G_FALSE
62 -- p_validation_level IN NUMBER
63 -- Default = FND_API.G_VALID_LEVEL_FULL
64 -- p_mode IN VARCHAR2 Required
65 -- Possible Values for p_mode
66 -- 'C' for create association
67 -- 'U' for update association
68 -- 'D' for delete association
69 -- p_set_association_rec IN
70 EAM_FailureSets_PUB.eam_set_association_rec_type
71 -- Within p_set_association_rec,either set id or
72 -- set_name column should have a value and
73 -- inventory_item_id is 'Required'.
74 -- is 'Required' while calling this API.
75 -- OUT : x_return_status OUT VARCHAR2(1)
76 -- x_msg_count OUT NUMBER
77 -- x_msg_data OUT VARCHAR2(2000)
78 -- Version : Current version 1.0.
79 -- Initial version 1.0
80 -- End of comments
81 ***************************************************************************/
82 PROCEDURE Setup_SetAssociation
83 (p_api_version IN NUMBER ,
84 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
85 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
86 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
87 p_mode IN VARCHAR2 ,
88 p_association_rec IN EAM_FailureSets_PUB.eam_set_association_rec_type,
89 x_return_status OUT NOCOPY VARCHAR2 ,
90 x_msg_count OUT NOCOPY NUMBER ,
91 x_msg_data OUT NOCOPY VARCHAR2
92 );
93
94 /**************************************************************************
95 -- Start of comments
96 -- API name : Setup_FailureSet_JSP
97 -- Type : Private.
98 -- Function : Wrapper to call Setup_FailureSet() from OA Fwk.
99 -- Pre-reqs : None.
100 -- Parameters :
101 -- IN : p_mode IN VARCHAR2 Required
102 -- Possible Values for p_mode
103 -- 'C' for create failure set
104 -- 'U' for update failure set
105 -- p_set_name VARCHAR2
106 -- p_description VARCHAR2
107 -- p_effective_end_date DATE
108 -- p_set_id NUMBER
109 -- p_stored_last_upd_date DATE
110 -- OUT : x_return_status OUT VARCHAR2(1)
111 -- x_msg_count OUT NUMBER
112 -- x_msg_data OUT VARCHAR2(2000)
113 -- x_failureset_id OUT NUMBER
114 -- Version : Current version 1.0.
115 -- Initial version 1.0
116 -- End of comments
117 ***************************************************************************/
118 PROCEDURE Setup_FailureSet_JSP
119 (p_mode IN VARCHAR2 ,
120 p_set_name IN VARCHAR2 ,
121 p_description IN VARCHAR2 ,
122 p_effective_end_date IN DATE ,
123 p_set_id IN NUMBER ,
124 p_stored_last_upd_date IN DATE ,
125 x_return_status OUT NOCOPY VARCHAR2,
126 x_msg_count OUT NOCOPY NUMBER ,
127 x_msg_data OUT NOCOPY VARCHAR2,
128 x_failureset_id OUT NOCOPY NUMBER
129 );
130
131 /**************************************************************************
132 -- Start of comments
133 -- API name : Setup_SetAssociation_JSP
134 -- Type : Private.
135 -- Function : Wrapper call to Setup_SetAssociation from OA Fwk
136 -- Pre-reqs : None.
137 -- Parameters :
138 -- IN : p_mode IN VARCHAR2 Required
139 -- Possible Values for p_mode
140 -- 'C' for create association
141 -- 'U' for update association
142 -- 'D' for delete association
143 -- p_set_id NUMBER
144 -- p_set_name VARCHAR2(80)
145 -- p_inventory_item_id NUMBER
146 -- p_failure_code_required VARCHAR2(1)
147 -- p_effective_end_date DATE
148 -- p_stored_last_upd_date DATE
149 -- OUT : x_return_status OUT VARCHAR2(1)
150 -- x_msg_count OUT NUMBER
151 -- x_msg_data OUT VARCHAR2(2000)
152 -- Version : Current version 1.0.
153 -- Initial version 1.0
154 -- End of comments
155 ***************************************************************************/
156 PROCEDURE Setup_SetAssociation_JSP
157 (p_mode IN VARCHAR2 ,
158 p_set_id IN NUMBER ,
159 p_set_name IN VARCHAR2 ,
160 p_inventory_item_id IN NUMBER ,
161 p_failure_code_required IN VARCHAR2 ,
162 p_effective_end_date IN DATE ,
163 p_stored_last_upd_date IN DATE ,
164 p_created_by IN NUMBER ,
165 p_creation_date IN DATE ,
166 p_last_update_date IN DATE ,
167 p_last_updated_by IN NUMBER ,
168 p_last_update_login IN NUMBER ,
169 x_return_status OUT NOCOPY VARCHAR2,
170 x_msg_count OUT NOCOPY NUMBER ,
171 x_msg_data OUT NOCOPY VARCHAR2
172 );
173
174 /**************************************************************************
175 -- Start of comments
176 -- API name : Lock_SetAssociation_JSP
177 -- Type : Private.
178 -- Function : To lock a failure set association row - called from
179 -- OA Fwk
180 -- Pre-reqs : None.
181 -- Parameters :
182 -- IN : p_set_id IN NUMBER,
183 -- p_item_id IN NUMBER
184 -- p_last_update_date IN DATE
185 -- OUT : x_return_status OUT VARCHAR2(1)
186 -- x_msg_count OUT NUMBER
187 -- x_msg_data OUT VARCHAR2(2000)
188 -- Version : Current version 1.0.
189 -- Initial version 1.0
190 -- End of comments
191 ***************************************************************************/
192 PROCEDURE Lock_SetAssociation_JSP
193 (p_set_id IN NUMBER,
194 p_item_id IN NUMBER,
195 p_last_update_date IN DATE ,
196 x_return_status OUT NOCOPY VARCHAR2,
197 x_msg_count OUT NOCOPY NUMBER ,
198 x_msg_data OUT NOCOPY VARCHAR2
199 );
200
201 END EAM_FailureSets_PVT;