DBA Data[Home] [Help]

APPS.PA_FP_MAINTAIN_ACTUAL_PUB dependencies on PA_BUDGET_LINES

Line 5: ( PERIOD_NAME PA_BUDGET_LINES.PERIOD_NAME%TYPE := null,

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,

Line 6: START_DATE PA_BUDGET_LINES.START_DATE%TYPE := null,

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,

Line 7: END_DATE PA_BUDGET_LINES.END_DATE%TYPE := null,

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,

Line 8: TXN_RAW_COST PA_BUDGET_LINES.TXN_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,

Line 9: TXN_BURDENED_COST PA_BUDGET_LINES.TXN_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,

Line 10: TXN_REVENUE PA_BUDGET_LINES.TXN_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,

Line 11: PROJECT_RAW_COST PA_BUDGET_LINES.PROJECT_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,

Line 12: PROJECT_BURDENED_COST PA_BUDGET_LINES.PROJECT_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,

Line 13: PROJECT_REVENUE PA_BUDGET_LINES.PROJECT_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);

Line 14: PROJECT_FUNC_RAW_COST PA_BUDGET_LINES.RAW_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:

Line 15: PROJECT_FUNC_BURDENED_COST PA_BUDGET_LINES.BURDENED_COST%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 */

Line 16: PROJECT_FUNC_REVENUE PA_BUDGET_LINES.REVENUE%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:

Line 17: QUANTITY PA_BUDGET_LINES.QUANTITY%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

Line 53: P_TXN_CURRENCY_CODE IN PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE,

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',