APPS.AHL_WORKORDER_MTL_TXNS_PKG dependencies on AHL_WORKORDER_MTL_TXNS

Line 1: package body AHL_WORKORDER_MTL_TXNS_PKG as

1: package body AHL_WORKORDER_MTL_TXNS_PKG as
2: /* $Header: AHLLWMTB.pls 120.0 2005/05/26 01:44:29 appldev noship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out nocopy VARCHAR2,
5: X_WORKORDER_MTL_TXN_ID Out Nocopy NUMBER,

Line 50: INSERT INTO AHL_WORKORDER_MTL_TXNS (

46: X_LAST_UPDATE_LOGIN in NUMBER)
47: is
48: begin
49:
50: INSERT INTO AHL_WORKORDER_MTL_TXNS (
51: WORKORDER_MTL_TXN_ID,
52: OBJECT_VERSION_NUMBER,
53: LAST_UPDATE_DATE,
54: LAST_UPDATED_BY,

Line 94: AHL_WORKORDER_MTL_TXNS_S.NextVal,

90: ATTRIBUTE13,
91: ATTRIBUTE14,
92: ATTRIBUTE15)
93: VALUES (
94: AHL_WORKORDER_MTL_TXNS_S.NextVal,
95: X_OBJECT_VERSION_NUMBER,
96: X_LAST_UPDATE_DATE,
97: X_LAST_UPDATED_BY,
98: X_CREATION_DATE,

Line 179: from AHL_WORKORDER_MTL_TXNS

175: ATTRIBUTE12,
176: ATTRIBUTE13,
177: ATTRIBUTE14,
178: ATTRIBUTE15
179: from AHL_WORKORDER_MTL_TXNS
180: where WORKORDER_MTL_TXN_ID = X_WORKORDER_MTL_TXN_ID
181: for update of WORKORDER_MTL_TXN_ID nowait;
182: recinfo c%rowtype;
183:

Line 277: update AHL_WORKORDER_MTL_TXNS set

273: X_LAST_UPDATED_BY in NUMBER,
274: X_LAST_UPDATE_LOGIN in NUMBER)
275: is
276: begin
277: update AHL_WORKORDER_MTL_TXNS set
278: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
279: ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
280: ATTRIBUTE1 = X_ATTRIBUTE1,
281: ATTRIBUTE2 = X_ATTRIBUTE2,

Line 311: delete from AHL_WORKORDER_MTL_TXNS

307: X_WORKORDER_MTL_TXN_ID in NUMBER
308: ) is
309: begin
310:
311: delete from AHL_WORKORDER_MTL_TXNS
312: where WORKORDER_MTL_TXN_ID = X_WORKORDER_MTL_TXN_ID;
313:
314: if (sql%notfound) then
315: raise no_data_found;

Line 320: end AHL_WORKORDER_MTL_TXNS_PKG;

316: end if;
317: end DELETE_ROW;
318:
319:
320: end AHL_WORKORDER_MTL_TXNS_PKG;