22: FUNCTION PJI_REP_DIM_2 return varchar2
23: IS
24: l_org_dimension_id VARCHAR2(150);
25: Begin
26: l_org_dimension_id :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Organization_ID;
27: return l_org_dimension_id;
28: END PJI_REP_DIM_2;
29:
30:
54: l_Period_ID VARCHAR2(150);
55: l_Period_ID_Value NUMBER;
56:
57: Begin
58: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Project Profitability');
59: l_Period_ID :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID;
60: l_Period_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID_Value;
61:
62: IF l_period_id ='FII_TIME_ENT_YEAR' then
55: l_Period_ID_Value NUMBER;
56:
57: Begin
58: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Project Profitability');
59: l_Period_ID :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID;
60: l_Period_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID_Value;
61:
62: IF l_period_id ='FII_TIME_ENT_YEAR' then
63: return TO_CHAR(l_Period_Id_Value);
56:
57: Begin
58: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Project Profitability');
59: l_Period_ID :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID;
60: l_Period_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID_Value;
61:
62: IF l_period_id ='FII_TIME_ENT_YEAR' then
63: return TO_CHAR(l_Period_Id_Value);
64: ELSE
74: l_Period_ID VARCHAR2(150);
75: l_Period_ID_Value NUMBER;
76:
77: Begin
78: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Project Profitability');
79: l_Period_ID :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID;
80: l_Period_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID_Value;
81:
82: IF l_period_id ='FII_TIME_ENT_QTR' then
75: l_Period_ID_Value NUMBER;
76:
77: Begin
78: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Project Profitability');
79: l_Period_ID :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID;
80: l_Period_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID_Value;
81:
82: IF l_period_id ='FII_TIME_ENT_QTR' then
83: return TO_CHAR(l_Period_Id_Value);
76:
77: Begin
78: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Project Profitability');
79: l_Period_ID :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID;
80: l_Period_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID_Value;
81:
82: IF l_period_id ='FII_TIME_ENT_QTR' then
83: return TO_CHAR(l_Period_Id_Value);
84: ELSE
94: l_Period_ID VARCHAR2(150);
95: l_Period_ID_Value NUMBER;
96:
97: Begin
98: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Project Profitability');
99: l_Period_ID :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID;
100: l_Period_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID_Value;
101:
102: IF l_period_id ='FII_TIME_ENT_PERIOD' then
95: l_Period_ID_Value NUMBER;
96:
97: Begin
98: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Project Profitability');
99: l_Period_ID :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID;
100: l_Period_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID_Value;
101:
102: IF l_period_id ='FII_TIME_ENT_PERIOD' then
103: return TO_CHAR(l_Period_Id_Value);
96:
97: Begin
98: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Project Profitability');
99: l_Period_ID :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID;
100: l_Period_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID_Value;
101:
102: IF l_period_id ='FII_TIME_ENT_PERIOD' then
103: return TO_CHAR(l_Period_Id_Value);
104: ELSE
114: l_Period_ID VARCHAR2(150);
115: l_Period_ID_Value NUMBER;
116:
117: Begin
118: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Project Profitability');
119: l_Period_ID :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID;
120: l_Period_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID_Value;
121:
122: IF l_period_id = 'FII_TIME_WEEK' then
115: l_Period_ID_Value NUMBER;
116:
117: Begin
118: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Project Profitability');
119: l_Period_ID :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID;
120: l_Period_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID_Value;
121:
122: IF l_period_id = 'FII_TIME_WEEK' then
123: return TO_CHAR(l_Period_Id_Value);
116:
117: Begin
118: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Project Profitability');
119: l_Period_ID :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID;
120: l_Period_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID_Value;
121:
122: IF l_period_id = 'FII_TIME_WEEK' then
123: return TO_CHAR(l_Period_Id_Value);
124: ELSE
133: FUNCTION Profitability_PP56_Time return varchar2
134: IS
135: l_Ent_Per_ID_Value NUMBER;
136: Begin
137: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Project Profitability');
138: l_Ent_Per_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Ent_Period_ID_Value;
139: return TO_CHAR(l_Ent_Per_ID_Value);
140: END Profitability_PP56_Time;
141:
134: IS
135: l_Ent_Per_ID_Value NUMBER;
136: Begin
137: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Project Profitability');
138: l_Ent_Per_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Ent_Period_ID_Value;
139: return TO_CHAR(l_Ent_Per_ID_Value);
140: END Profitability_PP56_Time;
141:
142:
146: FUNCTION Profitability_PP12_Yearly return varchar2
147: IS
148: l_Default_Compare_To VARCHAR2(150);
149: Begin
150: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Project Profitability');
151: l_Default_Compare_To :=G_Default_Compare_To;
152: return l_Default_Compare_To;
153: END Profitability_PP12_Yearly;
154:
159: FUNCTION Profitability_PP_PjiRepDim27 return varchar2
160: IS
161: l_Currency_ID VARCHAR2(150);
162: Begin
163: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Project Profitability');
164: l_currency_id :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Currency_ID;
165: return l_Currency_ID;
166: END Profitability_PP_PjiRepDim27 ;
167:
160: IS
161: l_Currency_ID VARCHAR2(150);
162: Begin
163: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Project Profitability');
164: l_currency_id :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Currency_ID;
165: return l_Currency_ID;
166: END Profitability_PP_PjiRepDim27 ;
167:
168:
178: l_Period_ID VARCHAR2(150);
179: l_Period_ID_Value NUMBER;
180:
181: Begin
182: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Resource Availability');
183: l_Period_ID :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID;
184: l_Period_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID_Value;
185:
186: IF l_period_id ='FII_TIME_ENT_YEAR' then
179: l_Period_ID_Value NUMBER;
180:
181: Begin
182: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Resource Availability');
183: l_Period_ID :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID;
184: l_Period_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID_Value;
185:
186: IF l_period_id ='FII_TIME_ENT_YEAR' then
187: return TO_CHAR(l_Period_Id_Value);
180:
181: Begin
182: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Resource Availability');
183: l_Period_ID :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID;
184: l_Period_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID_Value;
185:
186: IF l_period_id ='FII_TIME_ENT_YEAR' then
187: return TO_CHAR(l_Period_Id_Value);
188: ELSE
198: l_Period_ID VARCHAR2(150);
199: l_Period_ID_Value NUMBER;
200:
201: Begin
202: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Resource Availability');
203: l_Period_ID :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID;
204: l_Period_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID_Value;
205:
206: IF l_period_id ='FII_TIME_ENT_QTR' then
199: l_Period_ID_Value NUMBER;
200:
201: Begin
202: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Resource Availability');
203: l_Period_ID :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID;
204: l_Period_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID_Value;
205:
206: IF l_period_id ='FII_TIME_ENT_QTR' then
207: return TO_CHAR(l_Period_Id_Value);
200:
201: Begin
202: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Resource Availability');
203: l_Period_ID :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID;
204: l_Period_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID_Value;
205:
206: IF l_period_id ='FII_TIME_ENT_QTR' then
207: return TO_CHAR(l_Period_Id_Value);
208: ELSE
218: l_Period_ID VARCHAR2(150);
219: l_Period_ID_Value NUMBER;
220:
221: Begin
222: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Resource Availability');
223: l_Period_ID :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID;
224: l_Period_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID_Value;
225:
226: IF l_period_id ='FII_TIME_ENT_PERIOD' then
219: l_Period_ID_Value NUMBER;
220:
221: Begin
222: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Resource Availability');
223: l_Period_ID :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID;
224: l_Period_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID_Value;
225:
226: IF l_period_id ='FII_TIME_ENT_PERIOD' then
227: return TO_CHAR(l_Period_Id_Value);
220:
221: Begin
222: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Resource Availability');
223: l_Period_ID :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID;
224: l_Period_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID_Value;
225:
226: IF l_period_id ='FII_TIME_ENT_PERIOD' then
227: return TO_CHAR(l_Period_Id_Value);
228: ELSE
238: l_Period_ID VARCHAR2(150);
239: l_Period_ID_Value NUMBER;
240:
241: Begin
242: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Resource Availability');
243: l_Period_ID :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID;
244: l_Period_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID_Value;
245:
246: IF l_period_id = 'FII_TIME_WEEK' then
239: l_Period_ID_Value NUMBER;
240:
241: Begin
242: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Resource Availability');
243: l_Period_ID :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID;
244: l_Period_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID_Value;
245:
246: IF l_period_id = 'FII_TIME_WEEK' then
247: return TO_CHAR(l_Period_Id_Value);
240:
241: Begin
242: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Resource Availability');
243: l_Period_ID :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID;
244: l_Period_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID_Value;
245:
246: IF l_period_id = 'FII_TIME_WEEK' then
247: return TO_CHAR(l_Period_Id_Value);
248: ELSE
257: FUNCTION Availability_RA_PjiRepDim28 return varchar2
258: IS
259: l_Availability_Threshold VARCHAR2(150);
260: Begin
261: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Resource Availability');
262: l_Availability_Threshold:=PJI_PMV_DFLT_PARAMS_PVT.Derive_Avail_Threshold;
263: return l_Availability_Threshold;
264: END Availability_RA_PjiRepDim28 ;
265:
258: IS
259: l_Availability_Threshold VARCHAR2(150);
260: Begin
261: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Resource Availability');
262: l_Availability_Threshold:=PJI_PMV_DFLT_PARAMS_PVT.Derive_Avail_Threshold;
263: return l_Availability_Threshold;
264: END Availability_RA_PjiRepDim28 ;
265:
266:
270: FUNCTION Availability_RA_PjiRepDim29 return varchar2
271: IS
272: l_Duration_Type VARCHAR2(150);
273: Begin
274: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Resource Availability');
275: l_Duration_Type :=G_Duration_Type;
276: return l_Duration_Type;
277: END Availability_RA_PjiRepDim29 ;
278:
282: FUNCTION Availability_RA_FiiTimeWeek return varchar2
283: IS
284: l_EntWeek_ID_Value NUMBER;
285: Begin
286: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Resource Availability');
287: l_EntWeek_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Week_ID_Value;
288: return TO_CHAR(l_EntWeek_ID_Value);
289: END Availability_RA_FiiTimeWeek ;
290:
283: IS
284: l_EntWeek_ID_Value NUMBER;
285: Begin
286: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Resource Availability');
287: l_EntWeek_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Week_ID_Value;
288: return TO_CHAR(l_EntWeek_ID_Value);
289: END Availability_RA_FiiTimeWeek ;
290:
291: --************************************************************************************************
297: FUNCTION Cost_PP78_Time return varchar2
298: IS
299: l_Ent_Per_ID_Value NUMBER;
300: Begin
301: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Project Cost');
302: l_Ent_Per_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Ent_Period_ID_Value;
303: return TO_CHAR(l_Ent_Per_ID_Value);
304: END Cost_PP78_Time ;
305:
298: IS
299: l_Ent_Per_ID_Value NUMBER;
300: Begin
301: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Project Cost');
302: l_Ent_Per_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Ent_Period_ID_Value;
303: return TO_CHAR(l_Ent_Per_ID_Value);
304: END Cost_PP78_Time ;
305:
306: ---******************************************************************************************************
311: l_Period_ID VARCHAR2(150);
312: l_Period_ID_Value NUMBER;
313:
314: Begin
315: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Project Cost');
316: l_Period_ID :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID;
317: l_Period_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID_Value;
318:
319: IF l_period_id ='FII_TIME_ENT_YEAR' then
312: l_Period_ID_Value NUMBER;
313:
314: Begin
315: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Project Cost');
316: l_Period_ID :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID;
317: l_Period_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID_Value;
318:
319: IF l_period_id ='FII_TIME_ENT_YEAR' then
320: return TO_CHAR(l_Period_Id_Value);
313:
314: Begin
315: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Project Cost');
316: l_Period_ID :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID;
317: l_Period_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID_Value;
318:
319: IF l_period_id ='FII_TIME_ENT_YEAR' then
320: return TO_CHAR(l_Period_Id_Value);
321: ELSE
331: l_Period_ID VARCHAR2(150);
332: l_Period_ID_Value NUMBER;
333:
334: Begin
335: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Project Cost');
336: l_Period_ID :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID;
337: l_Period_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID_Value;
338:
339: IF l_period_id ='FII_TIME_ENT_QTR' then
332: l_Period_ID_Value NUMBER;
333:
334: Begin
335: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Project Cost');
336: l_Period_ID :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID;
337: l_Period_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID_Value;
338:
339: IF l_period_id ='FII_TIME_ENT_QTR' then
340: return TO_CHAR(l_Period_Id_Value);
333:
334: Begin
335: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Project Cost');
336: l_Period_ID :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID;
337: l_Period_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID_Value;
338:
339: IF l_period_id ='FII_TIME_ENT_QTR' then
340: return TO_CHAR(l_Period_Id_Value);
341: ELSE
351: l_Period_ID VARCHAR2(150);
352: l_Period_ID_Value NUMBER;
353:
354: Begin
355: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Project Cost');
356: l_Period_ID :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID;
357: l_Period_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID_Value;
358:
359: IF l_period_id ='FII_TIME_ENT_PERIOD' then
352: l_Period_ID_Value NUMBER;
353:
354: Begin
355: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Project Cost');
356: l_Period_ID :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID;
357: l_Period_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID_Value;
358:
359: IF l_period_id ='FII_TIME_ENT_PERIOD' then
360: return TO_CHAR(l_Period_Id_Value);
353:
354: Begin
355: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Project Cost');
356: l_Period_ID :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID;
357: l_Period_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID_Value;
358:
359: IF l_period_id ='FII_TIME_ENT_PERIOD' then
360: return TO_CHAR(l_Period_Id_Value);
361: ELSE
371: l_Period_ID VARCHAR2(150);
372: l_Period_ID_Value NUMBER;
373:
374: Begin
375: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Project Cost');
376: l_Period_ID :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID;
377: l_Period_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID_Value;
378:
379: IF l_period_id = 'FII_TIME_WEEK' then
372: l_Period_ID_Value NUMBER;
373:
374: Begin
375: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Project Cost');
376: l_Period_ID :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID;
377: l_Period_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID_Value;
378:
379: IF l_period_id = 'FII_TIME_WEEK' then
380: return TO_CHAR(l_Period_Id_Value);
373:
374: Begin
375: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Project Cost');
376: l_Period_ID :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID;
377: l_Period_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID_Value;
378:
379: IF l_period_id = 'FII_TIME_WEEK' then
380: return TO_CHAR(l_Period_Id_Value);
381: ELSE
389: FUNCTION Cost_P4610_Yearly return varchar2
390: IS
391: l_Default_Compare_To VARCHAR2(150);
392: Begin
393: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Project Cost');
394: l_Default_Compare_To :=G_Default_Compare_To;
395: return l_Default_Compare_To;
396: END Cost_P4610_Yearly;
397:
401: FUNCTION Cost_PP_PjiRepDim27 return varchar2
402: IS
403: l_Currency_ID VARCHAR2(150);
404: Begin
405: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Project Cost');
406: l_currency_id :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Currency_ID;
407: return l_Currency_ID;
408: END Cost_PP_PjiRepDim27 ;
409: --*************************************************************************************
402: IS
403: l_Currency_ID VARCHAR2(150);
404: Begin
405: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Project Cost');
406: l_currency_id :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Currency_ID;
407: return l_Currency_ID;
408: END Cost_PP_PjiRepDim27 ;
409: --*************************************************************************************
410: -- Bookings_Backlog
415: FUNCTION Bookings_Backlog20203_Time return varchar2
416: IS
417: l_Ent_Per_ID_Value NUMBER;
418: Begin
419: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Project Bookings and Backlog');
420: l_Ent_Per_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Ent_Period_ID_Value;
421: return TO_CHAR(l_Ent_Per_ID_Value);
422: END Bookings_Backlog20203_Time ;
423:
416: IS
417: l_Ent_Per_ID_Value NUMBER;
418: Begin
419: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Project Bookings and Backlog');
420: l_Ent_Per_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Ent_Period_ID_Value;
421: return TO_CHAR(l_Ent_Per_ID_Value);
422: END Bookings_Backlog20203_Time ;
423:
424: ---******************************************************************************************************
429: l_Period_ID VARCHAR2(150);
430: l_Period_ID_Value NUMBER;
431:
432: Begin
433: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Project Bookings and Backlog');
434: l_Period_ID :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID;
435: l_Period_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID_Value;
436:
437: IF l_period_id ='FII_TIME_ENT_YEAR' then
430: l_Period_ID_Value NUMBER;
431:
432: Begin
433: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Project Bookings and Backlog');
434: l_Period_ID :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID;
435: l_Period_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID_Value;
436:
437: IF l_period_id ='FII_TIME_ENT_YEAR' then
438: return TO_CHAR(l_Period_Id_Value);
431:
432: Begin
433: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Project Bookings and Backlog');
434: l_Period_ID :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID;
435: l_Period_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID_Value;
436:
437: IF l_period_id ='FII_TIME_ENT_YEAR' then
438: return TO_CHAR(l_Period_Id_Value);
439: ELSE
449: l_Period_ID VARCHAR2(150);
450: l_Period_ID_Value NUMBER;
451:
452: Begin
453: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Project Bookings and Backlog');
454: l_Period_ID :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID;
455: l_Period_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID_Value;
456:
457: IF l_period_id ='FII_TIME_ENT_QTR' then
450: l_Period_ID_Value NUMBER;
451:
452: Begin
453: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Project Bookings and Backlog');
454: l_Period_ID :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID;
455: l_Period_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID_Value;
456:
457: IF l_period_id ='FII_TIME_ENT_QTR' then
458: return TO_CHAR(l_Period_Id_Value);
451:
452: Begin
453: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Project Bookings and Backlog');
454: l_Period_ID :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID;
455: l_Period_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID_Value;
456:
457: IF l_period_id ='FII_TIME_ENT_QTR' then
458: return TO_CHAR(l_Period_Id_Value);
459: ELSE
469: l_Period_ID VARCHAR2(150);
470: l_Period_ID_Value NUMBER;
471:
472: Begin
473: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Project Bookings and Backlog');
474: l_Period_ID :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID;
475: l_Period_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID_Value;
476:
477: IF l_period_id ='FII_TIME_ENT_PERIOD' then
470: l_Period_ID_Value NUMBER;
471:
472: Begin
473: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Project Bookings and Backlog');
474: l_Period_ID :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID;
475: l_Period_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID_Value;
476:
477: IF l_period_id ='FII_TIME_ENT_PERIOD' then
478: return TO_CHAR(l_Period_Id_Value);
471:
472: Begin
473: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Project Bookings and Backlog');
474: l_Period_ID :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID;
475: l_Period_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID_Value;
476:
477: IF l_period_id ='FII_TIME_ENT_PERIOD' then
478: return TO_CHAR(l_Period_Id_Value);
479: ELSE
489: l_Period_ID VARCHAR2(150);
490: l_Period_ID_Value NUMBER;
491:
492: Begin
493: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Project Bookings and Backlog');
494: l_Period_ID :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID;
495: l_Period_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID_Value;
496:
497: IF l_period_id = 'FII_TIME_WEEK' then
490: l_Period_ID_Value NUMBER;
491:
492: Begin
493: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Project Bookings and Backlog');
494: l_Period_ID :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID;
495: l_Period_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID_Value;
496:
497: IF l_period_id = 'FII_TIME_WEEK' then
498: return TO_CHAR(l_Period_Id_Value);
491:
492: Begin
493: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Project Bookings and Backlog');
494: l_Period_ID :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID;
495: l_Period_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID_Value;
496:
497: IF l_period_id = 'FII_TIME_WEEK' then
498: return TO_CHAR(l_Period_Id_Value);
499: ELSE
507: FUNCTION Bookings_Backlog_PjiRepDim27 return varchar2
508: IS
509: l_Currency_ID VARCHAR2(150);
510: Begin
511: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Project Bookings and Backlog');
512: l_currency_id :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Currency_ID;
513: return l_Currency_ID;
514: END Bookings_Backlog_PjiRepDim27 ;
515:
508: IS
509: l_Currency_ID VARCHAR2(150);
510: Begin
511: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Project Bookings and Backlog');
512: l_currency_id :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Currency_ID;
513: return l_Currency_ID;
514: END Bookings_Backlog_PjiRepDim27 ;
515:
516: ---********************************************************************************
519: FUNCTION Bookings_BacklogBB2_Dim33 return varchar2
520: IS
521: l_Revenue_At_Risk_Only VARCHAR2(150);
522: Begin
523: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Project Bookings and Backlog');
524: l_Revenue_At_Risk_Only :=G_Default_Revenue_At_Risk_Only;
525: return l_Revenue_At_Risk_Only;
526: END Bookings_BacklogBB2_Dim33 ;
527:
531: FUNCTION Bookings_BacklogBB1_Yearly return varchar2
532: IS
533: l_Default_Compare_To VARCHAR2(150);
534: Begin
535: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Project Bookings and Backlog');
536: l_Default_Compare_To :=G_Default_Compare_To;
537: return l_Default_Compare_To;
538: END Bookings_BacklogBB1_Yearly;
539:
547: FUNCTION Utilization_UAP1U1_Yearly return varchar2
548: IS
549: l_Default_Compare_To VARCHAR2(150);
550: Begin
551: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Resource Utilization');
552: l_Default_Compare_To :=G_Default_Compare_To;
553: return l_Default_Compare_To;
554: END Utilization_UAP1U1_Yearly;
555:
559: FUNCTION Utilization_U2_Time return varchar2
560: IS
561: l_Ent_Per_ID_Value NUMBER;
562: Begin
563: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Resource Utilization');
564: l_Ent_Per_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Ent_Period_ID_Value;
565: return TO_CHAR(l_Ent_Per_ID_Value);
566: END Utilization_U2_Time ;
567:
560: IS
561: l_Ent_Per_ID_Value NUMBER;
562: Begin
563: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Resource Utilization');
564: l_Ent_Per_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Ent_Period_ID_Value;
565: return TO_CHAR(l_Ent_Per_ID_Value);
566: END Utilization_U2_Time ;
567:
568: ---******************************************************************************************************
573: l_Period_ID VARCHAR2(150);
574: l_Period_ID_Value NUMBER;
575:
576: Begin
577: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Resource Utilization');
578: l_Period_ID :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID;
579: l_Period_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID_Value;
580:
581: IF l_period_id ='FII_TIME_ENT_YEAR' then
574: l_Period_ID_Value NUMBER;
575:
576: Begin
577: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Resource Utilization');
578: l_Period_ID :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID;
579: l_Period_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID_Value;
580:
581: IF l_period_id ='FII_TIME_ENT_YEAR' then
582: return TO_CHAR(l_Period_Id_Value);
575:
576: Begin
577: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Resource Utilization');
578: l_Period_ID :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID;
579: l_Period_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID_Value;
580:
581: IF l_period_id ='FII_TIME_ENT_YEAR' then
582: return TO_CHAR(l_Period_Id_Value);
583: ELSE
593: l_Period_ID VARCHAR2(150);
594: l_Period_ID_Value NUMBER;
595:
596: Begin
597: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Resource Utilization');
598: l_Period_ID :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID;
599: l_Period_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID_Value;
600:
601: IF l_period_id ='FII_TIME_ENT_QTR' then
594: l_Period_ID_Value NUMBER;
595:
596: Begin
597: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Resource Utilization');
598: l_Period_ID :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID;
599: l_Period_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID_Value;
600:
601: IF l_period_id ='FII_TIME_ENT_QTR' then
602: return TO_CHAR(l_Period_Id_Value);
595:
596: Begin
597: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Resource Utilization');
598: l_Period_ID :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID;
599: l_Period_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID_Value;
600:
601: IF l_period_id ='FII_TIME_ENT_QTR' then
602: return TO_CHAR(l_Period_Id_Value);
603: ELSE
613: l_Period_ID VARCHAR2(150);
614: l_Period_ID_Value NUMBER;
615:
616: Begin
617: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Resource Utilization');
618: l_Period_ID :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID;
619: l_Period_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID_Value;
620:
621: IF l_period_id ='FII_TIME_ENT_PERIOD' then
614: l_Period_ID_Value NUMBER;
615:
616: Begin
617: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Resource Utilization');
618: l_Period_ID :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID;
619: l_Period_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID_Value;
620:
621: IF l_period_id ='FII_TIME_ENT_PERIOD' then
622: return TO_CHAR(l_Period_Id_Value);
615:
616: Begin
617: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Resource Utilization');
618: l_Period_ID :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID;
619: l_Period_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID_Value;
620:
621: IF l_period_id ='FII_TIME_ENT_PERIOD' then
622: return TO_CHAR(l_Period_Id_Value);
623: ELSE
633: l_Period_ID VARCHAR2(150);
634: l_Period_ID_Value NUMBER;
635:
636: Begin
637: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Resource Utilization');
638: l_Period_ID :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID;
639: l_Period_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID_Value;
640:
641: IF l_period_id = 'FII_TIME_WEEK' then
634: l_Period_ID_Value NUMBER;
635:
636: Begin
637: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Resource Utilization');
638: l_Period_ID :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID;
639: l_Period_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID_Value;
640:
641: IF l_period_id = 'FII_TIME_WEEK' then
642: return TO_CHAR(l_Period_Id_Value);
635:
636: Begin
637: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Resource Utilization');
638: l_Period_ID :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID;
639: l_Period_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID_Value;
640:
641: IF l_period_id = 'FII_TIME_WEEK' then
642: return TO_CHAR(l_Period_Id_Value);
643: ELSE
651: FUNCTION Utilization_PjiRepDim27 return varchar2
652: IS
653: l_Currency_ID VARCHAR2(150);
654: Begin
655: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Resource Utilization');
656: l_currency_id :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Currency_ID;
657: return l_Currency_ID;
658: END Utilization_PjiRepDim27 ;
659:
652: IS
653: l_Currency_ID VARCHAR2(150);
654: Begin
655: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Resource Utilization');
656: l_currency_id :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Currency_ID;
657: return l_Currency_ID;
658: END Utilization_PjiRepDim27 ;
659:
660:
667: -- *****************************************
668: -- Package Initialization Code
669: -- *****************************************
670: BEGIN
671: PJI_PMV_DFLT_PARAMS_PVT.InitEnvironment;
672: EXCEPTION
673: WHEN OTHERS THEN
674: RAISE;
675: END PJI_PMV_DFLT_PARAMS;