1: PACKAGE PA_FP_MAINTAIN_ACTUAL_PUB AUTHID CURRENT_USER 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,
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,
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,
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,
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,
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,
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,
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,
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);
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:
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 */
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:
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
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',