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_QTR

Line 2080: WHEN 'FII_TIME_CAL_QTR' THEN l_Level:=55;

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;
2083: WHEN 'PJI_TIME_PA_PERIOD' THEN l_Level:=23;
2084: WHEN 'FII_TIME_WEEK' THEN l_Level:=11;

Line 2469: , fii_time_cal_qtr qtr

2465: ,l_Qtr_Id
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

Line 2526: , fii_time_cal_qtr qtr

2522: ,l_Prior_Qtr_End_Date
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

Line 2542: WHEN 'FII_TIME_CAL_QTR' THEN l_Level:=55;

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;
2545: WHEN 'PJI_TIME_PA_PERIOD' THEN l_Level:=23;
2546: WHEN 'FII_TIME_WEEK' THEN l_Level:=11;

Line 2581: FROM fii_time_cal_qtr

2577: IF (l_year_start_date <> l_as_of_date OR p_Period_Type LIKE '%YEAR%') AND l_Level >= 119 THEN
2578: INSERT INTO PJI_PMV_TIME_DIM_TMP
2579: (ID, NAME, ORDER_BY_ID, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
2580: SELECT cal_qtr_id, l_Default_Period_Name, l_Default_Period_ID, 64, 0, l_Calendar_Type_Sum
2581: FROM fii_time_cal_qtr
2582: WHERE
2583: start_date>=l_As_Of_Date
2584: AND calendar_id = l_calendar_id
2585: AND end_date<=l_year_end_date;

Line 2616: FROM fii_time_cal_qtr

2612: IF (l_prior_year_start_date <> l_prior_as_of_date OR p_Period_Type LIKE '%YEAR%') AND l_Level >= 119 THEN
2613: INSERT INTO PJI_PMV_TIME_DIM_TMP
2614: (PRIOR_ID, NAME, ORDER_BY_ID, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
2615: SELECT cal_qtr_id, l_Default_Period_Name, l_Default_Period_ID, 64, 0, l_Calendar_Type_Sum
2616: FROM fii_time_cal_qtr
2617: WHERE
2618: start_date>=l_prior_As_Of_Date
2619: AND calendar_id = l_calendar_id
2620: AND end_date<=l_prior_year_end_date;

Line 2857: WHEN 'FII_TIME_CAL_QTR' THEN l_Level:=55;

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;
2860: WHEN 'PJI_TIME_PA_PERIOD' THEN l_Level:=23;
2861: WHEN 'FII_TIME_WEEK' THEN l_Level:=11;

Line 3333: , fii_time_cal_qtr qtr

3329: , l_Year_Name
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

Line 3387: WHEN 'FII_TIME_CAL_QTR' THEN

3383: l_Level:=55;
3384: l_Start_Time:=l_Qtr_Start_Date;
3385: l_Def_View_BY:=l_Qtr_Name;
3386: l_Def_View_BY_ID:=l_Qtr_ID;
3387: WHEN 'FII_TIME_CAL_QTR' THEN
3388: l_Level:=55;
3389: l_Start_Time:=l_Qtr_Start_Date;
3390: l_Def_View_BY:=l_Qtr_Name;
3391: l_Def_View_BY_ID:=l_Qtr_ID;

Line 3574: WHEN 'FII_TIME_CAL_QTR' THEN

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
3575: IF p_PA_DEBUG_MODE = 'Y' THEN
3576: Write2FWKLog('Creating time records for fiscal quarter.');
3577: END IF;
3578: INSERT INTO PJI_PMV_TIME_DIM_TMP

Line 3581: FROM fii_time_cal_qtr

3577: END IF;
3578: INSERT INTO PJI_PMV_TIME_DIM_TMP
3579: (ID, NAME, ORDER_BY_ID, PERIOD_TYPE, CALENDAR_TYPE)
3580: SELECT cal_qtr_id, name, cal_qtr_id, 64, 'G'
3581: FROM fii_time_cal_qtr
3582: WHERE start_date > l_End_Time
3583: AND start_date < l_Start_Time
3584: AND calendar_id = l_Calendar_Id;
3585: WHEN 'FII_TIME_CAL_PERIOD' THEN

Line 3688: WHEN 'FII_TIME_CAL_QTR' THEN

3684: pji_pmv_time_dim_tmp TTMP,
3685: fii_time_ent_qtr TIME
3686: WHERE TTMP.period_type = l_Level
3687: AND TTMP.id = TIME.ent_qtr_id;
3688: WHEN 'FII_TIME_CAL_QTR' THEN
3689: l_Level:=64;
3690: SELECT MIN(TIME.start_date)-1
3691: INTO l_As_Of_Date
3692: FROM

Line 3694: fii_time_cal_qtr TIME

3690: SELECT MIN(TIME.start_date)-1
3691: INTO l_As_Of_Date
3692: FROM
3693: pji_pmv_time_dim_tmp TTMP,
3694: fii_time_cal_qtr TIME
3695: WHERE TTMP.period_type = l_Level
3696: AND TTMP.id = TIME.cal_qtr_id;
3697: WHEN 'FII_TIME_ENT_PERIOD' THEN
3698: l_Level:=32;

Line 3823: WHEN 'FII_TIME_CAL_QTR' THEN

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
3824: Write2FWKLog('Creating time records for fiscal quarter.');
3825: INSERT INTO PJI_PMV_TIME_DIM_TMP (ID, PRIOR_ID, NAME, PERIOD_TYPE, ORDER_BY_ID, AMOUNT_TYPE, CALENDAR_TYPE)
3826: SELECT CAL_QTR_ID, NULL, DECODE(p_View_BY,'TM',NAME,'-1'), 64, CAL_QTR_ID, NULL, 'G'
3827: FROM FII_TIME_CAL_QTR

Line 3827: FROM FII_TIME_CAL_QTR

3823: WHEN 'FII_TIME_CAL_QTR' THEN
3824: Write2FWKLog('Creating time records for fiscal quarter.');
3825: INSERT INTO PJI_PMV_TIME_DIM_TMP (ID, PRIOR_ID, NAME, PERIOD_TYPE, ORDER_BY_ID, AMOUNT_TYPE, CALENDAR_TYPE)
3826: SELECT CAL_QTR_ID, NULL, DECODE(p_View_BY,'TM',NAME,'-1'), 64, CAL_QTR_ID, NULL, 'G'
3827: FROM FII_TIME_CAL_QTR
3828: WHERE l_Start_Date <= end_date
3829: AND l_End_Date >=start_date
3830: AND calendar_id = l_Calendar_ID;
3831: WHEN 'FII_TIME_CAL_PERIOD' THEN

Line 4200: WHEN 'FII_TIME_CAL_QTR' THEN l_level:=32;

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;
4203: WHEN 'PJI_TIME_PA_PERIOD' THEN l_level:=1;
4204: WHEN 'FII_TIME_WEEK' THEN l_level:=0;

Line 4396: FROM fii_time_cal_qtr, dual

4392:
4393: INSERT INTO PJI_PMV_TIME_DIM_TMP
4394: (ID, NAME, ORDER_BY_ID, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
4395: SELECT cal_qtr_id, '-1', '-1', 64 , l_amount_type, l_calendar_type_sum
4396: FROM fii_time_cal_qtr, dual
4397: WHERE cal_year_id = l_year_id_tmp
4398: AND calendar_id = l_calendar_id
4399: AND start_date < l_qtr_start_date_tmp;
4400: END IF;

Line 4737: FROM fii_time_cal_qtr, dual

4733:
4734: INSERT INTO PJI_PMV_TIME_DIM_TMP
4735: (ID, NAME, ORDER_BY_ID, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
4736: SELECT cal_qtr_id, '-1', '-1', 64 , l_amount_type, l_calendar_type_sum
4737: FROM fii_time_cal_qtr, dual
4738: WHERE cal_year_id = l_year_id
4739: AND calendar_id = l_calendar_id
4740: AND start_date < l_qtr_start_date
4741: AND start_date > l_qtr_start_date_s;

Line 4778: FROM fii_time_cal_qtr, dual

4774:
4775: INSERT INTO PJI_PMV_TIME_DIM_TMP
4776: (ID, NAME, ORDER_BY_ID, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
4777: SELECT cal_qtr_id, '-1', '-1', 64 , l_amount_type, l_calendar_type_sum
4778: FROM fii_time_cal_qtr, dual
4779: WHERE cal_year_id = l_year_id_s
4780: AND calendar_id = l_calendar_id
4781: AND start_date > l_qtr_start_date_s;
4782:

Line 4788: FROM fii_time_cal_qtr, dual

4784:
4785: INSERT INTO PJI_PMV_TIME_DIM_TMP
4786: (ID, NAME, ORDER_BY_ID, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
4787: SELECT cal_qtr_id, '-1', '-1', 64 , l_amount_type, l_calendar_type_sum
4788: FROM fii_time_cal_qtr, dual
4789: WHERE cal_year_id = l_year_id
4790: AND calendar_id = l_calendar_id
4791: AND start_date < l_qtr_start_date;
4792:

Line 5061: WHEN 'TIME+FII_TIME_CAL_QTR' THEN

5057: G_ViewBY_Table_Name := 'PJI_PROJECTS_V';
5058: WHEN 'TIME+FII_TIME_CAL_PERIOD' THEN
5059: G_ViewBY_Column_Name := 'TIME_ID';
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';

Line 5063: G_ViewBY_Table_Name := 'FII_TIME_CAL_QTR_V';

5059: G_ViewBY_Column_Name := 'TIME_ID';
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