APPS.PJI_PMV_ENGINE dependencies on PJI_UTILS

Line 29: PJI_UTILS.Write2SSWALOG(p_Message, p_Level, G_Module_Name);

25: BEGIN
26: IF p_Module IS NOT NULL THEN
27: G_Module_Name:=p_Module;
28: END IF;
29: PJI_UTILS.Write2SSWALOG(p_Message, p_Level, G_Module_Name);
30: COMMIT;
31: END Write2FWKLog;
32:
33: /*

Line 3352: l_End_Time:=PJI_UTILS.GET_EXTRACTION_START_DATE;

3348: l_End_Time:=l_Year_Start_Date-1;
3349: ELSIF l_Period_Type = 'FII_TIME_ENT_YEAR' OR l_Period_Type = 'FII_TIME_CAL_YEAR' THEN
3350: l_End_Time:=TO_DATE(Convert_AS_OF_DATE(Convert_AS_OF_DATE(p_As_Of_Date, l_Period_Type, 'YEARLY'), l_Period_Type, 'YEARLY'),'j');
3351: IF l_End_Time IS NULL THEN
3352: l_End_Time:=PJI_UTILS.GET_EXTRACTION_START_DATE;
3353: END IF;
3354: ELSIF l_Prior_As_Of_Date IS NOT NULL THEN
3355: l_End_Time:=l_Prior_As_Of_Date;
3356: ELSE

Line 3359: l_End_Time:=PJI_UTILS.GET_EXTRACTION_START_DATE;

3355: l_End_Time:=l_Prior_As_Of_Date;
3356: ELSE
3357: l_End_Time:=TO_DATE(Convert_AS_OF_DATE(p_As_Of_Date, l_Period_Type, 'YEARLY'),'j');
3358: IF l_End_Time IS NULL THEN
3359: l_End_Time:=PJI_UTILS.GET_EXTRACTION_START_DATE;
3360: END IF;
3361: END IF;
3362:
3363: IF ( l_Period_Type = 'FII_TIME_WEEK' OR l_Period_Type = 'PJI_TIME_PA_PERIOD') AND l_End_Time < (l_As_Of_Date)-91 THEN

Line 4088: l_Prior_As_Of_Date:=PJI_UTILS.GET_EXTRACTION_START_DATE;

4084: l_Prior_As_Of_Date:=FII_TIME_API.ent_sd_lyr_beg(l_As_Of_Date);
4085: EXCEPTION
4086: WHEN NO_DATA_FOUND THEN
4087: Write2FWKLog('Unable to determine Prior Year, hence defaulting it...');
4088: l_Prior_As_Of_Date:=PJI_UTILS.GET_EXTRACTION_START_DATE;
4089: END;
4090: Write2FWKLog('Done with Prior Year...');
4091:
4092: Write2FWKLog('Retrieving the last summarized date value');

Line 4094: l_summ_date := trunc(to_date(PJI_UTILS.GET_PARAMETER('LAST_FM_EXTR_DATE'),'YYYY/MM/DD'));

4090: Write2FWKLog('Done with Prior Year...');
4091:
4092: Write2FWKLog('Retrieving the last summarized date value');
4093:
4094: l_summ_date := trunc(to_date(PJI_UTILS.GET_PARAMETER('LAST_FM_EXTR_DATE'),'YYYY/MM/DD'));
4095: Write2FWKLog('The last summarized date is ' || to_char(l_summ_date, 'YYYY/MM/DD'));
4096:
4097: DELETE PJI_PMV_TIME_DIM_TMP;
4098:

Line 4109: l_prior_summ_date:=PJI_UTILS.GET_EXTRACTION_START_DATE;

4105: l_prior_summ_date:=FII_TIME_API.ent_sd_lyr_beg(l_summ_date);
4106: EXCEPTION
4107: WHEN NO_DATA_FOUND THEN
4108: Write2FWKLog('Unable to determine Prior Year, hence defaulting it...');
4109: l_prior_summ_date:=PJI_UTILS.GET_EXTRACTION_START_DATE;
4110: END;
4111:
4112: Write2FWKLog('Done with Prior Year...');
4113:

Line 5278: PJI_UTILS.RESET_SSWA_SESSION_CACHE;

5274: l_Parameter_Pattern VARCHAR2(150);
5275:
5276: BEGIN
5277: IF p_PA_DEBUG_MODE = 'Y' THEN
5278: PJI_UTILS.RESET_SSWA_SESSION_CACHE;
5279: Write2FWKLog('Entering Generate_SQL...','Generate_SQL');
5280: END IF;
5281:
5282: l_PMV_Rec:=BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

Line 5573: PJI_UTILS.RESET_SSWA_SESSION_CACHE;

5569: l_Start_Char_Pos NUMBER:=0;
5570:
5571: BEGIN
5572: IF p_PA_DEBUG_MODE = 'Y' THEN
5573: PJI_UTILS.RESET_SSWA_SESSION_CACHE;
5574: Write2FWKLog('Entering Generate_SQL...','Generate_SQL');
5575: END IF;
5576:
5577: l_PMV_Rec:=BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;