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;
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
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
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:
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