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.

[Home] [Help]

APPS.PJI_RESOURCE_UTILZ dependencies on FII_TIME_ENT_PERIOD

Line 140: WHERE period_type = DECODE(p_calendar_type,'E','FII_TIME_ENT_PERIOD', 'FII_TIME_CAL_PERIOD')

136: 32 as period_type,
137: 1 as amount_type,
138: p_calendar_type as calendar_type
139: FROM pji_time_mv
140: WHERE period_type = DECODE(p_calendar_type,'E','FII_TIME_ENT_PERIOD', 'FII_TIME_CAL_PERIOD')
141: AND calendar_id = p_calendar_id
142: AND sequence between g_curr_period_seq-g_backward_periods
143: and g_curr_period_seq+g_forward_periods;
144:

Line 153: lower.period_type = DECODE(p_calendar_type,'E','FII_TIME_ENT_PERIOD', 'FII_TIME_CAL_PERIOD')

149: SET pmv.PRIOR_ID =
150: ( SELECT period_id as prior_id
151: FROM pji_time_mv lower
152: WHERE
153: lower.period_type = DECODE(p_calendar_type,'E','FII_TIME_ENT_PERIOD', 'FII_TIME_CAL_PERIOD')
154: AND lower.calendar_id = p_calendar_id
155: AND lower.sequence between g_prev_yr_period_seq-g_backward_periods
156: and g_prev_yr_period_seq+g_forward_periods
157: AND pmv.order_by_id = lower.sequence-g_prev_yr_period_seq

Line 190: and period_type = DECODE(p_calendar_type,'E','FII_TIME_ENT_PERIOD', 'FII_TIME_CAL_PERIOD')

186: 1 as sequence
187: FROM pji_time_mv
188: WHERE period_id = g_curr_period_id
189: and calendar_id = p_calendar_id
190: and period_type = DECODE(p_calendar_type,'E','FII_TIME_ENT_PERIOD', 'FII_TIME_CAL_PERIOD')
191: UNION ALL
192: select period_id as id,
193: null as prior_id,
194: quarter_name as name,

Line 227: and period_type = DECODE(p_calendar_type,'E','FII_TIME_ENT_PERIOD', 'FII_TIME_CAL_PERIOD');

223: l_prev_year_id
224: FROM pji_time_mv
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;

Line 286: l_period_type := 'FII_TIME_ENT_PERIOD';

282:
283: IF (p_calendar_type <> 'E') THEN
284: l_period_type := 'FII_TIME_CAL_PERIOD';
285: ELSE
286: l_period_type := 'FII_TIME_ENT_PERIOD';
287: END IF;
288:
289: IF (p_calendar_type <> 'E') THEN
290: l_org_id := p_org_id; -- MOAC Changes

Line 316: WHERE period_type = DECODE(p_calendar_type,'E','FII_TIME_ENT_PERIOD', 'FII_TIME_CAL_PERIOD')

312: 32 as period_type,
313: DECODE(sign(sequence-g_last_summ_pd_seq),1,0,-1,1,0,1) as amount_type,
314: p_calendar_type as calendar_type
315: FROM pji_time_mv
316: WHERE period_type = DECODE(p_calendar_type,'E','FII_TIME_ENT_PERIOD', 'FII_TIME_CAL_PERIOD')
317: AND calendar_id = p_calendar_id
318: AND sequence between g_curr_period_seq-g_backward_periods
319: and g_curr_period_seq+g_forward_periods;
320:

Line 329: lower.period_type = DECODE(p_calendar_type,'E','FII_TIME_ENT_PERIOD', 'FII_TIME_CAL_PERIOD')

325: SET pmv.PRIOR_ID =
326: ( SELECT period_id as prior_id
327: FROM pji_time_mv lower
328: WHERE
329: lower.period_type = DECODE(p_calendar_type,'E','FII_TIME_ENT_PERIOD', 'FII_TIME_CAL_PERIOD')
330: AND lower.calendar_id = p_calendar_id
331: AND lower.sequence between g_prev_yr_period_seq-g_backward_periods
332: and g_prev_yr_period_seq+g_forward_periods
333: AND pmv.order_by_id = lower.sequence-g_prev_yr_period_seq

Line 448: and period_type = DECODE(p_calendar_type,'E','FII_TIME_ENT_PERIOD', 'FII_TIME_CAL_PERIOD');

444: p_calendar_type as calendar_type
445: FROM pji_time_mv
446: WHERE period_id = g_curr_period_id
447: and calendar_id = p_calendar_id
448: and period_type = DECODE(p_calendar_type,'E','FII_TIME_ENT_PERIOD', 'FII_TIME_CAL_PERIOD');
449: ELSE
450: --Call the API to insert daily records
451:
452: PJI_PMV_ENGINE.Convert_NViewBY_AS_OF_DATE

Line 490: and period_type = DECODE(p_calendar_type,'E','FII_TIME_ENT_PERIOD', 'FII_TIME_CAL_PERIOD');

486: FROM
487: pji_time_mv pt
488: where quarter_id = g_curr_quarter_id
489: and calendar_id = p_calendar_id
490: and period_type = DECODE(p_calendar_type,'E','FII_TIME_ENT_PERIOD', 'FII_TIME_CAL_PERIOD');
491:
492: FOR i in l_curr_period_id_tbl.FIRST.. l_curr_period_id_tbl.LAST
493: LOOP
494: IF g_last_summ_period_id = l_curr_period_id_tbl(i) THEN

Line 520: and period_type = DECODE(p_calendar_type,'E','FII_TIME_ENT_PERIOD', 'FII_TIME_CAL_PERIOD');

516: p_calendar_type as calendar_type
517: FROM pji_time_mv
518: WHERE quarter_id = g_curr_quarter_id
519: and calendar_id = p_calendar_id
520: and period_type = DECODE(p_calendar_type,'E','FII_TIME_ENT_PERIOD', 'FII_TIME_CAL_PERIOD');
521: ELSE
522: --Call the API to insert daily records
523:
524: PJI_PMV_ENGINE.Convert_NViewBY_AS_OF_DATE

Line 594: and period_type = DECODE(p_calendar_type,'E','FII_TIME_ENT_PERIOD', 'FII_TIME_CAL_PERIOD');

590: l_prev_year_id
591: FROM pji_time_mv
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,

Line 724: fii_time_ent_period period

720: ,period.name
721: INTO g_last_summ_period_id,
722: g_last_summ_pd_name
723: FROM fii_time_day day,
724: fii_time_ent_period period
725: WHERE report_date = g_last_summ_date
726: AND period.ent_period_id = day.ent_period_id;
727: ELSE
728: SELECT day.cal_period_id

Line 747: WHERE period_type = DECODE(p_calendar_type,'E','FII_TIME_ENT_PERIOD', 'FII_TIME_CAL_PERIOD')

743: --Get the sequence for the last summarized date period
744: SELECT sequence
745: INTO g_last_summ_pd_seq
746: FROM pji_time_mv
747: WHERE period_type = DECODE(p_calendar_type,'E','FII_TIME_ENT_PERIOD', 'FII_TIME_CAL_PERIOD')
748: AND period_id = g_last_summ_period_id
749: AND calendar_id = l_calendar_id;
750:
751: --Get the sequence and other information for the current selected period

Line 767: WHERE period_type = DECODE(p_calendar_type,'E','FII_TIME_ENT_PERIOD', 'FII_TIME_CAL_PERIOD')

763: g_curr_quarter_name,
764: g_curr_year_id,
765: g_curr_year_name
766: FROM pji_time_mv
767: WHERE period_type = DECODE(p_calendar_type,'E','FII_TIME_ENT_PERIOD', 'FII_TIME_CAL_PERIOD')
768: AND period_id = p_period_id
769: AND calendar_id = l_calendar_id;
770:
771: --Get the corresponding period from the last year

Line 777: FROM fii_time_ent_period

773: IF (p_calendar_type = 'E') THEN
774: --Get start date of current period
775: SELECT start_date
776: INTO g_curr_yr_pd_start_date
777: FROM fii_time_ent_period
778: WHERE ent_period_id = p_period_id;
779:
780: --Get corresponding date in the last year
781: SELECT Fii_Time_Api.ent_sd_lysper_end(g_curr_yr_pd_start_date)

Line 815: WHERE period_type = DECODE(p_calendar_type,'E','FII_TIME_ENT_PERIOD', 'FII_TIME_CAL_PERIOD')

811: --Get the sequence for the last year corresponding period
812: SELECT NVL(sequence,0)
813: INTO g_prev_yr_period_seq
814: FROM pji_time_mv
815: WHERE period_type = DECODE(p_calendar_type,'E','FII_TIME_ENT_PERIOD', 'FII_TIME_CAL_PERIOD')
816: AND period_id = g_prev_yr_period_id
817: AND calendar_id = l_calendar_id;
818:
819: --Populate the time tables

Line 965: and period_type = DECODE(p_calendar_type,'E','FII_TIME_ENT_PERIOD', 'FII_TIME_CAL_PERIOD');

961: l_prev_year_name
962: FROM pji_time_mv
963: WHERE sequence = g_prev_yr_period_seq
964: and calendar_id = l_calendar_id
965: and period_type = DECODE(p_calendar_type,'E','FII_TIME_ENT_PERIOD', 'FII_TIME_CAL_PERIOD');
966:
967: l_curr_yr_act_utilz_label := g_curr_year_name || ' ' || l_act_utilz_label;
968: l_curr_yr_sched_utilz_label := g_curr_year_name || ' ' || l_sched_utilz_label;
969: l_prev_yr_act_utilz_label := l_prev_year_name || ' ' || l_act_utilz_label;

Line 1087: and period_type = DECODE(p_calendar_type,'E','FII_TIME_ENT_PERIOD', 'FII_TIME_CAL_PERIOD');

1083: FROM
1084: pji_time_mv pt
1085: WHERE year_id = g_curr_year_id
1086: and calendar_id = l_calendar_id
1087: and period_type = DECODE(p_calendar_type,'E','FII_TIME_ENT_PERIOD', 'FII_TIME_CAL_PERIOD');
1088:
1089: --Populate the time tables
1090: IF (
1091: g_last_summ_pd_seq > g_curr_yr_max_sequence

Line 1271: and period_type = 'FII_TIME_ENT_PERIOD'

1267: l_period_status_tbl,
1268: l_period_st_dt_tbl
1269: FROM pji_time_mv
1270: WHERE calendar_id = l_calendar_id
1271: and period_type = 'FII_TIME_ENT_PERIOD'
1272: and year_id in
1273: (
1274: SELECT year_id
1275: FROM pji_time_mv

Line 1434: AND period_type = 'FII_TIME_ENT_PERIOD') BETWEEN period_start_date and period_end_date

1430: (SELECT DECODE(SIGN(TRUNC(SYSDATE) - MAX(period_end_date)), 1, MAX(period_end_date), TRUNC(SYSDATE))
1431: FROM pji_time_mv
1432: WHERE 1=1
1433: AND calendar_id = l_calendar_id
1434: AND period_type = 'FII_TIME_ENT_PERIOD') BETWEEN period_start_date and period_end_date
1435: AND calendar_id = l_calendar_id
1436: AND period_type = 'FII_TIME_ENT_PERIOD';
1437: ELSE
1438: --Get for PA/GL period

Line 1436: AND period_type = 'FII_TIME_ENT_PERIOD';

1432: WHERE 1=1
1433: AND calendar_id = l_calendar_id
1434: AND period_type = 'FII_TIME_ENT_PERIOD') BETWEEN period_start_date and period_end_date
1435: AND calendar_id = l_calendar_id
1436: AND period_type = 'FII_TIME_ENT_PERIOD';
1437: ELSE
1438: --Get for PA/GL period
1439: SELECT period_id,
1440: period_name