[Home] [Help]
PACKAGE: APPS.PA_FP_MAINTAIN_ACTUAL_PUB
Source
1 PACKAGE PA_FP_MAINTAIN_ACTUAL_PUB as
2 /* $Header: PAFPMAPS.pls 120.0 2005/05/29 17:17:06 appldev noship $ */
3
4 TYPE l_amt_dtls_rec_typ IS RECORD
5 ( PERIOD_NAME PA_BUDGET_LINES.PERIOD_NAME%TYPE := null,
6 START_DATE PA_BUDGET_LINES.START_DATE%TYPE := null,
7 END_DATE PA_BUDGET_LINES.END_DATE%TYPE := null,
8 TXN_RAW_COST PA_BUDGET_LINES.TXN_RAW_COST%TYPE := 0,
9 TXN_BURDENED_COST PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE := 0,
10 TXN_REVENUE PA_BUDGET_LINES.TXN_REVENUE%TYPE := 0,
11 PROJECT_RAW_COST PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE := 0,
12 PROJECT_BURDENED_COST PA_BUDGET_LINES.PROJECT_BURDENED_COST%TYPE := 0,
13 PROJECT_REVENUE PA_BUDGET_LINES.PROJECT_REVENUE%TYPE := 0,
14 PROJECT_FUNC_RAW_COST PA_BUDGET_LINES.RAW_COST%TYPE := 0,
15 PROJECT_FUNC_BURDENED_COST PA_BUDGET_LINES.BURDENED_COST%TYPE := 0,
16 PROJECT_FUNC_REVENUE PA_BUDGET_LINES.REVENUE%TYPE := 0,
17 QUANTITY PA_BUDGET_LINES.QUANTITY%TYPE := 0);
18
19 /* PLSQL table types */
20
21 TYPE l_amt_dtls_tbl_typ is TABLE OF
22 l_amt_dtls_rec_typ INDEX BY BINARY_INTEGER;
23
24
25 PROCEDURE MAINTAIN_ACTUAL_AMT_WRP
26 (P_PROJECT_ID_TAB IN SYSTEM.PA_NUM_TBL_TYPE,
27 P_WP_STR_VERSION_ID_TAB IN SYSTEM.PA_NUM_TBL_TYPE,
28 P_ACTUALS_THRU_DATE IN SYSTEM.PA_DATE_TBL_TYPE,
29 P_CALLING_CONTEXT IN VARCHAR2,
30 P_COMMIT_FLAG IN VARCHAR2 DEFAULT 'N',
31 P_INIT_MSG_FLAG IN VARCHAR2 DEFAULT 'Y',
32 P_CALLING_MODE IN VARCHAR2 DEFAULT 'SELF_SERVICE',
33 P_EXTRACTION_TYPE IN VARCHAR2 DEFAULT 'FULL',
34 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
35 X_MSG_COUNT OUT NOCOPY NUMBER,
36 X_MSG_DATA OUT NOCOPY VARCHAR2);
37
38 PROCEDURE UPD_REPORTING_LINES_WRP
39 (p_calling_module IN Varchar2
40 ,p_activity_code IN Varchar2
41 ,p_budget_version_id IN Number
42 ,p_resource_assignment_id IN Number
43 ,p_budget_line_id_tab IN pa_plsql_datatypes.IdTabTyp
44 ,p_calling_mode IN varchar2 default 'SELF_SERVICE'
45 ,x_msg_data OUT NOCOPY Varchar2
46 ,x_msg_count OUT NOCOPY Number
47 ,x_return_status OUT NOCOPY Varchar2);
48
49 PROCEDURE MAINTAIN_ACTUAL_AMT_RA
50 (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
51 P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
52 P_RESOURCE_ASSIGNMENT_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
53 P_TXN_CURRENCY_CODE IN PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE,
54 P_AMT_DTLS_REC_TAB IN PA_FP_MAINTAIN_ACTUAL_PUB.l_amt_dtls_tbl_typ,
55 P_CALLING_CONTEXT IN VARCHAR2,
56 P_TXN_AMT_TYPE_CODE IN VARCHAR2 DEFAULT 'ACTUAL_TXN',
57 P_CALLING_MODE IN VARCHAR2 DEFAULT 'SELF_SERVICE',
58 P_EXTRACTION_TYPE IN VARCHAR2 DEFAULT 'FULL',
59 P_OPEN_PD_PLAN_AMT_FLAG IN VARCHAR2 DEFAULT 'N',
60 P_OPEN_PD_END_DATE IN DATE DEFAULT NULL,
61 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
62 X_MSG_COUNT OUT NOCOPY NUMBER,
63 X_MSG_DATA OUT NOCOPY VARCHAR2);
64
65 PROCEDURE SYNC_UP_PLANNING_DATES
66 (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
67 P_CALLING_CONTEXT IN VARCHAR2 DEFAULT 'SYNC_VERSION_LEVEL',
68 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
69 X_MSG_COUNT OUT NOCOPY NUMBER,
70 X_MSG_DATA OUT NOCOPY VARCHAR2);
71
72 PROCEDURE BLK_UPD_REPORTING_LINES_WRP
73 (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
74 P_ENTIRE_VERSION_FLAG IN VARCHAR2 DEFAULT 'N',
75 P_RES_ASG_ID_TAB IN PA_PLSQL_DATATYPES.IDTABTYP,
76 P_ACTIVITY_CODE IN VARCHAR2 DEFAULT 'UPDATE',
77 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
78 X_MSG_COUNT OUT NOCOPY NUMBER,
79 X_MSG_DATA OUT NOCOPY VARCHAR2);
80
81 PROCEDURE SYNC_UP_PLANNING_DATES_NONE_TP
82 (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
83 P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
84 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
85 X_MSG_COUNT OUT NOCOPY NUMBER,
86 X_MSG_DATA OUT NOCOPY VARCHAR2);
87
88 END PA_FP_MAINTAIN_ACTUAL_PUB;