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_DAY_MV

Line 2045: Write2FWKLog('Selecting from FII_TIME_CAL_DAY_MV.');

2041: WHERE
2042: report_date = l_As_Of_Date;
2043: ELSE
2044: IF p_PA_DEBUG_MODE = 'Y' THEN
2045: Write2FWKLog('Selecting from FII_TIME_CAL_DAY_MV.');
2046: END IF;
2047: SELECT
2048: cal_period_id, cal_qtr_id, cal_year_id
2049: INTO

Line 2051: FROM fii_time_cal_day_mv

2047: SELECT
2048: cal_period_id, cal_qtr_id, cal_year_id
2049: INTO
2050: l_Period_Id, l_Qtr_Id, l_Year_Id
2051: FROM fii_time_cal_day_mv
2052: WHERE
2053: report_date = l_As_Of_Date
2054: AND calendar_id = l_Calendar_Id;
2055: END IF;

Line 2060: Write2FWKLog('Selecting Prior Period ID from FII_TIME_CAL_DAY_MV for PA Period Type.');

2056: END IF;
2057:
2058: IF p_Period_Type = 'PJI_TIME_PA_PERIOD' AND p_Parse_Prior = 'Y' AND l_Prior_As_Of_Date IS NOT NULL THEN
2059: IF p_PA_DEBUG_MODE = 'Y' THEN
2060: Write2FWKLog('Selecting Prior Period ID from FII_TIME_CAL_DAY_MV for PA Period Type.');
2061: END IF;
2062:
2063: SELECT cal_period_id
2064: INTO l_Prior_Period_Id

Line 2065: FROM fii_time_cal_day_mv

2061: END IF;
2062:
2063: SELECT cal_period_id
2064: INTO l_Prior_Period_Id
2065: FROM fii_time_cal_day_mv
2066: WHERE 1 = 1
2067: AND report_date = l_Prior_As_Of_Date
2068: AND calendar_id = l_Calendar_Id;
2069:

Line 2071: Write2FWKLog('Done selecting Prior Period ID from FII_TIME_CAL_DAY_MV for PA Period Type.');

2067: AND report_date = l_Prior_As_Of_Date
2068: AND calendar_id = l_Calendar_Id;
2069:
2070: IF p_PA_DEBUG_MODE = 'Y' THEN
2071: Write2FWKLog('Done selecting Prior Period ID from FII_TIME_CAL_DAY_MV for PA Period Type.');
2072: END IF;
2073: END IF;
2074:
2075: CASE p_Period_Type

Line 2145: , l_Default_Period_Name, l_Default_Period_ID, 1, 1, 'P' FROM fii_time_cal_day_mv

2141:
2142: INSERT INTO PJI_PMV_TIME_DIM_TMP
2143: (ID, NAME, ORDER_BY_ID, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
2144: SELECT report_date_julian
2145: , l_Default_Period_Name, l_Default_Period_ID, 1, 1, 'P' FROM fii_time_cal_day_mv
2146: WHERE cal_period_id = l_Period_Id
2147: AND calendar_id = l_Calendar_Id
2148: AND report_date<=l_As_Of_Date;
2149:

Line 2159: ,l_Default_Period_Name, l_Default_Period_ID, 1, 1, 'P' FROM fii_time_cal_day_mv

2155:
2156: INSERT INTO PJI_PMV_TIME_DIM_TMP
2157: (PRIOR_ID, NAME, ORDER_BY_ID, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
2158: SELECT report_date_julian
2159: ,l_Default_Period_Name, l_Default_Period_ID, 1, 1, 'P' FROM fii_time_cal_day_mv
2160: WHERE cal_period_id = l_Prior_Period_Id
2161: AND calendar_id = l_Calendar_Id
2162: AND report_date<=l_Prior_As_Of_Date;
2163:

Line 2446: Write2FWKLog('Selecting from FII_TIME_CAL_DAY_MV.');

2442: AND qtr.ent_qtr_id = day.ent_qtr_id
2443: AND year.ent_year_id = day.ent_year_id;
2444: ELSE
2445: IF p_PA_DEBUG_MODE = 'Y' THEN
2446: Write2FWKLog('Selecting from FII_TIME_CAL_DAY_MV.');
2447: END IF;
2448: SELECT period.start_date period_start_date
2449: ,qtr.start_date qtr_start_date
2450: ,year.start_date year_start_date

Line 2467: FROM fii_time_cal_day_mv day

2463: ,l_Year_End_Date
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

Line 2509: Write2FWKLog('Selecting from FII_TIME_CAL_DAY_MV.');

2505: AND qtr.ent_qtr_id = day.ent_qtr_id
2506: AND year.ent_year_id = day.ent_year_id;
2507: ELSE
2508: IF p_PA_DEBUG_MODE = 'Y' THEN
2509: Write2FWKLog('Selecting from FII_TIME_CAL_DAY_MV.');
2510: END IF;
2511: SELECT period.start_date period_start_date
2512: ,qtr.start_date qtr_start_date
2513: ,year.start_date year_start_date

Line 2524: FROM fii_time_cal_day_mv day

2520: ,l_Prior_Year_Start_Date
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

Line 2559: FROM fii_time_cal_day_mv

2555: IF (l_period_start_date <> l_as_of_date OR p_Period_Type LIKE '%PERIOD%') AND l_Level >= 11 THEN
2556: INSERT INTO PJI_PMV_TIME_DIM_TMP
2557: (ID, NAME, ORDER_BY_ID, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
2558: SELECT report_date_julian, l_Default_Period_Name, l_Default_Period_ID, 1, 0, l_Calendar_Type_Day
2559: FROM fii_time_cal_day_mv
2560: WHERE
2561: report_date>=l_As_Of_Date
2562: AND calendar_id = l_calendar_id
2563: AND report_date<=l_period_end_date;

Line 2595: FROM fii_time_cal_day_mv

2591: IF (l_prior_period_start_date <> l_prior_as_of_date OR p_Period_Type LIKE '%PERIOD%') AND l_Level >= 11 THEN
2592: INSERT INTO PJI_PMV_TIME_DIM_TMP
2593: (PRIOR_ID, NAME, ORDER_BY_ID, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
2594: SELECT report_date_julian, l_Default_Period_Name, l_Default_Period_ID, 1, 0, l_Calendar_Type_Day
2595: FROM fii_time_cal_day_mv
2596: WHERE
2597: report_date>=l_prior_As_Of_Date
2598: AND calendar_id = l_calendar_id
2599: AND report_date<=l_prior_period_end_date;

Line 2840: Write2FWKLog('Selecting from FII_TIME_CAL_DAY_MV.');

2836: WHERE
2837: report_date = l_As_Of_Date;
2838: ELSE
2839: IF p_PA_DEBUG_MODE = 'Y' THEN
2840: Write2FWKLog('Selecting from FII_TIME_CAL_DAY_MV.');
2841: END IF;
2842: SELECT
2843: cal_period_id, cal_qtr_id, cal_year_id
2844: INTO

Line 2846: FROM fii_time_cal_day_mv

2842: SELECT
2843: cal_period_id, cal_qtr_id, cal_year_id
2844: INTO
2845: l_Period_Id, l_Qtr_Id, l_Year_Id
2846: FROM fii_time_cal_day_mv
2847: WHERE
2848: report_date = l_As_Of_Date
2849: AND calendar_id = l_Calendar_Id;
2850: END IF;

Line 2899: , '-1', 1, 1, 'P' FROM fii_time_cal_day_mv

2895:
2896: INSERT INTO PJI_PMV_TCMP_DIM_TMP
2897: (ID, NAME, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
2898: SELECT report_date_julian
2899: , '-1', 1, 1, 'P' FROM fii_time_cal_day_mv
2900: WHERE cal_period_id = l_Period_Id
2901: AND calendar_id = l_Calendar_Id
2902: AND report_date<=l_As_Of_Date;
2903:

Line 3030: Write2FWKLog('Selecting from FII_TIME_CAL_DAY_MV.');

3026: END IF;
3027:
3028: IF l_Period_Type = 'PJI_TIME_PA_PERIOD' THEN
3029: IF p_PA_DEBUG_MODE = 'Y' THEN
3030: Write2FWKLog('Selecting from FII_TIME_CAL_DAY_MV.');
3031: END IF;
3032: SELECT cal_period_id
3033: INTO l_Period_Id
3034: FROM fii_time_cal_day_mv

Line 3034: FROM fii_time_cal_day_mv

3030: Write2FWKLog('Selecting from FII_TIME_CAL_DAY_MV.');
3031: END IF;
3032: SELECT cal_period_id
3033: INTO l_Period_Id
3034: FROM fii_time_cal_day_mv
3035: WHERE
3036: report_date = l_As_Of_Date
3037: AND calendar_id = l_Calendar_Id;
3038: END IF;

Line 3042: Write2FWKLog('Selecting Prior Period ID from FII_TIME_CAL_DAY_MV for PA Period Type.');

3038: END IF;
3039:
3040: IF p_Period_Type = 'PJI_TIME_PA_PERIOD' AND p_Parse_Prior = 'Y' AND l_Prior_As_Of_Date IS NOT NULL THEN
3041: IF p_PA_DEBUG_MODE = 'Y' THEN
3042: Write2FWKLog('Selecting Prior Period ID from FII_TIME_CAL_DAY_MV for PA Period Type.');
3043: END IF;
3044:
3045: SELECT cal_period_id
3046: INTO l_Prior_Period_Id

Line 3047: FROM fii_time_cal_day_mv

3043: END IF;
3044:
3045: SELECT cal_period_id
3046: INTO l_Prior_Period_Id
3047: FROM fii_time_cal_day_mv
3048: WHERE 1 = 1
3049: AND report_date = l_Prior_As_Of_Date
3050: AND calendar_id = l_Calendar_Id;
3051:

Line 3053: Write2FWKLog('Done selecting Prior Period ID from FII_TIME_CAL_DAY_MV for PA Period Type.');

3049: AND report_date = l_Prior_As_Of_Date
3050: AND calendar_id = l_Calendar_Id;
3051:
3052: IF p_PA_DEBUG_MODE = 'Y' THEN
3053: Write2FWKLog('Done selecting Prior Period ID from FII_TIME_CAL_DAY_MV for PA Period Type.');
3054: END IF;
3055: END IF;
3056:
3057: IF p_Period_Type <> 'PJI_TIME_PA_PERIOD' THEN

Line 3113: , '-1', '-1', 1, p_Comparator, 'P' FROM fii_time_cal_day_mv

3109:
3110: INSERT INTO PJI_PMV_ITD_DIM_TMP
3111: (ID, NAME, ORDER_BY_ID, PERIOD_TYPE, COMPARATOR_TYPE, CALENDAR_TYPE)
3112: SELECT report_date_julian
3113: , '-1', '-1', 1, p_Comparator, 'P' FROM fii_time_cal_day_mv
3114: WHERE cal_period_id = l_Period_Id
3115: AND calendar_id = l_Calendar_Id
3116: AND report_date<=l_As_Of_Date;
3117:

Line 3136: , '-1', '-1', 1, p_Comparator, 'P' FROM fii_time_cal_day_mv

3132:
3133: INSERT INTO PJI_PMV_ITD_DIM_TMP
3134: (PRIOR_ID, NAME, ORDER_BY_ID, PERIOD_TYPE, COMPARATOR_TYPE, CALENDAR_TYPE)
3135: SELECT report_date_julian
3136: , '-1', '-1', 1, p_Comparator, 'P' FROM fii_time_cal_day_mv
3137: WHERE cal_period_id = l_Prior_Period_Id
3138: AND calendar_id = l_Calendar_Id
3139: AND report_date<=l_Prior_As_Of_Date;
3140:

Line 3309: Write2FWKLog('Selecting from FII_TIME_CAL_DAY_MV.');

3305: AND qtr.ent_qtr_id = day.ent_qtr_id
3306: AND yer.ent_year_id = day.ent_year_id;
3307: ELSE
3308: IF p_PA_DEBUG_MODE = 'Y' THEN
3309: Write2FWKLog('Selecting from FII_TIME_CAL_DAY_MV.');
3310: END IF;
3311: SELECT
3312: day.cal_period_id
3313: , prd.name

Line 3331: FROM fii_time_cal_day_mv day

3327: , l_Qtr_Start_Date
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

Line 3478: , l_Def_View_BY, l_Def_View_BY_ID, 1, 1, 'P' FROM fii_time_cal_day_mv

3474:
3475: INSERT INTO PJI_PMV_TIME_DIM_TMP
3476: (ID, NAME, ORDER_BY_ID, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
3477: SELECT report_date_julian
3478: , l_Def_View_BY, l_Def_View_BY_ID, 1, 1, 'P' FROM fii_time_cal_day_mv
3479: WHERE cal_period_id = l_Period_Id
3480: AND calendar_id = l_Calendar_Id
3481: AND report_date<=l_As_Of_Date;
3482:

Line 3492: , l_Def_View_BY, l_Def_View_BY_ID, 1, 1, 'P' FROM fii_time_cal_day_mv

3488:
3489: INSERT INTO PJI_PMV_TIME_DIM_TMP
3490: (PRIOR_ID, NAME, ORDER_BY_ID, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
3491: SELECT report_date_julian
3492: , l_Def_View_BY, l_Def_View_BY_ID, 1, 1, 'P' FROM fii_time_cal_day_mv
3493: WHERE cal_period_id = l_Prior_Period_Id
3494: AND calendar_id = l_Calendar_Id
3495: AND report_date<=l_Prior_As_Of_Date;
3496:

Line 4169: Write2FWKLog('Selecting from FII_TIME_CAL_DAY_MV for as_of_date and last_summ_date');

4165: FROM fii_time_day
4166: WHERE report_date = l_summ_date;
4167:
4168: ELSE
4169: Write2FWKLog('Selecting from FII_TIME_CAL_DAY_MV for as_of_date and last_summ_date');
4170:
4171: SELECT cal_period_id, cal_period_start_date,
4172: cal_qtr_id, cal_qtr_start_date,
4173: cal_year_id, cal_year_start_date

Line 4177: FROM fii_time_cal_day_mv

4173: cal_year_id, cal_year_start_date
4174: INTO l_period_id, l_period_start_date,
4175: l_qtr_id, l_qtr_start_date,
4176: l_year_id, l_year_start_date
4177: FROM fii_time_cal_day_mv
4178: WHERE report_date = l_as_of_date
4179: AND calendar_id = l_calendar_id;
4180:
4181: SELECT cal_period_id, cal_period_start_date,

Line 4187: FROM fii_time_cal_day_mv

4183: cal_year_id, cal_year_start_date
4184: INTO l_period_id_s, l_period_start_date_s,
4185: l_qtr_id_s, l_qtr_start_date_s,
4186: l_year_id_s, l_year_start_date_s
4187: FROM fii_time_cal_day_mv
4188: WHERE report_date = l_summ_date
4189: AND calendar_id = l_calendar_id;
4190:
4191: END IF;

Line 4328: FROM fii_time_cal_day_mv, dual

4324:
4325: INSERT INTO PJI_PMV_TIME_DIM_TMP
4326: (ID, NAME, ORDER_BY_ID, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
4327: SELECT report_date_julian, '-1', '-1', 1, l_amount_type, l_calendar_type_day
4328: FROM fii_time_cal_day_mv, dual
4329: WHERE cal_period_id = l_period_id_tmp
4330: AND calendar_id = l_calendar_id
4331: AND report_date <= l_date;
4332:

Line 4338: FROM fii_time_cal_day_mv

4334: Write2FWKLog('Creating day slice for the prior year period - Fiscal Cal.');
4335: INSERT INTO PJI_PMV_TIME_DIM_TMP
4336: (PRIOR_ID, NAME, ORDER_BY_ID, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
4337: SELECT report_date_julian, '-1', '-1', 1, l_amount_type, l_calendar_type_day
4338: FROM fii_time_cal_day_mv
4339: WHERE cal_period_id = SUBSTR(LPAD(l_period_id_tmp,10,'0'),1,3)||TO_CHAR(SUBSTR(LPAD(l_period_id_tmp,10,'0'),4,4)-1)||SUBSTR(LPAD(l_period_id_tmp,10,'0'),8)
4340: AND calendar_id = l_calendar_id
4341: AND report_date <= l_prior_date;
4342: END IF;

Line 4510: FROM fii_time_cal_day_mv, dual

4506:
4507: INSERT INTO PJI_PMV_TIME_DIM_TMP
4508: (ID, NAME, ORDER_BY_ID, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
4509: SELECT report_date_julian, '-1', '-1', 1, l_amount_type, l_calendar_type_day
4510: FROM fii_time_cal_day_mv, dual
4511: WHERE cal_period_id = l_period_id
4512: AND calendar_id = l_calendar_id
4513: AND report_date > l_summ_date
4514: AND report_date <= l_as_of_date;

Line 4521: FROM fii_time_cal_day_mv

4517: Write2FWKLog('Creating day slice for the prior year period between the two dates - Fiscal Cal - scheduled.');
4518: INSERT INTO PJI_PMV_TIME_DIM_TMP
4519: (PRIOR_ID, NAME, ORDER_BY_ID, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
4520: SELECT report_date_julian, '-1', '-1', 1, l_amount_type, l_calendar_type_day
4521: FROM fii_time_cal_day_mv
4522: WHERE cal_period_id = SUBSTR(LPAD(l_period_id,10,'0'),1,3)||TO_CHAR(SUBSTR(LPAD(l_period_id,10,'0'),4,4)-1)||SUBSTR(LPAD(l_period_id,10,'0'),8)
4523: AND calendar_id = l_calendar_id
4524: AND report_date > l_prior_summ_date
4525: AND report_date <= l_prior_as_of_date;

Line 4582: FROM fii_time_cal_day_mv, dual

4578:
4579: INSERT INTO PJI_PMV_TIME_DIM_TMP
4580: (ID, NAME, ORDER_BY_ID, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
4581: SELECT report_date_julian, '-1', '-1', 1, l_amount_type, l_calendar_type_day
4582: FROM fii_time_cal_day_mv, dual
4583: WHERE cal_period_id = l_period_id_s
4584: AND calendar_id = l_calendar_id
4585: AND report_date > l_summ_date;
4586:

Line 4592: FROM fii_time_cal_day_mv

4588: Write2FWKLog('Creating day slice for the prior year period of last_summ_date - Fiscal Cal - scheduled');
4589: INSERT INTO PJI_PMV_TIME_DIM_TMP
4590: (PRIOR_ID, NAME, ORDER_BY_ID, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
4591: SELECT report_date_julian, '-1', '-1', 1, l_amount_type, l_calendar_type_day
4592: FROM fii_time_cal_day_mv
4593: WHERE cal_period_id = SUBSTR(LPAD(l_period_id_s,10,'0'),1,3)||TO_CHAR(SUBSTR(LPAD(l_period_id_s,10,'0'),4,4)-1)||SUBSTR(LPAD(l_period_id_s,10,'0'),8)
4594: AND calendar_id = l_calendar_id
4595: AND report_date > l_prior_summ_date;
4596: END IF;

Line 4603: FROM fii_time_cal_day_mv, dual

4599:
4600: INSERT INTO PJI_PMV_TIME_DIM_TMP
4601: (ID, NAME, ORDER_BY_ID, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
4602: SELECT report_date_julian, '-1', '-1', 1, l_amount_type, l_calendar_type_day
4603: FROM fii_time_cal_day_mv, dual
4604: WHERE cal_period_id = l_period_id
4605: AND calendar_id = l_calendar_id
4606: AND report_date <= l_as_of_date;
4607:

Line 4613: FROM fii_time_cal_day_mv

4609: Write2FWKLog('Creating day slice for the prior year period of as_of_date - Fiscal Cal - scheduled');
4610: INSERT INTO PJI_PMV_TIME_DIM_TMP
4611: (PRIOR_ID, NAME, ORDER_BY_ID, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
4612: SELECT report_date_julian, '-1', '-1', 1, l_amount_type, l_calendar_type_day
4613: FROM fii_time_cal_day_mv
4614: WHERE cal_period_id = SUBSTR(LPAD(l_period_id,10,'0'),1,3)||TO_CHAR(SUBSTR(LPAD(l_period_id,10,'0'),4,4)-1)||SUBSTR(LPAD(l_period_id,10,'0'),8)
4615: AND calendar_id = l_calendar_id
4616: AND report_date <= l_prior_as_of_date;
4617: END IF;