[Home] [Help]
PACKAGE: APPS.BOM_OPRESOURCE_PVT
Source
1 PACKAGE Bom_OpResource_Pvt AS
2 -- $Header: BOMVRESS.pls 120.1.12010000.2 2008/11/14 16:43:46 snandana ship $
3 -- Start of comments
4 -- API name : AssignResource
5 -- Type : Private.
6 -- Function : Populates Ids from 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_resource_rec RESOURCE_REC_TYPE Required
18 -- Default = G_MISS_RESOURCE_REC
19 -- OUT :
20 -- x_return_status VARCHAR2(1)
21 -- x_msg_count NUMBER
22 -- x_msg_data VARCHAR2(2000)
23 -- x_resource_rec RESOURCE_REC_TYPE
24 --
25 -- Version : Current version 1.0
26 -- Initial version 1.0
27 --
28 -- Notes : Note text
29 --
30 -- API name : ValidateResource
31 -- Type : Private.
32 -- Function : Validates Operation Resource 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_resource_rec RESOURCE_REC_TYPE Required
44 -- Default = G_MISS_RESOURCE_REC
45 -- OUT :
46 -- x_return_status VARCHAR2(1)
47 -- x_msg_count NUMBER
48 -- x_msg_data VARCHAR2(2000)
49 -- x_resource_rec RESOURCE_REC_TYPE
50 --
51 -- Version : Current version 1.0
52 -- Initial version 1.0
53 --
54 -- Notes : Full Validation includes AssignResource
55 --
56 -- API name : CreateResource
57 -- Type : Private.
58 -- Function : Inserts row into Bom Operation Resources
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_resource_rec RESOURCE_REC_TYPE Required
70 -- Default = G_MISS_RESOURCE_REC
71 -- OUT :
72 -- x_return_status VARCHAR2(1)
73 -- x_msg_count NUMBER
74 -- x_msg_data VARCHAR2(2000)
75 -- x_resource_rec RESOURCE_REC_TYPE
76 --
77 -- Version : Current version 1.0
78 -- Initial version 1.0
79 --
80 -- Notes : Full Validation includes AssignResource and
81 -- ValidateResource
82 --
83 -- API name : UpdateResource
84 -- Type : Private.
85 -- Function : Updates row in Bom Operation Resources
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_resource_rec RESOURCE_REC_TYPE Required
97 -- Default = G_MISS_RESOURCE_REC
98 -- OUT :
99 -- x_return_status VARCHAR2(1)
100 -- x_msg_count NUMBER
101 -- x_msg_data VARCHAR2(2000)
102 -- x_resource_rec RESOURCE_REC_TYPE
103 --
104 -- Version : Current version 1.0
105 -- Initial version 1.0
106 --
107 -- Notes : Full Validation includes AssignResource and
108 -- ValidateResource
109 --
110 -- API name : DeleteResource
111 -- Type : Private.
112 -- Function : Deletes row from Bom Operation Resources
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_resource_rec RESOURCE_REC_TYPE Required
124 -- Default = G_MISS_RESOURCE_REC
125 -- OUT :
126 -- x_return_status VARCHAR2(1)
127 -- x_msg_count NUMBER
128 -- x_msg_data VARCHAR2(2000)
129 -- x_resource_rec RESOURCE_REC_TYPE
130 --
131 -- Version : Current version 1.0
132 -- Initial version 1.0
133 --
134 -- Notes : Full Validation includes AssignResource
135 --
136 -- End of comments
137 TYPE resource_rec_type is record(
138 operation_sequence_id NUMBER := Fnd_Api.G_Miss_Num,
139 routing_sequence_id NUMBER := Fnd_Api.G_Miss_Num,
140 assembly_item_id NUMBER := Fnd_Api.G_Miss_Num,
141 assembly_item_number VARCHAR2(81) := Fnd_Api.G_Miss_Char,
142 organization_id NUMBER := Fnd_Api.G_Miss_Num,
143 organization_code VARCHAR2(3) := Fnd_Api.G_Miss_Char,
144 alternate_routing_designator VARCHAR2(10) := Fnd_Api.G_Miss_Char,
145 operation_seq_num NUMBER := Fnd_Api.G_Miss_Num,
146 effectivity_date DATE := Fnd_Api.G_Miss_Date,
147 resource_seq_num NUMBER := Fnd_Api.G_Miss_Num,
148 new_resource_seq_num NUMBER := Fnd_Api.G_Miss_Num,
149 resource_id NUMBER := Fnd_Api.G_Miss_Num,
150 resource_code VARCHAR2(10) := Fnd_Api.G_Miss_Char,
151 activity_id NUMBER := Fnd_Api.G_Miss_Num,
152 activity VARCHAR2(10) := Fnd_Api.G_Miss_Char,
153 standard_rate_flag NUMBER := Fnd_Api.G_Miss_Num,
154 assigned_units NUMBER := Fnd_Api.G_Miss_Num,
155 usage_rate_or_amount NUMBER := Fnd_Api.G_Miss_Num,
156 usage_rate_or_amount_inverse NUMBER := Fnd_Api.G_Miss_Num,
157 basis_type NUMBER := Fnd_Api.G_Miss_Num,
158 schedule_flag NUMBER := Fnd_Api.G_Miss_Num,
159 resource_offset_percent NUMBER := Fnd_Api.G_Miss_Num,
160 autocharge_type NUMBER := Fnd_Api.G_Miss_Num,
161 attribute_category VARCHAR2(30) := Fnd_Api.G_Miss_Char,
162 attribute1 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
163 attribute2 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
164 attribute3 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
165 attribute4 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
166 attribute5 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
167 attribute6 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
168 attribute7 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
169 attribute8 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
170 attribute9 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
171 attribute10 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
172 attribute11 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
173 attribute12 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
174 attribute13 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
175 attribute14 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
176 attribute15 VARCHAR2(150) := Fnd_Api.G_Miss_Char,
177 Principle_flag Number := Fnd_Api.G_Miss_Num,
178 schedule_seq_num Number := Fnd_Api.G_Miss_Num
179 );
180
181 G_MISS_RESOURCE_REC RESOURCE_REC_TYPE;
182 G_VALID_LEVEL_NO_ASSIGN constant number := 5;
183 G_round_off_val number :=NVL(FND_PROFILE.VALUE('BOM:ROUND_OFF_VALUE'),6); /* Bug 7322996 */
184
185 PROCEDURE AssignResource(
186 p_api_version IN NUMBER,
187 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
188 p_commit IN VARCHAR2 := FND_API.G_FALSE,
189 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
190 x_return_status IN OUT NOCOPY VARCHAR2,
191 x_msg_count IN OUT NOCOPY NUMBER,
192 x_msg_data IN OUT NOCOPY VARCHAR2,
193 p_resource_rec IN RESOURCE_REC_TYPE := G_MISS_RESOURCE_REC,
194 x_resource_rec IN OUT NOCOPY RESOURCE_REC_TYPE
195 );
196 PROCEDURE ValidateResource(
197 p_api_version IN NUMBER,
198 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
199 p_commit IN VARCHAR2 := FND_API.G_FALSE,
200 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
201 x_return_status IN OUT NOCOPY VARCHAR2,
202 x_msg_count IN OUT NOCOPY NUMBER,
203 x_msg_data IN OUT NOCOPY VARCHAR2,
204 p_resource_rec IN RESOURCE_REC_TYPE := G_MISS_RESOURCE_REC,
205 x_resource_rec IN OUT NOCOPY RESOURCE_REC_TYPE
206 );
207 PROCEDURE CreateResource(
208 p_api_version IN NUMBER,
209 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
210 p_commit IN VARCHAR2 := FND_API.G_FALSE,
211 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
212 x_return_status IN OUT NOCOPY VARCHAR2,
213 x_msg_count IN OUT NOCOPY NUMBER,
214 x_msg_data IN OUT NOCOPY VARCHAR2,
215 p_resource_rec IN RESOURCE_REC_TYPE := G_MISS_RESOURCE_REC,
216 x_resource_rec IN OUT NOCOPY RESOURCE_REC_TYPE
217 );
218 PROCEDURE UpdateResource(
219 p_api_version IN NUMBER,
220 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
221 p_commit IN VARCHAR2 := FND_API.G_FALSE,
222 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
223 x_return_status IN OUT NOCOPY VARCHAR2,
224 x_msg_count IN OUT NOCOPY NUMBER,
225 x_msg_data IN OUT NOCOPY VARCHAR2,
226 p_resource_rec IN RESOURCE_REC_TYPE := G_MISS_RESOURCE_REC,
227 x_resource_rec IN OUT NOCOPY RESOURCE_REC_TYPE
228 );
229 PROCEDURE DeleteResource(
230 p_api_version IN NUMBER,
231 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
232 p_commit IN VARCHAR2 := FND_API.G_FALSE,
233 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
234 x_return_status IN OUT NOCOPY VARCHAR2,
235 x_msg_count IN OUT NOCOPY NUMBER,
236 x_msg_data IN OUT NOCOPY VARCHAR2,
237 p_resource_rec IN RESOURCE_REC_TYPE := G_MISS_RESOURCE_REC,
238 x_resource_rec IN OUT NOCOPY RESOURCE_REC_TYPE
239 );
240 END Bom_OpResource_Pvt;