[Home] [Help]
PACKAGE: APPS.PA_FP_GEN_PUB
Source
1 PACKAGE PA_FP_GEN_PUB as
2 /* $Header: PAFPGNPS.pls 120.0 2005/05/30 03:47:03 appldev noship $ */
3
4
5 PROCEDURE UPDATE_RES_DEFAULTS
6 (P_PROJECT_ID IN pa_projects_all.PROJECT_ID%TYPE,
7 P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
8 P_CALLED_MODE IN VARCHAR2 DEFAULT 'SELF_SERVICE',
9 P_COMMIT_FLAG IN VARCHAR2 DEFAULT 'N',
10 P_INIT_MSG_FLAG IN VARCHAR2 DEFAULT 'N',
11 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
12 X_MSG_COUNT OUT NOCOPY NUMBER,
13 X_MSG_DATA OUT NOCOPY VARCHAR2);
14
15 PROCEDURE INCLUDE_CHANGE_DOCUMENT_WRP
16 (P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
17 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
18 X_MSG_COUNT OUT NOCOPY NUMBER,
19 X_MSG_DATA OUT NOCOPY VARCHAR2);
20
21 PROCEDURE UNSPENT_AMOUNT
22 (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
23 P_APP_COST_BDGT_VER_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
24 P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
25 P_UNSPENT_AMT_PERIOD IN VARCHAR2,
26 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
27 X_MSG_COUNT OUT NOCOPY NUMBER,
28 X_MSG_DATA OUT NOCOPY VARCHAR2);
29
30 PROCEDURE UPD_WBS_ELEMENT_VERSION_ID
31 (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
32 P_STRUCTURE_VERSION_ID IN NUMBER DEFAULT null,
33 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
34 X_MSG_COUNT OUT NOCOPY NUMBER,
35 X_MSG_DATA OUT NOCOPY VARCHAR2);
36
37 /* Added 10/15/2004 by dlai */
38 PROCEDURE PRORATE_UNALIGNED_PERIOD_AMTS
39 (P_SRC_RES_ASG_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
40 P_TARGET_RES_ASG_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
41 P_CURRENCY_CODE IN PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE,
42 P_CURRENCY_CODE_FLAG IN VARCHAR2,
43 P_ACTUAL_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
44 X_QUANTITY OUT NOCOPY PA_BUDGET_LINES.QUANTITY%TYPE,
45 X_TXN_RAW_COST OUT NOCOPY PA_BUDGET_LINES.TXN_RAW_COST%TYPE,
46 X_TXN_BURDENED_COST OUT NOCOPY PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE,
47 X_TXN_REVENUE OUT NOCOPY PA_BUDGET_LINES.TXN_REVENUE%TYPE,
48 X_PROJ_RAW_COST OUT NOCOPY PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE,
49 X_PROJ_BURDENED_COST OUT NOCOPY PA_BUDGET_LINES.PROJECT_BURDENED_COST%TYPE,
50 X_PROJ_REVENUE OUT NOCOPY PA_BUDGET_LINES.PROJECT_REVENUE%TYPE,
51 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
52 X_MSG_COUNT OUT NOCOPY NUMBER,
53 X_MSG_DATA OUT NOCOPY VARCHAR2);
54
55 /* Added 10/26/2004 by dkuo */
56 PROCEDURE MAINTAIN_FIXED_DATE_SP
57 (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
58 P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
59 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
60 X_MSG_COUNT OUT NOCOPY NUMBER,
61 X_MSG_DATA OUT NOCOPY VARCHAR2);
62
63 /* Added 1/6/2004 by dkuo */
64 PROCEDURE COPY_SRC_ATTRS_TO_TARGET_FCST
65 (P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
66 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
67 X_MSG_COUNT OUT NOCOPY NUMBER,
68 X_MSG_DATA OUT NOCOPY VARCHAR2);
69
70 END PA_FP_GEN_PUB;