DBA Data[Home] [Help]

APPS.ONT_LINE_DEF_UTIL dependencies on ONT_EC_LOCATION_DEF_UTIL

Line 4164: IF ONT_EC_LOCATION_Def_Util.Sync_EC_LOCATION_Cache

4160: ELSIF (p_foreign_database_object_name = 'OE_AK_END_CUS_SITEUSE_V') THEN
4161: IF NVL(p_record.END_CUSTOMER_SITE_USE_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
4162: RETURN NULL;
4163: END IF;
4164: IF ONT_EC_LOCATION_Def_Util.Sync_EC_LOCATION_Cache
4165: (p_END_CUSTOMER_SITE_USE_ID => p_record.END_CUSTOMER_SITE_USE_ID) = 1 then
4166: RETURN ONT_EC_LOCATION_Def_Util.Get_Attr_Val_Varchar2
4167: (p_foreign_attr_code,ONT_EC_LOCATION_Def_Util.g_cached_record);
4168: END IF;

Line 4166: RETURN ONT_EC_LOCATION_Def_Util.Get_Attr_Val_Varchar2

4162: RETURN NULL;
4163: END IF;
4164: IF ONT_EC_LOCATION_Def_Util.Sync_EC_LOCATION_Cache
4165: (p_END_CUSTOMER_SITE_USE_ID => p_record.END_CUSTOMER_SITE_USE_ID) = 1 then
4166: RETURN ONT_EC_LOCATION_Def_Util.Get_Attr_Val_Varchar2
4167: (p_foreign_attr_code,ONT_EC_LOCATION_Def_Util.g_cached_record);
4168: END IF;
4169:
4170: ELSIF (p_foreign_database_object_name = 'OE_AK_IB_OWNER_V') THEN

Line 4167: (p_foreign_attr_code,ONT_EC_LOCATION_Def_Util.g_cached_record);

4163: END IF;
4164: IF ONT_EC_LOCATION_Def_Util.Sync_EC_LOCATION_Cache
4165: (p_END_CUSTOMER_SITE_USE_ID => p_record.END_CUSTOMER_SITE_USE_ID) = 1 then
4166: RETURN ONT_EC_LOCATION_Def_Util.Get_Attr_Val_Varchar2
4167: (p_foreign_attr_code,ONT_EC_LOCATION_Def_Util.g_cached_record);
4168: END IF;
4169:
4170: ELSIF (p_foreign_database_object_name = 'OE_AK_IB_OWNER_V') THEN
4171: IF NVL(p_record.IB_OWNER,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN

Line 4732: IF ONT_EC_LOCATION_Def_Util.Sync_EC_LOCATION_Cache

4728: ELSIF (p_foreign_database_object_name = 'OE_AK_END_CUS_SITEUSE_V') THEN
4729: IF NVL(p_record.END_CUSTOMER_SITE_USE_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
4730: RETURN NULL;
4731: END IF;
4732: IF ONT_EC_LOCATION_Def_Util.Sync_EC_LOCATION_Cache
4733: (p_END_CUSTOMER_SITE_USE_ID => p_record.END_CUSTOMER_SITE_USE_ID) = 1 then
4734: RETURN ONT_EC_LOCATION_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_EC_LOCATION_Def_Util.g_cached_record);
4735: END IF;
4736:

Line 4734: RETURN ONT_EC_LOCATION_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_EC_LOCATION_Def_Util.g_cached_record);

4730: RETURN NULL;
4731: END IF;
4732: IF ONT_EC_LOCATION_Def_Util.Sync_EC_LOCATION_Cache
4733: (p_END_CUSTOMER_SITE_USE_ID => p_record.END_CUSTOMER_SITE_USE_ID) = 1 then
4734: RETURN ONT_EC_LOCATION_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_EC_LOCATION_Def_Util.g_cached_record);
4735: END IF;
4736:
4737: ELSIF (p_foreign_database_object_name = 'OE_AK_IB_OWNER_V') THEN
4738: IF NVL(p_record.IB_OWNER,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN