APPS.AHL_UF_HEADERS_PKG dependencies on AHL_UF_HEADERS

Line 1: PACKAGE BODY AHL_UF_HEADERS_PKG as

1: PACKAGE BODY AHL_UF_HEADERS_PKG as
2: /* $Header: AHLLUFHB.pls 115.3 2002/12/04 23:24:58 sikumar noship $ */
3: PROCEDURE INSERT_ROW (
4: X_UF_HEADER_ID IN OUT NOCOPY NUMBER,
5: X_OBJECT_VERSION_NUMBER IN NUMBER,

Line 37: insert into AHL_UF_HEADERS (

33: ) IS
34:
35:
36: BEGIN
37: insert into AHL_UF_HEADERS (
38: UF_HEADER_ID,
39: OBJECT_VERSION_NUMBER,
40: CREATED_BY,
41: CREATION_DATE,

Line 68: AHL_UF_HEADERS_S.NEXTVAL,

64: ATTRIBUTE13,
65: ATTRIBUTE14,
66: ATTRIBUTE15
67: ) values (
68: AHL_UF_HEADERS_S.NEXTVAL,
69: X_OBJECT_VERSION_NUMBER,
70: X_CREATED_BY,
71: X_CREATION_DATE,
72: X_LAST_UPDATED_BY,

Line 137: update AHL_UF_HEADERS set

133: ) IS
134:
135:
136: BEGIN
137: update AHL_UF_HEADERS set
138: UF_HEADER_ID = X_UF_HEADER_ID,
139: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
140: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
141: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 180: delete from AHL_UF_HEADERS

176: ) is
177:
178: BEGIN
179:
180: delete from AHL_UF_HEADERS
181: where UF_HEADER_ID = X_UF_HEADER_ID;
182:
183: IF (SQL%NOTFOUND) then
184: RAISE no_data_found;

Line 189: END AHL_UF_HEADERS_PKG;

185: END IF;
186:
187: END DELETE_ROW;
188:
189: END AHL_UF_HEADERS_PKG;