APPS.AHL_PC_NODES_PKG dependencies on AHL_PC_NODES_B

Line 38: cursor C is select ROWID from AHL_PC_NODES_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_NODES_B
39: where PC_NODE_ID = X_PC_NODE_ID
40: ;
41: begin
42: insert into AHL_PC_NODES_B (

Line 42: insert into AHL_PC_NODES_B (

38: cursor C is select ROWID from AHL_PC_NODES_B
39: where PC_NODE_ID = X_PC_NODE_ID
40: ;
41: begin
42: insert into AHL_PC_NODES_B (
43: ATTRIBUTE11,
44: ATTRIBUTE12,
45: ATTRIBUTE13,
46: ATTRIBUTE14,

Line 203: from AHL_PC_NODES_B

199: ATTRIBUTE8,
200: ATTRIBUTE9,
201: ATTRIBUTE10,
202: PC_HEADER_ID
203: from AHL_PC_NODES_B
204: where PC_NODE_ID = X_PC_NODE_ID
205: for update of PC_NODE_ID nowait;
206: recinfo c%rowtype;
207:

Line 323: update AHL_PC_NODES_B set

319: X_LAST_UPDATED_BY in NUMBER,
320: X_LAST_UPDATE_LOGIN in NUMBER
321: ) is
322: begin
323: update AHL_PC_NODES_B set
324: ATTRIBUTE11 = X_ATTRIBUTE11,
325: ATTRIBUTE12 = X_ATTRIBUTE12,
326: ATTRIBUTE13 = X_ATTRIBUTE13,
327: ATTRIBUTE14 = X_ATTRIBUTE14,

Line 383: delete from AHL_PC_NODES_B

379: if (sql%notfound) then
380: raise no_data_found;
381: end if;
382:
383: delete from AHL_PC_NODES_B
384: where PC_NODE_ID = X_PC_NODE_ID;
385:
386: if (sql%notfound) then
387: raise no_data_found;

Line 397: from AHL_PC_NODES_B B

393: begin
394: delete from AHL_PC_NODES_TL T
395: where not exists
396: (select NULL
397: from AHL_PC_NODES_B B
398: where B.PC_NODE_ID = T.PC_NODE_ID
399: );
400:
401: update AHL_PC_NODES_TL T set (