[Home] [Help]
PACKAGE: APPS.PA_FP_GEN_FCST_AMT_PUB3
Source
1 PACKAGE PA_FP_GEN_FCST_AMT_PUB3 AUTHID CURRENT_USER as
2 /* $Header: PAFPFG3S.pls 120.3.12020000.2 2013/05/17 10:51:42 bpottipa ship $ */
3
4 /**Valid values for param:P_ETC_SOURCE_CODE
5 * --ETC_WP
6 * --ETC_FP
7 * --TARGET_FP
8 **/
9 PROCEDURE GET_ETC_REMAIN_BDGT_AMTS
10 (P_SRC_RES_ASG_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
11 P_TGT_RES_ASG_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
12 P_FP_COLS_SRC_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
13 P_FP_COLS_TGT_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
14 P_TASK_ID IN PA_TASKS.TASK_ID%TYPE,
15 P_RESOURCE_LIST_MEMBER_ID IN PA_RESOURCE_LIST_MEMBERS.RESOURCE_LIST_MEMBER_ID%TYPE,
16 P_ETC_SOURCE_CODE IN PA_TASKS.GEN_ETC_SOURCE_CODE%TYPE,
17 P_WP_STRUCTURE_VERSION_ID IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
18 P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
19 P_PLANNING_OPTIONS_FLAG IN VARCHAR2,
20 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
21 X_MSG_COUNT OUT NOCOPY NUMBER,
22 X_MSG_DATA OUT NOCOPY VARCHAR2);
23
24 PROCEDURE CHECK_SINGLE_CURRENCY
25 (P_TGT_RES_ASG_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
26 X_SINGLE_CURRENCY_FLAG 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 /* Bug 4369741: Replaced single planning options flag parameter with
32 * 2 separate parameters - 1 for Workplan and 1 for Financial Plan. */
33
34 PROCEDURE GET_ETC_COMMITMENT_AMTS
35 (P_FP_COLS_TGT_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
36 P_WP_PLANNING_OPTIONS_FLAG IN VARCHAR2, /* Added for Bug 4369741 */
37 P_FP_PLANNING_OPTIONS_FLAG IN VARCHAR2, /* Added for Bug 4369741 */
38 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
39 X_MSG_COUNT OUT NOCOPY NUMBER,
40 X_MSG_DATA OUT NOCOPY VARCHAR2);
41
42 PROCEDURE GET_ETC_REMAIN_BDGT_AMTS_BLK(
43 P_SRC_RES_ASG_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
44 P_TGT_RES_ASG_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
45 P_FP_COLS_SRC_REC_FP IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
46 P_FP_COLS_SRC_REC_WP IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
47 P_FP_COLS_TGT_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
48 P_TASK_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
49 P_RES_LIST_MEMBER_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp,
50 P_CBS_ELEMENT_ID_TAB IN PA_PLSQL_DATATYPES.IdTabTyp, --bug#16791711
51 P_ETC_SOURCE_CODE_TAB IN PA_PLSQL_DATATYPES.Char30TabTyp,
52 P_WP_STRUCTURE_VERSION_ID IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
53 P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
54 P_PLANNING_OPTIONS_FLAG IN VARCHAR2,
55 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
56 X_MSG_COUNT OUT NOCOPY NUMBER,
57 X_MSG_DATA OUT NOCOPY VARCHAR2);
58
59 -- gboomina added for Bug 8318932 - Start
60 -- AAI Enhancement
61 PROCEDURE GET_ETC_FROM_SRC_BDGT
62 (P_FP_COLS_SRC_FP_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
63 P_FP_COLS_SRC_WP_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
64 P_FP_COLS_TGT_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
65 P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
66 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
67 X_MSG_COUNT OUT NOCOPY NUMBER,
68 X_MSG_DATA OUT NOCOPY VARCHAR2);
69
70 PROCEDURE PROCESS_PA_GL_DATES
71 (
72 p_start_date IN DATE,
73 p_end_date IN DATE,
74 p_org_id IN NUMBER,
75 X_GL_GREATER_FLAG OUT NOCOPY VARCHAR2,
76 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
77 X_MSG_COUNT OUT NOCOPY NUMBER,
78 X_MSG_DATA OUT NOCOPY VARCHAR2
79 );
80 -- gboomina added for Bug 8318932 - End
81
82 END PA_FP_GEN_FCST_AMT_PUB3;