APPS.AS_FORECAST_ACTUALS_PKG dependencies on AS_FORECAST_ACTUALS

Line 1: PACKAGE BODY AS_FORECAST_ACTUALS_PKG as

1: PACKAGE BODY AS_FORECAST_ACTUALS_PKG as
2: /* $Header: asxtfacb.pls 115.4 2002/11/06 00:52:47 appldev ship $ */
3: -- Start of Comments
4: -- Package name : AS_FORECAST_ACTUALS_PKG
5: -- Purpose :

Line 4: -- Package name : AS_FORECAST_ACTUALS_PKG

1: PACKAGE BODY AS_FORECAST_ACTUALS_PKG as
2: /* $Header: asxtfacb.pls 115.4 2002/11/06 00:52:47 appldev ship $ */
3: -- Start of Comments
4: -- Package name : AS_FORECAST_ACTUALS_PKG
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

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

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

Line 33: CURSOR C2 IS SELECT AS_FORECAST_ACTUALS_S.nextval FROM sys.dual;

29: p_ALLOCATED_BUDGET_AMOUNT NUMBER,
30: p_ACTUAL_REVENUE_AMOUNT NUMBER)
31:
32: IS
33: CURSOR C2 IS SELECT AS_FORECAST_ACTUALS_S.nextval FROM sys.dual;
34: BEGIN
35: If (px_FORECAST_ACTUAL_ID IS NULL) OR (px_FORECAST_ACTUAL_ID = FND_API.G_MISS_NUM) then
36: OPEN C2;
37: FETCH C2 INTO px_FORECAST_ACTUAL_ID;

Line 40: INSERT INTO AS_FORECAST_ACTUALS(

36: OPEN C2;
37: FETCH C2 INTO px_FORECAST_ACTUAL_ID;
38: CLOSE C2;
39: End If;
40: INSERT INTO AS_FORECAST_ACTUALS(
41: FORECAST_ACTUAL_ID,
42: CREATED_BY,
43: CREATION_DATE,
44: LAST_UPDATED_BY,

Line 96: Update AS_FORECAST_ACTUALS

92: p_ACTUAL_REVENUE_AMOUNT NUMBER)
93:
94: IS
95: BEGIN
96: Update AS_FORECAST_ACTUALS
97: SET
98: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
99: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
100: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),

Line 124: DELETE FROM AS_FORECAST_ACTUALS

120: PROCEDURE Delete_Row(
121: p_FORECAST_ACTUAL_ID NUMBER)
122: IS
123: BEGIN
124: DELETE FROM AS_FORECAST_ACTUALS
125: WHERE FORECAST_ACTUAL_ID = p_FORECAST_ACTUAL_ID;
126: If (SQL%NOTFOUND) then
127: RAISE NO_DATA_FOUND;
128: End If;

Line 152: FROM AS_FORECAST_ACTUALS

148:
149: IS
150: CURSOR C IS
151: SELECT *
152: FROM AS_FORECAST_ACTUALS
153: WHERE FORECAST_ACTUAL_ID = p_FORECAST_ACTUAL_ID
154: FOR UPDATE of FORECAST_ACTUAL_ID NOWAIT;
155: Recinfo C%ROWTYPE;
156: BEGIN

Line 220: End AS_FORECAST_ACTUALS_PKG;

216: APP_EXCEPTION.RAISE_EXCEPTION;
217: End If;
218: END Lock_Row;
219:
220: End AS_FORECAST_ACTUALS_PKG;