APPS.PJI_PMV_DFLT_PARAMS_PVT dependencies on FII_TIME_DAY

Line 21: -- Variables for drrive any valid ID from FII_TIME_DAY table

17: -- Variable to extract ID for the sysdate from PJI_SYSTEM_SETTTINGS
18:
19: G_Period_Id_Value VARCHAR2(30);
20:
21: -- Variables for drrive any valid ID from FII_TIME_DAY table
22:
23: G_Month_ID_Value NUMBER;
24: G_Ent_Period_ID_Value NUMBER;
25: G_Ent_Quarter_ID_Value NUMBER;

Line 94: from fii_time_day

90: G_Ent_Period_ID_Value,
91: G_Ent_Quarter_ID_Value,
92: G_Ent_Year_ID_Value,
93: G_Week_ID_Value
94: from fii_time_day
95: where report_date = trunc(sysdate);
96:
97: EXCEPTION
98: WHEN NO_DATA_FOUND THEN

Line 102: 'Parametrization table contains no data. Please, check tables PJI_SYSTEM_SETTINGS and FII_TIME_DAY');

98: WHEN NO_DATA_FOUND THEN
99: -- Bug 5391217 If the call is from Discoverer ignore the exception
100: IF p_Calling_Context IS NULL THEN
101: raise_application_error(-20010,
102: 'Parametrization table contains no data. Please, check tables PJI_SYSTEM_SETTINGS and FII_TIME_DAY');
103: ELSE
104: RETURN;
105: END IF;
106: WHEN TOO_MANY_ROWS

Line 109: 'Parametrization table contains more than 1 row. Please, check tables PJI_SYSTEM_SETTINGS and FII_TIME_DAY');

105: END IF;
106: WHEN TOO_MANY_ROWS
107: THEN
108: raise_application_error(-20010,
109: 'Parametrization table contains more than 1 row. Please, check tables PJI_SYSTEM_SETTINGS and FII_TIME_DAY');
110:
111: END InitEnvironment ;
112:
113: -- ********************************************************

Line 312: fii_time_day

308: ,'QUARTER',ENT_QTR_ID
309: ,'YEAR',ENT_YEAR_ID)
310:
311: into G_Period_Id_Value from
312: fii_time_day
313: where report_date = trunc(sysdate);
314: RETURN G_Period_Id_Value;
315:
316: EXCEPTION