APPS.AHL_SNAPSHOTS_PKG dependencies on AHL_SNAPSHOTS

Line 1: PACKAGE BODY AHL_SNAPSHOTS_PKG as

1: PACKAGE BODY AHL_SNAPSHOTS_PKG as
2: /* $Header: AHLLSNPB.pls 115.1 2003/10/23 19:19:54 sikumar noship $ */
3: PROCEDURE INSERT_ROW (
4: X_SNAPSHOT_ID IN NUMBER,
5: X_OBJECT_VERSION_NUMBER IN NUMBER,

Line 37: INSERT INTO AHL_SNAPSHOTS (

33: X_ATTRIBUTE14 IN VARCHAR2,
34: X_ATTRIBUTE15 IN VARCHAR2
35: ) IS
36: BEGIN
37: INSERT INTO AHL_SNAPSHOTS (
38: SNAPSHOT_ID,
39: OBJECT_VERSION_NUMBER,
40: SNAPSHOT_NUMBER,
41: LAST_UPDATE_DATE,

Line 139: UPDATE AHL_SNAPSHOTS SET

135: X_ATTRIBUTE14 IN VARCHAR2,
136: X_ATTRIBUTE15 IN VARCHAR2
137: ) IS
138: BEGIN
139: UPDATE AHL_SNAPSHOTS SET
140: VISIT_ID = X_VISIT_ID,
141: VISIT_TASK_ID = X_VISIT_TASK_ID,
142: SNAPSHOT_NUMBER = X_SNAPSHOT_NUMBER,
143: --CREATION_DATE = X_CREATION_DATE,

Line 183: DELETE FROM AHL_SNAPSHOTS

179: PROCEDURE DELETE_ROW (
180: X_SNAPSHOT_ID IN NUMBER
181: ) IS
182: BEGIN
183: DELETE FROM AHL_SNAPSHOTS
184: WHERE SNAPSHOT_ID = X_SNAPSHOT_ID;
185:
186: IF (SQL%NOTFOUND) THEN
187: RAISE NO_DATA_FOUND;

Line 192: END AHL_SNAPSHOTS_PKG;

188: END IF;
189:
190: END DELETE_ROW;
191:
192: END AHL_SNAPSHOTS_PKG;