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_ENGINE dependencies on FII_TIME_CAL_YEAR

Line 2078: WHEN 'FII_TIME_CAL_YEAR' THEN l_Level:=119;

2074:
2075: CASE p_Period_Type
2076: WHEN 'ITD' THEN l_Level:=1143;
2077: WHEN 'FII_TIME_ENT_YEAR' THEN l_Level:=119;
2078: WHEN 'FII_TIME_CAL_YEAR' THEN l_Level:=119;
2079: WHEN 'FII_TIME_ENT_QTR' THEN l_Level:=55;
2080: WHEN 'FII_TIME_CAL_QTR' THEN l_Level:=55;
2081: WHEN 'FII_TIME_ENT_PERIOD' THEN l_Level:=23;
2082: WHEN 'FII_TIME_CAL_PERIOD' THEN l_Level:=23;

Line 2470: , fii_time_cal_year year

2466: ,l_Year_Id
2467: FROM fii_time_cal_day_mv day
2468: , fii_time_cal_period period
2469: , fii_time_cal_qtr qtr
2470: , fii_time_cal_year year
2471: WHERE 1=1
2472: AND day.report_date = l_As_Of_Date
2473: AND period.cal_period_id = day.cal_period_id
2474: AND qtr.cal_qtr_id = day.cal_qtr_id

Line 2527: , fii_time_cal_year year

2523: ,l_Prior_Year_End_Date
2524: FROM fii_time_cal_day_mv day
2525: , fii_time_cal_period period
2526: , fii_time_cal_qtr qtr
2527: , fii_time_cal_year year
2528: WHERE 1=1
2529: AND day.report_date = l_Prior_As_Of_Date
2530: AND period.cal_period_id = day.cal_period_id
2531: AND qtr.cal_qtr_id = day.cal_qtr_id

Line 2540: WHEN 'FII_TIME_CAL_YEAR' THEN l_Level:=119;

2536:
2537: CASE p_Period_Type
2538: WHEN 'ITD' THEN l_Level:=1143;
2539: WHEN 'FII_TIME_ENT_YEAR' THEN l_Level:=119;
2540: WHEN 'FII_TIME_CAL_YEAR' THEN l_Level:=119;
2541: WHEN 'FII_TIME_ENT_QTR' THEN l_Level:=55;
2542: WHEN 'FII_TIME_CAL_QTR' THEN l_Level:=55;
2543: WHEN 'FII_TIME_ENT_PERIOD' THEN l_Level:=23;
2544: WHEN 'FII_TIME_CAL_PERIOD' THEN l_Level:=23;

Line 2855: WHEN 'FII_TIME_CAL_YEAR' THEN l_Level:=119;

2851: END IF;
2852:
2853: CASE p_Period_Type
2854: WHEN 'FII_TIME_ENT_YEAR' THEN l_Level:=119;
2855: WHEN 'FII_TIME_CAL_YEAR' THEN l_Level:=119;
2856: WHEN 'FII_TIME_ENT_QTR' THEN l_Level:=55;
2857: WHEN 'FII_TIME_CAL_QTR' THEN l_Level:=55;
2858: WHEN 'FII_TIME_ENT_PERIOD' THEN l_Level:=23;
2859: WHEN 'FII_TIME_CAL_PERIOD' THEN l_Level:=23;

Line 3334: , fii_time_cal_year yer

3330: , l_Year_Start_Date
3331: FROM fii_time_cal_day_mv day
3332: , fii_time_cal_period prd
3333: , fii_time_cal_qtr qtr
3334: , fii_time_cal_year yer
3335: WHERE
3336: report_date = l_As_Of_Date
3337: AND day.calendar_id = l_Calendar_Id
3338: AND prd.cal_period_id = day.cal_period_id

Line 3349: ELSIF l_Period_Type = 'FII_TIME_ENT_YEAR' OR l_Period_Type = 'FII_TIME_CAL_YEAR' THEN

3345: END IF;
3346:
3347: IF p_Report_Type IS NOT NULL THEN
3348: l_End_Time:=l_Year_Start_Date-1;
3349: ELSIF l_Period_Type = 'FII_TIME_ENT_YEAR' OR l_Period_Type = 'FII_TIME_CAL_YEAR' THEN
3350: l_End_Time:=TO_DATE(Convert_AS_OF_DATE(Convert_AS_OF_DATE(p_As_Of_Date, l_Period_Type, 'YEARLY'), l_Period_Type, 'YEARLY'),'j');
3351: IF l_End_Time IS NULL THEN
3352: l_End_Time:=PJI_UTILS.GET_EXTRACTION_START_DATE;
3353: END IF;

Line 3377: WHEN 'FII_TIME_CAL_YEAR' THEN

3373: l_Level:=119;
3374: l_Start_Time:=l_Year_Start_Date;
3375: l_Def_View_BY:=l_Year_Name;
3376: l_Def_View_BY_ID:=l_Year_ID;
3377: WHEN 'FII_TIME_CAL_YEAR' THEN
3378: l_Level:=119;
3379: l_Start_Time:=l_Year_Start_Date;
3380: l_Def_View_BY:=l_Year_Name;
3381: l_Def_View_BY_ID:=l_Year_ID;

Line 3563: WHEN 'FII_TIME_CAL_YEAR' THEN

3559: SELECT ent_period_id, name, ent_period_id, 32, 'E'
3560: FROM fii_time_ent_period
3561: WHERE start_date > l_End_Time
3562: AND start_date < l_Start_Time;
3563: WHEN 'FII_TIME_CAL_YEAR' THEN
3564: IF p_PA_DEBUG_MODE = 'Y' THEN
3565: Write2FWKLog('Creating time records for fiscal year.');
3566: END IF;
3567: INSERT INTO PJI_PMV_TIME_DIM_TMP

Line 3570: FROM fii_time_cal_year

3566: END IF;
3567: INSERT INTO PJI_PMV_TIME_DIM_TMP
3568: (ID, NAME, ORDER_BY_ID, PERIOD_TYPE, CALENDAR_TYPE)
3569: SELECT cal_year_id, name, cal_year_id, 128, 'G'
3570: FROM fii_time_cal_year
3571: WHERE start_date > l_End_Time
3572: AND start_date < l_Start_Time
3573: AND calendar_id = l_Calendar_Id;
3574: WHEN 'FII_TIME_CAL_QTR' THEN

Line 3670: WHEN 'FII_TIME_CAL_YEAR' THEN

3666: pji_pmv_time_dim_tmp TTMP,
3667: fii_time_ent_year TIME
3668: WHERE TTMP.period_type = l_Level
3669: AND TTMP.id = TIME.ent_year_id;
3670: WHEN 'FII_TIME_CAL_YEAR' THEN
3671: l_Level:=128;
3672: SELECT MIN(TIME.start_date)-1
3673: INTO l_As_Of_Date
3674: FROM

Line 3676: fii_time_cal_year TIME

3672: SELECT MIN(TIME.start_date)-1
3673: INTO l_As_Of_Date
3674: FROM
3675: pji_pmv_time_dim_tmp TTMP,
3676: fii_time_cal_year TIME
3677: WHERE TTMP.period_type = l_Level
3678: AND TTMP.id = TIME.cal_year_id;
3679: WHEN 'FII_TIME_ENT_QTR' THEN
3680: l_Level:=64;

Line 3815: WHEN 'FII_TIME_CAL_YEAR' THEN

3811: SELECT ENT_PERIOD_ID, NULL, DECODE(p_View_BY,'TM',NAME,'-1'), 32, ENT_PERIOD_ID, NULL, 'E'
3812: FROM FII_TIME_ENT_PERIOD
3813: WHERE l_Start_Date <= end_date
3814: AND l_End_Date >=start_date;
3815: WHEN 'FII_TIME_CAL_YEAR' THEN
3816: Write2FWKLog('Creating time records for fiscal year.');
3817: INSERT INTO PJI_PMV_TIME_DIM_TMP (ID, PRIOR_ID, NAME, PERIOD_TYPE, ORDER_BY_ID, AMOUNT_TYPE, CALENDAR_TYPE)
3818: SELECT CAL_YEAR_ID, NULL, DECODE(p_View_BY,'TM',NAME,'-1'), 128, CAL_YEAR_ID, NULL, 'G'
3819: FROM FII_TIME_CAL_YEAR

Line 3819: FROM FII_TIME_CAL_YEAR

3815: WHEN 'FII_TIME_CAL_YEAR' THEN
3816: Write2FWKLog('Creating time records for fiscal year.');
3817: INSERT INTO PJI_PMV_TIME_DIM_TMP (ID, PRIOR_ID, NAME, PERIOD_TYPE, ORDER_BY_ID, AMOUNT_TYPE, CALENDAR_TYPE)
3818: SELECT CAL_YEAR_ID, NULL, DECODE(p_View_BY,'TM',NAME,'-1'), 128, CAL_YEAR_ID, NULL, 'G'
3819: FROM FII_TIME_CAL_YEAR
3820: WHERE l_Start_Date <= end_date
3821: AND l_End_Date >=start_date
3822: AND calendar_id = l_Calendar_ID;
3823: WHEN 'FII_TIME_CAL_QTR' THEN

Line 4198: WHEN 'FII_TIME_CAL_YEAR' THEN l_level:=64;

4194: -- set the level depending on the period_type
4195: CASE p_period_type
4196: WHEN 'ITD' THEN l_level:=128;
4197: WHEN 'FII_TIME_ENT_YEAR' THEN l_level:=64;
4198: WHEN 'FII_TIME_CAL_YEAR' THEN l_level:=64;
4199: WHEN 'FII_TIME_ENT_QTR' THEN l_level:=32;
4200: WHEN 'FII_TIME_CAL_QTR' THEN l_level:=32;
4201: WHEN 'FII_TIME_ENT_PERIOD' THEN l_level:=1;
4202: WHEN 'FII_TIME_CAL_PERIOD' THEN l_level:=1;

Line 4424: FROM fii_time_cal_year, dual

4420:
4421: INSERT INTO PJI_PMV_TIME_DIM_TMP
4422: (ID, NAME, ORDER_BY_ID, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
4423: SELECT cal_year_id, '-1', '-1', 128 , l_amount_type, l_calendar_type_sum
4424: FROM fii_time_cal_year, dual
4425: WHERE calendar_id = l_calendar_id
4426: AND start_date < l_year_start_date_tmp;
4427: END IF;
4428: END IF;

Line 4821: FROM fii_time_cal_year, dual

4817:
4818: INSERT INTO PJI_PMV_TIME_DIM_TMP
4819: (ID, NAME, ORDER_BY_ID, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
4820: SELECT cal_year_id, '-1', '-1', 128 , l_amount_type, l_calendar_type_sum
4821: FROM fii_time_cal_year, dual
4822: WHERE calendar_id = l_calendar_id
4823: AND start_date < l_year_start_date
4824: AND start_date > l_year_start_date_s;
4825: END IF;

Line 5064: WHEN 'TIME+FII_TIME_CAL_YEAR' THEN

5060: G_ViewBY_Table_Name := 'FII_TIME_CAL_PERIOD_V';
5061: WHEN 'TIME+FII_TIME_CAL_QTR' THEN
5062: G_ViewBY_Column_Name := 'TIME_ID';
5063: G_ViewBY_Table_Name := 'FII_TIME_CAL_QTR_V';
5064: WHEN 'TIME+FII_TIME_CAL_YEAR' THEN
5065: G_ViewBY_Column_Name := 'TIME_ID';
5066: G_ViewBY_Table_Name := 'FII_TIME_CAL_YEAR_V';
5067: WHEN 'TIME+FII_TIME_ENT_PERIOD' THEN
5068: G_ViewBY_Column_Name := 'TIME_ID';

Line 5066: G_ViewBY_Table_Name := 'FII_TIME_CAL_YEAR_V';

5062: G_ViewBY_Column_Name := 'TIME_ID';
5063: G_ViewBY_Table_Name := 'FII_TIME_CAL_QTR_V';
5064: WHEN 'TIME+FII_TIME_CAL_YEAR' THEN
5065: G_ViewBY_Column_Name := 'TIME_ID';
5066: G_ViewBY_Table_Name := 'FII_TIME_CAL_YEAR_V';
5067: WHEN 'TIME+FII_TIME_ENT_PERIOD' THEN
5068: G_ViewBY_Column_Name := 'TIME_ID';
5069: G_ViewBY_Table_Name := 'FII_TIME_ENT_PERIOD_V';
5070: WHEN 'TIME+FII_TIME_ENT_QTR' THEN