[Home] [Help]
PACKAGE: APPS.PA_FP_GEN_BILLING_AMOUNTS
Source
1 PACKAGE PA_FP_GEN_BILLING_AMOUNTS as
2 /* $Header: PAFPGABS.pls 120.1 2005/07/26 18:05:18 appldev noship $ */
3
4 FUNCTION GET_EVENT_DATE(P_EVENT_DATE IN DATE,
5 P_ETC_START_DATE IN DATE,
6 P_PLAN_CLASS_CODE IN VARCHAR2)
7 RETURN DATE;
8
9 PROCEDURE CONVERT_TXN_AMT_TO_PC_PFC
10 (P_PROJECT_ID IN NUMBER,
11 P_BUDGET_VERSION_ID IN NUMBER,
12 P_RES_ASG_ID IN NUMBER,
13 P_START_DATE IN DATE,
14 P_END_DATE IN DATE,
15 P_CURRENCY_CODE IN VARCHAR2,
16 P_TXN_REV_AMOUNT IN NUMBER,
17 P_TXN_RAW_COST IN NUMBER,
18 P_TXN_BURDENED_COST IN NUMBER,
19 X_PROJFUNC_RAW_COST OUT NOCOPY NUMBER,
20 X_PROJFUNC_BURDENED_COST OUT NOCOPY NUMBER,
21 X_PROJFUNC_REVENUE OUT NOCOPY NUMBER,
22 X_PROJFUNC_REJECTION OUT NOCOPY VARCHAR2,
23 X_PROJ_RAW_COST OUT NOCOPY NUMBER,
24 X_PROJ_BURDENED_COST OUT NOCOPY NUMBER,
25 X_PROJ_REVENUE OUT NOCOPY NUMBER,
26 X_PROJ_REJECTION OUT NOCOPY VARCHAR2,
27 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
28 X_MSG_COUNT OUT NOCOPY NUMBER,
29 X_MSG_DATA OUT NOCOPY VARCHAR2);
30
31 PROCEDURE GEN_BILLING_AMOUNTS
32 (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
33 P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
34 P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
35 P_ETC_START_DATE IN
36 PA_BUDGET_VERSIONS.ETC_START_DATE%TYPE DEFAULT NULL,
37 PX_GEN_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
38 PX_DELETED_RES_ASG_ID_TAB IN OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
39 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
40 X_MSG_COUNT OUT NOCOPY NUMBER,
41 X_MSG_DATA OUT NOCOPY VARCHAR2);
42
43 PROCEDURE GET_BILLING_EVENT_AMT_IN_PFC
44 (P_PROJECT_ID IN pa_projects_all.project_id%type,
45 P_BUDGET_VERSION_ID IN pa_budget_versions.budget_version_id%type,
46 P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
47 P_PROJFUNC_CURRENCY_CODE IN pa_projects_all.projfunc_currency_code%type,
48 P_PROJECT_CURRENCY_CODE IN pa_projects_all.project_currency_code%type,
49 X_PROJFUNC_REVENUE OUT NOCOPY NUMBER,
50 X_PROJECT_REVENUE OUT NOCOPY NUMBER,
51 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
52 X_MSG_COUNT OUT NOCOPY NUMBER,
53 X_MSG_DATA OUT NOCOPY VARCHAR2);
54
55 -- Added 3/15/05
56 PROCEDURE MAP_BILLING_EVENT_RLMI_RBS
57 (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
58 P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
59 P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
60 X_TXN_SOURCE_ID_COUNT OUT NOCOPY NUMBER,
61 X_TXN_SOURCE_ID_TAB OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
62 X_RES_LIST_MEMBER_ID_TAB OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
63 X_RBS_ELEMENT_ID_TAB OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
64 X_TXN_ACCUM_HEADER_ID_TAB OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp,
65 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
66 X_MSG_COUNT OUT NOCOPY NUMBER,
67 X_MSG_DATA OUT NOCOPY VARCHAR2);
68
69 -- Added 3/15/05
70 PROCEDURE UPD_TMP4_TXN_RA_ID_AND_ML
71 (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
72 P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
73 P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
74 P_GEN_SRC_CODE IN PA_PROJ_FP_OPTIONS.GEN_ALL_SRC_CODE%TYPE,
75 P_WP_STRUCTURE_VER_ID IN PA_BUDGET_VERSIONS.PROJECT_STRUCTURE_VERSION_ID%TYPE DEFAULT NULL,
76 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
77 X_MSG_COUNT OUT NOCOPY NUMBER,
78 X_MSG_DATA OUT NOCOPY VARCHAR2);
79
80 END PA_FP_GEN_BILLING_AMOUNTS;