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_PERIOD

Line 2082: WHEN 'FII_TIME_CAL_PERIOD' THEN l_Level:=23;

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;
2085: WHEN 'FII_ROLLING_WEEK' THEN l_Level:=0;
2086: ELSE NULL;

Line 2468: , fii_time_cal_period period

2464: ,l_Period_Id
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

Line 2525: , fii_time_cal_period period

2521: ,l_Prior_Period_End_Date
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

Line 2544: WHEN 'FII_TIME_CAL_PERIOD' THEN l_Level:=23;

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;
2547: ELSE NULL;
2548: END CASE;

Line 2570: FROM fii_time_cal_period

2566: IF (l_qtr_start_date <> l_as_of_date OR p_Period_Type LIKE '%QTR%') AND l_Level >= 55 THEN
2567: INSERT INTO PJI_PMV_TIME_DIM_TMP
2568: (ID, NAME, ORDER_BY_ID, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
2569: SELECT cal_period_id, l_Default_Period_Name, l_Default_Period_ID, 32, 0, l_Calendar_Type_Sum
2570: FROM fii_time_cal_period
2571: WHERE
2572: start_date>=l_As_Of_Date
2573: AND calendar_id = l_calendar_id
2574: AND end_date<=l_qtr_end_date;

Line 2605: FROM fii_time_cal_period

2601: IF (l_prior_qtr_start_date <> l_prior_as_of_date OR p_Period_Type LIKE '%QTR%') AND l_Level >= 55 THEN
2602: INSERT INTO PJI_PMV_TIME_DIM_TMP
2603: (PRIOR_ID, NAME, ORDER_BY_ID, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
2604: SELECT cal_period_id, l_Default_Period_Name, l_Default_Period_ID, 32, 0, l_Calendar_Type_Sum
2605: FROM fii_time_cal_period
2606: WHERE
2607: start_date>=l_prior_As_Of_Date
2608: AND calendar_id = l_calendar_id
2609: AND end_date<=l_prior_qtr_end_date;

Line 2859: WHEN 'FII_TIME_CAL_PERIOD' THEN l_Level:=23;

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;
2862: ELSE NULL;
2863: END CASE;

Line 3332: , fii_time_cal_period prd

3328: , l_Year_Id
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

Line 3397: WHEN 'FII_TIME_CAL_PERIOD' THEN

3393: l_Level:=23;
3394: l_Start_Time:=l_Period_Start_Date;
3395: l_Def_View_BY:=l_Period_Name;
3396: l_Def_View_BY_ID:=l_Period_ID;
3397: WHEN 'FII_TIME_CAL_PERIOD' THEN
3398: l_Level:=23;
3399: l_Start_Time:=l_Period_Start_Date;
3400: l_Def_View_BY:=l_Period_Name;
3401: l_Def_View_BY_ID:=l_Period_ID;

Line 3585: WHEN 'FII_TIME_CAL_PERIOD' THEN

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
3586: IF p_PA_DEBUG_MODE = 'Y' THEN
3587: Write2FWKLog('Creating time records for fiscal period.');
3588: END IF;
3589: INSERT INTO PJI_PMV_TIME_DIM_TMP

Line 3592: FROM fii_time_cal_period

3588: END IF;
3589: INSERT INTO PJI_PMV_TIME_DIM_TMP
3590: (ID, NAME, ORDER_BY_ID, PERIOD_TYPE, CALENDAR_TYPE)
3591: SELECT cal_period_id, name, cal_period_id, 32, 'G'
3592: FROM fii_time_cal_period
3593: WHERE start_date > l_End_Time
3594: AND start_date < l_Start_Time
3595: AND calendar_id = l_Calendar_Id;
3596: WHEN 'PJI_TIME_PA_PERIOD' THEN

Line 3603: FROM fii_time_cal_period

3599: END IF;
3600: INSERT INTO PJI_PMV_TIME_DIM_TMP
3601: (ID, NAME, ORDER_BY_ID, PERIOD_TYPE, CALENDAR_TYPE)
3602: SELECT cal_period_id, name, cal_period_id, 32, 'P'
3603: FROM fii_time_cal_period
3604: WHERE start_date > l_End_Time
3605: AND start_date < l_Start_Time
3606: AND calendar_id = l_Calendar_Id;
3607: WHEN 'FII_TIME_WEEK' THEN

Line 3706: WHEN 'FII_TIME_CAL_PERIOD' THEN

3702: pji_pmv_time_dim_tmp TTMP,
3703: fii_time_ent_period TIME
3704: WHERE TTMP.period_type = l_Level
3705: AND TTMP.id = TIME.ent_period_id;
3706: WHEN 'FII_TIME_CAL_PERIOD' THEN
3707: l_Level:=32;
3708: SELECT MIN(TIME.start_date)-1
3709: INTO l_As_Of_Date
3710: FROM

Line 3712: fii_time_cal_period TIME

3708: SELECT MIN(TIME.start_date)-1
3709: INTO l_As_Of_Date
3710: FROM
3711: pji_pmv_time_dim_tmp TTMP,
3712: fii_time_cal_period TIME
3713: WHERE TTMP.period_type = l_Level
3714: AND TTMP.id = TIME.cal_period_id;
3715: WHEN 'PJI_TIME_PA_PERIOD' THEN
3716: l_Level:=32;

Line 3721: fii_time_cal_period TIME

3717: SELECT MIN(TIME.start_date)-1
3718: INTO l_As_Of_Date
3719: FROM
3720: pji_pmv_time_dim_tmp TTMP,
3721: fii_time_cal_period TIME
3722: WHERE TTMP.period_type = l_Level
3723: AND TTMP.id = TIME.cal_period_id;
3724: WHEN 'FII_TIME_WEEK' THEN
3725: l_Level:=16;

Line 3831: WHEN 'FII_TIME_CAL_PERIOD' THEN

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
3832: Write2FWKLog('Creating time records for fiscal period.');
3833: INSERT INTO PJI_PMV_TIME_DIM_TMP (ID, PRIOR_ID, NAME, PERIOD_TYPE, ORDER_BY_ID, AMOUNT_TYPE, CALENDAR_TYPE)
3834: SELECT CAL_PERIOD_ID, NULL, DECODE(p_View_BY,'TM',NAME,'-1'), 32, CAL_PERIOD_ID, NULL, 'G'
3835: FROM FII_TIME_CAL_PERIOD

Line 3835: FROM FII_TIME_CAL_PERIOD

3831: WHEN 'FII_TIME_CAL_PERIOD' THEN
3832: Write2FWKLog('Creating time records for fiscal period.');
3833: INSERT INTO PJI_PMV_TIME_DIM_TMP (ID, PRIOR_ID, NAME, PERIOD_TYPE, ORDER_BY_ID, AMOUNT_TYPE, CALENDAR_TYPE)
3834: SELECT CAL_PERIOD_ID, NULL, DECODE(p_View_BY,'TM',NAME,'-1'), 32, CAL_PERIOD_ID, NULL, 'G'
3835: FROM FII_TIME_CAL_PERIOD
3836: WHERE l_Start_Date <= end_date
3837: AND l_End_Date >=start_date
3838: AND calendar_id = l_Calendar_ID;
3839: WHEN 'PJI_TIME_PA_PERIOD' THEN

Line 3843: FROM FII_TIME_CAL_PERIOD

3839: WHEN 'PJI_TIME_PA_PERIOD' THEN
3840: Write2FWKLog('Creating time records for pa period.');
3841: INSERT INTO PJI_PMV_TIME_DIM_TMP (ID, PRIOR_ID, NAME, PERIOD_TYPE, ORDER_BY_ID, AMOUNT_TYPE, CALENDAR_TYPE)
3842: SELECT CAL_PERIOD_ID, NULL, DECODE(p_View_BY,'TM',NAME,'-1'), 32, CAL_PERIOD_ID, NULL, 'G'
3843: FROM FII_TIME_CAL_PERIOD
3844: WHERE l_Start_Date <= end_date
3845: AND l_End_Date >=start_date
3846: AND calendar_id = l_Calendar_ID;
3847: WHEN 'FII_TIME_WEEK' THEN

Line 4202: WHEN 'FII_TIME_CAL_PERIOD' THEN l_level:=1;

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;
4205: ELSE NULL;
4206: END CASE;

Line 4368: FROM fii_time_cal_period, dual

4364:
4365: INSERT INTO PJI_PMV_TIME_DIM_TMP
4366: (ID, NAME, ORDER_BY_ID, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
4367: SELECT cal_period_id, '-1', '-1', 32 , l_amount_type, l_calendar_type_sum
4368: FROM fii_time_cal_period, dual
4369: WHERE cal_qtr_id = l_qtr_id_tmp
4370: AND calendar_id = l_calendar_id
4371: AND start_date < l_period_start_date_tmp;
4372: END IF;

Line 4651: FROM fii_time_cal_period, dual

4647:
4648: INSERT INTO PJI_PMV_TIME_DIM_TMP
4649: (ID, NAME, ORDER_BY_ID, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
4650: SELECT cal_period_id, '-1', '-1', 32 , l_amount_type, l_calendar_type_sum
4651: FROM fii_time_cal_period, dual
4652: WHERE cal_qtr_id = l_qtr_id_s
4653: AND calendar_id = l_calendar_id
4654: AND start_date < l_period_start_date
4655: AND start_date > l_period_start_date_s;

Line 4691: FROM fii_time_cal_period, dual

4687:
4688: INSERT INTO PJI_PMV_TIME_DIM_TMP
4689: (ID, NAME, ORDER_BY_ID, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
4690: SELECT cal_period_id, '-1', '-1', 32 , l_amount_type, l_calendar_type_sum
4691: FROM fii_time_cal_period, dual
4692: WHERE cal_qtr_id = l_qtr_id_s
4693: AND calendar_id = l_calendar_id
4694: AND start_date > l_period_start_date_s;
4695:

Line 4701: FROM fii_time_cal_period, dual

4697:
4698: INSERT INTO PJI_PMV_TIME_DIM_TMP
4699: (ID, NAME, ORDER_BY_ID, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
4700: SELECT cal_period_id, '-1', '-1', 32 , l_amount_type, l_calendar_type_sum
4701: FROM fii_time_cal_period, dual
4702: WHERE cal_qtr_id = l_qtr_id
4703: AND calendar_id = l_calendar_id
4704: AND start_date < l_period_start_date;
4705:

Line 5058: WHEN 'TIME+FII_TIME_CAL_PERIOD' THEN

5054: G_ViewBY_Table_Name := 'PJI_WORK_TYPES_V';
5055: WHEN 'PROJECT+PJI_PROJECTS' THEN
5056: G_ViewBY_Column_Name := 'PROJECT_NAME';
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';

Line 5060: G_ViewBY_Table_Name := 'FII_TIME_CAL_PERIOD_V';

5056: G_ViewBY_Column_Name := 'PROJECT_NAME';
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