APPS.AHL_PRD_DISPOSITIONS_PKG dependencies on AHL_PRD_DISPOSITIONS_B

Line 50: cursor C is select ROWID from AHL_PRD_DISPOSITIONS_B

46: X_LAST_UPDATE_DATE in DATE,
47: X_LAST_UPDATED_BY in NUMBER,
48: X_LAST_UPDATE_LOGIN in NUMBER
49: ) is
50: cursor C is select ROWID from AHL_PRD_DISPOSITIONS_B
51: where DISPOSITION_ID = X_DISPOSITION_ID
52: ;
53: begin
54: insert into AHL_PRD_DISPOSITIONS_B (

Line 54: insert into AHL_PRD_DISPOSITIONS_B (

50: cursor C is select ROWID from AHL_PRD_DISPOSITIONS_B
51: where DISPOSITION_ID = X_DISPOSITION_ID
52: ;
53: begin
54: insert into AHL_PRD_DISPOSITIONS_B (
55: DISPOSITION_ID,
56: OBJECT_VERSION_NUMBER,
57: WORKORDER_ID,
58: PART_CHANGE_ID,

Line 261: from AHL_PRD_DISPOSITIONS_B

257: ATTRIBUTE12,
258: ATTRIBUTE13,
259: ATTRIBUTE14,
260: ATTRIBUTE15
261: from AHL_PRD_DISPOSITIONS_B
262: where DISPOSITION_ID = X_DISPOSITION_ID
263: for update of DISPOSITION_ID nowait;
264: recinfo c%rowtype;
265:

Line 421: update AHL_PRD_DISPOSITIONS_B set

417: X_LAST_UPDATED_BY in NUMBER,
418: X_LAST_UPDATE_LOGIN in NUMBER
419: ) is
420: begin
421: update AHL_PRD_DISPOSITIONS_B set
422: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
423: WORKORDER_ID = X_WORKORDER_ID,
424: PART_CHANGE_ID = X_PART_CHANGE_ID,
425: PATH_POSITION_ID = X_PATH_POSITION_ID,

Line 493: delete from AHL_PRD_DISPOSITIONS_B

489: if (sql%notfound) then
490: raise no_data_found;
491: end if;
492:
493: delete from AHL_PRD_DISPOSITIONS_B
494: where DISPOSITION_ID = X_DISPOSITION_ID;
495:
496: if (sql%notfound) then
497: raise no_data_found;

Line 507: from AHL_PRD_DISPOSITIONS_B B

503: begin
504: delete from AHL_PRD_DISPOSITIONS_TL T
505: where not exists
506: (select NULL
507: from AHL_PRD_DISPOSITIONS_B B
508: where B.DISPOSITION_ID = T.DISPOSITION_ID
509: );
510:
511: update AHL_PRD_DISPOSITIONS_TL T set (