APPS.AHL_PC_HEADERS_PKG dependencies on AHL_PC_HEADERS_B

Line 38: cursor C is select ROWID from AHL_PC_HEADERS_B

34: X_LAST_UPDATE_DATE in DATE,
35: X_LAST_UPDATED_BY in NUMBER,
36: X_LAST_UPDATE_LOGIN in NUMBER
37: ) is
38: cursor C is select ROWID from AHL_PC_HEADERS_B
39: where PC_HEADER_ID = X_PC_HEADER_ID
40: ;
41: begin
42: insert into AHL_PC_HEADERS_B (

Line 42: insert into AHL_PC_HEADERS_B (

38: cursor C is select ROWID from AHL_PC_HEADERS_B
39: where PC_HEADER_ID = X_PC_HEADER_ID
40: ;
41: begin
42: insert into AHL_PC_HEADERS_B (
43: ATTRIBUTE14,
44: ATTRIBUTE15,
45: PC_HEADER_ID,
46: OBJECT_VERSION_NUMBER,

Line 203: from AHL_PC_HEADERS_B

199: ATTRIBUTE4,
200: ATTRIBUTE5,
201: ATTRIBUTE2,
202: ATTRIBUTE3
203: from AHL_PC_HEADERS_B
204: where PC_HEADER_ID = X_PC_HEADER_ID
205: for update of PC_HEADER_ID nowait;
206: recinfo c%rowtype;
207:

Line 322: update AHL_PC_HEADERS_B set

318: X_LAST_UPDATED_BY in NUMBER,
319: X_LAST_UPDATE_LOGIN in NUMBER
320: ) is
321: begin
322: update AHL_PC_HEADERS_B set
323: ATTRIBUTE14 = X_ATTRIBUTE14,
324: ATTRIBUTE15 = X_ATTRIBUTE15,
325: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
326: NAME = X_NAME,

Line 382: delete from AHL_PC_HEADERS_B

378: if (sql%notfound) then
379: raise no_data_found;
380: end if;
381:
382: delete from AHL_PC_HEADERS_B
383: where PC_HEADER_ID = X_PC_HEADER_ID;
384:
385: if (sql%notfound) then
386: raise no_data_found;

Line 396: from AHL_PC_HEADERS_B B

392: begin
393: delete from AHL_PC_HEADERS_TL T
394: where not exists
395: (select NULL
396: from AHL_PC_HEADERS_B B
397: where B.PC_HEADER_ID = T.PC_HEADER_ID
398: );
399:
400: update AHL_PC_HEADERS_TL T set (