[Home] [Help]
PACKAGE: APPS.PA_FP_CONSTANTS_PKG
Source
1 PACKAGE PA_FP_CONSTANTS_PKG AUTHID CURRENT_USER AS
2 /* $Header: PAFPCNTS.pls 120.0 2005/05/31 03:15:18 appldev noship $ */
3
4 Invalid_Arg_Exc Exception ;
5 Just_Ret_Exc Exception ; /* This exception can be used to do the
6 processing typically done before exiting a procedure in one place
7 (the exception part of this exception handling). This is to avoid
8 repeating things done during exit of procedure before every RETURN
9 statement for apis that have multiple return statements.
10 For eg: Reset_curr_function debug call. */
11 MC_Conversion_Failed_Exc Exception; -- WEBADI UT
12
13 G_PREF_COST_ONLY CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'COST_ONLY';
14 G_PREF_REVENUE_ONLY CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'REVENUE_ONLY';
15 G_PREF_COST_AND_REV_SAME CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'COST_AND_REV_SAME';
16 G_PREF_COST_AND_REV_SEP CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'COST_AND_REV_SEP';
17
18 G_BUDGET_ENTRY_LEVEL_TOP CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'T';
19 G_BUDGET_ENTRY_LEVEL_LOWEST CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'L';
20 G_BUDGET_ENTRY_LEVEL_M CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'M';
21 G_BUDGET_ENTRY_LEVEL_PROJECT CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'P';
22
23 G_TASK_PLAN_LEVEL_TOP CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'TOP';
24 G_TASK_PLAN_LEVEL_LOWEST CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'LOWEST';
25 G_TASK_PLAN_LEVEL_UNPLANNED CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'UNPLANNED';
26
27 G_OPTION_LEVEL_PROJECT CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'PROJECT';
28 G_OPTION_LEVEL_PLAN_TYPE CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'PLAN_TYPE';
29 G_OPTION_LEVEL_PLAN_VERSION CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'PLAN_VERSION';
30
31 G_RATE_DATE_TYPE_START_DATE CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'START_DATE';
32 G_RATE_DATE_TYPE_END_DATE CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'END_DATE';
33 G_RATE_DATE_TYPE_FIXED_DATE CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'FIXED_DATE';
34
35 G_BUCKETING_PERIOD_CODE_SE CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'SE';
36 G_BUCKETING_PERIOD_CODE_PE CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'PE';
37 G_BUCKETING_PERIOD_CODE_SD CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'SD';
38 G_BUCKETING_PERIOD_CODE_PD CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'PD';
39
40 G_ELEMENT_TYPE_COST CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'COST';
41 G_ELEMENT_TYPE_REVENUE CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'REVENUE';
42 G_ELEMENT_TYPE_ALL CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'ALL';
43
44 G_TIME_PHASED_CODE_P CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'P';
45 G_TIME_PHASED_CODE_G CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'G';
46 G_TIME_PHASED_CODE_R CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'R';
47 G_TIME_PHASED_CODE_N CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'N';
48
49 G_PERIOD_TYPE_PA CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'PA';
50 G_PERIOD_TYPE_GL CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'GL';
51
52 G_CALLING_MODULE_FIN_PLAN CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'FINANCIAL_PLANNING';
53 G_CALLING_MODULE_ORG_FORECAST CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'ORG_FORECAST';
54 G_CALLING_MODULE_BUDGET CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'BUDGET';
55
59 G_RESOURCE_PLANNING_LEVEL_R CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'R';
56 G_USER_ENTERED CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'USER_ENTERED';
57 G_ROLLED_UP CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'ROLLED_UP';
58
60 G_RESOURCE_PLANNING_LEVEL_G CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'G';
61
62 G_MARGIN_DERIVED_FROM_CODE_R CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'R';
63 G_MARGIN_DERIVED_FROM_CODE_B CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'B';
64
65 G_PLAN_CLASS_BUDGET CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'BUDGET';
66 G_PLAN_CLASS_FORECAST CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'FORECAST';
67
68 G_AMOUNT_SOURCE_MANUAL_M CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'M';
69 G_AMOUNT_SOURCE_ACTUALS_A CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'A';
70 G_AMOUNT_SOURCE_COPY_P CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'P';
71
72 G_OBJECT_TYPE_ORG_FORECAST CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'ORG_FORECAST';
73 G_OBJECT_TYPE_FIN_PLAN CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'FIN_PLAN';
74 G_OBJECT_TYPE_RES_ASSIGNMENT CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'RES_ASSIGNMENT';
75
76 G_BUDGET_STATUS_SUBMITTED CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'S';
77 G_BUDGET_STATUS_WORKING CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'W';
78 G_BUDGET_STATUS_BASELINED CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'B';
79
80 G_CURRENCY_TYPE_TRANSACTION CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'TRANSACTION';
81 G_CURRENCY_TYPE_PROJECT CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'PROJECT';
82 G_CURRENCY_TYPE_PROJFUNC CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'PROJ_FUNCTIONAL';
83
84 G_LABOR_HRS_FROM_CODE_COST CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'COST';
85 G_LABOR_HRS_FROM_CODE_REVENUE CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'REVENUE';
86
87 /* others not defined in lookups are */
88 G_ELEMENT_TYPE_BOTH CONSTANT VARCHAR2(30) := 'BOTH';
89 G_ELEMENT_LEVEL_TASK CONSTANT VARCHAR2(30) := 'TASK';
90 G_ELEMENT_LEVEL_RESOURCE CONSTANT VARCHAR2(30) := 'RESOURCE';
91
92 G_UNIT_OF_MEASURE_HOURS CONSTANT VARCHAR2(30) := 'HOURS';
93 G_UNCLASSIFIED CONSTANT VARCHAR2(30) := 'UNCLASSIFIED';
94 G_UNCATEGORIZED CONSTANT VARCHAR2(30) := 'UNCATEGORIZED';
95
96 G_DATA_SOURCE_BUDGET_LINE CONSTANT VARCHAR2(30) := 'BUDGET_LINES';
97 G_DATA_SOURCE_ROLLUP_TMP CONSTANT VARCHAR2(30) := 'ROLLUP_TMP';
98 G_DATA_SOURCE_ORG_FORECAST CONSTANT VARCHAR2(30) := 'ORG_FORECAST';
99 G_DATA_SOURCE_COPY_ACTUAL CONSTANT VARCHAR2(30) := 'COPY_ACTUAL' ;
100
101 /*****
102 G_CALLING_MODULE_FIN_PLAN CONSTANT VARCHAR2(30) := 'FIN_PLAN';
103 G_CALLING_MODULE_ORG_FORECAST CONSTANT VARCHAR2(30) := 'ORG_FORECAST';
104 *****/
105
106 G_PD_PROFILE_FIN_PLANNING CONSTANT VARCHAR2(30) := 'FINANCIAL_PLANNING';
107 G_PD_PROFILE_ORG_FORECAST CONSTANT VARCHAR2(30) := 'ORG_FORECAST';
108
109 G_AMOUNT_TYPE_COST CONSTANT VARCHAR2(30) := 'COST';
110 G_AMOUNT_TYPE_RAW_COST CONSTANT VARCHAR2(30) := 'RAW_COST';
111 G_AMOUNT_TYPE_BURD_COST CONSTANT VARCHAR2(30) := 'BURDENED_COST';
112 G_AMOUNT_TYPE_REVENUE CONSTANT VARCHAR2(30) := 'REVENUE';
113 G_AMOUNT_TYPE_QUANTITY CONSTANT VARCHAR2(30) := 'QUANTITY';
114
115 G_DEBUG_LEVEL1 CONSTANT NUMBER := 1;
116 G_DEBUG_LEVEL2 CONSTANT NUMBER := 2;
117 G_DEBUG_LEVEL3 CONSTANT NUMBER := 3;
118 G_DEBUG_LEVEL4 CONSTANT NUMBER := 4;
119 G_DEBUG_LEVEL5 CONSTANT NUMBER := 5;
120 /* newly added constants */
121
122 G_VERSION_TYPE_COST CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'COST';
123 G_VERSION_TYPE_REVENUE CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'REVENUE';
124 G_VERSION_TYPE_ALL CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'ALL';
125
126 G_BUDGET_TYPE_CODE_AC CONSTANT VARCHAR2(30) := 'AC';
127 G_BUDGET_TYPE_CODE_AR CONSTANT VARCHAR2(30) := 'AR';
128 G_BUDGET_TYPE_CODE_FC CONSTANT VARCHAR2(30) := 'FC';
129 G_BUDGET_TYPE_CODE_FR CONSTANT VARCHAR2(30) := 'FR';
130
131 G_BUDGET_AMOUNT_CODE_C CONSTANT VARCHAR2(30) := 'C';
132 G_BUDGET_AMOUNT_CODE_R CONSTANT VARCHAR2(30) := 'R';
133
134 G_CALLING_CONTEXT_EDIT CONSTANT VARCHAR2(30) := 'EDIT' ;
135 G_CALLING_CONTEXT_VIEW CONSTANT VARCHAR2(30) := 'VIEW' ;
136 G_CALLING_CONTEXT_OTHER_CURR CONSTANT VARCHAR2(30) := 'EDIT_ANOTHER_CURRENCY';
137
138 /* Constants for calling context in auto baseline apis*/
139 G_CREATE_DRAFT CONSTANT VARCHAR2(30) := 'CREATE_DRAFT' ;
140 G_AUTOMATIC_BASELINE CONSTANT VARCHAR2(30) := 'AUTOMATIC_BASELINE' ;
141 /* Constants for calling context in auto baseline apis*/
142
143 /*Constants created to indicate the contexts */
144 G_CR_UP_PLAN_TYPE_PAGE CONSTANT VARCHAR2(30) := 'CR_UP_PLAN_TYPE_PAGE';
145 G_AMG_API CONSTANT VARCHAR2(30) := 'AMG_API';
146 G_WEBADI CONSTANT VARCHAR2(30) := 'WEBADI' ;
147 G_AMG_API_HEADER CONSTANT VARCHAR2(30) := 'AMG_API_HEADER' ;
148 G_AMG_API_DETAIL CONSTANT VARCHAR2(30) := 'AMG_API_DETAIL' ;
149 G_EDIT_PLAN_LINE_PAGE CONSTANT VARCHAR2(30) := 'EDIT_PLAN_LINE_PAGE' ;
150
151 G_IMPACTED_TASK_LEVEL_T CONSTANT VARCHAR2(30) := 'T';
152 G_IMPACTED_TASK_LEVEL_M CONSTANT VARCHAR2(30) := 'M';
153 G_IMPACTED_TASK_LEVEL_L CONSTANT VARCHAR2(30) := 'L';
154
155 /*Constants for validating conversion attributes for AMG*/
156 G_RATE_TYPE_NULL CONSTANT VARCHAR2(30) := 'RATE_TYPE_NULL';
157 G_RATE_TYPE_USER CONSTANT VARCHAR2(30) := 'User';
158 G_VALID_CONV_ATTR CONSTANT VARCHAR2(30) := 'VALID_CONV_ATTR';
159 G_RATE_DATE_NULL CONSTANT VARCHAR2(30) := 'RATE_DATE_NULL';
160 G_RATE_DATE_TYPE_NULL CONSTANT VARCHAR2(30) := 'RATE_DATE_TYPE_NULL';
161 G_NULL_ATTR CONSTANT VARCHAR2(30) := 'NULL_ATTR';
162
163 G_COST_TOKEN_MESSAGE CONSTANT VARCHAR2(30) := 'PA_FP_CURR_ATTRS_COST';
164 G_REV_TOKEN_MESSAGE CONSTANT VARCHAR2(30) := 'PA_FP_CURR_ATTRS_REVENUE';
165 G_PROJECT_TOKEN_MESSAGE CONSTANT VARCHAR2(30) := 'PA_FP_CURR_ATTRS_PROJECT';
166 G_PROJFUNC_TOKEN_MESSAGE CONSTANT VARCHAR2(30) := 'PA_FP_CURR_ATTRS_PROJ_FUNC';
167
168 G_RATE_NULL CONSTANT VARCHAR2(30) := 'RATE_NULL';
169
170
171 /* constants for pa_budget_versions.plan_processing_code for period profile refresh */
172 G_PLAN_PROC_CODE_P CONSTANT VARCHAR2(30) := 'P';
173 G_PLAN_PROC_CODE_E CONSTANT VARCHAR2(30) := 'E';
174 G_PLAN_PROC_CODE_G CONSTANT VARCHAR2(30) := 'G';
175 G_PLAN_PROC_CODE_PPP CONSTANT VARCHAR2(30) := 'PPP';
176 G_PLAN_PROC_CODE_PPE CONSTANT VARCHAR2(30) := 'PPE';
177 G_PLAN_PROC_CODE_PPG CONSTANT VARCHAR2(30) := 'PPG';
178
179 /* Added for bug 3099706 */
180 -- Following variable is NOT a constant, it is being used as a global variable
181 -- in PA_AGREEMENT_PUB and PA_BUDGET_PVT packages.
182
183 G_CALLED_FROM_AGREEMENT_PUB VARCHAR2(1) := 'N';
184
185
186
187 /*Constants Added for FPM Dev - tracking Bug 3354518*/
188 G_RESOURCE_CLASS_CODE_EQUIP CONSTANT VARCHAR2(30) := 'EQUIPMENT';
189 G_RESOURCE_CLASS_CODE_FIN CONSTANT VARCHAR2(30) := 'FINANCIAL_ELEMENTS';
190 G_RESOURCE_CLASS_CODE_MAT CONSTANT VARCHAR2(30) := 'MATERIAL_ITEMS';
191 G_RESOURCE_CLASS_CODE_PPL CONSTANT VARCHAR2(30) := 'PEOPLE';
192 G_CONTEXT_ACTUAL CONSTANT VARCHAR2(30) := 'ACTUAL';
193 G_QUANTITY_EFFORT CONSTANT VARCHAR2(30) := 'EFFORT';
194 G_CONTEXT_PLANNED CONSTANT VARCHAR2(30) := 'PLANNED';
195 G_SYS_STATUS_APPROVED CONSTANT VARCHAR2(30) := 'CI_APPROVED';
196 G_CALLING_MODULE_WORKPLAN CONSTANT VARCHAR2(30) := 'WORKPLAN';
197 G_CALLING_MODULE_TASK CONSTANT VARCHAR2(30) := 'TASK_ASSIGNMENT';
198 G_CALLING_MODULE_FORECAST CONSTANT VARCHAR2(30) := 'FORECAST';
199 G_CALC_API_RESOURCE_CONTEXT CONSTANT VARCHAR2(30) := 'RESOURCE_ASSIGNMENT';
200 G_CALC_API_BUDGET_LINE CONSTANT VARCHAR2(30) := 'BUDGET_LINE';
201 G_VERSION_NAME_WORKPLAN CONSTANT VARCHAR2(30) := 'WORKPLAN_VERSION';
202
203 G_CI_VERSION_AMOUNTS CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'CI_VERSION_AMOUNTS';
204 G_PARTIAL_IMPL_VERSION_AMOUNTS CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'PARTIAL_IMPL_VERSION_AMOUNTS';
205 G_PLAN_TYPE_CWV_AMOUNTS CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'PLAN_TYPE_CWV_AMOUNTS';
206 G_BV_IMPL_AMT CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'BV_IMPL_AMT';
207 G_BV_TOTAL CONSTANT PA_LOOKUPS.LOOKUP_CODE%TYPE := 'BV_TOTAL';
208
209 END PA_FP_CONSTANTS_PKG;