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_RESOURCE_UTILZ dependencies on PJI_PMV_TIME_DIM_TMP

Line 116: delete from pji_pmv_time_dim_tmp;

112: l_prev_quarter_id NUMBER;
113: l_prev_year_id NUMBER;
114: BEGIN
115:
116: delete from pji_pmv_time_dim_tmp;
117:
118: IF (p_population_mode = 'GRAPH') THEN
119:
120: --Insert records for the current period and corresponding

Line 122: INSERT INTO PJI_PMV_TIME_DIM_TMP

118: IF (p_population_mode = 'GRAPH') THEN
119:
120: --Insert records for the current period and corresponding
121: --periods backwards and forward
122: INSERT INTO PJI_PMV_TIME_DIM_TMP
123: (
124: ID,
125: PRIOR_ID,
126: NAME,

Line 148: UPDATE PJI_PMV_TIME_DIM_TMP pmv

144:
145: --Update records for the current period in the prior year
146: --and corresponding periods backwards and forward
147:
148: UPDATE PJI_PMV_TIME_DIM_TMP pmv
149: SET pmv.PRIOR_ID =
150: ( SELECT period_id as prior_id
151: FROM pji_time_mv lower
152: WHERE

Line 161: INSERT INTO PJI_PMV_TIME_DIM_TMP

157: AND pmv.order_by_id = lower.sequence-g_prev_yr_period_seq
158: );
159: ELSIF (p_population_mode = 'TABLE') THEN
160:
161: INSERT INTO PJI_PMV_TIME_DIM_TMP
162: (
163: ID,
164: PRIOR_ID,
165: NAME,

Line 229: UPDATE PJI_PMV_TIME_DIM_TMP pmv

225: WHERE sequence = g_prev_yr_period_seq
226: and calendar_id = p_calendar_id
227: and period_type = DECODE(p_calendar_type,'E','FII_TIME_ENT_PERIOD', 'FII_TIME_CAL_PERIOD');
228:
229: UPDATE PJI_PMV_TIME_DIM_TMP pmv
230: SET pmv.PRIOR_ID = l_prev_period_id
231: where order_by_id = 1;
232:
233: UPDATE PJI_PMV_TIME_DIM_TMP pmv

Line 233: UPDATE PJI_PMV_TIME_DIM_TMP pmv

229: UPDATE PJI_PMV_TIME_DIM_TMP pmv
230: SET pmv.PRIOR_ID = l_prev_period_id
231: where order_by_id = 1;
232:
233: UPDATE PJI_PMV_TIME_DIM_TMP pmv
234: SET pmv.PRIOR_ID = l_prev_quarter_id
235: where order_by_id = 2;
236:
237: UPDATE PJI_PMV_TIME_DIM_TMP pmv

Line 237: UPDATE PJI_PMV_TIME_DIM_TMP pmv

233: UPDATE PJI_PMV_TIME_DIM_TMP pmv
234: SET pmv.PRIOR_ID = l_prev_quarter_id
235: where order_by_id = 2;
236:
237: UPDATE PJI_PMV_TIME_DIM_TMP pmv
238: SET pmv.PRIOR_ID = l_prev_year_id
239: where order_by_id = 3;
240:
241: END IF;

Line 281: delete from pji_pmv_time_dim_tmp;

277: l_prev_year_id NUMBER;
278:
279: BEGIN
280:
281: delete from pji_pmv_time_dim_tmp;
282:
283: IF (p_calendar_type <> 'E') THEN
284: l_period_type := 'FII_TIME_CAL_PERIOD';
285: ELSE

Line 298: INSERT INTO PJI_PMV_TIME_DIM_TMP

294: IF (p_population_mode = 'GRAPH') THEN
295:
296: --Insert records for the current period and corresponding
297: --periods backwards and forward
298: INSERT INTO PJI_PMV_TIME_DIM_TMP
299: (
300: ID,
301: PRIOR_ID,
302: NAME,

Line 324: UPDATE PJI_PMV_TIME_DIM_TMP pmv

320:
321: --Update records for the current period in the prior year
322: --and corresponding periods backwards and forward
323:
324: UPDATE PJI_PMV_TIME_DIM_TMP pmv
325: SET pmv.PRIOR_ID =
326: ( SELECT period_id as prior_id
327: FROM pji_time_mv lower
328: WHERE

Line 349: PJI_PMV_TIME_DIM_TMP pmv

345: ID
346: BULK COLLECT INTO
347: l_curr_period_id_tbl
348: FROM
349: PJI_PMV_TIME_DIM_TMP pmv
350: where pmv.period_type = 32;
351:
352: FOR i in l_curr_period_id_tbl.FIRST.. l_curr_period_id_tbl.LAST
353: LOOP

Line 367: UPDATE PJI_PMV_TIME_DIM_TMP pmv

363: IF l_pop_daily_rec_flag = 'Y' THEN
364: --Update the table to set the period id to null
365: --where the last summarization date resides
366:
367: UPDATE PJI_PMV_TIME_DIM_TMP pmv
368: SET pmv.ID = null
369: where pmv.id = g_last_summ_period_id
370: and pmv.calendar_type = p_calendar_type
371: and pmv.period_type = 32

Line 400: UPDATE PJI_PMV_TIME_DIM_TMP pmv

396: , g_last_summ_period_id
397: );
398:
399: --Update sequence for daily records
400: UPDATE PJI_PMV_TIME_DIM_TMP pmv
401: set pmv.order_by_id = l_last_sum_pmv_seq
402: where pmv.period_type = 1 OR pmv.period_type = 16;
403: END IF;
404: ELSIF (p_population_mode = 'TABLE') THEN

Line 428: INSERT INTO PJI_PMV_TIME_DIM_TMP

424: --that we are populating
425:
426: --First process for period
427: IF (g_last_summ_period_id <> g_curr_period_id) THEN
428: INSERT INTO PJI_PMV_TIME_DIM_TMP
429: (
430: ID,
431: PRIOR_ID,
432: NAME,

Line 500: INSERT INTO PJI_PMV_TIME_DIM_TMP

496: END IF;
497: END LOOP;
498:
499: IF (l_daily_rec_qtr_flag <> 'Y') THEN
500: INSERT INTO PJI_PMV_TIME_DIM_TMP
501: (
502: ID,
503: PRIOR_ID,
504: NAME,

Line 596: INSERT INTO PJI_PMV_TIME_DIM_TMP

592: WHERE sequence = g_prev_yr_period_seq
593: and calendar_id = p_calendar_id
594: and period_type = DECODE(p_calendar_type,'E','FII_TIME_ENT_PERIOD', 'FII_TIME_CAL_PERIOD');
595:
596: INSERT INTO PJI_PMV_TIME_DIM_TMP
597: (
598: ID,
599: PRIOR_ID,
600: NAME,

Line 617: INSERT INTO PJI_PMV_TIME_DIM_TMP

613: 1 ,
614: p_calendar_type
615: );
616:
617: INSERT INTO PJI_PMV_TIME_DIM_TMP
618: (
619: ID,
620: PRIOR_ID,
621: NAME,

Line 637: INSERT INTO PJI_PMV_TIME_DIM_TMP

633: 64 ,
634: 1 ,
635: p_calendar_type
636: );
637: INSERT INTO PJI_PMV_TIME_DIM_TMP
638: (
639: ID,
640: PRIOR_ID,
641: NAME,

Line 890: from pji_rm_res_f cur2, PJI_PMV_TIME_DIM_TMP pmv

886: DECODE(pmv.amount_type,1, cur2.total_hrs_a, cur2.conf_hrs_s)))) as exp_utilz,
887: 0 as prev_yr_utilz,
888: pmv.name as period_name,
889: pmv.order_by_id as id
890: from pji_rm_res_f cur2, PJI_PMV_TIME_DIM_TMP pmv
891: where person_id = p_person_id
892: and pmv.period_type IN (1,16)
893: and pmv.period_type = cur2.period_type_id
894: and pmv.calendar_type = 'C'

Line 913: from pji_rm_res_f cur2, PJI_PMV_TIME_DIM_TMP pmv

909: DECODE(pmv.amount_type,1, cur2.total_hrs_a, cur2.conf_hrs_s)))) as exp_utilz,
910: 0 as prev_yr_utilz,
911: pmv.name as period_name,
912: pmv.order_by_id as id
913: from pji_rm_res_f cur2, PJI_PMV_TIME_DIM_TMP pmv
914: where person_id = p_person_id
915: and pmv.period_type = 32
916: and pmv.period_type = cur2.period_type_id
917: and pmv.calendar_type = p_calendar_type

Line 931: from pji_rm_res_f cur2, PJI_PMV_TIME_DIM_TMP pmv

927: SUM(total_wtd_res_hrs_a)/DECODE(SUM(DECODE(g_calc_mthd,'CAPACITY',cur2.capacity_hrs - cur2.reduce_capacity_hrs_a, cur2.total_hrs_a)),
928: 0, null,SUM(DECODE(g_calc_mthd,'CAPACITY',cur2.capacity_hrs - cur2.reduce_capacity_hrs_a, cur2.total_hrs_a))) as prev_yr_utilz,
929: pmv.name as period_name,
930: pmv.order_by_id as id
931: from pji_rm_res_f cur2, PJI_PMV_TIME_DIM_TMP pmv
932: where person_id = p_person_id
933: and pmv.period_type = 32
934: and pmv.period_type = cur2.period_type_id
935: and pmv.calendar_type = p_calendar_type

Line 1155: FROM pji_rm_res_f cur2, PJI_PMV_TIME_DIM_TMP pmv

1151: DECODE(pmv.amount_type,1,cur2.reduce_capacity_hrs_a,cur2.reduce_capacity_hrs_s),
1152: DECODE(pmv.amount_type,1, cur2.total_hrs_a, cur2.conf_hrs_s)))) as exp_utilz,
1153: 0 as prev_yr_utilz,
1154: pmv.order_by_id as id
1155: FROM pji_rm_res_f cur2, PJI_PMV_TIME_DIM_TMP pmv
1156: WHERE person_id = p_person_id
1157: and pmv.period_type = cur2.period_type_id
1158: and pmv.calendar_type = cur2.calendar_type
1159: and pmv.id = cur2.time_id

Line 1170: from pji_rm_res_f cur2, PJI_PMV_TIME_DIM_TMP pmv

1166: 0 as exp_utilz,
1167: SUM(total_wtd_res_hrs_a)/DECODE(SUM(DECODE(g_calc_mthd,'CAPACITY',cur2.capacity_hrs - cur2.reduce_capacity_hrs_a, cur2.total_hrs_a)),
1168: 0, null,SUM(DECODE(g_calc_mthd,'CAPACITY',cur2.capacity_hrs - cur2.reduce_capacity_hrs_a, cur2.total_hrs_a))) as prev_yr_utilz,
1169: pmv.order_by_id as id
1170: from pji_rm_res_f cur2, PJI_PMV_TIME_DIM_TMP pmv
1171: where person_id = p_person_id
1172: and pmv.period_type = cur2.period_type_id
1173: and pmv.calendar_type = cur2.calendar_type
1174: and pmv.prior_id = cur2.time_id