1 PACKAGE PA_FP_GEN_FCST_PG_PKG AUTHID CURRENT_USER as
2 /* $Header: PAFPGFPS.pls 120.2.12010000.2 2009/05/25 14:54:35 gboomina ship $ */
3
4 FUNCTION GET_REV_GEN_METHOD( P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE)
5 RETURN VARCHAR2;
6
7 FUNCTION GET_ACTUALS_THRU_PERIOD_DTLS(P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
8 P_CONTEXT IN VARCHAR2)
9 RETURN VARCHAR2;
10
11 FUNCTION GET_ACT_FRM_PERIOD(P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE)
12 RETURN VARCHAR2;
13
14 FUNCTION GET_ACT_TO_PERIOD(P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE)
15 RETURN VARCHAR2;
16
17 FUNCTION GET_ETC_FRM_PERIOD(P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE)
18 RETURN VARCHAR2;
19
20 FUNCTION GET_ETC_TO_PERIOD(P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE)
21 RETURN VARCHAR2;
22
23 FUNCTION GET_UNSPENT_AMT_PERIOD(P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE)
24 RETURN VARCHAR2;
25
26
27 PROCEDURE GET_VERSION_DETAILS
28 (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
29 X_VERSION_TYPE OUT NOCOPY PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE,
30 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
31 X_MSG_COUNT OUT NOCOPY NUMBER,
32 X_MSG_DATA OUT NOCOPY VARCHAR2);
33
34 /**
35 * 30-JUN-05 dkuo Added parameters P_CHECK_SRC_ERRORS, X_WARNING_MESSAGE.
36 * Please check body of VALIDATE_SUPPORT_CASES in PAFPGAUB.pls
37 * for list of valid parameter values.
38 **/
39
40 PROCEDURE UPD_VER_DTLS_AND_GEN_AMT
41 (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
42 P_VERSION_TYPE IN PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE,
43 P_UNSPENT_AMT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_UNSPENT_AMT_FLAG%TYPE,
44 P_UNSPENT_AMT_PERIOD IN VARCHAR2,
45 P_INCL_CHG_DOC_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_CHANGE_DOC_FLAG%TYPE,
46 P_INCL_OPEN_CMT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_OPEN_COMM_FLAG%TYPE,
47 P_INCL_BILL_EVT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_REV_INCL_BILL_EVENT_FLAG%TYPE,
48 P_RET_MANUAL_LNS_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_RET_MANUAL_LINE_FLAG%TYPE,
49 P_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,
50 P_PLAN_VERSION_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE,
51 P_PLAN_VERSION_NAME IN PA_BUDGET_VERSIONS.VERSION_NAME%TYPE,
52 P_ETC_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,
53 P_ETC_PLAN_VERSION_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE,
54 P_ETC_PLAN_VERSION_NAME IN PA_BUDGET_VERSIONS.VERSION_NAME%TYPE,
55 P_ACTUALS_FROM_PERIOD IN VARCHAR2,
56 P_ACTUALS_TO_PERIOD IN VARCHAR2,
57 P_ETC_FROM_PERIOD IN VARCHAR2,
58 P_ETC_TO_PERIOD IN VARCHAR2,
59 P_ACTUALS_THRU_PERIOD IN PA_BUDGET_VERSIONS.ACTUAL_AMTS_THRU_PERIOD%TYPE,
60 P_ACTUALS_THRU_DATE IN PA_PERIODS_ALL.END_DATE%TYPE,
61 P_WP_STRUCTURE_VERSION_ID IN PA_PROJ_ELEM_VER_STRUCTURE.ELEMENT_VERSION_ID%TYPE,
62 P_CHECK_SRC_ERRORS_FLAG IN VARCHAR2 DEFAULT 'Y',
63 X_WARNING_MESSAGE OUT NOCOPY VARCHAR2,
64 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
65 X_MSG_COUNT OUT NOCOPY NUMBER,
66 X_MSG_DATA OUT NOCOPY VARCHAR2);
67
68 PROCEDURE VALIDATE_PERIODS
69 (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
70 P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
71 P_UNSPENT_AMT_FLAG IN PA_PROJ_FP_OPTIONS.GEN_COST_INCL_UNSPENT_AMT_FLAG%TYPE,
72 P_UNSPENT_AMT_PERIOD IN VARCHAR2,
73 P_ACTUALS_FROM_PERIOD IN VARCHAR2,
74 P_ACTUALS_TO_PERIOD IN VARCHAR2,
75 P_ETC_FROM_PERIOD IN VARCHAR2,
76 P_ETC_TO_PERIOD IN VARCHAR2,
77 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
78 X_MSG_COUNT OUT NOCOPY NUMBER,
79 X_MSG_DATA OUT NOCOPY VARCHAR2);
80
81 PROCEDURE VALIDATE_PA_GL_PERIODS
82 (P_PERIOD_NAME IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,
83 P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
84 P_CONTEXT IN VARCHAR2,
85 P_ERROR_MSG_CODE IN FND_NEW_MESSAGES.MESSAGE_NAME%TYPE DEFAULT NULL,
86 X_END_DATE OUT NOCOPY DATE,
87 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
88 X_MSG_COUNT OUT NOCOPY NUMBER,
89 X_MSG_DATA OUT NOCOPY VARCHAR2);
90
91 PROCEDURE VALIDATE_PLAN_TYPE_OR_VERSION
92 (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
93 P_PLAN_TYPE_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,
94 PX_PLAN_VERSION_ID IN OUT NOCOPY PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE,
95 P_PLAN_VERSION_NAME IN PA_BUDGET_VERSIONS.VERSION_NAME%TYPE,
96 P_CALLING_CONTEXT IN VARCHAR2,
97 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
98 X_MSG_COUNT OUT NOCOPY NUMBER,
99 X_MSG_DATA OUT NOCOPY VARCHAR2);
100
101 -- gboomina added for AAI requirement 8318932 - start
102 /**
103 * This method is used to validate Time Phase and ETC Source of
104 * source plan if Copy ETC from Plan flag is selected
105 */
106 PROCEDURE VALIDATION_FOR_COPY_ETC_FLAG
107 (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
108 P_WP_VERSION_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE,
109 P_ETC_PLAN_VERSION_ID IN PA_PROJ_FP_OPTIONS.FIN_PLAN_VERSION_ID%TYPE,
110 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
111 X_MSG_COUNT OUT NOCOPY NUMBER,
112 X_MSG_DATA OUT NOCOPY VARCHAR2);
113 -- gboomina added for AAI requirement 8318932 - end
114
115 END PA_FP_GEN_FCST_PG_PKG;