58: AND event_type_code = x_event_type_code
59: ;
60:
61: BEGIN
62: xla_utility_pkg.trace('> .insert_row' ,20);
63:
64: INSERT INTO xla_prod_acct_headers
65: (creation_date
66: ,created_by
107: RAISE NO_DATA_FOUND;
108: END IF;
109: CLOSE c;
110:
111: xla_utility_pkg.trace('< .insert_row' ,20);
112: END insert_row;
113:
114: /*======================================================================+
115: | |
154:
155: recinfo c%ROWTYPE;
156:
157: BEGIN
158: xla_utility_pkg.trace('> .lock_row' ,20);
159:
160: OPEN c;
161: FETCH c INTO recinfo;
162:
183: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
184: app_exception.raise_exception;
185: END IF;
186:
187: xla_utility_pkg.trace('< .lock_row' ,20);
188: RETURN;
189:
190: END lock_row;
191:
211: ,x_last_update_login IN NUMBER)
212: IS
213:
214: BEGIN
215: xla_utility_pkg.trace('> .update_row' ,20);
216: UPDATE xla_prod_acct_headers
217: SET
218: last_update_date = x_last_update_date
219: ,validation_status_code = x_validation_status_code
232: IF (SQL%NOTFOUND) THEN
233: RAISE NO_DATA_FOUND;
234: END IF;
235:
236: xla_utility_pkg.trace('< .update_row' ,20);
237: END update_row;
238:
239: /*======================================================================+
240: | |
257: ,x_last_update_login IN NUMBER)
258: IS
259:
260: BEGIN
261: xla_utility_pkg.trace('> .update_row' ,20);
262: UPDATE xla_prod_acct_headers
263: SET
264: last_update_date = x_last_update_date
265: ,description_type_code = x_description_type_code
277: IF (SQL%NOTFOUND) THEN
278: RAISE NO_DATA_FOUND;
279: END IF;
280:
281: xla_utility_pkg.trace('< .update_row' ,20);
282: END update_row;
283:
284: /*======================================================================+
285: | |
297:
298: IS
299:
300: BEGIN
301: xla_utility_pkg.trace('> .delete_row' ,20);
302: DELETE FROM xla_prod_acct_headers
303: WHERE application_id = x_application_id
304: AND amb_context_code = x_amb_context_code
305: AND product_rule_type_code = x_product_rule_type_code
312: IF (SQL%NOTFOUND) THEN
313: RAISE NO_DATA_FOUND;
314: END IF;
315:
316: xla_utility_pkg.trace('< .delete_row' ,20);
317: END delete_row;
318:
319: /*======================================================================+
320: | |
357:
358: recinfo c%ROWTYPE;
359:
360: BEGIN
361: xla_utility_pkg.trace('> .lock_row' ,20);
362:
363: OPEN c;
364: FETCH c INTO recinfo;
365:
389: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
390: app_exception.raise_exception;
391: END IF;
392:
393: xla_utility_pkg.trace('< .lock_row' ,20);
394: RETURN;
395:
396: END lock_row;
397: