1 PACKAGE OZF_Related_Lines_PVT AUTHID CURRENT_USER AS
2 /* $Header: ozfvords.pls 120.0 2005/05/31 23:34:10 appldev noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- OZF_Related_Lines_PVT
7 -- Purpose
8 --
9 -- History
10 --
11 -- NOTE
12 --
13 -- End of Comments
14 -- ===============================================================
15
16 -- Default number of records fetch per call
17 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
18 --===================================================================
19 -- Start of Comments
20 -- -------------------------------------------------------
21 -- Record name
22 -- related_lines_rec_type
23 -- -------------------------------------------------------
24 -- Parameters:
25 -- related_deal_lines_id
26 -- modifier_id
27 -- related_modifier_id
28 -- last_update_date
29 -- last_updated_by
30 -- creation_date
31 -- created_by
32 -- last_update_login
33 -- object_version_number
34 -- security_group_id
35 -- estimated_qty_is_max
36 -- estimated_amount_is_max
37 -- estimated_qty
38 -- estimated_amount
39 -- qp_list_header_id
40 -- estimate_qty_uom
41 --
42 -- Required
43 --
44 -- Defaults
45 --
46 -- Note: This is automatic generated record definition, it includes all columns
47 -- defined in the table, developer must manually add or delete some of the attributes.
48 --
49 -- End of Comments
50
51 --===================================================================
52 TYPE related_lines_rec_type IS RECORD
53 (
54 related_deal_lines_id NUMBER ,
55 modifier_id NUMBER ,
56 related_modifier_id NUMBER ,
57 last_update_date DATE ,
58 last_updated_by NUMBER ,
59 creation_date DATE ,
60 created_by NUMBER ,
61 last_update_login NUMBER ,
62 object_version_number NUMBER ,
63 --security_group_id NUMBER ,
64 estimated_qty_is_max VARCHAR2(1) ,
65 estimated_amount_is_max VARCHAR2(1) ,
66 estimated_qty NUMBER ,
67 estimated_amount NUMBER ,
68 qp_list_header_id NUMBER ,
69 estimate_qty_uom VARCHAR2(3)
70 );
71
72 g_miss_related_lines_rec related_lines_rec_type;
73 TYPE related_lines_tbl_type IS TABLE OF related_lines_rec_type INDEX BY BINARY_INTEGER;
74 g_miss_related_lines_tbl related_lines_tbl_type;
75
76 -- ==============================================================================
77 -- Start of Comments
78 -- ==============================================================================
79 -- API Name
80 -- Create_Related_Lines
81 -- Type
82 -- Private
83 -- Pre-Req
84 --
85 -- Parameters
86 --
87 -- IN
88 -- p_api_version_number IN NUMBER Required
89 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
90 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
91 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
92 -- p_related_lines_rec IN related_lines_rec_type Required
93 --
94 -- OUT
95 -- x_return_status OUT VARCHAR2
96 -- x_msg_count OUT NUMBER
97 -- x_msg_data OUT VARCHAR2
98 -- Version : Current version 1.0
99 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
100 -- and basic operation, developer must manually add parameters and business logic as necessary.
101 --
102 -- End of Comments
103 -- ==============================================================================
104 --
105
106 PROCEDURE Create_Related_Lines(
107 p_api_version_number IN NUMBER,
108 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
109 p_commit IN VARCHAR2 := FND_API.G_FALSE,
110 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
111
112 x_return_status OUT NOCOPY VARCHAR2,
113 x_msg_count OUT NOCOPY NUMBER,
114 x_msg_data OUT NOCOPY VARCHAR2,
115
116 p_related_lines_rec IN related_lines_rec_type := g_miss_related_lines_rec,
117 x_related_deal_lines_id OUT NOCOPY NUMBER
118 );
119
120 -- ==============================================================================
121 -- Start of Comments
122 -- ==============================================================================
123 -- API Name
124 -- Update_Related_Lines
125 -- Type
126 -- Private
127 -- Pre-Req
128 --
129 -- Parameters
130 --
131 -- IN
132 -- p_api_version_number IN NUMBER Required
133 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
134 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
135 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
136 -- p_related_lines_rec IN related_lines_rec_type Required
137 --
138 -- OUT
139 -- x_return_status OUT VARCHAR2
140 -- x_msg_count OUT NUMBER
141 -- x_msg_data OUT VARCHAR2
142 -- Version : Current version 1.0
143 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
144 -- and basic operation, developer must manually add parameters and business logic as necessary.
145 --
146 -- End of Comments
147 -- ==============================================================================
148 --
149
150 PROCEDURE Update_Related_Lines(
151 p_api_version_number IN NUMBER,
152 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
153 p_commit IN VARCHAR2 := FND_API.G_FALSE,
154 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
155
156 x_return_status OUT NOCOPY VARCHAR2,
157 x_msg_count OUT NOCOPY NUMBER,
158 x_msg_data OUT NOCOPY VARCHAR2,
159
160 p_related_lines_rec IN related_lines_rec_type,
161 x_object_version_number OUT NOCOPY NUMBER
162 );
163
164 -- ==============================================================================
165 -- Start of Comments
166 -- ==============================================================================
167 -- API Name
168 -- Delete_Related_Lines
169 -- Type
170 -- Private
171 -- Pre-Req
172 --
173 -- Parameters
174 --
175 -- IN
176 -- p_api_version_number IN NUMBER Required
177 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
178 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
179 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
180 -- p_RELATED_DEAL_LINES_ID IN NUMBER
181 -- p_object_version_number IN NUMBER Optional Default = NULL
182 --
183 -- OUT
184 -- x_return_status OUT VARCHAR2
185 -- x_msg_count OUT NUMBER
186 -- x_msg_data OUT VARCHAR2
187 -- Version : Current version 1.0
188 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
189 -- and basic operation, developer must manually add parameters and business logic as necessary.
190 --
191 -- End of Comments
192 -- ==============================================================================
193 --
194
195 PROCEDURE Delete_Related_Lines(
196 p_api_version_number IN NUMBER,
197 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
198 p_commit IN VARCHAR2 := FND_API.G_FALSE,
199 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
200 x_return_status OUT NOCOPY VARCHAR2,
201 x_msg_count OUT NOCOPY NUMBER,
202 x_msg_data OUT NOCOPY VARCHAR2,
203 p_related_deal_lines_id IN NUMBER,
204 p_object_version_number IN NUMBER
205 );
206
207 -- ==============================================================================
208 -- Start of Comments
209 -- ==============================================================================
210 -- API Name
211 -- Lock_Related_Lines
212 -- Type
213 -- Private
214 -- Pre-Req
215 --
216 -- Parameters
217 --
218 -- IN
219 -- p_api_version_number IN NUMBER Required
220 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
221 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
222 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
223 -- p_related_lines_rec IN related_lines_rec_type Required
224 --
225 -- OUT
226 -- x_return_status OUT VARCHAR2
227 -- x_msg_count OUT NUMBER
228 -- x_msg_data OUT VARCHAR2
229 -- Version : Current version 1.0
230 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
231 -- and basic operation, developer must manually add parameters and business logic as necessary.
232 --
233 -- End of Comments
234 -- ==============================================================================
235 --
236
237 PROCEDURE Lock_Related_Lines(
238 p_api_version_number IN NUMBER,
239 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
240
241 x_return_status OUT NOCOPY VARCHAR2,
242 x_msg_count OUT NOCOPY NUMBER,
243 x_msg_data OUT NOCOPY VARCHAR2,
244
245 p_related_deal_lines_id IN NUMBER,
246 p_object_version IN NUMBER
247 );
248
249
250 -- Start of Comments
251 --
252 -- validation procedures
253 --
254 -- p_validation_mode is a constant defined in OZF_UTILITY_PVT package
255 -- For create: G_CREATE, for update: G_UPDATE
256 -- Note: 1. This is automated generated item level validation procedure.
257 -- The actual validation detail is needed to be added.
258 -- 2. We can also validate table instead of record. There will be an option for user to choose.
259 -- End of Comments
260
261 PROCEDURE Validate_related_lines(
262 p_api_version_number IN NUMBER,
263 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
264 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
265 p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_update,
266 p_related_lines_rec IN related_lines_rec_type,
267 x_return_status OUT NOCOPY VARCHAR2,
268 x_msg_count OUT NOCOPY NUMBER,
269 x_msg_data OUT NOCOPY VARCHAR2
270 );
271
272 -- Start of Comments
273 --
274 -- validation procedures
275 --
276 -- p_validation_mode is a constant defined in OZF_UTILITY_PVT package
277 -- For create: G_CREATE, for update: G_UPDATE
278 -- Note: 1. This is automated generated item level validation procedure.
279 -- The actual validation detail is needed to be added.
280 -- 2. Validate the unique keys, lookups here
281 -- End of Comments
282
283 PROCEDURE Check_related_lines_Items (
284 P_related_lines_rec IN related_lines_rec_type,
285 p_validation_mode IN VARCHAR2,
286 x_return_status OUT NOCOPY VARCHAR2
287 );
288
289 -- Start of Comments
290 --
291 -- Record level validation procedures
292 --
293 -- p_validation_mode is a constant defined in OZF_UTILITY_PVT package
294 -- For create: G_CREATE, for update: G_UPDATE
295 -- Note: 1. This is automated generated item level validation procedure.
296 -- The actual validation detail is needed to be added.
297 -- 2. Developer can manually added inter-field level validation.
298 -- End of Comments
299
300 PROCEDURE Validate_related_lines_rec(
301 p_api_version_number IN NUMBER,
302 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
303 x_return_status OUT NOCOPY VARCHAR2,
304 x_msg_count OUT NOCOPY NUMBER,
305 x_msg_data OUT NOCOPY VARCHAR2,
306 p_related_lines_rec IN related_lines_rec_type
307 );
308 END OZF_Related_Lines_PVT;