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_DAY

Line 2034: Write2FWKLog('Selecting from FII_TIME_DAY.');

2030:
2031: IF p_Full_Period_Flag IS NOT NULL OR l_Period_Type = 'PJI_TIME_PA_PERIOD' THEN
2032: IF l_IS_GL_Flag IS NULL THEN
2033: IF p_PA_DEBUG_MODE = 'Y' THEN
2034: Write2FWKLog('Selecting from FII_TIME_DAY.');
2035: END IF;
2036: SELECT
2037: ent_period_id, week_id, week_start_date, ent_qtr_id, ent_year_id
2038: INTO

Line 2040: FROM fii_time_day

2036: SELECT
2037: ent_period_id, week_id, week_start_date, ent_qtr_id, ent_year_id
2038: INTO
2039: l_Period_Id, l_Week_Id, l_Week_Start_Date, l_Qtr_Id, l_Year_Id
2040: FROM fii_time_day
2041: WHERE
2042: report_date = l_As_Of_Date;
2043: ELSE
2044: IF p_PA_DEBUG_MODE = 'Y' THEN

Line 2411: Write2FWKLog('Selecting from FII_TIME_DAY.');

2407: END IF;
2408:
2409: IF l_IS_GL_Flag IS NULL THEN
2410: IF p_PA_DEBUG_MODE = 'Y' THEN
2411: Write2FWKLog('Selecting from FII_TIME_DAY.');
2412: END IF;
2413:
2414: SELECT period.start_date period_start_date
2415: ,qtr.start_date qtr_start_date

Line 2435: FROM fii_time_day day

2431: ,l_Period_Id
2432: ,l_Week_ID
2433: ,l_Qtr_Id
2434: ,l_Year_Id
2435: FROM fii_time_day day
2436: , fii_time_ent_period period
2437: , fii_time_ent_qtr qtr
2438: , fii_time_ent_year year
2439: WHERE 1=1

Line 2482: Write2FWKLog('Selecting from FII_TIME_DAY.');

2478:
2479: IF p_Parse_Prior = 'Y' THEN
2480: IF l_IS_GL_Flag IS NULL THEN
2481: IF p_PA_DEBUG_MODE = 'Y' THEN
2482: Write2FWKLog('Selecting from FII_TIME_DAY.');
2483: END IF;
2484:
2485: SELECT period.start_date period_start_date
2486: ,qtr.start_date qtr_start_date

Line 2498: FROM fii_time_day day

2494: ,l_Prior_Year_Start_Date
2495: ,l_Prior_Period_End_Date
2496: ,l_Prior_Qtr_End_Date
2497: ,l_Prior_Year_End_Date
2498: FROM fii_time_day day
2499: , fii_time_ent_period period
2500: , fii_time_ent_qtr qtr
2501: , fii_time_ent_year year
2502: WHERE 1=1

Line 2628: FROM fii_time_day

2624: IF (l_period_start_date <> l_as_of_date OR p_Period_Type LIKE '%PERIOD%') AND l_Level >= 11 THEN
2625: INSERT INTO PJI_PMV_TIME_DIM_TMP
2626: (ID, NAME, ORDER_BY_ID, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
2627: SELECT report_date_julian, l_Default_Period_Name, l_Default_Period_ID, 1, 0, l_Calendar_Type_Day
2628: FROM fii_time_day
2629: WHERE
2630: report_date>=l_As_Of_Date
2631: AND report_date<=l_period_end_date;
2632: END IF;

Line 2661: FROM fii_time_day

2657: IF (l_prior_period_start_date <> l_prior_as_of_date OR p_Period_Type LIKE '%PERIOD%') AND l_Level >= 11 THEN
2658: INSERT INTO PJI_PMV_TIME_DIM_TMP
2659: (PRIOR_ID, NAME, ORDER_BY_ID, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
2660: SELECT report_date_julian, l_Default_Period_Name, l_Default_Period_ID, 1, 0, l_Calendar_Type_Day
2661: FROM fii_time_day
2662: WHERE
2663: report_date>=l_prior_As_Of_Date
2664: AND report_date<=l_Prior_period_end_date;
2665: END IF;

Line 2829: Write2FWKLog('Selecting from FII_TIME_DAY.');

2825:
2826: IF p_Full_Period_Flag IS NOT NULL OR l_Period_Type = 'PJI_TIME_PA_PERIOD' THEN
2827: IF l_IS_GL_Flag IS NULL THEN
2828: IF p_PA_DEBUG_MODE = 'Y' THEN
2829: Write2FWKLog('Selecting from FII_TIME_DAY.');
2830: END IF;
2831: SELECT
2832: ent_period_id, week_id, ent_qtr_id, ent_year_id
2833: INTO

Line 2835: FROM fii_time_day

2831: SELECT
2832: ent_period_id, week_id, ent_qtr_id, ent_year_id
2833: INTO
2834: l_Period_Id, l_Week_Id, l_Qtr_Id, l_Year_Id
2835: FROM fii_time_day
2836: WHERE
2837: report_date = l_As_Of_Date;
2838: ELSE
2839: IF p_PA_DEBUG_MODE = 'Y' THEN

Line 3268: Write2FWKLog('Selecting from FII_TIME_DAY.');

3264: END IF;
3265:
3266: IF l_IS_GL_Flag IS NULL THEN
3267: IF p_PA_DEBUG_MODE = 'Y' THEN
3268: Write2FWKLog('Selecting from FII_TIME_DAY.');
3269: END IF;
3270: SELECT
3271: day.ent_period_id
3272: , prd.name

Line 3296: FROM fii_time_day day

3292: , l_Qtr_Start_Date
3293: , l_Year_Id
3294: , l_Year_Name
3295: , l_Year_Start_Date
3296: FROM fii_time_day day
3297: , fii_time_week wek
3298: , fii_time_ent_period prd
3299: , fii_time_ent_qtr qtr
3300: , fii_time_ent_year yer

Line 4144: Write2FWKLog('Selecting from FII_TIME_DAY for as_of_date and last_summ_date');

4140: -- quarter, year for the as_of_date and the last
4141: -- summarized date
4142:
4143: IF l_is_GL IS NULL THEN
4144: Write2FWKLog('Selecting from FII_TIME_DAY for as_of_date and last_summ_date');
4145:
4146: SELECT ent_period_id, ent_period_start_date,
4147: ent_qtr_id, ent_qtr_start_date,
4148: ent_year_id, ent_year_start_date,

Line 4154: FROM fii_time_day

4150: INTO l_period_id, l_period_start_date,
4151: l_qtr_id, l_qtr_start_date,
4152: l_year_id, l_year_start_date,
4153: l_week_id, l_week_start_date
4154: FROM fii_time_day
4155: WHERE report_date = l_as_of_date;
4156:
4157: SELECT ent_period_id, ent_period_start_date,
4158: ent_qtr_id, ent_qtr_start_date,

Line 4165: FROM fii_time_day

4161: INTO l_period_id_s, l_period_start_date_s,
4162: l_qtr_id_s, l_qtr_start_date_s,
4163: l_year_id_s, l_year_start_date_s,
4164: l_week_id_s, l_week_start_date_s
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');

Line 4280: FROM fii_time_day, dual

4276: Write2FWKLog('Creating day slice for the given week.');
4277: INSERT INTO PJI_PMV_TIME_DIM_TMP
4278: (ID, NAME, ORDER_BY_ID, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
4279: SELECT report_date_julian, '-1', '-1', 1 , l_amount_type, l_calendar_type_day
4280: FROM fii_time_day, dual
4281: WHERE week_id = l_week_id_tmp
4282: AND report_date <= l_date;
4283:
4284: IF p_parse_prior IS NOT NULL THEN

Line 4289: FROM fii_time_day

4285: Write2FWKLog('Creating day slice for the prior year week.');
4286: INSERT INTO PJI_PMV_TIME_DIM_TMP
4287: (PRIOR_ID, NAME, ORDER_BY_ID, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
4288: SELECT report_date_julian, '-1', '-1', 1, l_amount_type, l_calendar_type_day
4289: FROM fii_time_day
4290: WHERE week_id = SUBSTR(LPAD(l_week_id_tmp,11,'0'),1,3)||TO_CHAR(SUBSTR(LPAD(l_week_id_tmp,11,'0'),4,4)-1)||SUBSTR(LPAD(l_week_id_tmp,11,'0'),8)
4291: AND report_date <= l_prior_date;
4292: END IF;
4293:

Line 4308: FROM fii_time_day, dual

4304:
4305: INSERT INTO PJI_PMV_TIME_DIM_TMP
4306: (ID, NAME, ORDER_BY_ID, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
4307: SELECT report_date_julian, '-1', '-1', 1 , l_amount_type, l_calendar_type_day
4308: FROM fii_time_day, dual
4309: WHERE ent_period_id = l_period_id_tmp
4310: AND report_date <= l_date;
4311:
4312: IF p_parse_prior IS NOT NULL THEN

Line 4317: FROM fii_time_day

4313: Write2FWKLog('Creating day slice for the prior year period - Enterprise Cal.');
4314: INSERT INTO PJI_PMV_TIME_DIM_TMP
4315: (PRIOR_ID, NAME, ORDER_BY_ID, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
4316: SELECT report_date_julian, '-1', '-1', 1, l_amount_type, l_calendar_type_day
4317: FROM fii_time_day
4318: WHERE ent_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)
4319: AND report_date <= l_prior_date;
4320: END IF;
4321:

Line 4456: FROM fii_time_day, dual

4452: Write2FWKLog('Creating day slice for the given week between the two dates - scheduled');
4453: INSERT INTO PJI_PMV_TIME_DIM_TMP
4454: (ID, NAME, ORDER_BY_ID, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
4455: SELECT report_date_julian, '-1', '-1', 1 , l_amount_type, l_calendar_type_day
4456: FROM fii_time_day, dual
4457: WHERE week_id = l_week_id
4458: AND report_date > l_summ_date
4459: AND report_date <= l_as_of_date;
4460:

Line 4466: FROM fii_time_day

4462: Write2FWKLog('Creating day slice for the prior year week between the two dates - scheduled');
4463: INSERT INTO PJI_PMV_TIME_DIM_TMP
4464: (PRIOR_ID, NAME, ORDER_BY_ID, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
4465: SELECT report_date_julian, '-1', '-1', 1, l_amount_type, l_calendar_type_day
4466: FROM fii_time_day
4467: WHERE week_id = SUBSTR(LPAD(l_week_id,11,'0'),1,3)||TO_CHAR(SUBSTR(LPAD(l_week_id,11,'0'),4,4)-1)||SUBSTR(LPAD(l_week_id,11,'0'),8)
4468: AND report_date > l_prior_summ_date
4469: AND report_date <= l_prior_as_of_date;
4470: END IF;

Line 4487: FROM fii_time_day, dual

4483:
4484: INSERT INTO PJI_PMV_TIME_DIM_TMP
4485: (ID, NAME, ORDER_BY_ID, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
4486: SELECT report_date_julian, '-1', '-1', 1 , l_amount_type, l_calendar_type_day
4487: FROM fii_time_day, dual
4488: WHERE ent_period_id = l_period_id
4489: AND report_date > l_summ_date
4490: AND report_date <= l_as_of_date;
4491:

Line 4497: FROM fii_time_day

4493: Write2FWKLog('Creating day slice for the prior year period between two_dates - Enterprise Cal - scheduled');
4494: INSERT INTO PJI_PMV_TIME_DIM_TMP
4495: (PRIOR_ID, NAME, ORDER_BY_ID, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
4496: SELECT report_date_julian, '-1', '-1', 1, l_amount_type, l_calendar_type_day
4497: FROM fii_time_day
4498: WHERE ent_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)
4499: AND report_date > l_prior_summ_date
4500: AND report_date <= l_prior_as_of_date;
4501:

Line 4542: FROM fii_time_day, dual

4538:
4539: INSERT INTO PJI_PMV_TIME_DIM_TMP
4540: (ID, NAME, ORDER_BY_ID, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
4541: SELECT report_date_julian, '-1', '-1', 1 , l_amount_type, l_calendar_type_day
4542: FROM fii_time_day, dual
4543: WHERE ent_period_id = l_period_id_s
4544: AND report_date > l_summ_date;
4545:
4546: IF p_parse_prior IS NOT NULL THEN

Line 4551: FROM fii_time_day

4547: Write2FWKLog('Creating day slice for the prior year period of last_summ_date - Enterprise Cal - scheduled');
4548: INSERT INTO PJI_PMV_TIME_DIM_TMP
4549: (PRIOR_ID, NAME, ORDER_BY_ID, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
4550: SELECT report_date_julian, '-1', '-1', 1, l_amount_type, l_calendar_type_day
4551: FROM fii_time_day
4552: WHERE ent_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)
4553: AND report_date > l_prior_summ_date;
4554: END IF;
4555:

Line 4562: FROM fii_time_day, dual

4558:
4559: INSERT INTO PJI_PMV_TIME_DIM_TMP
4560: (ID, NAME, ORDER_BY_ID, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
4561: SELECT report_date_julian, '-1', '-1', 1 , l_amount_type, l_calendar_type_day
4562: FROM fii_time_day, dual
4563: WHERE ent_period_id = l_period_id
4564: AND report_date <= l_as_of_date;
4565:
4566: IF p_parse_prior IS NOT NULL THEN

Line 4571: FROM fii_time_day

4567: Write2FWKLog('Creating day slice for the prior year period of as_of_date - Enterprise Cal - scheduled');
4568: INSERT INTO PJI_PMV_TIME_DIM_TMP
4569: (PRIOR_ID, NAME, ORDER_BY_ID, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
4570: SELECT report_date_julian, '-1', '-1', 1, l_amount_type, l_calendar_type_day
4571: FROM fii_time_day
4572: WHERE ent_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)
4573: AND report_date <= l_prior_as_of_date;
4574: END IF;
4575:

Line 4876: FROM fii_time_day day

4872: , wek.end_date
4873: INTO l_Week_Id,
4874: l_Week_Name,
4875: l_End_Date
4876: FROM fii_time_day day
4877: , fii_time_week wek
4878: WHERE
4879: report_date = to_date(p_as_of_date,'j') -- As Of Date
4880: AND wek.week_id = day.week_id;

Line 4886: , l_Week_Name, l_Week_Id, 1, 'C' FROM fii_time_day

4882:
4883: INSERT INTO PJI_PMV_TIME_DIM_TMP
4884: (ID, NAME, ORDER_BY_ID, PERIOD_TYPE, CALENDAR_TYPE)
4885: SELECT report_date_julian
4886: , l_Week_Name, l_Week_Id, 1, 'C' FROM fii_time_day
4887: WHERE week_id = l_Week_Id
4888: AND report_date>=to_date(p_as_of_date,'j');
4889:
4890: INSERT INTO PJI_PMV_TIME_DIM_TMP