PACKAGE: APPS.AS_FORECAST_ACTUALS_PKG

Source

1 PACKAGE AS_FORECAST_ACTUALS_PKG AUTHID CURRENT_USER as
2 /* $Header: asxtfacs.pls 115.3 2002/11/06 00:52:52 appldev ship $ */
3 -- Start of Comments
4 -- Package name     : AS_FORECAST_ACTUALS_PKG
5 -- Purpose          :
6 -- History          :
7 -- NOTE             :
8 -- End of Comments
9 
10 PROCEDURE Insert_Row(
11           px_FORECAST_ACTUAL_ID   IN OUT NUMBER,
12           p_CREATED_BY    NUMBER,
13           p_CREATION_DATE    DATE,
14           p_LAST_UPDATED_BY    NUMBER,
15           p_LAST_UPDATE_DATE    DATE,
16           p_LAST_UPDATE_LOGIN    NUMBER,
17           p_REQUEST_ID    NUMBER,
18           p_PROGRAM_APPLICATION_ID    NUMBER,
19           p_PROGRAM_ID    NUMBER,
20           p_PROGRAM_UPDATE_DATE    DATE,
21           p_SALESFORCE_ID    NUMBER,
22           p_SALES_GROUP_ID    NUMBER,
23           p_PERIOD_NAME    VARCHAR2,
24           p_CURRENCY_CODE    VARCHAR2,
25           p_ALLOCATED_BUDGET_AMOUNT    NUMBER,
26           p_ACTUAL_REVENUE_AMOUNT    NUMBER);
27 
28 PROCEDURE Update_Row(
29           p_FORECAST_ACTUAL_ID    NUMBER,
30           p_CREATED_BY    NUMBER,
31           p_CREATION_DATE    DATE,
32           p_LAST_UPDATED_BY    NUMBER,
33           p_LAST_UPDATE_DATE    DATE,
34           p_LAST_UPDATE_LOGIN    NUMBER,
35           p_REQUEST_ID    NUMBER,
36           p_PROGRAM_APPLICATION_ID    NUMBER,
37           p_PROGRAM_ID    NUMBER,
38           p_PROGRAM_UPDATE_DATE    DATE,
39           p_SALESFORCE_ID    NUMBER,
40           p_SALES_GROUP_ID    NUMBER,
41           p_PERIOD_NAME    VARCHAR2,
42           p_CURRENCY_CODE    VARCHAR2,
43           p_ALLOCATED_BUDGET_AMOUNT    NUMBER,
44           p_ACTUAL_REVENUE_AMOUNT    NUMBER);
45 
46 PROCEDURE Lock_Row(
47           p_FORECAST_ACTUAL_ID    NUMBER,
48           p_CREATED_BY    NUMBER,
49           p_CREATION_DATE    DATE,
50           p_LAST_UPDATED_BY    NUMBER,
51           p_LAST_UPDATE_DATE    DATE,
52           p_LAST_UPDATE_LOGIN    NUMBER,
53           p_REQUEST_ID    NUMBER,
54           p_PROGRAM_APPLICATION_ID    NUMBER,
55           p_PROGRAM_ID    NUMBER,
56           p_PROGRAM_UPDATE_DATE    DATE,
57           p_SALESFORCE_ID    NUMBER,
58           p_SALES_GROUP_ID    NUMBER,
59           p_PERIOD_NAME    VARCHAR2,
60           p_CURRENCY_CODE    VARCHAR2,
61           p_ALLOCATED_BUDGET_AMOUNT    NUMBER,
62           p_ACTUAL_REVENUE_AMOUNT    NUMBER);
63 
64 PROCEDURE Delete_Row(
65     p_FORECAST_ACTUAL_ID  NUMBER);
66 End AS_FORECAST_ACTUALS_PKG;