[Home] [Help]
PACKAGE: APPS.BOM_ROUTINGREVISION_PVT
Source
1 PACKAGE Bom_RoutingRevision_Pvt AUTHID CURRENT_USER AS
2 -- $Header: BOMVRRVS.pls 115.1 99/07/16 05:17:22 porting ship $
3 -- Start of comments
4 -- API name : AssignRtgRevision
5 -- Type : Private.
6 -- Function : Assign ids based on values
7 -- Pre-reqs : None.
8 -- Parameters :
9 -- IN :
10 -- p_api_version NUMBER Required
11 -- p_init_msg_list VARCHAR2 Optional
12 -- Default = FND_API.G_FALSE
13 -- p_commit VARCHAR2 Optional
14 -- Default = FND_API.G_FALSE
15 -- p_validation_level NUMBER Optional
16 -- Default = FND_API.G_VALID_LEVEL_FULL
17 -- p_RtgRevision_rec RTG_REVISION_REC_TYPE Required
18 -- Default = G_MISS_RTG_REVISION_REC
19 -- OUT :
20 -- x_return_status VARCHAR2(1)
21 -- x_msg_count NUMBER
22 -- x_msg_data VARCHAR2(2000)
23 -- x_RtgRevision_rec RTG_REVISION_REC_TYPE
24 --
25 -- Version : Current version 1.0
26 -- Initial version 1.0
27 --
28 -- Notes :
29 --
30 -- API name : ValidateRtgRevision
31 -- Type : Private.
32 -- Function : Validate Routing Revision record
33 -- Pre-reqs : None.
34 -- Parameters :
35 -- IN :
36 -- p_api_version NUMBER Required
37 -- p_init_msg_list VARCHAR2 Optional
38 -- Default = FND_API.G_FALSE
39 -- p_commit VARCHAR2 Optional
40 -- Default = FND_API.G_FALSE
41 -- p_validation_level NUMBER Optional
42 -- Default = FND_API.G_VALID_LEVEL_FULL
43 -- p_RtgRevision_rec RTG_REVISION_REC_TYPE Required
44 -- Default = G_MISS_RTG_REVISION_REC
45 -- OUT :
46 -- x_return_status VARCHAR2(1)
47 -- x_msg_count NUMBER
48 -- x_msg_data VARCHAR2(2000)
49 -- x_RtgRevision_rec RTG_REVISION_REC_TYPE
50 --
51 -- Version : Current version 1.0
52 -- Initial version 1.0
53 --
54 -- Notes : Full validation includes AssignRtgRevision
55 --
56 -- API name : CreateRtgRevision
57 -- Type : Private.
58 -- Function : Insert row into MTL_RTG_ITEM_REVISIONS
59 -- Pre-reqs : None.
60 -- Parameters :
61 -- IN :
62 -- p_api_version NUMBER Required
63 -- p_init_msg_list VARCHAR2 Optional
64 -- Default = FND_API.G_FALSE
65 -- p_commit VARCHAR2 Optional
66 -- Default = FND_API.G_FALSE
67 -- p_validation_level NUMBER Optional
68 -- Default = FND_API.G_VALID_LEVEL_FULL
69 -- p_RtgRevision_rec RTG_REVISION_REC_TYPE Required
70 -- Default = G_MISS_RTG_REVISION_REC
71 -- OUT :
72 -- x_return_status VARCHAR2(1)
73 -- x_msg_count NUMBER
74 -- x_msg_data VARCHAR2(2000)
75 -- x_RtgRevision_rec RTG_REVISION_REC_TYPE
76 --
77 -- Version : Current version 1.0
78 -- Initial version 1.0
79 --
80 -- Notes : Full validation includes AssignRtgRevision and
81 -- ValidateRtgRevision
82 --
83 -- API name : UpdateRtgRevision
84 -- Type : Private.
85 -- Function : Updates row in MTL_RTG_ITEM_REVISIONS
86 -- Pre-reqs : None.
87 -- Parameters :
88 -- IN :
89 -- p_api_version NUMBER Required
90 -- p_init_msg_list VARCHAR2 Optional
91 -- Default = FND_API.G_FALSE
92 -- p_commit VARCHAR2 Optional
93 -- Default = FND_API.G_FALSE
94 -- p_validation_level NUMBER Optional
95 -- Default = FND_API.G_VALID_LEVEL_FULL
96 -- p_RtgRevision_rec RTG_REVISION_REC_TYPE Required
97 -- Default = G_MISS_RTG_REVISION_REC
98 -- OUT :
99 -- x_return_status VARCHAR2(1)
100 -- x_msg_count NUMBER
101 -- x_msg_data VARCHAR2(2000)
102 -- x_RtgRevision_rec RTG_REVISION_REC_TYPE
103 --
104 -- Version : Current version 1.0
105 -- Initial version 1.0
106 --
107 -- Notes : Full validation includes AssignRtgRevision and
108 -- ValidateRtgRevision
109 --
110 -- API name : DeleteRtgRevision
111 -- Type : Private.
112 -- Function : Deletes row from MTL_RTG_ITEM_REVISIONS
113 -- Pre-reqs : None.
114 -- Parameters :
115 -- IN :
116 -- p_api_version NUMBER Required
117 -- p_init_msg_list VARCHAR2 Optional
118 -- Default = FND_API.G_FALSE
119 -- p_commit VARCHAR2 Optional
120 -- Default = FND_API.G_FALSE
121 -- p_validation_level NUMBER Optional
122 -- Default = FND_API.G_VALID_LEVEL_FULL
123 -- p_RtgRevision_rec RTG_REVISION_REC_TYPE Required
124 -- Default = G_MISS_RTG_REVISION_REC
125 -- OUT :
126 -- x_return_status VARCHAR2(1)
127 -- x_msg_count NUMBER
128 -- x_msg_data VARCHAR2(2000)
129 -- x_RtgRevision_rec RTG_REVISION_REC_TYPE
130 --
131 -- Version : Current version 1.0
132 -- Initial version 1.0
133 --
134 -- Notes : Full validation includes AssignRtgRevision
135 --
136 -- End of comments
137 TYPE rtg_revision_rec_type is record(
138 inventory_item_id NUMBER := Fnd_Api.G_Miss_Num,
139 inventory_item_number VARCHAR2(81) := Fnd_Api.G_Miss_Char,
140 organization_id NUMBER := Fnd_Api.G_Miss_Num,
141 organization_code VARCHAR2(3) := Fnd_Api.G_Miss_Char,
142 process_revision VARCHAR2(3) := Fnd_Api.G_Miss_Char,
143 change_notice VARCHAR2(10) := Fnd_Api.G_Miss_Char,
144 ecn_initiation_date DATE := Fnd_Api.G_Miss_Date,
145 implementation_date DATE := Fnd_Api.G_Miss_Date,
146 implemented_serial_number VARCHAR2(30) := Fnd_Api.G_Miss_Char,
147 effectivity_date DATE := Fnd_Api.G_Miss_Date,
148 attribute_category VARCHAR2(30) := Fnd_Api.G_Miss_Char,
149 attribute1 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
150 attribute2 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
151 attribute3 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
152 attribute4 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
153 attribute5 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
154 attribute6 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
155 attribute7 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
156 attribute8 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
157 attribute9 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
158 attribute10 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
159 attribute11 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
160 attribute12 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
161 attribute13 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
162 attribute14 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
163 attribute15 VARCHAR2(150) := Fnd_Api.G_Miss_Char
164 );
165
166 G_MISS_RTG_REVISION_REC rtg_revision_rec_type;
167 G_VALID_LEVEL_NO_ASSIGN constant number := 5;
168
169 PROCEDURE AssignRtgRevision(
170 p_api_version IN NUMBER,
171 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
172 p_commit IN VARCHAR2 := FND_API.G_FALSE,
173 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
174 x_return_status OUT VARCHAR2,
175 x_msg_count OUT NUMBER,
176 x_msg_data OUT VARCHAR2,
177 p_RtgRevision_rec IN RTG_REVISION_REC_TYPE :=
178 G_MISS_RTG_REVISION_REC,
179 x_RtgRevision_rec OUT RTG_REVISION_REC_TYPE
180 );
181 PROCEDURE ValidateRtgRevision(
182 p_api_version IN NUMBER,
183 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
184 p_commit IN VARCHAR2 := FND_API.G_FALSE,
185 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
186 x_return_status OUT VARCHAR2,
187 x_msg_count OUT NUMBER,
188 x_msg_data OUT VARCHAR2,
189 p_RtgRevision_rec IN RTG_REVISION_REC_TYPE :=
190 G_MISS_RTG_REVISION_REC,
191 x_RtgRevision_rec OUT RTG_REVISION_REC_TYPE
192 );
193 PROCEDURE CreateRtgRevision(
194 p_api_version IN NUMBER,
195 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
196 p_commit IN VARCHAR2 := FND_API.G_FALSE,
197 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
198 x_return_status OUT VARCHAR2,
199 x_msg_count OUT NUMBER,
200 x_msg_data OUT VARCHAR2,
201 p_RtgRevision_rec IN RTG_REVISION_REC_TYPE :=
202 G_MISS_RTG_REVISION_REC,
203 x_RtgRevision_rec OUT RTG_REVISION_REC_TYPE
204 );
205 PROCEDURE UpdateRtgRevision(
206 p_api_version IN NUMBER,
207 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
208 p_commit IN VARCHAR2 := FND_API.G_FALSE,
209 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
210 x_return_status OUT VARCHAR2,
211 x_msg_count OUT NUMBER,
212 x_msg_data OUT VARCHAR2,
213 p_RtgRevision_rec IN RTG_REVISION_REC_TYPE :=
214 G_MISS_RTG_REVISION_REC,
215 x_RtgRevision_rec OUT RTG_REVISION_REC_TYPE
216 );
217 PROCEDURE DeleteRtgRevision(
218 p_api_version IN NUMBER,
219 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
220 p_commit IN VARCHAR2 := FND_API.G_FALSE,
221 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
222 x_return_status OUT VARCHAR2,
223 x_msg_count OUT NUMBER,
224 x_msg_data OUT VARCHAR2,
225 p_RtgRevision_rec IN RTG_REVISION_REC_TYPE :=
226 G_MISS_RTG_REVISION_REC,
227 x_RtgRevision_rec OUT RTG_REVISION_REC_TYPE
228 );
229
230 END Bom_RoutingRevision_Pvt;