APPS.AS_FORECAST_WORKSHEETS_PKG dependencies on AS_FORECAST_WORKSHEETS

Line 1: PACKAGE BODY AS_FORECAST_WORKSHEETS_PKG as

1: PACKAGE BODY AS_FORECAST_WORKSHEETS_PKG as
2: /* $Header: asxtfwsb.pls 115.9 2004/01/13 10:08:34 gbatra ship $ */
3:
4: -- Start of Comments
5: -- Package name : AS_FORECAST_WORKSHEETS_PKG

Line 5: -- Package name : AS_FORECAST_WORKSHEETS_PKG

1: PACKAGE BODY AS_FORECAST_WORKSHEETS_PKG as
2: /* $Header: asxtfwsb.pls 115.9 2004/01/13 10:08:34 gbatra ship $ */
3:
4: -- Start of Comments
5: -- Package name : AS_FORECAST_WORKSHEETS_PKG
6: -- Purpose :
7: -- History :
8: -- NOTE :
9: -- End of Comments

Line 12: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AS_FORECAST_WORKSHEETS_PKG';

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

Line 65: CURSOR C2 IS SELECT AS_FORECAST_WORKSHEETS_S.nextval FROM sys.dual;

61: p_ACTIVE_FLAG VARCHAR2,
62: p_FORECAST_CATEGORY_ID NUMBER)
63:
64: IS
65: CURSOR C2 IS SELECT AS_FORECAST_WORKSHEETS_S.nextval FROM sys.dual;
66: BEGIN
67: If (px_FORECAST_WORKSHEET_ID IS NULL) OR (px_FORECAST_WORKSHEET_ID = FND_API.G_MISS_NUM) then
68: OPEN C2;
69: FETCH C2 INTO px_FORECAST_WORKSHEET_ID;

Line 72: INSERT INTO AS_FORECAST_WORKSHEETS(

68: OPEN C2;
69: FETCH C2 INTO px_FORECAST_WORKSHEET_ID;
70: CLOSE C2;
71: End If;
72: INSERT INTO AS_FORECAST_WORKSHEETS(
73: FORECAST_WORKSHEET_ID,
74: CREATED_BY,
75: CREATION_DATE,
76: LAST_UPDATED_BY,

Line 221: Update AS_FORECAST_WORKSHEETS

217: p_FORECAST_CATEGORY_ID NUMBER)
218:
219: IS
220: BEGIN
221: Update AS_FORECAST_WORKSHEETS
222: SET object_version_number = nvl(object_version_number,0) + 1,
223:
224: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
225: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),

Line 332: DELETE FROM AS_FORECAST_WORKSHEETS

328: PROCEDURE Delete_Row(
329: p_FORECAST_WORKSHEET_ID NUMBER)
330: IS
331: BEGIN
332: DELETE FROM AS_FORECAST_WORKSHEETS
333: WHERE FORECAST_WORKSHEET_ID = p_FORECAST_WORKSHEET_ID;
334: If (SQL%NOTFOUND) then
335: RAISE NO_DATA_FOUND;
336: End If;

Line 391: FROM AS_FORECAST_WORKSHEETS

387:
388: IS
389: CURSOR C IS
390: SELECT *
391: FROM AS_FORECAST_WORKSHEETS
392: WHERE FORECAST_WORKSHEET_ID = p_FORECAST_WORKSHEET_ID
393: FOR UPDATE of FORECAST_WORKSHEET_ID NOWAIT;
394: Recinfo C%ROWTYPE;
395: BEGIN

Line 552: End AS_FORECAST_WORKSHEETS_PKG;

548: APP_EXCEPTION.RAISE_EXCEPTION;
549: End If;
550: END Lock_Row;
551:
552: End AS_FORECAST_WORKSHEETS_PKG;
553: