APPS.AS_FORECAST_ACTUAL_PKG dependencies on AS_FORECAST_ACTUALS

Line 31: INSERT INTO AS_FORECAST_ACTUALS(

27: p_forecast_category_id in NUMBER,
28: p_credit_type_id in NUMBER)
29: IS
30: BEGIN
31: INSERT INTO AS_FORECAST_ACTUALS(
32: FORECAST_ACTUAL_ID,
33: SALESFORCE_ID,
34: SALES_GROUP_ID,
35: PERIOD_NAME,

Line 51: AS_FORECAST_ACTUALS_S.NEXTVAL,

47: PROGRAM_UPDATE_DATE,
48: FORECAST_CATEGORY_ID,
49: FORECAST_CREDIT_TYPE_ID
50: ) VALUES (
51: AS_FORECAST_ACTUALS_S.NEXTVAL,
52: decode( p_SALESFORCE_ID, FND_API.G_MISS_NUM, NULL, 0, NULL, p_SALESFORCE_ID),
53: decode( p_SALES_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_SALES_GROUP_ID),
54: decode( p_PERIOD_NAME, FND_API.G_MISS_CHAR, NULL, p_PERIOD_NAME),
55: decode( p_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_CURRENCY_CODE),

Line 88: Update AS_FORECAST_ACTUALS

84: p_SECURITY_GROUP_ID in NUMBER
85: )
86: IS
87: BEGIN
88: Update AS_FORECAST_ACTUALS
89: SET
90: CURRENCY_CODE = decode( p_CURRENCY_CODE, FND_API.G_MISS_CHAR, CURRENCY_CODE, p_CURRENCY_CODE),
91: ALLOCATED_BUDGET_AMOUNT = round(decode( p_ALLOCATED_BUDGET_AMOUNT, FND_API.G_MISS_NUM, ALLOCATED_BUDGET_AMOUNT, NULL, 0, p_ALLOCATED_BUDGET_AMOUNT),4),
92: ACTUAL_REVENUE_AMOUNT = round(decode( p_ACTUAL_REVENUE_AMOUNT, FND_API.G_MISS_NUM, ACTUAL_REVENUE_AMOUNT, NULL, 0, p_ACTUAL_REVENUE_AMOUNT),4),

Line 110: DELETE FROM AS_FORECAST_ACTUALS

106: PROCEDURE Delete_Row(
107: p_FORECAST_ACTUAL_ID in NUMBER)
108: IS
109: BEGIN
110: DELETE FROM AS_FORECAST_ACTUALS
111: WHERE FORECAST_ACTUAL_ID = p_FORECAST_ACTUAL_ID;
112: If (SQL%NOTFOUND) then
113: RAISE NO_DATA_FOUND;
114: End If;

Line 138: FROM AS_FORECAST_ACTUALS

134: p_SECURITY_GROUP_ID in NUMBER)
135: IS
136: CURSOR C IS
137: SELECT *
138: FROM AS_FORECAST_ACTUALS
139: WHERE FORECAST_ACTUAL_ID = p_FORECAST_ACTUAL_ID
140: FOR UPDATE of FORECAST_ACTUAL_ID NOWAIT;
141: Recinfo C%ROWTYPE;
142: BEGIN

Line 388: FROM AS_FORECAST_ACTUALS

384: BEGIN
385: IF l_salesforce_id IS NOT NULL THEN
386: SELECT forecast_actual_id
387: INTO l_forecast_actual_id
388: FROM AS_FORECAST_ACTUALS
389: WHERE SALESFORCE_ID = l_salesforce_id
390: AND SALES_GROUP_ID = l_sales_group_id
391: AND FORECAST_CATEGORY_ID = l_forecast_category_id
392: AND FORECAST_CREDIT_TYPE_ID = l_credit_type_id

Line 397: FROM AS_FORECAST_ACTUALS

393: AND PERIOD_NAME = p_period_name;
394: ELSE
395: SELECT forecast_actual_id
396: INTO l_forecast_actual_id
397: FROM AS_FORECAST_ACTUALS
398: WHERE SALES_GROUP_ID = l_sales_group_id
399: AND FORECAST_CATEGORY_ID = l_forecast_category_id
400: AND FORECAST_CREDIT_TYPE_ID = l_credit_type_id
401: AND PERIOD_NAME = p_period_name