APPS.AHL_SCHEDULE_MATERIALS_PKG dependencies on AHL_SCHEDULE_MATERIALS

Line 1: package body AHL_SCHEDULE_MATERIALS_PKG as

1: package body AHL_SCHEDULE_MATERIALS_PKG as
2: /* $Header: AHLLSMTB.pls 120.0.12020000.2 2012/12/06 22:41:15 sareepar ship $ */
3: PROCEDURE INSERT_ROW (
4: X_SCHEDULED_MATERIAL_ID IN NUMBER,
5: X_OBJECT_VERSION_NUMBER IN NUMBER,

Line 63: INSERT INTO AHL_SCHEDULE_MATERIALS(

59: ) IS
60:
61: BEGIN
62:
63: INSERT INTO AHL_SCHEDULE_MATERIALS(
64: SCHEDULED_MATERIAL_ID,
65: OBJECT_VERSION_NUMBER,
66: LAST_UPDATE_DATE,
67: LAST_UPDATED_BY,

Line 122: AHL_SCHEDULE_MATERIALS_S.NEXTVAL,

118: --sukhwsin: SB Effectivity Code changes - ends
119: )
120: VALUES
121: (
122: AHL_SCHEDULE_MATERIALS_S.NEXTVAL,
123: X_OBJECT_VERSION_NUMBER,
124: X_LAST_UPDATE_DATE,
125: X_LAST_UPDATED_BY,
126: X_CREATION_DATE,

Line 239: UPDATE AHL_SCHEDULE_MATERIALS SET

235: X_POSITION_KEY IN NUMBER
236: --sukhwsin: SB Effectivity Code changes - ends
237: ) IS
238: BEGIN
239: UPDATE AHL_SCHEDULE_MATERIALS SET
240: SCHEDULED_MATERIAL_ID = X_SCHEDULED_MATERIAL_ID,
241: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER + 1,
242: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
243: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 308: DELETE AHL_SCHEDULE_MATERIALS

304: PROCEDURE DELETE_ROW (
305: X_SCHEDULED_MATERIAL_ID IN NUMBER
306: ) IS
307: BEGIN
308: DELETE AHL_SCHEDULE_MATERIALS
309: WHERE SCHEDULED_MATERIAL_ID = X_SCHEDULED_MATERIAL_ID;
310:
311: IF (SQL%NOTFOUND) THEN
312: RAISE NO_DATA_FOUND;

Line 317: END AHL_SCHEDULE_MATERIALS_PKG;

313: END IF;
314:
315: END DELETE_ROW;
316:
317: END AHL_SCHEDULE_MATERIALS_PKG;