APPS.AHL_OSP_ORDER_LOGS_PKG dependencies on AHL_OSP_ORDER_LOGS

Line 1: PACKAGE BODY AHL_OSP_ORDER_LOGS_PKG as

1: PACKAGE BODY AHL_OSP_ORDER_LOGS_PKG as
2: /* $Header: AHLLOOLB.pls 115.2 2002/12/04 23:25:34 sikumar noship $ */
3: PROCEDURE INSERT_ROW (
4: X_OSP_ORDER_LOG_ID IN OUT NOCOPY NUMBER,
5: X_OBJECT_VERSION_NUMBER IN NUMBER,

Line 39: insert into AHL_OSP_ORDER_LOGS (

35: ) IS
36:
37:
38: BEGIN
39: insert into AHL_OSP_ORDER_LOGS (
40: OSP_ORDER_LOG_ID,
41: OBJECT_VERSION_NUMBER,
42: LAST_UPDATE_DATE,
43: LAST_UPDATED_BY,

Line 72: AHL_OSP_ORDER_LOGS_S.NEXTVAL,

68: ATTRIBUTE13,
69: ATTRIBUTE14,
70: ATTRIBUTE15
71: ) values (
72: AHL_OSP_ORDER_LOGS_S.NEXTVAL,
73: X_OBJECT_VERSION_NUMBER,
74: X_LAST_UPDATE_DATE,
75: X_LAST_UPDATED_BY,
76: X_CREATION_DATE,

Line 153: update AHL_OSP_ORDER_LOGS set

149: ) IS
150:
151:
152: BEGIN
153: update AHL_OSP_ORDER_LOGS set
154: OSP_ORDER_LOG_ID = X_OSP_ORDER_LOG_ID,
155: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER ,
156: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
157: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 208: delete from AHL_OSP_ORDER_LOGS

204: ) is
205:
206: BEGIN
207:
208: delete from AHL_OSP_ORDER_LOGS
209: where OSP_ORDER_LOG_ID = X_OSP_ORDER_LOG_ID;
210:
211: IF (SQL%NOTFOUND) then
212: RAISE no_data_found;

Line 218: END AHL_OSP_ORDER_LOGS_PKG; -- Package body

214:
215: END DELETE_ROW;
216:
217:
218: END AHL_OSP_ORDER_LOGS_PKG; -- Package body
219: ----------------------------------------------
220: