APPS.AHL_UF_DETAILS_PKG dependencies on AHL_UF_DETAILS

Line 1: PACKAGE BODY AHL_UF_DETAILS_PKG as

1: PACKAGE BODY AHL_UF_DETAILS_PKG as
2: /* $Header: AHLLUFDB.pls 115.1 2002/12/04 22:45:55 sracha noship $ */
3: PROCEDURE INSERT_ROW (
4: X_UF_DETAIL_ID IN OUT NOCOPY NUMBER,
5: X_OBJECT_VERSION_NUMBER IN NUMBER,

Line 36: insert into AHL_UF_DETAILS (

32: ) IS
33:
34:
35: BEGIN
36: insert into AHL_UF_DETAILS (
37: UF_DETAIL_ID,
38: OBJECT_VERSION_NUMBER,
39: CREATED_BY,
40: CREATION_DATE,

Line 66: AHL_UF_DETAILS_S.NEXTVAL,

62: ATTRIBUTE13,
63: ATTRIBUTE14,
64: ATTRIBUTE15
65: ) values (
66: AHL_UF_DETAILS_S.NEXTVAL,
67: X_OBJECT_VERSION_NUMBER,
68: X_CREATED_BY,
69: X_CREATION_DATE,
70: X_LAST_UPDATED_BY,

Line 144: update AHL_UF_DETAILS set

140: ) IS
141:
142:
143: BEGIN
144: update AHL_UF_DETAILS set
145: UF_DETAIL_ID = X_UF_DETAIL_ID,
146: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
147: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
148: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 186: delete from AHL_UF_DETAILS

182: ) is
183:
184: BEGIN
185:
186: delete from AHL_UF_DETAILS
187: where UF_DETAIL_ID = X_UF_DETAIL_ID;
188:
189: IF (SQL%NOTFOUND) then
190: RAISE no_data_found;

Line 195: END AHL_UF_DETAILS_PKG;

191: END IF;
192:
193: END DELETE_ROW;
194:
195: END AHL_UF_DETAILS_PKG;