DBA Data[Home] [Help]

APPS.ONT_LINE_DEF_UTIL dependencies on ONT_SRV_PERIOD_DEF_UTIL

Line 4134: IF ONT_SRV_PERIOD_Def_Util.Sync_SRV_PERIOD_Cache

4130: ELSIF (p_foreign_database_object_name = 'OE_AK_SRV_PERIOD_V') THEN
4131: IF NVL(p_record.SERVICE_PERIOD,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
4132: RETURN NULL;
4133: END IF;
4134: IF ONT_SRV_PERIOD_Def_Util.Sync_SRV_PERIOD_Cache
4135: (p_SERVICE_PERIOD_CODE => p_record.SERVICE_PERIOD) = 1 then
4136: RETURN ONT_SRV_PERIOD_Def_Util.Get_Attr_Val_Varchar2
4137: (p_foreign_attr_code,ONT_SRV_PERIOD_Def_Util.g_cached_record);
4138: END IF;

Line 4136: RETURN ONT_SRV_PERIOD_Def_Util.Get_Attr_Val_Varchar2

4132: RETURN NULL;
4133: END IF;
4134: IF ONT_SRV_PERIOD_Def_Util.Sync_SRV_PERIOD_Cache
4135: (p_SERVICE_PERIOD_CODE => p_record.SERVICE_PERIOD) = 1 then
4136: RETURN ONT_SRV_PERIOD_Def_Util.Get_Attr_Val_Varchar2
4137: (p_foreign_attr_code,ONT_SRV_PERIOD_Def_Util.g_cached_record);
4138: END IF;
4139:
4140: ELSIF (p_foreign_database_object_name = 'OE_AK_END_CUS_V') THEN

Line 4137: (p_foreign_attr_code,ONT_SRV_PERIOD_Def_Util.g_cached_record);

4133: END IF;
4134: IF ONT_SRV_PERIOD_Def_Util.Sync_SRV_PERIOD_Cache
4135: (p_SERVICE_PERIOD_CODE => p_record.SERVICE_PERIOD) = 1 then
4136: RETURN ONT_SRV_PERIOD_Def_Util.Get_Attr_Val_Varchar2
4137: (p_foreign_attr_code,ONT_SRV_PERIOD_Def_Util.g_cached_record);
4138: END IF;
4139:
4140: ELSIF (p_foreign_database_object_name = 'OE_AK_END_CUS_V') THEN
4141: IF NVL(p_record.END_CUSTOMER_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN

Line 4705: IF ONT_SRV_PERIOD_Def_Util.Sync_SRV_PERIOD_Cache

4701: ELSIF (p_foreign_database_object_name = 'OE_AK_SRV_PERIOD_V') THEN
4702: IF NVL(p_record.SERVICE_PERIOD,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
4703: RETURN NULL;
4704: END IF;
4705: IF ONT_SRV_PERIOD_Def_Util.Sync_SRV_PERIOD_Cache
4706: (p_SERVICE_PERIOD_CODE => p_record.SERVICE_PERIOD) = 1 then
4707: RETURN ONT_SRV_PERIOD_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_SRV_PERIOD_Def_Util.g_cached_record);
4708: END IF;
4709:

Line 4707: RETURN ONT_SRV_PERIOD_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_SRV_PERIOD_Def_Util.g_cached_record);

4703: RETURN NULL;
4704: END IF;
4705: IF ONT_SRV_PERIOD_Def_Util.Sync_SRV_PERIOD_Cache
4706: (p_SERVICE_PERIOD_CODE => p_record.SERVICE_PERIOD) = 1 then
4707: RETURN ONT_SRV_PERIOD_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_SRV_PERIOD_Def_Util.g_cached_record);
4708: END IF;
4709:
4710: ELSIF (p_foreign_database_object_name = 'OE_AK_END_CUS_V') THEN
4711: IF NVL(p_record.END_CUSTOMER_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN