APPS.AHL_OSP_ORDER_LINES_PKG dependencies on AHL_OSP_ORDER_LINES

Line 1: PACKAGE BODY AHL_OSP_ORDER_LINES_PKG as

1: PACKAGE BODY AHL_OSP_ORDER_LINES_PKG as
2: /* $Header: AHLLOSLB.pls 120.2 2008/01/30 22:20:13 jaramana ship $ */
3: PROCEDURE INSERT_ROW (
4: P_X_OSP_ORDER_LINE_ID IN OUT NOCOPY NUMBER,
5: P_OBJECT_VERSION_NUMBER IN NUMBER,

Line 55: insert into AHL_OSP_ORDER_LINES (

51: ) IS
52:
53:
54: BEGIN
55: insert into AHL_OSP_ORDER_LINES (
56: OSP_ORDER_LINE_ID,
57: OBJECT_VERSION_NUMBER,
58: LAST_UPDATE_DATE,
59: LAST_UPDATED_BY,

Line 217: update AHL_OSP_ORDER_LINES set

213: ) IS
214:
215:
216: BEGIN
217: update AHL_OSP_ORDER_LINES set
218: OSP_ORDER_LINE_ID = P_OSP_ORDER_LINE_ID,
219: OBJECT_VERSION_NUMBER = P_OBJECT_VERSION_NUMBER ,
220: LAST_UPDATE_DATE = P_LAST_UPDATE_DATE,
221: LAST_UPDATED_BY = P_LAST_UPDATED_BY,

Line 289: delete from AHL_OSP_ORDER_LINES

285: ) is
286:
287: BEGIN
288:
289: delete from AHL_OSP_ORDER_LINES
290: where OSP_ORDER_LINE_ID = P_OSP_ORDER_LINE_ID;
291:
292: IF (SQL%NOTFOUND) then
293: RAISE no_data_found;

Line 298: END AHL_OSP_ORDER_LINES_PKG; -- Package spec

294: END IF;
295:
296: END DELETE_ROW;
297:
298: END AHL_OSP_ORDER_LINES_PKG; -- Package spec
299: