DBA Data[Home] [Help]

PACKAGE: APPS.PA_FP_REV_GEN_PUB

Source


1 PACKAGE PA_FP_REV_GEN_PUB AUTHID CURRENT_USER as
2 /* $Header: PAFPGCRS.pls 120.1 2005/09/01 23:55:13 appldev noship $ */
3 
4 PROCEDURE GEN_COST_BASED_REVENUE
5           (P_BUDGET_VERSION_ID   IN           PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
6            P_FP_COLS_REC         IN           PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
7            P_ETC_START_DATE      IN
8               PA_BUDGET_VERSIONS.ETC_START_DATE%TYPE DEFAULT NULL,
9            X_RETURN_STATUS       OUT   NOCOPY VARCHAR2,
10            X_MSG_COUNT           OUT   NOCOPY NUMBER,
11            X_MSG_DATA	         OUT   NOCOPY VARCHAR2);
12 
13 /**
14  * Created as part of fix for Bug 4549862.
15  *
16  * This private procedure is meant to be used by GEN_COST_BASED_REVENUE
17  * when generating a Cost and Revenue together version with source of
18  * Staffing Plan and revenue accrual method of COST.
19  *
20  * This procedure propagates generation data stored in PA_FP_ROLLUP_TMP
21  * and Inserts/Updates it into PA_BUDGET_LINES. This includes txn/pc/pfc
22  * amounts, rate overrides, pc/pfc exchange rates, cost/revenue rate types,
23  * and rejection codes.
24  *
25  * This API should always be called by GEN_COST_BASED_REVENUE before
26  * returning with return status of Success.
27  **/
28 PROCEDURE PUSH_RES_SCH_DATA_TO_BL
29           (P_BUDGET_VERSION_ID   IN           PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
30            P_FP_COLS_REC         IN           PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
31            P_ETC_START_DATE      IN           PA_BUDGET_VERSIONS.ETC_START_DATE%TYPE,
32            P_PLAN_CLASS_CODE     IN           PA_FIN_PLAN_TYPES_B.PLAN_CLASS_CODE%TYPE,
33            X_RETURN_STATUS       OUT   NOCOPY VARCHAR2,
34            X_MSG_COUNT           OUT   NOCOPY NUMBER,
35            X_MSG_DATA            OUT   NOCOPY VARCHAR2);
36 
37 END PA_FP_REV_GEN_PUB;