DBA Data[Home] [Help]

APPS.ONT_HEADER_DEF_UTIL dependencies on ONT_EC_LOCATION_DEF_UTIL

Line 2498: IF ONT_EC_LOCATION_Def_Util.Sync_EC_LOCATION_Cache

2494: ELSIF (p_foreign_database_object_name = 'OE_AK_END_CUS_SITEUSE_V') THEN
2495: IF NVL(p_record.END_CUSTOMER_SITE_USE_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
2496: RETURN NULL;
2497: END IF;
2498: IF ONT_EC_LOCATION_Def_Util.Sync_EC_LOCATION_Cache
2499: (p_END_CUSTOMER_SITE_USE_ID => p_record.END_CUSTOMER_SITE_USE_ID) = 1 then
2500: RETURN ONT_EC_LOCATION_Def_Util.Get_Attr_Val_Varchar2
2501: (p_foreign_attr_code,ONT_EC_LOCATION_Def_Util.g_cached_record);
2502: END IF;

Line 2500: RETURN ONT_EC_LOCATION_Def_Util.Get_Attr_Val_Varchar2

2496: RETURN NULL;
2497: END IF;
2498: IF ONT_EC_LOCATION_Def_Util.Sync_EC_LOCATION_Cache
2499: (p_END_CUSTOMER_SITE_USE_ID => p_record.END_CUSTOMER_SITE_USE_ID) = 1 then
2500: RETURN ONT_EC_LOCATION_Def_Util.Get_Attr_Val_Varchar2
2501: (p_foreign_attr_code,ONT_EC_LOCATION_Def_Util.g_cached_record);
2502: END IF;
2503:
2504: ELSIF (p_foreign_database_object_name = 'OE_AK_IB_OWNER_V') THEN

Line 2501: (p_foreign_attr_code,ONT_EC_LOCATION_Def_Util.g_cached_record);

2497: END IF;
2498: IF ONT_EC_LOCATION_Def_Util.Sync_EC_LOCATION_Cache
2499: (p_END_CUSTOMER_SITE_USE_ID => p_record.END_CUSTOMER_SITE_USE_ID) = 1 then
2500: RETURN ONT_EC_LOCATION_Def_Util.Get_Attr_Val_Varchar2
2501: (p_foreign_attr_code,ONT_EC_LOCATION_Def_Util.g_cached_record);
2502: END IF;
2503:
2504: ELSIF (p_foreign_database_object_name = 'OE_AK_IB_OWNER_V') THEN
2505: IF NVL(p_record.IB_OWNER,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN

Line 3023: IF ONT_EC_LOCATION_Def_Util.Sync_EC_LOCATION_Cache

3019: ELSIF (p_foreign_database_object_name = 'OE_AK_END_CUS_SITEUSE_V') THEN
3020: IF NVL(p_record.END_CUSTOMER_SITE_USE_ID,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM THEN
3021: RETURN NULL;
3022: END IF;
3023: IF ONT_EC_LOCATION_Def_Util.Sync_EC_LOCATION_Cache
3024: (p_END_CUSTOMER_SITE_USE_ID => p_record.END_CUSTOMER_SITE_USE_ID) = 1 then
3025: RETURN ONT_EC_LOCATION_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_EC_LOCATION_Def_Util.g_cached_record);
3026: END IF;
3027:

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

3021: RETURN NULL;
3022: END IF;
3023: IF ONT_EC_LOCATION_Def_Util.Sync_EC_LOCATION_Cache
3024: (p_END_CUSTOMER_SITE_USE_ID => p_record.END_CUSTOMER_SITE_USE_ID) = 1 then
3025: RETURN ONT_EC_LOCATION_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_EC_LOCATION_Def_Util.g_cached_record);
3026: END IF;
3027:
3028: ELSIF (p_foreign_database_object_name = 'OE_AK_IB_OWNER_V') THEN
3029: IF NVL(p_record.IB_OWNER,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN