APPS.PJI_PMV_ENGINE dependencies on PJI_PMV_TCMP_DIM_TMP

Line 2871: INSERT INTO PJI_PMV_TCMP_DIM_TMP

2867: Write2FWKLog('Generating records for period types other than PA Period.');
2868: END IF;
2869:
2870: IF l_IS_GL_Flag IS NOT NULL THEN
2871: INSERT INTO PJI_PMV_TCMP_DIM_TMP
2872: (ID, NAME, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
2873: SELECT time_id, '-1', period_type_id, 1 , calendar_type
2874: FROM fii_time_cal_rpt_struct
2875: WHERE report_date = l_As_Of_Date

Line 2879: INSERT INTO PJI_PMV_TCMP_DIM_TMP

2875: WHERE report_date = l_As_Of_Date
2876: AND bitand(record_type_id,l_Level) = record_type_id
2877: AND calendar_id = l_Calendar_Id;
2878: ELSE
2879: INSERT INTO PJI_PMV_TCMP_DIM_TMP
2880: (ID, NAME, PERIOD_TYPE, AMOUNT_TYPE, CALENDAR_TYPE)
2881: SELECT time_id, '-1', period_type_id, 1 , calendar_type
2882: FROM fii_time_rpt_struct
2883: WHERE report_date = l_As_Of_Date

Line 2896: INSERT INTO PJI_PMV_TCMP_DIM_TMP

2892: IF p_PA_DEBUG_MODE = 'Y' THEN
2893: Write2FWKLog('Generating records for PA Period period type.');
2894: END IF;
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

Line 2915: INSERT INTO PJI_PMV_TCMP_DIM_TMP

2911: Write2FWKLog('Full Period Flag is set.');
2912: END IF;
2913: CASE l_Level
2914: WHEN 119 THEN
2915: INSERT INTO PJI_PMV_TCMP_DIM_TMP
2916: (ID, NAME, AMOUNT_TYPE, PERIOD_TYPE, CALENDAR_TYPE)
2917: VALUES (l_Year_ID, '-1', 2, 128, l_Calendar_Type_Sum);
2918: WHEN 55 THEN
2919: INSERT INTO PJI_PMV_TCMP_DIM_TMP

Line 2919: INSERT INTO PJI_PMV_TCMP_DIM_TMP

2915: INSERT INTO PJI_PMV_TCMP_DIM_TMP
2916: (ID, NAME, AMOUNT_TYPE, PERIOD_TYPE, CALENDAR_TYPE)
2917: VALUES (l_Year_ID, '-1', 2, 128, l_Calendar_Type_Sum);
2918: WHEN 55 THEN
2919: INSERT INTO PJI_PMV_TCMP_DIM_TMP
2920: (ID, NAME, AMOUNT_TYPE, PERIOD_TYPE, CALENDAR_TYPE)
2921: VALUES (l_Qtr_ID, '-1', 2, 64, l_Calendar_Type_Sum);
2922: WHEN 23 THEN
2923: INSERT INTO PJI_PMV_TCMP_DIM_TMP

Line 2923: INSERT INTO PJI_PMV_TCMP_DIM_TMP

2919: INSERT INTO PJI_PMV_TCMP_DIM_TMP
2920: (ID, NAME, AMOUNT_TYPE, PERIOD_TYPE, CALENDAR_TYPE)
2921: VALUES (l_Qtr_ID, '-1', 2, 64, l_Calendar_Type_Sum);
2922: WHEN 23 THEN
2923: INSERT INTO PJI_PMV_TCMP_DIM_TMP
2924: (ID, NAME, AMOUNT_TYPE, PERIOD_TYPE, CALENDAR_TYPE)
2925: VALUES (l_Period_ID, '-1', 2, 32, l_Calendar_Type_Sum);
2926: WHEN 11 THEN
2927: INSERT INTO PJI_PMV_TCMP_DIM_TMP

Line 2927: INSERT INTO PJI_PMV_TCMP_DIM_TMP

2923: INSERT INTO PJI_PMV_TCMP_DIM_TMP
2924: (ID, NAME, AMOUNT_TYPE, PERIOD_TYPE, CALENDAR_TYPE)
2925: VALUES (l_Period_ID, '-1', 2, 32, l_Calendar_Type_Sum);
2926: WHEN 11 THEN
2927: INSERT INTO PJI_PMV_TCMP_DIM_TMP
2928: (ID, NAME, AMOUNT_TYPE, PERIOD_TYPE, CALENDAR_TYPE)
2929: VALUES (l_Week_ID, '-1', 2, 16, 'E');
2930: END CASE;
2931:

Line 3921: DELETE PJI_PMV_TCMP_DIM_TMP;

3917: IF p_Parse_ITD IS NOT NULL THEN
3918: DELETE PJI_PMV_ITD_DIM_TMP;
3919: END IF;
3920: IF p_Report_Type = 'DBI' THEN
3921: DELETE PJI_PMV_TCMP_DIM_TMP;
3922: END IF;
3923:
3924: IF p_PA_DEBUG_MODE = 'Y' THEN
3925: Write2FWKLog('Done clearing time temporary tables...');