DBA Data[Home] [Help]

APPS.FTE_TL_CACHE dependencies on FTE_LOCATION_PARAMETERS_PKG

Line 3898: l_fac_info_rec FTE_LOCATION_PARAMETERS_PKG.TL_FAC_INFO_REC_TYPE;

3894: PROCEDURE Get_Facility_Info(
3895: p_stop_index IN NUMBER,
3896: x_return_status OUT NOCOPY VARCHAR2) IS
3897:
3898: l_fac_info_rec FTE_LOCATION_PARAMETERS_PKG.TL_FAC_INFO_REC_TYPE;
3899: l_fac_info_tab FTE_LOCATION_PARAMETERS_PKG.TL_FAC_INFO_TAB_TYPE;
3900: l_stop_index NUMBER;
3901: i NUMBER;
3902: l_return_status VARCHAR2(1);

Line 3899: l_fac_info_tab FTE_LOCATION_PARAMETERS_PKG.TL_FAC_INFO_TAB_TYPE;

3895: p_stop_index IN NUMBER,
3896: x_return_status OUT NOCOPY VARCHAR2) IS
3897:
3898: l_fac_info_rec FTE_LOCATION_PARAMETERS_PKG.TL_FAC_INFO_REC_TYPE;
3899: l_fac_info_tab FTE_LOCATION_PARAMETERS_PKG.TL_FAC_INFO_TAB_TYPE;
3900: l_stop_index NUMBER;
3901: i NUMBER;
3902: l_return_status VARCHAR2(1);
3903: l_stop_rec TL_TRIP_STOP_INPUT_REC_TYPE;

Line 3930: FTE_LOCATION_PARAMETERS_PKG.Get_Fac_Info( l_fac_info_tab,l_return_status);

3926: i:=i+1;
3927: l_stop_index:=l_stop_index+1;
3928: END LOOP;
3929:
3930: FTE_LOCATION_PARAMETERS_PKG.Get_Fac_Info( l_fac_info_tab,l_return_status);
3931: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS
3932: THEN
3933: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING
3934: THEN