APPS.AS_LEAD_OBSTACLES_PKG dependencies on AS_LEAD_OBSTACLES

Line 1: PACKAGE BODY AS_LEAD_OBSTACLES_PKG as

1: PACKAGE BODY AS_LEAD_OBSTACLES_PKG as
2: /* $Header: asxtobsb.pls 115.6 2004/01/13 10:08:44 gbatra ship $ */
3: -- Start of Comments
4: -- Package name : AS_LEAD_OBSTACLES_PKG
5: -- Purpose :

Line 4: -- Package name : AS_LEAD_OBSTACLES_PKG

1: PACKAGE BODY AS_LEAD_OBSTACLES_PKG as
2: /* $Header: asxtobsb.pls 115.6 2004/01/13 10:08:44 gbatra ship $ */
3: -- Start of Comments
4: -- Package name : AS_LEAD_OBSTACLES_PKG
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

Line 11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AS_LEAD_OBSTACLES_PKG';

7: -- NOTE :
8: -- End of Comments
9:
10:
11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AS_LEAD_OBSTACLES_PKG';
12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'asxtobsb.pls';
13:
14: PROCEDURE Insert_Row(
15: px_LEAD_OBSTACLE_ID IN OUT NOCOPY NUMBER,

Line 48: CURSOR C2 IS SELECT AS_LEAD_OBSTACLES_S.nextval FROM sys.dual;

44: p_ATTRIBUTE14 VARCHAR2,
45: p_ATTRIBUTE15 VARCHAR2)
46:
47: IS
48: CURSOR C2 IS SELECT AS_LEAD_OBSTACLES_S.nextval FROM sys.dual;
49: BEGIN
50: If (px_LEAD_OBSTACLE_ID IS NULL) OR (px_LEAD_OBSTACLE_ID = FND_API.G_MISS_NUM) then
51: OPEN C2;
52: FETCH C2 INTO px_LEAD_OBSTACLE_ID;

Line 55: INSERT INTO AS_LEAD_OBSTACLES(

51: OPEN C2;
52: FETCH C2 INTO px_LEAD_OBSTACLE_ID;
53: CLOSE C2;
54: End If;
55: INSERT INTO AS_LEAD_OBSTACLES(
56: LEAD_OBSTACLE_ID,
57: LAST_UPDATE_DATE,
58: LAST_UPDATED_BY,
59: CREATION_DATE,

Line 161: Update AS_LEAD_OBSTACLES

157: )
158:
159: IS
160: BEGIN
161: Update AS_LEAD_OBSTACLES
162: SET object_version_number = nvl(object_version_number,0) + 1,
163: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
164: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
165: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),

Line 206: DELETE FROM AS_LEAD_OBSTACLES

202: PROCEDURE Delete_Row(
203: p_LEAD_OBSTACLE_ID NUMBER)
204: IS
205: BEGIN
206: DELETE FROM AS_LEAD_OBSTACLES
207: WHERE LEAD_OBSTACLE_ID = p_LEAD_OBSTACLE_ID;
208: If (SQL%NOTFOUND) then
209: RAISE NO_DATA_FOUND;
210: End If;

Line 251: FROM AS_LEAD_OBSTACLES

247:
248: IS
249: CURSOR C IS
250: SELECT *
251: FROM AS_LEAD_OBSTACLES
252: WHERE LEAD_OBSTACLE_ID = p_LEAD_OBSTACLE_ID
253: FOR UPDATE of LEAD_OBSTACLE_ID NOWAIT;
254: Recinfo C%ROWTYPE;
255: BEGIN

Line 367: End AS_LEAD_OBSTACLES_PKG;

363: APP_EXCEPTION.RAISE_EXCEPTION;
364: End If;
365: END Lock_Row;
366:
367: End AS_LEAD_OBSTACLES_PKG;