APPS.AS_INTERNAL_FORECASTS_PKG dependencies on AS_INTERNAL_FORECASTS

Line 1: PACKAGE BODY AS_INTERNAL_FORECASTS_PKG as

1: PACKAGE BODY AS_INTERNAL_FORECASTS_PKG as
2: /* $Header: asxtifob.pls 115.7 2004/01/13 10:08:37 gbatra ship $ */
3: -- Start of Comments
4: -- Package name : AS_INTERNAL_FORECASTS_PKG
5: -- Purpose :

Line 4: -- Package name : AS_INTERNAL_FORECASTS_PKG

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

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

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

Line 74: CURSOR C2 IS SELECT AS_INTERNAL_FORECASTS_S.nextval FROM sys.dual;

70: p_ACTIVE_FLAG VARCHAR2,
71: p_FORECAST_CATEGORY_ID NUMBER)
72:
73: IS
74: CURSOR C2 IS SELECT AS_INTERNAL_FORECASTS_S.nextval FROM sys.dual;
75: BEGIN
76: If (px_FORECAST_ID IS NULL) OR (px_FORECAST_ID = FND_API.G_MISS_NUM) then
77: OPEN C2;
78: FETCH C2 INTO px_FORECAST_ID;

Line 85: INSERT INTO AS_INTERNAL_FORECASTS(

81: /*Bug# 1503400 requires that original forecast id should be forecast id
82: and not null*/
83:
84:
85: INSERT INTO AS_INTERNAL_FORECASTS(
86: FORECAST_ID,
87: CREATED_BY,
88: CREATION_DATE,
89: LAST_UPDATED_BY,

Line 264: Update AS_INTERNAL_FORECASTS

260: p_FORECAST_CATEGORY_ID NUMBER)
261:
262: IS
263: BEGIN
264: Update AS_INTERNAL_FORECASTS
265: SET object_version_number = nvl(object_version_number,0) + 1,
266: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
267: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
268: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),

Line 398: DELETE FROM AS_INTERNAL_FORECASTS

394: PROCEDURE Delete_Row(
395: p_FORECAST_ID NUMBER)
396: IS
397: BEGIN
398: DELETE FROM AS_INTERNAL_FORECASTS
399: WHERE FORECAST_ID = p_FORECAST_ID;
400: If (SQL%NOTFOUND) then
401: RAISE NO_DATA_FOUND;
402: End If;

Line 467: FROM AS_INTERNAL_FORECASTS

463:
464: IS
465: CURSOR C IS
466: SELECT *
467: FROM AS_INTERNAL_FORECASTS
468: WHERE FORECAST_ID = p_FORECAST_ID
469: FOR UPDATE of FORECAST_ID NOWAIT;
470: Recinfo C%ROWTYPE;
471: BEGIN

Line 658: End AS_INTERNAL_FORECASTS_PKG;

654: APP_EXCEPTION.RAISE_EXCEPTION;
655: End If;
656: END Lock_Row;
657:
658: End AS_INTERNAL_FORECASTS_PKG;