APPS.PJI_PMV_ENGINE dependencies on PJI_PMV_ITD_DIM_TMP

Line 3063: INSERT INTO PJI_PMV_ITD_DIM_TMP

3059: Write2FWKLog('Generating records for period types other than PA Period.');
3060: END IF;
3061:
3062: IF l_IS_GL_Flag IS NOT NULL THEN
3063: INSERT INTO PJI_PMV_ITD_DIM_TMP
3064: (ID, NAME, ORDER_BY_ID, PERIOD_TYPE, COMPARATOR_TYPE, CALENDAR_TYPE)
3065: SELECT time_id, '-1' , '-1' , period_type_id, p_Comparator, calendar_type
3066: FROM fii_time_cal_rpt_struct
3067: WHERE report_date = l_As_Of_Date

Line 3071: INSERT INTO PJI_PMV_ITD_DIM_TMP

3067: WHERE report_date = l_As_Of_Date
3068: AND bitand(record_type_id,1143) = record_type_id
3069: AND calendar_id = l_Calendar_Id;
3070: ELSE
3071: INSERT INTO PJI_PMV_ITD_DIM_TMP
3072: (ID, NAME, ORDER_BY_ID, PERIOD_TYPE, COMPARATOR_TYPE, CALENDAR_TYPE)
3073: SELECT time_id, '-1' , '-1' , period_type_id, p_Comparator, calendar_type
3074: FROM fii_time_rpt_struct
3075: WHERE report_date = l_As_Of_Date

Line 3085: INSERT INTO PJI_PMV_ITD_DIM_TMP

3081: IF p_PA_DEBUG_MODE = 'Y' THEN
3082: Write2FWKLog('Generating prior id records for period types other than PA Period.');
3083: END IF;
3084: IF l_IS_GL_Flag IS NOT NULL THEN
3085: INSERT INTO PJI_PMV_ITD_DIM_TMP
3086: (PRIOR_ID, NAME, ORDER_BY_ID, PERIOD_TYPE, COMPARATOR_TYPE, CALENDAR_TYPE)
3087: SELECT time_id, '-1', '-1', period_type_id, p_Comparator, calendar_type
3088: FROM fii_time_cal_rpt_struct
3089: WHERE report_date = l_Prior_As_Of_Date

Line 3093: INSERT INTO PJI_PMV_ITD_DIM_TMP

3089: WHERE report_date = l_Prior_As_Of_Date
3090: AND bitand(record_type_id,1143) = record_type_id
3091: AND calendar_id = l_Calendar_Id;
3092: ELSE
3093: INSERT INTO PJI_PMV_ITD_DIM_TMP
3094: (PRIOR_ID, NAME, ORDER_BY_ID, PERIOD_TYPE, COMPARATOR_TYPE, CALENDAR_TYPE)
3095: SELECT time_id, '-1', '-1', period_type_id, p_Comparator, calendar_type
3096: FROM fii_time_rpt_struct
3097: WHERE report_date = l_Prior_As_Of_Date

Line 3110: INSERT INTO PJI_PMV_ITD_DIM_TMP

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

Line 3118: INSERT INTO PJI_PMV_ITD_DIM_TMP

3114: WHERE cal_period_id = l_Period_Id
3115: AND calendar_id = l_Calendar_Id
3116: AND report_date<=l_As_Of_Date;
3117:
3118: INSERT INTO PJI_PMV_ITD_DIM_TMP
3119: (ID, NAME, ORDER_BY_ID, PERIOD_TYPE, COMPARATOR_TYPE, CALENDAR_TYPE)
3120: SELECT time_id, '-1', '-1', period_type_id, p_Comparator, 'P'
3121: FROM fii_time_cal_rpt_struct
3122: WHERE report_date = l_As_Of_Date

Line 3133: INSERT INTO PJI_PMV_ITD_DIM_TMP

3129: IF p_PA_DEBUG_MODE = 'Y' THEN
3130: Write2FWKLog('Generating prior id records for PA Period period type.');
3131: END IF;
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

Line 3141: INSERT INTO PJI_PMV_ITD_DIM_TMP

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:
3141: INSERT INTO PJI_PMV_ITD_DIM_TMP
3142: (PRIOR_ID, NAME, ORDER_BY_ID, PERIOD_TYPE, COMPARATOR_TYPE, CALENDAR_TYPE)
3143: SELECT time_id, '-1', '-1', period_type_id, p_Comparator, 'P'
3144: FROM fii_time_cal_rpt_struct
3145: WHERE report_date = l_As_Of_Date

Line 3918: DELETE PJI_PMV_ITD_DIM_TMP;

3914:
3915: DELETE PJI_PMV_TIME_DIM_TMP;
3916:
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;