DBA Data[Home] [Help]

APPS.ONT_HEADER_DEF_UTIL dependencies on ONT_ORDER_CAT_DEF_UTIL

Line 2428: IF ONT_ORDER_CAT_Def_Util.Sync_ORDER_CAT_Cache

2424: ELSIF (p_foreign_database_object_name = 'OE_AK_ORDER_CATEGORY_V') THEN
2425: IF NVL(p_record.ORDER_CATEGORY_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
2426: RETURN NULL;
2427: END IF;
2428: IF ONT_ORDER_CAT_Def_Util.Sync_ORDER_CAT_Cache
2429: (p_ORDER_CATEGORY_CODE => p_record.ORDER_CATEGORY_CODE) = 1 then
2430: RETURN ONT_ORDER_CAT_Def_Util.Get_Attr_Val_Varchar2
2431: (p_foreign_attr_code,ONT_ORDER_CAT_Def_Util.g_cached_record);
2432: END IF;

Line 2430: RETURN ONT_ORDER_CAT_Def_Util.Get_Attr_Val_Varchar2

2426: RETURN NULL;
2427: END IF;
2428: IF ONT_ORDER_CAT_Def_Util.Sync_ORDER_CAT_Cache
2429: (p_ORDER_CATEGORY_CODE => p_record.ORDER_CATEGORY_CODE) = 1 then
2430: RETURN ONT_ORDER_CAT_Def_Util.Get_Attr_Val_Varchar2
2431: (p_foreign_attr_code,ONT_ORDER_CAT_Def_Util.g_cached_record);
2432: END IF;
2433:
2434: ELSIF (p_foreign_database_object_name = 'OE_AK_ORDER_CATEGORY_V') THEN

Line 2431: (p_foreign_attr_code,ONT_ORDER_CAT_Def_Util.g_cached_record);

2427: END IF;
2428: IF ONT_ORDER_CAT_Def_Util.Sync_ORDER_CAT_Cache
2429: (p_ORDER_CATEGORY_CODE => p_record.ORDER_CATEGORY_CODE) = 1 then
2430: RETURN ONT_ORDER_CAT_Def_Util.Get_Attr_Val_Varchar2
2431: (p_foreign_attr_code,ONT_ORDER_CAT_Def_Util.g_cached_record);
2432: END IF;
2433:
2434: ELSIF (p_foreign_database_object_name = 'OE_AK_ORDER_CATEGORY_V') THEN
2435: IF NVL(p_record.ORDER_CATEGORY_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN

Line 2438: IF ONT_ORDER_CAT_Def_Util.Sync_ORDER_CAT_Cache

2434: ELSIF (p_foreign_database_object_name = 'OE_AK_ORDER_CATEGORY_V') THEN
2435: IF NVL(p_record.ORDER_CATEGORY_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
2436: RETURN NULL;
2437: END IF;
2438: IF ONT_ORDER_CAT_Def_Util.Sync_ORDER_CAT_Cache
2439: (p_ORDER_CATEGORY_CODE => p_record.ORDER_CATEGORY_CODE) = 1 then
2440: RETURN ONT_ORDER_CAT_Def_Util.Get_Attr_Val_Varchar2
2441: (p_foreign_attr_code,ONT_ORDER_CAT_Def_Util.g_cached_record);
2442: END IF;

Line 2440: RETURN ONT_ORDER_CAT_Def_Util.Get_Attr_Val_Varchar2

2436: RETURN NULL;
2437: END IF;
2438: IF ONT_ORDER_CAT_Def_Util.Sync_ORDER_CAT_Cache
2439: (p_ORDER_CATEGORY_CODE => p_record.ORDER_CATEGORY_CODE) = 1 then
2440: RETURN ONT_ORDER_CAT_Def_Util.Get_Attr_Val_Varchar2
2441: (p_foreign_attr_code,ONT_ORDER_CAT_Def_Util.g_cached_record);
2442: END IF;
2443:
2444: ELSIF (p_foreign_database_object_name = 'OE_AK_PACK_INST_V') THEN

Line 2441: (p_foreign_attr_code,ONT_ORDER_CAT_Def_Util.g_cached_record);

2437: END IF;
2438: IF ONT_ORDER_CAT_Def_Util.Sync_ORDER_CAT_Cache
2439: (p_ORDER_CATEGORY_CODE => p_record.ORDER_CATEGORY_CODE) = 1 then
2440: RETURN ONT_ORDER_CAT_Def_Util.Get_Attr_Val_Varchar2
2441: (p_foreign_attr_code,ONT_ORDER_CAT_Def_Util.g_cached_record);
2442: END IF;
2443:
2444: ELSIF (p_foreign_database_object_name = 'OE_AK_PACK_INST_V') THEN
2445: IF NVL(p_record.PACKING_INSTRUCTIONS,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN

Line 2960: IF ONT_ORDER_CAT_Def_Util.Sync_ORDER_CAT_Cache

2956: ELSIF (p_foreign_database_object_name = 'OE_AK_ORDER_CATEGORY_V') THEN
2957: IF NVL(p_record.ORDER_CATEGORY_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
2958: RETURN NULL;
2959: END IF;
2960: IF ONT_ORDER_CAT_Def_Util.Sync_ORDER_CAT_Cache
2961: (p_ORDER_CATEGORY_CODE => p_record.ORDER_CATEGORY_CODE) = 1 then
2962: RETURN ONT_ORDER_CAT_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_ORDER_CAT_Def_Util.g_cached_record);
2963: END IF;
2964:

Line 2962: RETURN ONT_ORDER_CAT_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_ORDER_CAT_Def_Util.g_cached_record);

2958: RETURN NULL;
2959: END IF;
2960: IF ONT_ORDER_CAT_Def_Util.Sync_ORDER_CAT_Cache
2961: (p_ORDER_CATEGORY_CODE => p_record.ORDER_CATEGORY_CODE) = 1 then
2962: RETURN ONT_ORDER_CAT_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_ORDER_CAT_Def_Util.g_cached_record);
2963: END IF;
2964:
2965: ELSIF (p_foreign_database_object_name = 'OE_AK_ORDER_CATEGORY_V') THEN
2966: IF NVL(p_record.ORDER_CATEGORY_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN

Line 2969: IF ONT_ORDER_CAT_Def_Util.Sync_ORDER_CAT_Cache

2965: ELSIF (p_foreign_database_object_name = 'OE_AK_ORDER_CATEGORY_V') THEN
2966: IF NVL(p_record.ORDER_CATEGORY_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
2967: RETURN NULL;
2968: END IF;
2969: IF ONT_ORDER_CAT_Def_Util.Sync_ORDER_CAT_Cache
2970: (p_ORDER_CATEGORY_CODE => p_record.ORDER_CATEGORY_CODE) = 1 then
2971: RETURN ONT_ORDER_CAT_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_ORDER_CAT_Def_Util.g_cached_record);
2972: END IF;
2973:

Line 2971: RETURN ONT_ORDER_CAT_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_ORDER_CAT_Def_Util.g_cached_record);

2967: RETURN NULL;
2968: END IF;
2969: IF ONT_ORDER_CAT_Def_Util.Sync_ORDER_CAT_Cache
2970: (p_ORDER_CATEGORY_CODE => p_record.ORDER_CATEGORY_CODE) = 1 then
2971: RETURN ONT_ORDER_CAT_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_ORDER_CAT_Def_Util.g_cached_record);
2972: END IF;
2973:
2974: ELSIF (p_foreign_database_object_name = 'OE_AK_PACK_INST_V') THEN
2975: IF NVL(p_record.PACKING_INSTRUCTIONS,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN