eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PJI_PMV_DFLT_PARAMS dependencies on PJI_PMV_DFLT_PARAMS

Line 1: PACKAGE BODY PJI_PMV_DFLT_PARAMS AS

1: PACKAGE BODY PJI_PMV_DFLT_PARAMS AS
2: /* $Header: PJIRX02B.pls 115.29 2004/06/04 12:34:49 aljain noship $ */
3:
4: G_Default_Org_Dimension_Level VARCHAR2(150):='PJI_REP_DIM_2';
5: G_Org_Hierarchy_Name VARCHAR2(100):='ORGANIZATION^PJI_ORGANIZATIONS';

Line 26: l_org_dimension_id :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Organization_ID;

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:

Line 58: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Project Profitability');

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

Line 59: l_Period_ID :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID;

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);

Line 60: l_Period_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_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

Line 78: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Project Profitability');

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

Line 79: l_Period_ID :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID;

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);

Line 80: l_Period_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_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

Line 98: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Project Profitability');

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

Line 99: l_Period_ID :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID;

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);

Line 100: l_Period_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_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

Line 118: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Project Profitability');

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

Line 119: l_Period_ID :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID;

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);

Line 120: l_Period_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_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

Line 137: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Project Profitability');

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:

Line 138: l_Ent_Per_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Ent_Period_ID_Value;

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:

Line 150: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Project Profitability');

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:

Line 163: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Project Profitability');

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:

Line 164: l_currency_id :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Currency_ID;

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:

Line 182: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Resource Availability');

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

Line 183: l_Period_ID :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID;

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);

Line 184: l_Period_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_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

Line 202: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Resource Availability');

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

Line 203: l_Period_ID :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID;

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);

Line 204: l_Period_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_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

Line 222: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Resource Availability');

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

Line 223: l_Period_ID :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID;

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);

Line 224: l_Period_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_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

Line 242: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Resource Availability');

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

Line 243: l_Period_ID :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID;

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);

Line 244: l_Period_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_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

Line 261: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Resource Availability');

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:

Line 262: l_Availability_Threshold:=PJI_PMV_DFLT_PARAMS_PVT.Derive_Avail_Threshold;

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:

Line 274: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Resource Availability');

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:

Line 286: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Resource Availability');

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:

Line 287: l_EntWeek_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Week_ID_Value;

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: --************************************************************************************************

Line 301: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Project Cost');

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:

Line 302: l_Ent_Per_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Ent_Period_ID_Value;

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: ---******************************************************************************************************

Line 315: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Project Cost');

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

Line 316: l_Period_ID :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID;

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);

Line 317: l_Period_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_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

Line 335: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Project Cost');

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

Line 336: l_Period_ID :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID;

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);

Line 337: l_Period_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_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

Line 355: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Project Cost');

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

Line 356: l_Period_ID :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID;

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);

Line 357: l_Period_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_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

Line 375: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Project Cost');

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

Line 376: l_Period_ID :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID;

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);

Line 377: l_Period_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_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

Line 393: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Project Cost');

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:

Line 405: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Project Cost');

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: --*************************************************************************************

Line 406: l_currency_id :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Currency_ID;

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

Line 419: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Project Bookings and 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:

Line 420: l_Ent_Per_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Ent_Period_ID_Value;

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: ---******************************************************************************************************

Line 433: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Project Bookings and Backlog');

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

Line 434: l_Period_ID :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID;

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);

Line 435: l_Period_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_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

Line 453: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Project Bookings and Backlog');

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

Line 454: l_Period_ID :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID;

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);

Line 455: l_Period_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_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

Line 473: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Project Bookings and Backlog');

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

Line 474: l_Period_ID :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID;

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);

Line 475: l_Period_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_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

Line 493: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Project Bookings and Backlog');

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

Line 494: l_Period_ID :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID;

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);

Line 495: l_Period_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_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

Line 511: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Project Bookings and Backlog');

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:

Line 512: l_currency_id :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Currency_ID;

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: ---********************************************************************************

Line 523: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Project Bookings and Backlog');

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:

Line 535: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Project Bookings and Backlog');

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:

Line 551: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Resource Utilization');

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:

Line 563: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Resource Utilization');

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:

Line 564: l_Ent_Per_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Ent_Period_ID_Value;

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: ---******************************************************************************************************

Line 577: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Resource Utilization');

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

Line 578: l_Period_ID :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID;

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);

Line 579: l_Period_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_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

Line 597: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Resource Utilization');

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

Line 598: l_Period_ID :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID;

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);

Line 599: l_Period_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_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

Line 617: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Resource Utilization');

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

Line 618: l_Period_ID :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID;

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);

Line 619: l_Period_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_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

Line 637: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Resource Utilization');

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

Line 638: l_Period_ID :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Period_ID;

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);

Line 639: l_Period_ID_Value :=PJI_PMV_DFLT_PARAMS_PVT.Derive_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

Line 655: PJI_PMV_DFLT_PARAMS_PVT.InitParameters ('Resource Utilization');

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:

Line 656: l_currency_id :=PJI_PMV_DFLT_PARAMS_PVT.Derive_Currency_ID;

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:

Line 671: PJI_PMV_DFLT_PARAMS_PVT.InitEnvironment;

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;

Line 675: END PJI_PMV_DFLT_PARAMS;

671: PJI_PMV_DFLT_PARAMS_PVT.InitEnvironment;
672: EXCEPTION
673: WHEN OTHERS THEN
674: RAISE;
675: END PJI_PMV_DFLT_PARAMS;
676: