APPS.AHL_PRD_DISPOSITIONS_B_H_PKG dependencies on AHL_PRD_DISPOSITIONS_B_H

Line 1: package body AHL_PRD_DISPOSITIONS_B_H_PKG as

1: package body AHL_PRD_DISPOSITIONS_B_H_PKG as
2: /* $Header: AHLLDSHB.pls 120.0 2005/05/26 00:06:19 appldev noship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out nocopy VARCHAR2,
5: X_DISPOSITION_H_ID in NUMBER,

Line 51: cursor C is select ROWID from AHL_PRD_DISPOSITIONS_B_H

47: X_LAST_UPDATE_DATE in DATE,
48: X_LAST_UPDATED_BY in NUMBER,
49: X_LAST_UPDATE_LOGIN in NUMBER
50: ) is
51: cursor C is select ROWID from AHL_PRD_DISPOSITIONS_B_H
52: where DISPOSITION_H_ID = X_DISPOSITION_H_ID
53: ;
54: begin
55: insert into AHL_PRD_DISPOSITIONS_B_H (

Line 55: insert into AHL_PRD_DISPOSITIONS_B_H (

51: cursor C is select ROWID from AHL_PRD_DISPOSITIONS_B_H
52: where DISPOSITION_H_ID = X_DISPOSITION_H_ID
53: ;
54: begin
55: insert into AHL_PRD_DISPOSITIONS_B_H (
56: DISPOSITION_H_ID,
57: DISPOSITION_ID,
58: OBJECT_VERSION_NUMBER,
59: WORKORDER_ID,

Line 268: from AHL_PRD_DISPOSITIONS_B_H

264: ATTRIBUTE12,
265: ATTRIBUTE13,
266: ATTRIBUTE14,
267: ATTRIBUTE15
268: from AHL_PRD_DISPOSITIONS_B_H
269: where DISPOSITION_H_ID = X_DISPOSITION_H_ID
270: for update of DISPOSITION_H_ID nowait;
271: recinfo c%rowtype;
272:

Line 430: update AHL_PRD_DISPOSITIONS_B_H set

426: X_LAST_UPDATED_BY in NUMBER,
427: X_LAST_UPDATE_LOGIN in NUMBER
428: ) is
429: begin
430: update AHL_PRD_DISPOSITIONS_B_H set
431: DISPOSITION_ID = X_DISPOSITION_ID,
432: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
433: WORKORDER_ID = X_WORKORDER_ID,
434: PART_CHANGE_ID = X_PART_CHANGE_ID,

Line 503: delete from AHL_PRD_DISPOSITIONS_B_H

499: if (sql%notfound) then
500: raise no_data_found;
501: end if;
502:
503: delete from AHL_PRD_DISPOSITIONS_B_H
504: where DISPOSITION_H_ID = X_DISPOSITION_H_ID;
505:
506: if (sql%notfound) then
507: raise no_data_found;

Line 517: from AHL_PRD_DISPOSITIONS_B_H B

513: begin
514: delete from AHL_PRD_DISPOSITIONS_TL_H T
515: where not exists
516: (select NULL
517: from AHL_PRD_DISPOSITIONS_B_H B
518: where B.DISPOSITION_H_ID = T.DISPOSITION_H_ID
519: );
520:
521: update AHL_PRD_DISPOSITIONS_TL_H T set (

Line 574: end AHL_PRD_DISPOSITIONS_B_H_PKG;

570: where T.DISPOSITION_H_ID = B.DISPOSITION_H_ID
571: and T.LANGUAGE = L.LANGUAGE_CODE);
572: end ADD_LANGUAGE;
573:
574: end AHL_PRD_DISPOSITIONS_B_H_PKG;