DBA Data[Home] [Help]

PACKAGE: APPS.PA_RES_ASG_CURRENCY_PUB

Source


1 PACKAGE PA_RES_ASG_CURRENCY_PUB AUTHID CURRENT_USER as
2 /* $Header: PAFPRBCS.pls 120.1 2007/02/06 10:10:17 dthakker noship $ */
3 
4 -- Public P_CALLING_MODULE values
5 -- NOTE: When adding new calling modules below, the IS_PUBLIC_CALLING_MODULE()
6 --       function in PAFPRBCB.pls needs to be updated with the new module as well.
7 G_BUDGET_GENERATION            CONSTANT VARCHAR2(30) := 'BUDGET_GENERATION';
8 G_FORECAST_GENERATION          CONSTANT VARCHAR2(30) := 'FORECAST_GENERATION';
9 G_CALCULATE_API                CONSTANT VARCHAR2(30) := 'CALCULATE_API';
10 G_UPDATE_PLAN_TRANSACTION      CONSTANT VARCHAR2(30) := 'UPDATE_PLAN_TRANSACTION';
11 G_WORKPLAN                     CONSTANT VARCHAR2(30) := 'WORKPLAN';
12 G_AMG_API                      CONSTANT VARCHAR2(30) := 'AMG_API';
13 G_WEBADI                       CONSTANT VARCHAR2(30) := 'WEBADI';
14 G_CHANGE_MGT                   CONSTANT VARCHAR2(30) := 'CHANGE_MGT';
15 G_COPY_PLAN                    CONSTANT VARCHAR2(30) := 'COPY_PLAN';
16 G_UPGRADE                      CONSTANT VARCHAR2(30) := 'UPGRADE';
17 
18 -- Valid P_COPY_MODE values
19 G_COPY_ALL                     CONSTANT VARCHAR2(30) := 'COPY_ALL';
20 G_COPY_OVERRIDES               CONSTANT VARCHAR2(30) := 'COPY_OVERRIDES';
21 
22 PROCEDURE MAINTAIN_DATA
23         ( P_FP_COLS_REC                  IN           PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
24           P_CALLING_MODULE               IN           VARCHAR2,
25           P_DELETE_FLAG                  IN           VARCHAR2 DEFAULT 'N',
26           P_COPY_FLAG                    IN           VARCHAR2 DEFAULT 'N',
27           P_SRC_VERSION_ID               IN           PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE DEFAULT NULL,
28           P_COPY_MODE                    IN           VARCHAR2 DEFAULT 'COPY_OVERRIDES',
29           P_ROLLUP_FLAG                  IN           VARCHAR2 DEFAULT 'N',
30           P_VERSION_LEVEL_FLAG           IN           VARCHAR2 DEFAULT 'N',
31           P_CALLED_MODE                  IN           VARCHAR2 DEFAULT 'SELF_SERVICE',
32           X_RETURN_STATUS                OUT NOCOPY   VARCHAR2,
33           X_MSG_COUNT                    OUT NOCOPY   NUMBER,
34           X_MSG_DATA                     OUT NOCOPY   VARCHAR2);
35 
36 END PA_RES_ASG_CURRENCY_PUB;