DBA Data[Home] [Help]

APPS.ONT_HEADER_DEF_UTIL dependencies on ONT_ORDER_CAT_DEF_UTIL

Line 2328: IF ONT_ORDER_CAT_Def_Util.Sync_ORDER_CAT_Cache

2324: ELSIF (p_foreign_database_object_name = 'OE_AK_ORDER_CATEGORY_V') THEN
2325: IF NVL(p_record.ORDER_CATEGORY_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
2326: RETURN NULL;
2327: END IF;
2328: IF ONT_ORDER_CAT_Def_Util.Sync_ORDER_CAT_Cache
2329: (p_ORDER_CATEGORY_CODE => p_record.ORDER_CATEGORY_CODE) = 1 then
2330: RETURN ONT_ORDER_CAT_Def_Util.Get_Attr_Val_Varchar2
2331: (p_foreign_attr_code,ONT_ORDER_CAT_Def_Util.g_cached_record);
2332: END IF;

Line 2330: RETURN ONT_ORDER_CAT_Def_Util.Get_Attr_Val_Varchar2

2326: RETURN NULL;
2327: END IF;
2328: IF ONT_ORDER_CAT_Def_Util.Sync_ORDER_CAT_Cache
2329: (p_ORDER_CATEGORY_CODE => p_record.ORDER_CATEGORY_CODE) = 1 then
2330: RETURN ONT_ORDER_CAT_Def_Util.Get_Attr_Val_Varchar2
2331: (p_foreign_attr_code,ONT_ORDER_CAT_Def_Util.g_cached_record);
2332: END IF;
2333:
2334: ELSIF (p_foreign_database_object_name = 'OE_AK_ORDER_CATEGORY_V') THEN

Line 2331: (p_foreign_attr_code,ONT_ORDER_CAT_Def_Util.g_cached_record);

2327: END IF;
2328: IF ONT_ORDER_CAT_Def_Util.Sync_ORDER_CAT_Cache
2329: (p_ORDER_CATEGORY_CODE => p_record.ORDER_CATEGORY_CODE) = 1 then
2330: RETURN ONT_ORDER_CAT_Def_Util.Get_Attr_Val_Varchar2
2331: (p_foreign_attr_code,ONT_ORDER_CAT_Def_Util.g_cached_record);
2332: END IF;
2333:
2334: ELSIF (p_foreign_database_object_name = 'OE_AK_ORDER_CATEGORY_V') THEN
2335: IF NVL(p_record.ORDER_CATEGORY_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN

Line 2338: IF ONT_ORDER_CAT_Def_Util.Sync_ORDER_CAT_Cache

2334: ELSIF (p_foreign_database_object_name = 'OE_AK_ORDER_CATEGORY_V') THEN
2335: IF NVL(p_record.ORDER_CATEGORY_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
2336: RETURN NULL;
2337: END IF;
2338: IF ONT_ORDER_CAT_Def_Util.Sync_ORDER_CAT_Cache
2339: (p_ORDER_CATEGORY_CODE => p_record.ORDER_CATEGORY_CODE) = 1 then
2340: RETURN ONT_ORDER_CAT_Def_Util.Get_Attr_Val_Varchar2
2341: (p_foreign_attr_code,ONT_ORDER_CAT_Def_Util.g_cached_record);
2342: END IF;

Line 2340: RETURN ONT_ORDER_CAT_Def_Util.Get_Attr_Val_Varchar2

2336: RETURN NULL;
2337: END IF;
2338: IF ONT_ORDER_CAT_Def_Util.Sync_ORDER_CAT_Cache
2339: (p_ORDER_CATEGORY_CODE => p_record.ORDER_CATEGORY_CODE) = 1 then
2340: RETURN ONT_ORDER_CAT_Def_Util.Get_Attr_Val_Varchar2
2341: (p_foreign_attr_code,ONT_ORDER_CAT_Def_Util.g_cached_record);
2342: END IF;
2343:
2344: ELSIF (p_foreign_database_object_name = 'OE_AK_PACK_INST_V') THEN

Line 2341: (p_foreign_attr_code,ONT_ORDER_CAT_Def_Util.g_cached_record);

2337: END IF;
2338: IF ONT_ORDER_CAT_Def_Util.Sync_ORDER_CAT_Cache
2339: (p_ORDER_CATEGORY_CODE => p_record.ORDER_CATEGORY_CODE) = 1 then
2340: RETURN ONT_ORDER_CAT_Def_Util.Get_Attr_Val_Varchar2
2341: (p_foreign_attr_code,ONT_ORDER_CAT_Def_Util.g_cached_record);
2342: END IF;
2343:
2344: ELSIF (p_foreign_database_object_name = 'OE_AK_PACK_INST_V') THEN
2345: IF NVL(p_record.PACKING_INSTRUCTIONS,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN

Line 2870: IF ONT_ORDER_CAT_Def_Util.Sync_ORDER_CAT_Cache

2866: ELSIF (p_foreign_database_object_name = 'OE_AK_ORDER_CATEGORY_V') THEN
2867: IF NVL(p_record.ORDER_CATEGORY_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
2868: RETURN NULL;
2869: END IF;
2870: IF ONT_ORDER_CAT_Def_Util.Sync_ORDER_CAT_Cache
2871: (p_ORDER_CATEGORY_CODE => p_record.ORDER_CATEGORY_CODE) = 1 then
2872: RETURN ONT_ORDER_CAT_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_ORDER_CAT_Def_Util.g_cached_record);
2873: END IF;
2874:

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

2868: RETURN NULL;
2869: END IF;
2870: IF ONT_ORDER_CAT_Def_Util.Sync_ORDER_CAT_Cache
2871: (p_ORDER_CATEGORY_CODE => p_record.ORDER_CATEGORY_CODE) = 1 then
2872: RETURN ONT_ORDER_CAT_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_ORDER_CAT_Def_Util.g_cached_record);
2873: END IF;
2874:
2875: ELSIF (p_foreign_database_object_name = 'OE_AK_ORDER_CATEGORY_V') THEN
2876: IF NVL(p_record.ORDER_CATEGORY_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN

Line 2879: IF ONT_ORDER_CAT_Def_Util.Sync_ORDER_CAT_Cache

2875: ELSIF (p_foreign_database_object_name = 'OE_AK_ORDER_CATEGORY_V') THEN
2876: IF NVL(p_record.ORDER_CATEGORY_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
2877: RETURN NULL;
2878: END IF;
2879: IF ONT_ORDER_CAT_Def_Util.Sync_ORDER_CAT_Cache
2880: (p_ORDER_CATEGORY_CODE => p_record.ORDER_CATEGORY_CODE) = 1 then
2881: RETURN ONT_ORDER_CAT_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_ORDER_CAT_Def_Util.g_cached_record);
2882: END IF;
2883:

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

2877: RETURN NULL;
2878: END IF;
2879: IF ONT_ORDER_CAT_Def_Util.Sync_ORDER_CAT_Cache
2880: (p_ORDER_CATEGORY_CODE => p_record.ORDER_CATEGORY_CODE) = 1 then
2881: RETURN ONT_ORDER_CAT_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_ORDER_CAT_Def_Util.g_cached_record);
2882: END IF;
2883:
2884: ELSIF (p_foreign_database_object_name = 'OE_AK_PACK_INST_V') THEN
2885: IF NVL(p_record.PACKING_INSTRUCTIONS,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN