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
2446: RETURN NULL;
2447: END IF;
2448: IF ONT_PACK_INST_Def_Util.Sync_PACK_INST_Cache
2449: (p_PACKING_INSTRUCTIONS => p_record.PACKING_INSTRUCTIONS) = 1 then
2450: RETURN ONT_PACK_INST_Def_Util.Get_Attr_Val_Varchar2
2451: (p_foreign_attr_code,ONT_PACK_INST_Def_Util.g_cached_record);
2452: END IF;
2446: RETURN NULL;
2447: END IF;
2448: IF ONT_PACK_INST_Def_Util.Sync_PACK_INST_Cache
2449: (p_PACKING_INSTRUCTIONS => p_record.PACKING_INSTRUCTIONS) = 1 then
2450: RETURN ONT_PACK_INST_Def_Util.Get_Attr_Val_Varchar2
2451: (p_foreign_attr_code,ONT_PACK_INST_Def_Util.g_cached_record);
2452: END IF;
2453:
2454: ELSIF (p_foreign_database_object_name = 'OE_AK_RETURN_REASON_V') THEN
2447: END IF;
2448: IF ONT_PACK_INST_Def_Util.Sync_PACK_INST_Cache
2449: (p_PACKING_INSTRUCTIONS => p_record.PACKING_INSTRUCTIONS) = 1 then
2450: RETURN ONT_PACK_INST_Def_Util.Get_Attr_Val_Varchar2
2451: (p_foreign_attr_code,ONT_PACK_INST_Def_Util.g_cached_record);
2452: END IF;
2453:
2454: ELSIF (p_foreign_database_object_name = 'OE_AK_RETURN_REASON_V') THEN
2455: IF NVL(p_record.RETURN_REASON_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
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
2976: RETURN NULL;
2977: END IF;
2978: IF ONT_PACK_INST_Def_Util.Sync_PACK_INST_Cache
2979: (p_PACKING_INSTRUCTIONS => p_record.PACKING_INSTRUCTIONS) = 1 then
2980: RETURN ONT_PACK_INST_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_PACK_INST_Def_Util.g_cached_record);
2981: END IF;
2982:
2976: RETURN NULL;
2977: END IF;
2978: IF ONT_PACK_INST_Def_Util.Sync_PACK_INST_Cache
2979: (p_PACKING_INSTRUCTIONS => p_record.PACKING_INSTRUCTIONS) = 1 then
2980: RETURN ONT_PACK_INST_Def_Util.Get_Attr_Val_Date(p_foreign_attr_code,ONT_PACK_INST_Def_Util.g_cached_record);
2981: END IF;
2982:
2983: ELSIF (p_foreign_database_object_name = 'OE_AK_RETURN_REASON_V') THEN
2984: IF NVL(p_record.RETURN_REASON_CODE,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN