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;